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 where SELLING_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 ) ) , breakdownTb as ( select buyer, count(*) as n_trades, -- count(distinct buyer) as n_traders, sum(AMOUNT_usd) as trade_volume, median(AMOUNT_usd) as median_trade_volume, avg(AMOUNT_usd) avg_trade_volume, from operationEvent group by 1 ) select case when trade_volume < 100 then '< $100' when trade_volume < 500 then '100 ~ $500' when trade_volume < 1000 then '500 ~ $1000' when trade_volume < 10000 then '1000 ~ $10K' when trade_volume < 50000 then '10K ~ $50K' when trade_volume < 100000 then '50K ~ $100K' when trade_volume >= 10000 then '>= $100K' end as volume_break, case when n_trades < 10 then '< 10 Txs' when n_trades < 25 then '10 ~ 25 Txs' when n_trades < 50 then '25 ~ 50 Txs' when n_trades < 100 then '50 ~ 100 Txs' when n_trades >= 100 then '>= 100 Txs' end as trades_break, count(distinct buyer) as n_traders, from breakdownTb group by 1,2 order by 3 desc

Query	Creator	Created
By fact trades stellar	0xHaM-d	Feb 18, 2025
By fact trades Over Time stellar	0xHaM-d	Feb 18, 2025
Total Over Time stellar	0xHaM-d	Feb 18, 2025
By fact trades in Total copy stellar	0xHaM-d	Feb 18, 2025
Total stellar	0xHaM-d	Feb 18, 2025
By fact trades in Total stellar	0xHaM-d	Feb 18, 2025
Total by asset stellar	0xHaM-d	Feb 18, 2025

0xHaM-d