PREVIEW / futures_daily / 2009-05-21
file: by_date/futures_daily/2009/2009-05-21.parquet size: 8 KB rows: 85
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-21 | ES | Futures | 857.78 | 858.74 | 836.58 | 847.06 | 2388542.0 |
| 2009-05-21 | NQ | Futures | 1563.93 | 1565.61 | 1518.99 | 1536.4 | 334972.0 |
| 2009-05-21 | YM | Futures | 7531.1 | 7537.4 | 7361.6 | 7440.5 | 163485.0 |
| 2009-05-21 | CL | Futures | 164.2 | 164.71 | 159.52 | 162.53 | 237412.0 |
| 2009-05-21 | GC | Futures | 1299.5 | 1325.1 | 1295.7 | 1317.0 | 130919.0 |
| 2009-05-21 | ZN | Futures | 93.941782 | 94.257349 | 92.946533 | 93.152865 | 1080205.0 |
| 2009-05-21 | A6 | Futures | 0.61592 | 0.62054 | 0.6105 | 0.61727 | 54242.0 |
| 2009-05-21 | AD | Futures | 0.86228 | 0.86789 | 0.85746 | 0.86346 | 68885.0 |
| 2009-05-21 | B | Futures | 58.15 | 58.45 | 56.66 | 57.72 | 91859.0 |
| 2009-05-21 | B6 | Futures | 1.6374 | 1.6533 | 1.614 | 1.6478 | 133248.0 |
| 2009-05-21 | BFX | Futures | 2385.3 | 2385.3 | 2324.0 | 2342.2 | 132.0 |
| 2009-05-21 | BZ | Futures | 61.57 | 62.88 | 61.43 | 62.56 | 42.0 |
| 2009-05-21 | C | Futures | 1719.0 | 1737.0 | 1705.0 | 1725.0 | 7568.0 |
| 2009-05-21 | CB | Futures | 77.038 | 77.038 | 76.737 | 76.737 | 6.0 |
| 2009-05-21 | CC | Futures | 2083.0 | 2108.0 | 2052.0 | 2100.0 | 4832.0 |
| 2009-05-21 | CT | Futures | 52.83 | 53.03 | 51.9 | 52.53 | 6082.0 |
| 2009-05-21 | DC | Futures | 24.43 | 24.63 | 24.27 | 24.34 | 331.0 |
| 2009-05-21 | DX | Futures | 83.534 | 83.925 | 82.834 | 83.04 | 11548.0 |
| 2009-05-21 | E1 | Futures | 1.20381 | 1.21561 | 1.19944 | 1.2127 | 32689.0 |
| 2009-05-21 | E6 | Futures | 1.63113 | 1.65045 | 1.62698 | 1.64642 | 226822.0 |
| 2009-05-21 | E7 | Futures | 1.612 | 1.6312 | 1.6081 | 1.6273 | 2750.0 |
| 2009-05-21 | ED | Futures | 93.7044 | 93.7444 | 93.6431 | 93.6572 | 355663.0 |
| 2009-05-21 | ER | Futures | 96.782 | 96.787 | 96.758 | 96.767 | 104400.0 |
| 2009-05-21 | EW | Futures | 542.8 | 543.9 | 528.3 | 537.1 | 30783.0 |
| 2009-05-21 | FCE | Futures | 2101.1 | 2108.5 | 2064.9 | 2077.6 | 98770.0 |
| 2009-05-21 | FDAX | Futures | 5418.3 | 5436.3 | 5296.9 | 5334.5 | 138713.0 |
| 2009-05-21 | FESX | Futures | 1464.7 | 1469.5 | 1434.7 | 1446.7 | 1010918.0 |
| 2009-05-21 | FEU3 | Futures | 97.342 | 97.362 | 97.342 | 97.352 | 119.0 |
| 2009-05-21 | FGBL | Futures | 91.08 | 91.71 | 90.81 | 91.46 | 659573.0 |
| 2009-05-21 | FGBM | Futures | 97.31 | 97.83 | 97.25 | 97.69 | 415815.0 |
| 2009-05-21 | FGBS | Futures | 103.786 | 103.978 | 103.771 | 103.92 | 390933.0 |
| 2009-05-21 | FGBX | Futures | 80.21 | 81.07 | 79.77 | 80.69 | 2551.0 |
| 2009-05-21 | FTDX | Futures | 570.2 | 571.1 | 550.4 | 554.0 | 394.0 |
| 2009-05-21 | FTI | Futures | 215.19 | 217.17 | 212.72 | 213.22 | 26782.0 |
| 2009-05-21 | FTUK | Futures | 2921.8 | 2926.8 | 2861.2 | 2882.5 | 112331.0 |
| 2009-05-21 | G | Futures | 76.08 | 76.32 | 75.27 | 75.66 | 147901.0 |
| 2009-05-21 | GF | Futures | 279.765 | 280.454 | 278.387 | 280.247 | 583.0 |
| 2009-05-21 | GSCI | Futures | 885.1 | 892.78 | 876.57 | 889.58 | 236.0 |
| 2009-05-21 | HE | Futures | 98.804 | 98.804 | 97.156 | 97.718 | 6144.0 |
| 2009-05-21 | HG | Futures | 2.9531 | 2.9545 | 2.8328 | 2.8856 | 16789.0 |
| 2009-05-21 | HO | Futures | 1.6178 | 1.6531 | 1.6041 | 1.6469 | 9555.0 |
| 2009-05-21 | HRC | Futures | 2495.0 | 2495.0 | 2495.0 | 2495.0 | 0.0 |
| 2009-05-21 | J1 | Futures | 0.0132857 | 0.013413 | 0.0132303 | 0.0133777 | 105197.0 |
| 2009-05-21 | J7 | Futures | 0.013125 | 0.01323 | 0.013054 | 0.013196 | 83.0 |
| 2009-05-21 | JB | Futures | 114.9 | 115.0 | 114.66 | 114.7 | 1611.0 |
| 2009-05-21 | KC | Futures | 368.8 | 376.7 | 365.06 | 376.28 | 8437.0 |
| 2009-05-21 | KE | Futures | 3163.15 | 3188.75 | 3116.83 | 3154.62 | 6455.0 |
| 2009-05-21 | L | Futures | 97.17 | 97.239 | 97.151 | 97.16 | 48904.0 |
| 2009-05-21 | LBS | Futures | 809.1 | 810.5 | 773.5 | 788.6 | 399.0 |
| 2009-05-21 | LE | Futures | 146.008 | 147.109 | 145.082 | 146.669 | 3861.0 |
> showing 50 of 85 rows — these rows as CSV