nsa2000Top 10 Emitted Events of Outflowers From FTX
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
›
⌄
--credit to alik110
with alamedaftx as (
select *
from ethereum.core.dim_labels
where label ilike 'ftx%' or address_name ilike 'ftx%'),
maintable as (
select block_timestamp,
to_address
from ethereum.core.ez_token_transfers
where from_address in (select distinct address from alamedaftx)
and to_address not in (select distinct address from alamedaftx)
--and to_address not in (select address from ethereum.core.dim_labels where label_type ilike 'cex')
and block_timestamp >= '2022-11-07')
select event_name,
count (distinct tx_hash) as TX_Count,
count (distinct origin_from_address) as Users_Count
from ethereum.core.fact_event_logs t1
join maintable t3 on t1.origin_from_address = t3.to_address and t1.block_timestamp > t3.block_timestamp
where tx_status = 'SUCCESS'
and event_name is not null
group by 1
order by 2 DESC
limit 10
Run a query to Download Data