PREVIEW / futures_daily / 2015-09-23
file: by_date/futures_daily/2015/2015-09-23.parquet size: 9 KB rows: 107
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-09-23 | ES | Futures | 2053.57 | 2065.54 | 2032.3 | 2051.45 | 1423965.0 |
| 2015-09-23 | NQ | Futures | 4985.8 | 5019.12 | 4935.81 | 4984.04 | 238547.0 |
| 2015-09-23 | YM | Futures | 16736.5 | 16840.7 | 16575.5 | 16701.4 | 172149.0 |
| 2015-09-23 | CL | Futures | 74.75 | 75.73 | 71.33 | 71.44 | 411957.0 |
| 2015-09-23 | GC | Futures | 1450.7 | 1463.9 | 1447.2 | 1460.6 | 96165.0 |
| 2015-09-23 | ZN | Futures | 122.658782 | 122.943165 | 122.404334 | 122.583944 | 914624.0 |
| 2015-09-23 | A6 | Futures | 0.70543 | 0.70563 | 0.69593 | 0.69713 | 64533.0 |
| 2015-09-23 | AD | Futures | 0.77127 | 0.77373 | 0.76636 | 0.76779 | 75352.0 |
| 2015-09-23 | ALI | Futures | 2144.53 | 2144.53 | 2144.53 | 2144.53 | 0.0 |
| 2015-09-23 | B | Futures | 44.48 | 45.54 | 43.21 | 43.28 | 232269.0 |
| 2015-09-23 | B6 | Futures | 1.617 | 1.6173 | 1.6022 | 1.6065 | 102343.0 |
| 2015-09-23 | BFX | Futures | 4045.9 | 4079.8 | 4042.9 | 4042.9 | 7.0 |
| 2015-09-23 | BR | Futures | 0.14949 | 0.14949 | 0.14361 | 0.14542 | 380.0 |
| 2015-09-23 | BZ | Futures | 44.45 | 45.55 | 43.2 | 43.27 | 22344.0 |
| 2015-09-23 | C | Futures | 2382.0 | 2403.0 | 2381.0 | 2402.0 | 9781.0 |
| 2015-09-23 | CB | Futures | 194.608 | 196.823 | 194.608 | 196.724 | 20.0 |
| 2015-09-23 | CC | Futures | 2429.0 | 2436.0 | 2409.0 | 2431.0 | 15045.0 |
| 2015-09-23 | CNH | Futures | 7.1925 | 7.213 | 7.1882 | 7.2101 | 12.0 |
| 2015-09-23 | CSC | Futures | 4.268 | 4.342 | 4.268 | 4.299 | 80.0 |
| 2015-09-23 | CT | Futures | 71.89 | 72.91 | 71.56 | 71.83 | 14.0 |
| 2015-09-23 | DC | Futures | 34.59 | 34.97 | 34.32 | 34.77 | 175.0 |
| 2015-09-23 | DX | Futures | 90.276 | 90.454 | 89.958 | 89.978 | 40598.0 |
| 2015-09-23 | E1 | Futures | 1.30472 | 1.30675 | 1.29774 | 1.30155 | 14264.0 |
| 2015-09-23 | E6 | Futures | 1.30498 | 1.3154 | 1.30264 | 1.31458 | 223155.0 |
| 2015-09-23 | E7 | Futures | 1.2981 | 1.3079 | 1.2954 | 1.3073 | 4779.0 |
| 2015-09-23 | EBM | Futures | 252.47 | 256.86 | 252.47 | 255.4 | 31985.0 |
| 2015-09-23 | ED | Futures | 95.7208 | 95.7304 | 95.7111 | 95.7111 | 105845.0 |
| 2015-09-23 | ER | Futures | 98.146 | 98.146 | 98.131 | 98.136 | 45075.0 |
| 2015-09-23 | EW | Futures | 1468.9 | 1479.3 | 1459.1 | 1464.7 | 13759.0 |
| 2015-09-23 | FBTP | Futures | 102.41 | 102.56 | 102.16 | 102.34 | 72652.0 |
| 2015-09-23 | FBTS | Futures | 100.293 | 100.32 | 100.248 | 100.311 | 25173.0 |
| 2015-09-23 | FCE | Futures | 3658.3 | 3731.6 | 3651.2 | 3684.5 | 109286.0 |
| 2015-09-23 | FDAX | Futures | 10474.0 | 10696.5 | 10444.3 | 10595.7 | 111552.0 |
| 2015-09-23 | FDIV | Futures | 126.78 | 127.2 | 126.78 | 127.2 | 5.0 |
| 2015-09-23 | FESX | Futures | 2285.1 | 2334.6 | 2275.4 | 2301.6 | 1071218.0 |
| 2015-09-23 | FGBL | Futures | 138.99 | 139.04 | 138.56 | 138.74 | 495245.0 |
| 2015-09-23 | FGBM | Futures | 125.29 | 125.31 | 125.15 | 125.2 | 316622.0 |
| 2015-09-23 | FGBS | Futures | 111.338 | 111.343 | 111.288 | 111.298 | 283502.0 |
| 2015-09-23 | FGBX | Futures | 159.1 | 159.24 | 157.47 | 158.45 | 26588.0 |
| 2015-09-23 | FMWO | Futures | 5323.2 | 5338.1 | 5309.6 | 5309.6 | 587.0 |
| 2015-09-23 | FOAT | Futures | 127.24 | 127.33 | 126.83 | 126.98 | 52880.0 |
| 2015-09-23 | FTDX | Futures | 1611.1 | 1631.5 | 1599.2 | 1626.8 | 184.0 |
| 2015-09-23 | FTI | Futures | 363.44 | 369.52 | 361.01 | 363.79 | 39171.0 |
| 2015-09-23 | FTUK | Futures | 4731.7 | 4852.7 | 4716.0 | 4826.2 | 120057.0 |
| 2015-09-23 | FVSA | Futures | 2496.66 | 2575.25 | 2464.29 | 2510.53 | 5445.0 |
| 2015-09-23 | FXXP | Futures | 267.4 | 272.4 | 267.2 | 269.3 | 19196.0 |
| 2015-09-23 | G | Futures | 105.17 | 105.17 | 104.86 | 104.97 | 150451.0 |
| 2015-09-23 | GF | Futures | 330.073 | 330.251 | 323.815 | 323.815 | 3825.0 |
| 2015-09-23 | GSCI | Futures | 597.65 | 598.79 | 582.96 | 582.96 | 327.0 |
| 2015-09-23 | HE | Futures | 97.441 | 97.964 | 95.496 | 96.057 | 12036.0 |
> showing 50 of 107 rows — these rows as CSV