NuveveCryptoArchivedFestive Wallets Transaction Type Count Over Time
    Updated 2023-01-10
    with new_wallets as (
    select
    min(block_timestamp) as first_timestamp,
    tx_sender
    from terra.core.fact_transactions
    group by tx_sender
    ),

    festive_wallets as (
    select
    distinct tx_sender as address
    from new_wallets
    where first_timestamp >= '2022-12-01'
    ),

    staking as (
    select
    date_trunc('week', staking.block_timestamp) as week,
    count(distinct tx_id) as tx_count
    from terra.core.ez_staking as staking
    inner join festive_wallets on staking.delegator_address = festive_wallets.address
    group by week
    ),

    swaps as (
    select
    date_trunc('week', swaps.block_timestamp) as week,
    count(distinct tx_id) as tx_count
    from terra.core.ez_swaps as swaps
    inner join festive_wallets on swaps.trader = festive_wallets.address
    group by week
    ),

    transfers as (
    select
    date_trunc('week', transfers.block_timestamp) as week,
    Run a query to Download Data