flipside

    Waiting for Aurory 4
    mattkstewWaiting for Aurory 4
    Updated 2022-07-15
    select
    date_trunc('day', block_timestamp),
    avg(sales_amount)

    from solana.core.fact_nft_sales left outer join solana.core.dim_labels
    on mint = solana.core.dim_labels.address
    where label like 'aurory'
    group by 1

    Run a query to Download Data