PREVIEW / futures_daily / 2013-03-20
file: by_date/futures_daily/2013/2013-03-20.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-03-20 | ES | Futures | 1580.29 | 1597.23 | 1577.46 | 1590.3 | 1802214.0 |
| 2013-03-20 | NQ | Futures | 3207.4 | 3241.76 | 3201.62 | 3217.21 | 213748.0 |
| 2013-03-20 | YM | Futures | 14145.3 | 14254.6 | 14127.6 | 14187.6 | 134708.0 |
| 2013-03-20 | CL | Futures | 161.31 | 163.37 | 161.31 | 163.19 | 226790.0 |
| 2013-03-20 | GC | Futures | 2142.5 | 2145.2 | 2126.1 | 2136.6 | 127570.0 |
| 2013-03-20 | ZN | Futures | 117.19762 | 117.322846 | 116.821942 | 117.002824 | 1086953.0 |
| 2013-03-20 | A6 | Futures | 0.95036 | 0.95414 | 0.94943 | 0.9522 | 78624.0 |
| 2013-03-20 | AD | Futures | 0.97623 | 0.97944 | 0.97582 | 0.97854 | 67187.0 |
| 2013-03-20 | B | Futures | 102.53 | 103.8 | 102.5 | 103.61 | 169060.0 |
| 2013-03-20 | B6 | Futures | 1.5786 | 1.5884 | 1.5716 | 1.5809 | 202830.0 |
| 2013-03-20 | BFX | Futures | 3139.2 | 3150.1 | 3139.2 | 3150.1 | 26.0 |
| 2013-03-20 | BR | Futures | 0.24681 | 0.24698 | 0.24681 | 0.24695 | 60.0 |
| 2013-03-20 | BZ | Futures | 105.02 | 106.28 | 105.02 | 106.1 | 2745.0 |
| 2013-03-20 | C | Futures | 1502.0 | 1533.0 | 1500.0 | 1531.0 | 6109.0 |
| 2013-03-20 | CB | Futures | 86.282 | 86.282 | 85.308 | 85.308 | 11.0 |
| 2013-03-20 | CC | Futures | 1589.0 | 1632.0 | 1585.0 | 1628.0 | 14793.0 |
| 2013-03-20 | CSC | Futures | 3.784 | 3.815 | 3.784 | 3.807 | 19.0 |
| 2013-03-20 | CT | Futures | 112.12 | 112.91 | 108.47 | 109.61 | 18469.0 |
| 2013-03-20 | DC | Futures | 28.4 | 29.09 | 28.37 | 29.01 | 511.0 |
| 2013-03-20 | DX | Futures | 80.0 | 80.005 | 79.505 | 79.72 | 30489.0 |
| 2013-03-20 | E1 | Futures | 1.35922 | 1.36848 | 1.35844 | 1.36475 | 34303.0 |
| 2013-03-20 | E6 | Futures | 1.51814 | 1.53122 | 1.51684 | 1.52721 | 319590.0 |
| 2013-03-20 | E7 | Futures | 1.5081 | 1.5211 | 1.5069 | 1.5173 | 5594.0 |
| 2013-03-20 | EBM | Futures | 279.72 | 283.8 | 279.72 | 283.51 | 19608.0 |
| 2013-03-20 | ED | Futures | 95.211 | 95.2349 | 95.1919 | 95.211 | 278677.0 |
| 2013-03-20 | ER | Futures | 97.71 | 97.768 | 97.695 | 97.739 | 312831.0 |
| 2013-03-20 | EW | Futures | 1153.4 | 1168.0 | 1151.0 | 1162.1 | 13832.0 |
| 2013-03-20 | FBTP | Futures | 74.58 | 75.3 | 74.57 | 75.08 | 30341.0 |
| 2013-03-20 | FBTS | Futures | 91.131 | 91.32 | 91.089 | 91.285 | 3806.0 |
| 2013-03-20 | FCE | Futures | 2851.1 | 2889.9 | 2851.1 | 2886.1 | 118853.0 |
| 2013-03-20 | FDAX | Futures | 8866.4 | 8946.5 | 8864.7 | 8909.2 | 108316.0 |
| 2013-03-20 | FDIV | Futures | 117.81 | 118.21 | 117.81 | 118.21 | 16.0 |
| 2013-03-20 | FESX | Futures | 1827.4 | 1852.5 | 1827.4 | 1850.4 | 1110217.0 |
| 2013-03-20 | FEU3 | Futures | 98.344 | 98.359 | 98.34 | 98.34 | 4.0 |
| 2013-03-20 | FGBL | Futures | 121.23 | 121.23 | 120.65 | 120.94 | 915806.0 |
| 2013-03-20 | FGBM | Futures | 118.05 | 118.05 | 117.74 | 117.89 | 449062.0 |
| 2013-03-20 | FGBS | Futures | 110.542 | 110.542 | 110.452 | 110.497 | 415309.0 |
| 2013-03-20 | FGBX | Futures | 128.66 | 128.69 | 126.89 | 127.63 | 15631.0 |
| 2013-03-20 | FMWO | Futures | 4658.1 | 4665.7 | 4658.1 | 4665.7 | 24.0 |
| 2013-03-20 | FOAT | Futures | 106.93 | 106.93 | 106.63 | 106.85 | 28443.0 |
| 2013-03-20 | FTDX | Futures | 868.7 | 872.9 | 868.7 | 872.4 | 32.0 |
| 2013-03-20 | FTI | Futures | 303.38 | 305.79 | 303.33 | 304.93 | 26376.0 |
| 2013-03-20 | FTUK | Futures | 4740.5 | 4769.9 | 4727.9 | 4743.5 | 92509.0 |
| 2013-03-20 | FVSA | Futures | 3438.68 | 3438.68 | 3262.98 | 3313.18 | 21522.0 |
| 2013-03-20 | FXXP | Futures | 214.6 | 214.7 | 213.7 | 214.1 | 2382.0 |
| 2013-03-20 | G | Futures | 98.91 | 98.93 | 98.12 | 98.69 | 163125.0 |
| 2013-03-20 | GF | Futures | 253.622 | 253.805 | 251.416 | 252.978 | 3268.0 |
| 2013-03-20 | GSCI | Futures | 1039.89 | 1042.22 | 1033.07 | 1040.69 | 186.0 |
| 2013-03-20 | HE | Futures | 88.224 | 88.299 | 87.016 | 88.123 | 250.0 |
| 2013-03-20 | HG | Futures | 4.3275 | 4.406 | 4.3256 | 4.397 | 50108.0 |
> showing 50 of 104 rows — these rows as CSV