PREVIEW / futures_daily / 2013-10-29
file: by_date/futures_daily/2013/2013-10-29.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-10-29 | ES | Futures | 1806.89 | 1816.91 | 1802.27 | 1815.52 | 1189498.0 |
| 2013-10-29 | NQ | Futures | 3879.44 | 3896.09 | 3868.81 | 3886.61 | 208676.0 |
| 2013-10-29 | YM | Futures | 15439.3 | 15547.8 | 15405.5 | 15537.9 | 101867.0 |
| 2013-10-29 | CL | Futures | 175.33 | 175.38 | 173.82 | 174.73 | 183243.0 |
| 2013-10-29 | GC | Futures | 1788.9 | 1799.2 | 1771.9 | 1779.5 | 127174.0 |
| 2013-10-29 | ZN | Futures | 115.574981 | 115.787409 | 115.504172 | 115.759086 | 763596.0 |
| 2013-10-29 | A6 | Futures | 0.90124 | 0.90152 | 0.89189 | 0.89274 | 83887.0 |
| 2013-10-29 | AD | Futures | 0.96611 | 0.96793 | 0.96379 | 0.9648 | 46172.0 |
| 2013-10-29 | B | Futures | 108.75 | 108.84 | 107.94 | 108.49 | 109564.0 |
| 2013-10-29 | B6 | Futures | 1.6936 | 1.6939 | 1.6812 | 1.6838 | 93212.0 |
| 2013-10-29 | BFX | Futures | 3453.2 | 3476.2 | 3452.8 | 3464.0 | 189.0 |
| 2013-10-29 | BR | Futures | 0.23145 | 0.23199 | 0.23125 | 0.23158 | 340.0 |
| 2013-10-29 | BZ | Futures | 109.21 | 109.54 | 108.68 | 109.21 | 5791.0 |
| 2013-10-29 | C | Futures | 1824.0 | 1827.0 | 1794.0 | 1806.0 | 14050.0 |
| 2013-10-29 | CB | Futures | 70.018 | 70.977 | 70.018 | 70.258 | 31.0 |
| 2013-10-29 | CC | Futures | 2000.0 | 2008.0 | 1977.0 | 1982.0 | 18858.0 |
| 2013-10-29 | CSC | Futures | 3.445 | 3.445 | 3.435 | 3.439 | 19.0 |
| 2013-10-29 | CT | Futures | 92.44 | 92.65 | 91.84 | 91.9 | 12768.0 |
| 2013-10-29 | DC | Futures | 26.27 | 26.33 | 26.15 | 26.23 | 288.0 |
| 2013-10-29 | DX | Futures | 75.638 | 75.976 | 75.595 | 75.909 | 18072.0 |
| 2013-10-29 | E1 | Futures | 1.43544 | 1.43737 | 1.42798 | 1.43056 | 33916.0 |
| 2013-10-29 | E6 | Futures | 1.62726 | 1.63033 | 1.62124 | 1.62254 | 217958.0 |
| 2013-10-29 | E7 | Futures | 1.6166 | 1.6198 | 1.6108 | 1.6121 | 3780.0 |
| 2013-10-29 | ED | Futures | 95.3638 | 95.3638 | 95.359 | 95.359 | 56795.0 |
| 2013-10-29 | ER | Futures | 97.842 | 97.852 | 97.842 | 97.847 | 51421.0 |
| 2013-10-29 | EW | Futures | 1316.2 | 1324.4 | 1314.3 | 1323.1 | 15817.0 |
| 2013-10-29 | FBTP | Futures | 80.53 | 81.02 | 80.53 | 80.96 | 35469.0 |
| 2013-10-29 | FBTS | Futures | 94.569 | 94.725 | 94.569 | 94.699 | 8230.0 |
| 2013-10-29 | FCE | Futures | 3297.4 | 3315.6 | 3284.6 | 3312.9 | 79157.0 |
| 2013-10-29 | FDAX | Futures | 9976.0 | 10034.2 | 9946.6 | 10010.4 | 71872.0 |
| 2013-10-29 | FDIV | Futures | 139.68 | 140.08 | 139.68 | 140.08 | 2.0 |
| 2013-10-29 | FESX | Futures | 2116.1 | 2135.8 | 2108.4 | 2133.7 | 668369.0 |
| 2013-10-29 | FEU3 | Futures | 98.468 | 98.468 | 98.468 | 98.468 | 95.0 |
| 2013-10-29 | FGBL | Futures | 120.15 | 120.45 | 120.01 | 120.29 | 555521.0 |
| 2013-10-29 | FGBM | Futures | 117.91 | 118.07 | 117.89 | 118.01 | 350662.0 |
| 2013-10-29 | FGBS | Futures | 110.393 | 110.423 | 110.393 | 110.418 | 203079.0 |
| 2013-10-29 | FGBX | Futures | 121.17 | 121.61 | 120.82 | 121.28 | 12726.0 |
| 2013-10-29 | FMWO | Futures | 5305.3 | 5305.3 | 5305.3 | 5305.3 | 0.0 |
| 2013-10-29 | FOAT | Futures | 107.98 | 108.24 | 107.88 | 108.15 | 24857.0 |
| 2013-10-29 | FTDX | Futures | 1055.8 | 1061.5 | 1053.5 | 1058.6 | 57.0 |
| 2013-10-29 | FTI | Futures | 335.09 | 337.33 | 334.52 | 336.98 | 16773.0 |
| 2013-10-29 | FTUK | Futures | 5030.3 | 5074.6 | 5020.6 | 5065.9 | 67966.0 |
| 2013-10-29 | FVSA | Futures | 2130.11 | 2130.11 | 2051.0 | 2057.08 | 3492.0 |
| 2013-10-29 | FXXP | Futures | 232.9 | 233.9 | 232.6 | 233.7 | 5983.0 |
| 2013-10-29 | G | Futures | 93.41 | 93.6 | 93.26 | 93.49 | 108250.0 |
| 2013-10-29 | GF | Futures | 269.382 | 270.189 | 268.213 | 268.979 | 1225.0 |
| 2013-10-29 | GSCI | Futures | 1047.29 | 1048.79 | 1043.87 | 1045.62 | 103.0 |
| 2013-10-29 | HE | Futures | 116.414 | 116.699 | 115.433 | 115.623 | 17011.0 |
| 2013-10-29 | HG | Futures | 4.1316 | 4.1734 | 4.1101 | 4.1506 | 48075.0 |
| 2013-10-29 | HH | Futures | 37.499 | 37.509 | 37.058 | 37.232 | 2126.0 |
> showing 50 of 104 rows — these rows as CSV