PREVIEW / futures_daily / 2014-03-11
file: by_date/futures_daily/2014/2014-03-11.parquet size: 9 KB rows: 100
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 |
|---|---|---|---|---|---|---|---|
| 2014-03-11 | ES | Futures | 1934.14 | 1940.33 | 1920.48 | 1922.8 | 1609666.0 |
| 2014-03-11 | NQ | Futures | 4262.17 | 4283.44 | 4231.7 | 4240.33 | 259716.0 |
| 2014-03-11 | YM | Futures | 16400.0 | 16454.2 | 16314.6 | 16332.7 | 7147.0 |
| 2014-03-11 | CL | Futures | 179.62 | 180.65 | 176.74 | 178.0 | 294201.0 |
| 2014-03-11 | GC | Futures | 1765.7 | 1783.5 | 1763.5 | 1775.2 | 150515.0 |
| 2014-03-11 | ZN | Futures | 114.620508 | 114.823324 | 114.504612 | 114.765377 | 1040177.0 |
| 2014-03-11 | A6 | Futures | 0.86109 | 0.86388 | 0.85523 | 0.856 | 30739.0 |
| 2014-03-11 | AD | Futures | 0.91065 | 0.9138 | 0.90883 | 0.91106 | 24306.0 |
| 2014-03-11 | B | Futures | 110.48 | 111.19 | 110.36 | 110.99 | 162825.0 |
| 2014-03-11 | B6 | Futures | 1.7481 | 1.749 | 1.7431 | 1.7463 | 59066.0 |
| 2014-03-11 | BR | Futures | 0.21822 | 0.21822 | 0.21785 | 0.21785 | 11.0 |
| 2014-03-11 | BZ | Futures | 112.6 | 113.41 | 112.58 | 113.21 | 6607.0 |
| 2014-03-11 | C | Futures | 1948.0 | 1980.0 | 1945.0 | 1969.0 | 10430.0 |
| 2014-03-11 | CB | Futures | 93.669 | 94.304 | 93.415 | 94.304 | 34.0 |
| 2014-03-11 | CC | Futures | 2213.0 | 2247.0 | 2210.0 | 2232.0 | 13644.0 |
| 2014-03-11 | CNH | Futures | 7.0437 | 7.0596 | 7.0421 | 7.0596 | 19.0 |
| 2014-03-11 | CSC | Futures | 4.363 | 4.375 | 4.348 | 4.348 | 43.0 |
| 2014-03-11 | CT | Futures | 103.03 | 103.67 | 102.28 | 103.01 | 8234.0 |
| 2014-03-11 | DC | Futures | 34.77 | 34.87 | 34.42 | 34.51 | 87.0 |
| 2014-03-11 | DX | Futures | 75.893 | 76.059 | 75.841 | 75.855 | 10966.0 |
| 2014-03-11 | E1 | Futures | 1.4633 | 1.4651 | 1.45881 | 1.46382 | 16313.0 |
| 2014-03-11 | E6 | Futures | 1.63824 | 1.63835 | 1.63292 | 1.63729 | 62112.0 |
| 2014-03-11 | E7 | Futures | 1.6272 | 1.6272 | 1.6223 | 1.6264 | 957.0 |
| 2014-03-11 | EBM | Futures | 291.0 | 296.98 | 289.94 | 296.28 | 19247.0 |
| 2014-03-11 | ED | Futures | 95.3899 | 95.3899 | 95.3851 | 95.3851 | 53233.0 |
| 2014-03-11 | ER | Futures | 97.832 | 97.847 | 97.822 | 97.837 | 83734.0 |
| 2014-03-11 | EW | Futures | 1420.9 | 1428.0 | 1408.2 | 1410.7 | 639.0 |
| 2014-03-11 | FBTP | Futures | 86.57 | 86.64 | 86.35 | 86.44 | 47556.0 |
| 2014-03-11 | FBTS | Futures | 97.047 | 97.073 | 97.003 | 97.038 | 7862.0 |
| 2014-03-11 | FCE | Futures | 3394.0 | 3402.5 | 3357.6 | 3369.6 | 103315.0 |
| 2014-03-11 | FDAX | Futures | 10303.8 | 10399.7 | 10265.5 | 10310.4 | 106716.0 |
| 2014-03-11 | FESX | Futures | 2177.3 | 2191.7 | 2164.4 | 2170.9 | 64766.0 |
| 2014-03-11 | FEU3 | Futures | 98.463 | 98.463 | 98.453 | 98.458 | 468.0 |
| 2014-03-11 | FGBL | Futures | 122.87 | 123.13 | 122.6 | 122.81 | 771089.0 |
| 2014-03-11 | FGBM | Futures | 119.39 | 119.53 | 119.28 | 119.38 | 502846.0 |
| 2014-03-11 | FGBS | Futures | 110.498 | 110.518 | 110.478 | 110.498 | 289054.0 |
| 2014-03-11 | FGBX | Futures | 125.32 | 125.54 | 124.41 | 124.79 | 22577.0 |
| 2014-03-11 | FMWO | Futures | 5522.7 | 5525.2 | 5502.5 | 5502.5 | 465.0 |
| 2014-03-11 | FOAT | Futures | 111.37 | 111.68 | 111.18 | 111.3 | 52089.0 |
| 2014-03-11 | FTDX | Futures | 1190.6 | 1190.6 | 1189.2 | 1189.2 | 1.0 |
| 2014-03-11 | FTI | Futures | 337.07 | 337.37 | 335.06 | 336.39 | 20.0 |
| 2014-03-11 | FTUK | Futures | 5051.6 | 5064.2 | 5020.4 | 5036.4 | 14771.0 |
| 2014-03-11 | FVSA | Futures | 1946.07 | 1961.0 | 1901.27 | 1956.02 | 8089.0 |
| 2014-03-11 | FXXP | Futures | 244.3 | 245.6 | 244.3 | 244.4 | 945.0 |
| 2014-03-11 | G | Futures | 92.64 | 92.86 | 92.57 | 92.76 | 163757.0 |
| 2014-03-11 | GF | Futures | 281.157 | 282.717 | 279.836 | 281.077 | 3164.0 |
| 2014-03-11 | GSCI | Futures | 1069.76 | 1069.76 | 1065.29 | 1066.12 | 2079.0 |
| 2014-03-11 | HE | Futures | 141.061 | 143.205 | 139.099 | 141.424 | 39972.0 |
| 2014-03-11 | HG | Futures | 3.8551 | 3.8741 | 3.7284 | 3.741 | 82355.0 |
| 2014-03-11 | HH | Futures | 60.75 | 60.88 | 59.629 | 60.033 | 1237.0 |
> showing 50 of 100 rows — these rows as CSV