PREVIEW / futures_daily / 2015-09-22
file: by_date/futures_daily/2015/2015-09-22.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-09-22 | ES | Futures | 2089.47 | 2090.27 | 2040.01 | 2055.17 | 1985152.0 |
| 2015-09-22 | NQ | Futures | 5076.7 | 5080.21 | 4934.64 | 4989.31 | 320027.0 |
| 2015-09-22 | YM | Futures | 16988.2 | 16993.4 | 16627.1 | 16744.7 | 200144.0 |
| 2015-09-22 | CL | Futures | 74.99 | 75.07 | 72.87 | 74.46 | 345875.0 |
| 2015-09-22 | GC | Futures | 1462.1 | 1466.6 | 1446.4 | 1452.0 | 117435.0 |
| 2015-09-22 | ZN | Futures | 122.045114 | 122.79349 | 122.030146 | 122.718652 | 947065.0 |
| 2015-09-22 | A6 | Futures | 0.71013 | 0.71283 | 0.70263 | 0.70573 | 64927.0 |
| 2015-09-22 | AD | Futures | 0.77271 | 0.77455 | 0.76984 | 0.77199 | 45323.0 |
| 2015-09-22 | ALI | Futures | 2160.65 | 2160.65 | 2160.65 | 2160.65 | 0.0 |
| 2015-09-22 | B | Futures | 43.96 | 44.6 | 43.23 | 44.48 | 185413.0 |
| 2015-09-22 | B6 | Futures | 1.6325 | 1.6347 | 1.6149 | 1.6176 | 85532.0 |
| 2015-09-22 | BFX | Futures | 4071.3 | 4071.3 | 4032.6 | 4032.6 | 7.0 |
| 2015-09-22 | BR | Futures | 0.14899 | 0.14949 | 0.14788 | 0.14825 | 1135.0 |
| 2015-09-22 | BZ | Futures | 43.97 | 44.6 | 43.23 | 44.48 | 17143.0 |
| 2015-09-22 | C | Futures | 2361.0 | 2385.0 | 2358.0 | 2382.0 | 8037.0 |
| 2015-09-22 | CB | Futures | 192.197 | 193.181 | 192.197 | 193.108 | 9.0 |
| 2015-09-22 | CC | Futures | 2428.0 | 2440.0 | 2404.0 | 2429.0 | 15685.0 |
| 2015-09-22 | CNH | Futures | 7.1753 | 7.1888 | 7.1721 | 7.1888 | 130.0 |
| 2015-09-22 | CSC | Futures | 4.307 | 4.335 | 4.273 | 4.325 | 34.0 |
| 2015-09-22 | CT | Futures | 73.42 | 74.26 | 71.67 | 71.87 | 66.0 |
| 2015-09-22 | DC | Futures | 34.37 | 34.77 | 34.28 | 34.7 | 140.0 |
| 2015-09-22 | DX | Futures | 89.85 | 90.327 | 89.701 | 90.202 | 30284.0 |
| 2015-09-22 | E1 | Futures | 1.3089 | 1.31055 | 1.30434 | 1.30484 | 11707.0 |
| 2015-09-22 | E6 | Futures | 1.31259 | 1.3147 | 1.30357 | 1.3058 | 198403.0 |
| 2015-09-22 | E7 | Futures | 1.3053 | 1.3076 | 1.2965 | 1.2986 | 4346.0 |
| 2015-09-22 | EBM | Futures | 248.46 | 251.01 | 246.99 | 250.65 | 21063.0 |
| 2015-09-22 | ED | Futures | 95.7015 | 95.7256 | 95.6967 | 95.7208 | 296983.0 |
| 2015-09-22 | ER | Futures | 98.122 | 98.146 | 98.122 | 98.141 | 106096.0 |
| 2015-09-22 | EW | Futures | 1495.6 | 1495.6 | 1462.2 | 1470.4 | 16265.0 |
| 2015-09-22 | FBTP | Futures | 101.83 | 102.36 | 101.74 | 102.27 | 79883.0 |
| 2015-09-22 | FBTS | Futures | 100.239 | 100.293 | 100.222 | 100.275 | 16678.0 |
| 2015-09-22 | FCE | Futures | 3818.7 | 3824.1 | 3667.9 | 3680.8 | 147125.0 |
| 2015-09-22 | FDAX | Futures | 11003.8 | 11034.6 | 10526.3 | 10539.0 | 152903.0 |
| 2015-09-22 | FDIV | Futures | 130.48 | 130.48 | 127.25 | 127.25 | 36.0 |
| 2015-09-22 | FESX | Futures | 2384.8 | 2390.0 | 2289.6 | 2295.6 | 1461484.0 |
| 2015-09-22 | FEU3 | Futures | 98.779 | 98.789 | 98.779 | 98.789 | 8020.0 |
| 2015-09-22 | FGBL | Futures | 137.9 | 138.97 | 137.83 | 138.87 | 717820.0 |
| 2015-09-22 | FGBM | Futures | 125.0 | 125.3 | 124.98 | 125.26 | 556051.0 |
| 2015-09-22 | FGBS | Futures | 111.263 | 111.338 | 111.263 | 111.328 | 421952.0 |
| 2015-09-22 | FGBX | Futures | 156.12 | 158.96 | 155.86 | 158.51 | 31268.0 |
| 2015-09-22 | FMWO | Futures | 5351.7 | 5351.7 | 5297.3 | 5302.2 | 565.0 |
| 2015-09-22 | FOAT | Futures | 126.24 | 127.16 | 126.15 | 127.09 | 70717.0 |
| 2015-09-22 | FTDX | Futures | 1658.1 | 1658.1 | 1604.0 | 1611.6 | 265.0 |
| 2015-09-22 | FTI | Futures | 376.34 | 377.03 | 363.79 | 364.44 | 53437.0 |
| 2015-09-22 | FTUK | Futures | 4888.9 | 4898.5 | 4738.9 | 4750.2 | 139064.0 |
| 2015-09-22 | FVSA | Futures | 2362.58 | 2579.88 | 2348.71 | 2547.51 | 17427.0 |
| 2015-09-22 | FXXP | Futures | 278.2 | 278.2 | 269.0 | 269.1 | 27442.0 |
| 2015-09-22 | G | Futures | 104.36 | 105.24 | 104.33 | 105.19 | 259141.0 |
| 2015-09-22 | GF | Futures | 332.027 | 335.001 | 330.961 | 331.805 | 3820.0 |
| 2015-09-22 | GSCI | Futures | 585.73 | 592.02 | 584.35 | 591.28 | 75.0 |
> showing 50 of 108 rows — these rows as CSV