LTirrellML Base -- Volume Spike copy
    Updated 2023-04-28
    -- -- forked from ML Base -- Volume Spike @ https://flipsidecrypto.xyz/edit/queries/565bfd32-7713-4abe-8a99-1e79cc78b11f
    -- -- forked from anduril / ML Base -- Volume Spike @ https://flipsidecrypto.xyz/anduril/q/ml-base-sales-total-daily-rE0xWL
    -- -- forked from LTirrell / ML Base -- sales Total Daily @ https://flipsidecrypto.xyz/LTirrell/q/ml-base-sales-SQMfsW
    -- -- forked from ML Base -- sales @ https://flipsidecrypto.xyz/edit/queries/66990db6-668c-4d46-89fb-86cd8473c33d
    -- -- forked from anduril / ML Base @ https://flipsidecrypto.xyz/anduril/q/2023-04-22-09-28-pm-lVxzpW

    select
    date_trunc('day', block_timestamp),
    sum(sales_amount)
    from
    solana.core.fact_nft_sales
    where
    date_trunc('day', block_timestamp) > '2023-04-01'
    group by
    date_trunc('day', block_timestamp)
    -- with
    -- ml_raw as (
    -- select
    -- signers[0] as collector,
    -- signers[2] as mint,
    -- fee / pow(10, 9) as fee,
    -- amount -- in sol
    -- from
    -- solana.core.fact_transactions
    -- inner join solana.core.fact_transfers t using (tx_id)
    -- where
    -- date(block_timestamp) >= '2023-04-19'
    -- and signers[1] = '2RtGg6fsFiiF1EQzHqbd66AhW7R5bWeQGpTbv2UMkCdW'
    -- and t.tx_to = '2RtGg6fsFiiF1EQzHqbd66AhW7R5bWeQGpTbv2UMkCdW'
    -- and mint = 'So11111111111111111111111111111111111111112'
    -- ),
    -- sol_price as (
    -- select
    -- recorded_hour,
    -- close as price
    -- from
    Run a query to Download Data