PREVIEW / futures_daily / 2011-05-27
file: by_date/futures_daily/2011/2011-05-27.parquet size: 9 KB rows: 93
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-27 | ES | Futures | 1313.25 | 1320.43 | 1311.27 | 1316.71 | 1393298.0 |
| 2011-05-27 | NQ | Futures | 2649.62 | 2663.28 | 2644.78 | 2656.45 | 154910.0 |
| 2011-05-27 | YM | Futures | 11663.8 | 11727.8 | 11641.3 | 11684.5 | 78552.0 |
| 2011-05-27 | CL | Futures | 192.42 | 194.49 | 192.19 | 193.24 | 212254.0 |
| 2011-05-27 | GC | Futures | 2057.5 | 2083.6 | 2057.2 | 2080.6 | 138115.0 |
| 2011-05-27 | ZN | Futures | 104.318642 | 104.489829 | 104.10795 | 104.384483 | 1353509.0 |
| 2011-05-27 | A6 | Futures | 0.91034 | 0.91754 | 0.90802 | 0.91668 | 92193.0 |
| 2011-05-27 | AD | Futures | 1.01743 | 1.02052 | 1.01584 | 1.01913 | 58703.0 |
| 2011-05-27 | B | Futures | 98.03 | 98.65 | 97.61 | 98.15 | 43680.0 |
| 2011-05-27 | B6 | Futures | 1.7025 | 1.715 | 1.7014 | 1.7128 | 106799.0 |
| 2011-05-27 | BFX | Futures | 3151.7 | 3179.1 | 3129.0 | 3134.2 | 1105.0 |
| 2011-05-27 | BR | Futures | 0.27194 | 0.27399 | 0.2715 | 0.27308 | 417.0 |
| 2011-05-27 | BZ | Futures | 102.35 | 102.35 | 102.35 | 102.35 | 294.0 |
| 2011-05-27 | C | Futures | 2015.0 | 2023.0 | 1963.0 | 1972.0 | 4271.0 |
| 2011-05-27 | CC | Futures | 2396.0 | 2420.0 | 2354.0 | 2363.0 | 8058.0 |
| 2011-05-27 | CT | Futures | 149.5 | 152.92 | 149.48 | 151.11 | 5308.0 |
| 2011-05-27 | DC | Futures | 31.18 | 31.4 | 31.07 | 31.2 | 146.0 |
| 2011-05-27 | DX | Futures | 75.243 | 75.292 | 74.521 | 74.644 | 26962.0 |
| 2011-05-27 | E1 | Futures | 1.51327 | 1.53841 | 1.51169 | 1.53474 | 47141.0 |
| 2011-05-27 | E6 | Futures | 1.67381 | 1.69383 | 1.67274 | 1.69003 | 328971.0 |
| 2011-05-27 | E7 | Futures | 1.6616 | 1.6812 | 1.6603 | 1.6775 | 7140.0 |
| 2011-05-27 | ED | Futures | 94.9549 | 94.9644 | 94.9525 | 94.9549 | 134807.0 |
| 2011-05-27 | ER | Futures | 97.331 | 97.346 | 97.316 | 97.326 | 107567.0 |
| 2011-05-27 | EW | Futures | 979.8 | 986.3 | 978.0 | 983.4 | 18011.0 |
| 2011-05-27 | FBTP | Futures | 65.25 | 65.35 | 65.09 | 65.19 | 6444.0 |
| 2011-05-27 | FCE | Futures | 2733.2 | 2747.8 | 2716.2 | 2725.9 | 128220.0 |
| 2011-05-27 | FDAX | Futures | 7677.7 | 7700.1 | 7600.3 | 7655.3 | 120752.0 |
| 2011-05-27 | FESX | Futures | 1810.0 | 1815.8 | 1795.9 | 1803.0 | 1249466.0 |
| 2011-05-27 | FEU3 | Futures | 97.875 | 97.89 | 97.87 | 97.87 | 201.0 |
| 2011-05-27 | FGBL | Futures | 100.49 | 100.65 | 100.28 | 100.53 | 961958.0 |
| 2011-05-27 | FGBM | Futures | 104.75 | 104.89 | 104.6 | 104.81 | 601920.0 |
| 2011-05-27 | FGBS | Futures | 106.89 | 106.964 | 106.836 | 106.93 | 708364.0 |
| 2011-05-27 | FGBX | Futures | 98.17 | 98.31 | 97.56 | 98.04 | 2731.0 |
| 2011-05-27 | FTDX | Futures | 805.6 | 805.6 | 791.3 | 801.6 | 717.0 |
| 2011-05-27 | FTI | Futures | 285.09 | 285.74 | 282.75 | 283.77 | 34762.0 |
| 2011-05-27 | FTUK | Futures | 4129.1 | 4156.4 | 4127.7 | 4149.0 | 96668.0 |
| 2011-05-27 | FXXP | Futures | 186.5 | 187.1 | 186.0 | 186.5 | 1255.0 |
| 2011-05-27 | G | Futures | 83.76 | 83.98 | 83.63 | 83.92 | 92168.0 |
| 2011-05-27 | GF | Futures | 286.552 | 287.656 | 284.693 | 285.216 | 1695.0 |
| 2011-05-27 | GSCI | Futures | 1093.0 | 1095.97 | 1090.81 | 1094.25 | 60.0 |
| 2011-05-27 | HE | Futures | 92.446 | 94.458 | 92.446 | 94.166 | 8378.0 |
| 2011-05-27 | HG | Futures | 5.4756 | 5.5713 | 5.4531 | 5.5613 | 33135.0 |
| 2011-05-27 | HO | Futures | 2.4505 | 2.4604 | 2.4402 | 2.4552 | 5358.0 |
| 2011-05-27 | HRC | Futures | 3159.1 | 3179.6 | 3150.9 | 3150.9 | 21.0 |
| 2011-05-27 | J1 | Futures | 0.0154438 | 0.0155694 | 0.0154413 | 0.0155468 | 108638.0 |
| 2011-05-27 | J7 | Futures | 0.015337 | 0.015472 | 0.015337 | 0.015452 | 375.0 |
| 2011-05-27 | JB | Futures | 122.41 | 122.76 | 122.39 | 122.66 | 22.0 |
| 2011-05-27 | KC | Futures | 640.02 | 648.18 | 629.11 | 632.35 | 9029.0 |
| 2011-05-27 | KE | Futures | 3729.47 | 3774.9 | 3694.91 | 3724.54 | 15048.0 |
| 2011-05-27 | L | Futures | 98.423 | 98.433 | 98.403 | 98.423 | 25179.0 |
> showing 50 of 93 rows — these rows as CSV