MoDeFiGPC - tokens trades liqudity week 1
    Updated 2025-04-07
    with tokens_data as (
    select *
    from $query('75f58bb3-b2cd-4208-85e9-e3d75d901a1c')
    ),

    tokens_supply as (
    select *
    from $query('d113b02b-ad6c-4fc4-8bfb-df28c696d7da')
    ),

    tokens_pool as (
    select *
    from $query('998239b1-00be-4fa2-8c02-617cd563917c')
    ),

    tokens_pools_balance as (
    select token_address, b.symbol, replace(pair_symbol,'WMATIC','WPOL') as pair_symbol, b.pool_address,
    sum(change) as balance
    from
    (select *, case when from_address in (select pool_address from tokens_pool) then from_address else to_address end as pool_address,
    case when from_address in (select pool_address from tokens_pool) then -AMOUNT_PRECISE else AMOUNT_PRECISE end change
    from polygon.core.ez_token_transfers
    where (from_address in (select pool_address from tokens_pool) or to_address in (select pool_address from tokens_pool))
    and contract_address in ('0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270','0xc2132d05d31c914a87c6611c10748aeb04b58e8f',
    '0x7ceb23fd6bc0add59e62ac25578270cff1b9f619','0x2791bca1f2de4661ed88a30c99a7a9449aa84174','0x3c499c542cef5e3811e1192ce70d8cc03d5c3359')
    and BLOCK_TIMESTAMP>='2023-04-09'
    and from_address!=to_address
    union all
    select *, case when to_address in (select pool_address from tokens_pool) then to_address else from_address end as pool_address,
    case when to_address in (select pool_address from tokens_pool) then AMOUNT_PRECISE else -AMOUNT_PRECISE end change
    from polygon.core.ez_token_transfers
    where (from_address in (select pool_address from tokens_pool) and to_address in (select pool_address from tokens_pool))
    and contract_address in ('0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270','0xc2132d05d31c914a87c6611c10748aeb04b58e8f',
    '0x7ceb23fd6bc0add59e62ac25578270cff1b9f619','0x2791bca1f2de4661ed88a30c99a7a9449aa84174','0x3c499c542cef5e3811e1192ce70d8cc03d5c3359')
    and BLOCK_TIMESTAMP>='2023-04-09'
    and from_address!=to_address) a
    Last run: 11 days ago
    TOKEN_ADDRESS
    SYMBOL
    WPOL
    WPOL_USD
    WETH
    WETH_USD
    USDC_USDT
    TOTAL_LIQUIDITY_USD
    1
    0x784665471bb8b945b57a76a9200b109ee214e789KC18946.9602457727915.82772030900126.8120738042.639793309
    2
    0xa76164b3d0a2f35b140ec57f1552f7d6987e06dbWORDS6062.4313486742532.8158976330002532.815897633
    3
    0x162539172b53e9a93b7d98fb6c41682de558a320GONE44269.09149150418495.1304608110.0000038952205380.010063808640.36289818495.503422619
    4
    0xd7b0c417365b63f098c1c4ad2ced35982d648876NOMAD2542.1333059991062.074814710001062.07481471
    5
    0x560d5b84d081b3a91e1cea3a9713473303124730VOCATE4977.1761400422079.4084300150002079.408430015
    6
    0x90880ee788963585525241bac32e7c99c3d0630fBORGER21.20311448.8584236490008.858423649
    7
    0x0f29965ca5f1111b073efa37a739dd2fafab11e0XENX1.0180113760.42531374760000.4253137476
    8
    0xe581b4854682f793c83a87e834b7d2a688d785c6FMJ290.095097444121.198481661000121.198481661
    9
    0x75c0a194cd8b4f01d5ed58be5b7c5b61a9c69d0aDHG2089.503451356872.9711324340.08017271809207.1366396501080.107772084
    10
    0x2fc359fc903040ac5d34ff9d50802e1fe0ced8feLZR1902.826788654794.97971417000794.97971417
    11
    0x45a04faf46aca702f1d1185988e97a1e1bd42673KFC1937.716089551809.556073206000809.556073206
    12
    0xfca466f2fa8e667a517c9c6cfa99cf985be5d9b1SPEPE22953.9423936989589.8999698890009589.899969889
    13
    0xc760a77356563560260c9e571af6dbbab396be38PEAR00002062.8422122062.842212
    14
    0x2b62ab4f6537cc3e7a90cdc2284a8103f9bd5822IMPACT906.036786584378.532018742000378.532018742
    15
    0x1d9ccbe51cc6b4deeeca686d409561cf9f801fbcNEUS3500.0893653821462.2981239550001462.298123955
    16
    0x20fc765a33b81e248c5ce2fae2adaffe243db0e0BIBLE3614.4089681591510.0595732270001510.059573227
    17
    0x8a953cfe442c5e8855cc6c61b1293fa648bae472PolyDoge102864.3957169742975.5920995790039.88243243015.474531579
    18
    0x64f6f111e9fdb753877f17f399b759de97379170EGP407.33069707170.1782017470.43324478391119.34422110101289.522422848
    19
    0xfec68cbf04f7c069628cf9e9c609abc95f9a476bKIRANA2303.084915345962.203075249000962.203075249
    20
    0xaf3b9202f8b324830d9b6c4ddfb447a0ba7f7fc5HIN51.50167525121.51682292600021.516822926
    40
    4KB
    47s