barbodFriktion Bitcoin Volt
    Updated 2022-03-23
    with Solana as (
    select block_timestamp::date as date ,
    count(DISTINCT tx_from_address) as s_wallets
    from solana.transactions
    where block_timestamp >= '2022-02-01'
    and succeeded = true
    group by 1
    ),
    Ethereum as (
    select block_timestamp::date as date,
    count(DISTINCT from_address) as e_wallets
    from ethereum.transactions
    where block_timestamp >= '2022-02-01'
    and success =true
    group by 1
    ),
    Terra as (
    select block_timestamp::date as date ,
    count(DISTINCT tx_from[0]) as t_wallets
    from terra.transactions
    where block_timestamp >= '2022-02-01'
    and tx_status ='SUCCEEDED'
    group by 1
    )
    select
    Solana.date as date,
    Solana.s_wallets,
    Ethereum.e_wallets,
    Terra.t_wallets
    from Solana join Terra join Ethereum
    on Solana.date = Ethereum.date and Solana.date = Terra.date
    ORDER by date
    Run a query to Download Data