N_TRADES | N_TRADERS | TRADE_VOLUME | |
|---|---|---|---|
1 | 817047 | 674254 | 17297492484.5213 |
0xHaM-dTotal
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
BLOCK_TIMESTAMP,
TX_ID,
TRANSACTION_HASH,
TX_ACCOUNT,
PARSE_JSON(TX_SIGNERS)[0]::string as TX_SIGNERS,
BUYING_ASSET_CODE,
PRICE[0]::float as price_,
SELLING_ASSET_CODE,
AMOUNT,
price_*AMOUNT as volume
from stellar.core.ez_operations
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
)
or 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
)
and SUCCESSFUL = 'true'
Last run: 27 days ago
1
34B
50s