PREVIEW / futures_daily / 2012-01-03
file: by_date/futures_daily/2012/2012-01-03.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 |
|---|---|---|---|---|---|---|---|
| 2012-01-03 | ES | Futures | 1279.3 | 1284.56 | 1274.78 | 1276.54 | 1565370.0 |
| 2012-01-03 | NQ | Futures | 2644.57 | 2662.58 | 2639.42 | 2648.57 | 177461.0 |
| 2012-01-03 | YM | Futures | 11945.3 | 12006.2 | 11916.3 | 11931.8 | 91126.0 |
| 2012-01-03 | CL | Futures | 186.33 | 192.83 | 186.24 | 192.42 | 275481.0 |
| 2012-01-03 | GC | Futures | 2121.1 | 2172.0 | 2115.4 | 2160.9 | 112937.0 |
| 2012-01-03 | ZN | Futures | 112.868196 | 113.09774 | 112.760175 | 112.814185 | 564737.0 |
| 2012-01-03 | A6 | Futures | 0.91084 | 0.92108 | 0.91084 | 0.91654 | 77617.0 |
| 2012-01-03 | AD | Futures | 0.98847 | 0.99449 | 0.98847 | 0.99198 | 48808.0 |
| 2012-01-03 | B | Futures | 96.13 | 99.64 | 96.13 | 99.4 | 111968.0 |
| 2012-01-03 | B6 | Futures | 1.627 | 1.6374 | 1.6263 | 1.6347 | 65038.0 |
| 2012-01-03 | BFX | Futures | 2553.8 | 2569.1 | 2528.6 | 2569.1 | 43.0 |
| 2012-01-03 | BR | Futures | 0.2523 | 0.2523 | 0.2523 | 0.2523 | 440.0 |
| 2012-01-03 | BZ | Futures | 103.56 | 105.48 | 103.56 | 105.48 | 805.0 |
| 2012-01-03 | C | Futures | 1432.0 | 1446.0 | 1390.0 | 1392.0 | 5986.0 |
| 2012-01-03 | CB | Futures | 89.884 | 89.884 | 89.212 | 89.212 | 1.0 |
| 2012-01-03 | CC | Futures | 1645.0 | 1689.0 | 1628.0 | 1640.0 | 10539.0 |
| 2012-01-03 | CT | Futures | 118.81 | 123.39 | 118.3 | 123.39 | 17546.0 |
| 2012-01-03 | DC | Futures | 29.5 | 29.69 | 29.37 | 29.45 | 98.0 |
| 2012-01-03 | DX | Futures | 78.016 | 78.084 | 77.7 | 77.78 | 20007.0 |
| 2012-01-03 | E1 | Futures | 1.41003 | 1.41344 | 1.40373 | 1.41042 | 15481.0 |
| 2012-01-03 | E6 | Futures | 1.55951 | 1.56405 | 1.55628 | 1.56142 | 137120.0 |
| 2012-01-03 | E7 | Futures | 1.5434 | 1.5496 | 1.5422 | 1.5472 | 2063.0 |
| 2012-01-03 | EBM | Futures | 260.43 | 266.66 | 260.11 | 261.09 | 20449.0 |
| 2012-01-03 | ED | Futures | 94.9148 | 94.9292 | 94.91 | 94.9148 | 111273.0 |
| 2012-01-03 | ER | Futures | 97.263 | 97.277 | 97.253 | 97.267 | 114539.0 |
| 2012-01-03 | EW | Futures | 895.9 | 924.0 | 888.4 | 891.4 | 32856.0 |
| 2012-01-03 | FBTP | Futures | 58.2 | 58.6 | 58.05 | 58.35 | 4441.0 |
| 2012-01-03 | FBTS | Futures | 80.523 | 80.579 | 80.298 | 80.539 | 322.0 |
| 2012-01-03 | FCE | Futures | 2314.4 | 2325.4 | 2286.8 | 2322.9 | 57657.0 |
| 2012-01-03 | FDAX | Futures | 6741.8 | 6831.3 | 6712.0 | 6816.9 | 136088.0 |
| 2012-01-03 | FESX | Futures | 1587.8 | 1595.8 | 1571.8 | 1594.5 | 810571.0 |
| 2012-01-03 | FEU3 | Futures | 97.821 | 97.826 | 97.821 | 97.821 | 28.0 |
| 2012-01-03 | FGBL | Futures | 111.95 | 112.07 | 111.51 | 111.91 | 377508.0 |
| 2012-01-03 | FGBM | Futures | 113.0 | 113.04 | 112.75 | 112.97 | 212498.0 |
| 2012-01-03 | FGBS | Futures | 109.825 | 109.859 | 109.76 | 109.82 | 289122.0 |
| 2012-01-03 | FGBX | Futures | 117.62 | 117.62 | 116.12 | 117.01 | 5728.0 |
| 2012-01-03 | FTDX | Futures | 652.1 | 659.5 | 651.6 | 659.1 | 179.0 |
| 2012-01-03 | FTI | Futures | 266.63 | 267.26 | 264.24 | 266.84 | 26487.0 |
| 2012-01-03 | FTUK | Futures | 4040.2 | 4085.3 | 4018.6 | 4077.4 | 91637.0 |
| 2012-01-03 | FVSA | Futures | 12480.77 | 12580.46 | 12181.71 | 12181.71 | 4435.0 |
| 2012-01-03 | FXXP | Futures | 175.7 | 176.8 | 174.7 | 176.8 | 3977.0 |
| 2012-01-03 | G | Futures | 94.61 | 94.81 | 94.35 | 94.52 | 73525.0 |
| 2012-01-03 | GF | Futures | 316.326 | 318.103 | 315.68 | 315.949 | 961.0 |
| 2012-01-03 | GSCI | Futures | 1030.47 | 1048.59 | 1029.92 | 1048.59 | 318.0 |
| 2012-01-03 | HE | Futures | 104.448 | 105.589 | 104.448 | 105.435 | 16788.0 |
| 2012-01-03 | HG | Futures | 4.5558 | 4.6679 | 4.5558 | 4.6541 | 33626.0 |
| 2012-01-03 | HO | Futures | 2.3589 | 2.4573 | 2.3589 | 2.4511 | 28161.0 |
| 2012-01-03 | HRC | Futures | 2845.4 | 2845.4 | 2845.4 | 2845.4 | 0.0 |
| 2012-01-03 | J1 | Futures | 0.0163812 | 0.0164113 | 0.0163611 | 0.0163937 | 45821.0 |
| 2012-01-03 | J7 | Futures | 0.016318 | 0.016346 | 0.016297 | 0.016326 | 212.0 |
> showing 50 of 98 rows — these rows as CSV