winnie-fsxerothermic-azure copy copy
Updated 2024-12-12
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
26
27
›
⌄
-- forked from theericstone / xerothermic-azure copy @ https://flipsidecrypto.xyz/theericstone/q/Q7BoVrXIw4n2/xerothermic-azure
-- forked from Mrfti / xerothermic-azure @ https://flipsidecrypto.xyz/Mrfti/q/Jmm7v04G1iUL/xerothermic-azure
-- I used these queries for forking:
-- forked from [Parent Query] NEP245 Parsed Events - 20241205 @ https://flipsidecrypto.xyz/studio/queries/9016ac39-e42b-4591-bea9-dabef61822f7
-- forked from [Parent Query] NEP245 Parsed Mints and Burns Events @ https://flipsidecrypto.xyz/studio/queries/1ca044ae-9e66-4f51-bc61-0cc181cfc50e
with database as
(
select BLOCK_TIMESTAMP,TX_HASH,MEMO,LOG_EVENT_INDEX,OWNER_ID,SYMBOL,OLD_OWNER_ID,NEW_OWNER_ID,TOKEN_AMOUNT_ADJ,AMOUNT_USD
from $query('6539c74d-1822-495e-b77a-d376b9271099')
where MEMO in ('deposit')
)
SELECT
count (DISTINCT tx_hash) as "Total Deposits",
count (DISTINCT owner_id) as "Total Unique Users",
sum (amount_usd) as "Total deposit volume (USD)"
from database
QueryRunArchived: QueryRun has been archived