PREVIEW / futures_daily / 2012-03-15
file: by_date/futures_daily/2012/2012-03-15.parquet size: 9 KB rows: 99
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-03-15 | ES | Futures | 1398.96 | 1408.28 | 1395.44 | 1406.77 | 1953864.0 |
| 2012-03-15 | NQ | Futures | 3096.02 | 3113.21 | 3090.01 | 3106.91 | 304394.0 |
| 2012-03-15 | YM | Futures | 12763.9 | 12825.2 | 12737.7 | 12809.6 | 110976.0 |
| 2012-03-15 | CL | Futures | 195.4 | 196.69 | 192.25 | 194.76 | 166094.0 |
| 2012-03-15 | GC | Futures | 2200.5 | 2232.9 | 2191.1 | 2222.3 | 180716.0 |
| 2012-03-15 | ZN | Futures | 111.661263 | 111.823719 | 111.092668 | 111.634187 | 1537304.0 |
| 2012-03-15 | A6 | Futures | 0.93005 | 0.93976 | 0.92789 | 0.93877 | 74976.0 |
| 2012-03-15 | AD | Futures | 1.01014 | 1.01366 | 1.00913 | 1.01286 | 61418.0 |
| 2012-03-15 | B | Futures | 111.94 | 112.18 | 109.16 | 110.14 | 292947.0 |
| 2012-03-15 | B6 | Futures | 1.6434 | 1.6508 | 1.6399 | 1.6491 | 47838.0 |
| 2012-03-15 | BFX | Futures | 2835.0 | 2860.5 | 2835.0 | 2860.5 | 268.0 |
| 2012-03-15 | BR | Futures | 0.26081 | 0.26081 | 0.25979 | 0.25979 | 102.0 |
| 2012-03-15 | BZ | Futures | 118.85 | 119.08 | 116.16 | 117.16 | 1260.0 |
| 2012-03-15 | C | Futures | 1491.0 | 1496.0 | 1425.0 | 1448.0 | 14433.0 |
| 2012-03-15 | CB | Futures | 82.887 | 82.887 | 82.887 | 82.887 | 4.0 |
| 2012-03-15 | CC | Futures | 1758.0 | 1758.0 | 1657.0 | 1690.0 | 22314.0 |
| 2012-03-15 | CSC | Futures | 3.692 | 3.749 | 3.692 | 3.744 | 36.0 |
| 2012-03-15 | CT | Futures | 109.14 | 110.46 | 108.97 | 109.31 | 10518.0 |
| 2012-03-15 | DC | Futures | 25.81 | 26.32 | 25.76 | 26.19 | 202.0 |
| 2012-03-15 | DX | Futures | 78.504 | 78.635 | 77.869 | 78.0 | 39391.0 |
| 2012-03-15 | E1 | Futures | 1.40811 | 1.42421 | 1.40418 | 1.42211 | 26998.0 |
| 2012-03-15 | E6 | Futures | 1.5557 | 1.56692 | 1.55295 | 1.56405 | 139122.0 |
| 2012-03-15 | E7 | Futures | 1.5404 | 1.5518 | 1.5382 | 1.5491 | 5063.0 |
| 2012-03-15 | EBM | Futures | 286.03 | 289.06 | 283.67 | 288.73 | 10193.0 |
| 2012-03-15 | ED | Futures | 95.0693 | 95.0836 | 95.0645 | 95.074 | 195102.0 |
| 2012-03-15 | ER | Futures | 97.469 | 97.489 | 97.449 | 97.479 | 192993.0 |
| 2012-03-15 | EW | Futures | 999.6 | 1011.1 | 997.7 | 1008.5 | 27224.0 |
| 2012-03-15 | FBTP | Futures | 69.35 | 69.57 | 69.15 | 69.29 | 6548.0 |
| 2012-03-15 | FBTS | Futures | 86.438 | 86.511 | 86.381 | 86.413 | 455.0 |
| 2012-03-15 | FCE | Futures | 2523.5 | 2537.0 | 2516.4 | 2535.6 | 82667.0 |
| 2012-03-15 | FDAX | Futures | 7829.6 | 7911.3 | 7810.3 | 7891.4 | 159927.0 |
| 2012-03-15 | FESX | Futures | 1730.3 | 1747.6 | 1724.8 | 1742.8 | 1337582.0 |
| 2012-03-15 | FEU3 | Futures | 98.053 | 98.053 | 98.053 | 98.053 | 600.0 |
| 2012-03-15 | FGBL | Futures | 111.8 | 112.22 | 111.73 | 111.91 | 856516.0 |
| 2012-03-15 | FGBM | Futures | 112.99 | 113.08 | 112.83 | 112.89 | 601541.0 |
| 2012-03-15 | FGBS | Futures | 109.819 | 109.829 | 109.73 | 109.745 | 570310.0 |
| 2012-03-15 | FGBX | Futures | 113.33 | 114.73 | 113.2 | 114.32 | 12373.0 |
| 2012-03-15 | FTDX | Futures | 731.2 | 739.1 | 731.2 | 739.1 | 4313.0 |
| 2012-03-15 | FTI | Futures | 280.6 | 282.8 | 280.05 | 282.37 | 20602.0 |
| 2012-03-15 | FTUK | Futures | 4296.8 | 4313.3 | 4282.2 | 4296.5 | 122037.0 |
| 2012-03-15 | FVSA | Futures | 8268.21 | 8318.42 | 8117.57 | 8117.57 | 7055.0 |
| 2012-03-15 | FXXP | Futures | 191.9 | 193.1 | 191.7 | 193.0 | 13389.0 |
| 2012-03-15 | G | Futures | 92.2 | 92.49 | 91.79 | 92.22 | 202809.0 |
| 2012-03-15 | GF | Futures | 328.838 | 330.827 | 325.96 | 326.536 | 2440.0 |
| 2012-03-15 | GSCI | Futures | 1115.52 | 1116.95 | 1101.91 | 1109.67 | 675.0 |
| 2012-03-15 | HE | Futures | 106.015 | 106.347 | 104.927 | 105.018 | 14017.0 |
| 2012-03-15 | HG | Futures | 5.0272 | 5.117 | 5.0147 | 5.1098 | 45158.0 |
| 2012-03-15 | HO | Futures | 2.6931 | 2.6967 | 2.6444 | 2.6598 | 21304.0 |
| 2012-03-15 | HRC | Futures | 2719.2 | 2719.2 | 2719.2 | 2719.2 | 0.0 |
| 2012-03-15 | J1 | Futures | 0.0149928 | 0.0150868 | 0.0149075 | 0.0150492 | 64395.0 |
> showing 50 of 99 rows — these rows as CSV