Eman-RazCorrelation Analysis: AXL Price vs. Unstaking Volume
    Updated 2024-01-29
    with tab1 as (SELECT hour::date as date, avg(price) as avg_price
    from ethereum.price.ez_hourly_token_prices
    where token_address=lower('0x467719aD09025FcC6cF6F8311755809d45a5E5f3')
    group by 1
    order by 1),

    tab2 as (select block_timestamp::date as date, sum(amount)/pow(10,6) as staking_volume
    from axelar.gov.fact_staking
    where tx_succeeded='true' and action='undelegate' and currency='uaxl'
    group by 1
    order by 1)

    select corr(avg_price, staking_volume) as cc
    from tab1 left join tab2 on tab1.date=tab2.date
    Last run: about 1 year agoAuto-refreshes every 24 hours
    CC
    1
    0.02556572188
    1
    17B
    5s