PREVIEW / futures_daily / 2013-10-28
file: by_date/futures_daily/2013/2013-10-28.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-28 | ES | Futures | 1801.5 | 1810.23 | 1799.19 | 1806.89 | 1157924.0 |
| 2013-10-28 | NQ | Futures | 3875.42 | 3894.65 | 3859.91 | 3885.75 | 196908.0 |
| 2013-10-28 | YM | Futures | 15415.5 | 15496.1 | 15390.6 | 15440.3 | 95128.0 |
| 2013-10-28 | CL | Futures | 174.16 | 175.83 | 173.25 | 175.58 | 230155.0 |
| 2013-10-28 | GC | Futures | 1789.0 | 1801.0 | 1780.3 | 1788.3 | 118915.0 |
| 2013-10-28 | ZN | Futures | 115.617467 | 115.702438 | 115.447525 | 115.617467 | 498134.0 |
| 2013-10-28 | A6 | Futures | 0.90266 | 0.90596 | 0.89964 | 0.9019 | 53544.0 |
| 2013-10-28 | AD | Futures | 0.96561 | 0.96773 | 0.96561 | 0.96652 | 30675.0 |
| 2013-10-28 | B | Futures | 106.71 | 109.06 | 106.54 | 109.0 | 137487.0 |
| 2013-10-28 | B6 | Futures | 1.6969 | 1.7008 | 1.692 | 1.6956 | 61131.0 |
| 2013-10-28 | BFX | Futures | 3431.9 | 3433.0 | 3431.9 | 3433.0 | 7.0 |
| 2013-10-28 | BR | Futures | 0.23092 | 0.23158 | 0.23082 | 0.23112 | 344.0 |
| 2013-10-28 | BZ | Futures | 107.49 | 109.79 | 107.35 | 109.73 | 8116.0 |
| 2013-10-28 | C | Futures | 1834.0 | 1837.0 | 1814.0 | 1817.0 | 5849.0 |
| 2013-10-28 | CB | Futures | 69.73 | 70.018 | 69.73 | 70.018 | 21.0 |
| 2013-10-28 | CC | Futures | 2018.0 | 2024.0 | 1996.0 | 2000.0 | 9081.0 |
| 2013-10-28 | CNH | Futures | 7.0128 | 7.0143 | 7.011 | 7.011 | 40.0 |
| 2013-10-28 | CSC | Futures | 3.445 | 3.455 | 3.445 | 3.455 | 10.0 |
| 2013-10-28 | CT | Futures | 92.77 | 93.25 | 92.11 | 92.27 | 14759.0 |
| 2013-10-28 | DC | Futures | 26.13 | 26.33 | 26.13 | 26.29 | 249.0 |
| 2013-10-28 | DX | Futures | 75.557 | 75.695 | 75.466 | 75.562 | 10854.0 |
| 2013-10-28 | E1 | Futures | 1.44032 | 1.44084 | 1.43441 | 1.43749 | 19337.0 |
| 2013-10-28 | E6 | Futures | 1.62962 | 1.6308 | 1.62572 | 1.62938 | 105828.0 |
| 2013-10-28 | E7 | Futures | 1.6191 | 1.6203 | 1.6154 | 1.6189 | 1777.0 |
| 2013-10-28 | ED | Futures | 95.359 | 95.3638 | 95.359 | 95.359 | 31144.0 |
| 2013-10-28 | ER | Futures | 97.842 | 97.847 | 97.832 | 97.842 | 4.0 |
| 2013-10-28 | EW | Futures | 1317.2 | 1323.9 | 1311.5 | 1317.7 | 13310.0 |
| 2013-10-28 | FBTP | Futures | 80.53 | 80.63 | 80.33 | 80.6 | 40919.0 |
| 2013-10-28 | FBTS | Futures | 94.526 | 94.586 | 94.448 | 94.578 | 8115.0 |
| 2013-10-28 | FCE | Futures | 3321.8 | 3324.5 | 3279.2 | 3293.1 | 81571.0 |
| 2013-10-28 | FDAX | Futures | 10013.1 | 10022.6 | 9934.4 | 9971.5 | 69032.0 |
| 2013-10-28 | FESX | Futures | 2129.4 | 2132.3 | 2105.6 | 2114.7 | 577147.0 |
| 2013-10-28 | FGBL | Futures | 120.01 | 120.26 | 119.99 | 120.19 | 423456.0 |
| 2013-10-28 | FGBM | Futures | 117.84 | 118.0 | 117.82 | 117.95 | 274976.0 |
| 2013-10-28 | FGBS | Futures | 110.383 | 110.413 | 110.368 | 110.403 | 185443.0 |
| 2013-10-28 | FGBX | Futures | 121.09 | 121.44 | 121.07 | 121.26 | 18834.0 |
| 2013-10-28 | FMWO | Futures | 5292.7 | 5292.7 | 5292.7 | 5292.7 | 0.0 |
| 2013-10-28 | FOAT | Futures | 107.84 | 108.0 | 107.79 | 107.98 | 25947.0 |
| 2013-10-28 | FTDX | Futures | 1058.2 | 1061.9 | 1054.9 | 1056.8 | 268.0 |
| 2013-10-28 | FTI | Futures | 336.16 | 336.47 | 334.09 | 334.96 | 16228.0 |
| 2013-10-28 | FTUK | Futures | 5038.2 | 5042.3 | 5010.8 | 5030.3 | 55655.0 |
| 2013-10-28 | FVSA | Futures | 2087.51 | 2154.46 | 2087.51 | 2105.77 | 3475.0 |
| 2013-10-28 | FXXP | Futures | 234.0 | 234.0 | 232.2 | 232.9 | 4428.0 |
| 2013-10-28 | G | Futures | 93.24 | 93.45 | 93.17 | 93.35 | 60459.0 |
| 2013-10-28 | GF | Futures | 269.463 | 269.947 | 269.019 | 269.503 | 1163.0 |
| 2013-10-28 | GSCI | Futures | 1038.87 | 1051.29 | 1038.78 | 1050.62 | 89.0 |
| 2013-10-28 | HE | Futures | 114.231 | 116.572 | 113.977 | 116.382 | 21508.0 |
| 2013-10-28 | HG | Futures | 4.1481 | 4.1601 | 4.124 | 4.1392 | 32039.0 |
| 2013-10-28 | HH | Futures | 37.828 | 37.971 | 37.561 | 37.561 | 1540.0 |
| 2013-10-28 | HO | Futures | 2.3309 | 2.3775 | 2.3271 | 2.3742 | 62716.0 |
> showing 50 of 103 rows — these rows as CSV