DEPOSITOR | DEPOSIT COUNT | ACTIVE DAYS | |
---|---|---|---|
1 | 0x13e46b2a3f8512ed4682a8fb8b560589fe3c2172 | 2223 | 84 |
2 | 0x7e689c1ef962160685da69742170b3629e6299ae | 439 | 2 |
3 | 0xe530a4ad020b8628b4031998bcd05904a4cd6e0e | 438 | 8 |
4 | 0x102ee22d378e9cec65c6095b0bbfbab8f236d59c | 294 | 2 |
5 | 0x49fbb9f90e78dd1c0569816e1eeeaf2c28414ed7 | 243 | 6 |
6 | 0x91d4feb0451254b8024d03d09d9b62a1a2e38e28 | 224 | 22 |
7 | 0x4f45eceb38221b338b4651cc1cdf51b1b61fddf4 | 208 | 22 |
8 | 0x8513fafe1813b6ec3bbd9fc4baf5340bda8d670b | 184 | 2 |
9 | 0x23254912de2b8c6e3d158efc8721f8dc1eb4a27a | 175 | 15 |
10 | 0xe4b479ccf9c5665b55dcb35c15d155dbf29d431b | 174 | 13 |
0-MIDTop 10 Depositors By Deposit Count
Updated 2024-01-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
select
TO_ADDRESS as depositor
,count(distinct tx_hash) as "DEPOSIT COUNT"
,count(distinct BLOCK_TIMESTAMP::date) as "ACTIVE DAYS"
from base.core.fact_transactions
where FROM_ADDRESS in('0x80c67432656d59144ceff962e8faf8926599bcf8','0xe4edb277e41dc89ab076a1f049f4a3efa700bce8','0xd9d74a29307cc6fc8bf424ee4217f1a587fbc8dc')
group by 1
order by 2 desc
limit 10
Last run: about 1 year ago
10
537B
17s