PREVIEW / futures_daily / 2014-01-30
file: by_date/futures_daily/2014/2014-01-30.parquet size: 9 KB rows: 106
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 |
|---|---|---|---|---|---|---|---|
| 2014-01-30 | ES | Futures | 1824.61 | 1849.1 | 1822.3 | 1836.21 | 1824579.0 |
| 2014-01-30 | NQ | Futures | 4000.63 | 4066.45 | 3990.29 | 4025.93 | 315346.0 |
| 2014-01-30 | YM | Futures | 15664.2 | 15821.0 | 15641.3 | 15708.2 | 178290.0 |
| 2014-01-30 | CL | Futures | 172.04 | 174.11 | 171.88 | 173.47 | 199420.0 |
| 2014-01-30 | GC | Futures | 1670.4 | 1671.2 | 1631.3 | 1637.9 | 163622.0 |
| 2014-01-30 | ZN | Futures | 114.977846 | 115.049385 | 114.634457 | 114.877691 | 1392073.0 |
| 2014-01-30 | A6 | Futures | 0.82995 | 0.83624 | 0.82747 | 0.83471 | 81452.0 |
| 2014-01-30 | AD | Futures | 0.90559 | 0.90711 | 0.90296 | 0.90509 | 47951.0 |
| 2014-01-30 | B | Futures | 110.13 | 110.62 | 109.92 | 110.18 | 127259.0 |
| 2014-01-30 | B6 | Futures | 1.7387 | 1.7397 | 1.7269 | 1.7304 | 99219.0 |
| 2014-01-30 | BFX | Futures | 3490.8 | 3504.5 | 3490.8 | 3504.5 | 5.0 |
| 2014-01-30 | BR | Futures | 0.21129 | 0.21339 | 0.21119 | 0.21306 | 3257.0 |
| 2014-01-30 | BZ | Futures | 112.19 | 112.85 | 112.18 | 112.41 | 8232.0 |
| 2014-01-30 | C | Futures | 1943.0 | 1954.0 | 1937.0 | 1952.0 | 9701.0 |
| 2014-01-30 | CB | Futures | 90.652 | 90.652 | 88.935 | 90.039 | 73.0 |
| 2014-01-30 | CC | Futures | 2164.0 | 2167.0 | 2147.0 | 2161.0 | 19560.0 |
| 2014-01-30 | CNH | Futures | 6.9526 | 6.9573 | 6.9526 | 6.9539 | 36.0 |
| 2014-01-30 | CSC | Futures | 4.298 | 4.344 | 4.298 | 4.344 | 20.0 |
| 2014-01-30 | CT | Futures | 97.49 | 98.98 | 97.2 | 98.09 | 16640.0 |
| 2014-01-30 | DC | Futures | 32.72 | 33.84 | 32.59 | 33.7 | 636.0 |
| 2014-01-30 | DX | Futures | 76.685 | 77.26 | 76.68 | 77.211 | 24074.0 |
| 2014-01-30 | E1 | Futures | 1.43545 | 1.43596 | 1.41927 | 1.42171 | 34277.0 |
| 2014-01-30 | E6 | Futures | 1.61286 | 1.61298 | 1.59869 | 1.59952 | 263799.0 |
| 2014-01-30 | E7 | Futures | 1.6016 | 1.6023 | 1.5881 | 1.5891 | 5463.0 |
| 2014-01-30 | EBM | Futures | 263.82 | 265.21 | 263.12 | 264.86 | 23046.0 |
| 2014-01-30 | ED | Futures | 95.3662 | 95.3758 | 95.3614 | 95.3662 | 100018.0 |
| 2014-01-30 | ER | Futures | 97.852 | 97.867 | 97.847 | 97.867 | 84455.0 |
| 2014-01-30 | EW | Futures | 1325.6 | 1347.7 | 1323.6 | 1338.0 | 20265.0 |
| 2014-01-30 | FBTP | Futures | 83.65 | 83.83 | 83.45 | 83.77 | 70954.0 |
| 2014-01-30 | FBTS | Futures | 96.073 | 96.187 | 96.073 | 96.178 | 9908.0 |
| 2014-01-30 | FCE | Futures | 3230.1 | 3274.8 | 3207.2 | 3251.5 | 133305.0 |
| 2014-01-30 | FDAX | Futures | 10338.2 | 10464.6 | 10282.7 | 10379.8 | 109255.0 |
| 2014-01-30 | FDIV | Futures | 141.35 | 142.53 | 141.35 | 142.53 | 35.0 |
| 2014-01-30 | FESX | Futures | 2115.5 | 2142.9 | 2100.0 | 2125.3 | 1114758.0 |
| 2014-01-30 | FEU3 | Futures | 98.478 | 98.483 | 98.478 | 98.483 | 100.0 |
| 2014-01-30 | FGBL | Futures | 121.76 | 122.05 | 121.63 | 121.88 | 961604.0 |
| 2014-01-30 | FGBM | Futures | 118.94 | 119.08 | 118.84 | 119.01 | 668538.0 |
| 2014-01-30 | FGBS | Futures | 110.608 | 110.638 | 110.588 | 110.623 | 336411.0 |
| 2014-01-30 | FGBX | Futures | 123.77 | 124.21 | 123.65 | 124.0 | 19691.0 |
| 2014-01-30 | FMWO | Futures | 5284.9 | 5284.9 | 5272.3 | 5272.3 | 48.0 |
| 2014-01-30 | FOAT | Futures | 110.0 | 110.31 | 109.95 | 110.26 | 60264.0 |
| 2014-01-30 | FTDX | Futures | 1160.1 | 1160.1 | 1132.4 | 1146.5 | 214.0 |
| 2014-01-30 | FTI | Futures | 332.54 | 335.11 | 330.14 | 332.88 | 37238.0 |
| 2014-01-30 | FTUK | Futures | 4900.7 | 4931.4 | 4884.1 | 4910.2 | 106378.0 |
| 2014-01-30 | FVSA | Futures | 2030.16 | 2116.87 | 1989.35 | 2050.56 | 14081.0 |
| 2014-01-30 | FXXP | Futures | 235.7 | 238.2 | 234.4 | 236.5 | 4351.0 |
| 2014-01-30 | G | Futures | 93.0 | 93.24 | 92.89 | 93.03 | 194207.0 |
| 2014-01-30 | GF | Futures | 272.473 | 272.876 | 271.627 | 271.99 | 2485.0 |
| 2014-01-30 | GSCI | Futures | 1031.13 | 1031.13 | 1025.8 | 1027.85 | 84.0 |
| 2014-01-30 | HE | Futures | 113.616 | 113.676 | 112.378 | 113.073 | 11962.0 |
> showing 50 of 106 rows — these rows as CSV