PREVIEW / futures_daily / 2009-04-30
file: by_date/futures_daily/2009/2009-04-30.parquet size: 9 KB rows: 87
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-04-30 | ES | Futures | 827.76 | 845.39 | 823.95 | 829.19 | 2712027.0 |
| 2009-04-30 | NQ | Futures | 1547.36 | 1592.3 | 1546.23 | 1565.61 | 349743.0 |
| 2009-04-30 | YM | Futures | 7278.2 | 7424.4 | 7250.3 | 7288.9 | 188313.0 |
| 2009-04-30 | CL | Futures | 136.8 | 139.9 | 135.24 | 137.69 | 208296.0 |
| 2009-04-30 | GC | Futures | 1244.2 | 1247.3 | 1218.6 | 1234.0 | 81596.0 |
| 2009-04-30 | ZN | Futures | 94.014605 | 94.184526 | 93.638352 | 93.941782 | 641782.0 |
| 2009-04-30 | A6 | Futures | 0.5758 | 0.58721 | 0.57509 | 0.58003 | 53474.0 |
| 2009-04-30 | AD | Futures | 0.81788 | 0.83038 | 0.81768 | 0.82546 | 55226.0 |
| 2009-04-30 | B | Futures | 49.47 | 50.47 | 49.14 | 49.95 | 58675.0 |
| 2009-04-30 | B6 | Futures | 1.5355 | 1.5558 | 1.5296 | 1.542 | 95796.0 |
| 2009-04-30 | BFX | Futures | 2160.6 | 2177.9 | 2120.7 | 2124.3 | 2283.0 |
| 2009-04-30 | BR | Futures | 0.17336 | 0.17431 | 0.17336 | 0.17374 | 288.0 |
| 2009-04-30 | BZ | Futures | 53.58 | 54.13 | 53.54 | 54.13 | 5.0 |
| 2009-04-30 | C | Futures | 1841.0 | 1846.0 | 1814.0 | 1815.0 | 2034.0 |
| 2009-04-30 | CB | Futures | 76.436 | 76.436 | 76.436 | 76.436 | 8.0 |
| 2009-04-30 | CC | Futures | 2140.0 | 2156.0 | 2088.0 | 2095.0 | 6216.0 |
| 2009-04-30 | CT | Futures | 49.29 | 50.38 | 48.72 | 50.29 | 10396.0 |
| 2009-04-30 | DC | Futures | 26.14 | 26.26 | 25.56 | 25.8 | 177.0 |
| 2009-04-30 | DX | Futures | 87.262 | 87.673 | 86.536 | 87.298 | 3922.0 |
| 2009-04-30 | E1 | Futures | 1.16695 | 1.17716 | 1.16046 | 1.16457 | 35602.0 |
| 2009-04-30 | E6 | Futures | 1.57138 | 1.58667 | 1.56355 | 1.57209 | 190696.0 |
| 2009-04-30 | E7 | Futures | 1.5531 | 1.5684 | 1.5454 | 1.5539 | 2717.0 |
| 2009-04-30 | EBM | Futures | 219.05 | 221.37 | 219.05 | 219.82 | 2042.0 |
| 2009-04-30 | ED | Futures | 93.3556 | 93.3886 | 93.3462 | 93.3791 | 170676.0 |
| 2009-04-30 | ER | Futures | 96.699 | 96.713 | 96.689 | 96.709 | 93948.0 |
| 2009-04-30 | EW | Futures | 538.5 | 554.1 | 528.5 | 541.3 | 55650.0 |
| 2009-04-30 | FCE | Futures | 1958.0 | 2003.4 | 1951.6 | 1980.8 | 183326.0 |
| 2009-04-30 | FDAX | Futures | 5143.3 | 5279.5 | 5133.5 | 5226.1 | 192729.0 |
| 2009-04-30 | FESX | Futures | 1368.7 | 1408.3 | 1366.3 | 1396.9 | 1605445.0 |
| 2009-04-30 | FEU3 | Futures | 97.278 | 97.288 | 97.278 | 97.288 | 294.0 |
| 2009-04-30 | FGBL | Futures | 92.59 | 92.7 | 92.23 | 92.48 | 731558.0 |
| 2009-04-30 | FGBM | Futures | 97.91 | 98.03 | 97.65 | 97.86 | 397584.0 |
| 2009-04-30 | FGBS | Futures | 103.781 | 103.815 | 103.642 | 103.733 | 508890.0 |
| 2009-04-30 | FGBX | Futures | 84.4 | 84.41 | 83.63 | 84.23 | 2003.0 |
| 2009-04-30 | FTDX | Futures | 513.5 | 532.4 | 513.5 | 527.0 | 1588.0 |
| 2009-04-30 | FTI | Futures | 197.61 | 200.46 | 196.01 | 197.94 | 45934.0 |
| 2009-04-30 | FTUK | Futures | 2785.6 | 2833.9 | 2757.3 | 2801.2 | 160494.0 |
| 2009-04-30 | G | Futures | 76.41 | 76.74 | 76.19 | 76.49 | 84737.0 |
| 2009-04-30 | GF | Futures | 275.328 | 277.003 | 273.373 | 275.258 | 438.0 |
| 2009-04-30 | GSCI | Futures | 776.18 | 780.75 | 769.8 | 777.77 | 369.0 |
| 2009-04-30 | HE | Futures | 98.44 | 98.853 | 95.676 | 95.882 | 1472.0 |
| 2009-04-30 | HG | Futures | 2.8314 | 2.9165 | 2.8047 | 2.8807 | 10130.0 |
| 2009-04-30 | HO | Futures | 1.4701 | 1.4857 | 1.4407 | 1.4585 | 36483.0 |
| 2009-04-30 | HRC | Futures | 2563.8 | 2595.1 | 2563.8 | 2595.1 | 20.0 |
| 2009-04-30 | J1 | Futures | 0.0129139 | 0.0129845 | 0.0127375 | 0.0127753 | 101171.0 |
| 2009-04-30 | J7 | Futures | 0.012742 | 0.012804 | 0.012568 | 0.012602 | 452.0 |
| 2009-04-30 | JB | Futures | 114.85 | 114.92 | 114.41 | 114.65 | 3609.0 |
| 2009-04-30 | KC | Futures | 323.22 | 323.77 | 315.74 | 321.14 | 7978.0 |
| 2009-04-30 | KE | Futures | 2832.82 | 2888.89 | 2823.07 | 2851.1 | 7213.0 |
| 2009-04-30 | L | Futures | 96.944 | 96.993 | 96.925 | 96.974 | 48790.0 |
> showing 50 of 87 rows — these rows as CSV