PREVIEW / futures_daily / 2014-04-28
file: by_date/futures_daily/2014/2014-04-28.parquet size: 9 KB rows: 104
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-04-28 | ES | Futures | 1926.24 | 1936.58 | 1907.87 | 1930.63 | 2065197.0 |
| 2014-04-28 | NQ | Futures | 4070.31 | 4100.81 | 4006.42 | 4075.77 | 481343.0 |
| 2014-04-28 | YM | Futures | 16396.9 | 16503.4 | 16308.6 | 16464.2 | 209156.0 |
| 2014-04-28 | CL | Futures | 182.01 | 183.88 | 181.72 | 182.65 | 231590.0 |
| 2014-04-28 | GC | Futures | 1717.1 | 1721.6 | 1702.5 | 1711.6 | 102409.0 |
| 2014-04-28 | ZN | Futures | 115.026141 | 115.156524 | 114.736403 | 115.055115 | 1106876.0 |
| 2014-04-28 | A6 | Futures | 0.8878 | 0.89212 | 0.88511 | 0.88607 | 66015.0 |
| 2014-04-28 | AD | Futures | 0.91796 | 0.91927 | 0.91735 | 0.91846 | 29088.0 |
| 2014-04-28 | B | Futures | 112.79 | 113.55 | 111.15 | 111.43 | 131075.0 |
| 2014-04-28 | B6 | Futures | 1.7657 | 1.7713 | 1.7626 | 1.7663 | 74149.0 |
| 2014-04-28 | BFX | Futures | 3720.5 | 3720.5 | 3706.6 | 3706.6 | 3.0 |
| 2014-04-28 | BR | Futures | 0.23276 | 0.2346 | 0.23247 | 0.2346 | 715.0 |
| 2014-04-28 | BZ | Futures | 115.44 | 115.8 | 113.38 | 113.65 | 8773.0 |
| 2014-04-28 | C | Futures | 1923.0 | 1936.0 | 1918.0 | 1923.0 | 6786.0 |
| 2014-04-28 | CB | Futures | 95.954 | 96.715 | 95.954 | 96.715 | 11.0 |
| 2014-04-28 | CC | Futures | 2175.0 | 2194.0 | 2165.0 | 2172.0 | 7639.0 |
| 2014-04-28 | CNH | Futures | 7.1794 | 7.1795 | 7.1763 | 7.1783 | 24.0 |
| 2014-04-28 | CSC | Futures | 4.466 | 4.466 | 4.408 | 4.442 | 41.0 |
| 2014-04-28 | CT | Futures | 105.01 | 105.32 | 103.35 | 103.85 | 7045.0 |
| 2014-04-28 | DC | Futures | 36.07 | 36.07 | 35.48 | 35.77 | 177.0 |
| 2014-04-28 | DX | Futures | 75.817 | 75.917 | 75.636 | 75.776 | 11599.0 |
| 2014-04-28 | E1 | Futures | 1.45791 | 1.46382 | 1.45445 | 1.4592 | 30839.0 |
| 2014-04-28 | E6 | Futures | 1.63387 | 1.63835 | 1.63056 | 1.63529 | 153057.0 |
| 2014-04-28 | E7 | Futures | 1.6224 | 1.6274 | 1.6197 | 1.6244 | 2853.0 |
| 2014-04-28 | EBM | Futures | 305.79 | 305.79 | 302.97 | 302.97 | 13677.0 |
| 2014-04-28 | ED | Futures | 95.4091 | 95.4138 | 95.4043 | 95.4091 | 91768.0 |
| 2014-04-28 | ER | Futures | 97.817 | 97.827 | 97.813 | 97.817 | 40507.0 |
| 2014-04-28 | EW | Futures | 1390.8 | 1397.3 | 1366.3 | 1385.1 | 24302.0 |
| 2014-04-28 | FBTP | Futures | 88.6 | 88.7 | 88.42 | 88.49 | 39608.0 |
| 2014-04-28 | FBTS | Futures | 97.46 | 97.46 | 97.372 | 97.381 | 9267.0 |
| 2014-04-28 | FCE | Futures | 3494.0 | 3509.9 | 3467.9 | 3496.4 | 97113.0 |
| 2014-04-28 | FDAX | Futures | 10414.8 | 10506.4 | 10367.3 | 10438.5 | 103757.0 |
| 2014-04-28 | FESX | Futures | 2226.9 | 2242.7 | 2213.3 | 2230.5 | 803099.0 |
| 2014-04-28 | FGBL | Futures | 124.51 | 124.64 | 124.35 | 124.5 | 436315.0 |
| 2014-04-28 | FGBM | Futures | 119.78 | 119.86 | 119.69 | 119.81 | 302497.0 |
| 2014-04-28 | FGBS | Futures | 110.503 | 110.513 | 110.478 | 110.498 | 159561.0 |
| 2014-04-28 | FGBX | Futures | 129.12 | 129.39 | 128.7 | 128.88 | 17354.0 |
| 2014-04-28 | FMWO | Futures | 5534.2 | 5534.2 | 5534.2 | 5534.2 | 0.0 |
| 2014-04-28 | FOAT | Futures | 113.79 | 113.84 | 113.58 | 113.7 | 36385.0 |
| 2014-04-28 | FTDX | Futures | 1144.7 | 1144.7 | 1125.9 | 1131.6 | 150.0 |
| 2014-04-28 | FTI | Futures | 336.72 | 338.02 | 334.6 | 336.55 | 22783.0 |
| 2014-04-28 | FTUK | Futures | 5064.2 | 5092.0 | 5049.3 | 5073.4 | 93503.0 |
| 2014-04-28 | FVSA | Futures | 1813.64 | 1837.44 | 1794.6 | 1818.4 | 8993.0 |
| 2014-04-28 | FXXP | Futures | 247.6 | 249.0 | 246.7 | 247.9 | 3810.0 |
| 2014-04-28 | G | Futures | 94.17 | 94.25 | 93.97 | 94.1 | 108446.0 |
| 2014-04-28 | GF | Futures | 286.638 | 289.304 | 285.842 | 288.23 | 2577.0 |
| 2014-04-28 | GSCI | Futures | 1089.36 | 1089.36 | 1082.82 | 1083.98 | 11.0 |
| 2014-04-28 | HE | Futures | 139.98 | 141.438 | 139.28 | 141.118 | 581.0 |
| 2014-04-28 | HG | Futures | 3.9509 | 3.9669 | 3.9381 | 3.9522 | 36864.0 |
| 2014-04-28 | HH | Futures | 60.339 | 60.91 | 60.225 | 60.834 | 541.0 |
> showing 50 of 104 rows — these rows as CSV