nsa2000Top 10 Emitted Events of Outflowers From FTX
    Updated 2022-11-10
    --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