PREVIEW / futures_daily / 2012-02-03
file: by_date/futures_daily/2012/2012-02-03.parquet size: 9 KB rows: 99
schema
date DATE symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| date | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2012-02-03 | ES | Futures | 1327.47 | 1346.79 | 1324.71 | 1343.78 | 1710648.0 |
| 2012-02-03 | NQ | Futures | 2849.84 | 2893.3 | 2847.27 | 2885.29 | 168427.0 |
| 2012-02-03 | YM | Futures | 12249.9 | 12410.5 | 12228.7 | 12371.8 | 86879.0 |
| 2012-02-03 | CL | Futures | 180.56 | 183.21 | 179.43 | 182.85 | 318638.0 |
| 2012-02-03 | GC | Futures | 2359.1 | 2364.8 | 2311.6 | 2330.5 | 191907.0 |
| 2012-02-03 | ZN | Futures | 114.218455 | 114.353481 | 113.46231 | 113.489315 | 1345585.0 |
| 2012-02-03 | A6 | Futures | 0.94804 | 0.95614 | 0.94511 | 0.95534 | 128705.0 |
| 2012-02-03 | AD | Futures | 1.00342 | 1.01005 | 0.99941 | 1.00944 | 103008.0 |
| 2012-02-03 | B | Futures | 99.65 | 101.85 | 99.36 | 101.75 | 122906.0 |
| 2012-02-03 | B6 | Futures | 1.652 | 1.6574 | 1.6459 | 1.6543 | 99791.0 |
| 2012-02-03 | BFX | Futures | 2743.9 | 2767.5 | 2743.9 | 2767.5 | 6.0 |
| 2012-02-03 | BR | Futures | 0.27009 | 0.27126 | 0.27009 | 0.27121 | 1274.0 |
| 2012-02-03 | BZ | Futures | 106.59 | 108.43 | 106.59 | 108.43 | 1473.0 |
| 2012-02-03 | C | Futures | 1484.0 | 1555.0 | 1466.0 | 1531.0 | 6877.0 |
| 2012-02-03 | CB | Futures | 82.618 | 82.618 | 82.08 | 82.08 | 34.0 |
| 2012-02-03 | CC | Futures | 1725.0 | 1798.0 | 1703.0 | 1771.0 | 13195.0 |
| 2012-02-03 | CSC | Futures | 3.783 | 3.805 | 3.766 | 3.805 | 22.0 |
| 2012-02-03 | CT | Futures | 122.35 | 126.04 | 121.22 | 124.08 | 14113.0 |
| 2012-02-03 | DC | Futures | 26.48 | 26.88 | 26.04 | 26.67 | 486.0 |
| 2012-02-03 | DX | Futures | 77.014 | 77.364 | 76.712 | 76.947 | 25748.0 |
| 2012-02-03 | E1 | Futures | 1.43247 | 1.43904 | 1.42197 | 1.4309 | 37522.0 |
| 2012-02-03 | E6 | Futures | 1.57146 | 1.57983 | 1.5619 | 1.5723 | 357602.0 |
| 2012-02-03 | E7 | Futures | 1.5567 | 1.5646 | 1.5475 | 1.5579 | 6499.0 |
| 2012-02-03 | EBM | Futures | 281.73 | 285.66 | 279.43 | 284.68 | 11680.0 |
| 2012-02-03 | ED | Futures | 95.1298 | 95.1298 | 95.1107 | 95.1202 | 185385.0 |
| 2012-02-03 | ER | Futures | 97.489 | 97.489 | 97.44 | 97.449 | 82535.0 |
| 2012-02-03 | EW | Futures | 960.9 | 978.5 | 959.5 | 974.6 | 18096.0 |
| 2012-02-03 | FBTP | Futures | 64.69 | 65.06 | 64.05 | 64.23 | 15005.0 |
| 2012-02-03 | FBTS | Futures | 84.529 | 84.641 | 84.28 | 84.432 | 1086.0 |
| 2012-02-03 | FCE | Futures | 2406.8 | 2442.4 | 2392.2 | 2435.3 | 93223.0 |
| 2012-02-03 | FDAX | Futures | 7358.0 | 7503.8 | 7332.1 | 7474.0 | 145950.0 |
| 2012-02-03 | FESX | Futures | 1658.0 | 1688.1 | 1650.0 | 1680.7 | 1186968.0 |
| 2012-02-03 | FEU3 | Futures | 98.004 | 98.004 | 98.004 | 98.004 | 210.0 |
| 2012-02-03 | FGBL | Futures | 112.76 | 112.96 | 111.78 | 111.94 | 730110.0 |
| 2012-02-03 | FGBM | Futures | 113.47 | 113.58 | 112.9 | 113.11 | 390812.0 |
| 2012-02-03 | FGBS | Futures | 109.859 | 109.899 | 109.83 | 109.869 | 423133.0 |
| 2012-02-03 | FGBX | Futures | 117.36 | 117.88 | 115.77 | 116.03 | 5191.0 |
| 2012-02-03 | FTDX | Futures | 708.3 | 724.1 | 706.0 | 715.7 | 110.0 |
| 2012-02-03 | FTI | Futures | 269.47 | 273.4 | 267.46 | 272.27 | 36618.0 |
| 2012-02-03 | FTUK | Futures | 4156.3 | 4240.4 | 4140.5 | 4224.1 | 105074.0 |
| 2012-02-03 | FVSA | Futures | 9948.86 | 10025.69 | 9564.74 | 9583.94 | 5581.0 |
| 2012-02-03 | FXXP | Futures | 183.5 | 186.5 | 183.0 | 186.3 | 3230.0 |
| 2012-02-03 | G | Futures | 94.26 | 94.43 | 93.34 | 93.53 | 154091.0 |
| 2012-02-03 | GF | Futures | 329.4 | 330.354 | 327.014 | 327.544 | 3075.0 |
| 2012-02-03 | GSCI | Futures | 1035.66 | 1044.27 | 1034.41 | 1043.48 | 682.0 |
| 2012-02-03 | HE | Futures | 108.22 | 109.247 | 107.163 | 107.465 | 13993.0 |
| 2012-02-03 | HG | Futures | 4.997 | 5.1632 | 4.9825 | 5.1461 | 55113.0 |
| 2012-02-03 | HO | Futures | 2.4775 | 2.5238 | 2.4668 | 2.5204 | 64351.0 |
| 2012-02-03 | HRC | Futures | 2837.4 | 2837.4 | 2837.4 | 2837.4 | 0.0 |
| 2012-02-03 | J1 | Futures | 0.0164854 | 0.0164967 | 0.0163674 | 0.0164038 | 95162.0 |
> showing 50 of 99 rows — these rows as CSV