PREVIEW / futures_daily / 2014-03-17
file: by_date/futures_daily/2014/2014-03-17.parquet size: 9 KB rows: 105
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-17 | ES | Futures | 1895.71 | 1920.03 | 1886.66 | 1914.86 | 1854428.0 |
| 2014-03-17 | NQ | Futures | 4168.73 | 4228.01 | 4146.28 | 4203.26 | 308493.0 |
| 2014-03-17 | YM | Futures | 16056.6 | 16273.4 | 15976.2 | 16232.3 | 167480.0 |
| 2014-03-17 | CL | Futures | 176.33 | 176.69 | 173.1 | 174.21 | 146507.0 |
| 2014-03-17 | GC | Futures | 1823.2 | 1835.7 | 1795.3 | 1809.8 | 154349.0 |
| 2014-03-17 | ZN | Futures | 115.518697 | 115.634592 | 115.214471 | 115.228958 | 912331.0 |
| 2014-03-17 | A6 | Futures | 0.86167 | 0.86868 | 0.86032 | 0.86762 | 60771.0 |
| 2014-03-17 | AD | Futures | 0.91167 | 0.91613 | 0.91076 | 0.91552 | 48847.0 |
| 2014-03-17 | B | Futures | 111.67 | 111.73 | 109.22 | 109.3 | 166228.0 |
| 2014-03-17 | B6 | Futures | 1.7482 | 1.7505 | 1.744 | 1.7474 | 66911.0 |
| 2014-03-17 | BFX | Futures | 3651.7 | 3679.7 | 3651.7 | 3679.7 | 1.0 |
| 2014-03-17 | BR | Futures | 0.22001 | 0.22001 | 0.21982 | 0.21982 | 27.0 |
| 2014-03-17 | BZ | Futures | 113.81 | 113.86 | 111.39 | 111.49 | 6790.0 |
| 2014-03-17 | C | Futures | 1967.0 | 1993.0 | 1959.0 | 1990.0 | 5550.0 |
| 2014-03-17 | CB | Futures | 92.654 | 94.431 | 92.654 | 94.431 | 22.0 |
| 2014-03-17 | CC | Futures | 2233.0 | 2256.0 | 2208.0 | 2250.0 | 10382.0 |
| 2014-03-17 | CNH | Futures | 7.087 | 7.0908 | 7.0822 | 7.0829 | 5.0 |
| 2014-03-17 | CSC | Futures | 4.399 | 4.562 | 4.399 | 4.538 | 31.0 |
| 2014-03-17 | CT | Futures | 103.57 | 103.94 | 103.02 | 103.44 | 6222.0 |
| 2014-03-17 | DC | Futures | 35.32 | 36.4 | 35.32 | 36.4 | 320.0 |
| 2014-03-17 | DX | Futures | 75.579 | 75.708 | 75.442 | 75.545 | 13874.0 |
| 2014-03-17 | E1 | Futures | 1.47177 | 1.4737 | 1.46677 | 1.47075 | 21711.0 |
| 2014-03-17 | E6 | Futures | 1.64237 | 1.6465 | 1.63835 | 1.6432 | 133961.0 |
| 2014-03-17 | E7 | Futures | 1.6314 | 1.6355 | 1.6276 | 1.6322 | 3046.0 |
| 2014-03-17 | EBM | Futures | 298.04 | 298.39 | 292.4 | 292.76 | 11052.0 |
| 2014-03-17 | ED | Futures | 95.3804 | 95.3851 | 95.3756 | 95.3851 | 121037.0 |
| 2014-03-17 | ER | Futures | 97.827 | 97.837 | 97.817 | 97.827 | 76031.0 |
| 2014-03-17 | EW | Futures | 1404.1 | 1421.9 | 1396.1 | 1412.9 | 39139.0 |
| 2014-03-17 | FBTP | Futures | 86.49 | 86.72 | 86.33 | 86.65 | 28286.0 |
| 2014-03-17 | FBTS | Futures | 96.968 | 97.073 | 96.968 | 97.056 | 5772.0 |
| 2014-03-17 | FCE | Futures | 3270.0 | 3319.8 | 3268.5 | 3314.4 | 73143.0 |
| 2014-03-17 | FDAX | Futures | 10039.3 | 10179.5 | 10022.2 | 10163.5 | 23082.0 |
| 2014-03-17 | FDIV | Futures | 137.34 | 137.34 | 137.34 | 137.34 | 1436.0 |
| 2014-03-17 | FESX | Futures | 2110.5 | 2145.0 | 2109.1 | 2142.9 | 582977.0 |
| 2014-03-17 | FGBL | Futures | 123.72 | 123.88 | 123.51 | 123.61 | 578487.0 |
| 2014-03-17 | FGBM | Futures | 119.73 | 119.85 | 119.66 | 119.71 | 360790.0 |
| 2014-03-17 | FGBS | Futures | 110.518 | 110.553 | 110.513 | 110.533 | 221344.0 |
| 2014-03-17 | FGBX | Futures | 126.34 | 126.58 | 125.93 | 126.09 | 16219.0 |
| 2014-03-17 | FMWO | Futures | 5425.8 | 5453.5 | 5425.8 | 5453.5 | 930.0 |
| 2014-03-17 | FOAT | Futures | 112.12 | 112.3 | 112.07 | 112.15 | 37589.0 |
| 2014-03-17 | FTDX | Futures | 1150.3 | 1165.8 | 1150.3 | 1165.8 | 19.0 |
| 2014-03-17 | FTI | Futures | 326.15 | 331.14 | 326.15 | 330.12 | 5781.0 |
| 2014-03-17 | FTUK | Futures | 4930.0 | 4983.0 | 4923.5 | 4965.1 | 105048.0 |
| 2014-03-17 | FVSA | Futures | 2076.39 | 2096.45 | 1976.08 | 1991.13 | 23281.0 |
| 2014-03-17 | FXXP | Futures | 238.2 | 240.5 | 238.2 | 240.3 | 9815.0 |
| 2014-03-17 | G | Futures | 93.9 | 93.91 | 93.62 | 93.74 | 119493.0 |
| 2014-03-17 | GF | Futures | 283.358 | 285.159 | 283.198 | 284.919 | 1707.0 |
| 2014-03-17 | GSCI | Futures | 1058.68 | 1059.76 | 1052.24 | 1052.9 | 259.0 |
| 2014-03-17 | HE | Futures | 145.59 | 147.704 | 145.53 | 146.979 | 20121.0 |
| 2014-03-17 | HG | Futures | 3.7315 | 3.7841 | 3.7024 | 3.741 | 50706.0 |
> showing 50 of 105 rows — these rows as CSV