SocioCryptoeth vs polygon
    Updated 2022-08-21
    SELECT 'polygon' as label,
    date_trunc('{{Interval}}',block_timestamp) as date,
    count(DISTINCT tx_hash) as n_swaps,
    sum(amount_in_usd) as amnt_usd,
    count(DISTINCT origin_from_address) as n_swappers
    FROM polygon.sushi.ez_swaps
    GROUP BY date
    UNION
    SELECT 'ethereum' as label,
    date_trunc('{{Interval}}', block_timestamp) as date,
    COUNT (DISTINCT tx_hash) as n_swaps,
    sum(amount_in_usd) as amnt_usd,
    count(DISTINCT origin_from_address) as n_swappers
    FROM ethereum.core.ez_dex_swaps
    WHERE platform like 'sushiswap'
    GROUP BY date

    Run a query to Download Data