MLDZMNStaking volume
Updated 2025-02-28
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 days as (
-- select
-- DATE_DAY as day
-- from ethereum.core.dim_dates
-- where DATE_DAY >=
-- ),
with gnosis_balance AS (
SELECT
date_trunc('week',BLOCK_TIMESTAMP) as week,
COALESCE(SUM(CASE WHEN TO_ADDRESS = lower('0xa45E64d13A30a51b91ae0eb182e88a40e9b18eD8') THEN AMOUNT ELSE 0 END), 0) AS deposit_gnosis,
COALESCE(SUM(CASE WHEN FROM_ADDRESS = lower('0xa45E64d13A30a51b91ae0eb182e88a40e9b18eD8') THEN AMOUNT ELSE 0 END), 0) AS withdraw_gnosis,
COALESCE(SUM(CASE WHEN TO_ADDRESS = lower('0xa45E64d13A30a51b91ae0eb182e88a40e9b18eD8') THEN AMOUNT ELSE 0 END), 0)
- COALESCE(SUM(CASE WHEN FROM_ADDRESS = lower('0xa45E64d13A30a51b91ae0eb182e88a40e9b18eD8') THEN AMOUNT ELSE 0 END), 0) AS daily_net_gnosis
FROM gnosis.core.ez_token_transfers
WHERE contract_address = lower('0xcE11e14225575945b8E6Dc0D4F2dD4C570f79d9f')
group by 1
),
optimism_balance AS (
SELECT
date_trunc('week',BLOCK_TIMESTAMP) as week,
COALESCE(SUM(CASE WHEN TO_ADDRESS = lower('0xBb7e1D6Cb6F243D6bdE81CE92a9f2aFF7Fbe7eac') THEN AMOUNT ELSE 0 END), 0) AS deposit_optimism,
COALESCE(SUM(CASE WHEN FROM_ADDRESS = lower('0xBb7e1D6Cb6F243D6bdE81CE92a9f2aFF7Fbe7eac') THEN AMOUNT ELSE 0 END), 0) AS withdraw_optimism,
COALESCE(SUM(CASE WHEN TO_ADDRESS = lower('0xBb7e1D6Cb6F243D6bdE81CE92a9f2aFF7Fbe7eac') THEN AMOUNT ELSE 0 END), 0)
- COALESCE(SUM(CASE WHEN FROM_ADDRESS = lower('0xBb7e1D6Cb6F243D6bdE81CE92a9f2aFF7Fbe7eac') THEN AMOUNT ELSE 0 END), 0) AS daily_net_optimism
FROM optimism.core.ez_token_transfers
WHERE
contract_address = lower('0xFC2E6e6BCbd49ccf3A5f029c79984372DcBFE527')
group by 1
),
price_tab as (
select
date_trunc('week',HOUR)as week,
avg(price) as olas_price
from ethereum.price.ez_prices_hourly
QueryRunArchived: QueryRun has been archived