PREVIEW / futures_daily / 2012-10-19
file: by_date/futures_daily/2012/2012-10-19.parquet size: 9 KB rows: 98
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 |
|---|---|---|---|---|---|---|---|
| 2012-10-19 | ES | Futures | 1477.06 | 1479.35 | 1448.82 | 1449.32 | 2400959.0 |
| 2012-10-19 | NQ | Futures | 3142.32 | 3149.8 | 3065.23 | 3065.23 | 338284.0 |
| 2012-10-19 | YM | Futures | 13166.0 | 13181.7 | 12934.6 | 12940.5 | 162751.0 |
| 2012-10-19 | CL | Futures | 166.67 | 168.49 | 162.55 | 163.0 | 329814.0 |
| 2012-10-19 | GC | Futures | 2326.3 | 2329.4 | 2291.1 | 2301.8 | 158721.0 |
| 2012-10-19 | ZN | Futures | 115.942315 | 116.436738 | 115.942315 | 116.368068 | 816459.0 |
| 2012-10-19 | A6 | Futures | 0.93798 | 0.93926 | 0.93326 | 0.93444 | 107241.0 |
| 2012-10-19 | AD | Futures | 1.01683 | 1.01814 | 1.0071 | 1.0089 | 90249.0 |
| 2012-10-19 | B | Futures | 102.88 | 103.8 | 100.71 | 100.93 | 231128.0 |
| 2012-10-19 | B6 | Futures | 1.676 | 1.6777 | 1.6702 | 1.672 | 92775.0 |
| 2012-10-19 | BFX | Futures | 2880.2 | 2880.3 | 2860.3 | 2860.9 | 28.0 |
| 2012-10-19 | BR | Futures | 0.23789 | 0.23811 | 0.23789 | 0.23801 | 51.0 |
| 2012-10-19 | BZ | Futures | 107.52 | 107.68 | 104.56 | 104.74 | 624.0 |
| 2012-10-19 | C | Futures | 1622.0 | 1639.0 | 1616.0 | 1636.0 | 7100.0 |
| 2012-10-19 | CB | Futures | 93.224 | 93.224 | 92.863 | 92.863 | 7.0 |
| 2012-10-19 | CC | Futures | 1844.0 | 1884.0 | 1844.0 | 1877.0 | 15508.0 |
| 2012-10-19 | CT | Futures | 100.29 | 100.55 | 98.74 | 99.21 | 15183.0 |
| 2012-10-19 | DC | Futures | 31.47 | 31.5 | 31.26 | 31.37 | 127.0 |
| 2012-10-19 | DX | Futures | 76.932 | 77.242 | 76.879 | 77.187 | 17723.0 |
| 2012-10-19 | E1 | Futures | 1.3932 | 1.39423 | 1.38664 | 1.38754 | 24570.0 |
| 2012-10-19 | E6 | Futures | 1.53969 | 1.54075 | 1.53309 | 1.53439 | 217244.0 |
| 2012-10-19 | E7 | Futures | 1.5308 | 1.5314 | 1.524 | 1.5252 | 3219.0 |
| 2012-10-19 | ED | Futures | 95.254 | 95.254 | 95.2396 | 95.2492 | 112408.0 |
| 2012-10-19 | ER | Futures | 97.862 | 97.866 | 97.857 | 97.866 | 46872.0 |
| 2012-10-19 | EW | Futures | 1016.6 | 1018.4 | 1000.6 | 1001.6 | 29144.0 |
| 2012-10-19 | FBTP | Futures | 73.26 | 73.62 | 73.08 | 73.19 | 15229.0 |
| 2012-10-19 | FBTS | Futures | 89.969 | 90.036 | 89.784 | 89.868 | 2152.0 |
| 2012-10-19 | FCE | Futures | 2653.1 | 2658.0 | 2614.0 | 2633.6 | 103068.0 |
| 2012-10-19 | FDAX | Futures | 8124.6 | 8143.8 | 8030.9 | 8071.5 | 134056.0 |
| 2012-10-19 | FESX | Futures | 1745.7 | 1749.1 | 1715.8 | 1724.6 | 1172116.0 |
| 2012-10-19 | FGBL | Futures | 116.79 | 117.41 | 116.76 | 117.1 | 629559.0 |
| 2012-10-19 | FGBM | Futures | 115.54 | 115.8 | 115.52 | 115.66 | 349118.0 |
| 2012-10-19 | FGBS | Futures | 110.188 | 110.233 | 110.173 | 110.198 | 241327.0 |
| 2012-10-19 | FGBX | Futures | 122.27 | 123.69 | 122.21 | 123.06 | 8182.0 |
| 2012-10-19 | FOAT | Futures | 103.52 | 103.92 | 103.51 | 103.8 | 18883.0 |
| 2012-10-19 | FTDX | Futures | 774.5 | 774.5 | 760.8 | 764.1 | 70.0 |
| 2012-10-19 | FTI | Futures | 286.21 | 287.2 | 284.02 | 285.7 | 34821.0 |
| 2012-10-19 | FTUK | Futures | 4303.1 | 4317.4 | 4270.9 | 4294.7 | 88082.0 |
| 2012-10-19 | FVSA | Futures | 5025.82 | 5116.17 | 4980.65 | 5082.29 | 4132.0 |
| 2012-10-19 | FXXP | Futures | 198.2 | 198.5 | 196.9 | 197.1 | 1614.0 |
| 2012-10-19 | G | Futures | 97.89 | 98.22 | 97.76 | 98.07 | 118578.0 |
| 2012-10-19 | GF | Futures | 286.212 | 287.028 | 284.868 | 284.916 | 1710.0 |
| 2012-10-19 | GSCI | Futures | 1082.53 | 1082.53 | 1059.32 | 1061.99 | 112.0 |
| 2012-10-19 | HE | Futures | 98.382 | 99.19 | 98.196 | 98.973 | 17993.0 |
| 2012-10-19 | HG | Futures | 4.7972 | 4.8159 | 4.661 | 4.6745 | 61609.0 |
| 2012-10-19 | HH | Futures | 46.121 | 46.121 | 46.121 | 46.121 | 3901.0 |
| 2012-10-19 | HO | Futures | 2.5726 | 2.5965 | 2.5232 | 2.5269 | 44740.0 |
| 2012-10-19 | HRC | Futures | 2418.5 | 2418.5 | 2418.5 | 2418.5 | 0.0 |
| 2012-10-19 | J1 | Futures | 0.0157992 | 0.0158267 | 0.0157679 | 0.0157967 | 71038.0 |
| 2012-10-19 | J7 | Futures | 0.01573 | 0.015758 | 0.015701 | 0.01573 | 466.0 |
> showing 50 of 98 rows — these rows as CSV