KaskoazulL1 Unique Users and prices since Feb1
    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 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-02-01' and fecha < CURRENT_DATE -1
    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-02-01' and fecha < CURRENT_DATE -1
    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-02-01' and fecha < CURRENT_DATE -1
    GROUP BY fecha
    ),

    TERRA_PRICE AS (
    SELECT hour::date as fecha, avg(price) as TERRA_price
    FROM ethereum.token_prices_hourly
    where symbol ='LUNA' and token_address = '0xbd31ea8212119f94a611fa969881cba3ea06fa3d' and fecha >= '2022-02-01' and fecha < CURRENT_DATE -1
    GROUP BY fecha
    ),
    Run a query to Download Data