theericstoneEthereum - USDC and DAI deposits to Uniswap
    Updated 2020-11-25
    select
    date_trunc('day',block_timestamp) as day,
    symbol,
    --contract_address,
    sum(amount_usd) as amount_sent
    FROM gold.ethereum_events
    WHERE to_label = 'uniswap' AND
    (LOWER(to_address_name) like '%usdc%' OR
    LOWER(to_address_name) like '%dai%')
    AND block_timestamp > getdate() - interval '1 month'
    AND contract_address in (
    '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48',
    '0x6b175474e89094c44da98b954eedeac495271d0f'
    )
    AND amount_usd > 0
    GROUP BY day, symbol
    ORDER BY symbol, day;

    Run a query to Download Data