flipside

    ATR 4
    sunshine-juliaATR 4
    Updated 2022-12-01
    select BLOCK_TIMESTAMP::date as day, count (distinct tx_id) as number_of_transactions,
    count (distinct trader) as number_of_buyer,
    sum (to_amount/pow(10,to_decimal)) as AXL_Amount
    from osmosis.core.fact_swaps
    where to_currency ilike 'ibc/903A61A498756EA560B85A85132D3AEE21B5DEDD41213725D22ABF276EA6945E'
    and tx_status ilike 'SUCCEEDED' and BLOCK_TIMESTAMP::date <= current_date - 1
    group by 1
    Run a query to Download Data