PREVIEW / futures_daily / 2008-03-06
file: by_date/futures_daily/2008/2008-03-06.parquet size: 8 KB rows: 78
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-03-06 | ES | Futures | 1238.06 | 1244.78 | 1207.01 | 1212.34 | 2517077.0 |
| 2008-03-06 | NQ | Futures | 1972.74 | 1990.14 | 1920.54 | 1924.19 | 429884.0 |
| 2008-03-06 | YM | Futures | 10903.5 | 10956.8 | 10679.6 | 10721.4 | 209087.0 |
| 2008-03-06 | CL | Futures | 448.7 | 454.4 | 441.02 | 452.26 | 337767.0 |
| 2008-03-06 | GC | Futures | 1416.7 | 1421.5 | 1381.7 | 1396.9 | 171611.0 |
| 2008-03-06 | ZN | Futures | 84.775279 | 85.403826 | 84.719159 | 85.145673 | 128239.0 |
| 2008-03-06 | A6 | Futures | 0.70356 | 0.7068 | 0.69617 | 0.69798 | 46113.0 |
| 2008-03-06 | AD | Futures | 0.99773 | 1.00018 | 0.99321 | 0.99645 | 36940.0 |
| 2008-03-06 | B | Futures | 120.87 | 122.3 | 119.05 | 121.8 | 83205.0 |
| 2008-03-06 | B6 | Futures | 2.0247 | 2.047 | 2.0225 | 2.0423 | 83374.0 |
| 2008-03-06 | BFX | Futures | 4237.8 | 4237.8 | 4153.4 | 4154.1 | 149.0 |
| 2008-03-06 | BR | Futures | 0.21336 | 0.21336 | 0.21083 | 0.21166 | 18.0 |
| 2008-03-06 | BZ | Futures | 118.93 | 119.62 | 116.85 | 119.47 | 2169.0 |
| 2008-03-06 | CB | Futures | 88.378 | 88.378 | 88.061 | 88.22 | 1.0 |
| 2008-03-06 | CC | Futures | 2523.0 | 2610.0 | 2471.0 | 2520.0 | 11444.0 |
| 2008-03-06 | CT | Futures | 104.91 | 105.33 | 100.52 | 100.52 | 37155.0 |
| 2008-03-06 | DC | Futures | 45.86 | 46.15 | 45.75 | 45.96 | 35.0 |
| 2008-03-06 | DX | Futures | 79.316 | 79.332 | 78.674 | 78.852 | 6442.0 |
| 2008-03-06 | E1 | Futures | 1.28658 | 1.30484 | 1.28365 | 1.29964 | 61212.0 |
| 2008-03-06 | E6 | Futures | 1.77188 | 1.78568 | 1.77095 | 1.78232 | 219626.0 |
| 2008-03-06 | E7 | Futures | 1.758 | 1.7722 | 1.7577 | 1.7689 | 2677.0 |
| 2008-03-06 | EBM | Futures | 245.55 | 246.2 | 241.85 | 242.07 | 2104.0 |
| 2008-03-06 | ED | Futures | 91.7904 | 91.8613 | 91.7881 | 91.8141 | 249111.0 |
| 2008-03-06 | ER | Futures | 94.185 | 94.185 | 94.125 | 94.14 | 211471.0 |
| 2008-03-06 | EW | Futures | 784.3 | 790.0 | 760.2 | 762.9 | 34187.0 |
| 2008-03-06 | FCE | Futures | 3115.9 | 3119.1 | 3045.1 | 3053.9 | 153940.0 |
| 2008-03-06 | FDAX | Futures | 7584.8 | 7588.2 | 7407.1 | 7407.1 | 177246.0 |
| 2008-03-06 | FESX | Futures | 2104.9 | 2106.1 | 2041.2 | 2041.2 | 1428818.0 |
| 2008-03-06 | FEU3 | Futures | 94.65 | 94.65 | 94.615 | 94.615 | 1940.0 |
| 2008-03-06 | FGBL | Futures | 88.09 | 88.44 | 87.98 | 88.44 | 1470086.0 |
| 2008-03-06 | FGBM | Futures | 94.46 | 94.62 | 94.3 | 94.4 | 838592.0 |
| 2008-03-06 | FGBS | Futures | 101.989 | 102.139 | 101.8 | 101.882 | 1325521.0 |
| 2008-03-06 | FGBX | Futures | 77.57 | 78.42 | 77.2 | 78.23 | 6660.0 |
| 2008-03-06 | FTDX | Futures | 707.2 | 710.0 | 694.4 | 694.4 | 1102.0 |
| 2008-03-06 | FTI | Futures | 330.35 | 330.65 | 323.65 | 324.57 | 35889.0 |
| 2008-03-06 | FTUK | Futures | 3790.7 | 3790.7 | 3709.4 | 3730.1 | 122071.0 |
| 2008-03-06 | G | Futures | 69.97 | 70.57 | 69.97 | 70.43 | 108394.0 |
| 2008-03-06 | GF | Futures | 297.041 | 298.669 | 295.413 | 295.413 | 163.0 |
| 2008-03-06 | HE | Futures | 133.661 | 137.585 | 133.661 | 134.481 | 7683.0 |
| 2008-03-06 | HG | Futures | 5.5297 | 5.6134 | 5.3706 | 5.4453 | 13524.0 |
| 2008-03-06 | HO | Futures | 3.2907 | 3.3348 | 3.2535 | 3.3323 | 9814.0 |
| 2008-03-06 | J1 | Futures | 0.0123428 | 0.0125094 | 0.0123313 | 0.0124607 | 108826.0 |
| 2008-03-06 | J7 | Futures | 0.012133 | 0.01229 | 0.012116 | 0.012241 | 76.0 |
| 2008-03-06 | JB | Futures | 115.49 | 115.8 | 115.42 | 115.8 | 1475.0 |
| 2008-03-06 | KC | Futures | 511.87 | 523.7 | 482.52 | 488.36 | 23819.0 |
| 2008-03-06 | KE | Futures | 6331.31 | 6485.7 | 6218.54 | 6350.1 | 7340.0 |
| 2008-03-06 | L | Futures | 93.854 | 93.894 | 93.835 | 93.864 | 75628.0 |
| 2008-03-06 | LE | Futures | 191.202 | 192.362 | 189.725 | 189.725 | 5495.0 |
| 2008-03-06 | MP | Futures | 0.04411 | 0.04412 | 0.04217 | 0.04358 | 64993.0 |
| 2008-03-06 | N6 | Futures | 0.60059 | 0.60209 | 0.5952 | 0.59685 | 888.0 |
> showing 50 of 78 rows — these rows as CSV