Query editor
WITH joepegs AS (SELECTevt_block_time AS block_time,'joepegs' AS platform,maker AS buyer,taker AS seller,collection,tokenId,price / 1e18 AS avax,evt_tx_hash AS hashFROM joepegs_avalanche_c.JoepegExchange_evt_TakerAskUNIONSELECTevt_block_time AS block_time,'joepegs' AS platform,maker AS buyer,taker AS seller,collection,tokenId,price / 1e18 AS avax,evt_tx_hash AS hashFROM joepegs_avalanche_c.JoepegExchange_evt_TakerBid),campfire AS (SELECTevt_block_time AS block_time,'campfire' AS platform,buyer,seller,nftContractAddress AS collection,nftTokenId AS tokenId,price / 1e18 AS avax,evt_tx_hash AS hashFROM campfire_avalanche_c.CampfireMarket_evt_Sale),nftrades AS (SELECTblock_time,'nftrades' AS platform,`from` AS buyer,'0x' || SUBSTR(data, 483, 40) AS seller,'0x' || SUBSTR(data, 1451, 40) AS collection,ROUND(bytea2numeric_v2(SUBSTR(data, 1515, 40))) AS tokenId,value/1e18 AS avax,hashFROM avalanche_c.transactionsWHERE to = '0xc28f1550160478a7fb3b085f25d4b179e08e649a'AND LEFT(data,10) = '0x9e832315'AND success),kalao AS (WITH txns AS (SELECTblock_time,`from` AS buyer,