PREVIEW / futures_daily / 2013-08-15
file: by_date/futures_daily/2013/2013-08-15.parquet size: 9 KB rows: 102
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-08-15 | ES | Futures | 1730.85 | 1732.4 | 1703.82 | 1705.36 | 2399533.0 |
| 2013-08-15 | NQ | Futures | 3600.96 | 3602.98 | 3547.17 | 3552.38 | 307034.0 |
| 2013-08-15 | YM | Futures | 15150.8 | 15164.7 | 14922.9 | 14936.7 | 187540.0 |
| 2013-08-15 | CL | Futures | 187.58 | 189.0 | 186.79 | 188.42 | 164958.0 |
| 2013-08-15 | GC | Futures | 1766.7 | 1811.4 | 1743.0 | 1799.9 | 226648.0 |
| 2013-08-15 | ZN | Futures | 113.012114 | 113.082299 | 112.127781 | 112.74541 | 1682284.0 |
| 2013-08-15 | A6 | Futures | 0.85438 | 0.86066 | 0.84809 | 0.85588 | 113265.0 |
| 2013-08-15 | AD | Futures | 0.97379 | 0.97772 | 0.97127 | 0.97741 | 66855.0 |
| 2013-08-15 | B | Futures | 106.78 | 107.91 | 106.78 | 107.47 | 223858.0 |
| 2013-08-15 | B6 | Futures | 1.6249 | 1.6409 | 1.6249 | 1.6396 | 155672.0 |
| 2013-08-15 | BR | Futures | 0.21279 | 0.21279 | 0.20992 | 0.21078 | 293.0 |
| 2013-08-15 | BZ | Futures | 107.8 | 108.68 | 107.65 | 108.26 | 6608.0 |
| 2013-08-15 | C | Futures | 1765.0 | 1766.0 | 1739.0 | 1747.0 | 2955.0 |
| 2013-08-15 | CB | Futures | 68.409 | 69.126 | 68.409 | 68.409 | 30.0 |
| 2013-08-15 | CC | Futures | 1859.0 | 1879.0 | 1842.0 | 1852.0 | 12249.0 |
| 2013-08-15 | CNH | Futures | 7.0788 | 7.0808 | 7.0787 | 7.0808 | 30.0 |
| 2013-08-15 | CSC | Futures | 3.402 | 3.402 | 3.402 | 3.402 | 29.0 |
| 2013-08-15 | CT | Futures | 108.08 | 109.14 | 108.08 | 109.14 | 8.0 |
| 2013-08-15 | DC | Futures | 26.14 | 26.2 | 25.89 | 26.02 | 154.0 |
| 2013-08-15 | DX | Futures | 78.057 | 78.362 | 77.521 | 77.609 | 38705.0 |
| 2013-08-15 | E1 | Futures | 1.3753 | 1.39033 | 1.3681 | 1.38892 | 53160.0 |
| 2013-08-15 | E6 | Futures | 1.56483 | 1.5771 | 1.55857 | 1.57533 | 313774.0 |
| 2013-08-15 | E7 | Futures | 1.5545 | 1.5669 | 1.5484 | 1.5651 | 5494.0 |
| 2013-08-15 | ED | Futures | 95.306 | 95.306 | 95.3012 | 95.3012 | 120057.0 |
| 2013-08-15 | ER | Futures | 97.822 | 97.822 | 97.808 | 97.817 | 50649.0 |
| 2013-08-15 | EW | Futures | 1251.8 | 1251.8 | 1227.7 | 1229.3 | 19717.0 |
| 2013-08-15 | FBTP | Futures | 79.08 | 79.08 | 78.42 | 78.67 | 18387.0 |
| 2013-08-15 | FBTS | Futures | 93.41 | 93.444 | 93.289 | 93.358 | 2258.0 |
| 2013-08-15 | FCE | Futures | 3167.5 | 3171.4 | 3125.5 | 3154.4 | 89912.0 |
| 2013-08-15 | FDAX | Futures | 9342.9 | 9350.1 | 9221.3 | 9298.5 | 95831.0 |
| 2013-08-15 | FESX | Futures | 1998.3 | 2000.4 | 1968.8 | 1988.5 | 921282.0 |
| 2013-08-15 | FGBL | Futures | 118.02 | 118.07 | 117.08 | 117.32 | 758152.0 |
| 2013-08-15 | FGBM | Futures | 116.54 | 116.61 | 116.14 | 116.29 | 427684.0 |
| 2013-08-15 | FGBS | Futures | 110.188 | 110.198 | 110.123 | 110.153 | 405120.0 |
| 2013-08-15 | FGBX | Futures | 120.83 | 121.03 | 119.17 | 119.51 | 12146.0 |
| 2013-08-15 | FMWO | Futures | 4996.5 | 4996.5 | 4952.2 | 4952.2 | 60.0 |
| 2013-08-15 | FOAT | Futures | 106.12 | 106.21 | 105.32 | 105.49 | 30205.0 |
| 2013-08-15 | FTDX | Futures | 977.6 | 981.4 | 967.7 | 971.5 | 120.0 |
| 2013-08-15 | FTI | Futures | 330.39 | 331.0 | 325.63 | 327.68 | 31983.0 |
| 2013-08-15 | FTUK | Futures | 4929.4 | 4931.3 | 4834.2 | 4854.4 | 108300.0 |
| 2013-08-15 | FVSA | Futures | 2568.64 | 2721.7 | 2568.64 | 2655.15 | 5449.0 |
| 2013-08-15 | FXXP | Futures | 226.8 | 226.8 | 223.6 | 225.0 | 10493.0 |
| 2013-08-15 | G | Futures | 92.55 | 92.64 | 91.92 | 92.24 | 196979.0 |
| 2013-08-15 | GF | Futures | 259.302 | 259.549 | 257.823 | 258.275 | 2309.0 |
| 2013-08-15 | GSCI | Futures | 1064.06 | 1068.25 | 1059.29 | 1066.86 | 136.0 |
| 2013-08-15 | HE | Futures | 106.728 | 106.879 | 105.004 | 105.609 | 19530.0 |
| 2013-08-15 | HG | Futures | 4.2398 | 4.2677 | 4.1707 | 4.2347 | 69039.0 |
| 2013-08-15 | HH | Futures | 36.631 | 37.71 | 36.51 | 37.666 | 1581.0 |
| 2013-08-15 | HO | Futures | 2.4515 | 2.4758 | 2.4492 | 2.4677 | 34757.0 |
| 2013-08-15 | HRC | Futures | 2259.4 | 2259.4 | 2259.4 | 2259.4 | 0.0 |
> showing 50 of 102 rows — these rows as CSV