kiryl_solSaga Genesis Tokens Chart
Updated 2024-01-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
SELECT
DATE_TRUNC('DAY', block_timestamp) AS day,
COUNT(*) AS count_mint,
COUNT(DISTINCT signers [2]) AS count_unique_owners
FROM
solana.core.fact_transactions
WHERE
block_timestamp :: DATE >= '2023-03-20'
AND signers[0] = '7k5qzD2LLJCchakNG9wu9G3AvyFP7eWXBk4WbqgQypm6'
AND (
signers[1] = 'D4v4527fUNT2CYgL4Wz7KnNLK3rTSd62ijQzYFYSjPTH' OR
signers[1] = '8haaz4YwkmiEirHomPNf6BiDaaLhAWrUSXVegexgYpjZ'
)
AND succeeded = TRUE
AND ACCOUNT_KEYS :: TEXT LIKE '%En54STTsmVrWA3Cd43SQNgiLrihRDG2iMJD6zWPHjYfW%'
GROUP BY
day
QueryRunArchived: QueryRun has been archived