rain_syndicaLibreplex Fair Launch Deployers
    Updated 2024-02-01
    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
    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
    ...
    861
    63KB
    396s