MLDZMNtokens2
    Updated 2023-05-05
    -- forked from tokens1 @ https://flipsidecrypto.xyz/edit/queries/e3e5c73d-9cda-4bbe-8c94-eda0f1ce415c

    with tb2 as (select
    recorded_hour::date as day,
    avg (close) as IOT_price
    from solana.core.ez_token_prices_hourly
    where token_address='iotEVVZLEywoTn1QdwNPddxPWszn3zFhEot3MfL9fns'
    and recorded_hour::date >= '2023-04-20'
    group by 1),

    tb3 as (select
    recorded_hour::date as day,
    avg (close) as Mobile_price
    from solana.core.ez_token_prices_hourly
    where token_address='mb1eu7TzEc71KxDpsmsKoucSSuuoGLv1drys1oP2jh6'
    and recorded_hour::date >= '2023-04-20'
    group by 1)



    select
    tb2.day as day,
    IOT_price,
    Mobile_price
    from tb2
    left join tb3 on tb2.day=tb3.day



    Run a query to Download Data