headitmanagerDAOJONES_Quary
    Updated 2022-02-19
    with TempTableTransactions as (Select block_timestamp::date as date,count(*) as TransactionsCount From solana.transactions Where
    block_timestamp::date >= '2021-12-06' And Succeeded = 'True' AND
    post_mint = 'r8nuuzXCchjtqsmQZVZDPXXq928tuk7KVH479GsKVpy'
    Group by date
    order by date)
    ,
    TempTablewallets as(Select block_timestamp::date as date,count(distinct tx_from_address) as AddressCount From solana.transactions Where
    block_timestamp::date >= '2021-12-06' And Succeeded = 'True' AND
    post_mint = 'r8nuuzXCchjtqsmQZVZDPXXq928tuk7KVH479GsKVpy' and tx_from_address!='' and tx_from_address is not null
    Group by date
    order by date)

    select TempTableTransactions.date,TransactionsCount,AddressCount from TempTableTransactions,TempTablewallets
    where TempTableTransactions.date = TempTablewallets.date
    order by TransactionsCount desc,AddressCount desc


    Run a query to Download Data