SalehStableJack-Date
    Updated 2025-05-19
    with lst_mint as (
    select
    block_timestamp::date as date_a
    ,tx_hash
    ,DECODED_LOG:to as wallet
    ,DECODED_LOG:value/1e18 as amount
    -- from avalanche.core.fact_decoded_event_logs
    from avalanche.core.ez_decoded_event_logs
    where event_name='Transfer'
    and contract_address='0xabe7a9dfda35230ff60d1590a929ae0644c47dc1' --Stable Jack: aUSD(aUSD)
    and DECODED_LOG:from = '0x0000000000000000000000000000000000000000'
    )
    ,lst_main_mint as (
    select
    block_timestamp::date as date_a
    ,tx_hash
    ,ORIGIN_FROM_ADDRESS as wallet
    ,amount
    from avalanche.core.ez_token_transfers
    where contract_address ='0xabe7a9dfda35230ff60d1590a929ae0644c47dc1' --Stable Jack: aUSD(aUSD)
    and from_address = '0x0000000000000000000000000000000000000000'
    )
    ,lst_burn as (
    select
    block_timestamp::date as date_a
    ,tx_hash
    ,DECODED_LOG:from as wallet
    ,DECODED_LOG:value/1e18 as amount
    -- from avalanche.core.fact_decoded_event_logs
    from avalanche.core.ez_decoded_event_logs
    where event_name='Transfer'
    and contract_address='0xabe7a9dfda35230ff60d1590a929ae0644c47dc1' --Stable Jack: aUSD(aUSD)
    and DECODED_LOG:to = '0x013b34dba0d6c9810f530534507144a8646e3273'
    )
    ,lst_all as (
    select 'Mint' as type , * from lst_main_mint
    Last run: 13 days ago
    DATE
    Minters
    Minted aUSD
    Burned aUSD
    Total Supply aUSD
    Cumulative Minted aUSD
    Cumulative Burned aUSD
    Cumulative Total Supply aUSD
    Cumulative Minters
    1
    2024-06-17 00:00:00.000185526486.2350724933733.78492752.45507249526486.2350724933733.78492752.45507249185
    2
    2024-06-24 00:00:00.00089289979.967157818170668.83119311.137157818816466.202230308204402.61612063.592230308274
    3
    2024-07-01 00:00:00.00064659008.295295307157439.002501569.2932953071475474.49752562361841.6121113632.88552561338
    4
    2024-07-08 00:00:00.00032418905.0558907828457.94410447.1158907821894379.5534164370299.5521524080.0014164370
    5
    2024-07-15 00:00:00.00052232144.8795408122340.17229804.7095408122126524.43295721372639.7221753884.71095721422
    6
    2024-07-22 00:00:00.0004464061.655805508134256.4-70194.7441944922190586.08876272506896.1221683689.96676272466
    7
    2024-07-29 00:00:00.00034128258.890865283156960.91-28702.0191347172318844.979628663857.0321654987.947628500
    8
    2024-08-05 00:00:00.00021108445.71544201220479.1887966.5354420122427290.69507001684336.2121742954.48307001521
    9
    2024-08-12 00:00:00.000125884.40802800546028.74-40144.3319719952433175.10309802730364.9521702810.15109802533
    10
    2024-08-19 00:00:00.0001510382.83640013335524.75-25141.9135998672443557.93949815765889.7021677668.23749815548
    11
    2024-08-26 00:00:00.00015122582.651392072358.71122223.9413920722566140.59089022766248.4121799892.17889022563
    12
    2024-09-02 00:00:00.00020278029.36969872325635.07252394.2996987232844169.96058894791883.4822052286.47858894583
    13
    2024-09-09 00:00:00.00024524424.87741938544123.46480301.4174193853368594.83800833836006.9422532587.89600833607
    14
    2024-09-16 00:00:00.00028103970.74365325498421.06-394450.316346753472565.581661581334428.0022138137.57966158635
    15
    2024-09-23 00:00:00.000103989784.70053277358902.9630881.7405327733562350.282194351393330.9622169019.320194351674
    16
    2024-09-30 00:00:00.00010945510.66339911122492.623018.0633991113607860.945593461415823.5622192037.383593461783
    17
    2024-10-07 00:00:00.000118149263.54792052851070.2598193.2979205283757124.493513991466893.8122290230.681513991901
    18
    2024-10-14 00:00:00.0008324582.736207676933.5223649.2162076763781707.229721671467827.3322313879.897721671984
    19
    2024-10-21 00:00:00.00027823949.44261476711301.7512647.6926147673805656.672336431479129.0822326527.590336432262
    20
    2024-10-28 00:00:00.00034230882.5777322631162.91429719.6637322633836539.25006871480291.9962356247.25406872604
    49
    6KB
    3s