DATE | TOTAL_PIXELS_DISTRIBUTED | TOTAL_USD | |
|---|---|---|---|
1 | 2024-12-15 00:00:00.000 | 0.1172916667 | 0.02 |
2 | 2024-12-16 00:00:00.000 | 28471.36764388 | 6395.48 |
3 | 2024-12-17 00:00:00.000 | 91980.349152344 | 20216.1 |
4 | 2024-12-18 00:00:00.000 | 77597.385610677 | 15788.36 |
5 | 2024-12-19 00:00:00.000 | 41214.291121094 | 7415.8 |
6 | 2024-12-20 00:00:00.000 | 56487.852889063 | 9042.51 |
7 | 2024-12-21 00:00:00.000 | 38371.958171875 | 6446.41 |
8 | 2024-12-22 00:00:00.000 | 73045.470734375 | 11644.51 |
9 | 2024-12-27 00:00:00.000 | 24.333046875 | 3.89 |
10 | 2025-01-06 00:00:00.000 | 17214.312761719 | 3033.23 |
11 | 2025-01-07 00:00:00.000 | 50964.945171875 | 8613.26 |
12 | 2025-01-08 00:00:00.000 | 50227.531767969 | 7493.01 |
13 | 2025-01-09 00:00:00.000 | 39508.793424609 | 5616.19 |
14 | 2025-01-10 00:00:00.000 | 28983.497764062 | 4126.76 |
15 | 2025-01-11 00:00:00.000 | 23959.395079687 | 3399.87 |
16 | 2025-01-12 00:00:00.000 | 30059.045828125 | 4233.12 |
17 | 2025-01-13 00:00:00.000 | 33023.493576004 | 4268.44 |
18 | 2025-01-14 00:00:00.000 | 31804.473330022 | 4260.25 |
19 | 2025-01-15 00:00:00.000 | 24867.105617969 | 3450.85 |
20 | 2025-01-16 00:00:00.000 | 37564.204766406 | 5393.35 |
jjj323Daily Pixels Distributed copy
Updated 2025-04-04
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
›
⌄
-- forked from permary / Daily Pixels Distributed @ https://flipsidecrypto.xyz/permary/q/BoQuQNkcgvhZ/daily-pixels-distributed
WITH rewards AS (
SELECT
tx_hash AS hash,
DATE_TRUNC('day', block_timestamp) AS date
FROM ronin.core.fact_transactions
WHERE to_address = '0x0e6bce8f215c52b53fad009e3bfacbb3be3774a6'
AND origin_function_signature = '0x9ca96ce0'
),
pixel_rewards AS (
SELECT
DATE_TRUNC('day', block_timestamp) AS date,
SUM(amount) AS total_pixels_distributed,
sum(amount_usd) as total_usd
FROM ronin.core.ez_token_transfers
WHERE contract_address = '0x7eae20d11ef8c779433eb24503def900b9d28ad7'
AND from_address = '0x0e6bce8f215c52b53fad009e3bfacbb3be3774a6'
AND tx_hash IN (SELECT hash FROM rewards)
GROUP BY 1
)
SELECT date, total_pixels_distributed, total_usd
FROM pixel_rewards
ORDER BY date ASC;
Last run: 3 months ago
98
5KB
7s