Query editor
WITH prices AS (SELECTtimestamp AS day,blockchain,contract_address,priceFROM prices.dayWHERE contract_address IN (0x14862c03a0caccc1ab328b062e64e31b2a1afcd7,0x306acd0c07c430abbbb2e74ef7bde94f32a898c0)AND blockchain IN ('ethereum', 'base')),burns AS (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 pON p.contract_address = t.contract_addressAND p.blockchain = t.blockchainAND p.day = date_trunc('day', t.block_time)WHERE t.contract_address IN (0x14862c03a0caccc1ab328b062e64e31b2a1afcd7, -- Ethereum0x306acd0c07c430abbbb2e74ef7bde94f32a898c0 -- Base)AND t."to" IN (0x0000000000000000000000000000000000000000,0x000000000000000000000000000000000000dEaD)AND t.blockchain IN ('ethereum', 'base')GROUP BY 1, 2),mints AS (SELECTdate_trunc('day', t.block_time) AS day,t.blockchain,SUM(t.amount) AS tokens_minted,SUM(t.amount * p.price) AS usd_minted,COUNT(*) AS mint_countFROM tokens.transfers tLEFT JOIN prices pON p.contract_address = t.contract_addressAND p.blockchain = t.blockchainAND p.day = date_trunc('day', t.block_time)WHERE t.contract_address IN (0x14862c03a0caccc1ab328b062e64e31b2a1afcd7,0x306acd0c07c430abbbb2e74ef7bde94f32a898c0)AND t."from" IN (0x0000000000000000000000000000000000000000,0x000000000000000000000000000000000000dEaD)AND t.blockchain IN ('ethereum', 'base')GROUP BY 1, 2