headitmanagerDAOJONES_Quary
Updated 2022-02-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
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