PREVIEW / futures_daily / 2009-05-06
file: by_date/futures_daily/2009/2009-05-06.parquet size: 8 KB rows: 84
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-05-06 | ES | Futures | 860.64 | 874.94 | 849.21 | 874.22 | 2650152.0 |
| 2009-05-06 | NQ | Futures | 1602.41 | 1612.8 | 1571.79 | 1606.34 | 396535.0 |
| 2009-05-06 | YM | Futures | 7515.0 | 7605.6 | 7433.3 | 7598.4 | 186363.0 |
| 2009-05-06 | CL | Futures | 145.77 | 152.1 | 144.29 | 151.75 | 334302.0 |
| 2009-05-06 | GC | Futures | 1242.4 | 1264.8 | 1239.8 | 1261.4 | 85608.0 |
| 2009-05-06 | ZN | Futures | 93.90537 | 94.330172 | 93.674764 | 94.075291 | 613013.0 |
| 2009-05-06 | A6 | Futures | 0.58928 | 0.59678 | 0.5833 | 0.59574 | 51982.0 |
| 2009-05-06 | AD | Futures | 0.83747 | 0.84505 | 0.83274 | 0.84407 | 62801.0 |
| 2009-05-06 | B | Futures | 53.39 | 55.19 | 52.96 | 55.05 | 81658.0 |
| 2009-05-06 | B6 | Futures | 1.5678 | 1.5763 | 1.5597 | 1.5743 | 74489.0 |
| 2009-05-06 | BFX | Futures | 2162.1 | 2225.7 | 2162.0 | 2224.6 | 734.0 |
| 2009-05-06 | BZ | Futures | 58.78 | 59.66 | 58.78 | 59.66 | 5.0 |
| 2009-05-06 | C | Futures | 1781.0 | 1807.0 | 1776.0 | 1795.0 | 2666.0 |
| 2009-05-06 | CB | Futures | 76.737 | 77.038 | 76.436 | 76.436 | 16.0 |
| 2009-05-06 | CC | Futures | 2095.0 | 2111.0 | 2065.0 | 2089.0 | 4190.0 |
| 2009-05-06 | CT | Futures | 53.2 | 54.03 | 52.97 | 53.82 | 13721.0 |
| 2009-05-06 | DC | Futures | 25.39 | 25.54 | 25.18 | 25.23 | 347.0 |
| 2009-05-06 | DX | Futures | 86.808 | 87.087 | 86.397 | 86.438 | 3896.0 |
| 2009-05-06 | E1 | Futures | 1.16947 | 1.17557 | 1.16496 | 1.17318 | 30307.0 |
| 2009-05-06 | E6 | Futures | 1.57813 | 1.58548 | 1.57007 | 1.58228 | 188672.0 |
| 2009-05-06 | E7 | Futures | 1.5598 | 1.567 | 1.5521 | 1.5639 | 2653.0 |
| 2009-05-06 | ED | Futures | 93.4169 | 93.4357 | 93.4027 | 93.431 | 183945.0 |
| 2009-05-06 | ER | Futures | 96.728 | 96.753 | 96.718 | 96.743 | 119077.0 |
| 2009-05-06 | EW | Futures | 558.1 | 565.1 | 549.7 | 562.2 | 42390.0 |
| 2009-05-06 | FCE | Futures | 2025.9 | 2098.3 | 2023.1 | 2071.3 | 143049.0 |
| 2009-05-06 | FDAX | Futures | 5278.9 | 5394.4 | 5261.5 | 5325.8 | 164305.0 |
| 2009-05-06 | FESX | Futures | 1416.1 | 1460.5 | 1411.9 | 1439.5 | 1302978.0 |
| 2009-05-06 | FEU3 | Futures | 97.303 | 97.323 | 97.303 | 97.323 | 203.0 |
| 2009-05-06 | FGBL | Futures | 92.49 | 92.57 | 91.85 | 92.14 | 708447.0 |
| 2009-05-06 | FGBM | Futures | 97.91 | 97.92 | 97.53 | 97.8 | 563118.0 |
| 2009-05-06 | FGBS | Futures | 103.771 | 103.815 | 103.656 | 103.791 | 538641.0 |
| 2009-05-06 | FGBX | Futures | 83.47 | 83.66 | 82.6 | 83.04 | 2003.0 |
| 2009-05-06 | FTDX | Futures | 557.6 | 577.4 | 557.6 | 569.3 | 564.0 |
| 2009-05-06 | FTI | Futures | 206.3 | 212.02 | 206.14 | 209.8 | 38973.0 |
| 2009-05-06 | FTUK | Futures | 2855.8 | 2939.1 | 2853.9 | 2910.4 | 156022.0 |
| 2009-05-06 | G | Futures | 76.27 | 76.29 | 75.72 | 75.82 | 104401.0 |
| 2009-05-06 | GF | Futures | 272.256 | 274.699 | 272.256 | 272.814 | 197.0 |
| 2009-05-06 | GSCI | Futures | 824.24 | 844.02 | 824.24 | 842.1 | 114.0 |
| 2009-05-06 | HE | Futures | 98.092 | 100.901 | 98.092 | 100.527 | 10239.0 |
| 2009-05-06 | HG | Futures | 2.9179 | 3.0973 | 2.8997 | 3.0769 | 15821.0 |
| 2009-05-06 | HO | Futures | 1.556 | 1.607 | 1.5449 | 1.6052 | 40077.0 |
| 2009-05-06 | HRC | Futures | 2520.0 | 2520.0 | 2520.0 | 2520.0 | 0.0 |
| 2009-05-06 | J1 | Futures | 0.0127413 | 0.0128761 | 0.0127224 | 0.0128245 | 85391.0 |
| 2009-05-06 | J7 | Futures | 0.012571 | 0.012695 | 0.012553 | 0.01265 | 31.0 |
| 2009-05-06 | KC | Futures | 344.42 | 347.05 | 342.2 | 346.08 | 6951.0 |
| 2009-05-06 | KE | Futures | 2910.83 | 2959.59 | 2901.08 | 2959.59 | 5599.0 |
| 2009-05-06 | L | Futures | 96.974 | 97.003 | 96.964 | 96.993 | 28424.0 |
| 2009-05-06 | LBS | Futures | 794.4 | 829.1 | 788.2 | 818.8 | 160.0 |
| 2009-05-06 | LE | Futures | 145.521 | 146.449 | 144.725 | 144.725 | 7618.0 |
| 2009-05-06 | MP | Futures | 0.03859 | 0.03911 | 0.03846 | 0.03906 | 7012.0 |
> showing 50 of 84 rows — these rows as CSV