SELECT

*

FROM eclipse.core.fact_events_inner

WHERE instruction_PROGRAM_ID = 'RariUNM3vz1rwxPg8UJyRAN7rSKXxgd2ncS2ddCa4ZE'

AND instruction:parsed:info:destination = '25EdY4Q6ejAT5FRuK71pjvxitq88vQwcggEHbUnrEYvx'

AND block_timestamp::date >= '2025-01-01'

),

temp2 as(

SELECT

FROM eclipse.core.fact_events_inner

WHERE instruction_PROGRAM_ID = 'RariUNM3vz1rwxPg8UJyRAN7rSKXxgd2ncS2ddCa4ZE'

AND instruction:parsed:info:destination = 'AsSKqK7CkxFUf3KaoQzzr8ZLPm5fFguUtVE5QwGALQQn'

AND block_timestamp::date >= '2025-01-01'

),

all_temps AS(

SELECT temp1.*

FROM temp1

left JOIN temp2 on (temp1.tx_id = temp2.tx_id)

),

all_minters AS(

SELECT

block_timestamp, tx_id, signers[0] as minter,

FROM eclipse.core.fact_events_inner

WHERE event_type = 'mintTo'

AND INSTRUCTION:program = 'spl-token'

AND block_timestamp::date >= '2025-01-01'

AND tx_id IN (SELECT tx_id FROM all_temps)

SELECT

date_trunc('hour',block_timestamp) AS time,