Query editor
WITH wash_trading AS (SELECT distinct wash_trading_filter_ AS wash_trading_filterFROM (SELECT CASE WHEN '{{Wash Trading Filter}}' IN ('ON', 'OFF') THEN false END AS wash_trading_filter_UNION ALLSELECT CASE WHEN '{{Wash Trading Filter}}'='OFF' THEN true END AS wash_trading_filter_)WHERE wash_trading_filter_ IS NOT NULL), base_data AS (SELECT t.nft_contract_address, MAX(t.collection) AS collection, MAX(t.token_standard) AS token_standard, SUM(t.amount_usd) AS total_volumeFROM nft.trades tINNER JOIN nft.wash_trades wt ON wt.block_time=t.block_timeAND wt.unique_trade_id=t.unique_trade_idAND wt.is_wash_trade IN (SELECT wash_trading_filter FROM wash_trading)WHERE t.blockchain = 'ethereum'AND t.nft_contract_address IS NOT NULLAND t.tx_hash NOT IN (SELECT tx_hash FROM query_1982559) -- https://dune.com/queries/1982559 (Remove occasional bad data)GROUP BY t.nft_contract_address), past_day AS (SELECT t.nft_contract_address, SUM(t.amount_usd) AS volumeFROM nft.trades tINNER JOIN nft.wash_trades wt ON wt.block_time=t.block_timeAND wt.unique_trade_id=t.unique_trade_idAND wt.is_wash_trade IN (SELECT wash_trading_filter FROM wash_trading)WHERE t.blockchain='ethereum'AND t.block_time > NOW() - interval '1' dayAND t.tx_hash NOT IN (SELECT tx_hash FROM query_1982559) -- https://dune.com/queries/1982559 (Remove occasional bad data)GROUP BY t.nft_contract_address), past_week AS (SELECT t.nft_contract_address, SUM(t.amount_usd) AS volumeFROM nft.trades tINNER JOIN nft.wash_trades wt ON wt.block_time=t.block_timeAND wt.unique_trade_id=t.unique_trade_idAND wt.is_wash_trade IN (SELECT wash_trading_filter FROM wash_trading)WHERE t.blockchain='ethereum'AND t.block_time > NOW() - interval '7' dayAND t.tx_hash NOT IN (SELECT tx_hash FROM query_1982559) -- https://dune.com/queries/1982559 (Remove occasional bad data)GROUP BY t.nft_contract_address), past_30_days AS (SELECT t.nft_contract_address, SUM(t.amount_usd) AS volumeFROM nft.trades tINNER JOIN nft.wash_trades wt ON wt.block_time=t.block_timeAND wt.unique_trade_id=t.unique_trade_idAND wt.is_wash_trade IN (SELECT wash_trading_filter FROM wash_trading)WHERE t.blockchain='ethereum'AND (wt.is_wash_trade IN (SELECT wash_trading_filter FROM wash_trading) OR wt.is_wash_trade IS NULL)