Query editor
WITH tradez AS (SELECTcast(SUM(protocolEthAmount) as double)/1e18 AS eth_buy_volume_protocol,cast(SUM(subjectEthAmount) as double)/1e18 AS eth_buy_volume_subject,cast(SUM(ethAmount+subjectEthAmount+protocolEthAmount) as double)/1e18 AS eth_buy_volume,COUNT(DISTINCT trader) AS num_buyer_addresses,COUNT(DISTINCT subject) AS num_subject_addressesFROM friendtech_base.FriendtechSharesV1_evt_Trade), mkt_cap AS (SELECT SUM(subject_market_cap) AS total_market_cap_ethFROM (SELECT *, last_supply*last_price AS subject_market_capFROM (SELECTsubject,cast (MAX_BY( cast(ethAmount as double)/cast(shareAmount as double), evt_block_number) as double)/1e18 AS last_price,cast (MAX_BY( cast(supply as double), evt_block_number) as double) AS last_supplyFROM friendtech_base.FriendtechSharesV1_evt_TradeWHERE supply > cast(0 as uint256) and shareAmount > cast(0 as uint256)GROUP BY 1) a) b), txs AS (SELECTCOUNT(*) as num_transactions,SUM(cast(l1_fee as double) + cast(gas_price as double)*cast(gas_used as double) )/1e18 as eth_tx_fees,AVG(cast(l1_fee as double) + cast(gas_price as double)*cast(gas_used as double) )/1e18 as avg_eth_tx_feesFROM base.transactions tWHERE to = 0xCF205808Ed36593aa40a44F10c7f7C2F67d4A4d4 --FriendtechSharesV1)SELECTnum_transactions,eth_buy_volume, eth_buy_volume_subject, eth_buy_volume_protocol,num_buyer_addresses, num_subject_addresses, eth_tx_fees,total_market_cap_ethFROM tradez z, txs t, mkt_cap m