DAY | DAILY_AMOUNT | DAILY_AMOUNT_USD | TIPPERS | |
|---|---|---|---|---|
1 | 2025-03-11 00:00:00.000 | 69 | 0.6300183 | 1 |
2 | 2025-02-26 00:00:00.000 | 69 | 0.6300183 | 1 |
3 | 2025-02-25 00:00:00.000 | 69 | 0.6300183 | 1 |
4 | 2025-02-24 00:00:00.000 | 42 | 0.3834894 | 1 |
5 | 2025-02-21 00:00:00.000 | 69 | 0.6300183 | 1 |
6 | 2025-02-19 00:00:00.000 | 42 | 0.3834894 | 1 |
7 | 2025-02-18 00:00:00.000 | 126 | 1.1504682 | 3 |
8 | 2025-02-17 00:00:00.000 | 42 | 0.3834894 | 1 |
9 | 2025-02-12 00:00:00.000 | 696 | 6.3549672 | 1 |
10 | 2025-02-11 00:00:00.000 | 42 | 0.3834894 | 1 |
11 | 2025-02-09 00:00:00.000 | 42 | 0.3834894 | 1 |
12 | 2025-02-06 00:00:00.000 | 111 | 1.0135077 | 1 |
13 | 2025-02-04 00:00:00.000 | 69 | 0.6300183 | 1 |
14 | 2025-02-02 00:00:00.000 | 84 | 0.7669788 | 2 |
15 | 2025-01-29 00:00:00.000 | 42 | 0.3834894 | 1 |
16 | 2025-01-24 00:00:00.000 | 84 | 0.7669788 | 1 |
17 | 2025-01-23 00:00:00.000 | 42 | 0.3834894 | 1 |
18 | 2025-01-17 00:00:00.000 | 138 | 1.2600366 | 2 |
19 | 2025-01-16 00:00:00.000 | 42 | 0.3834894 | 1 |
20 | 2025-01-15 00:00:00.000 | 933 | 8.5189431 | 4 |
zyroqDaily tips
Updated 2025-03-21
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
›
⌄
WITH price AS (
SELECT
price AS current_price
FROM (
SELECT
hour,
price,
RANK() OVER(ORDER BY hour DESC) AS rank
FROM base.price.ez_prices_hourly
WHERE token_address = LOWER('0x55cD6469F597452B5A7536e2CD98fDE4c1247ee4')
ORDER BY hour DESC
) AS a
WHERE rank = 1
)
SELECT
DATE_TRUNC('day', block_timestamp) AS day,
SUM(amount) AS daily_amount,
SUM(amount * price.current_price) AS daily_amount_usd,
count(DISTINCT from_address) as tippers,
FROM base.core.ez_token_transfers
JOIN price ON TRUE
WHERE contract_address = LOWER('0x55cD6469F597452B5A7536e2CD98fDE4c1247ee4')
AND to_address = LOWER('0x2d21235e26c326818ECEEaC82F26996E5202e512')
GROUP BY day
ORDER BY day DESC;
Last run: 27 days ago
91
4KB
4s