PREVIEW / futures_daily / 2013-09-24
file: by_date/futures_daily/2013/2013-09-24.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-09-24 | ES | Futures | 1739.35 | 1747.31 | 1733.44 | 1738.58 | 1501832.0 |
| 2013-09-24 | NQ | Futures | 3687.92 | 3710.6 | 3678.44 | 3690.5 | 178347.0 |
| 2013-09-24 | YM | Futures | 15255.3 | 15293.1 | 15184.6 | 15209.5 | 128966.0 |
| 2013-09-24 | CL | Futures | 183.13 | 183.48 | 181.11 | 182.58 | 259543.0 |
| 2013-09-24 | GC | Futures | 1747.7 | 1758.2 | 1726.6 | 1740.9 | 155023.0 |
| 2013-09-24 | ZN | Futures | 113.776424 | 114.243766 | 113.748101 | 114.144633 | 889838.0 |
| 2013-09-24 | A6 | Futures | 0.88556 | 0.88566 | 0.87971 | 0.88245 | 66601.0 |
| 2013-09-24 | AD | Futures | 0.98087 | 0.98248 | 0.97794 | 0.97915 | 37215.0 |
| 2013-09-24 | B | Futures | 106.86 | 107.79 | 106.34 | 107.54 | 197986.0 |
| 2013-09-24 | B6 | Futures | 1.6829 | 1.6832 | 1.6735 | 1.6792 | 82201.0 |
| 2013-09-24 | BFX | Futures | 3406.5 | 3406.5 | 3390.8 | 3390.8 | 25.0 |
| 2013-09-24 | BR | Futures | 0.2271 | 0.22881 | 0.2271 | 0.22812 | 27.0 |
| 2013-09-24 | BZ | Futures | 108.02 | 108.6 | 107.17 | 108.35 | 6581.0 |
| 2013-09-24 | C | Futures | 1811.0 | 1824.0 | 1808.0 | 1816.0 | 4862.0 |
| 2013-09-24 | CB | Futures | 75.533 | 75.773 | 75.294 | 75.294 | 23.0 |
| 2013-09-24 | CC | Futures | 1938.0 | 1945.0 | 1927.0 | 1940.0 | 9670.0 |
| 2013-09-24 | CSC | Futures | 3.242 | 3.271 | 3.242 | 3.271 | 10.0 |
| 2013-09-24 | CT | Futures | 98.86 | 99.6 | 98.8 | 98.99 | 5708.0 |
| 2013-09-24 | DC | Futures | 24.7 | 25.02 | 24.7 | 24.96 | 95.0 |
| 2013-09-24 | DX | Futures | 76.767 | 76.934 | 76.719 | 76.881 | 15622.0 |
| 2013-09-24 | E1 | Futures | 1.41154 | 1.41321 | 1.40807 | 1.40935 | 19026.0 |
| 2013-09-24 | E6 | Futures | 1.59268 | 1.59575 | 1.58926 | 1.59067 | 137957.0 |
| 2013-09-24 | E7 | Futures | 1.5822 | 1.5855 | 1.5791 | 1.5804 | 1972.0 |
| 2013-09-24 | ED | Futures | 95.3399 | 95.3399 | 95.3303 | 95.3351 | 98319.0 |
| 2013-09-24 | ER | Futures | 97.847 | 97.857 | 97.842 | 97.847 | 61605.0 |
| 2013-09-24 | EW | Futures | 1260.7 | 1270.5 | 1256.2 | 1263.4 | 17258.0 |
| 2013-09-24 | FBTP | Futures | 78.87 | 79.21 | 78.79 | 79.0 | 31162.0 |
| 2013-09-24 | FBTS | Futures | 93.912 | 94.024 | 93.895 | 93.964 | 5599.0 |
| 2013-09-24 | FCE | Futures | 3227.0 | 3248.2 | 3223.1 | 3240.1 | 82163.0 |
| 2013-09-24 | FDAX | Futures | 9600.9 | 9645.3 | 9583.1 | 9618.1 | 73636.0 |
| 2013-09-24 | FESX | Futures | 2033.4 | 2048.1 | 2030.5 | 2042.5 | 698452.0 |
| 2013-09-24 | FGBL | Futures | 118.18 | 119.0 | 118.1 | 118.82 | 766607.0 |
| 2013-09-24 | FGBM | Futures | 117.13 | 117.44 | 117.1 | 117.37 | 462366.0 |
| 2013-09-24 | FGBS | Futures | 110.378 | 110.413 | 110.368 | 110.403 | 301204.0 |
| 2013-09-24 | FGBX | Futures | 118.76 | 120.08 | 118.72 | 119.81 | 19718.0 |
| 2013-09-24 | FMWO | Futures | 5121.9 | 5121.9 | 5121.9 | 5121.9 | 199.0 |
| 2013-09-24 | FOAT | Futures | 105.94 | 106.53 | 105.88 | 106.43 | 29119.0 |
| 2013-09-24 | FTDX | Futures | 1008.2 | 1017.2 | 1007.3 | 1009.2 | 97.0 |
| 2013-09-24 | FTI | Futures | 328.9 | 330.5 | 328.29 | 329.72 | 17222.0 |
| 2013-09-24 | FTUK | Futures | 4891.9 | 4918.5 | 4886.7 | 4907.3 | 69016.0 |
| 2013-09-24 | FVSA | Futures | 2425.72 | 2425.72 | 2360.51 | 2360.51 | 4302.0 |
| 2013-09-24 | FXXP | Futures | 228.4 | 228.4 | 227.4 | 228.0 | 10529.0 |
| 2013-09-24 | G | Futures | 91.05 | 91.93 | 90.93 | 91.77 | 231060.0 |
| 2013-09-24 | GF | Futures | 264.259 | 267.357 | 264.218 | 266.99 | 3003.0 |
| 2013-09-24 | GSCI | Futures | 1059.04 | 1062.22 | 1052.84 | 1059.45 | 137.0 |
| 2013-09-24 | HE | Futures | 109.547 | 112.522 | 109.484 | 111.478 | 32744.0 |
| 2013-09-24 | HG | Futures | 4.1728 | 4.1753 | 4.0968 | 4.1234 | 40145.0 |
| 2013-09-24 | HH | Futures | 38.89 | 38.89 | 37.993 | 37.993 | 405.0 |
| 2013-09-24 | HO | Futures | 2.3608 | 2.3719 | 2.3428 | 2.3675 | 26676.0 |
| 2013-09-24 | HRC | Futures | 2270.3 | 2270.3 | 2270.3 | 2270.3 | 0.0 |
> showing 50 of 102 rows — these rows as CSV