PREVIEW / futures_daily / 2013-10-07
file: by_date/futures_daily/2013/2013-10-07.parquet size: 9 KB rows: 100
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-10-07 | ES | Futures | 1722.4 | 1725.23 | 1711.87 | 1713.16 | 1599803.0 |
| 2013-10-07 | NQ | Futures | 3702.85 | 3712.9 | 3677.3 | 3681.03 | 239190.0 |
| 2013-10-07 | YM | Futures | 14865.2 | 14876.2 | 14766.7 | 14776.7 | 142566.0 |
| 2013-10-07 | CL | Futures | 183.15 | 183.66 | 180.33 | 182.4 | 269025.0 |
| 2013-10-07 | GC | Futures | 1735.6 | 1758.3 | 1729.8 | 1752.5 | 95950.0 |
| 2013-10-07 | ZN | Futures | 114.456194 | 114.711108 | 114.442032 | 114.470356 | 615195.0 |
| 2013-10-07 | A6 | Futures | 0.8866 | 0.8884 | 0.88263 | 0.88745 | 52548.0 |
| 2013-10-07 | AD | Futures | 0.97935 | 0.97965 | 0.97602 | 0.97844 | 37625.0 |
| 2013-10-07 | B | Futures | 108.05 | 108.94 | 106.74 | 108.49 | 208652.0 |
| 2013-10-07 | B6 | Futures | 1.6813 | 1.6892 | 1.6812 | 1.6883 | 77834.0 |
| 2013-10-07 | BR | Futures | 0.22665 | 0.2281 | 0.22665 | 0.22782 | 32.0 |
| 2013-10-07 | BZ | Futures | 108.52 | 109.57 | 107.41 | 109.15 | 10854.0 |
| 2013-10-07 | C | Futures | 1815.0 | 1870.0 | 1814.0 | 1867.0 | 13751.0 |
| 2013-10-07 | CC | Futures | 1953.0 | 2020.0 | 1951.0 | 2011.0 | 29919.0 |
| 2013-10-07 | CSC | Futures | 3.271 | 3.277 | 3.247 | 3.253 | 54.0 |
| 2013-10-07 | CT | Futures | 102.2 | 102.2 | 98.07 | 98.57 | 29010.0 |
| 2013-10-07 | DC | Futures | 25.19 | 25.19 | 24.87 | 24.93 | 169.0 |
| 2013-10-07 | DX | Futures | 76.414 | 76.448 | 76.195 | 76.248 | 13137.0 |
| 2013-10-07 | E1 | Futures | 1.41796 | 1.42619 | 1.41783 | 1.42272 | 22287.0 |
| 2013-10-07 | E6 | Futures | 1.60059 | 1.60424 | 1.59846 | 1.60259 | 110524.0 |
| 2013-10-07 | E7 | Futures | 1.5904 | 1.5939 | 1.5882 | 1.5923 | 3280.0 |
| 2013-10-07 | ED | Futures | 95.3303 | 95.3303 | 95.316 | 95.3208 | 149877.0 |
| 2013-10-07 | ER | Futures | 97.842 | 97.862 | 97.842 | 97.847 | 22531.0 |
| 2013-10-07 | EW | Futures | 1272.0 | 1272.7 | 1261.8 | 1262.7 | 17039.0 |
| 2013-10-07 | FBTP | Futures | 79.6 | 79.88 | 79.6 | 79.76 | 23762.0 |
| 2013-10-07 | FBTS | Futures | 94.128 | 94.215 | 94.128 | 94.189 | 5247.0 |
| 2013-10-07 | FCE | Futures | 3198.8 | 3218.5 | 3168.3 | 3214.6 | 112461.0 |
| 2013-10-07 | FDAX | Futures | 9542.1 | 9553.2 | 9443.9 | 9533.2 | 92482.0 |
| 2013-10-07 | FESX | Futures | 2036.2 | 2045.3 | 2020.0 | 2040.4 | 769601.0 |
| 2013-10-07 | FEU3 | Futures | 98.468 | 98.468 | 98.468 | 98.468 | 9.0 |
| 2013-10-07 | FGBL | Futures | 119.29 | 119.59 | 119.25 | 119.48 | 400397.0 |
| 2013-10-07 | FGBM | Futures | 117.51 | 117.7 | 117.5 | 117.63 | 341413.0 |
| 2013-10-07 | FGBS | Futures | 110.438 | 110.473 | 110.433 | 110.443 | 222198.0 |
| 2013-10-07 | FGBX | Futures | 119.94 | 120.31 | 119.77 | 120.14 | 7736.0 |
| 2013-10-07 | FMWO | Futures | 5056.1 | 5056.1 | 5056.1 | 5056.1 | 0.0 |
| 2013-10-07 | FOAT | Futures | 106.76 | 106.96 | 106.73 | 106.9 | 25242.0 |
| 2013-10-07 | FTDX | Futures | 1027.1 | 1027.1 | 1018.1 | 1023.8 | 46.0 |
| 2013-10-07 | FTI | Futures | 324.39 | 324.52 | 320.93 | 323.74 | 27221.0 |
| 2013-10-07 | FTUK | Futures | 4819.2 | 4819.5 | 4771.2 | 4802.7 | 72286.0 |
| 2013-10-07 | FVSA | Futures | 2673.51 | 2738.72 | 2660.47 | 2666.99 | 5699.0 |
| 2013-10-07 | FXXP | Futures | 224.8 | 225.4 | 223.4 | 224.9 | 2751.0 |
| 2013-10-07 | G | Futures | 92.57 | 92.8 | 92.56 | 92.71 | 82074.0 |
| 2013-10-07 | GF | Futures | 267.52 | 268.335 | 266.419 | 267.357 | 817.0 |
| 2013-10-07 | GSCI | Futures | 1055.27 | 1072.02 | 1055.27 | 1067.83 | 1514.0 |
| 2013-10-07 | HE | Futures | 110.971 | 111.699 | 110.528 | 111.225 | 16269.0 |
| 2013-10-07 | HG | Futures | 4.1766 | 4.1949 | 4.1329 | 4.174 | 36985.0 |
| 2013-10-07 | HH | Futures | 38.549 | 39.029 | 38.378 | 38.741 | 1631.0 |
| 2013-10-07 | HO | Futures | 2.3969 | 2.42 | 2.3708 | 2.407 | 28255.0 |
| 2013-10-07 | HRC | Futures | 2342.6 | 2342.6 | 2342.6 | 2342.6 | 0.0 |
| 2013-10-07 | J1 | Futures | 0.0129327 | 0.013022 | 0.0129327 | 0.0129918 | 104030.0 |
> showing 50 of 100 rows — these rows as CSV