DATE | TRANSACTIONS | USERS | VOLUME_USD | AVERAGE_AMOUNT_USD | NEW_USERS | RETURNING_USERS | CUMULATIVE_TRANSACTIONS | CUMULATIVE_VOLUME_USD | |
|---|---|---|---|---|---|---|---|---|---|
1 | 2024-06-01 00:00:00.000 | 20 | 19 | 19 | 0 | 20 | |||
2 | 2024-07-01 00:00:00.000 | 63 | 43 | 42 | 1 | 83 | |||
3 | 2024-08-01 00:00:00.000 | 1663 | 680 | 9564788.80519722 | 11359.606657004 | 671 | 9 | 1746 | 9564788.80519722 |
4 | 2024-09-01 00:00:00.000 | 11032 | 7275 | 23127629.336068 | 3149.615870362 | 7034 | 241 | 12778 | 32692418.1412652 |
5 | 2024-10-01 00:00:00.000 | 9891 | 8318 | 25114244.6685038 | 6466.077412076 | 7462 | 856 | 22669 | 57806662.809769 |
6 | 2024-11-01 00:00:00.000 | 4665 | 2319 | 23000558.5586783 | 7232.880049899 | 1583 | 736 | 27334 | 80807221.3684472 |
7 | 2024-12-01 00:00:00.000 | 5612 | 1921 | 24262326.2433792 | 4094.907382849 | 1110 | 811 | 32946 | 105069547.611826 |
8 | 2025-01-01 00:00:00.000 | 4396 | 2029 | 34204574.6006467 | 8861.288756644 | 1254 | 775 | 37342 | 139274122.212473 |
9 | 2025-02-01 00:00:00.000 | 3303 | 1325 | 7632976.58878199 | 3151.51799702 | 711 | 614 | 40645 | 146907098.801255 |
10 | 2025-03-01 00:00:00.000 | 9528 | 7386 | 19686282.0693088 | 2241.407499637 | 6808 | 578 | 50173 | 166593380.870564 |
11 | 2025-04-01 00:00:00.000 | 9669 | 6219 | 21347891.0029744 | 1980.507561274 | 4516 | 1703 | 59842 | 187941271.873538 |
12 | 2025-05-01 00:00:00.000 | 2969 | 1534 | 62886039.3394307 | 16592.622517 | 453 | 1081 | 62811 | 250827311.212969 |
Afonso_DiazOvertime
Updated 2025-05-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
pricet as (
select
hour::date as date,
token_address,
avg(price) as price_usd
from
sei.price.ez_prices_hourly
group by 1, 2
),
main as (
select
tx_hash,
block_timestamp,
to_address as user,
contract_address as token_address,
symbol,
amount,
amount * price_usd as amount_usd
from
sei.core_evm.ez_token_transfers a
left join
pricet on block_timestamp::date = date and pricet.token_address = a.contract_address
where
origin_to_address = '0xc097ab8cd7b053326dfe9fb3e3a31a0cce3b526f'
),
overtime as (
select
date_trunc('{{ period }}', block_timestamp) as date,
count(distinct tx_hash) as transactions,
count(distinct user) as users,
sum(amount_usd) as volume_usd,
avg(amount_usd) as average_amount_usd
Last run: 19 days ago
12
1KB
2s