EkuboGas Usage
Updated 2023-11-10
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
31
32
33
34
35
36
›
⌄
WITH
hashs AS (
SELECT
'Deposits' AS type
, TX_HASH AS hashes
FROM external.tokenflow_starknet.decoded_events ev
WHERE ev.CHAIN_ID = 'mainnet'
--AND ev.TX_HASH = '0x0795b952aafcc1a172165ca5e316f8ccf6872ab5c326c07876e877f2c23f6456'
AND ev.NAME = 'Deposit'
AND ev.CONTRACT = '0x02e0af29598b407c8716b17f6d2795eca1b471413fa03fb145a5e33722184067' --EkuboDeposits
UNION
SELECT
'Withdrawals' AS type
, TX_HASH AS hashes
FROM external.tokenflow_starknet.decoded_events ev
WHERE CHAIN_ID = 'mainnet'
--AND TX_HASH = '0x02c975201b7e2dc8948d4f2ed0bb7a450c23e07f0a5b82fe4964afc858c22253'
AND NAME = 'Withdraw'
AND CONTRACT = '0x02e0af29598b407c8716b17f6d2795eca1b471413fa03fb145a5e33722184067'
)
SELECT * FROM (
SELECT
DATE_TRUNC('{{Time_Frame}}', tr.TIMESTAMP) AS "Date"
, h.type
, SUM(ACTUAL_FEE/POW(10,18)) AS "Transaction Fees in Ξ"
, SUM(SUM((ACTUAL_FEE/2)/POW(10,18))) OVER (ORDER BY DATE_TRUNC('{{Time_Frame}}', tr.TIMESTAMP)) AS "Cumulative Fee in Ξ"
FROM external.tokenflow_starknet.decoded_transactions tr
INNER JOIN hashs h ON tr.TX_HASH = h.hashes
GROUP BY 1, 2
)
WHERE "Date" >= '2023-09-11'
Run a query to Download Data