nitsDaily NFT Sales
    Updated 2022-12-01
    SELECT date(block_timestamp) as day, count(DISTINCT tx_id) as total_txs,
    count(DISTINCT purchaser) as buyers,
    sum(sales_amount)/pow(10,6) as net_sale,
    sum(net_sale) over (order by day) as cum_sale
    from terra.core.fact_nft_sales
    where tx_succeeded = TRUE and currency = 'uluna' and day >= CURRENT_DATE -{{N}}
    GROUP by 1
    Run a query to Download Data