Updated 2 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 2 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-04-14 00:00:00.0003054464.989525-191691.9970286662862772.9924963422003438.52020272575049.43641105-161637.516127612413411.9202834419438199.8212673
    0.679143
    0.802406
    14943481.24692615597328.1657838
    2
    2025-04-07 00:00:00.0002898786.884-509282.4410908612389504.4429091419140665.52770642448067.4993283-430208.0410421592017859.4582861417024787.9009839
    0.679143
    0.802406
    12999249.008483113660791.9604769
    3
    2025-03-31 00:00:00.000346839.613898-95803.578856486251036.03504151416751161.0847973293227.022238926-81022.589308739212204.43293018815006928.4426977
    0.679143
    0.802406
    11376433.792612512041649.4239913
    4
    2025-03-24 00:00:00.000117347.62-536345.959965633-418998.33996563316500125.049755799353.509591711-453983.975980008-354630.46638829714794724.0097675
    0.679143
    0.802406
    11205944.426666311871375.3137815
    5
    2025-03-17 00:00:00.000188436.15368-707438.41780822-519002.2641282216919123.3897214159781.846740324-599895.666721202-440113.81998087815149354.4761558
    0.679143
    0.802406
    11490504.216265512155932.9277943
    6
    2025-03-10 00:00:00.0001142346.912947-867279.954315669275066.95863133117438125.6538496970949.271679791-736724.491706042234224.7799737515589468.2961367
    0.679143
    0.802406
    11842980.970932412509082.8976299
    7
    2025-03-03 00:00:00.0005717424.801217-571240.0063307265146184.7948862717163058.69521834866599.87039965-485943.6653684344380656.2050312215355243.516163
    0.679143
    0.802406
    11656171.171446612321139.5288303
    8
    2025-02-24 00:00:00.000373280.278733-1584253.52302137-1210973.2442883712016873.900332318191.216169498-1349776.09812068-1031584.8819511910974587.3111318
    0.679143
    0.802406
    8161175.791293178806074.70597599
    9
    2025-02-17 00:00:00.000431588.790631-417099.78532572714489.00530527313227847.1446204368378.466059143-355977.33920745612401.12685168712006172.1930829
    0.679143
    0.802406
    8983599.793338919633824.60476291
    10
    2025-02-10 00:00:00.000101259.48381-883048.418386893-781788.93457689313213358.139315186594.226831427-755002.807593467-668408.5807620411993771.0662313
    0.679143
    0.802406
    8973759.686808879623873.86617035
    11
    2025-02-03 00:00:00.0003272660.84482-276397.1544037782996263.6904162213995147.0738922802106.46343848-236681.9120243072565424.5514141712662179.6469933
    0.679143
    0.802406
    9504706.1692042210160208.9218253
    12
    2025-01-27 00:00:00.000168066.069-200483.190812304-32417.12181230410998883.3834758144176.050966485-171930.116149047-27754.06518256210096755.0955791
    0.679143
    0.802406
    7469814.657703888101696.86922326
    13
    2025-01-20 00:00:00.00079342.810661-135336.585728474-55993.77506747411031300.505288168149.00614613-116246.692360477-48097.68621434810124509.1607617
    0.679143
    0.802406
    7491830.519062858123966.89765014
    14
    2025-01-13 00:00:00.000476238.031851-172956.237642299303281.79420870111087294.2803555409785.876103282-148777.236065448261008.64003783410172606.846976
    0.679143
    0.802406
    7529858.29944358162560.76965465
    15
    2025-01-06 00:00:00.000111464.131598-166532.935515358-55068.80391735710784012.486146896019.902740722-143477.73963137-47457.8368906489911598.2069382
    0.679143
    0.802406
    7323886.591879227953125.87083645
    16
    2024-12-30 00:00:00.00059542.313359-245119.255955058-185576.94259605810839081.290064251383.824430747-211544.071249743-160160.2468189979959056.04382885
    0.679143
    0.802406
    7361286.184578077991206.32390453
    17
    2024-12-23 00:00:00.000239215.3566-261183.890374227-21968.53377422711024658.2326603206839.646758229-225830.244213608-18990.59745537910119216.2906478
    0.679143
    0.802406
    7487319.466103598119719.86691357
    18
    2024-12-16 00:00:00.000407322.34171379-952914.676724472-545592.33501068211046626.7664345352674.185732275-825100.746495765-472426.5607634910138206.8881032
    0.679143
    0.802406
    7502239.242036618134958.03625535
    19
    2024-12-09 00:00:00.000476665.557538477-1580225.20420998-1103559.6466715111592219.1014452413550.673042521-1370984.39514063-957433.72209811210610633.4488667
    0.679143
    0.802406
    7872774.457212778514035.94317134
    20
    2024-12-02 00:00:00.0003213302.967387-280383.3479747872932919.6194122112695778.74811672792240.26065363-243650.6420770922548589.6185765311568067.1709648
    0.679143
    0.802406
    8622249.26633229282286.5063852
    68
    14KB
    241s