DAY | NEWRECIPIENTS | |
---|---|---|
1 | 2023-04-28 00:00:00.000 | 263 |
2 | 2023-05-11 00:00:00.000 | 150 |
3 | 2023-05-13 00:00:00.000 | 43 |
4 | 2023-05-14 00:00:00.000 | 32 |
5 | 2023-05-20 00:00:00.000 | 33 |
6 | 2023-05-21 00:00:00.000 | 40 |
7 | 2023-05-27 00:00:00.000 | 26 |
8 | 2023-05-28 00:00:00.000 | 16 |
9 | 2023-05-29 00:00:00.000 | 5 |
10 | 2023-06-03 00:00:00.000 | 23 |
11 | 2023-06-06 00:00:00.000 | 22 |
12 | 2023-06-07 00:00:00.000 | 24 |
13 | 2023-06-13 00:00:00.000 | 38 |
14 | 2023-06-14 00:00:00.000 | 31 |
15 | 2023-06-20 00:00:00.000 | 26 |
16 | 2023-06-21 00:00:00.000 | 21 |
17 | 2023-06-27 00:00:00.000 | 18 |
18 | 2023-06-28 00:00:00.000 | 21 |
19 | 2023-07-04 00:00:00.000 | 25 |
20 | 2023-07-05 00:00:00.000 | 20 |
crypto_edgarNew Raffle Winners
Updated 2024-01-29
99
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
the_heist_mints_1 as (
select
DATE_TRUNC('Day', BLOCK_TIMESTAMP) AS DAY,
instructions[3]:accounts[6] AS MINT,
CASE
WHEN DATE_TRUNC('Day', BLOCK_TIMESTAMP) = '2023-04-28 00:00:00' THEN instructions[3]:accounts[5]
ELSE instructions[2]:parsed:info:wallet
END AS TX_TO
from
solana.core.fact_transactions
where
SUCCEEDED
AND BLOCK_TIMESTAMP >= '2023-04-16 00:00:00'
AND instructions[3]:accounts[0] = 'Dsnt8uSrj3GRUmBZTmt2m3ZDhVW7cNUHhHaR1rLkG6cy'
AND instructions[3]:accounts[1] = 'CndyV3LdqHUfDLmE5naZjVN8rBZz4tqhdefbAnjHG3JR'
AND instructions[3]:accounts[2] = 'G7dtC1TA6bCs3FGywFz4se6VxoHGH19ND7PEJr8uGecz'
),
the_heist_mints_2 as (
SELECT
DATE_TRUNC('Day', BLOCK_TIMESTAMP) AS DAY,
instructions[1]:accounts[5] AS MINT,
instructions[1]:accounts[4] AS TX_TO
FROM
solana.core.fact_transactions
WHERE
SUCCEEDED
AND (
DATE_TRUNC('Day', BLOCK_TIMESTAMP) IN (
'2023-04-28 00:00:00',
'2023-05-11 00:00:00',
'2023-05-13 00:00:00',
'2023-05-14 00:00:00',
'2023-05-20 00:00:00',
'2023-05-21 00:00:00',
'2023-05-24 00:00:00',
Last run: about 1 year ago
28
865B
677s