Hessishdex ch - Weekly IBC transfer
    Updated 2022-11-16
    select date_trunc('week',block_timestamp) as date ,-1*count(tx_id) as txs
    ,TRANSFER_TYPE,-1*count(DISTINCT SENDER) as wallet
    from osmosis.core.fact_transfers
    --join osmosis.core.dim_labels
    -- on ADDRESS = CURRENCY
    WHERE TRANSFER_TYPE = 'IBC_TRANSFER_OUT'
    and BLOCK_TIMESTAMP >= CURRENT_DATE - 60
    GROUP by 1,3
    union
    select date_trunc('week',block_timestamp) as date ,count(tx_id) as txs
    ,TRANSFER_TYPE,count(DISTINCT SENDER) as wallet
    from osmosis.core.fact_transfers
    -- join osmosis.core.dim_labels
    --on ADDRESS = CURRENCY
    WHERE TRANSFER_TYPE = 'IBC_TRANSFER_IN'
    and BLOCK_TIMESTAMP >= CURRENT_DATE - 60
    GROUP by 1,3

    Run a query to Download Data