mehrancrypto-dxoepqUntitled Query
    Updated 2022-11-08
    with tab_lable as
    (
    SELECT ADDRESS
    from ethereum.core.dim_labels
    where (ADDRESS_NAME ilike '%Alameda%' or label ilike '%Alameda%')
    )
    SELECT block_timestamp::date as daily , symbol , sum(amount_usd) as in_volume
    FROM ethereum.core.ez_token_transfers A , tab_lable B
    WHERE to_address = B.ADDRESS
    AND symbol in ('USDT', 'USDC', 'DAI', 'TUSD', 'BUSD')
    AND block_timestamp > CURRENT_DATE - 60
    GROUP by 1 , 2
    Run a query to Download Data