feyikemi$GHST Txns
Updated 2024-09-20
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
›
⌄
With Tab1 as (
SELECT
DATE_TRUNC('day', block_timestamp) AS date
, SUM(amount_USD) AS Total_Volume_USD
, COUNT(DISTINCT Tx_hash) AS Transaction_Count
, COUNT(DISTINCT From_address) AS Active_Addresses
FROM
polygon.core.ez_token_transfers
WHERE 1=1
AND CONTRACT_ADDRESS = '0x385eeac5cb85a38a9a07a70c73e0a3271cfb54a7' -- $GHST Contract Address'
AND date >= '2024-01-01'
GROUP BY
date
ORDER BY
date DESC;
)
SELECT
Date
, Total_Volume_USD
, SUM(Total_Volume_USD) OVER (ORDER BY date) AS Cumulative_Volume_USD
, Transaction_Count
FROM
Tab1
QueryRunArchived: QueryRun has been archived