Query editor
withtime_seq AS (selectsequence(CAST('2025-01-01' as timestamp),date_trunc('day', cast(now() as timestamp)),interval '1' day) as time),days AS (selecttime.time as dayfrom time_seqcross join unnest(time) as time(time)),eth_fee AS (SELECTblock_minute AS day,tx_hash,redemption_fee AS fee,collateral_type,trove_idFROM query_6370412),add_price as (selectef.day,ef.tx_hash,ef.collateral_type,ef.fee,p.price AS price_usd,ef.fee * p.price AS fee_usdfrometh_fee efleft joinprices.day pon ef.day = p.timestampand p.symbol = ef.collateral_typeand p.blockchain = 'flare'),-- add_price AS (-- SELECT-- ef.day,-- ef.tx_hash,-- ef.collateral_type,-- ef.fee,-- p.price AS price_usd,-- ef.fee * p.price AS fee_usd-- FROM eth_fee ef-- JOIN sot s-- ON ef.collateral_type = s.collateral_type-- LEFT JOIN prices.day p-- ON ef.day = p.timestamp-- AND p.symbol = s.price_symbol -- <-- NEW: dynamic price lookup-- AND p.blockchain = 'flare' -- <-- or 'flare' depending on chain