Updated 5 hours ago
    with
    -------------------- Dates --------------------
    dates as (
    select
    date_trunc('week', date_day) as date
    from
    crosschain.core.dim_dates
    where
    date_day < current_date
    group by
    date
    ),
    -------------------- CORE and stCORE Prices --------------------
    prices_raw as (
    select
    (
    select response as core_price
    from(select livequery.live.udf_api(
    'https://api.coingecko.com/api/v3/simple/price?ids=coredaoorg&vs_currencies=usd'
    ):data:"coredaoorg":usd as response)
    ) as core_price,
    (
    select response as stcore_price
    from(select livequery.live.udf_api(
    'https://api.coingecko.com/api/v3/simple/price?ids=coredao-staked-core&vs_currencies=usd'
    ):data:"coredao-staked-core":usd as response)
    ) as stcore_price
    ),
    prices as (
    select
    core_price,
    stcore_price
    from
    prices_raw
    ),
    -------------------- Minting and Burning Transactions --------------------
    Last run: about 5 hours agoAuto-refreshes every 6 hours
    Date
    Deposited
    Withdrawn
    CORE Netflow
    Staked
    Minted
    Redeemed
    stCORE Netflow
    Supply
    CORE_PRICE
    STCORE_PRICE
    TVL
    Market Cap
    1
    2025-03-31 00:00:00.000345010.613898-95803.578856486249207.03504151416749332.0847973291681.423266509-81022.589308739210658.8339577715005382.8437253
    0.395962
    0.469413
    6632099.03096057043721.77682163
    2
    2025-03-24 00:00:00.000117347.62-536345.959965633-418998.33996563316500125.049755899353.509591711-453983.975980008-354630.46638829714794724.0097675
    0.395962
    0.469413
    6533422.514951396944835.78159701
    3
    2025-03-17 00:00:00.000188436.15368-707438.41780822-519002.2641282216919123.3897214159781.846740324-599895.666721202-440113.81998087715149354.4761558
    0.395962
    0.469413
    6699329.935640867111303.93271574
    4
    2025-03-10 00:00:00.0001142346.912947-867279.954315669275066.95863133117438125.6538496970949.271679791-736724.491706042234224.7799737515589468.2961367
    0.395962
    0.469413
    6904835.11014967317899.08129443
    5
    2025-03-03 00:00:00.0005717424.801217-571240.0063307265146184.7948862717163058.69521834866599.87039965-485943.6653684344380656.2050312215355243.516163
    0.395962
    0.469413
    6795919.047076027207950.92465261
    6
    2025-02-24 00:00:00.000373280.278733-1584253.52302137-1210973.2442883712016873.900332318191.216169499-1349776.09812068-1031584.8819511910974587.3111318
    0.395962
    0.469413
    4758225.423323265151613.95348029
    7
    2025-02-17 00:00:00.000431588.790631-417099.78532572714489.00530527313227847.1446204368378.466059143-355977.33920745612401.12685168712006172.1930829
    0.395962
    0.469413
    5237724.811078175635853.30767164
    8
    2025-02-10 00:00:00.000101259.48381-883048.418386893-781788.93457689313213358.139315186594.226831427-755002.807593467-668408.58076204111993771.0662313
    0.395962
    0.469413
    5231987.715559485630032.05751281
    9
    2025-02-03 00:00:00.0003272660.84482-276397.1544037782996263.6904162213995147.0738922802106.46343847-236681.9120243072565424.5514141712662179.6469933
    0.395962
    0.469413
    5541546.425672425943791.73463406
    10
    2025-01-27 00:00:00.000168066.069-200483.190812304-32417.12181230410998883.3834758144176.050966485-171930.116149047-27754.06518256210096755.0955791
    0.395962
    0.469413
    4355139.862287834739548.09968108
    11
    2025-01-20 00:00:00.00079342.810661-135336.585728474-55993.77506747411031300.505288168149.00614613-116246.692360478-48097.68621434810124509.1607617
    0.395962
    0.469413
    4367975.810674884752576.21868063
    12
    2025-01-13 00:00:00.000476238.031851-172956.237642299303281.79420870111087294.2803555409785.876103282-148777.236065448261008.64003783410172606.846976
    0.395962
    0.469413
    4390147.217838144775153.89785956
    13
    2025-01-06 00:00:00.000111464.131598-166532.935515358-55068.80391735710784012.486146896019.902740722-143477.73963137-47457.8368906489911598.2069382
    0.395962
    0.469413
    4270059.152039684652633.04911348
    14
    2024-12-30 00:00:00.00059542.313359-245119.255955058-185576.94259605810839081.290064251383.824430747-211544.071249743-160160.2468189979959056.04382885
    0.395962
    0.469413
    4291864.30577644674910.37470183
    15
    2024-12-23 00:00:00.000239215.3566-261183.890374227-21968.53377422711024658.2326603206839.646758229-225830.244213608-18990.59745537910119216.2906478
    0.395962
    0.469413
    4365345.723120624750091.67664188
    16
    2024-12-16 00:00:00.000407322.34171379-952914.676724472-545592.33501068211046626.7664345352674.185732275-825100.746495765-472426.5607634910138206.8881032
    0.395962
    0.469413
    4374044.427690934759006.1099652
    17
    2024-12-09 00:00:00.000476665.557538477-1580225.20420998-1103559.6466715111592219.1014452413550.673042521-1370984.39514063-957433.72209811210610633.4488667
    0.395962
    0.469413
    4590078.259846434980769.27913287
    18
    2024-12-02 00:00:00.0003213302.967387-280383.3479747872932919.6194122112695778.74811672792240.26065362-243650.6420770922548589.6185765311568067.1709648
    0.395962
    0.469413
    5027045.944661775430201.11492411
    19
    2024-11-25 00:00:00.00089954.56941103-449387.931178819-359433.3617677899762859.1287044678314.530931255-391118.469046384-312803.9381151299019477.55238829
    0.395962
    0.469413
    3865721.226320084233860.01629925
    20
    2024-11-18 00:00:00.000198922.5671454-328592.497731433-129669.93058603310122292.4904723173482.729584745-286512.188127228-113029.4585424829332281.49050342
    0.395962
    0.469413
    4008043.179112374380694.25130168
    66
    14KB
    44s