CryptoLionTiming for claiming rewards
Updated 2022-11-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
SELECT * FROM (
SELECT
date_trunc('hour',block_timestamp) as hour,
avg(fee_usd) as average_fee
FROM ethereum.transactions
WHERE
block_timestamp >= getdate() - interval '5 days'
and (
LOWER(function_name) like '%claim%'
OR LOWER(function_name) like '%deposit%'
OR LOWER(function_name) like '%stake%'
)
GROUP BY 1
ORDER BY 1 DESC
)
allofit
WHERE average_fee > 0
Run a query to Download Data