PREVIEW / futures_daily / 2008-12-31
file: by_date/futures_daily/2008/2008-12-31.parquet size: 8 KB rows: 77
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 |
|---|---|---|---|---|---|---|---|
| 2008-12-31 | ES | Futures | 838.53 | 857.41 | 837.11 | 849.86 | 920263.0 |
| 2008-12-31 | NQ | Futures | 1348.57 | 1369.25 | 1342.7 | 1355.56 | 125382.0 |
| 2008-12-31 | YM | Futures | 7693.0 | 7832.8 | 7677.8 | 7770.4 | 66711.0 |
| 2008-12-31 | CL | Futures | 155.51 | 180.8 | 146.66 | 177.07 | 188601.0 |
| 2008-12-31 | GC | Futures | 1219.5 | 1235.3 | 1195.3 | 1232.9 | 54996.0 |
| 2008-12-31 | ZN | Futures | 97.666674 | 97.714485 | 96.017182 | 96.196474 | 115346.0 |
| 2008-12-31 | A6 | Futures | 0.54462 | 0.5604 | 0.53947 | 0.55493 | 8624.0 |
| 2008-12-31 | AD | Futures | 0.80763 | 0.81136 | 0.79426 | 0.80792 | 12761.0 |
| 2008-12-31 | B | Futures | 44.17 | 51.14 | 42.17 | 50.37 | 50086.0 |
| 2008-12-31 | B6 | Futures | 1.4965 | 1.5264 | 1.4888 | 1.5125 | 23743.0 |
| 2008-12-31 | BFX | Futures | 2136.6 | 2136.6 | 2097.4 | 2099.6 | 496.0 |
| 2008-12-31 | BZ | Futures | 49.42 | 50.58 | 49.33 | 50.58 | 10.0 |
| 2008-12-31 | C | Futures | 1783.0 | 1811.0 | 1764.0 | 1773.0 | 1989.0 |
| 2008-12-31 | CB | Futures | 78.159 | 78.325 | 77.333 | 77.664 | 44.0 |
| 2008-12-31 | CC | Futures | 2248.0 | 2372.0 | 2241.0 | 2351.0 | 3573.0 |
| 2008-12-31 | CT | Futures | 46.95 | 47.99 | 46.54 | 47.72 | 6239.0 |
| 2008-12-31 | DC | Futures | 30.54 | 30.54 | 28.74 | 28.9 | 173.0 |
| 2008-12-31 | DX | Futures | 84.541 | 85.728 | 84.401 | 85.184 | 2296.0 |
| 2008-12-31 | E1 | Futures | 1.25924 | 1.26243 | 1.23851 | 1.24462 | 10662.0 |
| 2008-12-31 | E6 | Futures | 1.66611 | 1.6712 | 1.6358 | 1.64811 | 69253.0 |
| 2008-12-31 | E7 | Futures | 1.6467 | 1.6518 | 1.6168 | 1.6292 | 1330.0 |
| 2008-12-31 | EBM | Futures | 210.53 | 211.68 | 209.38 | 210.15 | 585.0 |
| 2008-12-31 | ED | Futures | 93.2179 | 93.2367 | 93.1614 | 93.1896 | 61554.0 |
| 2008-12-31 | ER | Futures | 95.841 | 95.895 | 95.841 | 95.88 | 19181.0 |
| 2008-12-31 | EW | Futures | 512.7 | 528.7 | 510.2 | 525.0 | 28129.0 |
| 2008-12-31 | FCE | Futures | 2006.7 | 2015.1 | 1981.5 | 1984.6 | 20564.0 |
| 2008-12-31 | FTI | Futures | 198.54 | 199.38 | 196.86 | 197.1 | 4010.0 |
| 2008-12-31 | FTUK | Futures | 2902.6 | 2902.6 | 2873.1 | 2878.4 | 24208.0 |
| 2008-12-31 | G | Futures | 77.02 | 77.28 | 76.87 | 77.25 | 8960.0 |
| 2008-12-31 | GF | Futures | 259.859 | 260.688 | 257.786 | 259.997 | 126.0 |
| 2008-12-31 | GSCI | Futures | 768.2 | 836.12 | 768.2 | 821.84 | 50.0 |
| 2008-12-31 | HE | Futures | 115.019 | 117.677 | 113.859 | 117.677 | 5721.0 |
| 2008-12-31 | HG | Futures | 1.8649 | 1.9909 | 1.8494 | 1.9845 | 9031.0 |
| 2008-12-31 | HO | Futures | 1.4889 | 1.6439 | 1.459 | 1.6345 | 8929.0 |
| 2008-12-31 | HRC | Futures | 3101.0 | 3101.0 | 3101.0 | 3101.0 | 0.0 |
| 2008-12-31 | J1 | Futures | 0.0140258 | 0.0140346 | 0.0139096 | 0.013931 | 20361.0 |
| 2008-12-31 | J7 | Futures | 0.013815 | 0.013851 | 0.013747 | 0.013764 | 21.0 |
| 2008-12-31 | KC | Futures | 307.95 | 322.96 | 306.52 | 320.24 | 7875.0 |
| 2008-12-31 | KE | Futures | 3097.83 | 3152.79 | 3047.87 | 3147.8 | 5609.0 |
| 2008-12-31 | L | Futures | 96.704 | 96.704 | 96.65 | 96.694 | 11624.0 |
| 2008-12-31 | LBS | Futures | 1069.7 | 1075.9 | 1048.9 | 1053.4 | 28.0 |
| 2008-12-31 | LE | Futures | 153.944 | 154.57 | 151.887 | 153.944 | 4437.0 |
| 2008-12-31 | MP | Futures | 0.03539 | 0.03587 | 0.03508 | 0.03517 | 2977.0 |
| 2008-12-31 | N6 | Futures | 0.45173 | 0.46222 | 0.44811 | 0.4593 | 365.0 |
| 2008-12-31 | NG | Futures | 370.971 | 371.161 | 347.199 | 356.391 | 28381.0 |
| 2008-12-31 | NIY | Futures | 7149.1 | 7316.8 | 7149.1 | 7244.9 | 3874.0 |
| 2008-12-31 | NKD | Futures | 8705.1 | 8922.2 | 8661.7 | 8816.1 | 2919.0 |
| 2008-12-31 | NOK | Futures | 0.142624 | 0.142624 | 0.142624 | 0.142624 | 0.0 |
| 2008-12-31 | OJ | Futures | 53.5 | 54.03 | 50.92 | 51.53 | 1584.0 |
| 2008-12-31 | PA | Futures | 213.5 | 233.22 | 208.13 | 215.68 | 1787.0 |
> showing 50 of 77 rows — these rows as CSV