misaghlbRocketPool: User Profile - LIDO vs. RocketPool - mints
    Updated 2022-04-23
    with seth as (
    SELECT
    date(block_timestamp) as date,
    sum(event_inputs:amount::float/1e18) as total,
    count(DISTINCT tx_hash) as tx_count,
    count(DISTINCT event_inputs:sender) as wallets_count,
    avg(event_inputs:amount::float/1e18) as avg_deposited,
    'stETH' as type
    from ethereum_core.fact_event_logs

    where date(block_timestamp) BETWEEN CURRENT_DATE - 90 and CURRENT_DATE - 2
    -- and tx_hash = '0xb4c976e97d20c44e3478c76b92501d81d1827073028f70b3d01921d55822a8f6' -- sample depost
    and contract_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84' -- stETH
    and event_name = 'Submitted'
    GROUP by date
    ),
    reth as (
    SELECT
    date(block_timestamp) as date,
    sum(event_inputs:amount::float/1e18) as total,
    count(DISTINCT tx_hash) as tx_count,
    count(DISTINCT event_inputs:to) as wallets_count,
    avg(event_inputs:amount::float/1e18) as avg_deposited,
    'rETH' as type
    from ethereum_core.fact_event_logs

    where date(block_timestamp) BETWEEN CURRENT_DATE - 90 and CURRENT_DATE - 2
    -- and tx_hash = '0xc9695d83d2254b3247736deeb7a48abe36fad26a73d9b194df7dd1ba87131d16' -- sample depost
    and contract_address = '0xae78736cd615f374d3085123a210448e74fc6393' -- rETH
    and event_name = 'TokensMinted'
    GROUP by date
    )

    SELECT * from seth
    UNION
    SELECT * from reth

    Run a query to Download Data