flipside

    Supply/Demand of Sushi
    nitsSupply/Demand of Sushi
    Updated 2022-05-26
    SELECT date(block_timestamp) as day, tx_type, sum(amount_usd) as total_amt
    from
    (SELECT * , case when from_label_type = 'cex' then 'from cex' else 'to cex' end as tx_type
    from ethereum.udm_events
    where contract_address = '0x6b3595068778dd592e39a122f4f5a5cf09c90fe2' and( to_label_type = 'cex' or from_label_type = 'cex') and block_timestamp >= '2022-05-07' and block_timestamp< '2022-05-15' )
    GROUP by 1,2
    -- limit 10
    Run a query to Download Data