Ali3NWallet Age of Terra HyperActive Users
Updated 2023-01-30
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 TransferTable as (
select 'Transfering' as Activity_Type,
sender as Terra_User,
count (distinct tx_id) as TX_Count
from terra.core.ez_transfers
where block_timestamp >= CURRENT_DATE - 90
group by 1,2),
StakeTable as (
select 'Staking' as Activity_Type,
delegator_address as Terra_User,
count (distinct tx_id) as TX_Count
from terra.core.ez_staking
where action = 'Delegate'
and block_timestamp >= CURRENT_DATE - 90
group by 1,2),
GovernanceTable as (
select 'Governance Voting' as Activity_Type,
voter as Terra_User,
count (distinct tx_id) as TX_Count
from terra.core.fact_governance_votes
where block_timestamp >= CURRENT_DATE - 90
group by 1,2),
NFTMintTable as (
select 'NFT Minting' as Activity_Type,
minter as Terra_User,
count (distinct tx_id) as TX_Count
from terra.core.fact_nft_mints
where block_timestamp >= CURRENT_DATE - 90
group by 1,2),
NFTTradeTable as (
select 'NFT Trading' as Activity_Type,
purchaser as Terra_User,
Run a query to Download Data