shadiltmp
Updated 2022-03-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
SELECT *
FROM ethereum.events_emitted
where
-- tx_id='0x8ffa4fd6a391cdb10dd2e237407ddb5a84ab9d016d88a86be6d87bb7b65b4fe2'
lower(contract_address) = lower('0xafd2aade64e6ea690173f6de59fc09f5c9190d74')
AND tx_succeeded = 'TRUE'
AND tx_to_label_subtype = 'pool'
AND event_name = 'PoolAllocation'
AND event_inputs:pool = 101
limit 1
-- SELECT *
-- FROM ethereum.dex_liquidity_pools
-- where
-- token1='0xdb55b77f5e8a1a41931684cf9e4881d24e6b6cc9'
-- 0x66f4856f1bbd1eb09e1c8d9d646f5a3a193da569
Run a query to Download Data