efer0. Daily and Total generated $axlUSDC
Updated 2023-01-18
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
›
⌄
WITH transfers AS (
SELECT
BLOCK_TIMESTAMP::date AS date,
TX_ID
FROM axelar.core.fact_transfers
--WHERE TRANSFER_TYPE != 'AXELAR'
), txns AS (
SELECT
transfers.date AS date,
transactions.fee/POW(10, 6) AS fee
FROM transfers
LEFT JOIN (
SELECT TX_ID, fee FROM axelar.core.fact_transactions
) transactions
ON transfers.TX_ID = transactions.TX_ID
)
SELECT
date,
SUM(fee) AS axlUSDC,
SUM(axlUSDC) OVER(ORDER BY date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cumulative
FROM txns
GROUP BY date
ORDER BY date DESC
Run a query to Download Data