strawbettyUntitled Query
    Updated 2022-07-09
    with tab1 as (
    SELECT
    SUM(amount_usd) as polygon_fee,
    date_trunc('day', block_timestamp) as day
    FROM polygon.udm_events
    WHERE to_label like 'opensea'
    and day>= '2022-07-01'
    GROUP by 2
    ), tab2 as (
    SELECT
    SUM(amount_usd) as ethereum_fee,
    date_trunc('day', block_timestamp) as day
    FROM ethereum.udm_events
    WHERE to_address LIKE '0x7be8076f4ea4a4ad08075c2508e481d6c946d12b'
    and day>= '2022-07-01'
    GROUP by 2
    )

    SELECT *
    FROM tab2 join tab1 on tab2.td = tab1.td

    Run a query to Download Data