PapasotUnique users, ETH, SOL, TERRA, ALGO
    Updated 2022-04-05
    --Question 37: Compare the number of unique wallets that have sent a transaction since February 1st on Solana vs Ethereum vs Terra.
    --How does user adoption seem to be trending for Solana compared to these other major chains?
    --Does it appear that market conditions are slowing down growth or activity on the networks?

    WITH ALGO_WALLETS AS (
    SELECT
    date_trunc('day',block_timestamp) AS fecha,
    count(distinct address) AS Algo_wallets
    FROM algorand.transaction_participation
    WHERE fecha >= '2022-01-01' and fecha < '2022-04-01'
    GROUP BY fecha
    ),

    ETH_WALLETS AS (
    SELECT block_timestamp::date as fecha, count(distinct from_address) as ETH_wallets, 'ETHEREUM' as L1
    FROM ethereum.transactions
    WHERE fecha >= '2022-01-01' and fecha < '2022-04-01'
    GROUP BY fecha
    ),

    ETH_PRICE AS (
    SELECT hour::date as fecha, avg(price) as ETH_price
    FROM ethereum.token_prices_hourly
    where symbol ='ETH' and fecha >= '2022-01-01' and fecha < '2022-04-01'
    GROUP BY fecha
    ),

    ETH_JOINT AS (
    SELECT w.fecha, w.ETH_wallets, p.ETH_price
    FROM ETH_WALLETS w LEFT JOIN ETH_PRICE p ON w.fecha = p.fecha
    ),

    TERRA_WALLETS AS (
    SELECT block_timestamp::date as fecha, count(distinct tx_from) as TERRA_wallets, 'TERRA' as L1
    FROM terra.transactions
    WHERE fecha >= '2022-01-01' and fecha < '2022-04-01'
    Run a query to Download Data