Chief Active accounts By Exchange By Day by distribution of ABC's held
Updated 2023-01-26
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
›
⌄
-- (iii) active accounts (daily signers) by By Day by distribution of ABC's held or by distribution of sol held.
-- would be interesting to see the number of wallets that are active across multiple exchanges
with marketplace as (
SELECT block_timestamp,
tx_id,
marketplace as marketplace_label,
program_id
FROM solana.core.fact_nft_sales
WHERE block_timestamp > '2022-11-20' -- -- real start of exchange art '2021-10-20'
)
SELECT date_trunc('day', tx.block_timestamp) as date,
marketplace_label,
count(distinct signers[0]) as "Active Wallet"
FROM marketplace
JOIN solana.core.fact_transactions as tx
ON tx.tx_id = marketplace.tx_id
WHERE date > '2022-11-20' -- real start of exchange art '2021-10-20'
GROUP BY marketplace_label, date
ORDER BY date DESC
-- WITH marketplace_label AS (
-- SELECT
-- program_id as program_id_label,
-- marketplace as marketplace_label,
-- count(distinct tx_id) as tx_Count
-- FROM solana.core.fact_nft_sales
-- WHERE block_timestamp > '2023-01-10' -- real start of exchange art '2021-10-20'
-- AND SUCCEEDED = TRUE
-- GROUP BY 1,2
-- ),
-- traders as (
Run a query to Download Data