0xaimanUntitled Query
Updated 2022-09-12
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
with a as (select tx_hash from ethereum.core.fact_event_logs
where tx_hash = '0xb5b1cc3484045000fbb1aeb508082642a013b0b684bd7c3f30ce20ff1a97df98' and
origin_to_address = '0x8731d54e9d02c286767d56ac03e8037c07e01e98'
group by 1)
select b.* , case when to_address = '0xdf0770df86a8034b3efef0a1bb3c889b8332ff56' then 'usdc' end as symbol, raw_amount/10e17 as vol_usdc
from ethereum.core.fact_token_transfers b
inner join a on b.tx_hash=a.tx_hash
limit 10
Run a query to Download Data