feyikemi$PYR Txn Fees
Updated 2024-05-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
SELECT
DATE_TRUNC('day', Hour) AS Date,
SUM(s.total_fees_USD) AS total_fees
FROM
ethereum.price.ez_prices_hourly p
JOIN ethereum.stats.ez_core_metrics_hourly s
ON p.hour = s.block_timestamp_hour
WHERE
p.token_address = '0x430ef9263e76dae63c84292c3409d61c598e9682'
AND DATE >= '2024-01-01'
GROUP BY
date
ORDER BY
date;
QueryRunArchived: QueryRun has been archived