flipside

    By fact trades
    0xHaM-dBy fact trades
    Updated 2025-02-18
    with operationEvent as (
    select
    SELLING_ASSET_CODE || '=>' || BUYING_ASSET_CODE as pair,
    BLOCK_TIMESTAMP,
    TRADE_ORDER,
    SELLING_ACCOUNT_ADDRESS as Seller,
    BUYING_ACCOUNT_ADDRESS as buyer,
    PRICE_D/PRICE_N as price,
    SELLING_AMOUNT as sell_AMOUNT,
    SELLING_AMOUNT*price as AMOUNT_usd,
    from stellar.defi.fact_trades
    where
    BUYING_ASSET_ISSUER ilike any (
    'GCK75CK3VX5L4ZLSD7HHNVA4L3LKGIAYWLCZO2IBNGOFTBV3HJBE2MPJ' -- GOLD- WTGOLD Commodities
    ,'GBHNGLLIE3KWGKCHIKMHJ5HVZHYIK7WTBE4QF5PLAKL4CJGSEU7HZIW5' -- BENJI- BENJI U.S. Treasuries
    ,'GDMBNMFJ3TRFLASJ6UGETFME3PJPNKPU24C7KFDBEBPQFG2CI6UC3JG6' -- WTGX- WTGXX U.S. Treasuries
    ,'GAJ4KSYLVBJKQ4UBPKJJXPYWVIRZWVTIYRMHBXTHGCDS4XJXXYEUALVD' -- TIPS- TIPSX U.S. Treasuries
    ,'GBTZKH3RNKW46XEZNCGZEBAGJISKDZKQXKSQ2N5G5SFX36TLWKKR6QJ6' -- FLTT- FLTTX U.S. Treasuries
    ,'GDEBI5X7J4IDXCSVV3KPFZIHQRCBVF3DAZMS5H7KYOBK45T6XYGDE77P' -- WTST- WTSTX U.S. Treasuries
    ,'GAK7PE7DD4ZRJQN3VBCQFBKFV53JGUM2SQATQAKLFK6MVONPGNYK34XH' -- WTLG- WTLGX U.S. Treasuries
    ,'GBBV5CF7UPA2PYRPA632URLB55BWML7X4H33ZRCDWMTULOXDGPHJR5VI' -- WTTS- WTTSX U.S. Treasuries
    ,'GB3ZUC7FGDEEBXY3BDEJWMPNGBFA66YRI4QQT6PBO3ZT6F33S7RL36VF' -- WTSY- WTSYX U.S. Treasuries
    )

    union all

    select
    SELLING_ASSET_CODE || '=>' || BUYING_ASSET_CODE as pair,
    BLOCK_TIMESTAMP,
    TRADE_ORDER,
    SELLING_ACCOUNT_ADDRESS as Seller,
    BUYING_ACCOUNT_ADDRESS as buyer,
    PRICE_N/PRICE_D as price,
    BUYING_AMOUNT as buy_AMOUNT,
    BUYING_AMOUNT*price as AMOUNT_usd
    from stellar.defi.fact_trades
    QueryRunArchived: QueryRun has been archived