PREVIEW / futures_daily / 2009-01-08
file: by_date/futures_daily/2009/2009-01-08.parquet size: 8 KB rows: 86
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 |
|---|---|---|---|---|---|---|---|
| 2009-01-08 | ES | Futures | 854.58 | 857.18 | 841.83 | 856.23 | 1775437.0 |
| 2009-01-08 | NQ | Futures | 1386.86 | 1400.56 | 1367.02 | 1396.92 | 256807.0 |
| 2009-01-08 | YM | Futures | 7786.5 | 7798.0 | 7660.9 | 7742.8 | 159156.0 |
| 2009-01-08 | CL | Futures | 169.25 | 173.22 | 160.95 | 165.55 | 312485.0 |
| 2009-01-08 | GC | Futures | 1175.6 | 1206.4 | 1166.5 | 1191.4 | 111880.0 |
| 2009-01-08 | ZN | Futures | 95.108766 | 96.148663 | 95.060954 | 95.861795 | 509890.0 |
| 2009-01-08 | A6 | Futures | 0.56159 | 0.56231 | 0.54835 | 0.55922 | 30327.0 |
| 2009-01-08 | AD | Futures | 0.82266 | 0.83729 | 0.81264 | 0.83081 | 28276.0 |
| 2009-01-08 | B | Futures | 50.35 | 51.71 | 48.08 | 49.06 | 125428.0 |
| 2009-01-08 | B6 | Futures | 1.5677 | 1.5956 | 1.5553 | 1.5799 | 70826.0 |
| 2009-01-08 | BFX | Futures | 2171.4 | 2193.3 | 2157.3 | 2169.5 | 60.0 |
| 2009-01-08 | BZ | Futures | 50.85 | 50.85 | 49.26 | 49.26 | 96.0 |
| 2009-01-08 | C | Futures | 1776.0 | 1852.0 | 1765.0 | 1827.0 | 14122.0 |
| 2009-01-08 | CB | Futures | 77.664 | 77.994 | 77.664 | 77.664 | 31.0 |
| 2009-01-08 | CC | Futures | 2272.0 | 2347.0 | 2252.0 | 2308.0 | 6806.0 |
| 2009-01-08 | CT | Futures | 48.26 | 49.25 | 47.39 | 49.08 | 7341.0 |
| 2009-01-08 | DC | Futures | 26.24 | 27.37 | 25.98 | 26.97 | 378.0 |
| 2009-01-08 | DX | Futures | 86.319 | 86.584 | 85.018 | 85.376 | 3570.0 |
| 2009-01-08 | E1 | Futures | 1.20714 | 1.22442 | 1.20023 | 1.21711 | 34314.0 |
| 2009-01-08 | E6 | Futures | 1.61271 | 1.63023 | 1.59839 | 1.62124 | 177491.0 |
| 2009-01-08 | E7 | Futures | 1.5946 | 1.6113 | 1.5803 | 1.6027 | 2420.0 |
| 2009-01-08 | EBM | Futures | 221.27 | 222.42 | 217.43 | 222.42 | 2765.0 |
| 2009-01-08 | ED | Futures | 93.1943 | 93.3026 | 93.1943 | 93.2697 | 244178.0 |
| 2009-01-08 | ER | Futures | 95.939 | 95.983 | 95.87 | 95.954 | 162971.0 |
| 2009-01-08 | EW | Futures | 530.0 | 532.7 | 521.0 | 531.5 | 27336.0 |
| 2009-01-08 | FCE | Futures | 2034.5 | 2065.3 | 2013.5 | 2048.6 | 97278.0 |
| 2009-01-08 | FDAX | Futures | 5366.3 | 5393.6 | 5281.6 | 5358.6 | 131144.0 |
| 2009-01-08 | FESX | Futures | 1443.8 | 1460.5 | 1427.1 | 1449.5 | 1094329.0 |
| 2009-01-08 | FEU3 | Futures | 96.485 | 96.544 | 96.445 | 96.544 | 416.0 |
| 2009-01-08 | FGBL | Futures | 92.05 | 92.55 | 91.53 | 92.3 | 725386.0 |
| 2009-01-08 | FGBM | Futures | 97.27 | 97.52 | 96.81 | 97.42 | 432339.0 |
| 2009-01-08 | FGBS | Futures | 103.268 | 103.431 | 103.105 | 103.397 | 456744.0 |
| 2009-01-08 | FGBX | Futures | 83.66 | 84.75 | 82.76 | 84.36 | 1745.0 |
| 2009-01-08 | FTDX | Futures | 456.4 | 456.4 | 442.1 | 450.1 | 279.0 |
| 2009-01-08 | FTI | Futures | 208.98 | 212.9 | 207.86 | 211.66 | 29176.0 |
| 2009-01-08 | FTUK | Futures | 2904.9 | 2954.4 | 2869.5 | 2933.8 | 118953.0 |
| 2009-01-08 | G | Futures | 75.88 | 76.2 | 75.69 | 76.09 | 86195.0 |
| 2009-01-08 | GF | Futures | 261.241 | 261.932 | 257.647 | 258.477 | 126.0 |
| 2009-01-08 | GSCI | Futures | 827.79 | 835.4 | 810.66 | 821.25 | 143.0 |
| 2009-01-08 | HE | Futures | 122.848 | 123.331 | 120.142 | 120.673 | 9868.0 |
| 2009-01-08 | HG | Futures | 2.1196 | 2.1429 | 2.0359 | 2.0816 | 16173.0 |
| 2009-01-08 | HO | Futures | 1.7415 | 1.7906 | 1.6762 | 1.6997 | 23323.0 |
| 2009-01-08 | HRC | Futures | 3101.0 | 3101.0 | 3101.0 | 3101.0 | 0.0 |
| 2009-01-08 | J1 | Futures | 0.0136519 | 0.0139159 | 0.0136014 | 0.0138414 | 97730.0 |
| 2009-01-08 | J7 | Futures | 0.013464 | 0.013742 | 0.013445 | 0.013675 | 136.0 |
| 2009-01-08 | JB | Futures | 115.96 | 116.49 | 115.92 | 116.03 | 25.0 |
| 2009-01-08 | KC | Futures | 324.96 | 332.67 | 323.1 | 324.24 | 7952.0 |
| 2009-01-08 | KE | Futures | 3172.78 | 3217.75 | 3119.07 | 3164.04 | 7286.0 |
| 2009-01-08 | L | Futures | 96.763 | 96.891 | 96.738 | 96.866 | 82357.0 |
| 2009-01-08 | LBS | Futures | 1006.9 | 1013.0 | 991.7 | 992.8 | 29.0 |
> showing 50 of 86 rows — these rows as CSV