vegardTop 10 Asset inflow
Updated 2022-11-10
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
›
⌄
with ftx_labels as (
select label, address
from ethereum.core.dim_labels
where (
label like any ('ftx%') or
address_name like any ('ftx%')
)
),
ftx_addresses as (
select distinct(address) as ftx_address from ftx_labels
),
inflow as (
select
symbol,
count(distinct(tx_hash)) as txn_num_inflow,
sum (amount_usd) as amount_usd_inflow
from ethereum.core.ez_token_transfers
where exists (select * from ftx_addresses where to_address = ftx_address)
and not exists (select * from ftx_addresses where from_address = ftx_address)
and amount_usd > 0
and block_timestamp >= '2022-11-06'
group by 1
)
select * from inflow
order by amount_usd_inflow desc
limit 10
Run a query to Download Data