PREVIEW / futures_daily / 2013-05-17
file: by_date/futures_daily/2013/2013-05-17.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 |
|---|---|---|---|---|---|---|---|
| 2013-05-17 | ES | Futures | 1693.47 | 1710.16 | 1692.19 | 1707.33 | 1923927.0 |
| 2013-05-17 | NQ | Futures | 3466.42 | 3497.9 | 3462.96 | 3491.55 | 188115.0 |
| 2013-05-17 | YM | Futures | 14984.3 | 15099.5 | 14980.3 | 15080.8 | 116568.0 |
| 2013-05-17 | CL | Futures | 166.47 | 168.7 | 165.77 | 167.92 | 156873.0 |
| 2013-05-17 | GC | Futures | 1838.9 | 1847.0 | 1796.9 | 1811.7 | 229036.0 |
| 2013-05-17 | ZN | Futures | 117.809836 | 118.018546 | 117.350674 | 117.420244 | 1484973.0 |
| 2013-05-17 | A6 | Futures | 0.90439 | 0.9055 | 0.89451 | 0.89682 | 148437.0 |
| 2013-05-17 | AD | Futures | 0.98567 | 0.98617 | 0.9719 | 0.97623 | 112512.0 |
| 2013-05-17 | B | Futures | 99.94 | 100.9 | 99.44 | 100.68 | 193728.0 |
| 2013-05-17 | B6 | Futures | 1.5979 | 1.5987 | 1.5857 | 1.5871 | 117000.0 |
| 2013-05-17 | BFX | Futures | 3260.0 | 3279.8 | 3255.1 | 3268.8 | 31.0 |
| 2013-05-17 | BR | Futures | 0.24346 | 0.24359 | 0.24205 | 0.24245 | 468.0 |
| 2013-05-17 | BZ | Futures | 100.76 | 101.93 | 100.46 | 101.7 | 5635.0 |
| 2013-05-17 | C | Futures | 1635.0 | 1668.0 | 1632.0 | 1662.0 | 5652.0 |
| 2013-05-17 | CC | Futures | 1721.0 | 1737.0 | 1707.0 | 1725.0 | 10519.0 |
| 2013-05-17 | CNH | Futures | 7.1737 | 7.1804 | 7.1737 | 7.1792 | 24.0 |
| 2013-05-17 | CSC | Futures | 3.647 | 3.651 | 3.637 | 3.641 | 7.0 |
| 2013-05-17 | CT | Futures | 103.1 | 103.67 | 102.52 | 103.56 | 11686.0 |
| 2013-05-17 | DC | Futures | 27.93 | 28.1 | 27.71 | 27.89 | 299.0 |
| 2013-05-17 | DX | Futures | 80.615 | 81.226 | 80.601 | 81.103 | 47333.0 |
| 2013-05-17 | E1 | Futures | 1.33426 | 1.33529 | 1.31792 | 1.32242 | 55260.0 |
| 2013-05-17 | E6 | Futures | 1.51943 | 1.51991 | 1.50882 | 1.51271 | 265709.0 |
| 2013-05-17 | E7 | Futures | 1.5089 | 1.5099 | 1.499 | 1.5028 | 3702.0 |
| 2013-05-17 | ED | Futures | 95.2659 | 95.2683 | 95.2635 | 95.2659 | 84521.0 |
| 2013-05-17 | ER | Futures | 97.832 | 97.847 | 97.832 | 97.837 | 52519.0 |
| 2013-05-17 | EW | Futures | 1224.3 | 1235.7 | 1223.8 | 1233.9 | 14834.0 |
| 2013-05-17 | FBTP | Futures | 79.55 | 80.23 | 79.55 | 80.15 | 30550.0 |
| 2013-05-17 | FBTS | Futures | 93.031 | 93.28 | 93.031 | 93.203 | 7.0 |
| 2013-05-17 | FCE | Futures | 3046.9 | 3099.5 | 3046.9 | 3078.6 | 129969.0 |
| 2013-05-17 | FDAX | Futures | 9287.7 | 9424.5 | 9257.2 | 9332.2 | 109829.0 |
| 2013-05-17 | FDIV | Futures | 125.71 | 126.66 | 125.71 | 126.56 | 80.0 |
| 2013-05-17 | FESX | Futures | 1946.2 | 1974.9 | 1943.4 | 1962.3 | 1092120.0 |
| 2013-05-17 | FGBL | Futures | 121.74 | 122.15 | 121.64 | 121.91 | 777073.0 |
| 2013-05-17 | FGBM | Futures | 118.16 | 118.39 | 118.15 | 118.3 | 511444.0 |
| 2013-05-17 | FGBS | Futures | 110.557 | 110.617 | 110.557 | 110.597 | 321006.0 |
| 2013-05-17 | FGBX | Futures | 127.61 | 128.64 | 127.54 | 128.14 | 10221.0 |
| 2013-05-17 | FMWO | Futures | 4937.1 | 4937.1 | 4937.1 | 4937.1 | 0.0 |
| 2013-05-17 | FOAT | Futures | 109.45 | 109.82 | 109.39 | 109.71 | 46460.0 |
| 2013-05-17 | FTDX | Futures | 919.3 | 920.7 | 911.3 | 916.5 | 134.0 |
| 2013-05-17 | FTI | Futures | 316.83 | 321.79 | 316.66 | 320.22 | 33688.0 |
| 2013-05-17 | FTUK | Futures | 4943.3 | 4999.8 | 4936.6 | 4975.6 | 85593.0 |
| 2013-05-17 | FVSA | Futures | 2906.72 | 2906.72 | 2838.05 | 2860.94 | 2531.0 |
| 2013-05-17 | FXXP | Futures | 224.9 | 226.6 | 224.6 | 225.9 | 2168.0 |
| 2013-05-17 | G | Futures | 99.04 | 99.32 | 98.75 | 98.96 | 163743.0 |
| 2013-05-17 | GF | Futures | 244.267 | 244.814 | 241.065 | 241.571 | 2954.0 |
| 2013-05-17 | GSCI | Futures | 1020.97 | 1025.83 | 1019.59 | 1025.83 | 142.0 |
| 2013-05-17 | HE | Futures | 91.451 | 91.966 | 89.024 | 89.784 | 25148.0 |
| 2013-05-17 | HG | Futures | 4.187 | 4.2621 | 4.1793 | 4.2335 | 53563.0 |
| 2013-05-17 | HH | Futures | 44.204 | 45.957 | 44.204 | 45.564 | 1520.0 |
| 2013-05-17 | HO | Futures | 2.3389 | 2.3755 | 2.3338 | 2.3642 | 50053.0 |
> showing 50 of 103 rows — these rows as CSV