flipside

    Bera boyco liquidity
    neo_nguyenBera boyco liquidity
    Updated 17 hours ago
    with bera_price as(
    select
    date(hour) date,
    replace(replace(symbol, 'W', ''), 'USDC', 'USD') assets,
    avg(price) price
    from
    ethereum.price.ez_prices_hourly
    where
    token_address in (
    '0x2260fac5e5542a773aa44fbcfedf7c193bc2c599',
    '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2',
    '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'
    )
    group by
    1,
    2
    order by
    date desc
    limit
    3
    ), bera_boyco_db as(
    select
    *
    from
    $query('57d30540-aa06-48b3-8598-974c2536873e')
    ),
    bera_deposit as(
    select
    pool,
    symbol,
    contract_address,
    sum(amount) balance
    from
    ethereum.core.ez_token_transfers tb1
    join bera_boyco_db tb2 on tb1.to_address = tb2.contract
    group by
    Last run: about 17 hours agoAuto-refreshes every 12 hours
    POOL
    SYMBOL
    ASSET
    LIQUIDITY
    TOTAL_LIQUIDITY
    1
    		Ethena x ConcretectMSUSD127046255.769417420940711.256882
    2
    		Stakestone ETHBABYUNOUSD55144968.6719731420940711.256882
    3
    		Bedrock Uni BTCBABYUNOUSD53640441.031092420940711.256882
    4
    		Stakestone ETHThe Next EthereumUSD45792987.3278711420940711.256882
    5
    		Stakestone ETHSTONEETH16748030.0536219420940711.256882
    6
    		Stakestone ETHberaSTONEETH11416458.7534259420940711.256882
    7
    		Ether.fi BTCeBTCBTC4777062.81168005420940711.256882
    8
    		Ether.fi ETHweETHETH3025397.92067106420940711.256882
    9
    		Ether.fi BTCLBTCBTC1861137.31064354420940711.256882
    10
    		Bedrock Uni BTCuniBTCBTC573925.902946304420940711.256882
    11
    		Cian Pump BTCpumpBTCBTC270409.61456978420940711.256882
    12
    		Ether.fi ETHeETHETH180108.352535295420940711.256882
    13
    		Cian ETHrsETHETH163082.85245863420940711.256882
    14
    		Ether.fi ETHwstETHETH98824.212451503420940711.256882
    15
    		Ether.fi BTCWBTCBTC43576.156566925420940711.256882
    16
    		Stakestone BTCberaSBTCBTC31270.170610278420940711.256882
    17
    		UsualUSD0USD29485.471093705420940711.256882
    18
    		Stakestone BTCSBTCBTC18707.398041356420940711.256882
    19
    		Stakestone BTCWBTCBTC16873.961032949420940711.256882
    20
    		VaultCraftWETHETH15523.537214124420940711.256882
    29
    2KB
    214s