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.58878198 | 3151.51799702 | 711 | 614 | 40645 | 146907098.801255 |
10 | 2025-03-01 00:00:00.000 | 9528 | 7386 | 19493353.8962638 | 2221.97126368 | 6808 | 578 | 50173 | 166400452.697519 |
11 | 2025-04-01 00:00:00.000 | 101 | 65 | 36232.354699228 | 309.678245293 | 21 | 44 | 50274 | 166436685.052218 |
Afonso_DiazOvertime
Updated 2025-04-01
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: about 1 month ago
11
1017B
2s