rajsTokens Sold by Celsius
    Updated 2022-06-22
    SELECT
    date_trunc('day', block_timestamp) as date,
    symbol_in,
    count(*) as no_of_txs,
    sum(amount_in_usd) as sell_amt
    from ethereum.core.ez_dex_swaps
    where origin_from_address IN
    (
    SELECT
    address
    from flipside_prod_db.crosschain.address_labels
    where project_name ilike '%celsius%'
    )
    and block_timestamp >= CURRENT_DATE - interval '90 days'
    group by 1,2
    order by 3 desc
    Run a query to Download Data