MasiOverview of Top Holders
    Updated 2025-03-08
    with tb0 as ( select trunc(hour,'day') as day,
    avg(price) as price
    from crosschain.price.ez_prices_hourly
    where token_address = lower('0xc383a3833a87009fd9597f8184979af5edfad019')
    and day = current_date - 1
    group by 1)
    ,
    tb1 as (select origin_from_address,
    count(distinct tx_hash) as wrap_tx,
    count(distinct origin_from_address) as wrapper,
    sum(amount) as wrap_amount,
    sum(amount*price) as wrap_usd,
    avg(amount*price) as avg_usd,
    median(amount*price) as median_usd,
    max(amount*price) as max_usd
    from ink.core.ez_token_transfers , tb0
    where from_address = '0x0000000000000000000000000000000000000000'
    and contract_address = '0x11476323d8dfcbafac942588e2f38823d2dd308e'
    group by 1)
    ,
    tb2 as (select origin_from_address,
    count(distinct tx_hash) as unwrap_tx,
    count(distinct origin_from_address) as unwrapper,
    sum(amount) as unwrap_amount,
    sum(amount*price) as unwrap_usd,
    avg(amount*price) as avg_usd,
    median(amount*price) as median_usd,
    max(amount*price) as max_usd
    from ink.core.ez_token_transfers , tb0
    where to_address = '0x0000000000000000000000000000000000000000'
    and contract_address = '0x11476323d8dfcbafac942588e2f38823d2dd308e'
    group by 1)

    select coalesce(a.origin_from_address,b.origin_from_address) as "Wallet Address",
    coalesce(wrap_tx,0) as "Wrap Txn",
    coalesce(unwrap_tx,0) as "Unwrap Txn",
    Last run: about 2 months ago
    Wallet Address
    Wrap Txn
    Unwrap Txn
    Wrapper
    Unwrapper
    Wrap Amount (iETH)
    Unwrap Amount (iETH)
    Wrap Amount (USD)
    Unwrap Amount (USD)
    Current Supply (iETH)
    Current Supply (USD)
    Avg Wrap (USD)
    Median Wrap (USD)
    Max Wrap (USD)
    Avg Unwrap (USD)
    Median Unwrap (USD)
    Max Unwrap (USD)
    1
    0x74ad7bdb7e08736c9eb818b2e00b53f65adde91910105.992318577015216.78143907505.99231857715216.78143907515216.78143907515216.78143907515216.781439075000
    2
    0x10d84b741b182d5a6aed37f30a54e63b697f699410104.971775584012625.23369803604.97177558412625.23369803612625.23369803612625.23369803612625.233698036000
    3
    0xce201d372ec99e288e4e849b5bc4dc7e5d95248c10103.50484332408900.13342133303.5048433248900.1334213338900.1334213338900.1334213338900.133421333000
    4
    0xd28530888d6c47c7c43840b7fe98850d8bc2085d21113.066118746-0.17786.044452986-253.9381252.9661187467532.1063279863893.0222264933893.0222264937532.106327986253.938125253.938125253.938125
    5
    0x45aecad3551f5c628e07a2a2b190bce2229fde5a30102.7564186706999.59788748402.756418676999.5978874842333.1992958283108.2259360113638.664539672000
    6
    0xd1c7e310ad36b0384b6666f9c72898069e133c61312112.64116114-0.21127071246706.915076336-536.4968857042.4298904276170.418190632216.35209923787.3975947221154.77339126268.248442852268.248442852511.103073204
    7
    0xe66dfe29097ade951da9eb8abd55f1c8460c4fcb21114.457266261-2.2811318.698369335-5789.789252.1772662615528.9091193355659.3491846685659.3491846685760.4089915375789.789255789.789255789.78925
    8
    0xb188daddde4df91fd4cc4aadc5334873099d4b9410102.09543124605321.09881713802.0954312465321.0988171385321.0988171385321.0988171385321.098817138000
    9
    0x891342f99726da3aed11e05ff0c7a29137bc8c5810101.98271983205034.88156591601.9827198325034.8815659165034.8815659165034.8815659165034.881565916000
    10
    0x3d97e13a1d2bb4c9ce9ea9d424d83d3638f052ad10101.64709925904182.61297453101.6470992594182.6129745314182.6129745314182.6129745314182.612974531000
    11
    0xb6f28ae8f31d85dc27361852b986286113bc588d41111.588240531-0.27282968984033.148226039-692.8185986741.3154108423340.3296273651008.28705651662.6893154962530.240129276692.818598674692.818598674692.818598674
    12
    0xf9a19c19a6be406ade2b091d2ae9d120de3fc9cb20100.996605999102530.76258764200.99660599912530.7625876421265.3812938211265.3812938212528.233965157000
    13
    0xfd1f937df2e64019d4e1e7eec745a61176ab2cbe10100.749687531801903.74246161800.74968753181903.7424616181903.7424616181903.7424616181903.742461618000
    14
    0x451ff8ecd1dd92017e70454f3120fada936f73a310100.746299036901895.13778107900.74629903691895.1377810791895.1377810791895.1377810791895.137781079000
    15
    0xeb0e6ecd0e78b0a84ecd9663a041f453c454a99d30100.654315737501661.55711535300.65431573751661.557115353553.852371784126.6741968861524.774302895000
    16
    0x3094ea2500822117a3518cf76518c4f2ec1f01ca31110.7306181911-0.111855.318135353-279.33193750.62061819111575.986197853618.439378451561.7571420641291.026882393279.3319375279.3319375279.3319375
    17
    0x35efc6f6c5a5df88029cbcc935fb53f6fbe8347520100.513483851501303.93126477700.51348385151303.931264777651.965632388651.9656323881291.271992942000
    18
    0xea369b9b08e6247404d775e83bdae0adb8a9ab1320100.507523092901288.79462597800.50752309291288.794625978644.397312989644.397312989657.031826287000
    19
    0xce9d5fdc295da5c25c5b216dedc30bc4b924737310100.500728467901271.54048274700.50072846791271.5404827471271.5404827471271.5404827471271.540482747000
    20
    0x83ed0969db692d47e801ed9dd93afb0755be264121111.4952403-0.99721887873796.985182-2532.3189227020.49802142131264.6662592991898.4925911898.4925912532.3189227022532.3189227022532.3189227022532.318922702
    100
    16KB
    8s