PREVIEW / futures_daily / 2012-10-18
file: by_date/futures_daily/2012/2012-10-18.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 |
|---|---|---|---|---|---|---|---|
| 2012-10-18 | ES | Futures | 1482.91 | 1485.71 | 1473.5 | 1477.31 | 1805949.0 |
| 2012-10-18 | NQ | Futures | 3188.34 | 3191.8 | 3138.29 | 3144.33 | 332954.0 |
| 2012-10-18 | YM | Futures | 13168.0 | 13211.9 | 13134.8 | 13169.9 | 119365.0 |
| 2012-10-18 | CL | Futures | 166.67 | 167.59 | 164.22 | 166.76 | 175857.0 |
| 2012-10-18 | GC | Futures | 2337.7 | 2341.0 | 2321.8 | 2329.4 | 106130.0 |
| 2012-10-18 | ZN | Futures | 116.038453 | 116.285664 | 115.942315 | 116.010985 | 1138606.0 |
| 2012-10-18 | A6 | Futures | 0.93816 | 0.94171 | 0.93662 | 0.93762 | 131247.0 |
| 2012-10-18 | AD | Futures | 1.02516 | 1.02687 | 1.01653 | 1.01724 | 88079.0 |
| 2012-10-18 | B | Futures | 103.67 | 104.13 | 102.24 | 103.02 | 212561.0 |
| 2012-10-18 | B6 | Futures | 1.6856 | 1.6885 | 1.6747 | 1.6772 | 111638.0 |
| 2012-10-18 | BFX | Futures | 2883.0 | 2887.2 | 2880.3 | 2887.2 | 237.0 |
| 2012-10-18 | BR | Futures | 0.23774 | 0.23806 | 0.2375 | 0.23787 | 163.0 |
| 2012-10-18 | BZ | Futures | 107.41 | 107.94 | 106.15 | 106.91 | 602.0 |
| 2012-10-18 | C | Futures | 1547.0 | 1598.0 | 1541.0 | 1596.0 | 7803.0 |
| 2012-10-18 | CB | Futures | 93.318 | 93.331 | 92.97 | 92.97 | 17.0 |
| 2012-10-18 | CC | Futures | 1799.0 | 1846.0 | 1793.0 | 1839.0 | 12334.0 |
| 2012-10-18 | CSC | Futures | 4.252 | 4.252 | 4.204 | 4.25 | 11.0 |
| 2012-10-18 | CT | Futures | 100.78 | 102.19 | 96.6 | 100.29 | 49312.0 |
| 2012-10-18 | DC | Futures | 30.73 | 31.6 | 30.6 | 31.47 | 418.0 |
| 2012-10-18 | DX | Futures | 76.637 | 76.971 | 76.554 | 76.932 | 17855.0 |
| 2012-10-18 | E1 | Futures | 1.39655 | 1.39784 | 1.39166 | 1.3923 | 28027.0 |
| 2012-10-18 | E6 | Futures | 1.5451 | 1.54687 | 1.53816 | 1.5391 | 237217.0 |
| 2012-10-18 | E7 | Futures | 1.5363 | 1.5375 | 1.529 | 1.5299 | 3648.0 |
| 2012-10-18 | ED | Futures | 95.254 | 95.2587 | 95.2444 | 95.254 | 165394.0 |
| 2012-10-18 | ER | Futures | 97.857 | 97.866 | 97.852 | 97.862 | 78849.0 |
| 2012-10-18 | EW | Futures | 1020.6 | 1021.8 | 1013.9 | 1017.3 | 21631.0 |
| 2012-10-18 | FBTP | Futures | 73.23 | 73.36 | 72.91 | 73.2 | 19394.0 |
| 2012-10-18 | FBTS | Futures | 89.96 | 89.994 | 89.692 | 89.868 | 5646.0 |
| 2012-10-18 | FCE | Futures | 2653.8 | 2661.4 | 2635.1 | 2655.3 | 110833.0 |
| 2012-10-18 | FDAX | Futures | 8115.8 | 8161.3 | 8097.2 | 8152.0 | 119676.0 |
| 2012-10-18 | FESX | Futures | 1749.8 | 1754.6 | 1736.9 | 1750.5 | 984564.0 |
| 2012-10-18 | FEU3 | Futures | 98.478 | 98.487 | 98.478 | 98.487 | 191.0 |
| 2012-10-18 | FGBL | Futures | 116.58 | 117.11 | 116.55 | 116.86 | 805434.0 |
| 2012-10-18 | FGBM | Futures | 115.48 | 115.73 | 115.43 | 115.6 | 457920.0 |
| 2012-10-18 | FGBS | Futures | 110.198 | 110.243 | 110.193 | 110.203 | 363073.0 |
| 2012-10-18 | FGBX | Futures | 121.57 | 122.78 | 121.39 | 122.27 | 5578.0 |
| 2012-10-18 | FOAT | Futures | 103.4 | 103.67 | 103.19 | 103.54 | 37288.0 |
| 2012-10-18 | FTDX | Futures | 778.7 | 778.7 | 774.9 | 777.3 | 29.0 |
| 2012-10-18 | FTI | Futures | 288.01 | 288.01 | 285.01 | 286.64 | 25962.0 |
| 2012-10-18 | FTUK | Futures | 4310.1 | 4319.6 | 4292.5 | 4313.8 | 76823.0 |
| 2012-10-18 | FVSA | Futures | 5093.59 | 5104.88 | 4969.35 | 4991.94 | 5967.0 |
| 2012-10-18 | FXXP | Futures | 198.4 | 199.2 | 198.0 | 198.9 | 1192.0 |
| 2012-10-18 | G | Futures | 97.85 | 98.11 | 97.6 | 97.89 | 193134.0 |
| 2012-10-18 | GF | Futures | 286.308 | 287.508 | 285.78 | 286.356 | 2354.0 |
| 2012-10-18 | GSCI | Futures | 1074.85 | 1078.24 | 1065.39 | 1075.33 | 254.0 |
| 2012-10-18 | HE | Futures | 98.476 | 98.693 | 97.637 | 98.009 | 19878.0 |
| 2012-10-18 | HG | Futures | 4.8107 | 4.8384 | 4.7818 | 4.8101 | 44083.0 |
| 2012-10-18 | HH | Futures | 45.739 | 45.739 | 45.739 | 45.739 | 840.0 |
| 2012-10-18 | HO | Futures | 2.5754 | 2.5841 | 2.5462 | 2.5669 | 51769.0 |
| 2012-10-18 | HRC | Futures | 2418.5 | 2418.5 | 2418.5 | 2418.5 | 0.0 |
> showing 50 of 100 rows — these rows as CSV