TXS | USERS | |
|---|---|---|
1 | 545781 | 119166 |
winnie-fs2023-11-27 07:31 PM
Updated 2024-01-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
-- forked from 2023-10-11 01:41 PM @ https://flipsidecrypto.xyz/edit/queries/3878012a-bfc1-4ed6-a3b9-e6d59657287a
select
count(DISTINCT tx_id) as txs,
count(DISTINCT signers[0]) as users
from solana.core.fact_events
join solana.core.fact_transactions using(tx_id,block_timestamp,succeeded)
join lateral flatten (input => log_messages) f
where program_id = '3parcLrT7WnXAcyPfkCz49oofuuf2guUKkjuFkAhZW8Y'
and block_timestamp::date > '2023-11-10'
and succeeded
Last run: over 1 year ago
1
17B
564s