roketop12
Updated 2022-12-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
--creator :: https://app.flipsidecrypto.com/velocity/queries/9bbf8dee-fb21-485a-889f-811462d69322
select
substring(INPUT_DATA, 202, 1) as chain_id,
symbol,
count(DISTINCT tx_hash) as tx_cnt,
count(DISTINCT from_address) as user_cnt,
sum(amount_usd) as volume
from ethereum.core.fact_transactions join ethereum.core.ez_token_transfers USING(tx_hash)
where to_address in (lower('0x3ee18b2214aff97000d974cf647e7c347e8fa585'))
and origin_function_signature in ( '0x0f5287b0','0x9981509f')
and chain_id = '1'
and block_timestamp >= '2022-10-01'
and symbol is not null
group by 1,2
order by 3 desc
limit 10
Run a query to Download Data