Query editor
with periods as (select period FROM UNNEST(sequence(TIMESTAMP '2024-10-24', cast(current_time as TIMESTAMP), interval '1' hour)) AS t(period)),supply as (selectdate_trunc('hour', block_time) as period,-- token_mint_address as token_contract,SUM(CASEWHEN action = 'mint' THEN amount / 1e9WHEN action = 'burn' THEN -amount / 1e9ELSE 0END) AS amountFROM tokens_solana.transfersWHERE token_mint_address = 'FRAGSEthVFL7fdqM8hxfxkfCZzUvmg21cqPJVvC1qdbo'AND (action = 'mint' or action = 'burn')-- AND block_time >= date('2024-10-23')GROUP BY 1),period_supply as (selectperiod,COALESCE(amount, 0) as amount,sum(COALESCE(amount, 0)) over(order by period asc) as total_amountfrom periodsleft join supply using(period)order by period desc)select*fromperiod_supplyWHERE period >= date('2024-10-24')order by period desc