PREVIEW / futures_daily / 2012-01-09
file: by_date/futures_daily/2012/2012-01-09.parquet size: 9 KB rows: 96
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 |
|---|---|---|---|---|---|---|---|
| 2012-01-09 | ES | Futures | 1279.3 | 1282.31 | 1271.77 | 1280.05 | 1438170.0 |
| 2012-01-09 | NQ | Futures | 2691.17 | 2702.89 | 2674.3 | 2683.74 | 152188.0 |
| 2012-01-09 | YM | Futures | 11906.6 | 11945.3 | 11848.6 | 11930.8 | 88483.0 |
| 2012-01-09 | CL | Futures | 190.48 | 190.91 | 187.08 | 189.34 | 311866.0 |
| 2012-01-09 | GC | Futures | 2184.1 | 2193.5 | 2167.9 | 2171.2 | 134386.0 |
| 2012-01-09 | ZN | Futures | 112.989719 | 113.313781 | 112.84119 | 113.084237 | 526956.0 |
| 2012-01-09 | A6 | Futures | 0.90123 | 0.90577 | 0.89571 | 0.90355 | 84221.0 |
| 2012-01-09 | AD | Futures | 0.97331 | 0.98024 | 0.9711 | 0.97833 | 62981.0 |
| 2012-01-09 | B | Futures | 100.82 | 101.22 | 99.52 | 100.1 | 155509.0 |
| 2012-01-09 | B6 | Futures | 1.611 | 1.6162 | 1.6084 | 1.6129 | 49997.0 |
| 2012-01-09 | BFX | Futures | 2510.5 | 2516.6 | 2497.0 | 2505.3 | 341.0 |
| 2012-01-09 | BR | Futures | 0.24996 | 0.25188 | 0.24996 | 0.25125 | 304.0 |
| 2012-01-09 | BZ | Futures | 106.9 | 107.24 | 105.65 | 106.23 | 969.0 |
| 2012-01-09 | C | Futures | 1363.0 | 1473.0 | 1357.0 | 1456.0 | 11660.0 |
| 2012-01-09 | CB | Futures | 90.799 | 90.961 | 90.476 | 90.961 | 33.0 |
| 2012-01-09 | CC | Futures | 1572.0 | 1705.0 | 1568.0 | 1682.0 | 16601.0 |
| 2012-01-09 | CT | Futures | 123.64 | 124.8 | 120.06 | 124.21 | 16481.0 |
| 2012-01-09 | DC | Futures | 30.02 | 30.27 | 29.55 | 29.6 | 371.0 |
| 2012-01-09 | DX | Futures | 79.491 | 79.671 | 79.087 | 79.216 | 16302.0 |
| 2012-01-09 | E1 | Futures | 1.37275 | 1.38482 | 1.3692 | 1.38194 | 23167.0 |
| 2012-01-09 | E6 | Futures | 1.51803 | 1.52891 | 1.5148 | 1.52532 | 186645.0 |
| 2012-01-09 | E7 | Futures | 1.5045 | 1.5149 | 1.5008 | 1.5114 | 3484.0 |
| 2012-01-09 | EBM | Futures | 257.81 | 264.37 | 257.49 | 263.71 | 11967.0 |
| 2012-01-09 | ED | Futures | 94.9674 | 95.0056 | 94.9674 | 94.996 | 206264.0 |
| 2012-01-09 | ER | Futures | 97.346 | 97.351 | 97.331 | 97.341 | 73026.0 |
| 2012-01-09 | EW | Futures | 892.3 | 902.1 | 890.2 | 899.1 | 21876.0 |
| 2012-01-09 | FBTP | Futures | 57.33 | 57.71 | 57.13 | 57.32 | 4926.0 |
| 2012-01-09 | FBTS | Futures | 79.801 | 79.921 | 79.672 | 79.672 | 1208.0 |
| 2012-01-09 | FCE | Futures | 2237.0 | 2261.7 | 2229.5 | 2240.6 | 56458.0 |
| 2012-01-09 | FDAX | Futures | 6650.7 | 6718.1 | 6617.6 | 6656.2 | 133871.0 |
| 2012-01-09 | FESX | Futures | 1522.3 | 1542.4 | 1519.0 | 1524.3 | 815651.0 |
| 2012-01-09 | FGBL | Futures | 112.51 | 112.58 | 112.07 | 112.57 | 346760.0 |
| 2012-01-09 | FGBM | Futures | 113.28 | 113.29 | 113.0 | 113.22 | 219243.0 |
| 2012-01-09 | FGBS | Futures | 109.924 | 109.944 | 109.864 | 109.934 | 233017.0 |
| 2012-01-09 | FGBX | Futures | 117.92 | 118.05 | 117.01 | 117.97 | 4398.0 |
| 2012-01-09 | FTDX | Futures | 664.6 | 664.6 | 658.1 | 660.0 | 48.0 |
| 2012-01-09 | FTI | Futures | 260.05 | 263.4 | 260.05 | 261.72 | 32778.0 |
| 2012-01-09 | FTUK | Futures | 4030.5 | 4064.7 | 4011.7 | 4020.7 | 78574.0 |
| 2012-01-09 | FVSA | Futures | 12201.65 | 12281.4 | 12042.15 | 12161.77 | 633.0 |
| 2012-01-09 | FXXP | Futures | 174.6 | 174.9 | 173.3 | 173.4 | 2253.0 |
| 2012-01-09 | G | Futures | 94.63 | 94.82 | 94.35 | 94.75 | 61879.0 |
| 2012-01-09 | GF | Futures | 317.511 | 319.665 | 316.649 | 318.372 | 918.0 |
| 2012-01-09 | GSCI | Futures | 1041.14 | 1043.96 | 1031.73 | 1039.96 | 2612.0 |
| 2012-01-09 | HE | Futures | 103.739 | 103.801 | 102.383 | 102.784 | 25490.0 |
| 2012-01-09 | HG | Futures | 4.5301 | 4.54 | 4.4556 | 4.5057 | 34685.0 |
| 2012-01-09 | HO | Futures | 2.4922 | 2.4991 | 2.4676 | 2.483 | 26335.0 |
| 2012-01-09 | HRC | Futures | 2876.8 | 2876.8 | 2876.8 | 2876.8 | 32.0 |
| 2012-01-09 | J1 | Futures | 0.0163573 | 0.0163724 | 0.0163209 | 0.0163485 | 33661.0 |
| 2012-01-09 | J7 | Futures | 0.016281 | 0.016302 | 0.016253 | 0.016281 | 186.0 |
| 2012-01-09 | JB | Futures | 124.51 | 124.66 | 124.5 | 124.62 | 211.0 |
> showing 50 of 96 rows — these rows as CSV