PREVIEW / futures_daily / 2015-07-23
file: by_date/futures_daily/2015/2015-07-23.parquet size: 9 KB rows: 107
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 |
|---|---|---|---|---|---|---|---|
| 2015-07-23 | ES | Futures | 2235.42 | 2240.19 | 2216.61 | 2224.03 | 1437249.0 |
| 2015-07-23 | NQ | Futures | 5395.98 | 5411.16 | 5352.2 | 5393.94 | 211215.0 |
| 2015-07-23 | YM | Futures | 18281.0 | 18314.9 | 18103.3 | 18153.6 | 127882.0 |
| 2015-07-23 | CL | Futures | 81.74 | 82.4 | 80.05 | 80.44 | 316060.0 |
| 2015-07-23 | GC | Futures | 1428.0 | 1443.0 | 1418.4 | 1428.9 | 204073.0 |
| 2015-07-23 | ZN | Futures | 120.45182 | 120.839317 | 120.302783 | 120.764798 | 955338.0 |
| 2015-07-23 | A6 | Futures | 0.72881 | 0.73257 | 0.72613 | 0.72722 | 68558.0 |
| 2015-07-23 | AD | Futures | 0.78426 | 0.78988 | 0.78334 | 0.78395 | 59566.0 |
| 2015-07-23 | ALI | Futures | 2193.72 | 2193.72 | 2193.72 | 2193.72 | 10.0 |
| 2015-07-23 | B | Futures | 52.15 | 52.6 | 51.27 | 51.43 | 207129.0 |
| 2015-07-23 | B6 | Futures | 1.6423 | 1.6488 | 1.6305 | 1.6321 | 91362.0 |
| 2015-07-23 | BFX | Futures | 4587.8 | 4596.3 | 4587.8 | 4596.3 | 1.0 |
| 2015-07-23 | BR | Futures | 0.18159 | 0.18159 | 0.17913 | 0.17979 | 2053.0 |
| 2015-07-23 | BZ | Futures | 52.03 | 52.56 | 51.23 | 51.4 | 28668.0 |
| 2015-07-23 | C | Futures | 2334.0 | 2340.0 | 2316.0 | 2320.0 | 8245.0 |
| 2015-07-23 | CB | Futures | 160.494 | 162.135 | 160.494 | 160.514 | 17.0 |
| 2015-07-23 | CC | Futures | 2401.0 | 2407.0 | 2383.0 | 2383.0 | 14039.0 |
| 2015-07-23 | CNH | Futures | 7.0032 | 7.0099 | 7.002 | 7.002 | 41.0 |
| 2015-07-23 | CSC | Futures | 4.343 | 4.472 | 4.343 | 4.412 | 46.0 |
| 2015-07-23 | CT | Futures | 80.28 | 81.07 | 80.03 | 80.67 | 17.0 |
| 2015-07-23 | DC | Futures | 34.98 | 36.07 | 34.93 | 35.56 | 556.0 |
| 2015-07-23 | DX | Futures | 91.362 | 91.395 | 90.754 | 91.012 | 41746.0 |
| 2015-07-23 | E1 | Futures | 1.32465 | 1.33532 | 1.3244 | 1.32808 | 18154.0 |
| 2015-07-23 | E6 | Futures | 1.28451 | 1.29532 | 1.28392 | 1.29297 | 240637.0 |
| 2015-07-23 | E7 | Futures | 1.2775 | 1.2882 | 1.2768 | 1.2858 | 4847.0 |
| 2015-07-23 | EBM | Futures | 306.6 | 308.65 | 305.37 | 305.78 | 10080.0 |
| 2015-07-23 | ED | Futures | 95.6222 | 95.6318 | 95.6175 | 95.6318 | 116811.0 |
| 2015-07-23 | ER | Futures | 98.107 | 98.112 | 98.102 | 98.107 | 23722.0 |
| 2015-07-23 | EW | Futures | 1571.9 | 1574.8 | 1555.9 | 1558.3 | 13046.0 |
| 2015-07-23 | FBTP | Futures | 99.99 | 100.52 | 99.99 | 100.34 | 46296.0 |
| 2015-07-23 | FBTS | Futures | 99.999 | 100.008 | 99.973 | 99.99 | 12313.0 |
| 2015-07-23 | FCE | Futures | 4257.1 | 4272.9 | 4215.8 | 4242.9 | 70441.0 |
| 2015-07-23 | FDAX | Futures | 12811.7 | 12857.1 | 12643.2 | 12717.8 | 83035.0 |
| 2015-07-23 | FESX | Futures | 2703.5 | 2713.1 | 2668.7 | 2687.2 | 650398.0 |
| 2015-07-23 | FEU3 | Futures | 98.749 | 98.754 | 98.749 | 98.749 | 24.0 |
| 2015-07-23 | FGBL | Futures | 136.63 | 136.92 | 136.52 | 136.62 | 384258.0 |
| 2015-07-23 | FGBM | Futures | 124.37 | 124.47 | 124.36 | 124.41 | 278114.0 |
| 2015-07-23 | FGBS | Futures | 111.203 | 111.213 | 111.198 | 111.208 | 71447.0 |
| 2015-07-23 | FGBX | Futures | 154.34 | 155.4 | 153.84 | 154.06 | 19720.0 |
| 2015-07-23 | FMWO | Futures | 5865.5 | 5866.7 | 5843.3 | 5843.3 | 551.0 |
| 2015-07-23 | FOAT | Futures | 124.98 | 125.31 | 124.94 | 125.1 | 37084.0 |
| 2015-07-23 | FTDX | Futures | 1718.2 | 1722.4 | 1703.6 | 1710.2 | 209.0 |
| 2015-07-23 | FTI | Futures | 428.32 | 430.57 | 423.62 | 426.34 | 23619.0 |
| 2015-07-23 | FTUK | Futures | 5292.1 | 5297.6 | 5224.1 | 5243.6 | 69226.0 |
| 2015-07-23 | FVSA | Futures | 1715.06 | 1732.61 | 1684.36 | 1688.74 | 11809.0 |
| 2015-07-23 | FXXP | Futures | 308.3 | 308.7 | 303.1 | 305.0 | 8416.0 |
| 2015-07-23 | G | Futures | 101.45 | 101.78 | 101.37 | 101.53 | 125939.0 |
| 2015-07-23 | GF | Futures | 360.696 | 362.524 | 356.318 | 356.658 | 5511.0 |
| 2015-07-23 | GSCI | Futures | 658.99 | 660.24 | 649.83 | 650.41 | 65.0 |
| 2015-07-23 | HE | Futures | 87.128 | 88.05 | 86.849 | 87.436 | 9885.0 |
> showing 50 of 107 rows — these rows as CSV