PREVIEW / futures_daily / 2010-01-21
file: by_date/futures_daily/2010/2010-01-21.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-21 | ES | Futures | 1099.72 | 1104.33 | 1076.22 | 1076.94 | 3438955.0 |
| 2010-01-21 | NQ | Futures | 2112.51 | 2130.33 | 2079.71 | 2082.26 | 501308.0 |
| 2010-01-21 | YM | Futures | 9642.2 | 9674.2 | 9433.1 | 9443.1 | 208152.0 |
| 2010-01-21 | CL | Futures | 183.2 | 185.09 | 178.71 | 179.7 | 327417.0 |
| 2010-01-21 | GC | Futures | 1531.1 | 1538.0 | 1497.5 | 1518.5 | 271810.0 |
| 2010-01-21 | ZN | Futures | 94.6304 | 95.058592 | 94.441492 | 94.957841 | 1190895.0 |
| 2010-01-21 | A6 | Futures | 0.73623 | 0.73916 | 0.72705 | 0.73071 | 143145.0 |
| 2010-01-21 | AD | Futures | 0.94401 | 0.94569 | 0.93789 | 0.93977 | 91003.0 |
| 2010-01-21 | B | Futures | 68.98 | 69.66 | 67.32 | 67.63 | 169228.0 |
| 2010-01-21 | B6 | Futures | 1.6916 | 1.6936 | 1.674 | 1.6829 | 152647.0 |
| 2010-01-21 | BFX | Futures | 2852.9 | 2869.1 | 2801.0 | 2804.2 | 413.0 |
| 2010-01-21 | BR | Futures | 0.22256 | 0.22256 | 0.22256 | 0.22256 | 13.0 |
| 2010-01-21 | BZ | Futures | 70.24 | 70.24 | 69.2 | 69.47 | 1.0 |
| 2010-01-21 | C | Futures | 2347.0 | 2384.0 | 2345.0 | 2361.0 | 6255.0 |
| 2010-01-21 | CB | Futures | 73.531 | 73.531 | 73.531 | 73.531 | 1.0 |
| 2010-01-21 | CC | Futures | 2933.0 | 2994.0 | 2931.0 | 2948.0 | 6420.0 |
| 2010-01-21 | CT | Futures | 57.89 | 58.76 | 57.74 | 58.58 | 8196.0 |
| 2010-01-21 | DC | Futures | 23.78 | 23.87 | 23.24 | 23.42 | 346.0 |
| 2010-01-21 | DX | Futures | 79.825 | 80.339 | 79.627 | 79.845 | 29670.0 |
| 2010-01-21 | E1 | Futures | 1.26401 | 1.26796 | 1.25662 | 1.26638 | 60850.0 |
| 2010-01-21 | E6 | Futures | 1.67007 | 1.67421 | 1.6606 | 1.66959 | 366647.0 |
| 2010-01-21 | E7 | Futures | 1.6582 | 1.6623 | 1.6492 | 1.658 | 4651.0 |
| 2010-01-21 | EBM | Futures | 213.35 | 215.89 | 213.35 | 215.47 | 6020.0 |
| 2010-01-21 | ED | Futures | 94.3867 | 94.3867 | 94.3725 | 94.382 | 128581.0 |
| 2010-01-21 | ER | Futures | 97.321 | 97.33 | 97.316 | 97.321 | 130107.0 |
| 2010-01-21 | EW | Futures | 724.6 | 728.4 | 712.6 | 713.6 | 44780.0 |
| 2010-01-21 | FBTP | Futures | 63.17 | 63.31 | 63.0 | 63.21 | 8617.0 |
| 2010-01-21 | FCE | Futures | 2586.6 | 2586.6 | 2488.2 | 2515.9 | 160859.0 |
| 2010-01-21 | FDAX | Futures | 6451.4 | 6460.2 | 6215.0 | 6279.9 | 242266.0 |
| 2010-01-21 | FESX | Futures | 1761.6 | 1764.0 | 1690.4 | 1712.5 | 2169372.0 |
| 2010-01-21 | FEU3 | Futures | 97.884 | 97.889 | 97.884 | 97.884 | 423.0 |
| 2010-01-21 | FGBL | Futures | 94.74 | 95.1 | 94.55 | 94.96 | 1005314.0 |
| 2010-01-21 | FGBM | Futures | 100.44 | 100.75 | 100.35 | 100.62 | 635514.0 |
| 2010-01-21 | FGBS | Futures | 105.591 | 105.703 | 105.572 | 105.654 | 723393.0 |
| 2010-01-21 | FGBX | Futures | 88.24 | 88.64 | 87.76 | 88.35 | 2929.0 |
| 2010-01-21 | FTDX | Futures | 730.5 | 738.0 | 718.6 | 724.8 | 733.0 |
| 2010-01-21 | FTI | Futures | 275.05 | 275.38 | 266.52 | 269.12 | 51761.0 |
| 2010-01-21 | FTUK | Futures | 3626.1 | 3634.8 | 3513.3 | 3546.4 | 157973.0 |
| 2010-01-21 | G | Futures | 75.17 | 75.95 | 75.13 | 75.76 | 145192.0 |
| 2010-01-21 | GF | Futures | 269.241 | 269.241 | 266.945 | 268.431 | 2643.0 |
| 2010-01-21 | GSCI | Futures | 965.23 | 968.41 | 946.73 | 951.03 | 341.0 |
| 2010-01-21 | HE | Futures | 98.318 | 99.021 | 96.077 | 97.214 | 17342.0 |
| 2010-01-21 | HG | Futures | 4.6325 | 4.6994 | 4.527 | 4.5456 | 37495.0 |
| 2010-01-21 | HO | Futures | 1.8947 | 1.9051 | 1.8521 | 1.8595 | 49102.0 |
| 2010-01-21 | J1 | Futures | 0.013795 | 0.0139686 | 0.0136993 | 0.0139246 | 182542.0 |
| 2010-01-21 | J7 | Futures | 0.013625 | 0.01379 | 0.013531 | 0.01375 | 165.0 |
| 2010-01-21 | JB | Futures | 117.51 | 117.64 | 117.27 | 117.34 | 1258.0 |
| 2010-01-21 | KC | Futures | 362.98 | 364.8 | 358.03 | 361.03 | 8594.0 |
| 2010-01-21 | KE | Futures | 2280.44 | 2283.83 | 2249.91 | 2277.04 | 8694.0 |
| 2010-01-21 | KRW | Futures | 0.0008545 | 0.0008545 | 0.000853 | 0.0008545 | 40.0 |
> showing 50 of 91 rows — these rows as CSV