PapasotUniswap v3 liquidity providers stablecoins
    Updated 2023-03-26
    select
    date_trunc('day',block_timestamp) as block_day,
    action,
    count(distinct(liquidity_provider)),
    sum(amount0_usd),
    sum(amount1_usd)
    from uniswapv3.lp_actions
    where block_day >= '2021-11-13'
    and pool_name like 'USDC-USDT%'

    group by block_day,action
    order by block_day

    Run a query to Download Data