PREVIEW / futures_daily / 2015-12-24
file: by_date/futures_daily/2015/2015-12-24.parquet size: 9 KB rows: 92
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-12-24 | ES | Futures | 2192.62 | 2200.09 | 2188.61 | 2191.01 | 325205.0 |
| 2015-12-24 | NQ | Futures | 5401.7 | 5427.78 | 5393.49 | 5405.51 | 62054.0 |
| 2015-12-24 | YM | Futures | 18086.2 | 18124.5 | 18043.8 | 18056.2 | 32084.0 |
| 2015-12-24 | CL | Futures | 56.31 | 56.93 | 55.6 | 56.67 | 205873.0 |
| 2015-12-24 | GC | Futures | 1379.4 | 1388.5 | 1379.3 | 1387.6 | 49685.0 |
| 2015-12-24 | ZN | Futures | 121.340382 | 121.475756 | 121.250132 | 121.460714 | 180131.0 |
| 2015-12-24 | A6 | Futures | 0.72163 | 0.72745 | 0.72143 | 0.72614 | 26007.0 |
| 2015-12-24 | AD | Futures | 0.73842 | 0.74006 | 0.73709 | 0.73832 | 17954.0 |
| 2015-12-24 | ALI | Futures | 2203.52 | 2203.52 | 2203.52 | 2203.52 | 0.0 |
| 2015-12-24 | B | Futures | 32.92 | 33.21 | 32.17 | 33.02 | 111015.0 |
| 2015-12-24 | B6 | Futures | 1.5653 | 1.5729 | 1.565 | 1.571 | 27590.0 |
| 2015-12-24 | BR | Futures | 0.15529 | 0.15598 | 0.15529 | 0.15598 | 917.0 |
| 2015-12-24 | BZ | Futures | 32.59 | 32.91 | 31.9 | 32.73 | 12069.0 |
| 2015-12-24 | C | Futures | 2372.0 | 2387.0 | 2370.0 | 2383.0 | 3956.0 |
| 2015-12-24 | CB | Futures | 255.432 | 255.432 | 255.432 | 255.432 | 2.0 |
| 2015-12-24 | CC | Futures | 2397.0 | 2410.0 | 2365.0 | 2367.0 | 11217.0 |
| 2015-12-24 | CNH | Futures | 7.2622 | 7.2698 | 7.2615 | 7.2615 | 4.0 |
| 2015-12-24 | CSC | Futures | 3.733 | 3.77 | 3.733 | 3.77 | 46.0 |
| 2015-12-24 | CT | Futures | 73.59 | 74.9 | 73.48 | 74.57 | 7679.0 |
| 2015-12-24 | DC | Futures | 29.33 | 29.7 | 29.33 | 29.7 | 55.0 |
| 2015-12-24 | DX | Futures | 91.911 | 91.911 | 91.486 | 91.561 | 9145.0 |
| 2015-12-24 | E1 | Futures | 1.2794 | 1.28622 | 1.27839 | 1.28344 | 4405.0 |
| 2015-12-24 | E6 | Futures | 1.27829 | 1.28519 | 1.27783 | 1.28344 | 51303.0 |
| 2015-12-24 | E7 | Futures | 1.2709 | 1.278 | 1.2707 | 1.2762 | 1749.0 |
| 2015-12-24 | EBM | Futures | 244.72 | 246.48 | 244.36 | 245.78 | 1727.0 |
| 2015-12-24 | ED | Futures | 95.5639 | 95.5736 | 95.5543 | 95.5639 | 56028.0 |
| 2015-12-24 | ER | Futures | 98.205 | 98.21 | 98.205 | 98.21 | 2483.0 |
| 2015-12-24 | EW | Futures | 1487.2 | 1494.8 | 1483.4 | 1487.6 | 6127.0 |
| 2015-12-24 | FCE | Futures | 3908.2 | 3917.0 | 3889.8 | 3900.7 | 9193.0 |
| 2015-12-24 | FTI | Futures | 387.76 | 388.99 | 386.28 | 388.03 | 3002.0 |
| 2015-12-24 | FTUK | Futures | 5064.8 | 5072.6 | 5044.9 | 5066.9 | 13961.0 |
| 2015-12-24 | G | Futures | 104.09 | 104.27 | 104.03 | 104.24 | 12383.0 |
| 2015-12-24 | GF | Futures | 314.972 | 316.372 | 309.278 | 315.552 | 1625.0 |
| 2015-12-24 | GSCI | Futures | 490.45 | 492.96 | 490.45 | 492.96 | 11.0 |
| 2015-12-24 | HE | Futures | 84.074 | 85.15 | 83.5 | 83.643 | 5647.0 |
| 2015-12-24 | HG | Futures | 2.6677 | 2.6752 | 2.647 | 2.6633 | 15954.0 |
| 2015-12-24 | HH | Futures | 21.791 | 22.039 | 21.424 | 21.899 | 1613.0 |
| 2015-12-24 | HO | Futures | 0.8917 | 0.897 | 0.87 | 0.8745 | 9954.0 |
| 2015-12-24 | HRC | Futures | 1355.1 | 1355.1 | 1355.1 | 1355.1 | 0.0 |
| 2015-12-24 | J1 | Futures | 0.0103278 | 0.0103851 | 0.0103209 | 0.0103795 | 54336.0 |
| 2015-12-24 | J7 | Futures | 0.010318 | 0.010381 | 0.010318 | 0.010375 | 478.0 |
| 2015-12-24 | JB | Futures | 135.55 | 135.55 | 135.44 | 135.47 | 549.0 |
| 2015-12-24 | KC | Futures | 182.54 | 183.14 | 179.37 | 180.58 | 4811.0 |
| 2015-12-24 | KE | Futures | 1335.58 | 1345.57 | 1334.15 | 1335.58 | 3798.0 |
| 2015-12-24 | L | Futures | 99.165 | 99.175 | 99.155 | 99.165 | 7817.0 |
| 2015-12-24 | LBS | Futures | 402.9 | 403.8 | 400.2 | 400.9 | 122.0 |
| 2015-12-24 | LE | Futures | 166.797 | 169.762 | 165.407 | 169.298 | 18188.0 |
| 2015-12-24 | MFC | Futures | 4559.2 | 4569.0 | 4559.2 | 4569.0 | 4.0 |
| 2015-12-24 | MFS | Futures | 1684.4 | 1693.6 | 1682.8 | 1688.6 | 3392.0 |
| 2015-12-24 | MGC | Futures | 1378.8 | 1386.7 | 1377.7 | 1385.8 | 896.0 |
> showing 50 of 92 rows — these rows as CSV