flipside

    4. CEL token flows 1
    MoDeFi4. CEL token flows 1
    Updated 2022-09-09
    with celsius_addresses as
    (select ADDRESS
    from flipside_prod_db.crosschain.address_labels
    where ADDRESS_NAME ilike '%Celsius%' and BLOCKCHAIN='ethereum')


    select *,
    row_number() over (order by swap_from desc) as rank
    from
    (select origin_from_address , sum(AMOUNT_IN) as swap_from
    from ethereum.core.ez_dex_swaps
    where TOKEN_IN='0xaaaebe6fe48e54f431b0c390cfaf0b017d09d42d'
    group by origin_from_address
    order by swap_from desc
    limit 20)
    Run a query to Download Data