PREVIEW / futures_daily / 2011-09-13
file: by_date/futures_daily/2011/2011-09-13.parquet size: 9 KB rows: 98
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 |
|---|---|---|---|---|---|---|---|
| 2011-09-13 | ES | Futures | 1154.77 | 1168.67 | 1137.14 | 1163.46 | 1129051.0 |
| 2011-09-13 | NQ | Futures | 2499.29 | 2534.59 | 2467.4 | 2528.9 | 114565.0 |
| 2011-09-13 | YM | Futures | 10550.9 | 10630.7 | 10408.7 | 10587.4 | 151994.0 |
| 2011-09-13 | CL | Futures | 167.99 | 170.84 | 165.82 | 170.23 | 160623.0 |
| 2011-09-13 | GC | Futures | 2453.0 | 2494.4 | 2423.3 | 2470.9 | 186087.0 |
| 2011-09-13 | ZN | Futures | 111.925013 | 112.179754 | 111.589828 | 111.710494 | 1123239.0 |
| 2011-09-13 | A6 | Futures | 0.89987 | 0.90233 | 0.8924 | 0.89776 | 31478.0 |
| 2011-09-13 | AD | Futures | 1.00636 | 1.01376 | 1.00095 | 1.01216 | 29342.0 |
| 2011-09-13 | B | Futures | 95.14 | 95.42 | 93.69 | 94.19 | 190498.0 |
| 2011-09-13 | B6 | Futures | 1.6534 | 1.655 | 1.6437 | 1.6479 | 34643.0 |
| 2011-09-13 | BFX | Futures | 2491.7 | 2498.0 | 2437.7 | 2490.1 | 1022.0 |
| 2011-09-13 | BR | Futures | 0.25928 | 0.26086 | 0.2586 | 0.25995 | 145.0 |
| 2011-09-13 | BZ | Futures | 97.84 | 98.06 | 97.11 | 97.57 | 1270.0 |
| 2011-09-13 | C | Futures | 1957.0 | 1973.0 | 1951.0 | 1958.0 | 7284.0 |
| 2011-09-13 | CB | Futures | 96.025 | 96.025 | 96.025 | 96.025 | 3.0 |
| 2011-09-13 | CC | Futures | 2250.0 | 2264.0 | 2241.0 | 2246.0 | 6831.0 |
| 2011-09-13 | CSC | Futures | 4.329 | 4.329 | 4.329 | 4.329 | 2.0 |
| 2011-09-13 | CT | Futures | 143.75 | 145.06 | 142.49 | 144.78 | 122.0 |
| 2011-09-13 | DC | Futures | 30.21 | 30.46 | 30.2 | 30.41 | 342.0 |
| 2011-09-13 | DX | Futures | 76.427 | 76.78 | 75.965 | 76.07 | 30419.0 |
| 2011-09-13 | E1 | Futures | 1.49493 | 1.50214 | 1.48272 | 1.49873 | 8177.0 |
| 2011-09-13 | E6 | Futures | 1.63266 | 1.64126 | 1.61999 | 1.6378 | 128157.0 |
| 2011-09-13 | E7 | Futures | 1.6191 | 1.6271 | 1.6063 | 1.6238 | 1705.0 |
| 2011-09-13 | ED | Futures | 94.922 | 94.9364 | 94.8934 | 94.922 | 318659.0 |
| 2011-09-13 | ER | Futures | 97.44 | 97.485 | 97.351 | 97.376 | 273856.0 |
| 2011-09-13 | EW | Futures | 829.3 | 843.2 | 816.7 | 837.8 | 51338.0 |
| 2011-09-13 | FBTP | Futures | 62.23 | 62.42 | 61.11 | 61.65 | 17654.0 |
| 2011-09-13 | FBTS | Futures | 81.43 | 81.43 | 80.844 | 81.037 | 2308.0 |
| 2011-09-13 | FCE | Futures | 2061.0 | 2077.8 | 1972.8 | 2064.2 | 87919.0 |
| 2011-09-13 | FDAX | Futures | 5507.6 | 5582.4 | 5303.0 | 5499.6 | 348094.0 |
| 2011-09-13 | FESX | Futures | 1335.0 | 1356.9 | 1284.5 | 1339.7 | 1941759.0 |
| 2011-09-13 | FEU3 | Futures | 98.029 | 98.034 | 97.935 | 97.935 | 11.0 |
| 2011-09-13 | FGBL | Futures | 111.73 | 112.39 | 111.22 | 111.43 | 1077404.0 |
| 2011-09-13 | FGBM | Futures | 111.39 | 111.78 | 111.06 | 111.15 | 510174.0 |
| 2011-09-13 | FGBS | Futures | 109.258 | 109.372 | 109.089 | 109.109 | 568188.0 |
| 2011-09-13 | FGBX | Futures | 112.75 | 114.05 | 112.2 | 112.67 | 7747.0 |
| 2011-09-13 | FTDX | Futures | 637.1 | 637.1 | 618.7 | 632.0 | 791.0 |
| 2011-09-13 | FTI | Futures | 225.94 | 226.86 | 219.34 | 224.49 | 18092.0 |
| 2011-09-13 | FTUK | Futures | 3715.8 | 3737.7 | 3618.9 | 3696.1 | 151265.0 |
| 2011-09-13 | FVSA | Futures | 18342.65 | 19061.14 | 17941.14 | 18363.78 | 3064.0 |
| 2011-09-13 | FXXP | Futures | 150.6 | 154.0 | 149.9 | 153.1 | 6914.0 |
| 2011-09-13 | G | Futures | 92.48 | 93.09 | 92.27 | 92.4 | 117586.0 |
| 2011-09-13 | GF | Futures | 306.907 | 310.36 | 306.68 | 310.246 | 3323.0 |
| 2011-09-13 | GSCI | Futures | 1043.97 | 1045.31 | 1036.44 | 1041.19 | 1913.0 |
| 2011-09-13 | HE | Futures | 106.046 | 107.298 | 105.954 | 106.443 | 23000.0 |
| 2011-09-13 | HG | Futures | 5.2865 | 5.3256 | 5.2336 | 5.2534 | 36393.0 |
| 2011-09-13 | HO | Futures | 2.3855 | 2.398 | 2.3652 | 2.3747 | 27489.0 |
| 2011-09-13 | HRC | Futures | 2910.3 | 2910.3 | 2910.3 | 2910.3 | 0.0 |
| 2011-09-13 | J1 | Futures | 0.0163122 | 0.0163838 | 0.0162896 | 0.0163712 | 43579.0 |
| 2011-09-13 | J7 | Futures | 0.016216 | 0.016284 | 0.016199 | 0.016272 | 116.0 |
> showing 50 of 98 rows — these rows as CSV