Query editor
with params as (selectdate_add('day', -15, current_date) as cohort_start_date,date_add('day', -14, current_date) as cohort_end_date,date_add('day', -9, current_date) as observation_end_date),createdAccounts as(selectca.call_block_date as block_date,ca.call_block_time as block_time,date_trunc('hour', ca.call_block_time) as created_hour,ca.call_tx_index as tx_index,ca.call_block_slot as block_slot,ca.call_tx_id as tx_id,ca.account_newAccount,ca.owner as account_owner,cast(ca.space as double) as space,ceil((cast(ca.space as double) +136) / 8) * 8 as estimated_accountsdb_state_bytes,-- see https://github.com/anza-xyz/agave/blob/f78668265d5aaa3f391cd29982afb7b375a3cc11/accounts-db/src/append_vec.rs#L857-L859casewhen 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 pwhereca.call_block_date >= p.cohort_start_dateand ca.call_block_date < p.cohort_end_dateunion allselectca.call_block_date as block_date,ca.call_block_time as block_time,date_trunc('hour', ca.call_block_time) as created_hour,ca.call_tx_index as tx_index,ca.call_block_slot as block_slot,ca.call_tx_id as tx_id,ca.account_newAccount,