flyingfishCap Raise March 6 copy copy
    Updated 2024-11-15
    -- forked from Cap Raise March 13 copy @ https://flipsidecrypto.xyz/edit/queries/3e695189-6d63-4e87-b913-c8d209f750a8

    -- forked from Cap Raise March 23 @ https://flipsidecrypto.xyz/edit/queries/ac6ce083-801f-4cb4-b198-48274698fc57

    -- forked from Daily JLP Supply copy @ https://flipsidecrypto.xyz/edit/queries/1202b841-57d5-444d-9561-c1f511212ea5

    -- forked from JLP Supply @ https://flipsidecrypto.xyz/edit/queries/75b9a1ea-07e3-475d-93f2-a3782fdb2f55

    /*

    - 2024-03-06 10:00 (announced 2024-03-05 09:56)
    - 40M
    - 190 -> 230M

    */
    WITH RECURSIVE dates AS (
    SELECT
    CAST('2023-07-18' AS DATETIME) AS date
    UNION ALL
    SELECT
    date + INTERVAL '1 HOUR'
    FROM
    dates
    WHERE
    date < current_timestamp - interval '1 hour'
    )

    /* with dates as (
    SELECT
    date_day AS date
    -- DISTINCT(iso_week_start_date) AS date
    FROM ethereum.core.dim_dates
    WHERE date_day BETWEEN '2023-07-18' AND current_date()
    )
    */
    , jlp_mints AS (
    Last run: 2 months ago
    DATE
    JLP_MINTED
    JLP_BURNED
    SUPPLY_DELTA
    TOTAL_JLP_MINTED
    TOTAL_JLP_BURNED
    TOTAL_SUPPLY
    1
    2024-03-06 00:00:00.00000098670561.9116151-11894175.10600486776386.8056111
    2
    2024-03-06 01:00:00.00000098670561.9116151-11894175.10600486776386.8056111
    3
    2024-03-06 02:00:00.00000098670561.9116151-11894175.10600486776386.8056111
    4
    2024-03-06 03:00:00.0000-0.01-0.0198670561.9116151-11894175.11600486776386.7956111
    5
    2024-03-06 04:00:00.00000098670561.9116151-11894175.11600486776386.7956111
    6
    2024-03-06 05:00:00.00000098670561.9116151-11894175.11600486776386.7956111
    7
    2024-03-06 06:00:00.0000-0.005494-0.00549498670561.9116151-11894175.12149886776386.7901171
    8
    2024-03-06 07:00:00.00000098670561.9116151-11894175.12149886776386.7901171
    9
    2024-03-06 08:00:00.00000098670561.9116151-11894175.12149886776386.7901171
    10
    2024-03-06 09:00:00.00000098670561.9116151-11894175.12149886776386.7901171
    11
    2024-03-06 10:00:00.0006481345.93938606481345.939386105151907.851001-11894175.12149893257732.7295031
    12
    2024-03-06 11:00:00.0006799083.11527506799083.115275111950990.966276-11894175.121498100056815.844778
    13
    2024-03-06 12:00:00.000499105.6100180499105.610018112450096.576294-11894175.121498100555921.454796
    14
    2024-03-06 13:00:00.000232237.0219760232237.021976112682333.59827-11894175.121498100788158.476772
    15
    2024-03-06 14:00:00.000000112682333.59827-11894175.121498100788158.476772
    16
    2024-03-06 15:00:00.000000112682333.59827-11894175.121498100788158.476772
    17
    2024-03-06 16:00:00.000000112682333.59827-11894175.121498100788158.476772
    18
    2024-03-06 17:00:00.000000112682333.59827-11894175.121498100788158.476772
    19
    2024-03-06 18:00:00.0000-70.958046-70.958046112682333.59827-11894246.079544100788087.518726
    20
    2024-03-06 19:00:00.000000112682333.59827-11894246.079544100788087.518726
    25
    2KB
    33s