Query editor
with txs as (SELECT distinctdate(call_block_time), "rightOrder"->'makerAddress' AS seller, "leftOrder"->'makerAddress' AS buyer, *FROM opensea_polygon_v2."ZeroExFeeWrapper_call_matchOrders" osjoin polygon.logs l on l.tx_hash = os.call_tx_hashwhere l.contract_address = '\x7c885c4bfd179fb59f1056fbea319d579a278075' ),token AS(SELECT call_tx_hash AS tx_hash,CASEWHEN ("leftOrder"->'makerAssetData')::text = '"0xf47261b00000000000000000000000007ceb23fd6bc0add59e62ac25578270cff1b9f619"' THEN '\x7ceB23fD6bC0adD59E62ac25578270cFf1b9f619'WHEN ("leftOrder"->'makerAssetData')::text = '"0xf47261b00000000000000000000000008f3cf7ad23cd3cadbd9735aff958023239c6a063"' THEN '\x8f3Cf7ad23Cd3CaDbD9735AFf958023239c6A063'WHEN ("leftOrder"->'makerAssetData')::text = '"0xf47261b000000000000000000000000070c006878a5a50ed185ac4c87d837633923de296"' THEN '\x70c006878a5a50ed185ac4c87d837633923de296'ELSE '\x8f3Cf7ad23Cd3CaDbD9735AFf958023239c6A063'::byteaEND AS token_address,18 AS decimalsFROM opensea_polygon_v2."ZeroExFeeWrapper_call_matchOrders" a),tx_values as (select distinct date, seller, buyer, txs.tx_hash, block_time, "output_matchedFillResults"->'right'->'takerFeePaid',--"output_matchedFillResults"->'right'->'takerFeePaid'/10^token.decimals,"output_matchedFillResults"->'left'->'makerFeePaid', SUM(p.price * least("output_matchedFillResults"->'left'->'makerFeePaid', "output_matchedFillResults"->'right'->'takerFeePaid')::numeric/10^token.decimals) as usd-- date(call_block_time), count(*)from txsleft join token on token.tx_hash = txs.tx_hashleft join prices.usd p on p.minute = date_trunc('minute', block_time) and token.token_address = p.contract_addressgroup by date, seller, buyer, txs.tx_hash, block_time, "output_matchedFillResults"->'right'->'takerFeePaid',--"output_matchedFillResults"->'right'->'takerFeePaid'::numeric/10^token.decimals,"output_matchedFillResults"->'left'->'makerFeePaid')select date, sum(usd) over (order by date asc)from (select date, sum(usd) as usdfrom tx_valuesgroup by 1) as sub