andurilUntitled Query
Updated 2022-12-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with dooar_txs as (
select DISTINCT tx_id as tx_id
from solana.core.fact_events
where
date(block_timestamp) = '2022-12-03' and
program_Id = 'Dooar9JkhdZ7J3LHN3A7YCuoGRUggXhQaG4kijfLGU2j'
)
select
count(distinct signers[0]) as a,
count (distinct signers [1]) as unique_signers,
count (distinct signers [2]) as unique_signers2
from solana.core.fact_transactions t
inner join dooar_txs d
using (tx_id)
where
date(block_timestamp) = '2022-12-03'
Run a query to Download Data