Query editor
withpriority_fees as (SELECTbytearray_to_bigint(bytearray_reverse(bytearray_substring(data, 2, 8)))/1e9 as priority_fee, *FROM solana.instruction_callsWHERE executing_account = 'ComputeBudget111111111111111111111111111111'and bytearray_substring(data,1,1) = 0x03and block_time > now() - interval '{{hours}}' hour-- AND tx_id = 'u2V4YynJsktLbcj8rSo7Aih66HU59h4eEAY9LJmMjti3jaZBcMCVSJkYdkSxhekN8Dn5qKmeX979FXzvdMmpkgE'-- and block_slot = 229394527), minutes as (with time_seq as (SELECTsequence(date_trunc('minute', cast((now() - interval '{{hours}}' hour) as timestamp)), date_trunc('minute', cast(now() as timestamp)), interval '1' minute) as time)SELECTtimes.timeFROM time_seqLEFT JOIN unnest(time) as times(time) on true --this is just doing explode like in spark sql), minutes_pri as (SELECTdate_trunc('minute',tx.block_time) as minute, avg(pf.priority_fee) as avg_priority_fee, max(pf.priority_fee) as max_priority_feeFROM solana.transactions txJOIN priority_fees pf ON pf.tx_id = tx.id AND pf.block_slot = tx.block_slotWHERE contains(tx.account_keys, '{{address}}')and tx.block_time > now() - interval '{{hours}}' hourgroup by 1)SELECTm.time, COALESCE(pri.avg_priority_fee,0) as avg_priority_fee, COALESCE(pri.max_priority_fee,0) as max_priority_feeFROM minutes mLEFT JOIN minutes_pri pri ON pri.minute = m.time