forgashuni v3 data exploration
Updated 2022-08-15Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- select platform, count(1) from ethereum.core.dim_dex_liquidity_pools
-- where platform in ('uniswap-v2', 'sushiswap')
-- limit 100
-- select
-- block_number,
-- tx_hash,
-- block_timestamp,
-- tx_json:receipt:logs
-- *
-- from ethereum.core.fact_transactions where tx_hash = '0x776673e67ebd2f65e17371aecabc39b18979d40d5778c60afae1cf21153f66ff'
-- dai to weth
-- 0x32844e66c41bf08a8c3d249d1dd53a404831bc486e094342dc4b79ae9c7aa8d3
-- eth to dai
-- 0x20db61bcf3940f091541c8d186fc42d81591b971871be6d8a3f980a54b730791
-- bal to eth
-- 0x776673e67ebd2f65e17371aecabc39b18979d40d5778c60afae1cf21153f66ff
-- fort to usdc
-- 0x85139e7479b63f846ccf58784fbdee931733ffe53e3e52744948a5ab521d9977
-- select * from ethereum.core.fact_event_logs
-- where event_name = 'Swap'
-- -- and contract_name is not null
-- and tx_hash in ('0x776673e67ebd2f65e17371aecabc39b18979d40d5778c60afae1cf21153f66ff',
-- '0x32844e66c41bf08a8c3d249d1dd53a404831bc486e094342dc4b79ae9c7aa8d3',
-- '0x20db61bcf3940f091541c8d186fc42d81591b971871be6d8a3f980a54b730791',
-- '0x85139e7479b63f846ccf58784fbdee931733ffe53e3e52744948a5ab521d9977'
-- )
-- order by event_index
-- limit 10
select c.address_name as address, count(1)
from ethereum.core.fact_event_logs l
Run a query to Download Data