binhachonCelsius Swaps - #1
    Updated 2022-06-20
    with celsius_wallets as (
    select
    *
    from flipside_prod_db.crosschain.address_labels
    where address_name ilike '%celsius%'
    ),
    swap_activity as (
    select
    *
    from flipside_prod_db.crosschain.ez_swaps
    where origin_from_address in (select address from celsius_wallets)
    )
    select
    date_trunc('month', block_timestamp) as time,
    platform,
    count(*) as number_of_swaps
    from swap_activity
    group by 1, 2
    Run a query to Download Data