Query editor
WITH blockchain_feeds AS (SELECT'Pyth' AS oracle,b.blockchain,b.contract_address,b.topic0,b.topic1,p.symbol,CAST(p.price_feed_id AS VARCHAR) AS price_feed_id,p.feed_type,p.sectors,REPLACE(p.asset, '/', '-') AS asset,SPLIT_PART(p.asset, '/', 1) AS token_a,SPLIT_PART(p.asset, '/', 2) AS token_bFROM dune.cryptexfinance.dataset_price_feeds_blockchains_06162025 AS bLEFT JOIN dune.cryptexfinance.dataset_pyth_price_feeds_06162025 AS pON b.topic1 = p.price_feed_id)SELECT * FROM blockchain_feeds