flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Total Perp Fee Spent in 30 Days
Motilola
Total Perp Fee Spent in 30 Days
Updated 2024-04-13
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
SELECT
--Date_trunc(day, block_timestamp) AS Date,
--symbol,
SUM
(
fee_amount
)
AS
Total_Perp_Fee
FROM
arbitrum
.
vertex
.
ez_perp_trades
WHERE
block_timestamp
>
CURRENT_DATE
-
30
AND
is_taker
=
'TRUE'
Results
QueryRunArchived: QueryRun has been archived