PREVIEW / futures_daily / 2011-03-08
file: by_date/futures_daily/2011/2011-03-08.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-03-08 | ES | Futures | 1288.23 | 1304.97 | 1285.53 | 1299.31 | 2209200.0 |
| 2011-03-08 | NQ | Futures | 2638.45 | 2665.69 | 2623.12 | 2649.52 | 363782.0 |
| 2011-03-08 | YM | Futures | 11304.1 | 11460.4 | 11289.2 | 11417.4 | 133651.0 |
| 2011-03-08 | CL | Futures | 203.72 | 205.55 | 200.77 | 204.05 | 420036.0 |
| 2011-03-08 | GC | Futures | 1943.8 | 1950.4 | 1932.0 | 1936.9 | 129914.0 |
| 2011-03-08 | ZN | Futures | 99.854615 | 100.065307 | 99.630755 | 99.736101 | 1052191.0 |
| 2011-03-08 | A6 | Futures | 0.85724 | 0.85869 | 0.85182 | 0.85631 | 108676.0 |
| 2011-03-08 | AD | Futures | 1.01994 | 1.02222 | 1.01785 | 1.02172 | 91310.0 |
| 2011-03-08 | B | Futures | 97.54 | 97.89 | 95.34 | 96.09 | 154507.0 |
| 2011-03-08 | B6 | Futures | 1.681 | 1.6814 | 1.6725 | 1.6761 | 103113.0 |
| 2011-03-08 | BFX | Futures | 3107.2 | 3107.2 | 3088.7 | 3099.9 | 112.0 |
| 2011-03-08 | BR | Futures | 0.26283 | 0.26283 | 0.26114 | 0.26114 | 33.0 |
| 2011-03-08 | BZ | Futures | 102.37 | 102.79 | 100.56 | 101.22 | 1926.0 |
| 2011-03-08 | C | Futures | 2588.0 | 2611.0 | 2529.0 | 2535.0 | 6727.0 |
| 2011-03-08 | CB | Futures | 123.202 | 123.217 | 123.202 | 123.217 | 10.0 |
| 2011-03-08 | CC | Futures | 2950.0 | 3001.0 | 2905.0 | 2920.0 | 8751.0 |
| 2011-03-08 | CSC | Futures | 4.361 | 4.366 | 4.291 | 4.307 | 54.0 |
| 2011-03-08 | CT | Futures | 191.15 | 192.93 | 185.23 | 185.23 | 13548.0 |
| 2011-03-08 | DC | Futures | 29.27 | 29.5 | 28.69 | 28.91 | 252.0 |
| 2011-03-08 | DX | Futures | 76.382 | 76.856 | 76.287 | 76.662 | 27047.0 |
| 2011-03-08 | E1 | Futures | 1.41494 | 1.4152 | 1.39986 | 1.40091 | 58766.0 |
| 2011-03-08 | E6 | Futures | 1.65248 | 1.65484 | 1.6397 | 1.64455 | 297445.0 |
| 2011-03-08 | E7 | Futures | 1.6402 | 1.6425 | 1.6276 | 1.6323 | 3946.0 |
| 2011-03-08 | EBM | Futures | 221.93 | 222.87 | 218.41 | 220.52 | 15081.0 |
| 2011-03-08 | ED | Futures | 94.867 | 94.867 | 94.8646 | 94.8646 | 92100.0 |
| 2011-03-08 | ER | Futures | 97.203 | 97.217 | 97.203 | 97.212 | 131389.0 |
| 2011-03-08 | EW | Futures | 939.7 | 956.5 | 937.2 | 952.4 | 28168.0 |
| 2011-03-08 | FBTP | Futures | 63.34 | 63.39 | 63.07 | 63.1 | 7057.0 |
| 2011-03-08 | FCE | Futures | 2658.1 | 2674.7 | 2634.2 | 2668.8 | 147030.0 |
| 2011-03-08 | FDAX | Futures | 7703.7 | 7738.6 | 7573.1 | 7671.6 | 205137.0 |
| 2011-03-08 | FESX | Futures | 1826.5 | 1835.2 | 1807.3 | 1828.4 | 1469980.0 |
| 2011-03-08 | FEU3 | Futures | 97.765 | 97.77 | 97.765 | 97.77 | 321.0 |
| 2011-03-08 | FGBL | Futures | 97.33 | 97.52 | 97.15 | 97.22 | 727117.0 |
| 2011-03-08 | FGBM | Futures | 102.62 | 102.84 | 102.62 | 102.66 | 556812.0 |
| 2011-03-08 | FGBS | Futures | 106.176 | 106.261 | 106.176 | 106.221 | 596656.0 |
| 2011-03-08 | FGBX | Futures | 93.83 | 94.3 | 93.48 | 93.68 | 3595.0 |
| 2011-03-08 | FTDX | Futures | 793.8 | 793.8 | 785.5 | 789.4 | 745.0 |
| 2011-03-08 | FTI | Futures | 297.05 | 297.82 | 293.73 | 296.6 | 56733.0 |
| 2011-03-08 | FTUK | Futures | 4127.0 | 4168.7 | 4094.3 | 4137.4 | 135092.0 |
| 2011-03-08 | FXXP | Futures | 182.7 | 183.2 | 181.2 | 182.6 | 1044.0 |
| 2011-03-08 | G | Futures | 80.87 | 80.95 | 80.5 | 80.58 | 106158.0 |
| 2011-03-08 | GF | Futures | 320.428 | 324.128 | 320.304 | 323.573 | 1480.0 |
| 2011-03-08 | GSCI | Futures | 1121.76 | 1124.2 | 1112.33 | 1119.4 | 2901.0 |
| 2011-03-08 | HE | Futures | 101.163 | 104.314 | 100.58 | 103.993 | 32983.0 |
| 2011-03-08 | HG | Futures | 5.7882 | 5.8055 | 5.6663 | 5.7788 | 36302.0 |
| 2011-03-08 | HO | Futures | 2.5386 | 2.5644 | 2.4998 | 2.5221 | 24039.0 |
| 2011-03-08 | HRC | Futures | 3081.2 | 3081.2 | 3081.2 | 3081.2 | 0.0 |
| 2011-03-08 | J1 | Futures | 0.0152603 | 0.0152754 | 0.0151561 | 0.01519 | 130779.0 |
| 2011-03-08 | J7 | Futures | 0.015156 | 0.015166 | 0.01505 | 0.015082 | 227.0 |
| 2011-03-08 | JB | Futures | 120.69 | 120.83 | 120.62 | 120.65 | 9139.0 |
> showing 50 of 94 rows — these rows as CSV