PREVIEW / futures_daily / 2011-08-10
file: by_date/futures_daily/2011/2011-08-10.parquet size: 9 KB rows: 95
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-08-10 | ES | Futures | 1162.96 | 1170.66 | 1106.1 | 1115.79 | 4925051.0 |
| 2011-08-10 | NQ | Futures | 2452.88 | 2469.11 | 2352.39 | 2374.31 | 543270.0 |
| 2011-08-10 | YM | Futures | 10582.9 | 10648.1 | 10064.8 | 10139.5 | 317148.0 |
| 2011-08-10 | CL | Futures | 156.96 | 159.33 | 152.41 | 158.85 | 520144.0 |
| 2011-08-10 | GC | Futures | 2359.3 | 2431.6 | 2349.5 | 2409.1 | 296968.0 |
| 2011-08-10 | ZN | Futures | 110.138562 | 111.136434 | 109.805937 | 110.75059 | 2091932.0 |
| 2011-08-10 | A6 | Futures | 0.89952 | 0.89969 | 0.87995 | 0.88786 | 208357.0 |
| 2011-08-10 | AD | Futures | 1.02032 | 1.02041 | 1.00155 | 1.00764 | 175583.0 |
| 2011-08-10 | B | Futures | 89.36 | 91.53 | 88.45 | 91.2 | 162759.0 |
| 2011-08-10 | B6 | Futures | 1.6979 | 1.6985 | 1.6765 | 1.6805 | 137648.0 |
| 2011-08-10 | BFX | Futures | 2598.0 | 2598.0 | 2540.2 | 2540.2 | 13.0 |
| 2011-08-10 | BR | Futures | 0.27127 | 0.27481 | 0.2706 | 0.27481 | 488.0 |
| 2011-08-10 | BZ | Futures | 93.83 | 94.2 | 92.37 | 94.2 | 1209.0 |
| 2011-08-10 | C | Futures | 2009.0 | 2034.0 | 1988.0 | 1993.0 | 7753.0 |
| 2011-08-10 | CC | Futures | 2301.0 | 2334.0 | 2240.0 | 2251.0 | 21781.0 |
| 2011-08-10 | CSC | Futures | 4.865 | 4.865 | 4.845 | 4.845 | 8.0 |
| 2011-08-10 | CT | Futures | 128.48 | 129.57 | 125.88 | 128.68 | 25.0 |
| 2011-08-10 | DC | Futures | 33.43 | 33.44 | 32.74 | 33.01 | 701.0 |
| 2011-08-10 | DX | Futures | 73.415 | 74.202 | 73.192 | 74.048 | 40194.0 |
| 2011-08-10 | E1 | Futures | 1.81621 | 1.82432 | 1.78587 | 1.79646 | 60330.0 |
| 2011-08-10 | E6 | Futures | 1.70849 | 1.70967 | 1.68105 | 1.68568 | 457078.0 |
| 2011-08-10 | E7 | Futures | 1.6955 | 1.6971 | 1.6689 | 1.6734 | 5373.0 |
| 2011-08-10 | ED | Futures | 94.9382 | 94.9716 | 94.8906 | 94.9191 | 479790.0 |
| 2011-08-10 | ER | Futures | 97.653 | 97.717 | 97.613 | 97.702 | 213842.0 |
| 2011-08-10 | EW | Futures | 817.2 | 823.4 | 787.1 | 792.4 | 68018.0 |
| 2011-08-10 | FBTP | Futures | 63.42 | 63.65 | 63.16 | 63.54 | 10101.0 |
| 2011-08-10 | FCE | Futures | 2255.9 | 2279.1 | 2105.7 | 2115.2 | 349963.0 |
| 2011-08-10 | FDAX | Futures | 6400.4 | 6540.3 | 5920.6 | 5993.8 | 333244.0 |
| 2011-08-10 | FESX | Futures | 1484.2 | 1505.4 | 1370.0 | 1381.6 | 3822559.0 |
| 2011-08-10 | FEU3 | Futures | 98.178 | 98.248 | 98.173 | 98.243 | 174.0 |
| 2011-08-10 | FGBL | Futures | 106.77 | 107.93 | 106.4 | 107.58 | 1001727.0 |
| 2011-08-10 | FGBM | Futures | 109.01 | 109.81 | 108.81 | 109.59 | 604771.0 |
| 2011-08-10 | FGBS | Futures | 108.81 | 109.094 | 108.701 | 108.994 | 758993.0 |
| 2011-08-10 | FGBX | Futures | 105.39 | 106.67 | 104.21 | 105.94 | 6821.0 |
| 2011-08-10 | FTDX | Futures | 636.8 | 659.1 | 609.1 | 613.6 | 1273.0 |
| 2011-08-10 | FTI | Futures | 237.48 | 239.11 | 226.18 | 226.46 | 2356.0 |
| 2011-08-10 | FTUK | Futures | 3705.4 | 3709.3 | 3498.3 | 3523.4 | 273883.0 |
| 2011-08-10 | FXXP | Futures | 159.5 | 159.9 | 150.8 | 151.1 | 2437.0 |
| 2011-08-10 | G | Futures | 88.91 | 90.14 | 88.84 | 89.96 | 144511.0 |
| 2011-08-10 | GF | Futures | 309.618 | 310.935 | 307.958 | 309.332 | 1903.0 |
| 2011-08-10 | GSCI | Futures | 978.56 | 990.94 | 968.46 | 990.0 | 1881.0 |
| 2011-08-10 | HE | Futures | 109.313 | 109.649 | 106.046 | 106.077 | 26362.0 |
| 2011-08-10 | HG | Futures | 5.3341 | 5.3843 | 5.1146 | 5.1404 | 62692.0 |
| 2011-08-10 | HO | Futures | 2.2616 | 2.3348 | 2.2616 | 2.3198 | 77918.0 |
| 2011-08-10 | HRC | Futures | 2868.4 | 2868.4 | 2868.4 | 2868.4 | 0.0 |
| 2011-08-10 | J1 | Futures | 0.0162883 | 0.0164756 | 0.0162695 | 0.0163801 | 128457.0 |
| 2011-08-10 | J7 | Futures | 0.016192 | 0.016363 | 0.016169 | 0.016271 | 566.0 |
| 2011-08-10 | JB | Futures | 123.76 | 124.0 | 123.76 | 123.84 | 3074.0 |
| 2011-08-10 | KC | Futures | 557.84 | 564.94 | 553.11 | 555.6 | 12519.0 |
| 2011-08-10 | KE | Futures | 2943.17 | 3019.03 | 2936.45 | 3015.19 | 13322.0 |
> showing 50 of 95 rows — these rows as CSV