Query editor
with params as (selectdate_add('day', -180, current_date) as start_date,date_add('day', -1, current_date) as end_date),solPriceDaily as (selectcast(date_trunc('day', minute) as date) as block_date,avg(price) as sol_price_usdfrom prices.usdcross join params pwhere blockchain = 'solana'and symbol = 'SOL'and minute >= cast(p.start_date as timestamp)and minute < cast(p.end_date as timestamp)group by 1),createAccount as (selectca.call_block_date as block_date,ca.account_newAccount,ca.owner as account_owner,ca.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-L859(cast(ca.space as double) + 128) * 6960 * pow(10, -9) as rent_required_sol,'system_createaccount' as creation_sourcefrom system_program_solana.system_program_call_createaccount cacross join params pwhere ca.call_block_date >= p.start_dateand ca.call_block_date < p.end_date),createAccountWithSeed as (selectca.call_block_date as block_date,ca.account_newAccount,ca.owner as account_owner,ca.space,ceil((cast(ca.space as double) + 136) / 8) * 8 as estimated_accountsdb_state_bytes,(cast(ca.space as double) + 128) * 6960 * pow(10, -9) as rent_required_sol,'system_createaccountwithseed' as creation_sourcefrom 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),all_create_accounts as (select * from createAccountunion allselect * from createAccountWithSeed),classified_create_accounts as (select