Query editor
/*Table(s): ethereum.transactionsReason: Raw tables recommendedTable(s): erc20_ethereum.evt_TransferReason: Based on standards mentionedTable(s): floki_bnb.FLOKI_evt_Transfer, floki_ethereum.FLOKI_evt_TransferReason: Based on contract addresses or possible project names*/WITH DailyTransaction AS (SELECTDATE_TRUNC('day', evt_block_time) AS day,TRY_CAST(value AS DECIMAL) AS transaction_valueFROM floki_ethereum.FLOKI_evt_TransferWHEREcontract_address = 0xcf0c122c6b73ff809c693db761e7baebe62b6a2e), DailyMedian AS (SELECTday,APPROX_PERCENTILE(transaction_value, 0.5) AS median_valueFROM DailyTransactionGROUP BYday), FilteredTransactions AS (SELECTdt.day,dt.transaction_valueFROM DailyTransaction AS dtJOIN DailyMedian AS dmON dt.day = dm.dayWHEREdt.transaction_value > dm.median_value)SELECTday,COUNT(*) AS transaction_count,SUM(transaction_value) AS total_transaction_volume_above_medianFROM FilteredTransactionsGROUP BYdayORDER BYday