Updated 2023-01-09
    with tbl_NewUsers as
    (
    select count(1) ,created_date from (select SIGNERS[0] as users , min(to_date(block_timestamp)) as created_date from solana.core.fact_transactions
    where SUCCEEDED='TRUE' and to_date(block_timestamp) > current_date - interval '90 days'
    group by users)
    group by created_date
    )
    ,tbl_token_prices as
    (
    select avg(CLOSE) as prices , to_date(RECORDED_HOUR) as price_date from solana.core.ez_token_prices_hourly
    where price_date > current_date - interval '90 days' and symbol='sol'
    group by price_date
    )
    ,tbl_top50_nft as
    (
    select sum(SALES_AMOUNT) as sales_amount , LABEL from solana.core.fact_nft_sales inner join
    solana.core.dim_labels
    on mint=address
    where to_date(block_timestamp) > current_date - interval '90 days'
    group by LABEL
    order by sales_amount desc
    limit 50
    )
    ,tbl_top50nft_price as
    (
    select sum(SALES_AMOUNT)/count(*) as nft_price , to_date(block_timestamp) as date,LABEL as nft from solana.core.fact_nft_sales inner join
    solana.core.dim_labels
    on mint=address
    where to_date(block_timestamp) > current_date - interval '90 days' and nft in (select LABEL from tbl_top50_nft)
    group by date,nft
    )
    , tbl_tokens_swap_to_solana as
    (
    select count(SWAPPER) ,sum(SWAP_TO_AMOUNT) , avg(SWAP_TO_AMOUNT) ,to_date(block_timestamp) as date
    from solana.core.fact_swaps
    where SWAP_TO_MINT='So11111111111111111111111111111111111111112' and to_date(block_timestamp) > current_date - interval '90 days'
    Run a query to Download Data