nsa2000e1
Updated 2022-12-07Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
-- This code is thankfully burrowed from 0xHaM☰d: https://app.flipsidecrypto.com/dashboard/mTsqs0
SELECT
date_trunc('day', BLOCK_TIMESTAMP) as date,
COUNT(DISTINCT tx_hash) as tx_cnt,
COUNT(DISTINCT ORIGIN_FROM_ADDRESS) as usr_cnt,
sum(RAW_AMOUNT/1e18) as volume,
sum(tx_cnt) over (order by date) as cum_tx_cnt,
sum(volume) over (order by date) as cum_volume
FROM ethereum.core.fact_token_transfers
WHERE CONTRACT_ADDRESS = lower('0x4d224452801ACEd8B2F0aebE155379bb5D594381')
AND ORIGIN_FROM_ADDRESS != '0x295d587aa3ca6e57e227a4430ab7c4c00989a195' -- Apecoin: Deployer
AND ORIGIN_TO_ADDRESS != '0x03ca52e482912308c287d09ec941b996c18668f5' -- Apecoin: Token Distributor
GROUP by 1
ORDER by 1 DESC
Run a query to Download Data