PREVIEW / futures_daily / 2009-07-17
file: by_date/futures_daily/2009/2009-07-17.parquet size: 8 KB rows: 86
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 |
|---|---|---|---|---|---|---|---|
| 2009-07-17 | ES | Futures | 897.32 | 900.67 | 890.36 | 899.0 | 1525903.0 |
| 2009-07-17 | NQ | Futures | 1703.04 | 1721.9 | 1694.59 | 1720.78 | 229769.0 |
| 2009-07-17 | YM | Futures | 7818.9 | 7856.8 | 7769.3 | 7846.9 | 102843.0 |
| 2009-07-17 | CL | Futures | 162.46 | 167.35 | 159.86 | 166.27 | 191848.0 |
| 2009-07-17 | GC | Futures | 1298.4 | 1301.1 | 1289.8 | 1297.9 | 62043.0 |
| 2009-07-17 | ZN | Futures | 92.098595 | 92.406411 | 91.618402 | 91.716903 | 715295.0 |
| 2009-07-17 | A6 | Futures | 0.64443 | 0.64443 | 0.63768 | 0.64298 | 47908.0 |
| 2009-07-17 | AD | Futures | 0.8839 | 0.88786 | 0.88213 | 0.88529 | 50841.0 |
| 2009-07-17 | B | Futures | 60.74 | 62.76 | 59.79 | 62.24 | 117528.0 |
| 2009-07-17 | B6 | Futures | 1.7122 | 1.7124 | 1.6939 | 1.7059 | 77339.0 |
| 2009-07-17 | BFX | Futures | 2385.3 | 2388.3 | 2366.5 | 2369.0 | 306.0 |
| 2009-07-17 | BR | Futures | 0.20044 | 0.20044 | 0.20044 | 0.20044 | 10.0 |
| 2009-07-17 | BZ | Futures | 65.09 | 66.41 | 65.09 | 66.41 | 2.0 |
| 2009-07-17 | C | Futures | 1825.0 | 1872.0 | 1825.0 | 1872.0 | 17481.0 |
| 2009-07-17 | CB | Futures | 75.031 | 75.671 | 74.463 | 75.33 | 8.0 |
| 2009-07-17 | CC | Futures | 2375.0 | 2478.0 | 2366.0 | 2457.0 | 7108.0 |
| 2009-07-17 | CT | Futures | 54.31 | 55.05 | 54.14 | 54.93 | 73.0 |
| 2009-07-17 | DC | Futures | 20.7 | 21.17 | 20.45 | 20.72 | 237.0 |
| 2009-07-17 | DX | Futures | 81.335 | 81.694 | 81.279 | 81.376 | 3052.0 |
| 2009-07-17 | E1 | Futures | 1.2343 | 1.23444 | 1.22424 | 1.23271 | 27148.0 |
| 2009-07-17 | E6 | Futures | 1.67903 | 1.67963 | 1.66954 | 1.67856 | 150003.0 |
| 2009-07-17 | E7 | Futures | 1.6616 | 1.6622 | 1.6525 | 1.6613 | 1630.0 |
| 2009-07-17 | ED | Futures | 93.8999 | 93.9236 | 93.8999 | 93.9188 | 126572.0 |
| 2009-07-17 | ER | Futures | 97.081 | 97.086 | 97.071 | 97.076 | 75305.0 |
| 2009-07-17 | EW | Futures | 568.7 | 570.3 | 564.4 | 568.9 | 24617.0 |
| 2009-07-17 | FCE | Futures | 2110.7 | 2121.9 | 2101.9 | 2110.4 | 109074.0 |
| 2009-07-17 | FDAX | Futures | 5496.3 | 5511.6 | 5442.0 | 5472.7 | 114882.0 |
| 2009-07-17 | FESX | Futures | 1480.9 | 1483.9 | 1463.6 | 1474.4 | 902100.0 |
| 2009-07-17 | FEU3 | Futures | 97.658 | 97.658 | 97.653 | 97.653 | 970.0 |
| 2009-07-17 | FGBL | Futures | 92.49 | 92.58 | 91.83 | 92.08 | 644456.0 |
| 2009-07-17 | FGBM | Futures | 98.31 | 98.41 | 97.98 | 98.1 | 293197.0 |
| 2009-07-17 | FGBS | Futures | 104.196 | 104.248 | 104.138 | 104.181 | 272302.0 |
| 2009-07-17 | FGBX | Futures | 84.69 | 84.8 | 83.31 | 83.76 | 939.0 |
| 2009-07-17 | FTDX | Futures | 575.5 | 588.0 | 573.7 | 574.6 | 892.0 |
| 2009-07-17 | FTI | Futures | 216.26 | 218.97 | 216.22 | 217.78 | 31153.0 |
| 2009-07-17 | FTUK | Futures | 2895.2 | 2906.9 | 2876.7 | 2895.2 | 92466.0 |
| 2009-07-17 | G | Futures | 75.42 | 75.55 | 74.87 | 75.13 | 61768.0 |
| 2009-07-17 | GF | Futures | 286.655 | 288.585 | 285.691 | 288.309 | 984.0 |
| 2009-07-17 | GSCI | Futures | 885.67 | 904.05 | 870.0 | 901.54 | 436.0 |
| 2009-07-17 | HE | Futures | 93.888 | 94.356 | 92.196 | 93.096 | 8660.0 |
| 2009-07-17 | HG | Futures | 3.353 | 3.4246 | 3.3236 | 3.4022 | 15770.0 |
| 2009-07-17 | HO | Futures | 1.6545 | 1.7131 | 1.6289 | 1.696 | 21709.0 |
| 2009-07-17 | HRC | Futures | 2409.0 | 2409.0 | 2409.0 | 2409.0 | 0.0 |
| 2009-07-17 | J1 | Futures | 0.0134314 | 0.0134754 | 0.0133458 | 0.0133634 | 70164.0 |
| 2009-07-17 | J7 | Futures | 0.013235 | 0.013281 | 0.013169 | 0.013179 | 48.0 |
| 2009-07-17 | JB | Futures | 116.73 | 116.83 | 116.67 | 116.71 | 1628.0 |
| 2009-07-17 | KC | Futures | 314.75 | 322.9 | 314.21 | 322.08 | 6356.0 |
| 2009-07-17 | KE | Futures | 2688.36 | 2753.11 | 2657.18 | 2717.13 | 8014.0 |
| 2009-07-17 | L | Futures | 97.308 | 97.367 | 97.298 | 97.337 | 41818.0 |
| 2009-07-17 | LBS | Futures | 756.7 | 772.9 | 737.6 | 751.8 | 893.0 |
> showing 50 of 86 rows — these rows as CSV