FECHA | MONEDA | CANTIDAD | PRECIO | VALOR | |
|---|---|---|---|---|---|
1 | 17/03/2025 | $OSMO | 1464.47 | 0.29 | $424.6963 |
2 | 17/03/2025 | $AXL | 913.555 | 0.41 | $374.55755 |
Popex404Osmosis #2 Pool #1094
Updated 3 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
⌄
SELECT
'17/03/2025' AS Fecha, -- Formato personalizado
'$OSMO' AS Moneda,
1464.47 AS Cantidad,
0.29 AS Precio,
'$' || TO_VARCHAR(Cantidad * Precio) AS Valor
UNION ALL
SELECT
'17/03/2025' AS Fecha, -- Formato personalizado
'$AXL' AS Moneda,
913.555 AS Cantidad,
0.41 AS Precio,
'$' || TO_VARCHAR(Cantidad * Precio) AS Valor
/*
UNION ALL
SELECT
TO_CHAR(CURRENT_DATE(), 'DD/MM/YYYY') AS Fecha, -- Formato personalizado
'$BTC' AS Moneda,
0.5 AS Cantidad,
45000 AS Precio,
'$' || TO_VARCHAR(0.5 * 45000) AS Valor;
*/
Last run: 3 days ago
2
97B
0s