PREVIEW / futures_daily / 2010-11-24
file: by_date/futures_daily/2010/2010-11-24.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 |
|---|---|---|---|---|---|---|---|
| 2010-11-24 | ES | Futures | 1154.63 | 1173.74 | 1152.18 | 1172.76 | 1821455.0 |
| 2010-11-24 | NQ | Futures | 2400.73 | 2455.44 | 2395.91 | 2446.94 | 267835.0 |
| 2010-11-24 | YM | Futures | 10246.6 | 10398.2 | 10221.5 | 10379.6 | 104539.0 |
| 2010-11-24 | CL | Futures | 166.31 | 173.0 | 166.27 | 172.2 | 324511.0 |
| 2010-11-24 | GC | Futures | 1871.8 | 1877.1 | 1860.4 | 1866.3 | 189894.0 |
| 2010-11-24 | ZN | Futures | 103.46438 | 103.670844 | 102.522387 | 102.638523 | 1730235.0 |
| 2010-11-24 | A6 | Futures | 0.81495 | 0.82502 | 0.8147 | 0.82175 | 87975.0 |
| 2010-11-24 | AD | Futures | 0.96825 | 0.98143 | 0.96756 | 0.97865 | 87681.0 |
| 2010-11-24 | B | Futures | 70.87 | 73.37 | 70.87 | 73.03 | 175946.0 |
| 2010-11-24 | B6 | Futures | 1.6384 | 1.644 | 1.6338 | 1.636 | 97690.0 |
| 2010-11-24 | BFX | Futures | 2984.8 | 3000.2 | 2970.2 | 2989.3 | 72.0 |
| 2010-11-24 | BR | Futures | 0.24576 | 0.24576 | 0.24554 | 0.24554 | 10.0 |
| 2010-11-24 | BZ | Futures | 75.23 | 77.44 | 75.09 | 77.25 | 320.0 |
| 2010-11-24 | C | Futures | 2051.0 | 2054.0 | 2027.0 | 2030.0 | 1831.0 |
| 2010-11-24 | CB | Futures | 93.135 | 93.282 | 92.402 | 93.282 | 7.0 |
| 2010-11-24 | CC | Futures | 2288.0 | 2299.0 | 2257.0 | 2266.0 | 6290.0 |
| 2010-11-24 | CSC | Futures | 3.374 | 3.374 | 3.374 | 3.374 | 13.0 |
| 2010-11-24 | CT | Futures | 95.72 | 100.94 | 95.29 | 99.98 | 18319.0 |
| 2010-11-24 | DC | Futures | 23.01 | 23.08 | 22.85 | 22.95 | 136.0 |
| 2010-11-24 | DX | Futures | 79.979 | 80.34 | 79.718 | 80.194 | 22787.0 |
| 2010-11-24 | E1 | Futures | 1.31726 | 1.32671 | 1.31463 | 1.31634 | 38096.0 |
| 2010-11-24 | E6 | Futures | 1.58267 | 1.58752 | 1.57108 | 1.57475 | 370767.0 |
| 2010-11-24 | E7 | Futures | 1.5708 | 1.5754 | 1.5594 | 1.5628 | 6506.0 |
| 2010-11-24 | ED | Futures | 94.7435 | 94.7506 | 94.6627 | 94.7078 | 545514.0 |
| 2010-11-24 | ER | Futures | 97.257 | 97.262 | 97.227 | 97.252 | 194728.0 |
| 2010-11-24 | EW | Futures | 830.3 | 848.7 | 828.5 | 846.9 | 19220.0 |
| 2010-11-24 | FBTP | Futures | 65.54 | 65.56 | 65.17 | 65.33 | 8233.0 |
| 2010-11-24 | FCE | Futures | 2505.0 | 2521.4 | 2477.9 | 2510.3 | 136662.0 |
| 2010-11-24 | FDAX | Futures | 7257.5 | 7372.6 | 7210.2 | 7340.3 | 161207.0 |
| 2010-11-24 | FESX | Futures | 1719.4 | 1731.9 | 1698.8 | 1721.3 | 1419919.0 |
| 2010-11-24 | FEU3 | Futures | 97.815 | 97.82 | 97.805 | 97.815 | 70.0 |
| 2010-11-24 | FGBL | Futures | 101.7 | 102.17 | 100.8 | 101.0 | 1331171.0 |
| 2010-11-24 | FGBM | Futures | 105.86 | 106.15 | 105.44 | 105.53 | 650476.0 |
| 2010-11-24 | FGBS | Futures | 107.489 | 107.583 | 107.346 | 107.41 | 738820.0 |
| 2010-11-24 | FGBX | Futures | 103.94 | 105.0 | 102.02 | 102.35 | 6123.0 |
| 2010-11-24 | FTDX | Futures | 686.2 | 693.7 | 681.3 | 693.7 | 496.0 |
| 2010-11-24 | FTI | Futures | 270.26 | 272.87 | 267.6 | 271.46 | 34620.0 |
| 2010-11-24 | FTUK | Futures | 3875.8 | 3923.2 | 3850.6 | 3908.0 | 99466.0 |
| 2010-11-24 | FXXP | Futures | 172.2 | 172.2 | 172.2 | 172.2 | 356.0 |
| 2010-11-24 | G | Futures | 82.79 | 83.14 | 82.2 | 82.35 | 174921.0 |
| 2010-11-24 | GF | Futures | 294.008 | 295.69 | 293.884 | 294.631 | 1919.0 |
| 2010-11-24 | GSCI | Futures | 920.52 | 938.35 | 918.57 | 937.86 | 360.0 |
| 2010-11-24 | HE | Futures | 96.567 | 97.633 | 96.505 | 97.32 | 5703.0 |
| 2010-11-24 | HG | Futures | 4.9431 | 5.0477 | 4.9431 | 5.0197 | 17698.0 |
| 2010-11-24 | HO | Futures | 1.9161 | 1.9707 | 1.9131 | 1.9674 | 7317.0 |
| 2010-11-24 | HRC | Futures | 2391.9 | 2391.9 | 2391.9 | 2391.9 | 0.0 |
| 2010-11-24 | J1 | Futures | 0.0151147 | 0.0151461 | 0.0150167 | 0.0150217 | 109762.0 |
| 2010-11-24 | J7 | Futures | 0.014995 | 0.015041 | 0.014914 | 0.014919 | 268.0 |
| 2010-11-24 | JB | Futures | 120.53 | 120.68 | 120.39 | 120.68 | 3710.0 |
| 2010-11-24 | KC | Futures | 516.69 | 521.72 | 505.66 | 508.72 | 6429.0 |
> showing 50 of 93 rows — these rows as CSV