PREVIEW / futures_daily / 2013-01-10
file: by_date/futures_daily/2013/2013-01-10.parquet size: 9 KB rows: 101
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-01-10 | ES | Futures | 1490.28 | 1504.35 | 1488.49 | 1501.03 | 1540850.0 |
| 2013-01-10 | NQ | Futures | 3140.24 | 3164.46 | 3130.15 | 3156.96 | 244792.0 |
| 2013-01-10 | YM | Futures | 13069.4 | 13169.4 | 13057.6 | 13145.9 | 112191.0 |
| 2013-01-10 | CL | Futures | 165.4 | 168.08 | 165.2 | 166.52 | 279295.0 |
| 2013-01-10 | GC | Futures | 2209.5 | 2237.2 | 2203.9 | 2236.1 | 159320.0 |
| 2013-01-10 | ZN | Futures | 116.431823 | 116.431823 | 116.087269 | 116.183744 | 1291330.0 |
| 2013-01-10 | A6 | Futures | 0.95692 | 0.96515 | 0.95563 | 0.96488 | 122780.0 |
| 2013-01-10 | AD | Futures | 1.01372 | 1.01984 | 1.01332 | 1.01743 | 66602.0 |
| 2013-01-10 | B | Futures | 104.01 | 105.37 | 103.85 | 104.23 | 240612.0 |
| 2013-01-10 | B6 | Futures | 1.6734 | 1.6891 | 1.672 | 1.6876 | 130556.0 |
| 2013-01-10 | BFX | Futures | 3027.6 | 3027.6 | 3014.7 | 3014.7 | 7.0 |
| 2013-01-10 | BR | Futures | 0.23897 | 0.2401 | 0.23897 | 0.23995 | 64.0 |
| 2013-01-10 | BZ | Futures | 106.74 | 107.65 | 106.36 | 106.55 | 1860.0 |
| 2013-01-10 | C | Futures | 1538.0 | 1548.0 | 1531.0 | 1546.0 | 3514.0 |
| 2013-01-10 | CB | Futures | 82.869 | 84.185 | 82.869 | 82.934 | 12.0 |
| 2013-01-10 | CC | Futures | 1677.0 | 1716.0 | 1677.0 | 1712.0 | 11923.0 |
| 2013-01-10 | CSC | Futures | 3.835 | 3.835 | 3.817 | 3.817 | 29.0 |
| 2013-01-10 | CT | Futures | 94.25 | 94.8 | 93.82 | 94.64 | 10131.0 |
| 2013-01-10 | DC | Futures | 28.42 | 28.42 | 28.2 | 28.31 | 150.0 |
| 2013-01-10 | DX | Futures | 77.878 | 77.917 | 76.909 | 76.978 | 38464.0 |
| 2013-01-10 | E1 | Futures | 1.39179 | 1.41084 | 1.39011 | 1.40878 | 39166.0 |
| 2013-01-10 | E6 | Futures | 1.54101 | 1.56625 | 1.53865 | 1.56377 | 344492.0 |
| 2013-01-10 | E7 | Futures | 1.5306 | 1.5556 | 1.5281 | 1.5531 | 6719.0 |
| 2013-01-10 | EBM | Futures | 274.51 | 276.45 | 272.84 | 273.67 | 12766.0 |
| 2013-01-10 | ED | Futures | 95.239 | 95.2438 | 95.2342 | 95.239 | 109009.0 |
| 2013-01-10 | ER | Futures | 97.817 | 97.842 | 97.793 | 97.798 | 254317.0 |
| 2013-01-10 | EW | Futures | 1076.1 | 1082.5 | 1071.1 | 1077.0 | 15812.0 |
| 2013-01-10 | FBTP | Futures | 76.76 | 77.57 | 76.54 | 77.3 | 29092.0 |
| 2013-01-10 | FBTS | Futures | 91.569 | 92.103 | 91.518 | 91.899 | 11592.0 |
| 2013-01-10 | FCE | Futures | 2803.1 | 2806.8 | 2780.5 | 2788.0 | 106913.0 |
| 2013-01-10 | FDAX | Futures | 8457.8 | 8496.0 | 8396.1 | 8417.9 | 111622.0 |
| 2013-01-10 | FESX | Futures | 1844.5 | 1853.4 | 1830.9 | 1840.4 | 894172.0 |
| 2013-01-10 | FEU3 | Futures | 98.418 | 98.418 | 98.404 | 98.404 | 275.0 |
| 2013-01-10 | FGBL | Futures | 118.63 | 118.74 | 117.73 | 117.95 | 947158.0 |
| 2013-01-10 | FGBM | Futures | 116.77 | 116.84 | 116.29 | 116.39 | 602017.0 |
| 2013-01-10 | FGBS | Futures | 110.362 | 110.387 | 110.263 | 110.283 | 556490.0 |
| 2013-01-10 | FGBX | Futures | 124.73 | 124.76 | 122.52 | 123.01 | 8629.0 |
| 2013-01-10 | FOAT | Futures | 105.33 | 105.43 | 104.91 | 105.05 | 30243.0 |
| 2013-01-10 | FTDX | Futures | 829.8 | 836.0 | 826.0 | 827.5 | 226.0 |
| 2013-01-10 | FTI | Futures | 300.76 | 302.22 | 300.24 | 301.06 | 11253.0 |
| 2013-01-10 | FTUK | Futures | 4450.5 | 4469.3 | 4446.1 | 4453.4 | 72170.0 |
| 2013-01-10 | FVSA | Futures | 3411.25 | 3431.55 | 3309.72 | 3411.25 | 6274.0 |
| 2013-01-10 | FXXP | Futures | 207.2 | 207.5 | 206.2 | 206.5 | 4078.0 |
| 2013-01-10 | G | Futures | 97.17 | 97.3 | 96.39 | 96.54 | 196343.0 |
| 2013-01-10 | GF | Futures | 287.477 | 287.571 | 285.376 | 285.703 | 2730.0 |
| 2013-01-10 | GSCI | Futures | 1047.18 | 1056.1 | 1047.18 | 1049.27 | 1901.0 |
| 2013-01-10 | HE | Futures | 97.175 | 97.576 | 96.744 | 97.089 | 25376.0 |
| 2013-01-10 | HG | Futures | 4.7141 | 4.7745 | 4.7077 | 4.7629 | 42883.0 |
| 2013-01-10 | HH | Futures | 36.888 | 37.651 | 36.77 | 37.487 | 484.0 |
| 2013-01-10 | HO | Futures | 2.4684 | 2.4958 | 2.4526 | 2.457 | 91198.0 |
> showing 50 of 101 rows — these rows as CSV