VOLUME_BREAK | TRADES_BREAK | N_TRADERS | |
|---|---|---|---|
1 | >= $100K | < 10 Txs | 312 |
2 | 10K ~ $50K | < 10 Txs | 221 |
3 | 50K ~ $100K | < 10 Txs | 71 |
4 | 1000 ~ $10K | < 10 Txs | 53 |
5 | >= $100K | 10 ~ 25 Txs | 37 |
6 | >= $100K | 25 ~ 50 Txs | 4 |
7 | < $100 | < 10 Txs | 3 |
8 | >= $100K | 50 ~ 100 Txs | 2 |
9 | 1000 ~ $10K | 10 ~ 25 Txs | 1 |
10 | 50K ~ $100K | 25 ~ 50 Txs | 1 |
0xHaM-dBy fact trades in Total
Updated 2025-02-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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
Last run: 2 months ago
10
296B
1s