zakkisyedNo. of LockUps
Updated 2023-06-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 lockups AS (
SELECT
DATE_TRUNC('DAY', block_timestamp) AS date,
origin_from_address AS address,
COUNT(*) AS num_lockups,
SUM(decoded_log:amount / 1e18) AS total_amount
FROM ethereum.core.ez_decoded_event_logs
WHERE
contract_address IN (
'0xa3e8e8a08a7a27f65fc4c7fdf87db698cd4b1807',
'0x45a4f6a4ecff0bbbca99f4c26a7086e6b6492f76',
'0x027a5981cfe14a9f33486a89a4a05f7ca1116f6d'
)
AND event_name = 'Deposit'
GROUP BY DATE_TRUNC('DAY', block_timestamp), origin_from_address
),
generation_cycles AS (
SELECT
DATE_TRUNC('DAY', block_timestamp) AS date,
CEIL(DATEDIFF('DAY', '2023-01-07', DATE_TRUNC('DAY', block_timestamp)) / 14) AS generation_number
FROM ethereum.core.ez_decoded_event_logs
WHERE
contract_address IN (
'0xa3e8e8a08a7a27f65fc4c7fdf87db698cd4b1807',
'0x45a4f6a4ecff0bbbca99f4c26a7086e6b6492f76',
'0x027a5981cfe14a9f33486a89a4a05f7ca1116f6d'
)
AND event_name = 'Deposit'
GROUP BY DATE_TRUNC('DAY', block_timestamp)
)
SELECT
gc.generation_number AS generation,
lc.date AS date,
lc.num_lockups AS num_lockups,
lc.total_amount AS total_amount
FROM lockups lc
Run a query to Download Data