Ali3NWallet Age of Terra HyperActive Users
    Updated 2023-01-30
    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