PREVIEW / futures_daily / 2009-01-14
file: by_date/futures_daily/2009/2009-01-14.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-14 | ES | Futures | 820.35 | 826.25 | 786.12 | 792.97 | 2749495.0 |
| 2009-01-14 | NQ | Futures | 1346.06 | 1353.6 | 1291.55 | 1303.01 | 289537.0 |
| 2009-01-14 | YM | Futures | 7489.1 | 7536.3 | 7200.6 | 7264.7 | 202766.0 |
| 2009-01-14 | CL | Futures | 149.99 | 152.55 | 141.25 | 146.8 | 259288.0 |
| 2009-01-14 | GC | Futures | 1145.8 | 1157.1 | 1124.6 | 1127.6 | 117221.0 |
| 2009-01-14 | ZN | Futures | 96.602871 | 97.52324 | 96.244286 | 97.128796 | 508269.0 |
| 2009-01-14 | A6 | Futures | 0.52551 | 0.53725 | 0.51893 | 0.52099 | 31114.0 |
| 2009-01-14 | AD | Futures | 0.80252 | 0.81106 | 0.78601 | 0.78886 | 36360.0 |
| 2009-01-14 | B | Futures | 49.14 | 50.13 | 47.66 | 49.14 | 165065.0 |
| 2009-01-14 | B6 | Futures | 1.5059 | 1.5261 | 1.5034 | 1.5136 | 57237.0 |
| 2009-01-14 | BFX | Futures | 2171.6 | 2171.6 | 2076.8 | 2080.0 | 2164.0 |
| 2009-01-14 | BZ | Futures | 49.09 | 49.92 | 48.02 | 49.33 | 153.0 |
| 2009-01-14 | C | Futures | 1803.0 | 1845.0 | 1741.0 | 1743.0 | 10317.0 |
| 2009-01-14 | CB | Futures | 77.664 | 77.664 | 76.672 | 77.333 | 15.0 |
| 2009-01-14 | CC | Futures | 2204.0 | 2243.0 | 2088.0 | 2116.0 | 12920.0 |
| 2009-01-14 | CT | Futures | 45.14 | 45.86 | 44.37 | 44.78 | 7938.0 |
| 2009-01-14 | DC | Futures | 26.97 | 27.0 | 26.43 | 26.49 | 253.0 |
| 2009-01-14 | DX | Futures | 87.989 | 88.523 | 87.289 | 88.315 | 3538.0 |
| 2009-01-14 | E1 | Futures | 1.18853 | 1.19704 | 1.18295 | 1.19026 | 25819.0 |
| 2009-01-14 | E6 | Futures | 1.55742 | 1.57566 | 1.54665 | 1.55529 | 178186.0 |
| 2009-01-14 | E7 | Futures | 1.5397 | 1.5575 | 1.5291 | 1.5375 | 2398.0 |
| 2009-01-14 | EBM | Futures | 223.19 | 224.72 | 220.89 | 224.72 | 1302.0 |
| 2009-01-14 | ED | Futures | 93.4015 | 93.4062 | 93.3073 | 93.3215 | 282991.0 |
| 2009-01-14 | ER | Futures | 96.179 | 96.204 | 96.12 | 96.155 | 149336.0 |
| 2009-01-14 | EW | Futures | 507.8 | 511.6 | 484.5 | 488.5 | 31999.0 |
| 2009-01-14 | FCE | Futures | 1994.6 | 1998.3 | 1869.7 | 1890.4 | 160787.0 |
| 2009-01-14 | FDAX | Futures | 5121.7 | 5126.1 | 4795.8 | 4856.9 | 198178.0 |
| 2009-01-14 | FESX | Futures | 1399.0 | 1400.1 | 1306.5 | 1323.1 | 1711023.0 |
| 2009-01-14 | FEU3 | Futures | 96.746 | 96.766 | 96.711 | 96.721 | 1076.0 |
| 2009-01-14 | FGBL | Futures | 93.44 | 94.15 | 93.14 | 93.99 | 760498.0 |
| 2009-01-14 | FGBM | Futures | 97.92 | 98.33 | 97.68 | 98.18 | 460027.0 |
| 2009-01-14 | FGBS | Futures | 103.522 | 103.671 | 103.421 | 103.565 | 565772.0 |
| 2009-01-14 | FGBX | Futures | 84.95 | 85.46 | 83.9 | 85.07 | 4663.0 |
| 2009-01-14 | FTDX | Futures | 430.5 | 430.5 | 403.6 | 409.0 | 338.0 |
| 2009-01-14 | FTI | Futures | 211.17 | 211.73 | 197.29 | 199.55 | 40112.0 |
| 2009-01-14 | FTUK | Futures | 2874.8 | 2877.4 | 2673.5 | 2708.2 | 177041.0 |
| 2009-01-14 | G | Futures | 76.06 | 76.85 | 75.84 | 76.7 | 79828.0 |
| 2009-01-14 | GF | Futures | 266.237 | 266.939 | 260.205 | 265.466 | 465.0 |
| 2009-01-14 | GSCI | Futures | 813.83 | 820.16 | 792.72 | 813.83 | 486.0 |
| 2009-01-14 | HE | Futures | 118.789 | 118.837 | 112.989 | 115.841 | 10107.0 |
| 2009-01-14 | HG | Futures | 2.1478 | 2.1745 | 2.0422 | 2.0936 | 15265.0 |
| 2009-01-14 | HO | Futures | 1.6938 | 1.7104 | 1.5869 | 1.6283 | 34462.0 |
| 2009-01-14 | HRC | Futures | 3130.5 | 3130.5 | 3130.5 | 3130.5 | 0.0 |
| 2009-01-14 | J1 | Futures | 0.0141458 | 0.0142696 | 0.0140523 | 0.0141849 | 78491.0 |
| 2009-01-14 | J7 | Futures | 0.013964 | 0.014094 | 0.013887 | 0.014014 | 87.0 |
| 2009-01-14 | JB | Futures | 117.01 | 117.01 | 116.66 | 117.01 | 1.0 |
| 2009-01-14 | KC | Futures | 330.96 | 333.39 | 326.82 | 327.67 | 6926.0 |
| 2009-01-14 | KE | Futures | 2990.41 | 3040.37 | 2945.44 | 2997.9 | 6536.0 |
| 2009-01-14 | L | Futures | 97.019 | 97.029 | 96.93 | 96.96 | 61628.0 |
| 2009-01-14 | LBS | Futures | 975.4 | 975.4 | 929.5 | 929.5 | 142.0 |
> showing 50 of 86 rows — these rows as CSV