PREVIEW / futures_daily / 2011-05-16
file: by_date/futures_daily/2011/2011-05-16.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-16 | ES | Futures | 1318.69 | 1327.85 | 1311.52 | 1312.26 | 2177046.0 |
| 2011-05-16 | NQ | Futures | 2694.6 | 2702.29 | 2652.75 | 2658.73 | 405609.0 |
| 2011-05-16 | YM | Futures | 11785.1 | 11855.6 | 11741.9 | 11760.7 | 112415.0 |
| 2011-05-16 | CL | Futures | 192.03 | 192.34 | 186.98 | 187.98 | 171276.0 |
| 2011-05-16 | GC | Futures | 2023.0 | 2036.1 | 2011.3 | 2017.5 | 127098.0 |
| 2011-05-16 | ZN | Futures | 103.37053 | 103.502212 | 103.159838 | 103.449539 | 792300.0 |
| 2011-05-16 | A6 | Futures | 0.90322 | 0.90965 | 0.89816 | 0.90553 | 113465.0 |
| 2011-05-16 | AD | Futures | 1.02639 | 1.02759 | 1.01843 | 1.02271 | 91697.0 |
| 2011-05-16 | B | Futures | 95.9 | 96.32 | 93.47 | 94.06 | 209420.0 |
| 2011-05-16 | B6 | Futures | 1.6798 | 1.6881 | 1.6782 | 1.6833 | 90672.0 |
| 2011-05-16 | BFX | Futures | 3210.4 | 3220.0 | 3210.2 | 3220.0 | 19.0 |
| 2011-05-16 | BR | Futures | 0.26754 | 0.26948 | 0.26754 | 0.26877 | 389.0 |
| 2011-05-16 | BZ | Futures | 99.89 | 101.05 | 98.58 | 99.12 | 462.0 |
| 2011-05-16 | C | Futures | 2032.0 | 2053.0 | 2025.0 | 2032.0 | 4550.0 |
| 2011-05-16 | CC | Futures | 2388.0 | 2417.0 | 2380.0 | 2393.0 | 5875.0 |
| 2011-05-16 | CT | Futures | 145.2 | 149.6 | 143.69 | 149.6 | 7817.0 |
| 2011-05-16 | DC | Futures | 29.12 | 29.34 | 29.12 | 29.31 | 142.0 |
| 2011-05-16 | DX | Futures | 75.7 | 75.81 | 75.034 | 75.273 | 36265.0 |
| 2011-05-16 | E1 | Futures | 1.46534 | 1.48813 | 1.46508 | 1.48263 | 37370.0 |
| 2011-05-16 | E6 | Futures | 1.6667 | 1.68624 | 1.66279 | 1.67961 | 313519.0 |
| 2011-05-16 | E7 | Futures | 1.6549 | 1.6736 | 1.6504 | 1.6671 | 6158.0 |
| 2011-05-16 | ED | Futures | 94.9597 | 94.9621 | 94.9549 | 94.9597 | 97258.0 |
| 2011-05-16 | ER | Futures | 97.281 | 97.286 | 97.267 | 97.277 | 96811.0 |
| 2011-05-16 | EW | Futures | 983.1 | 991.3 | 975.5 | 976.0 | 27368.0 |
| 2011-05-16 | FBTP | Futures | 65.2 | 65.35 | 65.16 | 65.31 | 3037.0 |
| 2011-05-16 | FCE | Futures | 2713.4 | 2737.0 | 2706.8 | 2730.1 | 10794.0 |
| 2011-05-16 | FDAX | Futures | 7846.4 | 7914.2 | 7787.2 | 7890.7 | 149470.0 |
| 2011-05-16 | FESX | Futures | 1821.6 | 1837.6 | 1813.9 | 1830.5 | 1271926.0 |
| 2011-05-16 | FEU3 | Futures | 97.82 | 97.82 | 97.815 | 97.82 | 29.0 |
| 2011-05-16 | FGBL | Futures | 99.68 | 99.72 | 99.24 | 99.32 | 810527.0 |
| 2011-05-16 | FGBM | Futures | 104.05 | 104.07 | 103.79 | 103.84 | 489315.0 |
| 2011-05-16 | FGBS | Futures | 106.568 | 106.578 | 106.464 | 106.484 | 493636.0 |
| 2011-05-16 | FGBX | Futures | 96.87 | 96.87 | 95.79 | 95.84 | 4676.0 |
| 2011-05-16 | FTDX | Futures | 826.1 | 831.0 | 817.2 | 827.5 | 858.0 |
| 2011-05-16 | FTI | Futures | 288.65 | 289.68 | 286.81 | 289.06 | 1779.0 |
| 2011-05-16 | FTUK | Futures | 4115.8 | 4143.1 | 4089.2 | 4132.9 | 115039.0 |
| 2011-05-16 | FXXP | Futures | 185.7 | 187.0 | 185.0 | 186.5 | 1451.0 |
| 2011-05-16 | G | Futures | 83.79 | 83.83 | 83.53 | 83.62 | 93231.0 |
| 2011-05-16 | GF | Futures | 307.875 | 310.141 | 304.97 | 304.97 | 2150.0 |
| 2011-05-16 | GSCI | Futures | 1064.43 | 1073.98 | 1053.94 | 1058.25 | 586.0 |
| 2011-05-16 | HE | Futures | 100.202 | 100.652 | 98.905 | 99.117 | 16670.0 |
| 2011-05-16 | HG | Futures | 5.3209 | 5.3401 | 5.2431 | 5.3016 | 29553.0 |
| 2011-05-16 | HO | Futures | 2.4373 | 2.4426 | 2.3734 | 2.3884 | 50807.0 |
| 2011-05-16 | HRC | Futures | 3077.0 | 3077.0 | 3077.0 | 3077.0 | 0.0 |
| 2011-05-16 | J1 | Futures | 0.0155405 | 0.015582 | 0.0154991 | 0.0155581 | 86642.0 |
| 2011-05-16 | J7 | Futures | 0.015452 | 0.015485 | 0.015405 | 0.015463 | 404.0 |
| 2011-05-16 | JB | Futures | 122.74 | 122.75 | 122.45 | 122.5 | 1482.0 |
| 2011-05-16 | KC | Futures | 645.78 | 652.61 | 630.79 | 633.31 | 12280.0 |
| 2011-05-16 | KE | Futures | 3443.12 | 3502.37 | 3428.31 | 3459.91 | 9362.0 |
| 2011-05-16 | L | Futures | 98.443 | 98.443 | 98.423 | 98.433 | 12082.0 |
> showing 50 of 91 rows — these rows as CSV