feyikemi$GHST Count
Updated 2024-09-20
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT
--DATE_TRUNC('day', block_timestamp) AS date,
SUM(amount_USD) AS total_volume
, 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_TRUNC('day', block_timestamp) >= '2024-01-01'
QueryRunArchived: QueryRun has been archived