PREVIEW / futures_daily / 2010-03-12
file: by_date/futures_daily/2010/2010-03-12.parquet size: 9 KB rows: 90
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-03-12 | ES | Futures | 1115.47 | 1123.96 | 1111.6 | 1115.96 | 826747.0 |
| 2010-03-12 | NQ | Futures | 2178.4 | 2188.86 | 2167.65 | 2179.25 | 75098.0 |
| 2010-03-12 | YM | Futures | 9692.8 | 9738.7 | 9681.7 | 9719.4 | 95422.0 |
| 2010-03-12 | CL | Futures | 192.96 | 195.22 | 189.14 | 190.71 | 337201.0 |
| 2010-03-12 | GC | Futures | 1523.0 | 1536.0 | 1505.5 | 1511.6 | 159858.0 |
| 2010-03-12 | ZN | Futures | 95.256899 | 95.524725 | 94.899797 | 95.333421 | 1033104.0 |
| 2010-03-12 | A6 | Futures | 0.74299 | 0.74693 | 0.74233 | 0.74397 | 81189.0 |
| 2010-03-12 | AD | Futures | 0.96406 | 0.97215 | 0.96317 | 0.97008 | 92025.0 |
| 2010-03-12 | B | Futures | 72.4 | 73.2 | 70.95 | 71.56 | 137821.0 |
| 2010-03-12 | B6 | Futures | 1.563 | 1.5817 | 1.5591 | 1.5742 | 110945.0 |
| 2010-03-12 | BFX | Futures | 2960.8 | 2960.8 | 2959.2 | 2959.2 | 31.0 |
| 2010-03-12 | BR | Futures | 0.2284 | 0.22885 | 0.2284 | 0.2284 | 245.0 |
| 2010-03-12 | BZ | Futures | 75.75 | 75.75 | 74.62 | 75.25 | 11.0 |
| 2010-03-12 | C | Futures | 2200.0 | 2244.0 | 2189.0 | 2241.0 | 9620.0 |
| 2010-03-12 | CB | Futures | 74.024 | 74.024 | 74.024 | 74.024 | 10.0 |
| 2010-03-12 | CC | Futures | 2414.0 | 2479.0 | 2385.0 | 2472.0 | 8600.0 |
| 2010-03-12 | CT | Futures | 64.06 | 65.68 | 64.05 | 65.44 | 8084.0 |
| 2010-03-12 | DC | Futures | 22.77 | 22.9 | 22.66 | 22.82 | 89.0 |
| 2010-03-12 | DX | Futures | 81.616 | 81.677 | 81.013 | 81.145 | 47272.0 |
| 2010-03-12 | E1 | Futures | 1.23248 | 1.24604 | 1.2313 | 1.24341 | 57401.0 |
| 2010-03-12 | E6 | Futures | 1.61762 | 1.63205 | 1.61691 | 1.62743 | 290812.0 |
| 2010-03-12 | E7 | Futures | 1.6048 | 1.6188 | 1.6037 | 1.6141 | 3467.0 |
| 2010-03-12 | EBM | Futures | 199.47 | 200.7 | 199.47 | 199.88 | 3346.0 |
| 2010-03-12 | ED | Futures | 94.3802 | 94.3897 | 94.3613 | 94.3802 | 257563.0 |
| 2010-03-12 | ER | Futures | 97.34 | 97.345 | 97.326 | 97.34 | 180577.0 |
| 2010-03-12 | EW | Futures | 758.9 | 762.9 | 755.4 | 762.6 | 33883.0 |
| 2010-03-12 | FBTP | Futures | 64.11 | 64.25 | 64.05 | 64.22 | 5008.0 |
| 2010-03-12 | FCE | Futures | 2522.7 | 2532.0 | 2508.3 | 2513.7 | 3919.0 |
| 2010-03-12 | FDAX | Futures | 6494.6 | 6544.3 | 6482.0 | 6495.1 | 135214.0 |
| 2010-03-12 | FESX | Futures | 1736.1 | 1745.3 | 1726.3 | 1730.6 | 139992.0 |
| 2010-03-12 | FEU3 | Futures | 97.899 | 97.899 | 97.889 | 97.899 | 170.0 |
| 2010-03-12 | FGBL | Futures | 95.52 | 95.74 | 95.26 | 95.65 | 824603.0 |
| 2010-03-12 | FGBM | Futures | 101.39 | 101.45 | 101.22 | 101.4 | 543998.0 |
| 2010-03-12 | FGBS | Futures | 106.17 | 106.18 | 106.106 | 106.155 | 457432.0 |
| 2010-03-12 | FGBX | Futures | 89.42 | 90.27 | 89.17 | 89.82 | 5088.0 |
| 2010-03-12 | FTDX | Futures | 745.1 | 745.1 | 734.9 | 736.3 | 514.0 |
| 2010-03-12 | FTI | Futures | 273.92 | 275.74 | 273.11 | 273.47 | 2370.0 |
| 2010-03-12 | FTUK | Futures | 3772.7 | 3785.9 | 3762.6 | 3774.4 | 88682.0 |
| 2010-03-12 | G | Futures | 75.59 | 75.96 | 75.49 | 75.87 | 77551.0 |
| 2010-03-12 | GF | Futures | 275.032 | 276.989 | 274.314 | 276.532 | 2082.0 |
| 2010-03-12 | GSCI | Futures | 977.16 | 979.56 | 959.5 | 965.39 | 696.0 |
| 2010-03-12 | HE | Futures | 96.344 | 98.184 | 96.311 | 97.214 | 13042.0 |
| 2010-03-12 | HG | Futures | 4.6316 | 4.6541 | 4.5885 | 4.6179 | 23204.0 |
| 2010-03-12 | HO | Futures | 1.9528 | 1.9732 | 1.9138 | 1.93 | 12574.0 |
| 2010-03-12 | HRC | Futures | 3037.7 | 3037.7 | 3037.7 | 3037.7 | 0.0 |
| 2010-03-12 | J1 | Futures | 0.0138819 | 0.013951 | 0.0138102 | 0.013897 | 115729.0 |
| 2010-03-12 | J7 | Futures | 0.013767 | 0.013836 | 0.0137 | 0.013786 | 108.0 |
| 2010-03-12 | JB | Futures | 118.24 | 118.28 | 117.91 | 118.0 | 3728.0 |
| 2010-03-12 | KC | Futures | 343.89 | 347.23 | 338.37 | 340.3 | 12990.0 |
| 2010-03-12 | KE | Futures | 2171.32 | 2199.02 | 2162.46 | 2192.37 | 4826.0 |
> showing 50 of 90 rows — these rows as CSV