Highest Polygon NFT Daily Sales

with 
polygon_nft_categories as (
    select coalesce(address, pair_address) address,
        coalesce(c.category, dex.category) category
    from nft.polygon_nft_categories c
    full join (
        select distinct pair_address, 'DeFi' category
        from dex.polygon_dex_pools_v3
    ) dex on c.address=dex.pair_address
)
,nft_washtrades as (
  SELECT * FROM nft.polygon_nft_washtrades
  WHERE is_wash_trade = true
)
select
*,
ROW_NUMBER() OVER (partition by tx_hash, washtrade ORDER BY amount_usd DESC) as rn
FROM
(
  SELECT 
      DISTINCT
      txfer.data_creation_date,
      txfer.tx_hash,
      txfer.nft_contract_address as collection_address,
      CASE WHEN wt.transaction_hash IS NULL THEN false ELSE true END as washtrade
    ,amount_usd
        ,amount_original
      ,currency_symbol,
    txfer.token_id
  FROM nft.polygon_trades txfer
  LEFT JOIN nft_washtrades wt
  ON txfer.data_creation_date = wt.data_creation_date
  AND txfer.tx_hash = wt.transaction_hash
  LEFT JOIN polygon_nft_categories c ON txfer.nft_contract_address = c.address
  WHERE txfer.data_creation_date BETWEEN current_date - interval '1' day and current_date
  AND wt.data_creation_date BETWEEN current_date - interval '1' day and current_date
  AND c.category is null or lower(c.category) != 'defi'
)
WHERE data_creation_date  BETWEEN current_date - interval '1' day and current_date
AND collection_address NOT IN ('0x2953399124f0cbb46d2cbacd8a89cf0599974963')
ORDER BY amount_usd DESC,data_creation_date DESC
LIMIT 100