MONTH | LABEL | TXS | WALLETS | |
---|---|---|---|---|
1 | 2024-02-01 00:00:00.000 | UnderDog | 17008 | 2 |
2 | 2024-02-01 00:00:00.000 | Spling Labs | 14508 | 34 |
3 | 2024-02-01 00:00:00.000 | Access | 10200 | 2455 |
4 | 2024-02-01 00:00:00.000 | Dialect | 3945 | 784 |
5 | 2024-02-01 00:00:00.000 | Dispatch | 3888 | 1 |
6 | 2024-02-01 00:00:00.000 | Squads | 3875 | 628 |
7 | 2024-02-01 00:00:00.000 | Exchange Art | 2853 | 1067 |
8 | 2024-02-01 00:00:00.000 | Taki | 2178 | 1882 |
9 | 2024-02-01 00:00:00.000 | Bonfida | 1360 | 1037 |
10 | 2024-02-01 00:00:00.000 | Audius | 1316 | 161 |
11 | 2024-02-01 00:00:00.000 | ANS Domain | 910 | 318 |
12 | 2024-02-01 00:00:00.000 | Nina Protocol | 307 | 9 |
13 | 2024-02-01 00:00:00.000 | Raindrops | 176 | 3 |
14 | 2024-02-01 00:00:00.000 | Backpack | 62 | 42 |
15 | 2024-02-01 00:00:00.000 | BazeOne | 27 | 7 |
16 | 2024-02-01 00:00:00.000 | Only1 | 23 | 16 |
17 | 2024-02-01 00:00:00.000 | CodeCanvas | 11 | 8 |
18 | 2024-02-01 00:00:00.000 | Cupcake | 7 | 4 |
19 | 2024-02-01 00:00:00.000 | Only1 | 1 | 1 |
20 | 2024-01-01 00:00:00.000 | UnderDog | 196968 | 2 |
andurilSocial Data - Programs, Tokens and Misc
Updated 2024-02-06
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with
compression_txs as (
select distinct
tx_id
from
solana.core.fact_events
where
date(block_timestamp) >= '2023-08-10'
and program_id = 'BGUMAp9Gq7iTEuizy4pqaxsTyUCBK68MDfK752saRPUY'
and signers[0] = '4WCBsTL4fHpg8qCt1wxoqRzgj2CZepdpmS5NaaoxPUJh'
),
dialect_agg as (
select
date_trunc('month',block_timestamp) as month,
'Dialect' as label,
count(distinct tx_id) as txs, --mints
count(distinct instructions[0]:accounts[1]) as wallets--collectors
from
solana.core.fact_transactions
inner join compression_txs using (tx_id)
where
month between '2023-08-10' and date_trunc('month', current_date())
and (
log_messages[1] = 'Program log: Instruction: MintToCollectionV1'
OR log_messages[1] = 'Program log: Instruction: MintV1'
)
and succeeded
group by
1
),
social_transfers AS (
SELECT
block_timestamp,
tx_id,
Last run: over 1 year ago
...
146
7KB
557s