PREVIEW / futures_daily / 2016-03-29
file: by_date/futures_daily/2016/2016-03-29.parquet size: 9 KB rows: 110
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 |
|---|---|---|---|---|---|---|---|
| 2016-03-29 | ES | Futures | 2177.23 | 2200.32 | 2168.1 | 2198.44 | 1549483.0 |
| 2016-03-29 | NQ | Futures | 5157.99 | 5244.64 | 5139.48 | 5238.48 | 229527.0 |
| 2016-03-29 | YM | Futures | 18135.4 | 18250.8 | 18022.0 | 18235.2 | 133947.0 |
| 2016-03-29 | CL | Futures | 47.73 | 47.92 | 46.02 | 46.47 | 488032.0 |
| 2016-03-29 | GC | Futures | 1576.5 | 1605.0 | 1568.6 | 1595.1 | 199346.0 |
| 2016-03-29 | ZN | Futures | 124.830984 | 125.615515 | 124.755548 | 125.524992 | 1047652.0 |
| 2016-03-29 | A6 | Futures | 0.76049 | 0.77122 | 0.75745 | 0.77031 | 100101.0 |
| 2016-03-29 | AD | Futures | 0.77554 | 0.78361 | 0.7737 | 0.7828 | 68923.0 |
| 2016-03-29 | ALI | Futures | 2054.62 | 2065.61 | 2054.62 | 2058.5 | 10.0 |
| 2016-03-29 | B | Futures | 33.98 | 34.02 | 32.86 | 33.19 | 260397.0 |
| 2016-03-29 | B6 | Futures | 1.5013 | 1.5171 | 1.495 | 1.5142 | 94274.0 |
| 2016-03-29 | BFX | Futures | 3974.0 | 3981.6 | 3954.6 | 3956.4 | 17.0 |
| 2016-03-29 | BR | Futures | 0.17472 | 0.17615 | 0.17472 | 0.17615 | 601.0 |
| 2016-03-29 | BZ | Futures | 33.58 | 33.73 | 32.54 | 32.85 | 24700.0 |
| 2016-03-29 | C | Futures | 2321.0 | 2323.0 | 2299.0 | 2306.0 | 6345.0 |
| 2016-03-29 | CB | Futures | 244.196 | 246.33 | 243.586 | 246.33 | 25.0 |
| 2016-03-29 | CC | Futures | 2167.0 | 2191.0 | 2162.0 | 2175.0 | 10415.0 |
| 2016-03-29 | CNH | Futures | 7.1028 | 7.1057 | 7.0791 | 7.0791 | 31.0 |
| 2016-03-29 | CSC | Futures | 3.615 | 3.615 | 3.615 | 3.615 | 52.0 |
| 2016-03-29 | CT | Futures | 66.54 | 66.54 | 65.72 | 65.9 | 9101.0 |
| 2016-03-29 | DC | Futures | 28.42 | 28.49 | 28.38 | 28.42 | 40.0 |
| 2016-03-29 | DX | Futures | 89.451 | 89.717 | 88.644 | 88.706 | 30016.0 |
| 2016-03-29 | E1 | Futures | 1.29429 | 1.30522 | 1.29115 | 1.30472 | 19367.0 |
| 2016-03-29 | E6 | Futures | 1.30881 | 1.32129 | 1.30555 | 1.32042 | 231419.0 |
| 2016-03-29 | E7 | Futures | 1.3018 | 1.3141 | 1.2985 | 1.3132 | 3995.0 |
| 2016-03-29 | EBM | Futures | 202.67 | 204.92 | 202.35 | 204.6 | 31532.0 |
| 2016-03-29 | ED | Futures | 95.6581 | 95.7015 | 95.6581 | 95.6919 | 276103.0 |
| 2016-03-29 | ER | Futures | 98.259 | 98.264 | 98.249 | 98.259 | 64461.0 |
| 2016-03-29 | EW | Futures | 1492.7 | 1524.9 | 1487.8 | 1524.1 | 23312.0 |
| 2016-03-29 | FBON | Futures | 118.68 | 119.16 | 118.68 | 119.04 | 304.0 |
| 2016-03-29 | FBTP | Futures | 107.43 | 107.97 | 107.41 | 107.83 | 65142.0 |
| 2016-03-29 | FBTS | Futures | 100.988 | 101.033 | 100.979 | 101.015 | 14941.0 |
| 2016-03-29 | FCE | Futures | 3626.3 | 3653.8 | 3608.4 | 3637.6 | 85291.0 |
| 2016-03-29 | FDAX | Futures | 10682.9 | 10735.6 | 10576.1 | 10662.0 | 89612.0 |
| 2016-03-29 | FDXM | Futures | 10291.0 | 10335.4 | 10184.4 | 10266.1 | 22176.0 |
| 2016-03-29 | FESX | Futures | 2284.6 | 2299.4 | 2266.7 | 2283.0 | 912661.0 |
| 2016-03-29 | FEU3 | Futures | 98.912 | 98.912 | 98.912 | 98.912 | 30.0 |
| 2016-03-29 | FGBL | Futures | 145.88 | 146.53 | 145.85 | 146.26 | 459482.0 |
| 2016-03-29 | FGBM | Futures | 127.32 | 127.57 | 127.31 | 127.5 | 376245.0 |
| 2016-03-29 | FGBS | Futures | 111.608 | 111.653 | 111.603 | 111.633 | 164454.0 |
| 2016-03-29 | FGBX | Futures | 173.16 | 174.98 | 173.16 | 174.22 | 29196.0 |
| 2016-03-29 | FMWO | Futures | 5517.1 | 5517.1 | 5489.7 | 5503.4 | 249.0 |
| 2016-03-29 | FOAT | Futures | 133.39 | 134.14 | 133.38 | 133.92 | 57864.0 |
| 2016-03-29 | FTDX | Futures | 1530.9 | 1531.9 | 1514.2 | 1521.4 | 79.0 |
| 2016-03-29 | FTI | Futures | 389.94 | 392.69 | 388.21 | 390.38 | 28814.0 |
| 2016-03-29 | FTUK | Futures | 5003.2 | 5034.1 | 4960.3 | 4983.8 | 100548.0 |
| 2016-03-29 | FVSA | Futures | 2749.64 | 2815.9 | 2699.95 | 2777.25 | 5646.0 |
| 2016-03-29 | FXXP | Futures | 265.6 | 266.7 | 263.7 | 265.3 | 18038.0 |
| 2016-03-29 | G | Futures | 108.37 | 108.81 | 108.33 | 108.63 | 123381.0 |
| 2016-03-29 | GF | Futures | 305.428 | 307.538 | 304.594 | 306.409 | 2045.0 |
> showing 50 of 110 rows — these rows as CSV