Algorand AS (

SELECT

block_timestamp,

tx_group_id AS tx,

nft_marketplace AS marketplace,

purchaser AS buyer,

nft_asset_id AS token_id,

-- nft_asset_name AS nft_name,

collection_name AS collection,

total_sales_amount * price_usd AS amount_usd

FROM

algorand.nft.ez_nft_sales sales

JOIN (

SELECT

block_hour::date AS day,

AVG(price_usd) AS price_usd

FROM

algorand.defi.ez_price_pool_balances

WHERE

block_hour::date BETWEEN (CURRENT_DATE - {{range}} - 1) AND (CURRENT_DATE - 1)

AND asset_id = 0

GROUP BY

day

) prices

ON

sales.block_timestamp::date = prices.day

WHERE

block_timestamp::date BETWEEN (CURRENT_DATE - {{range}} - 1) AND (CURRENT_DATE - 1)

AND total_sales_amount > 0

),

Arbitrum AS (

SELECT

events.block_timestamp,

events.tx_hash AS tx,

events.origin_to_address AS marketplace,