PREVIEW / futures_daily / 2011-01-05
file: by_date/futures_daily/2011/2011-01-05.parquet size: 9 KB rows: 93
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 |
|---|---|---|---|---|---|---|---|
| 2011-01-05 | ES | Futures | 1245.66 | 1253.78 | 1236.07 | 1251.81 | 1797267.0 |
| 2011-01-05 | NQ | Futures | 2550.74 | 2579.13 | 2531.16 | 2576.86 | 213120.0 |
| 2011-01-05 | YM | Futures | 10876.4 | 10934.5 | 10803.4 | 10916.7 | 100760.0 |
| 2011-01-05 | CL | Futures | 182.98 | 186.16 | 180.54 | 185.05 | 416908.0 |
| 2011-01-05 | GC | Futures | 1876.7 | 1882.8 | 1854.0 | 1867.2 | 202336.0 |
| 2011-01-05 | ZN | Futures | 100.140582 | 100.42655 | 99.1137 | 99.191691 | 1354117.0 |
| 2011-01-05 | A6 | Futures | 0.84571 | 0.84715 | 0.8374 | 0.84054 | 115083.0 |
| 2011-01-05 | AD | Futures | 0.99255 | 0.99771 | 0.98868 | 0.99483 | 72608.0 |
| 2011-01-05 | B | Futures | 79.37 | 81.51 | 78.58 | 81.22 | 125896.0 |
| 2011-01-05 | B6 | Futures | 1.6166 | 1.6203 | 1.602 | 1.6063 | 110012.0 |
| 2011-01-05 | BFX | Futures | 3034.4 | 3053.4 | 3011.1 | 3039.2 | 198.0 |
| 2011-01-05 | BR | Futures | 0.25659 | 0.25659 | 0.25459 | 0.25467 | 75.0 |
| 2011-01-05 | BZ | Futures | 84.16 | 86.67 | 84.16 | 86.51 | 819.0 |
| 2011-01-05 | C | Futures | 2139.0 | 2144.0 | 2091.0 | 2113.0 | 12275.0 |
| 2011-01-05 | CB | Futures | 105.602 | 107.069 | 105.602 | 107.069 | 4.0 |
| 2011-01-05 | CC | Futures | 2374.0 | 2377.0 | 2290.0 | 2314.0 | 13400.0 |
| 2011-01-05 | CT | Futures | 123.05 | 126.72 | 121.81 | 124.51 | 9892.0 |
| 2011-01-05 | DC | Futures | 23.01 | 23.44 | 23.01 | 23.18 | 300.0 |
| 2011-01-05 | DX | Futures | 79.566 | 80.49 | 79.566 | 80.393 | 29263.0 |
| 2011-01-05 | E1 | Futures | 1.38348 | 1.38505 | 1.35386 | 1.35622 | 58778.0 |
| 2011-01-05 | E6 | Futures | 1.57416 | 1.57605 | 1.55227 | 1.55523 | 361260.0 |
| 2011-01-05 | E7 | Futures | 1.5622 | 1.5642 | 1.5408 | 1.5437 | 5267.0 |
| 2011-01-05 | EBM | Futures | 223.32 | 228.09 | 222.19 | 227.86 | 9467.0 |
| 2011-01-05 | ED | Futures | 94.8147 | 94.8242 | 94.8004 | 94.8099 | 210886.0 |
| 2011-01-05 | ER | Futures | 97.385 | 97.385 | 97.365 | 97.37 | 124714.0 |
| 2011-01-05 | EW | Futures | 894.0 | 900.8 | 886.9 | 898.6 | 20091.0 |
| 2011-01-05 | FBTP | Futures | 64.31 | 64.53 | 64.15 | 64.24 | 4061.0 |
| 2011-01-05 | FCE | Futures | 2606.0 | 2617.0 | 2569.3 | 2606.3 | 141745.0 |
| 2011-01-05 | FDAX | Futures | 7453.7 | 7475.7 | 7338.1 | 7438.7 | 158435.0 |
| 2011-01-05 | FESX | Futures | 1757.6 | 1766.9 | 1729.0 | 1755.7 | 1300115.0 |
| 2011-01-05 | FEU3 | Futures | 97.944 | 97.944 | 97.929 | 97.929 | 23.0 |
| 2011-01-05 | FGBL | Futures | 99.84 | 100.2 | 99.15 | 99.38 | 1076231.0 |
| 2011-01-05 | FGBM | Futures | 105.32 | 105.49 | 104.78 | 104.95 | 519010.0 |
| 2011-01-05 | FGBS | Futures | 107.642 | 107.657 | 107.415 | 107.449 | 455546.0 |
| 2011-01-05 | FGBX | Futures | 99.21 | 99.83 | 97.7 | 98.25 | 4917.0 |
| 2011-01-05 | FTDX | Futures | 758.7 | 761.3 | 748.2 | 756.1 | 473.0 |
| 2011-01-05 | FTI | Futures | 286.84 | 287.24 | 282.16 | 286.16 | 44507.0 |
| 2011-01-05 | FTUK | Futures | 4151.3 | 4176.3 | 4114.5 | 4163.8 | 103007.0 |
| 2011-01-05 | FXXP | Futures | 181.4 | 181.6 | 179.6 | 181.4 | 5997.0 |
| 2011-01-05 | G | Futures | 81.73 | 82.0 | 81.08 | 81.17 | 101819.0 |
| 2011-01-05 | GF | Futures | 301.046 | 301.98 | 300.174 | 301.357 | 867.0 |
| 2011-01-05 | GSCI | Futures | 1012.35 | 1024.76 | 1000.42 | 1021.68 | 261.0 |
| 2011-01-05 | HE | Futures | 97.006 | 98.668 | 96.693 | 97.853 | 13893.0 |
| 2011-01-05 | HG | Futures | 5.8413 | 5.89 | 5.718 | 5.8746 | 39093.0 |
| 2011-01-05 | HO | Futures | 2.1075 | 2.1428 | 2.0729 | 2.1334 | 24677.0 |
| 2011-01-05 | HRC | Futures | 2653.8 | 2653.8 | 2653.8 | 2653.8 | 0.0 |
| 2011-01-05 | J1 | Futures | 0.0153093 | 0.0153482 | 0.0150695 | 0.015082 | 185471.0 |
| 2011-01-05 | J7 | Futures | 0.015183 | 0.015237 | 0.014965 | 0.014975 | 263.0 |
| 2011-01-05 | JB | Futures | 121.15 | 121.49 | 121.15 | 121.36 | 2003.0 |
| 2011-01-05 | KC | Futures | 574.08 | 583.4 | 564.02 | 571.38 | 10889.0 |
> showing 50 of 93 rows — these rows as CSV