PREVIEW / futures_daily / 2014-10-17
file: by_date/futures_daily/2014/2014-10-17.parquet size: 9 KB rows: 105
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-10-17 | ES | Futures | 1935.62 | 1976.1 | 1933.53 | 1964.87 | 2579053.0 |
| 2014-10-17 | NQ | Futures | 4343.84 | 4451.05 | 4336.89 | 4408.74 | 477901.0 |
| 2014-10-17 | YM | Futures | 16265.9 | 16584.4 | 16252.7 | 16545.9 | 266749.0 |
| 2014-10-17 | CL | Futures | 158.21 | 160.78 | 156.96 | 157.55 | 217690.0 |
| 2014-10-17 | GC | Futures | 1625.8 | 1629.2 | 1616.0 | 1625.1 | 117545.0 |
| 2014-10-17 | ZN | Futures | 119.945164 | 120.267322 | 119.432641 | 119.623007 | 1967511.0 |
| 2014-10-17 | A6 | Futures | 0.84702 | 0.85295 | 0.84537 | 0.84789 | 89931.0 |
| 2014-10-17 | AD | Futures | 0.90056 | 0.90473 | 0.89874 | 0.89996 | 55623.0 |
| 2014-10-17 | ALI | Futures | 3002.7 | 3002.7 | 3002.7 | 3002.7 | 11.0 |
| 2014-10-17 | B | Futures | 89.79 | 90.66 | 88.74 | 89.43 | 280473.0 |
| 2014-10-17 | B6 | Futures | 1.6891 | 1.6943 | 1.684 | 1.6925 | 94821.0 |
| 2014-10-17 | BFX | Futures | 3531.8 | 3617.3 | 3531.8 | 3617.3 | 11.0 |
| 2014-10-17 | BR | Futures | 0.21639 | 0.21939 | 0.21588 | 0.21863 | 5114.0 |
| 2014-10-17 | BZ | Futures | 90.09 | 91.31 | 89.41 | 90.09 | 19641.0 |
| 2014-10-17 | C | Futures | 2171.0 | 2183.0 | 2157.0 | 2166.0 | 2910.0 |
| 2014-10-17 | CB | Futures | 136.022 | 136.041 | 133.748 | 133.922 | 20.0 |
| 2014-10-17 | CC | Futures | 2300.0 | 2318.0 | 2287.0 | 2302.0 | 9001.0 |
| 2014-10-17 | CNH | Futures | 7.0652 | 7.0662 | 7.0652 | 7.0662 | 1.0 |
| 2014-10-17 | CSC | Futures | 4.985 | 4.985 | 4.964 | 4.964 | 74.0 |
| 2014-10-17 | CT | Futures | 80.76 | 81.27 | 79.78 | 79.83 | 12494.0 |
| 2014-10-17 | DC | Futures | 40.51 | 40.66 | 40.28 | 40.43 | 218.0 |
| 2014-10-17 | DX | Futures | 80.712 | 81.025 | 80.55 | 80.89 | 26574.0 |
| 2014-10-17 | E1 | Futures | 1.35665 | 1.3601 | 1.35013 | 1.35294 | 32467.0 |
| 2014-10-17 | E6 | Futures | 1.50788 | 1.51164 | 1.5007 | 1.50411 | 175499.0 |
| 2014-10-17 | E7 | Futures | 1.4982 | 1.5021 | 1.4913 | 1.4947 | 3124.0 |
| 2014-10-17 | ED | Futures | 95.4278 | 95.4374 | 95.423 | 95.4326 | 135631.0 |
| 2014-10-17 | ER | Futures | 97.974 | 97.989 | 97.97 | 97.984 | 69339.0 |
| 2014-10-17 | EW | Futures | 1362.0 | 1381.1 | 1359.0 | 1373.2 | 28490.0 |
| 2014-10-17 | FBTP | Futures | 93.62 | 94.47 | 93.14 | 94.29 | 121519.0 |
| 2014-10-17 | FBTS | Futures | 97.789 | 98.286 | 97.638 | 98.179 | 29593.0 |
| 2014-10-17 | FCE | Futures | 3155.7 | 3258.9 | 3145.2 | 3252.1 | 188718.0 |
| 2014-10-17 | FDAX | Futures | 9399.5 | 9702.9 | 9380.3 | 9687.1 | 184762.0 |
| 2014-10-17 | FESX | Futures | 2071.7 | 2142.0 | 2065.2 | 2136.9 | 1931215.0 |
| 2014-10-17 | FGBL | Futures | 133.21 | 133.25 | 132.58 | 132.71 | 951841.0 |
| 2014-10-17 | FGBM | Futures | 123.0 | 123.01 | 122.8 | 122.89 | 551624.0 |
| 2014-10-17 | FGBS | Futures | 110.923 | 110.928 | 110.888 | 110.918 | 223678.0 |
| 2014-10-17 | FGBX | Futures | 146.2 | 146.82 | 144.16 | 144.76 | 34024.0 |
| 2014-10-17 | FMWO | Futures | 5303.8 | 5386.6 | 5303.8 | 5377.8 | 2992.0 |
| 2014-10-17 | FOAT | Futures | 121.83 | 121.9 | 121.12 | 121.5 | 107227.0 |
| 2014-10-17 | FTDX | Futures | 1067.5 | 1107.6 | 1060.8 | 1098.7 | 193.0 |
| 2014-10-17 | FTI | Futures | 328.22 | 338.11 | 327.87 | 337.72 | 66040.0 |
| 2014-10-17 | FTUK | Futures | 4762.1 | 4864.6 | 4752.1 | 4855.3 | 154262.0 |
| 2014-10-17 | FVSA | Futures | 1933.32 | 1974.98 | 1808.32 | 1845.82 | 14046.0 |
| 2014-10-17 | FXXP | Futures | 234.0 | 241.5 | 233.7 | 241.4 | 12807.0 |
| 2014-10-17 | G | Futures | 99.82 | 99.88 | 98.9 | 99.01 | 259813.0 |
| 2014-10-17 | GF | Futures | 370.938 | 370.938 | 366.516 | 366.516 | 2740.0 |
| 2014-10-17 | GSCI | Futures | 920.98 | 922.77 | 914.7 | 917.76 | 176.0 |
| 2014-10-17 | HE | Futures | 120.728 | 123.016 | 120.256 | 121.905 | 12413.0 |
| 2014-10-17 | HG | Futures | 3.7868 | 3.8211 | 3.7437 | 3.8097 | 44456.0 |
| 2014-10-17 | HH | Futures | 45.191 | 45.602 | 45.033 | 45.529 | 6461.0 |
> showing 50 of 105 rows — these rows as CSV