Query editor
with params as (selectdate_add('day', -30, current_date) as start_date,date_add('day', -1, current_date) as end_date),solPrice as (selecttimestamp as block_date,price as sol_price_usdfrom prices.minutecross join params pwhere blockchain = 'solana'and symbol = 'SOL'and contract_address = from_base58('So11111111111111111111111111111111111111112')and timestamp >= cast(p.start_date as timestamp)and timestamp < cast(p.end_date as timestamp)),tempo_createAddress as(select distinctct.tx_hash,ct.address as created_address,ct.block_time,ct.code,ct.addressfrom tempo.creation_traces ctcross join params pwhere ct.block_time >= p.start_dateand ct.block_time < p.end_date),tempo_tx_list as(selectt.hash,t.gas_pricefrom tempo.transactions tcross join params pwhere t.block_time >= p.start_dateand t.block_time < p.end_date),tempo_trace_list as(selectt.tx_hash,t.gas_used,t.code,t.addressfrom tempo.traces tcross join params pwhere t.block_time >= p.start_dateand t.block_time < p.end_date),tempo_account_cost as(select