Query editor
WITHuitrades AS (SELECT contract_address, evt_tx_hash, evt_index, DATE_TRUNC('day', evt_block_time) AS day_, evt_block_time, evt_block_number, account, collateral,CAST(JSON_EXTRACT("order", '$.maker') AS BIGINT) AS newMaker,CAST(JSON_EXTRACT("order", '$.long') AS BIGINT) AS newLong,CAST(JSON_EXTRACT("order", '$.short') AS BIGINT) AS newShort,CAST(JSON_EXTRACT("order", '$.net') AS BIGINT) AS net,CAST(JSON_EXTRACT("order", '$.skew') AS BIGINT) AS skew,CAST(JSON_EXTRACT("order", '$.impact') AS BIGINT) AS impact,CAST(JSON_EXTRACT("order", '$.utilization') AS BIGINT) AS utilization,CAST(JSON_EXTRACT("order", '$.efficiency') AS BIGINT) AS efficiency,CAST(JSON_EXTRACT("order", '$.fee') AS BIGINT) AS newFee,CAST(JSON_EXTRACT("order", '$.keeper') AS BIGINT) AS keeperFROM perennial_v2_arbitrum.Market_evt_OrderCreated),uitxns AS (SELECTCASEWHEN contract_address = 0x90A664846960AaFA2c164605Aebb8e9Ac338f9a0 THEN 'Ethereum'WHEN contract_address = 0xcc83e3cDA48547e3c250a88C8D5E97089Fd28F60 THEN 'Bitcoin'WHEN contract_address = 0x02258bE4ac91982dc1AF7a3D2C4F05bE6079C253 THEN 'Solana'WHEN contract_address = 0x7e34b5cbc6427bd53ecfaefc9ac2cad04e982f78 THEN 'Polygon'WHEN contract_address = 0xD9c296A7Bee1c201B9f3531c7AC9c9310ef3b738 THEN 'Chainlink'WHEN contract_address = 0x362c6bC2A4EA2033063bf20409A4c5E8C5754056 THEN 'BNB'WHEN contract_address = 0x2CD8651b0dB6bE605267fdd737C840442A96fAFE THEN 'Celestia'WHEN contract_address = 0x708B750f9f5bbD23E074a5a0A646EF545285906e85 THEN 'Rollbit'WHEN contract_address = 0x2402e92f8c58886f716f5554039fa6398d7a1efb THEN 'Ripple'WHEN contract_address = 0x3d1d603073b3ceab5974db5c54568058a9551ccc THEN 'Arbitrum'WHEN contract_address = 0x768a5909f0b6997efa56761a89344ea2bd5560fd THEN 'Bitcoin²'WHEN contract_address = 0x004e1abf70e4ff99bc572843b63a63a58faa08ff THEN 'Ethereum²'WHEN contract_address = 0xbfa99F19a376F25968865983c41535fa368B28da THEN 'Jupiter'END AS market,CASEWHEN contract_address = 0x90A664846960AaFA2c164605Aebb8e9Ac338f9a0 THEN 'ETH-USD'WHEN contract_address = 0xcc83e3cDA48547e3c250a88C8D5E97089Fd28F60 THEN 'BTC-USD'WHEN contract_address = 0x02258bE4ac91982dc1AF7a3D2C4F05bE6079C253 THEN 'SOL-USD'WHEN contract_address = 0x7e34b5cbc6427bd53ecfaefc9ac2cad04e982f78 THEN 'MATIC-USD'WHEN contract_address = 0xD9c296A7Bee1c201B9f3531c7AC9c9310ef3b738 THEN 'LINK-USD'WHEN contract_address = 0x362c6bC2A4EA2033063bf20409A4c5E8C5754056 THEN 'BNB-USD'WHEN contract_address = 0x2CD8651b0dB6bE605267fdd737C840442A96fAFE THEN 'TIA-USD'WHEN contract_address = 0x708B750f9f5bbD23E074a5a0A646EF545285906e85 THEN 'RLB-USD'WHEN contract_address = 0x2402e92f8c58886f716f5554039fa6398d7a1efb THEN 'XRP-USD'WHEN contract_address = 0x3d1d603073b3ceab5974db5c54568058a9551ccc THEN 'ARB-USD'WHEN contract_address = 0x768a5909f0b6997efa56761a89344ea2bd5560fd THEN 'BTC²-USD'WHEN contract_address = 0x004e1abf70e4ff99bc572843b63a63a58faa08ff THEN 'ETH²-USD'WHEN contract_address = 0xbfa99f19a376f25968865983c41535fa368b28da THEN 'JUP-USD'END AS product_id_,*FROM uitrades ut),pyth_price_feeds_markets AS (SELECTDATE_TRUNC('minute', call_block_time) AS _day,account_price_account,CASEWHEN account_price_account = 'JBu1AL4obBcCMqKBBxhpWCNUt136ijcuMZLFvTP7iWdB' THEN 'ETH-USD'WHEN account_price_account = 'GVXRSBjFk6e6J3NbVPXohDJetcTjaeeuykUpbQF8UoMU' THEN 'BTC-USD'WHEN account_price_account = 'H6ARHf6YXhGYeQfUzQNGk6rDNnLBQKrenN712K4AQJEG' THEN 'SOL-USD'