theericstonePosition Changes by Day
    Updated 2023-03-09
    SELECT
    date_trunc('day',lpa.block_timestamp) as date,
    --pool_address,
    --pool_name,
    --count(distinct liquidity_provider) as providers,
    sum(fee_usd) as fees_paid,
    count(distinct lpa.tx_id) as n_changes -- position changes
    FROM uniswapv3.lp_actions lpa
    join ethereum.transactions etx
    on etx.tx_id = lpa.tx_id
    WHERE lpa.block_timestamp >= getdate() - interval '14 days'
    and etx.block_timestamp >= getdate() - interval '14 days'
    GROUP BY 1
    --pool_address, pool_name
    --HAVING providers > 9
    ORDER BY 1 desc;
    Run a query to Download Data