Query editor
WITH-- Get V1 TRADE events in AMM contract on ethereumv1_trade_info_on_ethereum AS (SELECTcontract_address,evt_block_time,trader,price,CAST(size AS int256) as sizeFROMsynfutures_v1_ethereum.Amm_evt_trade),-- Get V1 SETTLE events in AMM contract on ethereumv1_settle_info_on_ethereum AS (SELECTcontract_address,evt_block_time,trader,price,sizeFROMsynfutures_v1_ethereum.Amm_evt_settle),-- Get V1 CREATE NEW PAIR events in FACTORY of CHAINLINK PAIR contract on ethereumv1_chainlink_pair_info_on_ethereum AS (SELECTevt_block_time,futures,quoteFROMsynfutures_v1_ethereum.Factory_evt_newChainlinkPair),v1_uniswap_pair_info_on_ethereum AS (SELECTevt_block_time,futures,quoteFROMsynfutures_v1_ethereum.Factory_evt_newUniswapPair),v1_trade_value_on_ethereum AS (SELECTu.quote AS quote,t.evt_block_time as trade_time,(t.price / 1e18) * ABS(t.size / 1e18) AS quote_volume,p.price as priceFROM(SELECT*FROMv1_trade_info_on_ethereumUNION ALLSELECT*FROMv1_settle_info_on_ethereum) tLEFT JOIN (SELECT