PREVIEW / futures_daily / 2014-05-19
file: by_date/futures_daily/2014/2014-05-19.parquet size: 9 KB rows: 104
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-05-19 | ES | Futures | 1941.24 | 1948.22 | 1930.38 | 1947.45 | 1035685.0 |
| 2014-05-19 | NQ | Futures | 4128.73 | 4164.12 | 4104.26 | 4159.23 | 221042.0 |
| 2014-05-19 | YM | Futures | 16533.5 | 16564.6 | 16454.2 | 16548.6 | 101151.0 |
| 2014-05-19 | CL | Futures | 184.95 | 186.43 | 184.66 | 185.73 | 218477.0 |
| 2014-05-19 | GC | Futures | 1703.6 | 1720.4 | 1699.0 | 1704.7 | 108500.0 |
| 2014-05-19 | ZN | Futures | 116.532781 | 116.86598 | 116.503807 | 116.576242 | 950868.0 |
| 2014-05-19 | A6 | Futures | 0.89808 | 0.89837 | 0.89414 | 0.89443 | 37765.0 |
| 2014-05-19 | AD | Futures | 0.93256 | 0.93387 | 0.93164 | 0.93215 | 24629.0 |
| 2014-05-19 | ALI | Futures | 2678.41 | 2678.41 | 2678.41 | 2678.41 | 0.0 |
| 2014-05-19 | B | Futures | 113.68 | 114.21 | 113.15 | 113.22 | 171705.0 |
| 2014-05-19 | B6 | Futures | 1.7677 | 1.7701 | 1.7659 | 1.7672 | 53132.0 |
| 2014-05-19 | BFX | Futures | 3747.7 | 3761.2 | 3747.7 | 3749.6 | 184.0 |
| 2014-05-19 | BR | Futures | 0.23671 | 0.23813 | 0.23671 | 0.23771 | 116.0 |
| 2014-05-19 | BZ | Futures | 115.93 | 116.47 | 115.42 | 115.47 | 7101.0 |
| 2014-05-19 | C | Futures | 1892.0 | 1909.0 | 1879.0 | 1908.0 | 17400.0 |
| 2014-05-19 | CB | Futures | 105.841 | 106.108 | 105.841 | 105.879 | 13.0 |
| 2014-05-19 | CC | Futures | 2147.0 | 2164.0 | 2124.0 | 2161.0 | 15796.0 |
| 2014-05-19 | CSC | Futures | 4.39 | 4.399 | 4.319 | 4.323 | 96.0 |
| 2014-05-19 | CT | Futures | 101.12 | 101.26 | 100.35 | 100.38 | 12240.0 |
| 2014-05-19 | DC | Futures | 35.34 | 35.6 | 34.85 | 34.98 | 258.0 |
| 2014-05-19 | DX | Futures | 76.107 | 76.107 | 75.94 | 76.048 | 10519.0 |
| 2014-05-19 | E1 | Futures | 1.43879 | 1.44149 | 1.43828 | 1.43943 | 18808.0 |
| 2014-05-19 | E6 | Futures | 1.61699 | 1.62136 | 1.61663 | 1.61864 | 118610.0 |
| 2014-05-19 | E7 | Futures | 1.6063 | 1.6104 | 1.606 | 1.6079 | 1519.0 |
| 2014-05-19 | ED | Futures | 95.4162 | 95.4162 | 95.4138 | 95.4162 | 51971.0 |
| 2014-05-19 | ER | Futures | 97.881 | 97.886 | 97.862 | 97.871 | 80684.0 |
| 2014-05-19 | EW | Futures | 1394.7 | 1406.3 | 1386.6 | 1402.2 | 12737.0 |
| 2014-05-19 | FBTP | Futures | 89.05 | 89.23 | 88.08 | 88.42 | 101328.0 |
| 2014-05-19 | FBTS | Futures | 97.46 | 97.522 | 97.223 | 97.276 | 22171.0 |
| 2014-05-19 | FCE | Futures | 3531.4 | 3546.5 | 3499.0 | 3540.9 | 94883.0 |
| 2014-05-19 | FDAX | Futures | 10637.3 | 10694.7 | 10531.3 | 10678.7 | 97724.0 |
| 2014-05-19 | FDIV | Futures | 145.85 | 146.05 | 145.8 | 146.05 | 104.0 |
| 2014-05-19 | FESX | Futures | 2265.7 | 2272.2 | 2242.0 | 2268.6 | 752037.0 |
| 2014-05-19 | FEU3 | Futures | 98.492 | 98.492 | 98.488 | 98.492 | 72.0 |
| 2014-05-19 | FGBL | Futures | 126.28 | 126.49 | 126.05 | 126.22 | 529570.0 |
| 2014-05-19 | FGBM | Futures | 120.78 | 120.86 | 120.67 | 120.75 | 400842.0 |
| 2014-05-19 | FGBS | Futures | 110.683 | 110.703 | 110.673 | 110.688 | 271187.0 |
| 2014-05-19 | FGBX | Futures | 131.64 | 132.09 | 131.24 | 131.56 | 14006.0 |
| 2014-05-19 | FMWO | Futures | 5562.0 | 5601.1 | 5562.0 | 5601.1 | 122.0 |
| 2014-05-19 | FOAT | Futures | 115.76 | 115.86 | 115.4 | 115.52 | 53122.0 |
| 2014-05-19 | FTDX | Futures | 1150.3 | 1150.8 | 1141.9 | 1147.5 | 91.0 |
| 2014-05-19 | FTI | Futures | 344.8 | 346.53 | 343.2 | 346.18 | 24015.0 |
| 2014-05-19 | FTUK | Futures | 5223.2 | 5225.1 | 5174.8 | 5210.6 | 86140.0 |
| 2014-05-19 | FVSA | Futures | 1648.39 | 1690.41 | 1634.38 | 1643.72 | 6351.0 |
| 2014-05-19 | FXXP | Futures | 253.1 | 253.7 | 251.2 | 253.5 | 6444.0 |
| 2014-05-19 | G | Futures | 95.14 | 95.23 | 94.8 | 94.93 | 97067.0 |
| 2014-05-19 | GF | Futures | 296.481 | 300.887 | 296.481 | 300.695 | 4500.0 |
| 2014-05-19 | GSCI | Futures | 1084.8 | 1086.29 | 1081.82 | 1082.82 | 111.0 |
| 2014-05-19 | HE | Futures | 132.971 | 133.92 | 132.274 | 133.223 | 11192.0 |
| 2014-05-19 | HG | Futures | 4.018 | 4.0685 | 4.0129 | 4.0467 | 33826.0 |
> showing 50 of 104 rows — these rows as CSV