PREVIEW / futures_daily / 2012-01-25
file: by_date/futures_daily/2012/2012-01-25.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-25 | ES | Futures | 1315.93 | 1329.47 | 1307.65 | 1324.96 | 1973502.0 |
| 2012-01-25 | NQ | Futures | 2788.09 | 2823.54 | 2786.66 | 2813.82 | 249740.0 |
| 2012-01-25 | YM | Futures | 12211.3 | 12306.0 | 12109.7 | 12270.2 | 110233.0 |
| 2012-01-25 | CL | Futures | 185.4 | 187.64 | 182.27 | 185.77 | 322794.0 |
| 2012-01-25 | GC | Futures | 2250.0 | 2313.1 | 2226.7 | 2295.4 | 240476.0 |
| 2012-01-25 | ZN | Futures | 112.409107 | 113.543325 | 112.314589 | 113.003222 | 1591077.0 |
| 2012-01-25 | A6 | Futures | 0.92766 | 0.93977 | 0.92419 | 0.9371 | 157247.0 |
| 2012-01-25 | AD | Futures | 0.99328 | 0.99971 | 0.98786 | 0.9973 | 94347.0 |
| 2012-01-25 | B | Futures | 98.19 | 98.66 | 96.99 | 97.75 | 116659.0 |
| 2012-01-25 | B6 | Futures | 1.6321 | 1.6383 | 1.6229 | 1.6348 | 108606.0 |
| 2012-01-25 | BFX | Futures | 2631.6 | 2635.1 | 2631.6 | 2635.1 | 25.0 |
| 2012-01-25 | BR | Futures | 0.26363 | 0.26363 | 0.26363 | 0.26363 | 49.0 |
| 2012-01-25 | BZ | Futures | 104.35 | 104.35 | 104.17 | 104.17 | 481.0 |
| 2012-01-25 | C | Futures | 1619.0 | 1643.0 | 1602.0 | 1620.0 | 9571.0 |
| 2012-01-25 | CB | Futures | 84.771 | 84.906 | 84.771 | 84.906 | 25.0 |
| 2012-01-25 | CC | Futures | 1868.0 | 1904.0 | 1852.0 | 1878.0 | 14980.0 |
| 2012-01-25 | CSC | Futures | 3.878 | 3.878 | 3.878 | 3.878 | 1.0 |
| 2012-01-25 | CT | Futures | 126.21 | 126.28 | 121.83 | 124.83 | 14958.0 |
| 2012-01-25 | DC | Futures | 28.36 | 28.36 | 27.99 | 28.28 | 483.0 |
| 2012-01-25 | DX | Futures | 77.831 | 78.357 | 77.393 | 77.59 | 36051.0 |
| 2012-01-25 | E1 | Futures | 1.4162 | 1.42709 | 1.40648 | 1.42315 | 37802.0 |
| 2012-01-25 | E6 | Futures | 1.55796 | 1.56871 | 1.54588 | 1.56429 | 365623.0 |
| 2012-01-25 | E7 | Futures | 1.5436 | 1.5544 | 1.5318 | 1.55 | 5127.0 |
| 2012-01-25 | EBM | Futures | 270.59 | 275.18 | 268.95 | 272.55 | 18753.0 |
| 2012-01-25 | ED | Futures | 95.0533 | 95.0677 | 95.0438 | 95.0581 | 241362.0 |
| 2012-01-25 | ER | Futures | 97.435 | 97.464 | 97.425 | 97.444 | 131602.0 |
| 2012-01-25 | EW | Futures | 941.1 | 950.3 | 933.0 | 948.8 | 22156.0 |
| 2012-01-25 | FBTP | Futures | 61.99 | 61.99 | 61.21 | 61.63 | 8114.0 |
| 2012-01-25 | FBTS | Futures | 82.963 | 82.963 | 82.65 | 82.859 | 2675.0 |
| 2012-01-25 | FCE | Futures | 2379.0 | 2384.4 | 2338.4 | 2358.0 | 76588.0 |
| 2012-01-25 | FDAX | Futures | 7139.4 | 7156.5 | 7033.4 | 7089.1 | 132553.0 |
| 2012-01-25 | FESX | Futures | 1633.3 | 1636.6 | 1602.5 | 1617.9 | 957521.0 |
| 2012-01-25 | FEU3 | Futures | 98.014 | 98.014 | 97.994 | 97.999 | 39.0 |
| 2012-01-25 | FGBL | Futures | 111.13 | 112.01 | 111.01 | 111.53 | 755934.0 |
| 2012-01-25 | FGBM | Futures | 112.63 | 113.13 | 112.5 | 112.83 | 422583.0 |
| 2012-01-25 | FGBS | Futures | 109.83 | 109.924 | 109.77 | 109.874 | 412686.0 |
| 2012-01-25 | FGBX | Futures | 114.05 | 115.99 | 113.99 | 115.12 | 8852.0 |
| 2012-01-25 | FTDX | Futures | 690.2 | 690.2 | 678.6 | 685.5 | 154.0 |
| 2012-01-25 | FTI | Futures | 268.88 | 269.22 | 264.9 | 266.45 | 35104.0 |
| 2012-01-25 | FTUK | Futures | 4126.0 | 4139.0 | 4075.9 | 4094.3 | 98629.0 |
| 2012-01-25 | FVSA | Futures | 10697.91 | 11024.42 | 10601.88 | 10755.53 | 1137.0 |
| 2012-01-25 | FXXP | Futures | 180.7 | 180.9 | 178.7 | 179.7 | 1683.0 |
| 2012-01-25 | G | Futures | 93.49 | 93.97 | 93.44 | 93.59 | 149142.0 |
| 2012-01-25 | GF | Futures | 327.969 | 329.824 | 327.12 | 328.711 | 2704.0 |
| 2012-01-25 | GSCI | Futures | 1029.01 | 1040.75 | 1024.01 | 1034.49 | 97.0 |
| 2012-01-25 | HE | Futures | 106.347 | 107.344 | 106.196 | 106.619 | 11683.0 |
| 2012-01-25 | HG | Futures | 5.0419 | 5.0874 | 4.9594 | 5.0511 | 53184.0 |
| 2012-01-25 | HO | Futures | 2.4495 | 2.4602 | 2.4204 | 2.4363 | 77131.0 |
| 2012-01-25 | HRC | Futures | 2876.8 | 2876.8 | 2876.8 | 2876.8 | 0.0 |
| 2012-01-25 | J1 | Futures | 0.0161765 | 0.0161966 | 0.0160459 | 0.0161476 | 135692.0 |
> showing 50 of 98 rows — these rows as CSV