HoneylandFuture Investors
    Updated 6 days ago
    -- Future Investors
    WITH WALLET_LIST AS (
    SELECT
    '6Pny6i91mSjk1s9qQRpyX4LG2J8Y2Mye359EvNQ9sQns' AS FUTURE_INVESTORS
    UNION
    ALL
    SELECT
    'Gs8NG1u85eQ8YugowC8TyY6on7XT1N64HKUn6jvT2kkZ' AS FUTURE_INVESTORS
    UNION
    ALL
    SELECT
    'Cuu2ts6MezbQrAbH5JgY8pdECZ8FS9st3aUmim4UAx3H' AS FUTURE_INVESTORS
    UNION
    ALL
    SELECT
    'GcM5zFTU2SqqsLVQr9bvz9XwfnfvqGHXpAmNtguHD8be' AS FUTURE_INVESTORS
    UNION
    ALL
    SELECT
    'EjdLYkuDe9W36ERDge2NyDKXnqygrbAEJ14SFRGWg9CX' AS FUTURE_INVESTORS
    UNION
    ALL
    SELECT
    '7jp6kBTrVaWW9uTkyRJXBzGn7gPUbQDJX7infWJKWNQ7' AS FUTURE_INVESTORS
    ),
    cte_date (date_rec) as (
    select
    to_date('2023-03-07')
    union
    all
    select
    to_date(dateadd(day, 1, date_rec)) --or week, month, week, hour, minute instead of day
    from
    cte_date
    where
    date_rec < CURRENT_DATE()
    Last run: 6 days ago
    DAY
    CUMULATIVE_SUM
    1
    2025-04-21 00:00:00.00044031812.4137865
    2
    2025-04-20 00:00:00.00044031812.4137865
    3
    2025-04-19 00:00:00.00044031812.4137865
    4
    2025-04-18 00:00:00.00044031812.4137865
    5
    2025-04-17 00:00:00.00044031812.4137865
    6
    2025-04-16 00:00:00.00044031812.4137865
    7
    2025-04-15 00:00:00.00044031812.4137865
    8
    2025-04-14 00:00:00.00044031812.4137865
    9
    2025-04-13 00:00:00.00044031812.4137865
    10
    2025-04-12 00:00:00.00044031812.4137865
    11
    2025-04-11 00:00:00.00044031812.4137865
    12
    2025-04-10 00:00:00.00044031812.4137865
    13
    2025-04-09 00:00:00.00044031812.4137865
    14
    2025-04-08 00:00:00.00044031812.4137865
    15
    2025-04-07 00:00:00.00044031812.4137865
    16
    2025-04-06 00:00:00.00044031812.4137865
    17
    2025-04-05 00:00:00.00044031812.4137865
    18
    2025-04-04 00:00:00.00044031812.4137865
    19
    2025-04-03 00:00:00.00044031812.4137865
    20
    2025-04-02 00:00:00.00044031812.4137865
    ...
    768
    32KB
    101s