PREVIEW / futures_daily / 2013-08-16
file: by_date/futures_daily/2013/2013-08-16.parquet size: 9 KB rows: 102
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 |
|---|---|---|---|---|---|---|---|
| 2013-08-16 | ES | Futures | 1704.33 | 1711.8 | 1698.92 | 1700.47 | 1739935.0 |
| 2013-08-16 | NQ | Futures | 3553.24 | 3574.36 | 3549.2 | 3550.93 | 189035.0 |
| 2013-08-16 | YM | Futures | 14926.8 | 14979.4 | 14895.1 | 14905.0 | 146206.0 |
| 2013-08-16 | CL | Futures | 188.11 | 189.76 | 187.03 | 188.6 | 185111.0 |
| 2013-08-16 | GC | Futures | 1806.1 | 1824.1 | 1794.7 | 1813.2 | 177729.0 |
| 2013-08-16 | ZN | Futures | 112.675225 | 112.717336 | 111.98741 | 112.282188 | 1145450.0 |
| 2013-08-16 | A6 | Futures | 0.85606 | 0.86301 | 0.85447 | 0.86151 | 87243.0 |
| 2013-08-16 | AD | Futures | 0.97681 | 0.97812 | 0.97177 | 0.9753 | 53781.0 |
| 2013-08-16 | B | Futures | 107.29 | 108.55 | 107.05 | 108.26 | 195846.0 |
| 2013-08-16 | B6 | Futures | 1.6395 | 1.6414 | 1.636 | 1.6396 | 87155.0 |
| 2013-08-16 | BR | Futures | 0.20999 | 0.21016 | 0.20568 | 0.2069 | 632.0 |
| 2013-08-16 | BZ | Futures | 108.03 | 109.34 | 107.85 | 109.05 | 7199.0 |
| 2013-08-16 | C | Futures | 1746.0 | 1754.0 | 1739.0 | 1743.0 | 2561.0 |
| 2013-08-16 | CB | Futures | 68.17 | 68.17 | 67.619 | 68.17 | 26.0 |
| 2013-08-16 | CC | Futures | 1845.0 | 1871.0 | 1845.0 | 1859.0 | 10311.0 |
| 2013-08-16 | CSC | Futures | 3.408 | 3.427 | 3.408 | 3.427 | 4.0 |
| 2013-08-16 | CT | Futures | 109.56 | 111.83 | 109.56 | 111.23 | 36.0 |
| 2013-08-16 | DC | Futures | 26.14 | 26.37 | 25.92 | 26.24 | 264.0 |
| 2013-08-16 | DX | Futures | 77.579 | 77.832 | 77.474 | 77.691 | 25745.0 |
| 2013-08-16 | E1 | Futures | 1.38828 | 1.39496 | 1.38416 | 1.38815 | 32279.0 |
| 2013-08-16 | E6 | Futures | 1.57557 | 1.57923 | 1.57097 | 1.57392 | 182199.0 |
| 2013-08-16 | E7 | Futures | 1.5652 | 1.5689 | 1.5607 | 1.5636 | 3525.0 |
| 2013-08-16 | ED | Futures | 95.3012 | 95.306 | 95.3012 | 95.3012 | 66418.0 |
| 2013-08-16 | ER | Futures | 97.817 | 97.827 | 97.813 | 97.822 | 46955.0 |
| 2013-08-16 | EW | Futures | 1228.8 | 1234.7 | 1223.6 | 1225.0 | 17111.0 |
| 2013-08-16 | FBTP | Futures | 78.64 | 79.02 | 78.62 | 78.97 | 14247.0 |
| 2013-08-16 | FBTS | Futures | 93.358 | 93.453 | 93.358 | 93.427 | 1535.0 |
| 2013-08-16 | FCE | Futures | 3151.0 | 3180.6 | 3143.3 | 3179.1 | 88966.0 |
| 2013-08-16 | FDAX | Futures | 9271.8 | 9327.9 | 9246.3 | 9311.2 | 79467.0 |
| 2013-08-16 | FESX | Futures | 1985.0 | 2006.0 | 1982.2 | 2001.8 | 809006.0 |
| 2013-08-16 | FGBL | Futures | 117.29 | 117.54 | 116.99 | 117.41 | 456126.0 |
| 2013-08-16 | FGBM | Futures | 116.27 | 116.42 | 116.14 | 116.36 | 257445.0 |
| 2013-08-16 | FGBS | Futures | 110.138 | 110.193 | 110.128 | 110.173 | 196331.0 |
| 2013-08-16 | FGBX | Futures | 119.63 | 119.87 | 118.88 | 119.61 | 8965.0 |
| 2013-08-16 | FMWO | Futures | 4961.1 | 4961.1 | 4961.1 | 4961.1 | 0.0 |
| 2013-08-16 | FOAT | Futures | 105.39 | 105.74 | 105.33 | 105.61 | 25620.0 |
| 2013-08-16 | FTDX | Futures | 963.0 | 974.8 | 963.0 | 971.5 | 97.0 |
| 2013-08-16 | FTI | Futures | 326.81 | 327.55 | 325.11 | 327.07 | 27971.0 |
| 2013-08-16 | FTUK | Futures | 4841.7 | 4872.4 | 4828.5 | 4856.7 | 70129.0 |
| 2013-08-16 | FVSA | Futures | 2628.53 | 2675.12 | 2581.95 | 2588.61 | 5765.0 |
| 2013-08-16 | FXXP | Futures | 224.7 | 226.5 | 224.0 | 225.6 | 47858.0 |
| 2013-08-16 | G | Futures | 92.17 | 92.43 | 91.83 | 92.06 | 99641.0 |
| 2013-08-16 | GF | Futures | 258.48 | 260.001 | 257.329 | 259.261 | 2399.0 |
| 2013-08-16 | GSCI | Futures | 1069.49 | 1071.38 | 1063.81 | 1067.84 | 641.0 |
| 2013-08-16 | HE | Futures | 105.7 | 106.002 | 104.732 | 104.914 | 14722.0 |
| 2013-08-16 | HG | Futures | 4.2608 | 4.2887 | 4.2366 | 4.2671 | 53755.0 |
| 2013-08-16 | HH | Futures | 37.215 | 37.226 | 37.071 | 37.104 | 827.0 |
| 2013-08-16 | HO | Futures | 2.4651 | 2.4832 | 2.4603 | 2.476 | 39974.0 |
| 2013-08-16 | HRC | Futures | 2259.4 | 2259.4 | 2259.4 | 2259.4 | 0.0 |
| 2013-08-16 | J1 | Futures | 0.0129365 | 0.0129667 | 0.0128698 | 0.0128975 | 111264.0 |
> showing 50 of 102 rows — these rows as CSV