PREVIEW / futures_daily / 2015-01-27
file: by_date/futures_daily/2015/2015-01-27.parquet size: 9 KB rows: 106
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-01-27 | ES | Futures | 2152.86 | 2153.64 | 2110.14 | 2127.7 | 1957000.0 |
| 2015-01-27 | NQ | Futures | 4950.67 | 4955.6 | 4806.8 | 4847.12 | 363818.0 |
| 2015-01-27 | YM | Futures | 17940.5 | 17954.7 | 17533.1 | 17699.1 | 212587.0 |
| 2015-01-27 | CL | Futures | 86.73 | 89.46 | 86.11 | 88.84 | 313141.0 |
| 2015-01-27 | GC | Futures | 1676.1 | 1697.9 | 1664.4 | 1690.5 | 90039.0 |
| 2015-01-27 | ZN | Futures | 122.057718 | 122.646587 | 122.013553 | 122.16077 | 1182996.0 |
| 2015-01-27 | A6 | Futures | 0.77309 | 0.77867 | 0.77182 | 0.77515 | 73602.0 |
| 2015-01-27 | AD | Futures | 0.81586 | 0.82207 | 0.81412 | 0.82105 | 59511.0 |
| 2015-01-27 | ALI | Futures | 2874.99 | 2874.99 | 2874.99 | 2874.99 | 14.0 |
| 2015-01-27 | B | Futures | 48.88 | 50.61 | 48.41 | 50.23 | 107567.0 |
| 2015-01-27 | B6 | Futures | 1.5855 | 1.6002 | 1.583 | 1.5978 | 97411.0 |
| 2015-01-27 | BFX | Futures | 4296.7 | 4299.1 | 4252.0 | 4259.3 | 27.0 |
| 2015-01-27 | BR | Futures | 0.21128 | 0.21371 | 0.21117 | 0.21244 | 6801.0 |
| 2015-01-27 | BZ | Futures | 48.96 | 50.49 | 48.3 | 50.11 | 16393.0 |
| 2015-01-27 | C | Futures | 2094.0 | 2103.0 | 2078.0 | 2089.0 | 11899.0 |
| 2015-01-27 | CB | Futures | 137.192 | 139.656 | 136.576 | 139.43 | 12.0 |
| 2015-01-27 | CC | Futures | 2024.0 | 2032.0 | 2013.0 | 2024.0 | 18365.0 |
| 2015-01-27 | CNH | Futures | 7.1326 | 7.1326 | 7.1295 | 7.1295 | 1.0 |
| 2015-01-27 | CSC | Futures | 4.418 | 4.421 | 4.347 | 4.35 | 51.0 |
| 2015-01-27 | CT | Futures | 74.56 | 75.21 | 74.13 | 75.07 | 12945.0 |
| 2015-01-27 | DC | Futures | 34.83 | 35.25 | 34.45 | 34.53 | 245.0 |
| 2015-01-27 | DX | Futures | 90.232 | 90.232 | 88.935 | 89.214 | 56996.0 |
| 2015-01-27 | E1 | Futures | 1.42032 | 1.43168 | 1.39631 | 1.42504 | 18112.0 |
| 2015-01-27 | E6 | Futures | 1.32258 | 1.34422 | 1.32082 | 1.33858 | 219755.0 |
| 2015-01-27 | E7 | Futures | 1.3143 | 1.3361 | 1.3128 | 1.3306 | 7620.0 |
| 2015-01-27 | EBM | Futures | 316.71 | 317.11 | 313.06 | 313.46 | 22945.0 |
| 2015-01-27 | ED | Futures | 95.4498 | 95.4594 | 95.4498 | 95.4546 | 130933.0 |
| 2015-01-27 | ER | Futures | 98.043 | 98.053 | 98.038 | 98.053 | 54731.0 |
| 2015-01-27 | EW | Futures | 1538.2 | 1539.6 | 1513.2 | 1530.8 | 19043.0 |
| 2015-01-27 | FBTP | Futures | 101.55 | 101.65 | 101.19 | 101.39 | 92067.0 |
| 2015-01-27 | FBTS | Futures | 99.12 | 99.147 | 99.067 | 99.102 | 16526.0 |
| 2015-01-27 | FCE | Futures | 3822.0 | 3823.6 | 3746.1 | 3772.2 | 132702.0 |
| 2015-01-27 | FDAX | Futures | 12018.4 | 12021.1 | 11763.6 | 11806.9 | 136709.0 |
| 2015-01-27 | FESX | Futures | 2462.7 | 2464.2 | 2414.5 | 2429.6 | 1292705.0 |
| 2015-01-27 | FGBL | Futures | 138.61 | 138.76 | 138.47 | 138.7 | 595361.0 |
| 2015-01-27 | FGBM | Futures | 124.05 | 124.1 | 123.98 | 124.08 | 305444.0 |
| 2015-01-27 | FGBS | Futures | 111.078 | 111.093 | 111.068 | 111.088 | 169228.0 |
| 2015-01-27 | FGBX | Futures | 164.88 | 165.42 | 164.05 | 165.1 | 36168.0 |
| 2015-01-27 | FMWO | Futures | 5642.2 | 5644.6 | 5589.0 | 5598.9 | 540.0 |
| 2015-01-27 | FOAT | Futures | 127.62 | 127.8 | 127.51 | 127.7 | 54326.0 |
| 2015-01-27 | FTDX | Futures | 1404.0 | 1414.3 | 1384.8 | 1386.2 | 403.0 |
| 2015-01-27 | FTI | Futures | 396.57 | 397.3 | 389.51 | 392.11 | 37435.0 |
| 2015-01-27 | FTUK | Futures | 5300.3 | 5308.9 | 5235.6 | 5271.4 | 100967.0 |
| 2015-01-27 | FVSA | Futures | 1880.99 | 2035.94 | 1863.77 | 1992.9 | 17364.0 |
| 2015-01-27 | FXXP | Futures | 281.6 | 281.6 | 276.7 | 278.2 | 11898.0 |
| 2015-01-27 | G | Futures | 105.45 | 105.7 | 105.25 | 105.57 | 182034.0 |
| 2015-01-27 | GF | Futures | 337.562 | 344.943 | 335.496 | 343.846 | 5322.0 |
| 2015-01-27 | GSCI | Futures | 653.31 | 661.24 | 650.9 | 655.9 | 229.0 |
| 2015-01-27 | HE | Futures | 98.202 | 99.577 | 95.519 | 96.659 | 17621.0 |
| 2015-01-27 | HG | Futures | 3.2278 | 3.231 | 3.1071 | 3.1281 | 58051.0 |
> showing 50 of 106 rows — these rows as CSV