degods as (

select distinct instruction :accounts[5] ::string as mint

from solana.core.fact_events

where succeeded

and block_timestamp between'2021-10-08 10:52:04.000' and '2021-10-14 08:41:42.000'

and program_id = 'cndyAnrLdpjq1Ssp1z8xxDsB8dxe7u4HL5Nxi2K5WXZ' -- Candy Machine v1

and instruction :accounts[0] in ('CPCHdAXtfEw9JsAr7Q6py6Wu39CiwX3FxwHVhNDjn13h','9mYuXCV4iC7XZqTfvn5PySamwmSrxXX4Noav6c56dENP') -- Config

and instruction :accounts[5] is not null

),

solana_burns as (

select

date_trunc('hour',block_timestamp) as date,

tx_id,

signers[0] as wallet,

mint,

regexp_replace(f.value, '^\\w* \\w*:.\\w*.\\w*:.') as tokenid,

'send' as label

from solana.core.fact_events events

inner join degods

on events.instruction :accounts[4] = degods.mint

inner join solana.core.fact_transactions txs

using(tx_id, block_timestamp, succeeded)

inner join lateral flatten (input => txs.log_messages) f

where succeeded

and program_id = '35iLrpYNNR9ygHLcvE1xKFHbHq6paHthrF6wSovdWgGu'

and f.value like 'Program log: token id: %'

and block_timestamp >= '2023-03-30 00:00:00.000'