tx_hash,

block_timestamp,

seller_address,

buyer_address,

platform_name,

nft_address,

price,

price_usd,

tx_fee_usd,

platform_fee_usd,

CASE

WHEN platform_fee_usd >= 0 AND platform_fee_usd < 0.6 THEN 'a. < 0.6 $'

WHEN platform_fee_usd >= 0.6 AND platform_fee_usd < 1.2 THEN 'b. 0.6 $ - 1.2 $'

WHEN platform_fee_usd >= 1.2 AND platform_fee_usd < 1.8 THEN 'c. 1.2 $ - 1.8 $'

WHEN platform_fee_usd >= 1.8 AND platform_fee_usd < 2.4 THEN 'd. 1.8 $ - 2.4 $'

else 'e. > 2.4 $'

END AS platform_fee_group

bsc.nft.ez_nft_sales

block_timestamp::date BETWEEN '{{ start_date }}' AND '{{ end_date }}'

and platform_name = 'element'

platform_fee_group,

COUNT(tx_hash) AS total_transactions,

SUM(price_usd) AS total_volume_usd,

COUNT(DISTINCT seller_address) AS unique_sellers,

COUNT(DISTINCT buyer_address) AS unique_buyers,

AVG(platform_fee_usd) AS avg_platform_fee_usd,

AVG(price_usd) AS avg_price_usd,

SUM(tx_fee_usd) AS total_tx_fee_usd

FROM t