Query editor
WITHsale AS (SELECT*FROM(SELECT(value / CAST(1e18 AS DOUBLE)) AS amount_bnb_sell,"from" AS buyer_address,"to" AS seller_address,tx_hash,DATE_TRUNC('day', TRY_CAST(block_time AS DATE)) AS dt,ROW_NUMBER() OVER (PARTITION BYtx_hashORDER BYvalue DESC) AS sale_orderFROMbnb.tracesWHEREblock_time > timestamp'2022-11-01'AND tx_hash IN (SELECTevt_tx_hashFROMerc721_bnb.evt_TransferWHEREcontract_address = 0x2af749593978cb79ed11b9959cd82fd128ba4f8dAND "from" != 0x0000000000000000000000000000000000000000)AND value > cast(0 as uint256)and "to" = 0x00000000000000adc04c56bf30ac9d3c0aaf14dc) AS aWHEREsale_order = 1)SELECTMAX(amount_bnb_sell) AS max_price,AVG(amount_bnb_sell) AS min_price,(APPROX_PERCENTILE(amount_bnb_sell, 0.1)) AS approx_floor_price,dtFROMsaleGROUP BY4ORDER BYdt DESC