PREVIEW / futures_daily / 2011-05-19
file: by_date/futures_daily/2011/2011-05-19.parquet size: 9 KB rows: 94
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-19 | ES | Futures | 1324.88 | 1332.06 | 1321.17 | 1328.35 | 1825276.0 |
| 2011-05-19 | NQ | Futures | 2690.05 | 2702.86 | 2680.37 | 2698.02 | 228801.0 |
| 2011-05-19 | YM | Futures | 11783.2 | 11861.3 | 11756.9 | 11837.8 | 101769.0 |
| 2011-05-19 | CL | Futures | 192.55 | 194.49 | 189.48 | 190.06 | 311515.0 |
| 2011-05-19 | GC | Futures | 2024.2 | 2029.7 | 2011.0 | 2020.0 | 162309.0 |
| 2011-05-19 | ZN | Futures | 103.186175 | 103.357362 | 102.77796 | 103.331025 | 1633918.0 |
| 2011-05-19 | A6 | Futures | 0.90896 | 0.91342 | 0.90588 | 0.91162 | 104734.0 |
| 2011-05-19 | AD | Futures | 1.026 | 1.03097 | 1.0243 | 1.02679 | 77163.0 |
| 2011-05-19 | B | Futures | 95.47 | 95.93 | 94.34 | 94.56 | 155870.0 |
| 2011-05-19 | B6 | Futures | 1.6789 | 1.6868 | 1.6751 | 1.6839 | 122755.0 |
| 2011-05-19 | BFX | Futures | 3198.4 | 3222.0 | 3182.6 | 3200.7 | 1104.0 |
| 2011-05-19 | BR | Futures | 0.27177 | 0.27177 | 0.27005 | 0.27005 | 12.0 |
| 2011-05-19 | BZ | Futures | 100.25 | 100.95 | 99.64 | 99.64 | 246.0 |
| 2011-05-19 | C | Futures | 2023.0 | 2039.0 | 2013.0 | 2028.0 | 3999.0 |
| 2011-05-19 | CC | Futures | 2381.0 | 2386.0 | 2365.0 | 2371.0 | 15615.0 |
| 2011-05-19 | CT | Futures | 158.01 | 159.67 | 152.29 | 154.06 | 7123.0 |
| 2011-05-19 | DC | Futures | 30.03 | 30.64 | 30.02 | 30.48 | 612.0 |
| 2011-05-19 | DX | Futures | 75.108 | 75.332 | 74.81 | 74.901 | 41029.0 |
| 2011-05-19 | E1 | Futures | 1.48564 | 1.49389 | 1.47464 | 1.48551 | 45086.0 |
| 2011-05-19 | E6 | Futures | 1.68719 | 1.69608 | 1.68174 | 1.69418 | 346643.0 |
| 2011-05-19 | E7 | Futures | 1.6742 | 1.6833 | 1.6692 | 1.6816 | 7226.0 |
| 2011-05-19 | ED | Futures | 94.9502 | 94.9573 | 94.943 | 94.9549 | 280623.0 |
| 2011-05-19 | ER | Futures | 97.267 | 97.277 | 97.257 | 97.257 | 148536.0 |
| 2011-05-19 | EW | Futures | 986.1 | 992.6 | 980.3 | 988.0 | 29374.0 |
| 2011-05-19 | FBTP | Futures | 65.22 | 65.22 | 64.86 | 65.03 | 5507.0 |
| 2011-05-19 | FCE | Futures | 2732.2 | 2772.1 | 2721.8 | 2755.1 | 116609.0 |
| 2011-05-19 | FDAX | Futures | 7843.2 | 7932.9 | 7817.6 | 7852.3 | 156016.0 |
| 2011-05-19 | FESX | Futures | 1831.8 | 1851.0 | 1821.6 | 1835.6 | 1403082.0 |
| 2011-05-19 | FEU3 | Futures | 97.81 | 97.815 | 97.8 | 97.8 | 167.0 |
| 2011-05-19 | FGBL | Futures | 99.26 | 99.4 | 99.0 | 99.32 | 1015497.0 |
| 2011-05-19 | FGBM | Futures | 103.68 | 103.78 | 103.54 | 103.75 | 664215.0 |
| 2011-05-19 | FGBS | Futures | 106.444 | 106.498 | 106.375 | 106.459 | 694821.0 |
| 2011-05-19 | FGBX | Futures | 95.68 | 96.13 | 95.38 | 95.9 | 2424.0 |
| 2011-05-19 | FTDX | Futures | 826.1 | 826.1 | 819.0 | 821.7 | 232.0 |
| 2011-05-19 | FTI | Futures | 287.83 | 289.02 | 285.78 | 287.79 | 28987.0 |
| 2011-05-19 | FTUK | Futures | 4164.1 | 4193.8 | 4145.5 | 4164.1 | 112767.0 |
| 2011-05-19 | FXXP | Futures | 186.1 | 187.3 | 185.4 | 186.5 | 1108.0 |
| 2011-05-19 | G | Futures | 83.53 | 83.65 | 83.33 | 83.59 | 144199.0 |
| 2011-05-19 | GF | Futures | 298.231 | 298.521 | 293.641 | 294.338 | 4256.0 |
| 2011-05-19 | GSCI | Futures | 1083.45 | 1084.31 | 1067.48 | 1069.52 | 135.0 |
| 2011-05-19 | HE | Futures | 96.734 | 97.476 | 95.834 | 96.708 | 20883.0 |
| 2011-05-19 | HG | Futures | 5.4418 | 5.473 | 5.3601 | 5.384 | 32120.0 |
| 2011-05-19 | HO | Futures | 2.386 | 2.3968 | 2.3762 | 2.3798 | 3849.0 |
| 2011-05-19 | HRC | Futures | 3077.0 | 3077.0 | 3077.0 | 3077.0 | 0.0 |
| 2011-05-19 | J1 | Futures | 0.0153847 | 0.0154237 | 0.015278 | 0.0153986 | 119030.0 |
| 2011-05-19 | J7 | Futures | 0.015277 | 0.01533 | 0.015186 | 0.015304 | 315.0 |
| 2011-05-19 | JB | Futures | 122.48 | 122.51 | 122.33 | 122.41 | 1232.0 |
| 2011-05-19 | KC | Futures | 648.41 | 651.05 | 629.35 | 632.35 | 13607.0 |
| 2011-05-19 | KE | Futures | 3704.79 | 3783.78 | 3686.03 | 3731.45 | 12471.0 |
| 2011-05-19 | KRW | Futures | 0.0008998 | 0.0008998 | 0.0008998 | 0.0008998 | 2.0 |
> showing 50 of 94 rows — these rows as CSV