flipside

    8. Tiered User Analysis by Deposit Size
    hbd19948. Tiered User Analysis by Deposit Size
    Updated 2 hours ago
    with prices as
    (select
    hour,
    token_address,
    price,
    row_number() over (partition by token_address order by hour desc) as orders
    from ethereum.price.ez_prices_hourly
    where token_address in ('0x2260fac5e5542a773aa44fbcfedf7c193bc2c599','0xcd5fe23c85820f7b72d0926fc9b05b43e359b7ee','0x4c9edd5852cd905f086c759e8383e09bff1e68b3','0xa1290d69c65a6fe4df752f95823fae25cb99e5a7','0x83f20f44975d03b1b09e64809b757c47f942beea')
    QUALIFY orders = 1),

    base as (
    select
    case
    when to_address = '0x8bc93498b861fd98277c3b51d240e7e56e48f23c' then 'Deposit'
    else 'Withdraw' end as action,
    BLOCK_TIMESTAMP,
    TX_HASH,
    ORIGIN_FROM_ADDRESS,
    ORIGIN_TO_ADDRESS,
    CONTRACT_ADDRESS,
    SYMBOL,
    FROM_ADDRESS,
    TO_ADDRESS,
    CASE
    WHEN ACTION = 'Deposit' then AMOUNT
    else AMOUNT * (-1) end as volume,
    CASE
    WHEN ACTION = 'Deposit' then AMOUNT_USD
    else AMOUNT_USD * (-1) end as volume_usd
    from ethereum.core.ez_token_transfers
    where (to_address = '0x8bc93498b861fd98277c3b51d240e7e56e48f23c' or from_address = '0x8bc93498b861fd98277c3b51d240e7e56e48f23c')
    and symbol != 'BTCN'
    and symbol != 'Earn $TUSD airdrops at https://www.tenorusd.org'),

    final as (
    select
    Last run: about 2 hours agoAuto-refreshes every 12 hours
    Net Deposit Level
    Number of Users
    1
    		No Deposit Left8949
    2
    		a. 0 - 100 $3632
    3
    		b. 100 - 250 $432
    4
    		c. 250 - 500 $161
    5
    		d. 500 - 1500 $168
    6
    		e. 1500 - 5000 $85
    7
    		f. 5000 - 10000 $21
    8
    		g. 10000 - 50000 $8
    9
    		h. > 50000 $2
    10
    		20535
    10
    224B
    60s