flipside

    Top Reya Depositors
    mamad-5XN3k3Top Reya Depositors
    Updated 2025-02-01
    with enst as (
    select
    OWNER,
    ENS_DOMAIN
    from ethereum.ens.ez_ens_domains
    where ENS_SET = 'TRUE'
    )

    select
    --date_trunc('hour', block_timestamp) as date,
    --chain,
    distinct user as users,
    ENS_DOMAIN as Domain,
    round(sum(amt),2) as staked
    --round(3*sum(amt),2) as Liquidity
    --sum(sum(amt)) over ( order by date_trunc('hour', block_timestamp) asc) as cum_staked,
    --sum(3*sum(amt)) over ( order by date_trunc('hour', block_timestamp) asc) as cum_liquidity
    from(
    select
    distinct from_address as user,
    BLOCK_TIMESTAMP,
    amount as amt,
    AMOUNT_USD as usd_amt,
    'Ethereum' as chain
    from ethereum.core.ez_token_transfers
    where to_address = lower('0xdff78a949e47c1e90f3dd6dd7fe2fa72b42a75f7')

    UNION

    select
    distinct from_address as user,
    BLOCK_TIMESTAMP,
    amount as amt,
    AMOUNT_USD as usd_amt,
    'Arbitrum'
    from arbitrum.core.ez_token_transfers
    Last run: 3 months ago
    USERS
    DOMAIN
    STAKED
    1
    		0x8fdc70015562f288cddcafee5dfbc9218a695e9a33010065506.57
    2
    		0x653676c094b03e0bb5ea17637acb8c460c40559032346851259.55
    3
    		0xaf05e1ef1fe0862b3096cf1dbd58c662765659fd8522221.09
    4
    		0xccbf8dd3dd9a7f627873b2b34e4e365ed992cb958476556.6
    5
    		0xe5b49820e5a1063f6f4ddf851327b5e8b23010487056420
    6
    		0x0d64aec1fb1cdc5eb76c7fc93c5489377260558d6155565.97
    7
    		0x1be3d6c73e7af74a0ab818c4a95bd72f058f320a5828295.44
    8
    		0x4fd221f4ef5e4034047b454c6998a1aa8febb7ae5799678.49
    9
    		0x7309f40898866d9b10417e4db41c8a91aed5d5fe5728371.34
    10
    		0x51ba1b54434b396defa5cfdcd89bc8a6dcc8ede95147771.1
    11
    		0x0f1b9f69d532e60c2314e0e390486c08de0a2d3d5053407.96
    12
    		0x3ead4a9c2d4d8eff7fd534dc0dd396793dbacbe94971841.74
    13
    		0xe76a0f658ef48a6c18b146c2442491bf5757c1814888700.32
    14
    		0xc72c20edc92f3099b99e4cad1bf2f9b59e9b55064789282.33
    15
    		0x011089a473376bf27c7756e1ed0627ee13dee12d4769213.8
    16
    		0x42eadf6fe45b51b729c165c3f636b8ccaa35d7054578079.23
    17
    		0x530ece1581c8a1cc68c8537f0ab25a15f1b620374555158.49
    18
    		0x01a8e78b7ba1313a482630837c3978c6259ac1ea4158873.36
    19
    		0xb38e8c17e38363af6ebdcb3dae12e0243582891d4079943
    20
    		0x564aa5a2e98bdfcb876e8bcce129c18b6f052a0d4000000
    ...
    66121
    4MB
    19s