AzinStable coin TVL of pools
    Updated 2024-11-30
    with t1 as
    (select
    *
    from
    sei.core.dim_tokens
    where
    (SYMBOL like 'us%'
    OR
    SYMBOL like 'US%'
    OR
    SYMBOL like 'Us%'
    OR
    SYMBOL like 'uS%')
    and
    SYMBOL not in ('USDX','USEDCAR','usei','USEI','USK','USTC','USTRD')
    )

    ,
    jj as
    (select
    PLATFORM ,
    date_trunc('day',BLOCK_TIMESTAMP) as date,
    LIQUIDITY_PROVIDER_ADDRESS ,
    LP_ACTION,
    POOL_ADDRESS,
    TOKEN1_AMOUNT/pow(10,DECIMALS) as amount1 ,
    SYMBOL as symbol1 ,
    TOKEN1_CURRENCY,
    TOKEN2_CURRENCY,
    TOKEN2_AMOUNT


    from
    sei.defi.fact_lp_actions a left join sei.core.dim_tokens b
    on a.TOKEN1_CURRENCY=b.CURRENCY
    where
    Last run: about 1 month ago
    POOL_ADDRESS
    ADD
    REMOVE
    TVL
    1
    sei1ltr0r989uds8y0gahfl6uqec5rqulks06fyugpre0syml8ul0jtsjgv69c1564654.6728131226712.466333337942.20648
    2
    sei1rlze8sq5ju67fn26sg5agpgh55v3kw5lvkh5q7pfj94wlvv9gegs3mzyn51503136.8547741176737.17246326399.682314
    3
    sei1yyxck25qx4kx8xm9w47rhcn8sry0jkgf47v8dwtagewegwnzw5lqs560ps1000000766602.85059233397.14941
    4
    sei1wg3n328hs2ps8jnjaanuhpsmk4prdzf69f0kdvz79sh738xw2htsx394lp251347.584639121702.925839129644.6588
    5
    sei1crjupg8yp8ltusnq9z9kxd8az4m79gpwcsa6tkzm5wr0lywwqdwq0mc4zw1826031.4251431715384.847556110646.577587
    6
    sei1a33ff50xnw9ylls5zw485wddp5x7z24g8kx3u9u9lpara67wrc4s2804fp96356.3403534254.19589392102.14446
    7
    sei10etq43u6fq26g58rfkt7l4ypm6fsgpm02tjdtdaz9u7mesy9p8nqrld6vh90001.82110675162.1122414839.708866
    8
    sei1m4t2zv2nj9d8qequs5t0phld49dh0gdnra50cp232vuhjmv9qx5qrl54cp15056.22613211831.8563663224.369766
    9
    sei1j24sqmw2206jtgllp23kqfcd58rjspus4w485lqrwt0ghyup0r3qcf56x229305.17457526997.7760462307.398529
    10
    sei1m8jw0zxw3n6m5a4n0g6k7vzt6c2ycxyk33ct567tz3mcqlct226qq9nqe366695.87941965230.1536871465.725732
    11
    sei1mmn28xt7l2d905gllhw4d2mr3j2kzstqscjypp460rwm8xqqvu6q0ey37s451106.1177450103.014241003.10346
    12
    sei184s83umu3gf64vg7h4nymhwzyle69szv2t0dwjp5t8wjr48t6qdqz2mhnv416.5002450416.500245
    13
    sei1fux2qdga9p8p282zvjpagcspgpkjdje95a7n2lty5n2d69fr503qstgrfc1607.3887911377.879099229.509692
    14
    sei1samxhhlgtfgqlx0ek79fn0edvpu473nc6lhmwzz38w840fk33mhqcfpcq73595.4733593483.435693112.037666
    15
    sei1wdevr63c7grqhk6zc9lys70azq057yzna6vg4qynf6apc8fth47sq598z071.702152071.702152
    16
    sei1de0llwr6j2rytlteczn9pzqjjtmt2nf6f6qd7r8nlwd79srwvs8q48uz9z171.608487103.07058268.537905
    17
    sei1jc4gk0ua02kvrpggat77r25226h6hg5rrfwlywu7zclkdscjwlhqep7nwm1310.2888251268.98404341.304782
    18
    sei1e7kcd62rqsc9zu5a8xyecr367e88zvuysnfnm3yhvjkmtdxwelcscs88ny55.55996324.03759331.52237
    19
    sei1q8p46phncrz6qq5j32kf0nen5svg45vqqxz9egtexcl0h6mgdwjqej4d3h41.98771825.11313516.874583
    20
    sei1f08dl9tkntsjmxx2txccthvx9n0mdcyqajvg4yyuuyh76sgef5dsfpsnhe103.3804367588.2739226415.10651411
    37
    4KB
    3s