PREVIEW / futures_daily / 2012-12-13
file: by_date/futures_daily/2012/2012-12-13.parquet size: 9 KB rows: 100
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-12-13 | ES | Futures | 1451.11 | 1456.96 | 1440.93 | 1443.22 | 1950507.0 |
| 2012-12-13 | NQ | Futures | 3072.42 | 3094.28 | 3040.49 | 3051.13 | 299474.0 |
| 2012-12-13 | YM | Futures | 12901.7 | 12946.8 | 12828.1 | 12839.9 | 35466.0 |
| 2012-12-13 | CL | Futures | 155.37 | 155.72 | 153.65 | 153.79 | 228417.0 |
| 2012-12-13 | GC | Futures | 2282.5 | 2282.5 | 2253.1 | 2261.2 | 171357.0 |
| 2012-12-13 | ZN | Futures | 117.369011 | 117.465486 | 116.996892 | 117.079585 | 1311631.0 |
| 2012-12-13 | A6 | Futures | 0.95847 | 0.96003 | 0.95499 | 0.95563 | 84137.0 |
| 2012-12-13 | AD | Futures | 1.01653 | 1.01854 | 1.01523 | 1.01573 | 60387.0 |
| 2012-12-13 | B | Futures | 100.66 | 100.83 | 99.2 | 99.27 | 188677.0 |
| 2012-12-13 | B6 | Futures | 1.6862 | 1.6878 | 1.6804 | 1.6832 | 79487.0 |
| 2012-12-13 | BFX | Futures | 2953.9 | 2953.9 | 2941.2 | 2941.2 | 20.0 |
| 2012-12-13 | BR | Futures | 0.23421 | 0.23421 | 0.23294 | 0.23326 | 220.0 |
| 2012-12-13 | BZ | Futures | 103.27 | 103.86 | 102.21 | 102.27 | 952.0 |
| 2012-12-13 | C | Futures | 1648.0 | 1651.0 | 1625.0 | 1640.0 | 7593.0 |
| 2012-12-13 | CB | Futures | 87.573 | 87.573 | 87.443 | 87.443 | 5.0 |
| 2012-12-13 | CC | Futures | 1841.0 | 1844.0 | 1807.0 | 1827.0 | 9578.0 |
| 2012-12-13 | CSC | Futures | 3.916 | 3.916 | 3.873 | 3.873 | 52.0 |
| 2012-12-13 | CT | Futures | 94.39 | 94.64 | 93.6 | 93.83 | 11450.0 |
| 2012-12-13 | DC | Futures | 29.04 | 29.12 | 28.75 | 28.75 | 214.0 |
| 2012-12-13 | DX | Futures | 77.15 | 77.261 | 77.03 | 77.168 | 20619.0 |
| 2012-12-13 | E1 | Futures | 1.39127 | 1.39732 | 1.39011 | 1.39578 | 21143.0 |
| 2012-12-13 | E6 | Futures | 1.54254 | 1.54644 | 1.53936 | 1.54361 | 98705.0 |
| 2012-12-13 | E7 | Futures | 1.5324 | 1.5359 | 1.529 | 1.5331 | 2218.0 |
| 2012-12-13 | EBM | Futures | 289.25 | 290.08 | 283.96 | 284.52 | 23344.0 |
| 2012-12-13 | ED | Futures | 95.2438 | 95.2486 | 95.239 | 95.239 | 124916.0 |
| 2012-12-13 | ER | Futures | 97.862 | 97.876 | 97.862 | 97.866 | 75741.0 |
| 2012-12-13 | EW | Futures | 1027.9 | 1031.1 | 1019.2 | 1020.1 | 38519.0 |
| 2012-12-13 | FBTP | Futures | 74.5 | 74.68 | 74.25 | 74.37 | 22550.0 |
| 2012-12-13 | FBTS | Futures | 90.443 | 90.502 | 90.333 | 90.434 | 3532.0 |
| 2012-12-13 | FCE | Futures | 2743.2 | 2748.5 | 2727.8 | 2735.7 | 14446.0 |
| 2012-12-13 | FDAX | Futures | 8323.4 | 8349.7 | 8284.0 | 8295.5 | 119778.0 |
| 2012-12-13 | FESX | Futures | 1785.9 | 1792.0 | 1776.4 | 1780.4 | 258968.0 |
| 2012-12-13 | FEU3 | Futures | 98.478 | 98.478 | 98.473 | 98.473 | 2.0 |
| 2012-12-13 | FGBL | Futures | 119.77 | 120.3 | 119.71 | 119.9 | 713419.0 |
| 2012-12-13 | FGBM | Futures | 117.31 | 117.56 | 117.27 | 117.44 | 390207.0 |
| 2012-12-13 | FGBS | Futures | 110.582 | 110.632 | 110.582 | 110.617 | 239731.0 |
| 2012-12-13 | FGBX | Futures | 126.31 | 127.55 | 126.31 | 126.72 | 9175.0 |
| 2012-12-13 | FOAT | Futures | 106.17 | 106.54 | 106.11 | 106.24 | 29166.0 |
| 2012-12-13 | FTI | Futures | 295.99 | 296.46 | 294.96 | 295.52 | 924.0 |
| 2012-12-13 | FTUK | Futures | 4338.0 | 4343.8 | 4319.2 | 4324.7 | 18686.0 |
| 2012-12-13 | FVSA | Futures | 4010.25 | 4101.62 | 4000.1 | 4071.16 | 3834.0 |
| 2012-12-13 | FXXP | Futures | 201.0 | 201.0 | 200.5 | 200.5 | 1173.0 |
| 2012-12-13 | G | Futures | 98.68 | 98.92 | 98.32 | 98.49 | 146969.0 |
| 2012-12-13 | GF | Futures | 288.995 | 292.174 | 288.995 | 290.561 | 4746.0 |
| 2012-12-13 | GSCI | Futures | 1022.06 | 1023.59 | 1016.18 | 1017.71 | 2349.0 |
| 2012-12-13 | HE | Futures | 98.351 | 99.04 | 98.15 | 98.58 | 17879.0 |
| 2012-12-13 | HG | Futures | 4.7623 | 4.7642 | 4.691 | 4.7 | 40385.0 |
| 2012-12-13 | HH | Futures | 39.295 | 39.295 | 39.295 | 39.295 | 588.0 |
| 2012-12-13 | HO | Futures | 2.3874 | 2.3939 | 2.363 | 2.3651 | 31670.0 |
| 2012-12-13 | HRC | Futures | 2431.9 | 2431.9 | 2431.9 | 2431.9 | 0.0 |
> showing 50 of 100 rows — these rows as CSV