mmdrezaWeekly Swaps
    Updated 2023-05-27
    with wallet_type as (
    select
    payer,
    proposer,
    case
    when payer ='0x55ad22f01ef568a1' then 'Blocto wallet'
    when payer ='0x18eb4ee6b3c026d2' then 'Dapper wallet'
    when payer ='0xecfad18ba9582d4f' then 'JoyRide wallet'
    when payer = '0x39e42c67cc851cfb' then 'lilico wallet'
    when payer = '0x8234007b36f8113c' then 'Monsoon wallet'
    when payer = '0x4bbff461fa8f6192' then 'Fantastec wallet'
    when payer= '0x1b65c33d7a352c61' then 'Cricket Moments wallet'
    end as wallet
    from flow.core.fact_transactions t
    join flow.core.fact_events e on t.tx_id = e.tx_id
    where event_type = 'TokensWithdrawn'
    and t.block_timestamp >= '2023-01-01'
    and t.TX_SUCCEEDED ilike 'true'
    and wallet is not null)

    select
    date_trunc('week',block_timestamp) as date,
    wallet,
    count (distinct tx_id) as tx_count,
    count (distinct Trader) as swappers_count
    from flow.core.ez_swaps t
    join wallet_type w on t.trader = w.proposer
    where t.block_timestamp >= '2023-01-01'
    group by 1,2
    order by 2 desc


    Run a query to Download Data