PREVIEW / futures_daily / 2009-07-08
file: by_date/futures_daily/2009/2009-07-08.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-07-08 | ES | Futures | 843.83 | 847.67 | 830.16 | 838.31 | 2498962.0 |
| 2009-07-08 | NQ | Futures | 1585.92 | 1594.08 | 1568.18 | 1584.51 | 326368.0 |
| 2009-07-08 | YM | Futures | 7336.2 | 7367.8 | 7249.6 | 7322.7 | 164710.0 |
| 2009-07-08 | CL | Futures | 163.95 | 164.92 | 157.9 | 158.24 | 334958.0 |
| 2009-07-08 | GC | Futures | 1279.4 | 1281.9 | 1252.7 | 1258.9 | 131006.0 |
| 2009-07-08 | ZN | Futures | 92.455662 | 93.551487 | 92.418724 | 93.477611 | 960140.0 |
| 2009-07-08 | A6 | Futures | 0.63141 | 0.63141 | 0.61759 | 0.61871 | 105818.0 |
| 2009-07-08 | AD | Futures | 0.84677 | 0.85269 | 0.84252 | 0.84361 | 63393.0 |
| 2009-07-08 | B | Futures | 59.86 | 60.27 | 57.77 | 57.9 | 112808.0 |
| 2009-07-08 | B6 | Futures | 1.68 | 1.6807 | 1.6645 | 1.6691 | 101061.0 |
| 2009-07-08 | BFX | Futures | 2248.8 | 2250.9 | 2221.5 | 2225.5 | 301.0 |
| 2009-07-08 | BR | Futures | 0.19262 | 0.19262 | 0.19042 | 0.19075 | 29.0 |
| 2009-07-08 | C | Futures | 1710.0 | 1768.0 | 1710.0 | 1765.0 | 4487.0 |
| 2009-07-08 | CB | Futures | 71.905 | 71.905 | 71.905 | 71.905 | 16.0 |
| 2009-07-08 | CC | Futures | 2189.0 | 2277.0 | 2176.0 | 2261.0 | 6478.0 |
| 2009-07-08 | CT | Futures | 50.72 | 50.91 | 49.99 | 50.42 | 78.0 |
| 2009-07-08 | DC | Futures | 20.29 | 20.67 | 20.01 | 20.35 | 112.0 |
| 2009-07-08 | DX | Futures | 82.927 | 83.029 | 82.671 | 82.912 | 4708.0 |
| 2009-07-08 | E1 | Futures | 1.21656 | 1.21815 | 1.21074 | 1.21325 | 34804.0 |
| 2009-07-08 | E6 | Futures | 1.65209 | 1.65458 | 1.642 | 1.64413 | 232588.0 |
| 2009-07-08 | E7 | Futures | 1.6355 | 1.6374 | 1.6253 | 1.6273 | 3084.0 |
| 2009-07-08 | ED | Futures | 93.8763 | 93.9188 | 93.8716 | 93.9094 | 182603.0 |
| 2009-07-08 | ER | Futures | 97.017 | 97.027 | 97.007 | 97.017 | 120557.0 |
| 2009-07-08 | EW | Futures | 530.4 | 533.7 | 519.2 | 525.6 | 34959.0 |
| 2009-07-08 | FCE | Futures | 1973.9 | 1989.6 | 1950.8 | 1963.8 | 144356.0 |
| 2009-07-08 | FDAX | Futures | 5019.6 | 5083.2 | 4996.0 | 5009.1 | 158132.0 |
| 2009-07-08 | FESX | Futures | 1369.4 | 1382.5 | 1354.4 | 1361.6 | 1129767.0 |
| 2009-07-08 | FEU3 | Futures | 97.594 | 97.594 | 97.594 | 97.594 | 416.0 |
| 2009-07-08 | FGBL | Futures | 92.81 | 93.1 | 92.65 | 92.85 | 595826.0 |
| 2009-07-08 | FGBM | Futures | 98.53 | 98.71 | 98.46 | 98.56 | 326962.0 |
| 2009-07-08 | FGBS | Futures | 104.258 | 104.33 | 104.239 | 104.282 | 370060.0 |
| 2009-07-08 | FGBX | Futures | 84.24 | 84.69 | 83.99 | 84.34 | 1619.0 |
| 2009-07-08 | FTDX | Futures | 541.6 | 547.0 | 533.6 | 540.7 | 690.0 |
| 2009-07-08 | FTI | Futures | 200.05 | 201.71 | 198.01 | 198.62 | 30010.0 |
| 2009-07-08 | FTUK | Futures | 2743.6 | 2762.8 | 2710.7 | 2722.3 | 110315.0 |
| 2009-07-08 | G | Futures | 76.09 | 76.31 | 75.96 | 76.21 | 85704.0 |
| 2009-07-08 | GF | Futures | 283.348 | 283.899 | 279.834 | 280.178 | 3410.0 |
| 2009-07-08 | GSCI | Futures | 855.35 | 857.02 | 834.49 | 834.49 | 2654.0 |
| 2009-07-08 | HE | Futures | 89.066 | 89.389 | 87.446 | 87.842 | 17372.0 |
| 2009-07-08 | HG | Futures | 3.0905 | 3.1452 | 3.0076 | 3.0315 | 20388.0 |
| 2009-07-08 | HO | Futures | 1.6489 | 1.657 | 1.5948 | 1.599 | 21912.0 |
| 2009-07-08 | HRC | Futures | 2409.0 | 2409.0 | 2409.0 | 2409.0 | 0.0 |
| 2009-07-08 | J1 | Futures | 0.0132916 | 0.0137272 | 0.0132753 | 0.0136315 | 166447.0 |
| 2009-07-08 | J7 | Futures | 0.013102 | 0.013522 | 0.013102 | 0.013444 | 189.0 |
| 2009-07-08 | JB | Futures | 116.58 | 116.93 | 116.58 | 116.84 | 3138.0 |
| 2009-07-08 | KC | Futures | 317.6 | 318.55 | 311.36 | 312.58 | 7499.0 |
| 2009-07-08 | KE | Futures | 2606.82 | 2658.38 | 2606.82 | 2621.21 | 9730.0 |
| 2009-07-08 | L | Futures | 97.239 | 97.278 | 97.229 | 97.268 | 54454.0 |
| 2009-07-08 | LBS | Futures | 849.3 | 849.3 | 817.3 | 831.0 | 232.0 |
| 2009-07-08 | LE | Futures | 147.506 | 148.034 | 146.625 | 146.889 | 20019.0 |
> showing 50 of 85 rows — these rows as CSV