flipside

    1 - Meteora Top pools by TVL
    flyingfish1 - Meteora Top pools by TVL
    Updated 2025-04-15
    /* select
    livequery.utils.udf_api('https://flipsidecrypto.xyz/api/v1/queries/15843ffd-39db-4426-979b-df727f1bcb26/data/latest') as response
    */

    with meteora_pools as (

    select
    -- case
    -- when owner = 'LBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo' then 'Meteora DLMM'
    -- when owner = 'whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc' then 'Orca'
    -- end as program_name
    'Meteora' as program_name
    , account_address as pool_address

    from solana.core.fact_token_account_owners

    where 1 = 1
    and owner = 'LBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo'

    )

    , pools_tvl_init as (

    select
    block_timestamp
    , date_trunc(week, block_timestamp) as week_
    , program_name
    , account_address
    , owner
    , mint
    , symbol
    , price
    , balance
    , balance - pre_balance as delta
    , balance * price as token_usd_tvl
    , delta * price as transfer_usd_value
    Last run: 28 days ago
    WEEK_
    WEEK_CHAR
    PROGRAM_NAME
    POOL_ADDRESS
    POOL_SLUG
    POOL_TVL
    TVL_CHAR
    WEEKLY_RANK
    1
    		2025-04-21 00:00:00.0002025-04-21Meteora9d9mb8kooFfaD3SctgZtkxQypkshx6ezhbKio89ixyy2TRUMP-USDC408315343.283944 408,315,3431
    2
    		2025-04-21 00:00:00.0002025-04-21Meteora9DiruRpjnAnzhn6ts5HGLouHtJrT1JGsPbXNYCrFz2adMELANIA-USDC68700508.6111764 68,700,5092
    3
    		2025-04-21 00:00:00.0002025-04-21MeteoraAXXo7N2gcLeVyo8nDsN99UW8Fv6NCsa2DP21WD3SKtM3USDT-USDT26832162.76745 26,832,1633
    4
    		2025-04-21 00:00:00.0002025-04-21MeteoraA8nPhpCJqtqHdqUk35Uj9Hy2YsGXFkCZGuNwvkD3k7VCTRUMP-USDC18472261.7654347 18,472,2624
    5
    		2025-04-21 00:00:00.0002025-04-21MeteoraBoeMUkCLHchTD31HdXsbDExuZZfcUppSLpYtV3LZTH6UJITOSOL-SOL14229356.1768599 14,229,3565
    6
    		2025-04-21 00:00:00.0002025-04-21Meteora35ZnqaMNCyjYc9ja7bpiE55goiNVYU943A22Bb9YiLdBMELANIA-USDC8171010.20572696 8,171,0106
    7
    		2025-04-21 00:00:00.0002025-04-21MeteoraBVRbyLjjfSBcoyiYFuxbgKYnWuiFaF9CSXEa5vdSZ9HhSOL-USDC6531997.52572455 6,531,9987
    8
    		2025-04-21 00:00:00.0002025-04-21MeteoraCopraAQegh7HohkLgYayjoRENXsf66eYaDtwFpbr8zRZPAIN-SOL4611682.59556237 4,611,6838
    9
    		2025-04-21 00:00:00.0002025-04-21Meteora5rCf1DM8LjKTw4YqhnoLcngyZYeNnQqztScTogYHAS6SOL-USDC4010604.15137761 4,010,6049
    10
    		2025-04-21 00:00:00.0002025-04-21MeteoraC8Gr6AUuq9hEdSYJzoEpNcdjpojPZwqG5MtQbeouNNwgJUP-SOL3909473.40704494 3,909,47310
    11
    		2025-04-21 00:00:00.0002025-04-21Meteora4CTUHtiHrPHFT4Zc1qNScrposmM7xfupU7EVDWCR7PZwSOL-TRUMP3695125.29340549 3,695,12511
    12
    		2025-04-21 00:00:00.0002025-04-21MeteoraENERLy2pi2mK2dYngha6rwA5ywW2Dwv5dacgafW3X59CENRON-USDC3406181.9512957 3,406,18212
    13
    		2025-04-21 00:00:00.0002025-04-21MeteoraARwi1S4DaiTG5DX7S4M4ZsrXqpMD1MrTmbu9ue2tpmEqUSDC-USDT3185743.74251918 3,185,74413
    14
    		2025-04-21 00:00:00.0002025-04-21MeteoraASSBTtJAMEfH53ZgsnaNDegwb6tzX8sXHQZEqkhQbXSPJLP-USDC3182195.64095868 3,182,19614
    15
    		2025-04-21 00:00:00.0002025-04-21MeteoraBGm1tav58oGcsQJehL9WXBFXF7D27vZsKefj4xJKD5YSOL-USDC2718233.31768547 2,718,23315
    16
    		2025-04-21 00:00:00.0002025-04-21MeteoraF1KKNyUCsQcZLRjwQ4abX6Ri8gDAQ46nHwSHFKA5sFQvCLOUD-USDC2712318.87285647 2,712,31916
    17
    		2025-04-21 00:00:00.0002025-04-21Meteora44AFUHN78Zn1tPSEtg3fmpnVCoBNMf3k7WnDJRVBNhP9CBBTC-TRUMP1859002.89572852 1,859,00317
    18
    		2025-04-21 00:00:00.0002025-04-21Meteora4kdxjt8pKEW4qV4ji4HANixwswDJw3Egn8L4x2BEWQqTSOL-WBTC1831489.20885869 1,831,48918
    19
    		2025-04-21 00:00:00.0002025-04-21MeteoraJ2Gsg3xTDjM8UZjKdEqzBeDwitHb2Ux6TSBX5RzsE42rJLP-SOL1716826.45218018 1,716,82619
    20
    		2025-04-21 00:00:00.0002025-04-21MeteoraH8ctnvYCibuM3REZJLLJ354Mm9jnQUWPG7eJtdBS5bEfIO-USDC1647924.47689386 1,647,92420
    ...
    1700
    254KB
    174s