PREVIEW / futures_daily / 2013-10-15
file: by_date/futures_daily/2013/2013-10-15.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-10-15 | ES | Futures | 1752.7 | 1756.3 | 1735.5 | 1738.07 | 1872624.0 |
| 2013-10-15 | NQ | Futures | 3736.73 | 3748.22 | 3714.34 | 3722.09 | 329005.0 |
| 2013-10-15 | YM | Futures | 15159.8 | 15188.6 | 15006.5 | 15019.5 | 207713.0 |
| 2013-10-15 | CL | Futures | 182.04 | 182.45 | 179.83 | 180.44 | 147498.0 |
| 2013-10-15 | GC | Futures | 1684.4 | 1703.0 | 1654.5 | 1683.9 | 204033.0 |
| 2013-10-15 | ZN | Futures | 113.988852 | 114.27209 | 113.889719 | 114.073824 | 899938.0 |
| 2013-10-15 | A6 | Futures | 0.89293 | 0.89822 | 0.89151 | 0.89435 | 69328.0 |
| 2013-10-15 | AD | Futures | 0.9747 | 0.97652 | 0.97096 | 0.97208 | 35452.0 |
| 2013-10-15 | B | Futures | 109.95 | 110.12 | 108.48 | 109.06 | 223343.0 |
| 2013-10-15 | B6 | Futures | 1.6771 | 1.6818 | 1.6698 | 1.6781 | 89758.0 |
| 2013-10-15 | BFX | Futures | 3413.9 | 3428.3 | 3413.9 | 3428.3 | 86.0 |
| 2013-10-15 | BR | Futures | 0.23036 | 0.23117 | 0.23016 | 0.23039 | 148.0 |
| 2013-10-15 | BZ | Futures | 110.56 | 110.76 | 109.16 | 109.72 | 6461.0 |
| 2013-10-15 | C | Futures | 1875.0 | 1909.0 | 1873.0 | 1904.0 | 8073.0 |
| 2013-10-15 | CC | Futures | 2022.0 | 2064.0 | 2019.0 | 2057.0 | 12396.0 |
| 2013-10-15 | CNH | Futures | 7.0426 | 7.0426 | 7.034 | 7.034 | 23.0 |
| 2013-10-15 | CSC | Futures | 3.367 | 3.369 | 3.367 | 3.367 | 8.0 |
| 2013-10-15 | CT | Futures | 98.31 | 98.64 | 97.86 | 98.2 | 8071.0 |
| 2013-10-15 | DC | Futures | 25.69 | 25.83 | 25.64 | 25.79 | 202.0 |
| 2013-10-15 | DX | Futures | 76.648 | 76.986 | 76.548 | 76.758 | 25387.0 |
| 2013-10-15 | E1 | Futures | 1.41244 | 1.41385 | 1.40074 | 1.40819 | 42636.0 |
| 2013-10-15 | E6 | Futures | 1.60047 | 1.60188 | 1.59103 | 1.59587 | 208065.0 |
| 2013-10-15 | E7 | Futures | 1.5899 | 1.5916 | 1.5808 | 1.5856 | 3926.0 |
| 2013-10-15 | ED | Futures | 95.3255 | 95.3303 | 95.316 | 95.3208 | 170707.0 |
| 2013-10-15 | ER | Futures | 97.837 | 97.852 | 97.832 | 97.842 | 68099.0 |
| 2013-10-15 | EW | Futures | 1288.8 | 1291.6 | 1272.2 | 1275.8 | 20569.0 |
| 2013-10-15 | FBTP | Futures | 80.01 | 80.16 | 79.84 | 80.07 | 28830.0 |
| 2013-10-15 | FBTS | Futures | 94.284 | 94.396 | 94.266 | 94.379 | 6320.0 |
| 2013-10-15 | FCE | Futures | 3277.2 | 3300.5 | 3276.8 | 3294.7 | 110425.0 |
| 2013-10-15 | FDAX | Futures | 9713.5 | 9794.0 | 9705.2 | 9776.8 | 98360.0 |
| 2013-10-15 | FESX | Futures | 2089.5 | 2103.5 | 2085.3 | 2100.0 | 927266.0 |
| 2013-10-15 | FEU3 | Futures | 98.463 | 98.463 | 98.463 | 98.463 | 25.0 |
| 2013-10-15 | FGBL | Futures | 118.71 | 118.83 | 118.42 | 118.56 | 650895.0 |
| 2013-10-15 | FGBM | Futures | 117.38 | 117.43 | 117.24 | 117.3 | 449443.0 |
| 2013-10-15 | FGBS | Futures | 110.403 | 110.403 | 110.363 | 110.378 | 257922.0 |
| 2013-10-15 | FGBX | Futures | 118.68 | 118.78 | 117.98 | 118.3 | 13602.0 |
| 2013-10-15 | FMWO | Futures | 5140.9 | 5140.9 | 5140.9 | 5140.9 | 0.0 |
| 2013-10-15 | FOAT | Futures | 106.41 | 106.51 | 106.22 | 106.31 | 39150.0 |
| 2013-10-15 | FTDX | Futures | 1031.3 | 1038.4 | 1029.0 | 1033.7 | 491.0 |
| 2013-10-15 | FTI | Futures | 325.37 | 329.21 | 325.15 | 328.87 | 23300.0 |
| 2013-10-15 | FTUK | Futures | 4892.3 | 4906.5 | 4872.4 | 4890.4 | 84244.0 |
| 2013-10-15 | FVSA | Futures | 2434.42 | 2452.67 | 2373.56 | 2403.99 | 13127.0 |
| 2013-10-15 | FXXP | Futures | 228.2 | 229.5 | 228.2 | 229.3 | 4864.0 |
| 2013-10-15 | G | Futures | 91.91 | 92.01 | 91.72 | 91.82 | 135346.0 |
| 2013-10-15 | GF | Futures | 271.963 | 272.286 | 269.624 | 270.189 | 2297.0 |
| 2013-10-15 | GSCI | Futures | 1062.46 | 1065.05 | 1058.63 | 1060.63 | 159.0 |
| 2013-10-15 | HE | Futures | 109.358 | 111.921 | 109.01 | 111.13 | 24014.0 |
| 2013-10-15 | HG | Futures | 4.1728 | 4.1911 | 4.1544 | 4.188 | 36968.0 |
| 2013-10-15 | HH | Futures | 40.758 | 40.801 | 40.299 | 40.459 | 5247.0 |
| 2013-10-15 | HO | Futures | 2.4237 | 2.4325 | 2.401 | 2.4126 | 22151.0 |
> showing 50 of 103 rows — these rows as CSV