crypto_edgarNew Raffle Winners
    Updated 2024-01-29
    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
    DAY
    NEWRECIPIENTS
    1
    2023-04-28 00:00:00.000263
    2
    2023-05-11 00:00:00.000150
    3
    2023-05-13 00:00:00.00043
    4
    2023-05-14 00:00:00.00032
    5
    2023-05-20 00:00:00.00033
    6
    2023-05-21 00:00:00.00040
    7
    2023-05-27 00:00:00.00026
    8
    2023-05-28 00:00:00.00016
    9
    2023-05-29 00:00:00.0005
    10
    2023-06-03 00:00:00.00023
    11
    2023-06-06 00:00:00.00022
    12
    2023-06-07 00:00:00.00024
    13
    2023-06-13 00:00:00.00038
    14
    2023-06-14 00:00:00.00031
    15
    2023-06-20 00:00:00.00026
    16
    2023-06-21 00:00:00.00021
    17
    2023-06-27 00:00:00.00018
    18
    2023-06-28 00:00:00.00021
    19
    2023-07-04 00:00:00.00025
    20
    2023-07-05 00:00:00.00020
    28
    865B
    677s