PREVIEW / futures_daily / 2015-12-23
file: by_date/futures_daily/2015/2015-12-23.parquet size: 9 KB rows: 108
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 |
|---|---|---|---|---|---|---|---|
| 2015-12-23 | ES | Futures | 2172.59 | 2197.96 | 2169.12 | 2192.88 | 1003982.0 |
| 2015-12-23 | NQ | Futures | 5381.48 | 5416.35 | 5372.69 | 5400.53 | 147737.0 |
| 2015-12-23 | YM | Futures | 17957.9 | 18126.6 | 17930.0 | 18080.0 | 96588.0 |
| 2015-12-23 | CL | Futures | 54.24 | 56.44 | 53.96 | 55.77 | 374658.0 |
| 2015-12-23 | GC | Futures | 1382.5 | 1386.3 | 1376.9 | 1377.8 | 69363.0 |
| 2015-12-23 | ZN | Futures | 121.520881 | 121.520881 | 121.189966 | 121.295257 | 475286.0 |
| 2015-12-23 | A6 | Futures | 0.72163 | 0.72344 | 0.71953 | 0.72274 | 33152.0 |
| 2015-12-23 | AD | Futures | 0.73474 | 0.73903 | 0.73362 | 0.73791 | 46801.0 |
| 2015-12-23 | ALI | Futures | 2180.5 | 2180.5 | 2180.5 | 2180.5 | 0.0 |
| 2015-12-23 | B | Futures | 31.7 | 33.01 | 31.62 | 32.56 | 196978.0 |
| 2015-12-23 | B6 | Futures | 1.5604 | 1.5681 | 1.5597 | 1.565 | 48572.0 |
| 2015-12-23 | BFX | Futures | 4454.4 | 4488.4 | 4444.6 | 4488.4 | 4.0 |
| 2015-12-23 | BR | Futures | 0.15409 | 0.15535 | 0.15409 | 0.15529 | 1180.0 |
| 2015-12-23 | BZ | Futures | 31.46 | 32.73 | 31.35 | 32.27 | 28728.0 |
| 2015-12-23 | C | Futures | 2341.0 | 2382.0 | 2331.0 | 2380.0 | 7957.0 |
| 2015-12-23 | CB | Futures | 252.03 | 256.05 | 252.03 | 254.69 | 25.0 |
| 2015-12-23 | CC | Futures | 2351.0 | 2405.0 | 2343.0 | 2404.0 | 21645.0 |
| 2015-12-23 | CNH | Futures | 7.2644 | 7.2731 | 7.2644 | 7.27 | 3.0 |
| 2015-12-23 | CSC | Futures | 3.753 | 3.758 | 3.728 | 3.745 | 174.0 |
| 2015-12-23 | CT | Futures | 73.98 | 74.23 | 73.5 | 73.53 | 10998.0 |
| 2015-12-23 | DC | Futures | 29.61 | 29.61 | 29.36 | 29.51 | 164.0 |
| 2015-12-23 | DX | Futures | 91.757 | 92.168 | 91.743 | 91.889 | 16785.0 |
| 2015-12-23 | E1 | Futures | 1.28331 | 1.28331 | 1.2741 | 1.27877 | 11507.0 |
| 2015-12-23 | E6 | Futures | 1.28379 | 1.28391 | 1.27373 | 1.27876 | 119343.0 |
| 2015-12-23 | E7 | Futures | 1.2764 | 1.2765 | 1.2666 | 1.2716 | 3490.0 |
| 2015-12-23 | EBM | Futures | 246.13 | 246.84 | 244.36 | 245.07 | 10332.0 |
| 2015-12-23 | ED | Futures | 95.5639 | 95.5736 | 95.5591 | 95.5591 | 85326.0 |
| 2015-12-23 | ER | Futures | 98.205 | 98.215 | 98.205 | 98.205 | 24002.0 |
| 2015-12-23 | EW | Futures | 1470.2 | 1489.9 | 1470.0 | 1486.8 | 12135.0 |
| 2015-12-23 | FBON | Futures | 115.04 | 115.04 | 114.46 | 114.46 | 385.0 |
| 2015-12-23 | FBTP | Futures | 104.41 | 104.52 | 104.02 | 104.04 | 32200.0 |
| 2015-12-23 | FBTS | Futures | 100.624 | 100.632 | 100.588 | 100.597 | 8214.0 |
| 2015-12-23 | FCE | Futures | 3849.3 | 3927.9 | 3845.9 | 3909.9 | 68872.0 |
| 2015-12-23 | FDAX | Futures | 11459.1 | 11675.4 | 11456.4 | 11649.9 | 71593.0 |
| 2015-12-23 | FDXM | Futures | 10966.4 | 11163.4 | 10955.0 | 11137.5 | 11659.0 |
| 2015-12-23 | FESX | Futures | 2458.2 | 2506.1 | 2458.2 | 2494.7 | 638280.0 |
| 2015-12-23 | FGBL | Futures | 139.62 | 139.75 | 139.09 | 139.12 | 215151.0 |
| 2015-12-23 | FGBM | Futures | 125.53 | 125.59 | 125.36 | 125.38 | 140954.0 |
| 2015-12-23 | FGBS | Futures | 111.423 | 111.438 | 111.398 | 111.403 | 90580.0 |
| 2015-12-23 | FGBX | Futures | 157.56 | 158.01 | 155.71 | 155.91 | 15349.0 |
| 2015-12-23 | FMWO | Futures | 5594.3 | 5631.6 | 5594.3 | 5630.4 | 632.0 |
| 2015-12-23 | FOAT | Futures | 127.83 | 127.93 | 127.3 | 127.32 | 31957.0 |
| 2015-12-23 | FTDX | Futures | 1727.6 | 1743.0 | 1720.9 | 1740.1 | 196.0 |
| 2015-12-23 | FTI | Futures | 379.94 | 389.16 | 379.9 | 387.68 | 27613.0 |
| 2015-12-23 | FTUK | Futures | 4954.3 | 5072.2 | 4950.7 | 5053.4 | 80716.0 |
| 2015-12-23 | FVSA | Futures | 2192.72 | 2197.43 | 2093.91 | 2122.14 | 8448.0 |
| 2015-12-23 | FXXP | Futures | 283.3 | 288.9 | 283.1 | 287.5 | 16820.0 |
| 2015-12-23 | G | Futures | 104.46 | 104.49 | 104.0 | 104.03 | 77035.0 |
| 2015-12-23 | GF | Futures | 307.3 | 314.924 | 307.3 | 314.779 | 3734.0 |
| 2015-12-23 | GSCI | Futures | 484.42 | 491.55 | 484.18 | 489.2 | 61.0 |
> showing 50 of 108 rows — these rows as CSV