Query editor
WITH printr_created AS (SELECT DISTINCT base_mint AS tokenFROM meteora_solana.dynamic_bonding_curve_evt_evtinitializepoolWHERE evt_executing_account = 'dbcij3LWUppWqq96dh6gJWwBifmcGfLSB5D4DuSMaqN'AND evt_outer_executing_account = 'T8HsGYv7sMk3kTnyaRqZrbRPuntYzdh12evXBkprint'AND evt_block_time >= CURRENT_DATE - INTERVAL '60' DAY),printr_graduated AS (SELECTm.account_base_mint AS token,DATE(MIN(m.call_block_time)) AS graduated_dayFROM meteora_solana.dynamic_bonding_curve_call_migration_damm_v2 mJOIN printr_created c ON m.account_base_mint = c.tokenGROUP BY 1),printr_bc_hits AS (SELECTt.block_date AS day,t.tx_id,COALESCE(CAST(t.outer_instruction_index AS VARCHAR), '0') AS outer_ix,COALESCE(CAST(t.inner_instruction_index AS VARCHAR), '0') AS inner_ix,CAST(t.amount_usd AS DOUBLE) AS amount_usdFROM dex_solana.trades tJOIN printr_created c ON t.token_bought_mint_address = c.tokenLEFT JOIN printr_graduated g ON t.token_bought_mint_address = g.tokenWHERE t.block_time >= CURRENT_DATE - INTERVAL '60' DAYAND DATE(t.block_time) < CURRENT_DATEAND (g.graduated_day IS NULL OR CAST(t.block_date AS DATE) < g.graduated_day)UNION ALLSELECTt.block_date AS day,t.tx_id,COALESCE(CAST(t.outer_instruction_index AS VARCHAR), '0') AS outer_ix,COALESCE(CAST(t.inner_instruction_index AS VARCHAR), '0') AS inner_ix,CAST(t.amount_usd AS DOUBLE) AS amount_usdFROM dex_solana.trades tJOIN printr_created c ON t.token_sold_mint_address = c.tokenLEFT JOIN printr_graduated g ON t.token_sold_mint_address = g.tokenWHERE t.block_time >= CURRENT_DATE - INTERVAL '60' DAYAND DATE(t.block_time) < CURRENT_DATEAND (g.graduated_day IS NULL OR CAST(t.block_date AS DATE) < g.graduated_day)),printr_dex_hits AS (SELECTt.block_date AS day,t.tx_id,COALESCE(CAST(t.outer_instruction_index AS VARCHAR), '0') AS outer_ix,COALESCE(CAST(t.inner_instruction_index AS VARCHAR), '0') AS inner_ix,CAST(t.amount_usd AS DOUBLE) AS amount_usdFROM dex_solana.trades tJOIN printr_graduated g ON t.token_bought_mint_address = g.tokenAND CAST(t.block_date AS DATE) >= g.graduated_dayWHERE t.block_time >= CURRENT_DATE - INTERVAL '60' DAYAND DATE(t.block_time) < CURRENT_DATEUNION ALLSELECTt.block_date AS day,t.tx_id,COALESCE(CAST(t.outer_instruction_index AS VARCHAR), '0') AS outer_ix,COALESCE(CAST(t.inner_instruction_index AS VARCHAR), '0') AS inner_ix,