PREVIEW / futures_daily / 2014-09-03
file: by_date/futures_daily/2014/2014-09-03.parquet size: 9 KB rows: 106
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-09-03 | ES | Futures | 2078.11 | 2089.02 | 2073.7 | 2076.29 | 1297828.0 |
| 2014-09-03 | NQ | Futures | 4722.13 | 4746.36 | 4687.23 | 4697.9 | 265476.0 |
| 2014-09-03 | YM | Futures | 17206.2 | 17308.1 | 17200.2 | 17226.4 | 116573.0 |
| 2014-09-03 | CL | Futures | 173.75 | 178.5 | 173.34 | 177.96 | 294395.0 |
| 2014-09-03 | GC | Futures | 1661.5 | 1668.9 | 1655.2 | 1666.2 | 107908.0 |
| 2014-09-03 | ZN | Futures | 117.484012 | 117.51319 | 117.046347 | 117.440246 | 116979.0 |
| 2014-09-03 | A6 | Futures | 0.89566 | 0.90311 | 0.8945 | 0.90253 | 124480.0 |
| 2014-09-03 | AD | Futures | 0.92901 | 0.93398 | 0.92779 | 0.93277 | 61207.0 |
| 2014-09-03 | ALI | Futures | 3054.99 | 3063.39 | 3054.99 | 3059.97 | 5.0 |
| 2014-09-03 | B | Futures | 105.54 | 108.29 | 105.52 | 107.95 | 135238.0 |
| 2014-09-03 | B6 | Futures | 1.731 | 1.7342 | 1.7282 | 1.7297 | 119284.0 |
| 2014-09-03 | BFX | Futures | 3865.9 | 3868.3 | 3856.5 | 3856.5 | 11.0 |
| 2014-09-03 | BR | Futures | 0.23602 | 0.23658 | 0.23602 | 0.23607 | 300.0 |
| 2014-09-03 | BZ | Futures | 106.45 | 109.03 | 106.42 | 108.71 | 12075.0 |
| 2014-09-03 | C | Futures | 2103.0 | 2126.0 | 2088.0 | 2103.0 | 4351.0 |
| 2014-09-03 | CB | Futures | 154.154 | 154.154 | 154.154 | 154.154 | 24.0 |
| 2014-09-03 | CC | Futures | 2330.0 | 2336.0 | 2321.0 | 2322.0 | 11315.0 |
| 2014-09-03 | CNH | Futures | 7.05 | 7.05 | 7.0464 | 7.0464 | 1.0 |
| 2014-09-03 | CSC | Futures | 5.148 | 5.148 | 5.124 | 5.124 | 5.0 |
| 2014-09-03 | CT | Futures | 83.59 | 84.14 | 83.32 | 84.14 | 19.0 |
| 2014-09-03 | DC | Futures | 41.64 | 41.64 | 41.16 | 41.18 | 100.0 |
| 2014-09-03 | DX | Futures | 78.791 | 78.857 | 78.653 | 78.68 | 17194.0 |
| 2014-09-03 | E1 | Futures | 1.39443 | 1.39712 | 1.3934 | 1.39661 | 48516.0 |
| 2014-09-03 | E6 | Futures | 1.54972 | 1.55291 | 1.54843 | 1.55114 | 191738.0 |
| 2014-09-03 | E7 | Futures | 1.5399 | 1.5427 | 1.5383 | 1.541 | 2203.0 |
| 2014-09-03 | ED | Futures | 95.4162 | 95.4186 | 95.4139 | 95.4162 | 95855.0 |
| 2014-09-03 | ER | Futures | 97.955 | 97.965 | 97.955 | 97.96 | 51219.0 |
| 2014-09-03 | EW | Futures | 1495.2 | 1506.8 | 1491.5 | 1492.6 | 13717.0 |
| 2014-09-03 | FBTP | Futures | 94.64 | 94.71 | 94.34 | 94.43 | 143311.0 |
| 2014-09-03 | FBTS | Futures | 98.765 | 98.819 | 98.765 | 98.783 | 31350.0 |
| 2014-09-03 | FCE | Futures | 3494.2 | 3540.0 | 3490.2 | 3520.1 | 133418.0 |
| 2014-09-03 | FDAX | Futures | 10480.6 | 10666.7 | 10480.0 | 10592.4 | 145602.0 |
| 2014-09-03 | FESX | Futures | 2289.3 | 2326.7 | 2288.6 | 2313.1 | 1580228.0 |
| 2014-09-03 | FEU3 | Futures | 98.581 | 98.581 | 98.581 | 98.581 | 2032.0 |
| 2014-09-03 | FGBL | Futures | 131.33 | 131.38 | 130.9 | 131.16 | 1470221.0 |
| 2014-09-03 | FGBM | Futures | 122.5 | 122.52 | 122.34 | 122.46 | 1039434.0 |
| 2014-09-03 | FGBS | Futures | 110.893 | 110.903 | 110.863 | 110.873 | 656200.0 |
| 2014-09-03 | FGBX | Futures | 141.97 | 142.14 | 140.98 | 141.23 | 68399.0 |
| 2014-09-03 | FMWO | Futures | 5846.9 | 5851.9 | 5833.0 | 5833.0 | 644.0 |
| 2014-09-03 | FOAT | Futures | 121.33 | 121.33 | 120.92 | 121.06 | 170159.0 |
| 2014-09-03 | FTDX | Futures | 1174.3 | 1187.9 | 1174.3 | 1180.9 | 95.0 |
| 2014-09-03 | FTI | Futures | 357.81 | 361.04 | 357.81 | 359.49 | 31113.0 |
| 2014-09-03 | FTUK | Futures | 5251.9 | 5308.1 | 5249.6 | 5288.8 | 115909.0 |
| 2014-09-03 | FVSA | Futures | 1497.88 | 1497.88 | 1442.24 | 1463.64 | 9644.0 |
| 2014-09-03 | FXXP | Futures | 258.6 | 261.2 | 258.6 | 260.0 | 21438.0 |
| 2014-09-03 | G | Futures | 96.73 | 96.74 | 96.17 | 96.47 | 211528.0 |
| 2014-09-03 | GF | Futures | 342.378 | 346.334 | 341.912 | 345.481 | 1464.0 |
| 2014-09-03 | GSCI | Futures | 1010.15 | 1020.3 | 1009.15 | 1018.45 | 160.0 |
| 2014-09-03 | HE | Futures | 121.228 | 123.615 | 120.532 | 122.225 | 25223.0 |
| 2014-09-03 | HG | Futures | 4.0044 | 4.0164 | 3.9644 | 3.9663 | 46695.0 |
> showing 50 of 106 rows — these rows as CSV