PREVIEW / futures_daily / 2014-04-02
file: by_date/futures_daily/2014/2014-04-02.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-02 | ES | Futures | 1942.79 | 1951.59 | 1941.24 | 1948.22 | 1181442.0 |
| 2014-04-02 | NQ | Futures | 4202.11 | 4222.83 | 4192.9 | 4211.03 | 239816.0 |
| 2014-04-02 | YM | Futures | 16519.4 | 16577.7 | 16498.4 | 16554.6 | 115123.0 |
| 2014-04-02 | CL | Futures | 177.81 | 178.15 | 176.42 | 177.78 | 231596.0 |
| 2014-04-02 | GC | Futures | 1686.0 | 1706.2 | 1685.1 | 1700.7 | 124467.0 |
| 2014-04-02 | ZN | Futures | 114.417691 | 114.432178 | 113.896162 | 113.968596 | 1319552.0 |
| 2014-04-02 | A6 | Futures | 0.88328 | 0.8854 | 0.88146 | 0.88376 | 50451.0 |
| 2014-04-02 | AD | Futures | 0.91785 | 0.91978 | 0.91613 | 0.91796 | 38324.0 |
| 2014-04-02 | B | Futures | 108.71 | 109.22 | 107.36 | 108.2 | 224763.0 |
| 2014-04-02 | B6 | Futures | 1.747 | 1.7506 | 1.746 | 1.7464 | 53794.0 |
| 2014-04-02 | BFX | Futures | 3805.5 | 3815.2 | 3805.5 | 3811.4 | 48.0 |
| 2014-04-02 | BR | Futures | 0.22833 | 0.22852 | 0.22833 | 0.22852 | 295.0 |
| 2014-04-02 | BZ | Futures | 110.68 | 111.31 | 109.43 | 110.28 | 10331.0 |
| 2014-04-02 | C | Futures | 1946.0 | 1953.0 | 1931.0 | 1935.0 | 8490.0 |
| 2014-04-02 | CB | Futures | 94.938 | 94.938 | 94.811 | 94.862 | 3.0 |
| 2014-04-02 | CC | Futures | 2180.0 | 2189.0 | 2157.0 | 2166.0 | 21461.0 |
| 2014-04-02 | CNH | Futures | 7.12 | 7.1236 | 7.12 | 7.1236 | 1.0 |
| 2014-04-02 | CT | Futures | 103.51 | 104.51 | 102.52 | 102.85 | 13779.0 |
| 2014-04-02 | DC | Futures | 35.84 | 36.15 | 35.81 | 35.91 | 85.0 |
| 2014-04-02 | DX | Futures | 76.235 | 76.415 | 76.145 | 76.356 | 15827.0 |
| 2014-04-02 | E1 | Futures | 1.45342 | 1.45599 | 1.44675 | 1.44816 | 22330.0 |
| 2014-04-02 | E6 | Futures | 1.62832 | 1.63127 | 1.62336 | 1.62466 | 122839.0 |
| 2014-04-02 | E7 | Futures | 1.6172 | 1.6204 | 1.6127 | 1.6138 | 2588.0 |
| 2014-04-02 | EBM | Futures | 292.76 | 292.76 | 289.23 | 291.0 | 23810.0 |
| 2014-04-02 | ED | Futures | 95.3995 | 95.4043 | 95.3995 | 95.3995 | 55988.0 |
| 2014-04-02 | ER | Futures | 97.832 | 97.842 | 97.827 | 97.837 | 55822.0 |
| 2014-04-02 | EW | Futures | 1432.0 | 1437.4 | 1429.6 | 1436.1 | 13462.0 |
| 2014-04-02 | FBTP | Futures | 87.28 | 87.35 | 87.11 | 87.2 | 41639.0 |
| 2014-04-02 | FBTS | Futures | 97.284 | 97.32 | 97.258 | 97.284 | 8491.0 |
| 2014-04-02 | FCE | Futures | 3451.6 | 3452.8 | 3436.4 | 3443.8 | 68696.0 |
| 2014-04-02 | FDAX | Futures | 10663.2 | 10675.4 | 10630.7 | 10658.3 | 66318.0 |
| 2014-04-02 | FESX | Futures | 2247.7 | 2249.9 | 2238.4 | 2244.2 | 552885.0 |
| 2014-04-02 | FEU3 | Futures | 98.453 | 98.458 | 98.453 | 98.458 | 24.0 |
| 2014-04-02 | FGBL | Futures | 123.6 | 123.61 | 123.16 | 123.21 | 638035.0 |
| 2014-04-02 | FGBM | Futures | 119.56 | 119.56 | 119.31 | 119.34 | 472507.0 |
| 2014-04-02 | FGBS | Futures | 110.483 | 110.488 | 110.443 | 110.453 | 401950.0 |
| 2014-04-02 | FGBX | Futures | 126.64 | 126.64 | 125.75 | 125.87 | 12869.0 |
| 2014-04-02 | FMWO | Futures | 5580.9 | 5583.4 | 5580.9 | 5583.4 | 10.0 |
| 2014-04-02 | FOAT | Futures | 112.5 | 112.55 | 112.18 | 112.23 | 54049.0 |
| 2014-04-02 | FTDX | Futures | 1192.5 | 1198.1 | 1192.5 | 1195.3 | 112.0 |
| 2014-04-02 | FTI | Futures | 347.23 | 347.35 | 346.03 | 346.54 | 16278.0 |
| 2014-04-02 | FTUK | Futures | 5031.0 | 5049.0 | 5020.0 | 5038.3 | 73597.0 |
| 2014-04-02 | FVSA | Futures | 1740.36 | 1760.42 | 1730.33 | 1750.39 | 5026.0 |
| 2014-04-02 | FXXP | Futures | 249.4 | 249.7 | 248.7 | 249.4 | 7449.0 |
| 2014-04-02 | G | Futures | 93.27 | 93.27 | 93.03 | 93.07 | 155892.0 |
| 2014-04-02 | GF | Futures | 282.397 | 284.078 | 282.317 | 283.718 | 821.0 |
| 2014-04-02 | GSCI | Futures | 1052.4 | 1055.29 | 1048.68 | 1051.24 | 436.0 |
| 2014-04-02 | HE | Futures | 146.279 | 147.183 | 143.246 | 146.688 | 622.0 |
| 2014-04-02 | HG | Futures | 3.8488 | 3.8957 | 3.8456 | 3.8595 | 50145.0 |
| 2014-04-02 | HH | Futures | 53.858 | 55.503 | 53.858 | 55.238 | 5707.0 |
> showing 50 of 104 rows — these rows as CSV