Query editor
WITH supply AS (SELECTDATE_TRUNC('minute', c.block_time) AS day,SUM(TRY_CAST(CAST(value AS DOUBLE) AS DOUBLE)) AS daily_supply,SUM(SUM(TRY_CAST(CAST(value AS DOUBLE) AS DOUBLE))) OVER (ORDER BY DATE_TRUNC('minute', c.block_time)) AS TOTALFROM (SELECTblock_time,TRY_CAST(CAST(b.value AS DOUBLE) AS DOUBLE) / 1e18 AS valueFROM erc20_base.evt_transfer AS bINNER JOIN base.transactions AS tx ON tx.hash = b.evt_tx_hashWHERE contract_address = 0x4e99472385a2522aa292b008Da294a78F420A367 /* TCAP */AND b."from" = 0x0000000000000000000000000000000000000000UNION ALLSELECTblock_time,-TRY_CAST(CAST(d.value AS DOUBLE) AS DOUBLE) / 1e18 AS valueFROM erc20_base.evt_Transfer AS dINNER JOIN base.transactions AS tx ON tx.hash = d.evt_tx_hashWHERE contract_address = 0x4e99472385a2522aa292b008Da294a78F420A367 /* TCAP */AND d."to" = 0x0000000000000000000000000000000000000000) AS cGROUP BY DATE_TRUNC('minute', c.block_time)ORDER BY DATE_TRUNC('minute', c.block_time) DESC),oracle_price AS (SELECTl.contract_address,'AnswerUpdated' AS event_name,l.block_time,l.block_number,l.tx_hash,l.topic0 AS event_signature,bytearray_to_uint256(bytearray_substring(l.topic1, 1, 32)) AS current,bytearray_to_uint256(bytearray_substring(l.topic2, 1, 32)) AS roundId,bytearray_to_uint256(bytearray_substring(l.data, 1, 32)) AS updatedAtFROM base.logs lWHERE l.topic0 = 0x0559884fd3a460db3073b7fc896cc77986f16e378210ded43186175bf646fc5fAND l.contract_address = 0x6f9829A2278A5b017b6e997E2BafCDbCb8d6Bc04),oracle_price_usd AS (SELECTDATE_TRUNC('minute', block_time) AS day,AVG(current / 1e18) AS TCAP_priceFROM oracle_priceGROUP BY DATE_TRUNC('minute', block_time))SELECTs.day,AVG(s.TOTAL) AS avg_total_supplyFROM supply sLEFT JOIN oracle_price_usd oON s.day = o.dayWHERE s.day >= DATE '2025-01-27'GROUP BY s.dayORDER BY s.day DESC