PREVIEW / futures_daily / 2013-12-02
file: by_date/futures_daily/2013/2013-12-02.parquet size: 9 KB rows: 103
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 |
|---|---|---|---|---|---|---|---|
| 2013-12-02 | ES | Futures | 1855.43 | 1858.25 | 1845.92 | 1848.75 | 1330983.0 |
| 2013-12-02 | NQ | Futures | 4011.8 | 4021.28 | 3993.14 | 4000.32 | 231123.0 |
| 2013-12-02 | YM | Futures | 16015.5 | 16033.4 | 15892.1 | 15917.9 | 118915.0 |
| 2013-12-02 | CL | Futures | 164.02 | 166.45 | 163.76 | 165.99 | 234800.0 |
| 2013-12-02 | GC | Futures | 1655.8 | 1656.6 | 1611.5 | 1617.8 | 146101.0 |
| 2013-12-02 | ZN | Futures | 114.65446 | 114.739431 | 114.215442 | 114.342899 | 191595.0 |
| 2013-12-02 | A6 | Futures | 0.86044 | 0.86516 | 0.8577 | 0.85874 | 84315.0 |
| 2013-12-02 | AD | Futures | 0.95096 | 0.95166 | 0.94803 | 0.94984 | 58575.0 |
| 2013-12-02 | B | Futures | 111.09 | 113.73 | 110.78 | 112.84 | 131570.0 |
| 2013-12-02 | B6 | Futures | 1.7183 | 1.7259 | 1.7154 | 1.716 | 128461.0 |
| 2013-12-02 | BFX | Futures | 3452.1 | 3457.9 | 3452.1 | 3457.9 | 6.0 |
| 2013-12-02 | BR | Futures | 0.21598 | 0.21598 | 0.21495 | 0.21523 | 28.0 |
| 2013-12-02 | BZ | Futures | 113.7 | 115.69 | 112.72 | 114.8 | 9531.0 |
| 2013-12-02 | C | Futures | 1862.0 | 1884.0 | 1857.0 | 1866.0 | 3392.0 |
| 2013-12-02 | CB | Futures | 75.122 | 75.122 | 74.705 | 74.926 | 10.0 |
| 2013-12-02 | CC | Futures | 2078.0 | 2111.0 | 2077.0 | 2088.0 | 11775.0 |
| 2013-12-02 | CSC | Futures | 3.497 | 3.501 | 3.497 | 3.501 | 20.0 |
| 2013-12-02 | CT | Futures | 89.99 | 90.68 | 89.34 | 89.64 | 10661.0 |
| 2013-12-02 | DC | Futures | 26.7 | 26.85 | 26.63 | 26.81 | 155.0 |
| 2013-12-02 | DX | Futures | 76.876 | 77.167 | 76.71 | 77.121 | 19884.0 |
| 2013-12-02 | E1 | Futures | 1.41873 | 1.42117 | 1.41051 | 1.41449 | 36737.0 |
| 2013-12-02 | E6 | Futures | 1.60354 | 1.60684 | 1.59622 | 1.59787 | 182452.0 |
| 2013-12-02 | E7 | Futures | 1.5931 | 1.5965 | 1.586 | 1.5876 | 2505.0 |
| 2013-12-02 | ED | Futures | 95.3686 | 95.371 | 95.3686 | 95.371 | 50239.0 |
| 2013-12-02 | ER | Futures | 97.867 | 97.871 | 97.867 | 97.871 | 24109.0 |
| 2013-12-02 | EW | Futures | 1329.5 | 1340.5 | 1320.3 | 1328.7 | 33340.0 |
| 2013-12-02 | FBTP | Futures | 82.03 | 82.09 | 81.86 | 81.9 | 27409.0 |
| 2013-12-02 | FBTS | Futures | 95.589 | 95.598 | 95.537 | 95.546 | 7547.0 |
| 2013-12-02 | FCE | Futures | 3327.6 | 3342.4 | 3312.9 | 3323.0 | 88278.0 |
| 2013-12-02 | FDAX | Futures | 10440.4 | 10463.7 | 10415.4 | 10439.3 | 73186.0 |
| 2013-12-02 | FESX | Futures | 2161.7 | 2169.4 | 2151.9 | 2158.9 | 603467.0 |
| 2013-12-02 | FGBL | Futures | 120.55 | 120.61 | 120.11 | 120.17 | 752250.0 |
| 2013-12-02 | FGBM | Futures | 118.5 | 118.51 | 118.33 | 118.36 | 446368.0 |
| 2013-12-02 | FGBS | Futures | 110.583 | 110.593 | 110.553 | 110.568 | 288481.0 |
| 2013-12-02 | FGBX | Futures | 121.57 | 121.65 | 120.97 | 121.15 | 20540.0 |
| 2013-12-02 | FMWO | Futures | 5354.7 | 5354.7 | 5354.7 | 5354.7 | 0.0 |
| 2013-12-02 | FOAT | Futures | 108.9 | 108.99 | 108.7 | 108.77 | 44730.0 |
| 2013-12-02 | FTDX | Futures | 1087.8 | 1090.2 | 1084.1 | 1090.2 | 73.0 |
| 2013-12-02 | FTI | Futures | 341.99 | 343.41 | 340.96 | 341.69 | 20910.0 |
| 2013-12-02 | FTUK | Futures | 4985.3 | 4996.9 | 4932.0 | 4945.9 | 98061.0 |
| 2013-12-02 | FVSA | Futures | 1887.93 | 1942.39 | 1887.93 | 1930.29 | 4064.0 |
| 2013-12-02 | FXXP | Futures | 237.3 | 238.0 | 236.1 | 236.7 | 5099.0 |
| 2013-12-02 | G | Futures | 91.96 | 92.02 | 91.41 | 91.47 | 167149.0 |
| 2013-12-02 | GF | Futures | 266.678 | 267.04 | 265.993 | 266.195 | 2313.0 |
| 2013-12-02 | GSCI | Futures | 1032.41 | 1037.72 | 1026.78 | 1034.07 | 489.0 |
| 2013-12-02 | HE | Futures | 109.178 | 109.872 | 108.846 | 109.238 | 13378.0 |
| 2013-12-02 | HG | Futures | 4.0473 | 4.0606 | 4.0019 | 4.0195 | 42781.0 |
| 2013-12-02 | HH | Futures | 39.27 | 39.951 | 39.139 | 39.951 | 10325.0 |
| 2013-12-02 | HO | Futures | 2.4166 | 2.4595 | 2.4097 | 2.4328 | 16722.0 |
| 2013-12-02 | HRC | Futures | 2392.3 | 2392.3 | 2392.3 | 2392.3 | 0.0 |
> showing 50 of 103 rows — these rows as CSV