anduril3Kr Program
Updated 2023-06-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
›
⌄
with
txs as (
select distinct
tx_id
from
solana.core.fact_events
where
date(block_timestamp) >= '2023-03-20'
and program_id = '3Kr1RcL41pWL7qzAA5tCTTKcqjbG3RNRsFaDGMd82iW4'
)
select
date(block_timestamp) as date,
count(distinct tx_id) as txs,
count(distinct tx_from) as senders,
count(distinct tx_to) as recievers,
sum(amount) as sol_amount
from
solana.core.fact_transfers
join txs using (tx_id)
where
date(block_timestamp) >= '2023-03-20'
and mint = 'So11111111111111111111111111111111111111112'
group by
date
Run a query to Download Data