Query editor
-- WITH-- program_compute AS (-- SELECT-- SPLIT(log, ' ') [2] AS program_id,-- TRY_CAST(SPLIT(log, ' ') [4] AS BIGINT) AS computed_units_spent,-- TRY_CAST(SPLIT(log, ' ') [6] AS BIGINT) AS computed_units_allocated,-- block_date,-- block_slot,-- block_time,-- id,-- fee-- FROM-- solana.transactions AS t-- LEFT JOIN UNNEST (log_messages) AS l (log) ON TRUE-- WHERE-- log LIKE 'Program % consumed % of % compute units'-- AND t.block_time >= CURRENT_TIMESTAMP - INTERVAL '24' hour-- ),-- block_compute AS (-- SELECT-- block_date,-- block_slot,-- COUNT(*) AS num_ixs,-- SUM(computed_units_spent) AS computed_units_spent,-- SUM(computed_units_allocated) AS computed_units_allocated,-- SUM(fee) AS fee-- FROM-- program_compute AS pc-- GROUP BY-- block_date,-- block_slot-- ),-- totals as (-- SELECT-- pc.block_date,-- pc.block_slot,-- CASE-- WHEN pi.is_anchor and not pi.has_idl THEN pc.program_id-- ELSE NULL-- END as program_id,-- CASE-- WHEN pi.is_anchor IS NULL THEN false-- ELSE pi.is_anchor-- END as is_anchor,-- CASE-- WHEN pi.has_idl IS NULL THEN false-- ELSE pi.has_idl-- END as has_idl,-- bc.fee,-- bc.num_ixs,-- bc.computed_units_spent,-- SUM(pc.computed_units_spent) compute,-- COUNT(*) AS ct-- FROM-- program_compute AS pc-- LEFT JOIN dune.solana_team.dataset_programinfo AS pi ON pi.program_id = pc.program_id-- LEFT JOIN block_compute AS bc ON pc.block_slot = bc.block_slot-- GROUP BY-- pc.block_date,-- pc.block_slot,