PREVIEW / futures_daily / 2013-10-31
file: by_date/futures_daily/2013/2013-10-31.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-31 | ES | Futures | 1805.61 | 1812.03 | 1797.9 | 1798.67 | 1885721.0 |
| 2013-10-31 | NQ | Futures | 3882.02 | 3898.1 | 3859.91 | 3869.39 | 252511.0 |
| 2013-10-31 | YM | Futures | 15463.2 | 15514.0 | 15399.5 | 15399.5 | 143545.0 |
| 2013-10-31 | CL | Futures | 171.92 | 172.64 | 170.87 | 171.49 | 255401.0 |
| 2013-10-31 | GC | Futures | 1774.5 | 1776.2 | 1744.0 | 1750.7 | 151974.0 |
| 2013-10-31 | ZN | Futures | 115.532496 | 115.801571 | 115.178449 | 115.433363 | 1469826.0 |
| 2013-10-31 | A6 | Futures | 0.89293 | 0.89718 | 0.89 | 0.89076 | 97777.0 |
| 2013-10-31 | AD | Futures | 0.96328 | 0.96925 | 0.96207 | 0.96854 | 66589.0 |
| 2013-10-31 | B | Futures | 109.29 | 109.44 | 108.32 | 108.59 | 149171.0 |
| 2013-10-31 | B6 | Futures | 1.6829 | 1.6862 | 1.6795 | 1.6845 | 104739.0 |
| 2013-10-31 | BFX | Futures | 3469.4 | 3469.5 | 3465.5 | 3465.5 | 23.0 |
| 2013-10-31 | BR | Futures | 0.22911 | 0.22911 | 0.2256 | 0.22662 | 272.0 |
| 2013-10-31 | BZ | Futures | 109.79 | 110.15 | 109.03 | 109.31 | 6458.0 |
| 2013-10-31 | C | Futures | 1799.0 | 1826.0 | 1793.0 | 1813.0 | 9151.0 |
| 2013-10-31 | CB | Futures | 70.762 | 72.176 | 70.75 | 71.457 | 28.0 |
| 2013-10-31 | CC | Futures | 1984.0 | 2008.0 | 1975.0 | 1995.0 | 14683.0 |
| 2013-10-31 | CNH | Futures | 7.0237 | 7.0309 | 7.0237 | 7.0309 | 10.0 |
| 2013-10-31 | CSC | Futures | 3.464 | 3.513 | 3.464 | 3.513 | 130.0 |
| 2013-10-31 | CT | Futures | 91.46 | 92.78 | 90.46 | 90.54 | 22034.0 |
| 2013-10-31 | DC | Futures | 26.34 | 26.72 | 26.34 | 26.69 | 494.0 |
| 2013-10-31 | DX | Futures | 76.052 | 76.562 | 75.976 | 76.474 | 26159.0 |
| 2013-10-31 | E1 | Futures | 1.42914 | 1.42991 | 1.41629 | 1.41963 | 44129.0 |
| 2013-10-31 | E6 | Futures | 1.62136 | 1.62147 | 1.60212 | 1.60401 | 286499.0 |
| 2013-10-31 | E7 | Futures | 1.6108 | 1.6109 | 1.5918 | 1.5937 | 5501.0 |
| 2013-10-31 | ED | Futures | 95.359 | 95.3638 | 95.3542 | 95.359 | 109991.0 |
| 2013-10-31 | ER | Futures | 97.847 | 97.881 | 97.842 | 97.871 | 232922.0 |
| 2013-10-31 | EW | Futures | 1313.4 | 1322.3 | 1307.7 | 1311.7 | 23912.0 |
| 2013-10-31 | FBTP | Futures | 80.68 | 81.34 | 80.58 | 81.18 | 52494.0 |
| 2013-10-31 | FBTS | Futures | 94.586 | 94.837 | 94.552 | 94.828 | 8774.0 |
| 2013-10-31 | FCE | Futures | 3296.6 | 3338.1 | 3293.5 | 3330.3 | 105856.0 |
| 2013-10-31 | FDAX | Futures | 9961.5 | 10047.5 | 9959.3 | 10023.1 | 93794.0 |
| 2013-10-31 | FESX | Futures | 2117.5 | 2152.6 | 2116.8 | 2145.6 | 858155.0 |
| 2013-10-31 | FGBL | Futures | 120.55 | 121.19 | 120.51 | 120.91 | 982214.0 |
| 2013-10-31 | FGBM | Futures | 118.19 | 118.59 | 118.18 | 118.51 | 671378.0 |
| 2013-10-31 | FGBS | Futures | 110.468 | 110.568 | 110.453 | 110.548 | 625342.0 |
| 2013-10-31 | FGBX | Futures | 121.51 | 122.64 | 121.51 | 122.25 | 21518.0 |
| 2013-10-31 | FMWO | Futures | 5287.6 | 5287.6 | 5287.6 | 5287.6 | 0.0 |
| 2013-10-31 | FOAT | Futures | 108.21 | 108.92 | 108.21 | 108.72 | 54302.0 |
| 2013-10-31 | FTDX | Futures | 1057.7 | 1063.8 | 1051.6 | 1063.8 | 46.0 |
| 2013-10-31 | FTI | Futures | 335.91 | 338.76 | 334.78 | 337.63 | 26666.0 |
| 2013-10-31 | FTUK | Futures | 5051.7 | 5060.7 | 5022.8 | 5031.8 | 126605.0 |
| 2013-10-31 | FVSA | Futures | 2081.43 | 2099.68 | 2044.91 | 2063.17 | 4751.0 |
| 2013-10-31 | FXXP | Futures | 233.2 | 235.3 | 233.2 | 234.8 | 6282.0 |
| 2013-10-31 | G | Futures | 93.9 | 94.13 | 93.11 | 93.34 | 214394.0 |
| 2013-10-31 | GF | Futures | 266.035 | 266.801 | 264.745 | 265.148 | 1788.0 |
| 2013-10-31 | GSCI | Futures | 1041.03 | 1045.79 | 1036.45 | 1036.45 | 182.0 |
| 2013-10-31 | HE | Futures | 114.357 | 114.42 | 112.743 | 112.87 | 24531.0 |
| 2013-10-31 | HG | Futures | 4.193 | 4.2032 | 4.1677 | 4.1791 | 56949.0 |
| 2013-10-31 | HH | Futures | 37.161 | 37.161 | 36.678 | 36.74 | 1162.0 |
| 2013-10-31 | HO | Futures | 2.385 | 2.3917 | 2.3598 | 2.366 | 55554.0 |
> showing 50 of 103 rows — these rows as CSV