flipside

    Algorand price correlation 4
    sarath Algorand price correlation 4
    Updated 2022-06-30
    with data1 as (SELECT date(hour) as date,avg(price) as sol_price
    FROM ethereum.core.fact_hourly_token_prices
    WHERE token_address =lower( '0xD31a59c85aE9D8edEFeC411D448f90841571b89c' )
    GROUP by 1),
    data2 as (SELECT date(block_timestamp) as date1,count(tx_id) as TRANSACTIONs from solana.core.fact_TRANSACTIONs
    GROUP by 1
    ),
    data3 as (
    SELECT date(block_timestamp) as date2,count(tx_id) as transfers from solana.core.fact_transfers
    GROUP by 1
    )
    SELECT date,sol_price,TRANSACTIONs,transfers from data1 join data2 on data1.date=data2.date1 join data3 on data1.date=data3.date2
    LIMIT 1000
    Run a query to Download Data