Skip to content

Instantly share code, notes, and snippets.

@araa47

araa47/BancorBq.md

Last active February 8, 2021 07:19
Show Gist options
  • Save araa47/ab0c4c4e7e7920cbd932bc030ccb4c40 to your computer and use it in GitHub Desktop.
Save araa47/ab0c4c4e7e7920cbd932bc030ccb4c40 to your computer and use it in GitHub Desktop.
Download ZIP
Bancor Data
Raw
BancorBq.md

Get All Other Contract Registry's

SELECT 
    *
FROM 
    `blockchain-etl.ethereum_bancor.ContractRegistry_event_AddressUpdate` 
WHERE 
    _contractName = '0x436f6e7472616374526567697374727900000000000000000000000000000000'

Results:

0x52ae12abe5d8bd778bd5397f99ca900624cfadd4

Get a list of BancorConverterFactory

SELECT 
    DISTINCT(contract_address)  
FROM 
    `blockchain-etl.ethereum_bancor.BancorConverterFactory_event_NewConverter`

Missing from the list:

  ['0x5ed8c09f98b2b3ed37d07414bb8c3f065bbb802b','0x005f7ed737346941acd68d0292a86f21d173538a','0x9af06fcff3f867caf949ca8d2305795fd7bb2ede','0x0040c769b501805c6ebd77e3e2c64073fe4ebd69','0x009bb5e9fcf28e5e601b7d0e9e821da6365d0a9c','0x0a8079ce1fd9b1ae682d9f1b709609a05bf9b236','0xb6cc59f55d3a68635d07269bf12ba892a73c45aa','0x87558bafcf76866d70569bf36a60d78f0d0067fb']```
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment