PREVIEW / futures_daily / 2014-01-10
file: by_date/futures_daily/2014/2014-01-10.parquet size: 9 KB rows: 103
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-10 | ES | Futures | 1889.82 | 1899.35 | 1882.6 | 1894.46 | 1455887.0 |
| 2014-01-10 | NQ | Futures | 4080.82 | 4106.4 | 4057.54 | 4094.33 | 263424.0 |
| 2014-01-10 | YM | Futures | 16366.1 | 16434.0 | 16291.3 | 16355.2 | 138308.0 |
| 2014-01-10 | CL | Futures | 162.94 | 164.85 | 162.4 | 163.69 | 255988.0 |
| 2014-01-10 | GC | Futures | 1624.7 | 1653.1 | 1624.1 | 1650.9 | 161259.0 |
| 2014-01-10 | ZN | Futures | 112.917516 | 113.876141 | 112.874592 | 113.81891 | 1683252.0 |
| 2014-01-10 | A6 | Futures | 0.84386 | 0.85454 | 0.84224 | 0.8533 | 130562.0 |
| 2014-01-10 | AD | Futures | 0.93253 | 0.93283 | 0.92352 | 0.92818 | 101423.0 |
| 2014-01-10 | B | Futures | 107.85 | 108.84 | 107.43 | 108.56 | 233482.0 |
| 2014-01-10 | B6 | Futures | 1.7299 | 1.7343 | 1.7197 | 1.7297 | 120295.0 |
| 2014-01-10 | BR | Futures | 0.21251 | 0.21679 | 0.21251 | 0.21598 | 52.0 |
| 2014-01-10 | BZ | Futures | 110.35 | 110.9 | 109.58 | 110.72 | 6509.0 |
| 2014-01-10 | C | Futures | 1812.0 | 1831.0 | 1812.0 | 1829.0 | 10397.0 |
| 2014-01-10 | CB | Futures | 83.586 | 84.396 | 83.169 | 84.396 | 18.0 |
| 2014-01-10 | CC | Futures | 1995.0 | 2017.0 | 1986.0 | 2013.0 | 12300.0 |
| 2014-01-10 | CNH | Futures | 6.9608 | 6.9608 | 6.957 | 6.9584 | 10.0 |
| 2014-01-10 | CSC | Futures | 3.878 | 3.896 | 3.874 | 3.894 | 23.0 |
| 2014-01-10 | CT | Futures | 94.38 | 95.87 | 93.94 | 94.17 | 20305.0 |
| 2014-01-10 | DC | Futures | 29.93 | 30.2 | 29.74 | 30.09 | 251.0 |
| 2014-01-10 | DX | Futures | 77.108 | 77.284 | 76.666 | 76.794 | 38732.0 |
| 2014-01-10 | E1 | Futures | 1.41529 | 1.4262 | 1.41234 | 1.42184 | 38072.0 |
| 2014-01-10 | E6 | Futures | 1.60566 | 1.61569 | 1.602 | 1.6125 | 231614.0 |
| 2014-01-10 | E7 | Futures | 1.595 | 1.6052 | 1.5914 | 1.602 | 7195.0 |
| 2014-01-10 | EBM | Futures | 273.56 | 275.3 | 267.99 | 268.69 | 32092.0 |
| 2014-01-10 | ED | Futures | 95.3614 | 95.371 | 95.3566 | 95.3614 | 143249.0 |
| 2014-01-10 | ER | Futures | 97.837 | 97.867 | 97.837 | 97.847 | 65413.0 |
| 2014-01-10 | EW | Futures | 1365.4 | 1376.2 | 1362.8 | 1375.6 | 15352.0 |
| 2014-01-10 | FBTP | Futures | 83.22 | 83.32 | 83.03 | 83.13 | 45983.0 |
| 2014-01-10 | FBTS | Futures | 96.038 | 96.1 | 95.977 | 96.047 | 8477.0 |
| 2014-01-10 | FCE | Futures | 3312.5 | 3327.7 | 3298.5 | 3313.7 | 96052.0 |
| 2014-01-10 | FDAX | Futures | 10510.1 | 10578.8 | 10477.9 | 10509.5 | 93053.0 |
| 2014-01-10 | FESX | Futures | 2180.9 | 2193.6 | 2171.8 | 2179.5 | 839518.0 |
| 2014-01-10 | FGBL | Futures | 118.81 | 119.45 | 118.78 | 119.35 | 718733.0 |
| 2014-01-10 | FGBM | Futures | 117.36 | 117.77 | 117.35 | 117.69 | 477204.0 |
| 2014-01-10 | FGBS | Futures | 110.343 | 110.428 | 110.343 | 110.403 | 332289.0 |
| 2014-01-10 | FGBX | Futures | 118.83 | 119.46 | 118.5 | 119.2 | 21327.0 |
| 2014-01-10 | FMWO | Futures | 5418.3 | 5418.3 | 5418.3 | 5418.3 | 0.0 |
| 2014-01-10 | FOAT | Futures | 107.7 | 108.15 | 107.59 | 108.1 | 58128.0 |
| 2014-01-10 | FTDX | Futures | 1131.9 | 1144.6 | 1131.9 | 1141.3 | 105.0 |
| 2014-01-10 | FTI | Futures | 345.43 | 346.98 | 345.01 | 345.31 | 113.0 |
| 2014-01-10 | FTUK | Futures | 5037.0 | 5085.1 | 5037.0 | 5062.0 | 112078.0 |
| 2014-01-10 | FVSA | Futures | 1837.68 | 1864.55 | 1805.44 | 1810.82 | 7394.0 |
| 2014-01-10 | FXXP | Futures | 241.6 | 242.9 | 240.9 | 241.7 | 8373.0 |
| 2014-01-10 | G | Futures | 90.74 | 91.65 | 90.72 | 91.52 | 169652.0 |
| 2014-01-10 | GF | Futures | 272.312 | 273.159 | 270.297 | 270.297 | 3075.0 |
| 2014-01-10 | GSCI | Futures | 1001.62 | 1002.28 | 995.23 | 1000.15 | 1987.0 |
| 2014-01-10 | HE | Futures | 103.139 | 104.135 | 102.596 | 103.652 | 23763.0 |
| 2014-01-10 | HG | Futures | 4.1616 | 4.2267 | 4.1547 | 4.2204 | 46978.0 |
| 2014-01-10 | HH | Futures | 40.031 | 40.993 | 39.67 | 40.602 | 1766.0 |
| 2014-01-10 | HO | Futures | 2.3229 | 2.3443 | 2.3113 | 2.3371 | 32957.0 |
> showing 50 of 103 rows — these rows as CSV