DrsimonDEGODS PRISE-w
    Updated 2022-09-08
    select
    date_trunc('week', block_timestamp) as date ,
    avg(sales_amount) as "AVG DEGODS PRISE SOL/USD" ,
    sum(sales_amount) as "TOTAL DEGODS PRICE SOL/USD" ,
    count(distinct(tx_id)) as "num sales"
    from solana.fact_nft_sales as n
    join solana.core.dim_labels as l
    on n.mint = l.address
    where label ilike 'DeGods'
    and succeeded = 'TRUE'
    group by 1
    Run a query to Download Data