h4wkRaydium Top LP List
    Updated 2024-11-30
    -- forked from overview_archive @ https://flipsidecrypto.xyz/edit/queries/69530376-ed21-44af-af94-759a16270430

    with pools as (
    select address as pool_address,
    upper(substring(address_name,9, len(address_name) - 13)) as pool_name
    from (
    select distinct LIQUIDITY_POOL_ADDRESS
    from solana.defi.fact_liquidity_pool_actions
    where 1 = 1
    and program_id in (
    '5quBtoiQqxF9Jv6KYKctB59NT3gtJD2Y65kdnB1Uev3h',
    '27haf8L6oxUeXrHrgEgsexjSY5hbVUWEmvv9Nyxg8vQv',
    '675kPX9MHTjS2zt1qfr1NYHuzeLXfQM9H24wFSUt1Mp8',
    'CAMMCzo5YL8w4VFF8KVHrK22GGUsp5VTaW7grrKgrWqK')
    ) left join solana.core.dim_labels l on (LIQUIDITY_POOL_ADDRESS = address)
    -- where pool_name != 'UNKNOWN-USDC'
    )

    , latest_price as (
    select upper(symbol) as price_symbol,
    price as latest_price
    from solana.price.ez_prices_hourly
    where price_symbol not in ('BOO', 'SFI', 'COPE',
    'PEPE', 'KITTY', 'ICE', 'SCS', 'BULL', 'MEME', 'WHEY', 'BSAMO',
    'GXE', 'KS', 'COW', 'XENO', 'SMRT', 'GEAR', 'ZEE', 'BIRD', 'INU', 'VRS', 'AVAX', 'MMAPS',
    'STAR') -- Causing ERROR
    qualify row_number() over (partition by price_symbol order by hour desc) = 1
    )
    , base as (
    select block_timestamp,
    action,
    upper(symbol) as token,
    program_id,
    pool_name,
    pool_address,
    amount,
    Last run: about 2 months ago
    POOL_NAME
    DATE_CREATED
    TX_COUNT
    🟢 Deposit TXs
    🟡 Withdrawal TXs
    POOL_ADDRESS
    1
    RAY-SOL2021-07-29 00:00:00.00045456537082283743AVs9TA4nWDzfPJE9gGVNJMVhcQy3V9PGazuz33BfG2RA
    2
    RAY-USDC2021-05-21 00:00:00.000413366349783635836UmmUiYoBjSrhakAobJw8BvkmJtDVxaeBtbt7rxWo1mg
    3
    STEP-USDC2021-04-25 00:00:00.000389197333804553934Sx1NLrQiK4b9FdLKe2DhQ9FHvRzJhzKN3LoD6BrEPnf
    4
    RAY-USDT2021-03-25 00:00:00.00036385630847955377DVa7Qmb5ct9RCpaU7UTpSaf3GVMYz17vNVU67XpdCRut
    5
    ATLAS-RAY2021-09-02 00:00:00.00029019124438845802F73euqPynBwrgcZn3fNSEneSnYasDQohPM5aZazW9hp2
    6
    SOL-USDC2021-03-30 00:00:00.0002685922030406555258oQChx4yWmvKdwLLZzBi4ChoCc2fqCUWBkwMihLYQo2
    7
    RAY-SRM2021-07-29 00:00:00.00024306620187141195GaqgfieVmnmY4ZsZHHA6L5RSVzCGL3sKx4UgHBaYNy8m
    8
    Unknown LP2021-03-16 00:00:00.0002179042077311834
    9
    SAMO-RAY2021-07-08 00:00:00.00020782316356344260EyDgEU9BdG7m6ZK4bYERxbN4NCJ129WzPtv23dBkfsLg
    10
    POLIS-RAY2021-09-02 00:00:00.000177018148773282445tho4By9RsqTF1rbm9Akiepik3kZBT7ffUzGg8bL1mD
    11
    DFL-USDC2021-11-24 00:00:00.000176296135056412398GJdzPuEBPP3BHJpcspBcfpRZV4moZMFwhTAuXebaPL8
    12
    STARS-USDC2021-11-10 00:00:00.00016613813525730880CWQVga1qUbpZXjrWQRj6U6tmL3HhrFiAT11VYnB8d3CF
    13
    CAVE-USDC2021-10-23 00:00:00.000159087122855362312PfKnjEfoUoVDbDS1YwvZ8HuPGBCpN831mnTuqTAJZjH
    14
    SOL-USDT2021-03-31 00:00:00.000158061130610274517XawhbbxtsRcQA8KTkHT9f9nc6d69UwqCDh6U5EEbEmX
    15
    GENE-USDC2021-11-18 00:00:00.00014956412017229391Enq8vJucRbkzKA1i1PahJNhMyUTzoVL5Cs8n5rC3NLGn
    16
    REAL-USDC2021-12-10 00:00:00.00014131511270628608A7ZxDrK9LSkVXhfRTu2pRCinwYfdxW2kK6DaJk12jRWw
    17
    LIKE-USDC2021-08-03 00:00:00.00013975212471115041GmaDNMWsTYWjaXVBjJTHNmCWAKU6cn5hhtWWYEZt4odo
    18
    GENE-RAY2021-11-18 00:00:00.000133834107239265948FrCybrh7UFznP1hVHg8kXZ8bhii37c7BGzmjkdcsGJp
    19
    MBS-USDC2021-12-21 00:00:00.00012721099122280876eRECBcCVP82AvAd6Di4rZApa2btLf8RDUqrTigt4hS4
    20
    GRAPE-USDC2021-09-14 00:00:00.00012357410390219671vVXfY15WdPsCmLvbiP4hWWECPFeAvPTuPNq3Q4BXfhy
    100
    10KB
    109s