Query editor
with params as (selectdate_add('day', -180, current_date) as start_date,date_add('day', -1, current_date) as end_date,'{{Status Filter}}' as session_status_filter),createdAccounts as(selectca.call_block_date as block_date,ca.call_block_time as block_time,ca.call_tx_index as tx_index,ca.call_block_slot as block_slot,ca.account_newAccount,casewhen ca.owner = 'TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA'and ca.space = 165then 'spl_token_classic_account'when ca.owner = 'TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb'and ca.space = 165then 'token_2022_base_account'when ca.owner = 'TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb'and ca.space > 165then 'token_2022_extension_account'when ca.space < 165then 'small_custom_program_account'else 'custom_or_other_program_account'end as rent_account_typefrom system_program_solana.system_program_call_createaccount cacross join params pwhereca.call_block_date >= p.start_dateand ca.call_block_date < p.end_dateunion allselectca.call_block_date as block_date,ca.call_block_time as block_time,ca.call_tx_index as tx_index,ca.call_block_slot as block_slot,ca.account_newAccount,casewhen ca.owner = 'TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA'and ca.space = 165then 'spl_token_classic_account'when ca.owner = 'TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb'and ca.space = 165then 'token_2022_base_account'when ca.owner = 'TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb'and ca.space > 165then 'token_2022_extension_account'when ca.space < 165then 'small_custom_program_account'else 'custom_or_other_program_account'end as rent_account_typefrom system_program_solana.system_program_call_createaccountwithseed ca