DATE | TRANSACTIONS | USERS | NEW_USERS | RETURNING_USERS | |
|---|---|---|---|---|---|
1 | 2021-10-01 00:00:00.000 | 280987 | 17406 | 17406 | 0 |
2 | 2021-11-01 00:00:00.000 | 239552 | 19650 | 9771 | 9879 |
3 | 2021-12-01 00:00:00.000 | 180565 | 20445 | 8957 | 11488 |
4 | 2022-01-01 00:00:00.000 | 179730 | 22178 | 9238 | 12940 |
5 | 2022-02-01 00:00:00.000 | 127379 | 18002 | 7080 | 10922 |
6 | 2022-03-01 00:00:00.000 | 90535 | 13995 | 3863 | 10132 |
7 | 2022-04-01 00:00:00.000 | 111793 | 16044 | 5690 | 10354 |
8 | 2022-05-01 00:00:00.000 | 130566 | 16126 | 5533 | 10593 |
9 | 2022-06-01 00:00:00.000 | 133924 | 13804 | 5408 | 8396 |
10 | 2022-07-01 00:00:00.000 | 89576 | 10231 | 3304 | 6927 |
11 | 2022-08-01 00:00:00.000 | 80175 | 12263 | 5973 | 6290 |
12 | 2022-09-01 00:00:00.000 | 67117 | 11787 | 3583 | 8204 |
13 | 2022-10-01 00:00:00.000 | 63519 | 16311 | 5755 | 10556 |
14 | 2022-11-01 00:00:00.000 | 101340 | 20830 | 7084 | 13746 |
15 | 2022-12-01 00:00:00.000 | 59883 | 18605 | 6824 | 11781 |
16 | 2023-01-01 00:00:00.000 | 83168 | 16527 | 3802 | 12725 |
17 | 2023-02-01 00:00:00.000 | 43470 | 8034 | 2098 | 5936 |
18 | 2023-03-01 00:00:00.000 | 57730 | 8954 | 2610 | 6344 |
19 | 2023-04-01 00:00:00.000 | 35585 | 7280 | 2803 | 4477 |
20 | 2023-05-01 00:00:00.000 | 40249 | 8229 | 5015 | 3214 |
Afonso_Diazovertime
Updated 2025-03-10
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
main as (
select
tx_hash,
block_timestamp,
borrower as user,
token_symbol as symbol,
amount_usd,
'Borrow' as event_name
from
avalanche.defi.ez_lending_borrows
where
platform ilike 'aave%'
union all
select
tx_hash,
block_timestamp,
depositor as user,
token_symbol as symbol,
amount_usd,
'Deposit' as event_name
from
avalanche.defi.ez_lending_deposits
where
platform ilike 'aave%'
union all
select
tx_hash,
block_timestamp,
depositor as user,
token_symbol as symbol,
Last run: 3 months ago
42
2KB
11s