PREVIEW / futures_daily / 2014-02-12
file: by_date/futures_daily/2014/2014-02-12.parquet size: 9 KB rows: 103
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-02-12 | ES | Futures | 1869.2 | 1879.51 | 1867.14 | 1873.07 | 1385941.0 |
| 2014-02-12 | NQ | Futures | 4152.38 | 4177.1 | 4150.37 | 4166.75 | 252230.0 |
| 2014-02-12 | YM | Futures | 15899.9 | 15982.7 | 15871.9 | 15917.8 | 123103.0 |
| 2014-02-12 | CL | Futures | 177.75 | 179.35 | 177.29 | 177.8 | 185433.0 |
| 2014-02-12 | GC | Futures | 1700.6 | 1708.9 | 1692.4 | 1707.1 | 111438.0 |
| 2014-02-12 | ZN | Futures | 114.934922 | 115.020769 | 114.54861 | 114.691689 | 1056413.0 |
| 2014-02-12 | A6 | Futures | 0.85902 | 0.86226 | 0.85644 | 0.85882 | 71033.0 |
| 2014-02-12 | AD | Futures | 0.91896 | 0.9219 | 0.91785 | 0.92018 | 45433.0 |
| 2014-02-12 | B | Futures | 111.14 | 111.92 | 110.97 | 111.26 | 249899.0 |
| 2014-02-12 | B6 | Futures | 1.7279 | 1.7434 | 1.7252 | 1.7431 | 157245.0 |
| 2014-02-12 | BR | Futures | 0.21482 | 0.21484 | 0.21236 | 0.2129 | 391.0 |
| 2014-02-12 | BZ | Futures | 113.44 | 114.18 | 113.22 | 113.51 | 9502.0 |
| 2014-02-12 | C | Futures | 1968.0 | 1983.0 | 1965.0 | 1975.0 | 12880.0 |
| 2014-02-12 | CB | Futures | 85.365 | 85.377 | 83.905 | 85.377 | 22.0 |
| 2014-02-12 | CC | Futures | 2175.0 | 2208.0 | 2175.0 | 2206.0 | 24542.0 |
| 2014-02-12 | CSC | Futures | 4.247 | 4.267 | 4.211 | 4.22 | 31.0 |
| 2014-02-12 | CT | Futures | 101.1 | 101.83 | 100.32 | 100.76 | 18365.0 |
| 2014-02-12 | DC | Futures | 32.86 | 33.03 | 32.32 | 32.57 | 406.0 |
| 2014-02-12 | DX | Futures | 76.747 | 76.947 | 76.619 | 76.781 | 18607.0 |
| 2014-02-12 | E1 | Futures | 1.42941 | 1.43185 | 1.42068 | 1.42608 | 34526.0 |
| 2014-02-12 | E6 | Futures | 1.60967 | 1.61168 | 1.60093 | 1.60471 | 224243.0 |
| 2014-02-12 | E7 | Futures | 1.5993 | 1.601 | 1.5904 | 1.5942 | 4006.0 |
| 2014-02-12 | EBM | Futures | 272.17 | 273.22 | 271.48 | 272.52 | 15786.0 |
| 2014-02-12 | ED | Futures | 95.3758 | 95.3853 | 95.3758 | 95.3805 | 110346.0 |
| 2014-02-12 | ER | Futures | 97.867 | 97.881 | 97.867 | 97.876 | 70045.0 |
| 2014-02-12 | EW | Futures | 1348.8 | 1362.3 | 1348.8 | 1359.2 | 15029.0 |
| 2014-02-12 | FBTP | Futures | 84.71 | 84.91 | 84.33 | 84.47 | 48477.0 |
| 2014-02-12 | FBTS | Futures | 96.468 | 96.52 | 96.354 | 96.389 | 9327.0 |
| 2014-02-12 | FCE | Futures | 3332.4 | 3349.8 | 3324.2 | 3336.3 | 3341.0 |
| 2014-02-12 | FDAX | Futures | 10548.9 | 10646.5 | 10530.6 | 10572.7 | 104236.0 |
| 2014-02-12 | FESX | Futures | 2173.2 | 2188.6 | 2167.5 | 2176.0 | 866452.0 |
| 2014-02-12 | FEU3 | Futures | 98.488 | 98.492 | 98.488 | 98.492 | 250.0 |
| 2014-02-12 | FGBL | Futures | 122.16 | 122.25 | 121.76 | 121.83 | 702091.0 |
| 2014-02-12 | FGBM | Futures | 119.18 | 119.25 | 119.0 | 119.06 | 489121.0 |
| 2014-02-12 | FGBS | Futures | 110.618 | 110.638 | 110.593 | 110.608 | 342832.0 |
| 2014-02-12 | FGBX | Futures | 124.21 | 124.39 | 123.45 | 123.67 | 14965.0 |
| 2014-02-12 | FMWO | Futures | 5386.8 | 5386.8 | 5376.7 | 5376.7 | 7.0 |
| 2014-02-12 | FOAT | Futures | 110.43 | 110.59 | 110.21 | 110.25 | 48333.0 |
| 2014-02-12 | FTDX | Futures | 1173.2 | 1178.9 | 1173.2 | 1176.5 | 260.0 |
| 2014-02-12 | FTI | Futures | 338.22 | 341.13 | 338.22 | 339.59 | 289.0 |
| 2014-02-12 | FTUK | Futures | 5020.0 | 5047.2 | 5013.1 | 5019.6 | 92005.0 |
| 2014-02-12 | FVSA | Futures | 1846.52 | 1866.43 | 1811.68 | 1861.46 | 7296.0 |
| 2014-02-12 | FXXP | Futures | 242.1 | 244.2 | 242.1 | 243.0 | 6656.0 |
| 2014-02-12 | G | Futures | 93.06 | 93.12 | 92.46 | 92.51 | 192315.0 |
| 2014-02-12 | GF | Futures | 272.151 | 273.078 | 271.224 | 271.667 | 2881.0 |
| 2014-02-12 | GSCI | Futures | 1045.4 | 1049.26 | 1042.85 | 1043.92 | 1479.0 |
| 2014-02-12 | HE | Futures | 113.918 | 114.824 | 112.922 | 113.978 | 20650.0 |
| 2014-02-12 | HG | Futures | 4.0757 | 4.1218 | 4.0688 | 4.1124 | 55392.0 |
| 2014-02-12 | HH | Futures | 53.198 | 53.208 | 50.797 | 51.232 | 4526.0 |
| 2014-02-12 | HO | Futures | 2.4226 | 2.4455 | 2.4005 | 2.4084 | 69739.0 |
> showing 50 of 103 rows — these rows as CSV