PREVIEW / futures_daily / 2008-07-23
file: by_date/futures_daily/2008/2008-07-23.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-07-23 | ES | Futures | 1179.32 | 1194.35 | 1177.24 | 1186.26 | 2125754.0 |
| 2008-07-23 | NQ | Futures | 2030.51 | 2080.57 | 2027.17 | 2056.93 | 494064.0 |
| 2008-07-23 | YM | Futures | 10271.9 | 10374.9 | 10250.6 | 10313.6 | 194513.0 |
| 2008-07-23 | CL | Futures | 557.77 | 558.64 | 538.76 | 540.15 | 293200.0 |
| 2008-07-23 | GC | Futures | 1339.5 | 1344.3 | 1299.3 | 1306.8 | 203965.0 |
| 2008-07-23 | ZN | Futures | 83.502907 | 83.52592 | 83.100178 | 83.22675 | 965203.0 |
| 2008-07-23 | A6 | Futures | 0.74497 | 0.74752 | 0.73616 | 0.73732 | 53029.0 |
| 2008-07-23 | AD | Futures | 0.97374 | 0.976 | 0.97001 | 0.97148 | 31041.0 |
| 2008-07-23 | B | Futures | 155.07 | 155.19 | 149.33 | 150.14 | 112071.0 |
| 2008-07-23 | B6 | Futures | 2.0427 | 2.0551 | 2.0411 | 2.048 | 88595.0 |
| 2008-07-23 | BFX | Futures | 3538.5 | 3585.8 | 3506.6 | 3563.5 | 431.0 |
| 2008-07-23 | BR | Futures | 0.22884 | 0.22884 | 0.22809 | 0.22813 | 6.0 |
| 2008-07-23 | BZ | Futures | 150.26 | 152.84 | 147.82 | 147.92 | 1292.0 |
| 2008-07-23 | C | Futures | 1290.0 | 1291.0 | 1276.0 | 1282.0 | 4142.0 |
| 2008-07-23 | CB | Futures | 94.703 | 95.01 | 94.397 | 94.397 | 13.0 |
| 2008-07-23 | CC | Futures | 2498.0 | 2500.0 | 2452.0 | 2470.0 | 7295.0 |
| 2008-07-23 | CT | Futures | 71.97 | 74.01 | 71.09 | 73.34 | 269.0 |
| 2008-07-23 | DC | Futures | 51.81 | 51.94 | 50.64 | 50.69 | 271.0 |
| 2008-07-23 | DX | Futures | 76.913 | 77.358 | 76.871 | 77.305 | 10817.0 |
| 2008-07-23 | E1 | Futures | 1.29365 | 1.29578 | 1.28192 | 1.28338 | 67173.0 |
| 2008-07-23 | E6 | Futures | 1.84323 | 1.8444 | 1.82942 | 1.83024 | 227985.0 |
| 2008-07-23 | E7 | Futures | 1.8254 | 1.8264 | 1.8116 | 1.8125 | 2837.0 |
| 2008-07-23 | ED | Futures | 91.6077 | 91.6313 | 91.5841 | 91.5983 | 234684.0 |
| 2008-07-23 | ER | Futures | 93.556 | 93.571 | 93.541 | 93.556 | 64175.0 |
| 2008-07-23 | EW | Futures | 806.3 | 817.6 | 804.4 | 810.1 | 29288.0 |
| 2008-07-23 | FCE | Futures | 2844.7 | 2887.0 | 2843.7 | 2876.3 | 128155.0 |
| 2008-07-23 | FDAX | Futures | 7314.2 | 7402.1 | 7312.0 | 7375.8 | 147007.0 |
| 2008-07-23 | FESX | Futures | 1976.7 | 2006.1 | 1976.7 | 2000.2 | 1341794.0 |
| 2008-07-23 | FEU3 | Futures | 94.092 | 94.107 | 94.092 | 94.102 | 663.0 |
| 2008-07-23 | FGBL | Futures | 82.79 | 82.94 | 82.56 | 82.93 | 966962.0 |
| 2008-07-23 | FGBM | Futures | 89.19 | 89.37 | 89.09 | 89.36 | 546294.0 |
| 2008-07-23 | FGBS | Futures | 98.979 | 99.11 | 98.95 | 99.105 | 445875.0 |
| 2008-07-23 | FGBX | Futures | 73.64 | 74.58 | 73.1 | 74.58 | 2298.0 |
| 2008-07-23 | FTDX | Futures | 677.8 | 682.3 | 672.4 | 680.5 | 709.0 |
| 2008-07-23 | FTI | Futures | 309.05 | 312.71 | 309.05 | 310.55 | 28549.0 |
| 2008-07-23 | FTUK | Futures | 3520.6 | 3550.4 | 3488.5 | 3540.6 | 98293.0 |
| 2008-07-23 | G | Futures | 67.0 | 67.04 | 66.8 | 67.01 | 78584.0 |
| 2008-07-23 | GF | Futures | 309.172 | 309.579 | 304.291 | 305.375 | 436.0 |
| 2008-07-23 | GSCI | Futures | 2012.83 | 2014.11 | 1958.55 | 1958.81 | 214.0 |
| 2008-07-23 | HE | Futures | 157.172 | 157.322 | 154.675 | 156.673 | 5603.0 |
| 2008-07-23 | HG | Futures | 5.1427 | 5.1609 | 5.0389 | 5.0974 | 14979.0 |
| 2008-07-23 | HO | Futures | 4.3098 | 4.3098 | 4.1373 | 4.1565 | 33586.0 |
| 2008-07-23 | J1 | Futures | 0.0118922 | 0.0119062 | 0.0118146 | 0.0118222 | 101644.0 |
| 2008-07-23 | J7 | Futures | 0.011693 | 0.011695 | 0.011614 | 0.011619 | 158.0 |
| 2008-07-23 | JB | Futures | 113.37 | 113.37 | 113.02 | 113.03 | 1781.0 |
| 2008-07-23 | KC | Futures | 416.3 | 417.21 | 409.32 | 412.5 | 11870.0 |
| 2008-07-23 | KE | Futures | 4371.04 | 4401.54 | 4280.86 | 4307.39 | 10065.0 |
| 2008-07-23 | L | Futures | 93.339 | 93.353 | 93.299 | 93.329 | 63936.0 |
| 2008-07-23 | LE | Futures | 193.751 | 195.557 | 192.223 | 195.418 | 5745.0 |
| 2008-07-23 | MP | Futures | 0.04761 | 0.04781 | 0.0474 | 0.04776 | 29214.0 |
> showing 50 of 83 rows — these rows as CSV