USER | TRANSFER_COUNT | TOTAL_USD_VOLUME | |
|---|---|---|---|
1 | 0x92eaaf32c0008dba1b228cd622f06aff14e1672b | 12 | 5112399.618979 |
2 | 0x56b4b18f6293252fc5eec4e5df1915f7218d04fc | 403 | 3298345.4138782 |
3 | 0x4675a6d0920adb300242db2d3de125623d0e5ec5 | 24 | 1950104.144863 |
4 | 0x74c77c2a5d0a2aa6a99b757b00cbd61c67dbd1c6 | 2 | 612562.700613 |
5 | 0xf64db6d105c7dea5a40c22593631de99a837db1e | 1 | 500000 |
6 | 0xaebeea38207c2bc71449d7ceae8afa1cd6aece88 | 34 | 393409.955522375 |
7 | 0x25ebab74687236c711a612da494c79eac2a0f250 | 4 | 352635.594941 |
8 | 0x78d293ab4dd4c004f4f49dc4a05b3a5508f9fb9b | 3 | 275916.199835 |
9 | 0xa432ca1edabf81a8373fe2d655a2811ed2634e45 | 4 | 250010 |
10 | 0xfb9a6aa7720b37610799a57064c38d2bb7ce0cd2 | 5 | 222595.395356 |
Afonso_DiazTop users
Updated 9 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with
pricet as (
select
hour::date as date,
'0x55acee547df909cf844e32dd66ee55a6f81dc71b' as token_contract,
avg(price) as token_price_usd
from
crosschain.price.ez_prices_hourly
where
blockchain = 'ethereum'
and token_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'
group by 1, 2
),
main as (
select
tx_hash,
block_timestamp,
to_address as user,
contract_address as token_address,
case contract_address
when '0x55acee547df909cf844e32dd66ee55a6f81dc71b' then 'WETH'
when '0xe2053bcf56d2030d2470fb454574237cf9ee3d4b' then 'USDC.e'
when '0x9025095263d1e548dc890a7589a4c78038ac40ab' then 'USDT'
end as symbol,
iff(contract_address = '0x9025095263d1e548dc890a7589a4c78038ac40ab', raw_amount / 1e6, amount) as amnt,
case
when amount_usd is not null then amount_usd
when contract_address in ('0xe2053bcf56d2030d2470fb454574237cf9ee3d4b', '0x9025095263d1e548dc890a7589a4c78038ac40ab') then amnt
else amnt * token_price_usd
end as amount_usd
from
kaia.core.ez_token_transfers a
left join
pricet on block_timestamp::date = date and pricet.token_contract = contract_address
Last run: 9 days ago
10
629B
9s