N_TRADES | N_TRADERS | TRADE_VOLUME | MEDIAN_TRADE_VOLUME | AVG_TRADE_VOLUME | |
|---|---|---|---|---|---|
1 | 2438 | 705 | 733591645.390951 | 31264.977088169 | 300898.952170202 |
0xHaM-dBy fact trades in Total copy
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
›
⌄
-- forked from By fact trades in Total @ https://flipsidecrypto.xyz/studio/queries/d7abdc1e-b9bf-48c7-bf77-9cc7842224ea
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,
Last run: 30 days ago
1
62B
1s