PREVIEW / futures_daily / 2008-09-24
file: by_date/futures_daily/2008/2008-09-24.parquet size: 8 KB rows: 83
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 |
|---|---|---|---|---|---|---|---|
| 2008-09-24 | ES | Futures | 1118.65 | 1139.6 | 1111.35 | 1123.36 | 2403254.0 |
| 2008-09-24 | NQ | Futures | 1852.99 | 1881.23 | 1844.88 | 1870.04 | 354265.0 |
| 2008-09-24 | YM | Futures | 9647.5 | 9807.4 | 9549.8 | 9647.5 | 207304.0 |
| 2008-09-24 | CL | Futures | 461.8 | 472.9 | 452.6 | 456.62 | 233417.0 |
| 2008-09-24 | GC | Futures | 1253.6 | 1269.5 | 1231.2 | 1251.6 | 132783.0 |
| 2008-09-24 | ZN | Futures | 85.920066 | 86.516165 | 85.709678 | 86.200583 | 738129.0 |
| 2008-09-24 | A6 | Futures | 0.65308 | 0.65907 | 0.65001 | 0.65458 | 30450.0 |
| 2008-09-24 | AD | Futures | 0.95169 | 0.95751 | 0.9505 | 0.95406 | 29796.0 |
| 2008-09-24 | B | Futures | 121.56 | 124.45 | 119.38 | 120.35 | 105709.0 |
| 2008-09-24 | B6 | Futures | 1.9188 | 1.9262 | 1.9119 | 1.9179 | 44632.0 |
| 2008-09-24 | BFX | Futures | 3256.9 | 3258.6 | 3216.6 | 3228.4 | 786.0 |
| 2008-09-24 | BZ | Futures | 121.47 | 121.67 | 117.25 | 117.85 | 750.0 |
| 2008-09-24 | C | Futures | 1336.0 | 1366.0 | 1331.0 | 1356.0 | 4687.0 |
| 2008-09-24 | CB | Futures | 96.22 | 96.22 | 96.22 | 96.22 | 1.0 |
| 2008-09-24 | CC | Futures | 2418.0 | 2475.0 | 2417.0 | 2450.0 | 7091.0 |
| 2008-09-24 | CT | Futures | 62.03 | 62.7 | 60.22 | 61.09 | 10677.0 |
| 2008-09-24 | DC | Futures | 42.16 | 42.54 | 41.6 | 41.78 | 111.0 |
| 2008-09-24 | DX | Futures | 80.384 | 80.939 | 80.185 | 80.536 | 4262.0 |
| 2008-09-24 | E1 | Futures | 1.23537 | 1.24084 | 1.22789 | 1.23096 | 42097.0 |
| 2008-09-24 | E6 | Futures | 1.73162 | 1.74131 | 1.72595 | 1.73138 | 153031.0 |
| 2008-09-24 | E7 | Futures | 1.7164 | 1.7246 | 1.7094 | 1.7148 | 2725.0 |
| 2008-09-24 | ED | Futures | 91.2274 | 91.2463 | 90.8968 | 90.9582 | 408764.0 |
| 2008-09-24 | ER | Futures | 93.398 | 93.457 | 93.364 | 93.438 | 161805.0 |
| 2008-09-24 | EW | Futures | 747.2 | 760.2 | 737.4 | 741.8 | 28937.0 |
| 2008-09-24 | FCE | Futures | 2661.2 | 2683.4 | 2635.6 | 2650.0 | 111707.0 |
| 2008-09-24 | FDAX | Futures | 6845.4 | 6890.1 | 6783.3 | 6833.6 | 141403.0 |
| 2008-09-24 | FESX | Futures | 1820.4 | 1838.4 | 1803.1 | 1818.7 | 1414167.0 |
| 2008-09-24 | FEU3 | Futures | 93.938 | 93.993 | 93.938 | 93.988 | 829.0 |
| 2008-09-24 | FGBL | Futures | 85.25 | 85.84 | 85.2 | 85.84 | 771022.0 |
| 2008-09-24 | FGBM | Futures | 91.29 | 91.72 | 91.24 | 91.72 | 650758.0 |
| 2008-09-24 | FGBS | Futures | 99.923 | 100.135 | 99.875 | 100.106 | 618387.0 |
| 2008-09-24 | FGBX | Futures | 73.75 | 75.3 | 73.75 | 75.22 | 1487.0 |
| 2008-09-24 | FTDX | Futures | 664.4 | 673.4 | 651.9 | 668.9 | 250.0 |
| 2008-09-24 | FTI | Futures | 284.09 | 286.64 | 277.61 | 280.29 | 34132.0 |
| 2008-09-24 | FTUK | Futures | 3359.8 | 3368.8 | 3311.5 | 3330.6 | 113577.0 |
| 2008-09-24 | G | Futures | 68.56 | 69.06 | 68.51 | 68.98 | 84136.0 |
| 2008-09-24 | GF | Futures | 286.914 | 290.005 | 285.705 | 289.199 | 229.0 |
| 2008-09-24 | GSCI | Futures | 1681.48 | 1684.48 | 1632.26 | 1639.01 | 193.0 |
| 2008-09-24 | HE | Futures | 143.754 | 145.112 | 143.047 | 143.971 | 4620.0 |
| 2008-09-24 | HG | Futures | 4.4122 | 4.4535 | 4.3156 | 4.3485 | 10077.0 |
| 2008-09-24 | HO | Futures | 3.4807 | 3.5486 | 3.4213 | 3.4585 | 10425.0 |
| 2008-09-24 | J1 | Futures | 0.0120476 | 0.0120943 | 0.011973 | 0.0120311 | 70419.0 |
| 2008-09-24 | J7 | Futures | 0.011853 | 0.011915 | 0.011813 | 0.011848 | 27.0 |
| 2008-09-24 | JB | Futures | 114.03 | 114.13 | 113.73 | 114.13 | 3706.0 |
| 2008-09-24 | KC | Futures | 399.69 | 404.12 | 397.19 | 400.14 | 5944.0 |
| 2008-09-24 | KE | Futures | 4039.51 | 4078.17 | 3886.12 | 3913.19 | 14645.0 |
| 2008-09-24 | L | Futures | 93.016 | 93.066 | 92.927 | 93.046 | 118623.0 |
| 2008-09-24 | LE | Futures | 189.901 | 191.368 | 189.901 | 191.047 | 7777.0 |
| 2008-09-24 | MP | Futures | 0.04499 | 0.04519 | 0.04457 | 0.04468 | 16524.0 |
| 2008-09-24 | N6 | Futures | 0.52815 | 0.53347 | 0.52611 | 0.53136 | 1668.0 |
> showing 50 of 83 rows — these rows as CSV