Query editor
-- This query has been migrated to run on DuneSQL.-- If you need to change back because you’re seeing issues, use the Query History view to restore the previous version.-- If you notice a regression, please email [email protected].WITHtoken_buys AS (SELECTSUM(amount_usd) AS volume_usd,DATE_TRUNC('hour', block_time) AS hour,'buy' AS actionFROMdex.tradesWHEREtoken_bought_address = 0xADE00C28244d5CE17D72E40330B1c318cD12B7c3AND blockchain ='ethereum'GROUP BY2),token_sells AS (SELECTSUM(amount_usd) AS volume_usd,DATE_TRUNC('hour', block_time) AS hour,'sell' AS actionFROMdex.tradesWHEREtoken_sold_address = 0xADE00C28244d5CE17D72E40330B1c318cD12B7c3AND blockchain = 'ethereum'GROUP BY2),daily_prices AS (SELECTmedian_price AS price,hourFROMdex.pricesWHEREcontract_address = 0xADE00C28244d5CE17D72E40330B1c318cD12B7c3)SELECTa.volume_usd AS buys,a.hour AS hour,b.volume_usd AS sells,c.price AS priceFROMtoken_buys AS aLEFT JOIN token_sells AS b ON a.hour = b.hourLEFT JOIN daily_prices AS c ON a.hour = c.hourWHEREa.hour > NOW() - INTERVAL '30' day