PREVIEW / futures_daily / 2011-01-26
file: by_date/futures_daily/2011/2011-01-26.parquet size: 9 KB rows: 93
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-01-26 | ES | Futures | 1267.07 | 1276.42 | 1265.84 | 1273.22 | 1609255.0 |
| 2011-01-26 | NQ | Futures | 2611.48 | 2633.91 | 2608.93 | 2632.2 | 218232.0 |
| 2011-01-26 | YM | Futures | 11156.3 | 11204.9 | 11147.8 | 11171.2 | 99816.0 |
| 2011-01-26 | CL | Futures | 175.42 | 178.6 | 175.02 | 177.66 | 347753.0 |
| 2011-01-26 | GC | Futures | 1810.9 | 1829.3 | 1799.4 | 1811.1 | 85450.0 |
| 2011-01-26 | ZN | Futures | 100.504541 | 100.517539 | 99.958603 | 100.036594 | 1052068.0 |
| 2011-01-26 | A6 | Futures | 0.83986 | 0.84283 | 0.83698 | 0.83961 | 73945.0 |
| 2011-01-26 | AD | Futures | 0.99493 | 0.99781 | 0.99324 | 0.99612 | 63330.0 |
| 2011-01-26 | B | Futures | 81.22 | 83.82 | 81.22 | 83.46 | 99639.0 |
| 2011-01-26 | B6 | Futures | 1.6406 | 1.6534 | 1.6352 | 1.6466 | 138207.0 |
| 2011-01-26 | BFX | Futures | 3062.6 | 3104.9 | 3062.6 | 3082.4 | 55.0 |
| 2011-01-26 | BR | Futures | 0.25612 | 0.25657 | 0.25584 | 0.25635 | 111.0 |
| 2011-01-26 | BZ | Futures | 88.64 | 89.61 | 88.64 | 89.18 | 834.0 |
| 2011-01-26 | C | Futures | 2444.0 | 2463.0 | 2389.0 | 2419.0 | 5936.0 |
| 2011-01-26 | CB | Futures | 118.215 | 118.509 | 118.215 | 118.509 | 4.0 |
| 2011-01-26 | CC | Futures | 2719.0 | 2755.0 | 2693.0 | 2720.0 | 11419.0 |
| 2011-01-26 | CSC | Futures | 3.994 | 3.994 | 3.994 | 3.994 | 1.0 |
| 2011-01-26 | CT | Futures | 139.81 | 143.06 | 137.89 | 143.06 | 10010.0 |
| 2011-01-26 | DC | Futures | 28.03 | 28.82 | 27.89 | 28.71 | 1200.0 |
| 2011-01-26 | DX | Futures | 77.994 | 78.094 | 77.67 | 77.895 | 20577.0 |
| 2011-01-26 | E1 | Futures | 1.39082 | 1.39501 | 1.38531 | 1.38911 | 30195.0 |
| 2011-01-26 | E6 | Futures | 1.61746 | 1.62243 | 1.61273 | 1.61781 | 297228.0 |
| 2011-01-26 | E7 | Futures | 1.6055 | 1.6104 | 1.6007 | 1.6058 | 6212.0 |
| 2011-01-26 | EBM | Futures | 240.12 | 242.61 | 240.12 | 241.48 | 6886.0 |
| 2011-01-26 | ED | Futures | 94.8337 | 94.8384 | 94.8289 | 94.8337 | 123410.0 |
| 2011-01-26 | ER | Futures | 97.257 | 97.281 | 97.242 | 97.267 | 237272.0 |
| 2011-01-26 | EW | Futures | 908.5 | 919.5 | 907.5 | 915.0 | 25453.0 |
| 2011-01-26 | FBTP | Futures | 63.96 | 64.03 | 63.71 | 63.74 | 8771.0 |
| 2011-01-26 | FCE | Futures | 2701.5 | 2715.5 | 2697.8 | 2702.5 | 102636.0 |
| 2011-01-26 | FDAX | Futures | 7605.2 | 7677.5 | 7596.7 | 7635.8 | 123029.0 |
| 2011-01-26 | FESX | Futures | 1849.5 | 1860.7 | 1842.7 | 1843.3 | 929117.0 |
| 2011-01-26 | FEU3 | Futures | 97.81 | 97.825 | 97.81 | 97.825 | 11.0 |
| 2011-01-26 | FGBL | Futures | 98.17 | 98.31 | 97.78 | 97.9 | 852837.0 |
| 2011-01-26 | FGBM | Futures | 103.64 | 103.74 | 103.35 | 103.44 | 586074.0 |
| 2011-01-26 | FGBS | Futures | 106.838 | 106.857 | 106.714 | 106.764 | 717095.0 |
| 2011-01-26 | FGBX | Futures | 96.05 | 96.14 | 94.9 | 95.08 | 6461.0 |
| 2011-01-26 | FTDX | Futures | 759.6 | 771.0 | 757.8 | 769.7 | 1134.0 |
| 2011-01-26 | FTI | Futures | 290.36 | 292.21 | 289.55 | 290.92 | 33993.0 |
| 2011-01-26 | FTUK | Futures | 4091.2 | 4146.8 | 4091.2 | 4127.3 | 89732.0 |
| 2011-01-26 | FXXP | Futures | 182.0 | 183.5 | 181.9 | 182.8 | 2034.0 |
| 2011-01-26 | G | Futures | 80.79 | 80.87 | 80.3 | 80.4 | 135316.0 |
| 2011-01-26 | GF | Futures | 309.019 | 311.486 | 308.279 | 311.116 | 2940.0 |
| 2011-01-26 | GSCI | Futures | 1001.46 | 1015.47 | 998.43 | 1011.97 | 163.0 |
| 2011-01-26 | HE | Futures | 101.688 | 105.16 | 101.513 | 105.16 | 30373.0 |
| 2011-01-26 | HG | Futures | 5.6654 | 5.7294 | 5.6294 | 5.6867 | 25498.0 |
| 2011-01-26 | HO | Futures | 2.1848 | 2.2447 | 2.1786 | 2.234 | 69351.0 |
| 2011-01-26 | HRC | Futures | 2797.9 | 2797.9 | 2797.9 | 2797.9 | 0.0 |
| 2011-01-26 | J1 | Futures | 0.0152817 | 0.0153231 | 0.0152026 | 0.0152289 | 97157.0 |
| 2011-01-26 | J7 | Futures | 0.015167 | 0.015213 | 0.015097 | 0.015121 | 118.0 |
| 2011-01-26 | JB | Futures | 120.58 | 120.74 | 120.48 | 120.63 | 2102.0 |
> showing 50 of 93 rows — these rows as CSV