Query editor
WITH-- Closing price: last swap price of each dayclose_price_ranked AS (SELECTdate_trunc('day', block_time) AS day,CASEWHEN token_bought_address = 0xC02aaA39b223FE8D0A0E5C4F27eAD9083C756Cc2THEN token_sold_amount / token_bought_amountELSE token_bought_amount / token_sold_amountEND AS price,ROW_NUMBER() OVER (PARTITION BY date_trunc('day', block_time)ORDER BY block_time DESC) AS rnFROM dex.tradesWHERE blockchain = 'ethereum'AND project = 'uniswap'AND version = '2'AND project_contract_address = 0xB4e16d0168e52d35CaCD2c6185b44281Ec28C9DcAND token_bought_amount > 0AND token_sold_amount > 0),daily_close AS (SELECT day, price AS close_price_usdcFROM close_price_rankedWHERE rn = 1AND price BETWEEN 50 AND 100000),-- Daily volume and feesdaily_volume AS (SELECTdate_trunc('day', block_time) AS day,ROUND(SUM(amount_usd), 2) AS volume_usd,ROUND(SUM(amount_usd) * 0.003, 2) AS fees_usdFROM dex.tradesWHERE blockchain = 'ethereum'AND project = 'uniswap'AND version = '2'AND project_contract_address = 0xB4e16d0168e52d35CaCD2c6185b44281Ec28C9DcAND amount_usd > 0GROUP BY 1),-- End-of-day reserves from last Sync event of each daylast_sync_ranked AS (SELECTdate_trunc('day', evt_block_time) AS day,reserve0,reserve1,ROW_NUMBER() OVER (PARTITION BY date_trunc('day', evt_block_time)ORDER BY evt_block_time DESC, evt_index DESC) AS rnFROM uniswap_v2_ethereum.Pair_evt_SyncWHERE contract_address = 0xB4e16d0168e52d35CaCD2c6185b44281Ec28C9Dc),