Pine Analyticsrepulsive-pink
    Updated 2025-06-13
    with tab1 as (
    SELECT
    date(hour) as date,
    'USDC' as token,
    sum(
    CASE when type like 'mint' then volume else -volume end
    ) as net_mint,
    sum(net_mint) over (order by date) as supply
    FROM (
    SELECT
    date_trunc('hour', block_timestamp) as hour,
    'mint' as type,
    tx_id,
    --tx_to as wallet,
    mint_amount/power(10, 6) as volume
    FROM eclipse.defi.fact_token_mint_actions
    where mint like 'AKEWE7Bgh87GPp171b4cJPSSZfmZwQ3KaqYqXoKLNAEE'
    and succeeded
    UNION all
    SELECT
    date_trunc('hour', block_timestamp) as hour,
    'burn' as type,
    tx_id,
    --signers[0] as wallet,
    burn_amount/power(10, 6) as volume
    FROM eclipse.defi.fact_token_burn_actions
    where mint like 'AKEWE7Bgh87GPp171b4cJPSSZfmZwQ3KaqYqXoKLNAEE'
    and succeeded
    )
    GROUP BY 1,2
    Last run: 22 days ago
    DATE
    TOKEN
    NET_MINT
    SUPPLY
    DATE1
    WIF_PRICE
    SOL_PRICE
    ORCA_PRICE
    TVL_USD
    1
    2024-12-15 00:00:00.000USDC114307.63994248712.410642024-12-15 00:00:00.0002.83219.94.964248712.41064
    2
    2025-04-22 00:00:00.000USDC39545.60807613603316.6798952025-04-22 00:00:00.0000.436898139.9252.69513603316.679895
    3
    2025-03-28 00:00:00.000USDC458644.31013318296538.9236612025-03-28 00:00:00.0000.482951131.0977500012.72518296538.923661
    4
    2025-03-10 00:00:00.000USDC-61083.36319716399193.8686762025-03-10 00:00:00.0000.45766126.9898712251.5416399193.868676
    5
    2025-04-22 00:00:00.000WIF-93.892512656.6507182025-04-22 00:00:00.0000.436898139.9252.6955529.665385393
    6
    2024-12-15 00:00:00.000WIF-59819.2958312885.138262024-12-15 00:00:00.0002.83219.94.9636464.9412758
    7
    2025-03-28 00:00:00.000WIF-119480.4437182025-03-28 00:00:00.0000.482951131.0977500012.7259408.099774052
    8
    2025-03-10 00:00:00.000WIF87.886619734.150692025-03-10 00:00:00.0000.45766126.9898712251.549031.531404785
    9
    2025-04-22 00:00:00.000SOL-1050.30807465635475.5752522272025-04-22 00:00:00.0000.436898139.9252.6954963919.86716787
    10
    2025-03-10 00:00:00.000SOL852.47023753844358.668881442025-03-10 00:00:00.0000.45766126.9898712251.545633101.64897602
    11
    2025-03-28 00:00:00.000SOL248.03418410743560.1089967242025-03-28 00:00:00.0000.482951131.0977500012.7255710632.27927669
    12
    2024-12-15 00:00:00.000SOL226.5179266386023.413629782024-12-15 00:00:00.0002.83219.94.961324548.65718862
    13
    2025-04-22 00:00:00.000USDT-63489.071068958336.2243222025-04-22 00:00:00.0000.436898139.9252.695958336.224322
    14
    2025-03-28 00:00:00.000USDT85476.4777151770220.6087922025-03-28 00:00:00.0000.482951131.0977500012.7251770220.608792
    15
    2024-12-15 00:00:00.000USDT17959.294736637.7318232024-12-15 00:00:00.0002.83219.94.9636637.731823
    16
    2025-03-10 00:00:00.000USDT51352.05321416268.1243362025-03-10 00:00:00.0000.45766126.9898712251.541416268.124336
    17
    2025-04-22 00:00:00.000ORCA4.682725510.947012025-04-22 00:00:00.0000.436898139.9252.69568752.00219195
    18
    2024-12-15 00:00:00.000ORCA-196.861418308.988852024-12-15 00:00:00.0002.83219.94.9690812.584696
    19
    2025-03-28 00:00:00.000ORCA-1054.661723914.6044652025-03-28 00:00:00.0000.482951131.0977500012.72565167.297167125
    20
    2025-03-10 00:00:00.000ORCA-0.00271131028.8034412025-03-10 00:00:00.0000.45766126.9898712251.5447784.35729914
    ...
    1229
    148KB
    10s