KingTigerMafia-7mwRZbUntitled Query
    -- part 1
    with deposit as (
    select block_timestamp::date as date, count(tx_hash) as num_tx, count(distinct origin_from_address) as num_users, sum(lp_token_amount_usd) as lp_amount
    from optimism.velodrome.ez_lp_actions
    where lp_action = 'deposit'
    group by 1
    order by 1 asc
    ), withdraw as (
    select block_timestamp::date as date, count(tx_hash) as num_tx, count(distinct origin_to_address) as num_users, sum(lp_token_amount_usd) as lp_amount
    from optimism.velodrome.ez_lp_actions
    where lp_action = 'withdraw'
    group by 1
    order by 1 asc
    )

    SELECT d.date as date, sum(d.num_tx) as num_deposit, sum(d.num_users) as deposit_user, sum(w.num_tx) as num_withdraw, sum(w.num_users) as withdraw_user, sum(d.lp_amount) as deposit_amount, sum(w.lp_amount) as withdraw_amount
    from deposit d join withdraw w on d.date = w.date
    group by 1
    order by 1 asc

    -- part 2
    select pool_name, count(tx_hash) as num_tx
    from optimism.velodrome.ez_lp_actions
    group by 1
    order by 2 DESC
    limit 10

    -- part 3
    select pool_type, count(tx_hash) as num_tx
    from optimism.velodrome.ez_lp_actions
    group by 1
    order by 2 DESC
    limit 10

    -- part 4
    select block_timestamp::date as date, sum(claimed_amount_usd)
    Run a query to Download Data