0xaimanStargate User Growth p2 USDT copy
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
-- forked from rhonin / Stargate User Growth p2 USDT @ https://flipsidecrypto.xyz/rhonin/q/untitled-query-zRDE4J
SELECT
date_trunc('day', block_timestamp) as day,
COUNT(DISTINCT from_address) as unique_users,
sum(amount_usd) as USDT_volume,
sum(USDT_volume) over (ORDER BY day) as cum_volume,
sum(unique_users) over (ORDER BY DAY) as cum_users
FROM ethereum_core.ez_token_transfers
WHERE to_address IN ('0x38ea452219524bb87e18de1c24d3bb59510bd783' , '0xdf0770df86a8034b3efef0a1bb3c889b8332ff56')--stargate USDT and USDC pool_addresses
AND tx_hash IN (
SELECT
tx_hash
FROM ethereum_core.ez_token_transfers
WHERE from_address = '0x0000000000000000000000000000000000000000'
AND contract_address IN ('0x38ea452219524bb87e18de1c24d3bb59510bd783' , '0xdf0770df86a8034b3efef0a1bb3c889b8332ff56') --stargate USDT and USDC pool_addressess
)
GROUP BY 1
Run a query to Download Data