PREVIEW / futures_daily / 2008-05-27
file: by_date/futures_daily/2008/2008-05-27.parquet size: 8 KB rows: 81
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-05-27 | ES | Futures | 1272.53 | 1285.03 | 1269.06 | 1282.25 | 1572828.0 |
| 2008-05-27 | NQ | Futures | 2191.23 | 2233.99 | 2184.25 | 2227.84 | 327749.0 |
| 2008-05-27 | YM | Futures | 11081.8 | 11163.5 | 11044.5 | 11146.7 | 138034.0 |
| 2008-05-27 | CL | Futures | 575.86 | 584.48 | 560.56 | 563.49 | 326598.0 |
| 2008-05-27 | GC | Futures | 1316.9 | 1324.7 | 1286.3 | 1292.6 | 97720.0 |
| 2008-05-27 | ZN | Futures | 84.146913 | 84.203845 | 83.55481 | 83.668676 | 1359148.0 |
| 2008-05-27 | A6 | Futures | 0.73067 | 0.73403 | 0.72869 | 0.72991 | 32750.0 |
| 2008-05-27 | AD | Futures | 0.9939 | 0.99606 | 0.98741 | 0.988 | 46613.0 |
| 2008-05-27 | B | Futures | 160.44 | 161.05 | 154.32 | 154.85 | 59115.0 |
| 2008-05-27 | B6 | Futures | 2.0218 | 2.0255 | 2.0122 | 2.0169 | 62751.0 |
| 2008-05-27 | BFX | Futures | 4154.6 | 4157.8 | 4111.2 | 4133.3 | 85.0 |
| 2008-05-27 | BZ | Futures | 157.59 | 157.59 | 151.74 | 152.2 | 1078.0 |
| 2008-05-27 | C | Futures | 1190.0 | 1217.0 | 1190.0 | 1200.0 | 3142.0 |
| 2008-05-27 | CB | Futures | 93.937 | 93.937 | 92.864 | 93.784 | 10.0 |
| 2008-05-27 | CC | Futures | 2324.0 | 2357.0 | 2314.0 | 2325.0 | 5234.0 |
| 2008-05-27 | CT | Futures | 77.42 | 77.86 | 74.02 | 74.06 | 20710.0 |
| 2008-05-27 | DC | Futures | 56.46 | 56.8 | 55.87 | 56.11 | 184.0 |
| 2008-05-27 | DX | Futures | 77.491 | 78.002 | 77.383 | 77.926 | 3607.0 |
| 2008-05-27 | E1 | Futures | 1.30124 | 1.30324 | 1.28752 | 1.28952 | 72921.0 |
| 2008-05-27 | E6 | Futures | 1.83485 | 1.84068 | 1.8246 | 1.82705 | 226651.0 |
| 2008-05-27 | E7 | Futures | 1.8156 | 1.8265 | 1.809 | 1.8113 | 3307.0 |
| 2008-05-27 | ED | Futures | 91.6261 | 91.652 | 91.5791 | 91.5909 | 161957.0 |
| 2008-05-27 | ER | Futures | 93.491 | 93.501 | 93.482 | 93.487 | 61563.0 |
| 2008-05-27 | EW | Futures | 846.7 | 856.6 | 845.4 | 854.2 | 21594.0 |
| 2008-05-27 | FCE | Futures | 3249.7 | 3261.9 | 3218.0 | 3227.2 | 95133.0 |
| 2008-05-27 | FDAX | Futures | 7927.9 | 7975.6 | 7859.8 | 7921.7 | 156264.0 |
| 2008-05-27 | FESX | Futures | 2182.6 | 2190.8 | 2163.3 | 2173.3 | 1020585.0 |
| 2008-05-27 | FEU3 | Futures | 94.022 | 94.022 | 94.007 | 94.007 | 415.0 |
| 2008-05-27 | FGBL | Futures | 84.88 | 85.13 | 84.77 | 84.77 | 787038.0 |
| 2008-05-27 | FGBM | Futures | 90.98 | 91.12 | 90.92 | 90.98 | 463764.0 |
| 2008-05-27 | FGBS | Futures | 99.865 | 99.933 | 99.841 | 99.889 | 566879.0 |
| 2008-05-27 | FGBX | Futures | 75.39 | 75.39 | 74.54 | 74.54 | 2755.0 |
| 2008-05-27 | FTDX | Futures | 763.8 | 775.6 | 753.9 | 775.6 | 663.0 |
| 2008-05-27 | FTI | Futures | 360.83 | 362.34 | 356.25 | 357.45 | 23368.0 |
| 2008-05-27 | FTUK | Futures | 3965.2 | 3978.8 | 3918.0 | 3934.2 | 76567.0 |
| 2008-05-27 | G | Futures | 67.45 | 67.66 | 67.42 | 67.54 | 223626.0 |
| 2008-05-27 | GF | Futures | 312.155 | 315.817 | 312.155 | 312.562 | 179.0 |
| 2008-05-27 | GSCI | Futures | 2162.68 | 2164.01 | 2109.89 | 2111.22 | 140.0 |
| 2008-05-27 | HE | Futures | 153.967 | 154.758 | 151.297 | 152.187 | 3348.0 |
| 2008-05-27 | HG | Futures | 5.2215 | 5.2278 | 5.1407 | 5.1804 | 8702.0 |
| 2008-05-27 | HO | Futures | 4.6523 | 4.6523 | 4.4896 | 4.5025 | 7553.0 |
| 2008-05-27 | J1 | Futures | 0.012378 | 0.0123856 | 0.0122427 | 0.0122503 | 132521.0 |
| 2008-05-27 | J7 | Futures | 0.012113 | 0.012115 | 0.011988 | 0.011993 | 52.0 |
| 2008-05-27 | JB | Futures | 111.73 | 112.06 | 111.52 | 111.9 | 2106.0 |
| 2008-05-27 | KC | Futures | 417.66 | 420.46 | 408.35 | 409.9 | 11557.0 |
| 2008-05-27 | KE | Futures | 4311.31 | 4370.52 | 4304.58 | 4332.84 | 5611.0 |
| 2008-05-27 | L | Futures | 93.378 | 93.393 | 93.358 | 93.373 | 40388.0 |
| 2008-05-27 | LE | Futures | 201.159 | 203.197 | 200.264 | 201.855 | 5960.0 |
| 2008-05-27 | MP | Futures | 0.04571 | 0.04585 | 0.04569 | 0.04579 | 9324.0 |
| 2008-05-27 | N6 | Futures | 0.5947 | 0.59971 | 0.59273 | 0.59789 | 1950.0 |
> showing 50 of 81 rows — these rows as CSV