Query editor
WITH params AS (SELECT'{{pool_address}}' AS pool_address,CAST('{{start_date}}' AS timestamp) AS start_date,CAST('{{end_date}}' AS timestamp) AS end_date,'{{bin_status}}' AS bin_status_filter,COALESCE(CAST('{{insider_usd_threshold}}' AS DOUBLE), 1000.0) AS insider_usd_threshold,COALESCE(CAST('{{price_range_width}}' AS INTEGER), 50) AS price_range_width,'{{action}}' AS action_filter),pool_info AS (SELECTlbPair AS pool_address,binStep,tokenX AS token_x_mint,tokenY AS token_y_mintFROM meteora_solana.lb_clmm_evt_lbpaircreateWHERE lbPair = (SELECT pool_address FROM params)),daily_active_bins AS (SELECTDATE_TRUNC('day', evt_block_time) AS day,activeBinId AS active_binFROM (SELECTevt_block_time,activeBinId,ROW_NUMBER() OVER (PARTITION BY DATE_TRUNC('day', evt_block_time) ORDER BY evt_block_time DESC) as rnFROM (SELECT evt_block_time, activeBinIdFROM meteora_solana.lb_clmm_evt_addliquidityWHERE lbPair = (SELECT pool_address FROM params)AND evt_block_time >= (SELECT start_date FROM params)AND evt_block_time < (SELECT end_date FROM params)UNION ALLSELECT evt_block_time, activeBinIdFROM meteora_solana.lb_clmm_evt_removeliquidityWHERE lbPair = (SELECT pool_address FROM params)AND evt_block_time >= (SELECT start_date FROM params)AND evt_block_time < (SELECT end_date FROM params)) all_events) rankedWHERE rn = 1),token_prices AS (SELECTDATE_TRUNC('day', hour) AS day,contract_address,AVG(price) AS price_usd,MAX(symbol) AS symbol,MAX(decimals) AS decimalsFROM dex_solana.price_hourWHERE contract_address IN (SELECT token_x_mint FROM pool_infoUNION ALL