PREVIEW / futures_daily / 2015-02-05
file: by_date/futures_daily/2015/2015-02-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 |
|---|---|---|---|---|---|---|---|
| 2015-02-05 | ES | Futures | 2122.46 | 2157.83 | 2118.01 | 2153.9 | 1343547.0 |
| 2015-02-05 | NQ | Futures | 4862.78 | 4936.75 | 4851.76 | 4928.34 | 200569.0 |
| 2015-02-05 | YM | Futures | 17847.8 | 18150.3 | 17815.2 | 18112.6 | 132143.0 |
| 2015-02-05 | CL | Futures | 93.53 | 100.12 | 91.01 | 97.01 | 596851.0 |
| 2015-02-05 | GC | Futures | 1661.1 | 1666.5 | 1642.4 | 1651.0 | 113827.0 |
| 2015-02-05 | ZN | Futures | 122.896856 | 123.073516 | 122.16077 | 122.352153 | 1196206.0 |
| 2015-02-05 | A6 | Futures | 0.75791 | 0.76466 | 0.75585 | 0.7628 | 80733.0 |
| 2015-02-05 | AD | Futures | 0.80964 | 0.82136 | 0.80873 | 0.8182 | 67831.0 |
| 2015-02-05 | ALI | Futures | 2877.56 | 2897.14 | 2877.56 | 2897.14 | 6.0 |
| 2015-02-05 | B | Futures | 55.29 | 58.19 | 53.52 | 56.93 | 236907.0 |
| 2015-02-05 | B6 | Futures | 1.5962 | 1.613 | 1.5943 | 1.6116 | 87176.0 |
| 2015-02-05 | BFX | Futures | 4273.8 | 4293.1 | 4267.7 | 4293.1 | 5.0 |
| 2015-02-05 | BR | Futures | 0.20027 | 0.20149 | 0.1987 | 0.20036 | 2437.0 |
| 2015-02-05 | BZ | Futures | 55.19 | 58.02 | 53.37 | 56.79 | 34052.0 |
| 2015-02-05 | C | Futures | 2094.0 | 2115.0 | 2086.0 | 2111.0 | 11726.0 |
| 2015-02-05 | CB | Futures | 155.47 | 155.47 | 152.8 | 152.8 | 61.0 |
| 2015-02-05 | CC | Futures | 2017.0 | 2039.0 | 2013.0 | 2034.0 | 15630.0 |
| 2015-02-05 | CNH | Futures | 7.1495 | 7.1495 | 7.132 | 7.132 | 64.0 |
| 2015-02-05 | CSC | Futures | 4.478 | 4.546 | 4.461 | 4.503 | 56.0 |
| 2015-02-05 | CT | Futures | 77.91 | 79.08 | 77.33 | 78.92 | 31654.0 |
| 2015-02-05 | DC | Futures | 36.42 | 37.14 | 36.21 | 36.84 | 255.0 |
| 2015-02-05 | DX | Futures | 89.603 | 89.607 | 88.561 | 88.724 | 28925.0 |
| 2015-02-05 | E1 | Futures | 1.38201 | 1.39031 | 1.37371 | 1.38648 | 10026.0 |
| 2015-02-05 | E6 | Futures | 1.33411 | 1.35304 | 1.33011 | 1.35022 | 205679.0 |
| 2015-02-05 | E7 | Futures | 1.3257 | 1.3453 | 1.3223 | 1.3422 | 4179.0 |
| 2015-02-05 | EBM | Futures | 302.51 | 307.38 | 301.3 | 303.33 | 21962.0 |
| 2015-02-05 | ED | Futures | 95.445 | 95.4498 | 95.4402 | 95.4498 | 155521.0 |
| 2015-02-05 | ER | Futures | 98.033 | 98.038 | 98.014 | 98.033 | 56505.0 |
| 2015-02-05 | EW | Futures | 1524.1 | 1548.3 | 1521.4 | 1545.1 | 19374.0 |
| 2015-02-05 | FBTP | Futures | 101.06 | 101.57 | 101.03 | 101.39 | 86566.0 |
| 2015-02-05 | FBTS | Futures | 99.147 | 99.271 | 99.085 | 99.235 | 20656.0 |
| 2015-02-05 | FCE | Futures | 3779.6 | 3841.6 | 3775.5 | 3838.3 | 99417.0 |
| 2015-02-05 | FDAX | Futures | 11987.8 | 12137.2 | 11982.3 | 12106.1 | 101808.0 |
| 2015-02-05 | FESX | Futures | 2422.4 | 2461.3 | 2419.5 | 2457.7 | 986671.0 |
| 2015-02-05 | FGBL | Futures | 139.33 | 139.37 | 138.62 | 138.85 | 661776.0 |
| 2015-02-05 | FGBM | Futures | 124.46 | 124.49 | 124.33 | 124.37 | 354666.0 |
| 2015-02-05 | FGBS | Futures | 111.168 | 111.193 | 111.153 | 111.168 | 197468.0 |
| 2015-02-05 | FGBX | Futures | 168.8 | 170.53 | 167.44 | 167.92 | 27286.0 |
| 2015-02-05 | FMWO | Futures | 5659.5 | 5694.1 | 5659.5 | 5684.2 | 1171.0 |
| 2015-02-05 | FOAT | Futures | 127.86 | 127.94 | 127.44 | 127.57 | 111196.0 |
| 2015-02-05 | FTDX | Futures | 1401.2 | 1414.3 | 1401.2 | 1413.9 | 122.0 |
| 2015-02-05 | FTI | Futures | 388.26 | 393.54 | 388.26 | 393.23 | 29869.0 |
| 2015-02-05 | FTUK | Futures | 5280.0 | 5312.8 | 5263.7 | 5303.4 | 77338.0 |
| 2015-02-05 | FVSA | Futures | 2040.25 | 2074.68 | 1971.38 | 1971.38 | 8005.0 |
| 2015-02-05 | FXXP | Futures | 278.4 | 281.3 | 278.4 | 281.0 | 8038.0 |
| 2015-02-05 | G | Futures | 105.49 | 105.66 | 104.95 | 105.0 | 211638.0 |
| 2015-02-05 | GF | Futures | 331.236 | 333.134 | 325.585 | 330.055 | 5315.0 |
| 2015-02-05 | GSCI | Futures | 686.67 | 705.28 | 686.67 | 696.49 | 505.0 |
| 2015-02-05 | HE | Futures | 90.857 | 90.857 | 88.744 | 88.912 | 18265.0 |
| 2015-02-05 | HG | Futures | 3.2977 | 3.3148 | 3.2183 | 3.2964 | 57912.0 |
> showing 50 of 106 rows — these rows as CSV