eferCopy of Copy of 5. APE staking since the first day (Daily)
Updated 2022-12-07
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 BAYC AS (
SELECT
BLOCK_TIMESTAMP::date AS date,
SUM(RAW_AMOUNT) / POW(10, 18) AS apes
FROM
ethereum.core.fact_token_transfers
WHERE
ORIGIN_TO_ADDRESS = '0x5954ab967bc958940b7eb73ee84797dc8a2afbb9'
AND ORIGIN_FUNCTION_SIGNATURE = '0x46583a05'
GROUP BY BLOCK_TIMESTAMP::date
), MAYC AS (
SELECT
BLOCK_TIMESTAMP::date AS date,
SUM(RAW_AMOUNT) / POW(10, 18) AS apes
FROM
ethereum.core.fact_token_transfers
WHERE
ORIGIN_TO_ADDRESS = '0x5954ab967bc958940b7eb73ee84797dc8a2afbb9'
AND ORIGIN_FUNCTION_SIGNATURE = '0x8ecbffa7'
GROUP BY BLOCK_TIMESTAMP::date
), BAKC AS (
SELECT
BLOCK_TIMESTAMP::date AS date,
SUM(RAW_AMOUNT) / POW(10, 18) AS apes
FROM
ethereum.core.fact_token_transfers
WHERE
ORIGIN_TO_ADDRESS = '0x5954ab967bc958940b7eb73ee84797dc8a2afbb9'
AND ORIGIN_FUNCTION_SIGNATURE = '0xd346cbd9'
GROUP BY BLOCK_TIMESTAMP::date
),APE AS (
SELECT
BLOCK_TIMESTAMP::date AS date,
SUM(RAW_AMOUNT) / POW(10, 18) AS apes
FROM
ethereum.core.fact_token_transfers
Run a query to Download Data