PREVIEW / futures_daily / 2010-06-09
file: by_date/futures_daily/2010/2010-06-09.parquet size: 8 KB rows: 87
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-06-09 | ES | Futures | 1031.24 | 1049.5 | 1023.69 | 1027.83 | 2970468.0 |
| 2010-06-09 | NQ | Futures | 2032.62 | 2068.64 | 2012.2 | 2021.84 | 361910.0 |
| 2010-06-09 | YM | Futures | 9119.1 | 9246.0 | 9061.2 | 9103.5 | 181974.0 |
| 2010-06-09 | CL | Futures | 158.67 | 164.03 | 157.62 | 162.76 | 436981.0 |
| 2010-06-09 | GC | Futures | 1687.5 | 1695.0 | 1668.4 | 1677.7 | 125493.0 |
| 2010-06-09 | ZN | Futures | 99.056482 | 99.184545 | 98.723519 | 99.056482 | 1039327.0 |
| 2010-06-09 | A6 | Futures | 0.67825 | 0.68547 | 0.67209 | 0.67858 | 97223.0 |
| 2010-06-09 | AD | Futures | 0.94214 | 0.95241 | 0.93849 | 0.9452 | 84497.0 |
| 2010-06-09 | B | Futures | 64.23 | 66.18 | 63.81 | 65.77 | 113840.0 |
| 2010-06-09 | B6 | Futures | 1.5007 | 1.5167 | 1.4944 | 1.5083 | 117941.0 |
| 2010-06-09 | BFX | Futures | 2745.6 | 2768.7 | 2730.5 | 2768.7 | 93.0 |
| 2010-06-09 | BZ | Futures | 70.93 | 70.93 | 70.93 | 70.93 | 14.0 |
| 2010-06-09 | C | Futures | 2568.0 | 2591.0 | 2524.0 | 2543.0 | 3832.0 |
| 2010-06-09 | CB | Futures | 80.88 | 80.88 | 80.88 | 80.88 | 1.0 |
| 2010-06-09 | CC | Futures | 2479.0 | 2510.0 | 2470.0 | 2495.0 | 9263.0 |
| 2010-06-09 | CT | Futures | 62.36 | 64.63 | 62.33 | 64.63 | 16015.0 |
| 2010-06-09 | DC | Futures | 22.08 | 22.17 | 21.99 | 22.14 | 108.0 |
| 2010-06-09 | DX | Futures | 89.363 | 89.606 | 88.613 | 89.11 | 32771.0 |
| 2010-06-09 | E1 | Futures | 1.14101 | 1.15311 | 1.13916 | 1.14614 | 41705.0 |
| 2010-06-09 | E6 | Futures | 1.41533 | 1.42834 | 1.41059 | 1.41781 | 341633.0 |
| 2010-06-09 | E7 | Futures | 1.404 | 1.4165 | 1.399 | 1.4062 | 5227.0 |
| 2010-06-09 | ED | Futures | 94.2263 | 94.2357 | 94.2263 | 94.2334 | 148138.0 |
| 2010-06-09 | ER | Futures | 97.37 | 97.375 | 97.37 | 97.37 | 31398.0 |
| 2010-06-09 | EW | Futures | 704.2 | 724.3 | 699.5 | 709.3 | 39595.0 |
| 2010-06-09 | FBTP | Futures | 63.45 | 64.29 | 63.43 | 64.1 | 5703.0 |
| 2010-06-09 | FCE | Futures | 2251.5 | 2282.7 | 2225.0 | 2281.0 | 141877.0 |
| 2010-06-09 | FDAX | Futures | 6405.5 | 6520.8 | 6344.6 | 6517.6 | 195705.0 |
| 2010-06-09 | FESX | Futures | 1541.4 | 1565.9 | 1524.3 | 1562.8 | 1958594.0 |
| 2010-06-09 | FEU3 | Futures | 97.924 | 97.929 | 97.924 | 97.929 | 1130.0 |
| 2010-06-09 | FGBL | Futures | 101.23 | 101.31 | 100.81 | 100.91 | 836065.0 |
| 2010-06-09 | FGBM | Futures | 105.59 | 105.62 | 105.37 | 105.42 | 449422.0 |
| 2010-06-09 | FGBS | Futures | 107.77 | 107.775 | 107.701 | 107.731 | 449693.0 |
| 2010-06-09 | FGBX | Futures | 100.78 | 101.54 | 100.35 | 100.62 | 2825.0 |
| 2010-06-09 | FTDX | Futures | 641.2 | 654.5 | 640.3 | 654.5 | 409.0 |
| 2010-06-09 | FTI | Futures | 248.85 | 252.71 | 246.73 | 252.35 | 44568.0 |
| 2010-06-09 | FTUK | Futures | 3422.2 | 3446.6 | 3363.3 | 3440.1 | 145900.0 |
| 2010-06-09 | G | Futures | 80.24 | 80.29 | 79.91 | 80.0 | 105967.0 |
| 2010-06-09 | GF | Futures | 275.035 | 277.561 | 275.035 | 275.919 | 1766.0 |
| 2010-06-09 | GSCI | Futures | 839.17 | 850.04 | 839.17 | 845.25 | 3575.0 |
| 2010-06-09 | HE | Futures | 97.912 | 99.351 | 97.724 | 98.194 | 21016.0 |
| 2010-06-09 | HG | Futures | 3.8022 | 3.9095 | 3.7418 | 3.8701 | 40822.0 |
| 2010-06-09 | HO | Futures | 1.7594 | 1.8088 | 1.7592 | 1.7995 | 13871.0 |
| 2010-06-09 | J1 | Futures | 0.0137348 | 0.013809 | 0.0137159 | 0.0137989 | 121911.0 |
| 2010-06-09 | J7 | Futures | 0.01365 | 0.013696 | 0.013608 | 0.013689 | 472.0 |
| 2010-06-09 | KC | Futures | 340.2 | 341.85 | 338.29 | 341.34 | 15858.0 |
| 2010-06-09 | KE | Futures | 2006.35 | 2020.48 | 1983.53 | 1991.14 | 14336.0 |
| 2010-06-09 | L | Futures | 97.987 | 98.017 | 97.977 | 98.007 | 37565.0 |
| 2010-06-09 | LBS | Futures | 666.0 | 666.0 | 637.6 | 637.6 | 1068.0 |
| 2010-06-09 | LE | Futures | 142.915 | 144.665 | 142.224 | 142.346 | 17942.0 |
| 2010-06-09 | MFS | Futures | 1059.5 | 1071.4 | 1044.3 | 1048.8 | 1444.0 |
> showing 50 of 87 rows — these rows as CSV