mariyaStepN Growth
Updated 2022-03-02
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select block_timestamp::date as date , count (DISTINCT TX_FROM_ADDRESS) as number_of_unique_wallets,
count(DISTINCT tx_id) as num_of_transactions
from solana.transactions
where block_timestamp::date >= '2022-01-01'
and succeeded =true
and (pre_mint = 'AFbX8oGjGpmVFywbVouvhQSRmiW2aR1mohfahi4Y2AdB' or post_mint = 'AFbX8oGjGpmVFywbVouvhQSRmiW2aR1mohfahi4Y2AdB' )
group by 1
-- select * from solana.transactions
-- where tx_id ='64QaDZN7BsuXxsSKB4BEJknXXTJjs3VsWcnEUMpS2cJqp8Wjp4kGKCE5R7kCciaR5LdKER6MqwBjt6mp2xpZyvdL'
Run a query to Download Data