Query editor
with params as (selectdate_add('day', -30, current_date) as start_date,date_add('day', -1, current_date) as end_date),createdAccounts as (selectca.call_block_date as block_date,ca.account_newAccount,casewhen ca.owner = 'TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA'and ca.space = 165then 'spl_token_classic_account'when ca.owner = 'TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA'and ca.space > 165then 'spl_token_extension_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 pwhere ca.call_block_date >= p.start_dateand ca.call_block_date < p.end_dateunion allselectca.call_block_date as block_date,ca.account_newAccount,casewhen ca.owner = 'TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA'and ca.space = 165then 'spl_token_classic_account'when ca.owner = 'TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA'and ca.space > 165then 'spl_token_extension_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 cacross join params pwhere ca.call_block_date >= p.start_dateand ca.call_block_date < p.end_date)