Query editor
WITH token_properties AS (-- Get token properties like decimals from the tokens tableSELECTblockchain,contract_address,symbol,decimalsFROM tokens.erc20WHERE contract_address = 0xd2a530170D71a9Cfe1651Fb468E2B98F7Ed7456b -- AUDF token contractAND blockchain = 'ethereum'LIMIT 1),-- transaction_data AS (-- -- Fetch and aggregate transaction data-- SELECT-- DATE_TRUNC('day', evt_block_time) AS day,-- COUNT(contract_address) AS transaction_count,-- SUM(value) AS transaction_value-- FROM erc20_ethereum.evt_transfer-- WHERE-- -- evt_block_time > TRY_CAST('2025-03-01' AS TIMESTAMP)-- -- AND-- contract_address = 0x4cCe605eD955295432958d8951D0B176C10720d5 -- AUDF token contract-- GROUP BY-- DATE_TRUNC('day', evt_block_time)-- ),-- cumulative_data AS (-- -- Calculate cumulative transaction count and transaction value-- SELECT-- day,-- transaction_count,-- transaction_value,-- SUM(transaction_count) OVER (ORDER BY day) AS cumulative_transaction_count,-- SUM(transaction_value) OVER (ORDER BY day) AS cumulative_transaction_value-- FROM transaction_data-- ),-- Get date series datagenerateDates AS(SELECT * FROM UNNEST(sequence(CAST('2022-01-01' AS TIMESTAMP),CAST(NOW() AS TIMESTAMP), interval '1' day)) as t(day)),-- First mint datecalendar_1 AS (SELECT MIN(DATE_TRUNC('day', evt_block_time)) as datefrom erc20_ethereum.evt_transferwhere contract_address = 0xd2a530170D71a9Cfe1651Fb468E2B98F7Ed7456b -- AUDF token contract),burns AS (-- Get burn transactions (transfers to burn address)SELECTDATE_TRUNC('day', evt_block_time) AS day,-SUM(value) AS daily_burnsFROM erc20_ethereum.evt_transferWHERE contract_address = 0xd2a530170D71a9Cfe1651Fb468E2B98F7Ed7456b -- AUDF token contractAND to = 0x0000000000000000000000000000000000000000