PREVIEW / futures_daily / 2014-03-05
file: by_date/futures_daily/2014/2014-03-05.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 |
|---|---|---|---|---|---|---|---|
| 2014-03-05 | ES | Futures | 1928.47 | 1933.37 | 1925.38 | 1930.28 | 1254803.0 |
| 2014-03-05 | NQ | Futures | 4274.82 | 4290.91 | 4267.92 | 4286.02 | 205524.0 |
| 2014-03-05 | YM | Futures | 16353.2 | 16379.1 | 16304.2 | 16329.2 | 129277.0 |
| 2014-03-05 | CL | Futures | 183.91 | 184.23 | 179.46 | 180.53 | 267837.0 |
| 2014-03-05 | GC | Futures | 1759.5 | 1769.0 | 1756.8 | 1766.8 | 97109.0 |
| 2014-03-05 | ZN | Futures | 115.292618 | 115.421389 | 115.078 | 115.321234 | 60130.0 |
| 2014-03-05 | A6 | Futures | 0.85244 | 0.85854 | 0.85082 | 0.85539 | 70845.0 |
| 2014-03-05 | AD | Futures | 0.91228 | 0.91835 | 0.91147 | 0.91724 | 58338.0 |
| 2014-03-05 | B | Futures | 111.77 | 112.07 | 110.17 | 110.38 | 141229.0 |
| 2014-03-05 | B6 | Futures | 1.7501 | 1.7586 | 1.7496 | 1.7557 | 91588.0 |
| 2014-03-05 | BFX | Futures | 3748.5 | 3757.6 | 3748.5 | 3757.6 | 323.0 |
| 2014-03-05 | BR | Futures | 0.22088 | 0.22214 | 0.22061 | 0.22196 | 33.0 |
| 2014-03-05 | BZ | Futures | 114.1 | 114.29 | 112.4 | 112.59 | 7692.0 |
| 2014-03-05 | C | Futures | 1927.0 | 1938.0 | 1920.0 | 1935.0 | 19059.0 |
| 2014-03-05 | CB | Futures | 91.385 | 91.638 | 91.385 | 91.638 | 27.0 |
| 2014-03-05 | CC | Futures | 2191.0 | 2210.0 | 2186.0 | 2205.0 | 7251.0 |
| 2014-03-05 | CNH | Futures | 7.0517 | 7.054 | 7.0491 | 7.0491 | 16.0 |
| 2014-03-05 | CSC | Futures | 4.274 | 4.319 | 4.274 | 4.283 | 50.0 |
| 2014-03-05 | CT | Futures | 100.14 | 100.67 | 99.29 | 99.59 | 8745.0 |
| 2014-03-05 | DC | Futures | 33.78 | 34.32 | 33.78 | 34.13 | 93.0 |
| 2014-03-05 | DX | Futures | 76.21 | 76.348 | 76.134 | 76.188 | 15257.0 |
| 2014-03-05 | E1 | Futures | 1.44662 | 1.44893 | 1.44328 | 1.44623 | 26121.0 |
| 2014-03-05 | E6 | Futures | 1.62195 | 1.62313 | 1.61805 | 1.62088 | 159592.0 |
| 2014-03-05 | E7 | Futures | 1.6111 | 1.6124 | 1.6076 | 1.6103 | 4106.0 |
| 2014-03-05 | EBM | Futures | 288.53 | 291.7 | 288.53 | 289.94 | 23926.0 |
| 2014-03-05 | ED | Futures | 95.3853 | 95.3853 | 95.3829 | 95.3853 | 44693.0 |
| 2014-03-05 | ER | Futures | 97.881 | 97.886 | 97.871 | 97.871 | 87747.0 |
| 2014-03-05 | EW | Futures | 1416.7 | 1421.1 | 1411.7 | 1413.9 | 14821.0 |
| 2014-03-05 | FBTP | Futures | 86.27 | 86.68 | 86.27 | 86.62 | 52384.0 |
| 2014-03-05 | FBTS | Futures | 96.915 | 97.073 | 96.897 | 97.056 | 16223.0 |
| 2014-03-05 | FCE | Futures | 3396.3 | 3410.6 | 3390.5 | 3400.6 | 107761.0 |
| 2014-03-05 | FDAX | Futures | 10598.8 | 10649.8 | 10562.7 | 10576.6 | 78908.0 |
| 2014-03-05 | FESX | Futures | 2201.3 | 2214.0 | 2197.1 | 2204.8 | 757540.0 |
| 2014-03-05 | FEU3 | Futures | 98.497 | 98.497 | 98.488 | 98.488 | 1.0 |
| 2014-03-05 | FGBL | Futures | 123.19 | 123.25 | 122.93 | 123.2 | 682862.0 |
| 2014-03-05 | FGBM | Futures | 119.54 | 119.63 | 119.45 | 119.6 | 531258.0 |
| 2014-03-05 | FGBS | Futures | 110.618 | 110.633 | 110.593 | 110.603 | 257607.0 |
| 2014-03-05 | FGBX | Futures | 126.05 | 126.18 | 125.52 | 126.09 | 15433.0 |
| 2014-03-05 | FMWO | Futures | 5520.2 | 5520.2 | 5520.2 | 5520.2 | 24.0 |
| 2014-03-05 | FOAT | Futures | 111.8 | 111.83 | 111.49 | 111.81 | 64994.0 |
| 2014-03-05 | FTDX | Futures | 1197.2 | 1204.7 | 1194.4 | 1202.8 | 157.0 |
| 2014-03-05 | FTI | Futures | 340.02 | 341.25 | 339.55 | 340.4 | 20890.0 |
| 2014-03-05 | FTUK | Futures | 5139.5 | 5147.1 | 5105.5 | 5109.3 | 84749.0 |
| 2014-03-05 | FVSA | Futures | 1846.52 | 1851.5 | 1811.68 | 1851.5 | 5025.0 |
| 2014-03-05 | FXXP | Futures | 246.7 | 248.1 | 246.6 | 247.2 | 3992.0 |
| 2014-03-05 | G | Futures | 93.43 | 93.46 | 93.06 | 93.27 | 159136.0 |
| 2014-03-05 | GF | Futures | 278.439 | 280.736 | 274.569 | 277.673 | 3256.0 |
| 2014-03-05 | GSCI | Futures | 1075.35 | 1075.35 | 1063.21 | 1064.44 | 88.0 |
| 2014-03-05 | HE | Futures | 135.959 | 138.495 | 131.943 | 133.725 | 42686.0 |
| 2014-03-05 | HG | Futures | 4.0693 | 4.1003 | 4.0566 | 4.0585 | 35567.0 |
> showing 50 of 106 rows — these rows as CSV