CREATOR | FIRST_DEPLOYMENT_DATE | |
---|---|---|
1 | 41TMXb4bcQPc3oWn2Y8VvQeM9wXNXd1Z4n9azoGdaFEd | 2023-12-16 00:00:00.000 |
2 | 8QqEzaJq2zJG27koeYHPonKXjzef7Czku3MUQTedy3N2 | 2023-12-17 00:00:00.000 |
3 | EwH7gvicP4BjURMjpKPNf5hCGbjQg3RxVK2HCgkTuGRc | 2023-12-17 00:00:00.000 |
4 | 8XFv1WoNWmAHCmDZLLx7JP1R9QMNxksX98i3jku5MHop | 2023-12-18 00:00:00.000 |
5 | CUNxXonQ8RMEAjmd5ya7kFjx8u3MViE8YejdPWvWB8eB | 2023-12-16 00:00:00.000 |
6 | F24iMVgiPiHstjy8df9vbSyp8nJ8XuYX5eXPqmFVTApS | 2023-12-18 00:00:00.000 |
7 | 7pauvUaSNA2tyhgFrUabewvn3GfWBWZcXZbARRGpm563 | 2023-12-16 00:00:00.000 |
8 | s78j5Eqp5h15YPDdpTtknwVxGcNxQRN6kYDEfpPk8XJ | 2023-12-15 00:00:00.000 |
9 | 8W9NJfM6cqCsvR1FC8Ab8YZPSQF7bz7inxJZxWnF7GsX | 2023-12-15 00:00:00.000 |
10 | EzW2j5g1MEyKS5TBe22qgBSu1QedCh9cVvL9RukctH4F | 2023-12-17 00:00:00.000 |
11 | Ds2jzp6Qpu84bNaKeR81P3QLLNh5DEvjbMD9iQNCUvVY | 2023-12-16 00:00:00.000 |
12 | 7WTDH4ZLfW4sjxdFnVhZAcmSpmu8kVkA7R66dfXCMyFT | 2023-12-16 00:00:00.000 |
13 | 6Hr6UTEGVRoDXZiqbURLgLk8tzQZcszAJBHiNN5qPuY7 | 2023-12-15 00:00:00.000 |
14 | GEhLxggGLJ7t4emFFmacLfyHywqS8m7b7YksKw6t5t3A | 2023-12-15 00:00:00.000 |
15 | H4797npirinPtdxZohazPjaSjWfMQFJip1SXvHm8S99c | 2023-12-16 00:00:00.000 |
16 | Hf52tuGzrLn6zLy2HTzKYzfkFHrwniDQ1EJByZ1JYjaD | 2023-12-17 00:00:00.000 |
17 | 3mzzWWDmzqSPVgZeXRsRyBoXfGjvieeVC5XQc8DVcfZU | 2023-12-16 00:00:00.000 |
18 | 6GiD6hXpBr8Jy53sQubZwfryUebCpHEvXhsMqJbDa4Qp | 2023-12-15 00:00:00.000 |
19 | MQ8YJ8r1Pqm97LKLWqgbkpk9Af4zLWqiGdXsm28XU7E | 2023-12-22 00:00:00.000 |
20 | 7Teob9b6w9kjksb5zoW4eco9BudB2hBUH24jZ53GKn13 | 2023-12-15 00:00:00.000 |
rain_syndicaLibreplex Fair Launch Deployers
Updated 2024-02-01
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
deployments as (
select distinct
block_timestamp
, signers[0] as creator
, tx_id
from solana.core.fact_events
inner join solana.core.fact_transactions
using(block_timestamp, tx_id, succeeded)
-- inner join lateral flatten (input => log_messages) f_logs
where succeeded
and program_id = '8bvPnYE5Pvz2Z9dE6RAqWr1rzLknTndZ9hwvRE6kPDXP'
and log_messages::string like '%Program log: Instruction: DeployLegacy%'
and log_messages::string like '%Program log: Instruction: CreateInscription%'
and block_timestamp > '2023-11-10'
and block_timestamp < '2024-02-01'
),
creator_first_deployment as (
SELECT
creator,
min(block_timestamp) as first_deployment_date
from deployments
group by creator
)
select
creator,
date_trunc('day', first_deployment_date)::string as first_deployment_date
from creator_first_deployment
-- SELECT
-- date_trunc('day', first_deployment_date) as day,
Last run: about 1 year ago
...
861
63KB
396s