Query editor
WITH parameters AS (SELECT'2qEHjDLDLbuBgRYvsxhc5D6uDWAivNFZGan56P1tpump' AS target_token,CAST('2024-11-01' AS DATE) AS target_date),-- ============================================-- Активные пулы на целевую дату (из dex_solana.trades)-- ============================================active_pools_on_date AS (SELECT DISTINCTt.project_program_id AS pool_address,t.project AS dex,t.version_name AS pool_typeFROM dex_solana.trades tCROSS JOIN parametersWHERE t.block_date = (SELECT target_date FROM parameters)AND (t.token_bought_mint_address = (SELECT target_token FROM parameters)OR t.token_sold_mint_address = (SELECT target_token FROM parameters))),-- ============================================-- Meteora DLMM пулы-- ============================================meteora_dlmm_pools AS (SELECTcall_block_time AS created_at,call_tx_id AS creation_tx,call_tx_signer AS creator_signer,'Meteora' AS dex,'DLMM' AS pool_type,account_lbPair AS pool_address,account_tokenMintX AS token_a,account_tokenMintY AS token_b,account_reserveX AS vault_a,account_reserveY AS vault_b,account_oracle AS oracle,account_funder AS funder,binStep AS bin_step,activeId AS active_idFROM meteora_solana.lb_clmm_call_initializelbpairCROSS JOIN parametersWHERE (account_tokenMintX = (SELECT target_token FROM parameters)OR account_tokenMintY = (SELECT target_token FROM parameters))),-- ============================================-- Meteora CPMM пулы-- ============================================meteora_cpmm_pools AS (SELECTcall_block_time AS created_at,call_tx_id AS creation_tx,call_tx_signer AS creator_signer,'Meteora' AS dex,'CPMM' AS pool_type,account_pool AS pool_address,account_token_a_mint AS token_a,account_token_b_mint AS token_b,account_token_a_vault AS vault_a,