PREVIEW / futures_daily / 2015-09-01
file: by_date/futures_daily/2015/2015-09-01.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-01 | ES | Futures | 2083.07 | 2083.87 | 2012.33 | 2030.61 | 2822050.0 |
| 2015-09-01 | NQ | Futures | 4980.64 | 4982.97 | 4808.14 | 4854.84 | 481009.0 |
| 2015-09-01 | YM | Futures | 16932.5 | 16938.7 | 16390.2 | 16521.7 | 297120.0 |
| 2015-09-01 | CL | Futures | 78.45 | 79.71 | 72.01 | 74.06 | 713418.0 |
| 2015-09-01 | GC | Futures | 1463.6 | 1481.0 | 1463.6 | 1471.4 | 128865.0 |
| 2015-09-01 | ZN | Futures | 121.629213 | 122.389303 | 121.584502 | 121.971999 | 156708.0 |
| 2015-09-01 | A6 | Futures | 0.70414 | 0.7082 | 0.69434 | 0.69612 | 103109.0 |
| 2015-09-01 | AD | Futures | 0.77854 | 0.77986 | 0.77107 | 0.77434 | 85062.0 |
| 2015-09-01 | ALI | Futures | 2189.03 | 2189.03 | 2189.03 | 2189.03 | 0.0 |
| 2015-09-01 | B | Futures | 48.66 | 49.16 | 44.66 | 45.64 | 161343.0 |
| 2015-09-01 | B6 | Futures | 1.6149 | 1.6216 | 1.6101 | 1.611 | 103764.0 |
| 2015-09-01 | BFX | Futures | 4102.8 | 4102.8 | 4089.5 | 4097.3 | 2.0 |
| 2015-09-01 | BR | Futures | 0.16346 | 0.16408 | 0.16131 | 0.16155 | 218.0 |
| 2015-09-01 | BZ | Futures | 48.1 | 49.1 | 44.84 | 45.64 | 28422.0 |
| 2015-09-01 | C | Futures | 2230.0 | 2262.0 | 2229.0 | 2262.0 | 6247.0 |
| 2015-09-01 | CB | Futures | 182.75 | 185.013 | 182.75 | 185.013 | 2.0 |
| 2015-09-01 | CC | Futures | 2280.0 | 2306.0 | 2277.0 | 2303.0 | 15874.0 |
| 2015-09-01 | CNH | Futures | 7.2122 | 7.2194 | 7.2088 | 7.2194 | 70.0 |
| 2015-09-01 | CSC | Futures | 4.458 | 4.483 | 4.458 | 4.478 | 8.0 |
| 2015-09-01 | CT | Futures | 77.89 | 77.99 | 77.53 | 77.8 | 5.0 |
| 2015-09-01 | DC | Futures | 35.7 | 35.99 | 35.63 | 35.85 | 46.0 |
| 2015-09-01 | DX | Futures | 89.762 | 89.762 | 89.125 | 89.346 | 53675.0 |
| 2015-09-01 | E1 | Futures | 1.31386 | 1.32745 | 1.31335 | 1.32224 | 20677.0 |
| 2015-09-01 | E6 | Futures | 1.31693 | 1.33162 | 1.31693 | 1.32704 | 245554.0 |
| 2015-09-01 | E7 | Futures | 1.3101 | 1.3241 | 1.31 | 1.3197 | 6378.0 |
| 2015-09-01 | EBM | Futures | 262.33 | 262.74 | 257.41 | 257.82 | 2180.0 |
| 2015-09-01 | ED | Futures | 95.6318 | 95.6462 | 95.6318 | 95.6414 | 176280.0 |
| 2015-09-01 | ER | Futures | 98.126 | 98.131 | 98.122 | 98.126 | 21596.0 |
| 2015-09-01 | EW | Futures | 1474.2 | 1475.2 | 1435.3 | 1444.3 | 31050.0 |
| 2015-09-01 | FBTP | Futures | 100.2 | 100.42 | 99.86 | 99.9 | 93212.0 |
| 2015-09-01 | FBTS | Futures | 100.017 | 100.035 | 99.973 | 100.008 | 28262.0 |
| 2015-09-01 | FCE | Futures | 3817.0 | 3850.9 | 3754.2 | 3802.8 | 150481.0 |
| 2015-09-01 | FDAX | Futures | 11070.6 | 11185.5 | 10928.0 | 11049.6 | 128589.0 |
| 2015-09-01 | FDIV | Futures | 135.39 | 135.39 | 135.11 | 135.11 | 10.0 |
| 2015-09-01 | FESX | Futures | 2367.5 | 2390.4 | 2326.1 | 2354.9 | 1637630.0 |
| 2015-09-01 | FEU3 | Futures | 98.769 | 98.769 | 98.769 | 98.769 | 2.0 |
| 2015-09-01 | FGBL | Futures | 136.53 | 136.84 | 136.19 | 136.45 | 1058415.0 |
| 2015-09-01 | FGBM | Futures | 124.44 | 124.47 | 124.31 | 124.37 | 637530.0 |
| 2015-09-01 | FGBS | Futures | 111.158 | 111.213 | 111.158 | 111.198 | 522745.0 |
| 2015-09-01 | FGBX | Futures | 153.15 | 154.81 | 152.54 | 153.88 | 39187.0 |
| 2015-09-01 | FMWO | Futures | 5360.9 | 5362.1 | 5290.8 | 5324.0 | 1309.0 |
| 2015-09-01 | FOAT | Futures | 124.49 | 124.72 | 124.12 | 124.32 | 74578.0 |
| 2015-09-01 | FTDX | Futures | 1583.0 | 1585.8 | 1553.3 | 1566.5 | 666.0 |
| 2015-09-01 | FTI | Futures | 375.49 | 379.79 | 367.44 | 372.78 | 54394.0 |
| 2015-09-01 | FTUK | Futures | 4872.4 | 4963.4 | 4751.2 | 4805.2 | 185604.0 |
| 2015-09-01 | FVSA | Futures | 2578.44 | 2826.04 | 2548.56 | 2710.78 | 14319.0 |
| 2015-09-01 | FXXP | Futures | 272.9 | 276.0 | 267.7 | 270.8 | 27462.0 |
| 2015-09-01 | G | Futures | 103.53 | 104.0 | 103.33 | 103.79 | 170997.0 |
| 2015-09-01 | GF | Futures | 347.416 | 347.89 | 344.355 | 345.304 | 1546.0 |
| 2015-09-01 | GSCI | Futures | 622.28 | 622.28 | 596.23 | 599.77 | 794.0 |
> showing 50 of 108 rows — these rows as CSV