DATE_MINUTE | COUNT | MOVING_AVERAGE_30M | CONSTANT | |
|---|---|---|---|---|
1 | 2025-01-22 00:00:00.000 | 2 | 0.066667 | 0.25 |
2 | 2025-01-22 00:01:00.000 | 3 | 0.166667 | 0.25 |
3 | 2025-01-22 00:02:00.000 | 2 | 0.233333 | 0.25 |
4 | 2025-01-22 00:03:00.000 | 0 | 0.233333 | 0.25 |
5 | 2025-01-22 00:04:00.000 | 2 | 0.3 | 0.25 |
6 | 2025-01-22 00:05:00.000 | 0 | 0.3 | 0.25 |
7 | 2025-01-22 00:06:00.000 | 1 | 0.333333 | 0.25 |
8 | 2025-01-22 00:07:00.000 | 0 | 0.333333 | 0.25 |
9 | 2025-01-22 00:08:00.000 | 1 | 0.366667 | 0.25 |
10 | 2025-01-22 00:09:00.000 | 0 | 0.366667 | 0.25 |
11 | 2025-01-22 00:10:00.000 | 2 | 0.433333 | 0.25 |
12 | 2025-01-22 00:11:00.000 | 1 | 0.466667 | 0.25 |
13 | 2025-01-22 00:12:00.000 | 1 | 0.5 | 0.25 |
14 | 2025-01-22 00:13:00.000 | 1 | 0.533333 | 0.25 |
15 | 2025-01-22 00:14:00.000 | 2 | 0.6 | 0.25 |
16 | 2025-01-22 00:15:00.000 | 1 | 0.633333 | 0.25 |
17 | 2025-01-22 00:16:00.000 | 1 | 0.666667 | 0.25 |
18 | 2025-01-22 00:17:00.000 | 2 | 0.733333 | 0.25 |
19 | 2025-01-22 00:18:00.000 | 0 | 0.733333 | 0.25 |
20 | 2025-01-22 00:19:00.000 | 2 | 0.8 | 0.25 |
nasdfajsklj2024-06-14 10:01 PM
Updated 2025-02-05
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 addresses as (
select lower(address) as address from (
values
('0xc8c0e780960f954c3426a32b6ab453248d632b59') --old fee address
,('0x77777d91c0b8ec9984a05302e4ef041dccf77fee') --new fee address
-- ,('0x0000000000002bdbf1bf3279983603ec279cc6df') --relay?
) as t(address)
)
,data as (
select
block_timestamp::date as date,
date_trunc('minute', block_timestamp) as date_minute,
date_trunc('month', block_timestamp)::date as month,
chain,
amount_usd,
origin_to_address
from (
select block_timestamp, amount_usd, origin_to_address, 'ETH' as chain
from ethereum.core.ez_token_transfers
where to_address in (select address from addresses)
and origin_from_address not in (select address from addresses)
and block_timestamp::date > '2024-04-01'
and symbol not in ('Shiba 2.0', 'INNBC')
union all
select block_timestamp, amount_usd, origin_to_address, 'BASE' as chain
from base.core.ez_token_transfers
where to_address in (select address from addresses)
and origin_from_address not in (select address from addresses)
and block_timestamp::date > '2024-04-01'
) as combined
),
all_minutes AS (
Last run: 3 months agoAuto-refreshes every 12 hours
...
20150
827KB
153s