SELECT

decoded_log:taker AS taker,

decoded_log:maker AS maker,

SUM(CASE

WHEN decoded_log:takerAssetId = 0 THEN decoded_log:takerAmountFilled

WHEN decoded_log:makerAssetId = 0 THEN decoded_log:makerAmountFilled

END / 1e18) AS Amount_USD,

FROM blast.core.fact_decoded_event_logs

WHERE contract_address IN ('0x739f0331594029064c252559436edce0e468e37a', '0x6a3796c21e733a3016bc0ba41edf763016247e72')

AND event_name = 'OrderFilled'

GROUP BY taker, maker

SELECT

COUNT(DISTINCT taker) AS takers,

COUNT(DISTINCT maker) AS Makers,

CASE

WHEN Amount_USD < 200 THEN '<200'

WHEN Amount_USD >= 200 AND Amount_USD < 500 THEN '200-500'

WHEN Amount_USD >= 500 AND Amount_USD < 1000 THEN '500-1000'

WHEN Amount_USD >= 1000 AND Amount_USD < 2000 THEN '1000-2000'

WHEN Amount_USD >= 2000 AND Amount_USD < 5000 THEN '2000-5000'

WHEN Amount_USD >= 5000 THEN '>5000'

END AS Amount_Category

FROM predictfun

GROUP BY Amount_Category

ORDER BY Amount_Category;