PREVIEW / futures_daily / 2011-05-18
file: by_date/futures_daily/2011/2011-05-18.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 |
|---|---|---|---|---|---|---|---|
| 2011-05-18 | ES | Futures | 1313.0 | 1327.11 | 1311.27 | 1325.13 | 1612220.0 |
| 2011-05-18 | NQ | Futures | 2666.42 | 2693.47 | 2657.59 | 2689.48 | 232300.0 |
| 2011-05-18 | YM | Futures | 11696.7 | 11802.0 | 11678.9 | 11782.3 | 87861.0 |
| 2011-05-18 | CL | Futures | 188.61 | 194.84 | 188.21 | 193.19 | 286251.0 |
| 2011-05-18 | GC | Futures | 2012.0 | 2029.9 | 2009.4 | 2024.6 | 145016.0 |
| 2011-05-18 | ZN | Futures | 103.620726 | 103.805081 | 103.14667 | 103.265184 | 1333625.0 |
| 2011-05-18 | A6 | Futures | 0.90776 | 0.91171 | 0.90339 | 0.90716 | 103063.0 |
| 2011-05-18 | AD | Futures | 1.0239 | 1.0262 | 1.01952 | 1.02311 | 70242.0 |
| 2011-05-18 | B | Futures | 93.83 | 95.98 | 93.71 | 95.3 | 174649.0 |
| 2011-05-18 | B6 | Futures | 1.687 | 1.6915 | 1.6725 | 1.6765 | 161431.0 |
| 2011-05-18 | BFX | Futures | 3200.0 | 3200.0 | 3182.7 | 3187.3 | 2052.0 |
| 2011-05-18 | BR | Futures | 0.27067 | 0.27278 | 0.27067 | 0.27214 | 73.0 |
| 2011-05-18 | BZ | Futures | 99.91 | 101.08 | 99.31 | 100.42 | 287.0 |
| 2011-05-18 | C | Futures | 2026.0 | 2037.0 | 2016.0 | 2028.0 | 5673.0 |
| 2011-05-18 | CC | Futures | 2375.0 | 2407.0 | 2369.0 | 2384.0 | 6025.0 |
| 2011-05-18 | CT | Futures | 154.35 | 159.15 | 153.71 | 158.22 | 8480.0 |
| 2011-05-18 | DC | Futures | 29.86 | 30.12 | 29.71 | 30.07 | 247.0 |
| 2011-05-18 | DX | Futures | 75.039 | 75.357 | 74.855 | 75.255 | 31693.0 |
| 2011-05-18 | E1 | Futures | 1.48773 | 1.49088 | 1.48066 | 1.4859 | 40704.0 |
| 2011-05-18 | E6 | Futures | 1.68494 | 1.69134 | 1.68032 | 1.68388 | 288025.0 |
| 2011-05-18 | E7 | Futures | 1.6729 | 1.6786 | 1.6679 | 1.6713 | 5753.0 |
| 2011-05-18 | ED | Futures | 94.9597 | 94.9621 | 94.9454 | 94.9502 | 220622.0 |
| 2011-05-18 | ER | Futures | 97.286 | 97.286 | 97.262 | 97.272 | 109194.0 |
| 2011-05-18 | EW | Futures | 971.3 | 987.0 | 970.4 | 986.0 | 23108.0 |
| 2011-05-18 | FBTP | Futures | 65.22 | 65.22 | 64.97 | 65.13 | 3895.0 |
| 2011-05-18 | FCE | Futures | 2722.1 | 2737.4 | 2706.5 | 2720.4 | 141607.0 |
| 2011-05-18 | FDAX | Futures | 7827.2 | 7848.6 | 7761.0 | 7809.1 | 128740.0 |
| 2011-05-18 | FESX | Futures | 1829.9 | 1834.4 | 1812.6 | 1823.5 | 1078780.0 |
| 2011-05-18 | FEU3 | Futures | 97.82 | 97.82 | 97.805 | 97.815 | 319.0 |
| 2011-05-18 | FGBL | Futures | 99.43 | 99.62 | 99.26 | 99.47 | 865098.0 |
| 2011-05-18 | FGBM | Futures | 103.78 | 103.94 | 103.69 | 103.84 | 693319.0 |
| 2011-05-18 | FGBS | Futures | 106.474 | 106.533 | 106.459 | 106.503 | 519228.0 |
| 2011-05-18 | FGBX | Futures | 96.39 | 96.45 | 95.92 | 96.19 | 3244.0 |
| 2011-05-18 | FTDX | Futures | 823.4 | 824.8 | 818.1 | 820.8 | 209.0 |
| 2011-05-18 | FTI | Futures | 287.22 | 287.59 | 284.39 | 286.36 | 37881.0 |
| 2011-05-18 | FTUK | Futures | 4123.1 | 4163.4 | 4110.9 | 4139.2 | 87793.0 |
| 2011-05-18 | FXXP | Futures | 185.9 | 185.9 | 184.5 | 185.3 | 264.0 |
| 2011-05-18 | G | Futures | 83.68 | 83.91 | 83.6 | 83.72 | 110910.0 |
| 2011-05-18 | GF | Futures | 302.704 | 302.82 | 297.475 | 297.475 | 3765.0 |
| 2011-05-18 | GSCI | Futures | 1064.51 | 1087.99 | 1062.55 | 1081.73 | 290.0 |
| 2011-05-18 | HE | Futures | 98.561 | 98.746 | 96.549 | 97.052 | 24291.0 |
| 2011-05-18 | HG | Futures | 5.3621 | 5.479 | 5.3448 | 5.4537 | 38343.0 |
| 2011-05-18 | HO | Futures | 2.3641 | 2.4016 | 2.3641 | 2.3894 | 9012.0 |
| 2011-05-18 | HRC | Futures | 3077.0 | 3077.0 | 3077.0 | 3077.0 | 0.0 |
| 2011-05-18 | J1 | Futures | 0.0154337 | 0.0155242 | 0.0153722 | 0.0153998 | 111753.0 |
| 2011-05-18 | J7 | Futures | 0.015352 | 0.015427 | 0.015282 | 0.015306 | 563.0 |
| 2011-05-18 | JB | Futures | 122.31 | 122.48 | 122.3 | 122.46 | 1541.0 |
| 2011-05-18 | KC | Futures | 643.02 | 659.33 | 641.94 | 647.58 | 10268.0 |
| 2011-05-18 | KE | Futures | 3541.87 | 3740.34 | 3534.95 | 3704.79 | 16716.0 |
| 2011-05-18 | L | Futures | 98.433 | 98.443 | 98.423 | 98.423 | 48572.0 |
> showing 50 of 91 rows — these rows as CSV