PREVIEW / futures_daily / 2013-11-12
file: by_date/futures_daily/2013/2013-11-12.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 |
|---|---|---|---|---|---|---|---|
| 2013-11-12 | ES | Futures | 1815.88 | 1817.93 | 1806.38 | 1813.05 | 1419105.0 |
| 2013-11-12 | NQ | Futures | 3853.02 | 3866.8 | 3840.39 | 3864.22 | 196199.0 |
| 2013-11-12 | YM | Futures | 15649.3 | 15673.2 | 15578.6 | 15631.4 | 116723.0 |
| 2013-11-12 | CL | Futures | 169.03 | 169.42 | 165.23 | 165.55 | 353689.0 |
| 2013-11-12 | GC | Futures | 1694.7 | 1700.0 | 1667.1 | 1681.2 | 146536.0 |
| 2013-11-12 | ZN | Futures | 114.215442 | 114.286252 | 113.946367 | 114.116309 | 889123.0 |
| 2013-11-12 | A6 | Futures | 0.8815 | 0.88282 | 0.87338 | 0.87612 | 77961.0 |
| 2013-11-12 | AD | Futures | 0.96419 | 0.9648 | 0.96076 | 0.96237 | 45022.0 |
| 2013-11-12 | B | Futures | 106.17 | 107.06 | 105.22 | 105.5 | 247490.0 |
| 2013-11-12 | B6 | Futures | 1.6779 | 1.6782 | 1.6637 | 1.6676 | 105913.0 |
| 2013-11-12 | BFX | Futures | 3496.9 | 3496.9 | 3476.8 | 3476.8 | 61.0 |
| 2013-11-12 | BR | Futures | 0.21616 | 0.21858 | 0.21555 | 0.21703 | 245.0 |
| 2013-11-12 | BZ | Futures | 106.62 | 107.76 | 105.9 | 106.2 | 9239.0 |
| 2013-11-12 | C | Futures | 1768.0 | 1821.0 | 1767.0 | 1798.0 | 3807.0 |
| 2013-11-12 | CB | Futures | 71.817 | 71.937 | 71.697 | 71.937 | 4.0 |
| 2013-11-12 | CC | Futures | 1930.0 | 1952.0 | 1912.0 | 1946.0 | 18846.0 |
| 2013-11-12 | CSC | Futures | 3.426 | 3.426 | 3.426 | 3.426 | 5.0 |
| 2013-11-12 | CT | Futures | 90.19 | 92.02 | 90.19 | 91.36 | 26037.0 |
| 2013-11-12 | DC | Futures | 26.4 | 26.56 | 26.1 | 26.17 | 333.0 |
| 2013-11-12 | DX | Futures | 77.358 | 77.696 | 77.253 | 77.417 | 21324.0 |
| 2013-11-12 | E1 | Futures | 1.39753 | 1.40408 | 1.39316 | 1.39984 | 30352.0 |
| 2013-11-12 | E6 | Futures | 1.58206 | 1.58808 | 1.57651 | 1.58465 | 230321.0 |
| 2013-11-12 | E7 | Futures | 1.5721 | 1.5778 | 1.5665 | 1.5744 | 3812.0 |
| 2013-11-12 | ED | Futures | 95.359 | 95.3638 | 95.359 | 95.359 | 74481.0 |
| 2013-11-12 | ER | Futures | 97.891 | 97.896 | 97.881 | 97.886 | 42111.0 |
| 2013-11-12 | EW | Futures | 1313.9 | 1314.9 | 1305.4 | 1313.4 | 16284.0 |
| 2013-11-12 | FBTP | Futures | 81.25 | 81.32 | 81.12 | 81.2 | 22660.0 |
| 2013-11-12 | FBTS | Futures | 95.252 | 95.278 | 95.2 | 95.261 | 7628.0 |
| 2013-11-12 | FCE | Futures | 3322.2 | 3326.5 | 3290.7 | 3300.1 | 182118.0 |
| 2013-11-12 | FDAX | Futures | 10119.1 | 10127.4 | 10053.6 | 10079.7 | 79866.0 |
| 2013-11-12 | FESX | Futures | 2140.7 | 2143.5 | 2118.2 | 2125.9 | 759462.0 |
| 2013-11-12 | FEU3 | Futures | 98.512 | 98.512 | 98.507 | 98.507 | 2.0 |
| 2013-11-12 | FGBL | Futures | 120.03 | 120.05 | 119.66 | 119.81 | 666419.0 |
| 2013-11-12 | FGBM | Futures | 118.33 | 118.37 | 118.22 | 118.35 | 469406.0 |
| 2013-11-12 | FGBS | Futures | 110.593 | 110.608 | 110.578 | 110.593 | 258719.0 |
| 2013-11-12 | FGBX | Futures | 120.18 | 120.23 | 119.11 | 119.32 | 21068.0 |
| 2013-11-12 | FMWO | Futures | 5263.6 | 5263.6 | 5263.6 | 5263.6 | 0.0 |
| 2013-11-12 | FOAT | Futures | 108.09 | 108.17 | 107.81 | 107.89 | 43156.0 |
| 2013-11-12 | FTDX | Futures | 1073.7 | 1073.7 | 1061.0 | 1061.9 | 482.0 |
| 2013-11-12 | FTI | Futures | 340.61 | 341.13 | 338.02 | 338.84 | 41210.0 |
| 2013-11-12 | FTUK | Futures | 5034.4 | 5040.1 | 5005.2 | 5028.1 | 93781.0 |
| 2013-11-12 | FVSA | Futures | 2105.77 | 2111.82 | 2081.57 | 2105.77 | 9648.0 |
| 2013-11-12 | FXXP | Futures | 235.8 | 235.8 | 233.7 | 234.5 | 3445.0 |
| 2013-11-12 | G | Futures | 91.63 | 92.04 | 91.55 | 91.85 | 145272.0 |
| 2013-11-12 | GF | Futures | 265.027 | 266.114 | 264.343 | 264.343 | 1800.0 |
| 2013-11-12 | GSCI | Futures | 1020.48 | 1022.22 | 1008.63 | 1010.12 | 1716.0 |
| 2013-11-12 | HE | Futures | 111.351 | 111.952 | 110.18 | 110.37 | 27829.0 |
| 2013-11-12 | HG | Futures | 4.1202 | 4.1253 | 4.0658 | 4.0949 | 54987.0 |
| 2013-11-12 | HH | Futures | 37.14 | 37.458 | 37.109 | 37.109 | 701.0 |
| 2013-11-12 | HO | Futures | 2.3154 | 2.324 | 2.2802 | 2.2853 | 61441.0 |
> showing 50 of 104 rows — these rows as CSV