PREVIEW / futures_daily / 2011-12-14
file: by_date/futures_daily/2011/2011-12-14.parquet size: 9 KB rows: 98
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-12-14 | ES | Futures | 1224.1 | 1230.87 | 1206.79 | 1210.55 | 2855128.0 |
| 2011-12-14 | NQ | Futures | 2592.25 | 2603.4 | 2534.21 | 2548.5 | 341733.0 |
| 2011-12-14 | YM | Futures | 11497.6 | 11551.7 | 11330.2 | 11374.7 | 148958.0 |
| 2011-12-14 | CL | Futures | 187.73 | 187.73 | 176.48 | 177.81 | 154950.0 |
| 2011-12-14 | GC | Futures | 2202.9 | 2222.1 | 2113.9 | 2142.6 | 283563.0 |
| 2011-12-14 | ZN | Futures | 112.73317 | 113.084237 | 112.544133 | 113.043729 | 872092.0 |
| 2011-12-14 | A6 | Futures | 0.88148 | 0.88459 | 0.87035 | 0.87133 | 61147.0 |
| 2011-12-14 | AD | Futures | 0.97 | 0.97 | 0.96086 | 0.96277 | 45750.0 |
| 2011-12-14 | B | Futures | 97.18 | 97.21 | 92.34 | 92.91 | 197796.0 |
| 2011-12-14 | B6 | Futures | 1.6179 | 1.6221 | 1.6092 | 1.6154 | 76864.0 |
| 2011-12-14 | BFX | Futures | 2440.3 | 2440.3 | 2391.3 | 2391.3 | 389.0 |
| 2011-12-14 | BR | Futures | 0.24568 | 0.24568 | 0.24568 | 0.24568 | 27.0 |
| 2011-12-14 | BZ | Futures | 102.15 | 102.15 | 98.42 | 98.6 | 647.0 |
| 2011-12-14 | C | Futures | 1506.0 | 1511.0 | 1442.0 | 1451.0 | 11041.0 |
| 2011-12-14 | CB | Futures | 88.808 | 89.212 | 88.808 | 89.212 | 28.0 |
| 2011-12-14 | CC | Futures | 1749.0 | 1763.0 | 1671.0 | 1690.0 | 10690.0 |
| 2011-12-14 | CT | Futures | 112.45 | 112.59 | 108.64 | 109.63 | 10635.0 |
| 2011-12-14 | DC | Futures | 28.44 | 28.61 | 28.44 | 28.54 | 149.0 |
| 2011-12-14 | DX | Futures | 78.819 | 79.242 | 78.624 | 79.12 | 30086.0 |
| 2011-12-14 | E1 | Futures | 1.39007 | 1.39546 | 1.37984 | 1.38062 | 18245.0 |
| 2011-12-14 | E6 | Futures | 1.55951 | 1.56381 | 1.54971 | 1.55317 | 131473.0 |
| 2011-12-14 | E7 | Futures | 1.5458 | 1.5495 | 1.5357 | 1.539 | 2268.0 |
| 2011-12-14 | EBM | Futures | 231.28 | 233.24 | 230.3 | 231.28 | 9956.0 |
| 2011-12-14 | ED | Futures | 94.9196 | 94.9196 | 94.8527 | 94.8575 | 341798.0 |
| 2011-12-14 | ER | Futures | 97.149 | 97.169 | 97.11 | 97.135 | 121175.0 |
| 2011-12-14 | EW | Futures | 858.0 | 862.4 | 840.9 | 842.5 | 34907.0 |
| 2011-12-14 | FBTP | Futures | 57.45 | 57.97 | 56.79 | 57.08 | 7952.0 |
| 2011-12-14 | FBTS | Futures | 78.5 | 78.733 | 78.027 | 78.155 | 706.0 |
| 2011-12-14 | FCE | Futures | 2183.7 | 2197.3 | 2126.4 | 2128.5 | 113192.0 |
| 2011-12-14 | FDAX | Futures | 6203.3 | 6267.3 | 6156.0 | 6173.4 | 219442.0 |
| 2011-12-14 | FESX | Futures | 1489.5 | 1506.2 | 1468.1 | 1472.2 | 1519520.0 |
| 2011-12-14 | FEU3 | Futures | 97.702 | 97.702 | 97.687 | 97.687 | 50.0 |
| 2011-12-14 | FGBL | Futures | 110.67 | 111.74 | 110.55 | 111.56 | 505610.0 |
| 2011-12-14 | FGBM | Futures | 112.24 | 112.73 | 112.07 | 112.64 | 255644.0 |
| 2011-12-14 | FGBS | Futures | 109.675 | 109.73 | 109.62 | 109.69 | 354801.0 |
| 2011-12-14 | FGBX | Futures | 115.75 | 118.07 | 115.57 | 117.7 | 7228.0 |
| 2011-12-14 | FTDX | Futures | 619.1 | 621.0 | 614.5 | 614.5 | 2766.0 |
| 2011-12-14 | FTI | Futures | 249.01 | 250.65 | 245.11 | 245.28 | 24803.0 |
| 2011-12-14 | FTUK | Futures | 3900.3 | 3920.5 | 3843.3 | 3852.7 | 129924.0 |
| 2011-12-14 | FVSA | Futures | 14295.07 | 14753.63 | 14255.19 | 14713.75 | 1332.0 |
| 2011-12-14 | FXXP | Futures | 166.5 | 166.7 | 163.9 | 163.9 | 13419.0 |
| 2011-12-14 | G | Futures | 93.86 | 94.07 | 93.43 | 93.95 | 113977.0 |
| 2011-12-14 | GF | Futures | 309.325 | 310.295 | 307.333 | 309.648 | 1763.0 |
| 2011-12-14 | GSCI | Futures | 997.93 | 997.93 | 971.42 | 974.08 | 289.0 |
| 2011-12-14 | HE | Futures | 106.39 | 106.976 | 105.712 | 106.421 | 12013.0 |
| 2011-12-14 | HG | Futures | 4.4668 | 4.5189 | 4.2953 | 4.3243 | 61191.0 |
| 2011-12-14 | HO | Futures | 2.3844 | 2.3879 | 2.2934 | 2.3014 | 17146.0 |
| 2011-12-14 | HRC | Futures | 2745.9 | 2745.9 | 2745.9 | 2745.9 | 0.0 |
| 2011-12-14 | J1 | Futures | 0.0161376 | 0.0161527 | 0.0161024 | 0.0161213 | 46358.0 |
| 2011-12-14 | J7 | Futures | 0.016082 | 0.016085 | 0.01604 | 0.016055 | 134.0 |
> showing 50 of 98 rows — these rows as CSV