princefarzamActive wallets
Updated 2022-07-06
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
28
29
30
31
32
33
34
35
36
›
⌄
WITH txns AS (
SELECT
COUNT(DISTINCT TX_SIGNER) AS ACTIVE_WALLETS,
COUNT(DISTINCT TXN_HASH) AS Number_of_txns
FROM flipside_prod_db.mdao_near.transactions
WHERE BLOCK_TIMESTAMP::DATE >= CURRENT_DATE - 90 --IN THE LAST 90 DAYS
),
swaps AS (
WITH swap_txns AS (
SELECT
DISTINCT TXN_HASH AS swaps
FROM flipside_prod_db.mdao_near.actions_events
WHERE ACTION_DATA:method_name::STRING='swap'
AND BLOCK_TIMESTAMP::DATE >= CURRENT_DATE - 90)
SELECT
COUNT(DISTINCT A.TXN_HASH) AS NUMBER_OF_SWAPS,
COUNT(DISTINCT TX_SIGNER) AS ACTIVE_SWAPPERS
FROM flipside_prod_db.mdao_near.transactions A INNER JOIN swap_txns B ON A.TXN_HASH = B.swaps
),
transfers AS (
SELECT
COUNT(DISTINCT TXN_HASH) AS NUMBER_OF_TRANSFERS,
COUNT(DISTINCT TX_SIGNER) AS ACTIVE_SENDERS
FROM flipside_prod_db.mdao_near.transfers
WHERE BLOCK_TIMESTAMP::DATE >= CURRENT_DATE - 90
AND STATUS= TRUE
),
stakers AS(
WITH Stake_transactions AS (
SELECT
TXN_HASH AS Stake_txns
FROM flipside_prod_db.mdao_near.actions_events
WHERE ACTION_DATA:method_name::string='deposit_and_stake'
AND BLOCK_TIMESTAMP::DATE >= CURRENT_DATE - 90)
Run a query to Download Data