PREVIEW / futures_daily / 2010-01-27
file: by_date/futures_daily/2010/2010-01-27.parquet size: 9 KB rows: 91
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 |
|---|---|---|---|---|---|---|---|
| 2010-01-27 | ES | Futures | 1054.16 | 1062.64 | 1045.44 | 1060.95 | 2634603.0 |
| 2010-01-27 | NQ | Futures | 2034.47 | 2060.2 | 2022.03 | 2046.07 | 443906.0 |
| 2010-01-27 | YM | Futures | 9262.3 | 9321.6 | 9184.6 | 9312.5 | 189543.0 |
| 2010-01-27 | CL | Futures | 176.42 | 177.36 | 171.6 | 174.01 | 356179.0 |
| 2010-01-27 | GC | Futures | 1501.7 | 1513.8 | 1487.4 | 1489.6 | 124936.0 |
| 2010-01-27 | ZN | Futures | 94.983029 | 95.335657 | 94.756339 | 94.831902 | 1068542.0 |
| 2010-01-27 | A6 | Futures | 0.7277 | 0.73144 | 0.72047 | 0.72372 | 124419.0 |
| 2010-01-27 | AD | Futures | 0.92871 | 0.93039 | 0.92348 | 0.92614 | 72065.0 |
| 2010-01-27 | B | Futures | 66.11 | 66.58 | 64.53 | 65.38 | 63667.0 |
| 2010-01-27 | B6 | Futures | 1.6766 | 1.6867 | 1.6723 | 1.6793 | 127323.0 |
| 2010-01-27 | BFX | Futures | 2798.7 | 2825.6 | 2787.0 | 2819.1 | 36.0 |
| 2010-01-27 | BR | Futures | 0.21587 | 0.21587 | 0.21587 | 0.21587 | 99.0 |
| 2010-01-27 | C | Futures | 2338.0 | 2345.0 | 2236.0 | 2279.0 | 15578.0 |
| 2010-01-27 | CB | Futures | 71.075 | 71.075 | 70.323 | 70.57 | 18.0 |
| 2010-01-27 | CC | Futures | 2884.0 | 2895.0 | 2725.0 | 2808.0 | 19512.0 |
| 2010-01-27 | CT | Futures | 57.08 | 57.3 | 56.28 | 56.44 | 11311.0 |
| 2010-01-27 | DC | Futures | 23.11 | 23.17 | 22.5 | 22.59 | 445.0 |
| 2010-01-27 | DX | Futures | 80.008 | 80.389 | 79.861 | 80.206 | 20803.0 |
| 2010-01-27 | E1 | Futures | 1.26098 | 1.26256 | 1.25306 | 1.25715 | 59416.0 |
| 2010-01-27 | E6 | Futures | 1.66675 | 1.66865 | 1.65633 | 1.66131 | 335848.0 |
| 2010-01-27 | E7 | Futures | 1.655 | 1.657 | 1.6448 | 1.6498 | 3666.0 |
| 2010-01-27 | EBM | Futures | 214.2 | 215.89 | 212.5 | 212.93 | 4633.0 |
| 2010-01-27 | ED | Futures | 94.3678 | 94.382 | 94.3678 | 94.3725 | 184309.0 |
| 2010-01-27 | ER | Futures | 97.311 | 97.326 | 97.306 | 97.316 | 134784.0 |
| 2010-01-27 | EW | Futures | 698.9 | 701.0 | 689.9 | 699.0 | 39845.0 |
| 2010-01-27 | FBTP | Futures | 63.56 | 63.61 | 63.18 | 63.26 | 6850.0 |
| 2010-01-27 | FCE | Futures | 2453.1 | 2474.2 | 2432.2 | 2448.5 | 141444.0 |
| 2010-01-27 | FDAX | Futures | 6137.4 | 6215.5 | 6106.8 | 6164.2 | 204734.0 |
| 2010-01-27 | FESX | Futures | 1674.2 | 1685.6 | 1656.3 | 1665.8 | 1612453.0 |
| 2010-01-27 | FEU3 | Futures | 97.879 | 97.879 | 97.874 | 97.879 | 143.0 |
| 2010-01-27 | FGBL | Futures | 95.07 | 95.31 | 94.82 | 95.13 | 1082891.0 |
| 2010-01-27 | FGBM | Futures | 100.7 | 100.85 | 100.5 | 100.71 | 550170.0 |
| 2010-01-27 | FGBS | Futures | 105.688 | 105.713 | 105.591 | 105.664 | 707594.0 |
| 2010-01-27 | FGBX | Futures | 88.91 | 89.32 | 88.71 | 89.21 | 3859.0 |
| 2010-01-27 | FTDX | Futures | 707.5 | 715.5 | 696.9 | 708.0 | 787.0 |
| 2010-01-27 | FTI | Futures | 264.49 | 267.41 | 263.35 | 265.22 | 37899.0 |
| 2010-01-27 | FTUK | Futures | 3476.1 | 3499.5 | 3448.3 | 3467.1 | 130961.0 |
| 2010-01-27 | G | Futures | 76.16 | 76.26 | 75.94 | 76.14 | 104698.0 |
| 2010-01-27 | GF | Futures | 267.351 | 268.364 | 264.987 | 266.135 | 1796.0 |
| 2010-01-27 | GSCI | Futures | 932.99 | 932.99 | 909.73 | 915.71 | 1013.0 |
| 2010-01-27 | HE | Futures | 91.895 | 92.832 | 91.393 | 92.263 | 13660.0 |
| 2010-01-27 | HG | Futures | 4.607 | 4.6311 | 4.3787 | 4.4456 | 41568.0 |
| 2010-01-27 | HO | Futures | 1.826 | 1.8386 | 1.7731 | 1.7936 | 58938.0 |
| 2010-01-27 | HRC | Futures | 2729.2 | 2729.2 | 2729.2 | 2729.2 | 0.0 |
| 2010-01-27 | J1 | Futures | 0.0140416 | 0.0141209 | 0.0139699 | 0.0139925 | 129425.0 |
| 2010-01-27 | J7 | Futures | 0.013861 | 0.013944 | 0.013797 | 0.013817 | 124.0 |
| 2010-01-27 | JB | Futures | 117.69 | 117.91 | 117.54 | 117.91 | 2256.0 |
| 2010-01-27 | KC | Futures | 359.2 | 361.81 | 347.1 | 347.62 | 23459.0 |
| 2010-01-27 | KE | Futures | 2252.17 | 2261.22 | 2217.12 | 2218.25 | 11742.0 |
| 2010-01-27 | KRW | Futures | 0.0008427 | 0.0008427 | 0.0008394 | 0.0008394 | 2.0 |
> showing 50 of 91 rows — these rows as CSV