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,'{{time_interval}}' AS time_interval,'{{bin_id}}' AS bin_id_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)),token_info AS (SELECTtoken_mint_address,symbol,decimalsFROM tokens_solana.fungibleWHERE token_mint_address IN (SELECT token_x_mint FROM pool_infoUNION ALLSELECT token_y_mint FROM pool_info)),-- Цены токенов из dex_solana.price_hourtoken_prices AS (SELECTcontract_address,hour,price as price_usdFROM dex_solana.price_hourWHERE contract_address IN (SELECT token_x_mint FROM pool_infoUNION ALLSELECT token_y_mint FROM pool_info)AND hour >= (SELECT start_date FROM params)AND hour < (SELECT end_date FROM params) + INTERVAL '1' day),-- Все события ликвидности с детализацией по бинамliquidity_events AS (SELECTevt_block_time as block_time,CASEWHEN (SELECT time_interval FROM params) = 'hour' THENDATE_TRUNC('hour', evt_block_time)ELSEDATE_TRUNC('day', evt_block_time)END AS time_window,lbPair as pool_address,'ADD' as action,