Query editor
WITH prices AS (SELECTdate_trunc('day', timestamp) AS day,blockchain,contract_address,price,volumeFROM (SELECTtimestamp,blockchain,contract_address,price,volume,ROW_NUMBER() OVER (PARTITION BY date_trunc('day', timestamp), blockchain, contract_addressORDER BY volume DESC NULLS LAST) AS rnFROM prices.dayWHERE contract_address IN (0x14862c03a0caccc1ab328b062e64e31b2a1afcd7,0x306acd0c07c430abbbb2e74ef7bde94f32a898c0)AND blockchain IN ('ethereum', 'base'))WHERE rn = 1),prices_final AS (SELECT day, priceFROM (SELECTday,price,volume,ROW_NUMBER() OVER (PARTITION BY dayORDER BY volume DESC NULLS LAST) AS rnFROM prices)WHERE rn = 1)SELECTdate_trunc('day', t.block_time) AS day,t.blockchain,SUM(t.amount) AS tokens_burned,SUM(t.amount * p.price) AS usd_burned,COUNT(*) AS burn_countFROM tokens.transfers tLEFT JOIN prices_final pON p.day = date_trunc('day', t.block_time)WHERE t.contract_address IN (0x14862c03a0caccc1ab328b062e64e31b2a1afcd7,0x306acd0c07c430abbbb2e74ef7bde94f32a898c0)AND t."to" IN (0x0000000000000000000000000000000000000000,0x000000000000000000000000000000000000dEaD