DrsimonFrax and Osmosis -TRANSFERS m1
    Updated 2023-02-26
    with Frax as
    (
    select
    * ,
    DECIMAL as ddd
    from osmosis.core.dim_tokens
    where
    LABEL = 'Frax'
    or PROJECT_NAME = 'FRAX'
    or ADDRESS = 'ibc/0E43EDE2E2A3AFA36D0CD38BDDC0B49FECA64FA426A82E102F304E430ECF46EE'

    ) ,
    transfer
    as (
    select date_trunc('month', block_timestamp) as date, DECIMAL,
    case
    when date < '2022-11-08' then 'Before FTX & Alameda news'
    when date >= '2022-11-08' then 'After FTX & Alameda news'
    end as TYPE,
    count (distinct tx_id) as TX_Count
    from osmosis.core.fact_transfers
    where TX_SUCCEEDED = 'TRUE'
    and date >= '2020'
    and transfer_type = 'IBC_TRANSFER_IN'

    group by 1,2,3

    )
    select *
    from transfer as n
    inner join Frax as b
    on b.ddd = n.DECIMAL
    order by 1