PREVIEW / futures_daily / 2010-08-06
file: by_date/futures_daily/2010/2010-08-06.parquet size: 9 KB rows: 89
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-08-06 | ES | Futures | 1095.81 | 1099.22 | 1076.55 | 1091.91 | 2177376.0 |
| 2010-08-06 | NQ | Futures | 2153.3 | 2159.24 | 2117.93 | 2153.3 | 373034.0 |
| 2010-08-06 | YM | Futures | 9832.1 | 9879.2 | 9683.2 | 9812.7 | 139396.0 |
| 2010-08-06 | CL | Futures | 174.35 | 175.52 | 169.94 | 171.34 | 397532.0 |
| 2010-08-06 | GC | Futures | 1627.6 | 1649.2 | 1623.6 | 1638.3 | 105721.0 |
| 2010-08-06 | ZN | Futures | 101.579317 | 102.194018 | 101.451254 | 102.104374 | 1302106.0 |
| 2010-08-06 | A6 | Futures | 0.75566 | 0.76113 | 0.754 | 0.75798 | 104138.0 |
| 2010-08-06 | AD | Futures | 0.97068 | 0.97286 | 0.95784 | 0.95873 | 101293.0 |
| 2010-08-06 | B | Futures | 71.2 | 71.67 | 69.5 | 70.01 | 96355.0 |
| 2010-08-06 | B6 | Futures | 1.6487 | 1.6602 | 1.6433 | 1.6566 | 103830.0 |
| 2010-08-06 | BFX | Futures | 2971.5 | 2971.5 | 2905.4 | 2907.0 | 493.0 |
| 2010-08-06 | BR | Futures | 0.23643 | 0.23643 | 0.23643 | 0.23643 | 102.0 |
| 2010-08-06 | BZ | Futures | 75.65 | 75.65 | 75.34 | 75.34 | 73.0 |
| 2010-08-06 | C | Futures | 2500.0 | 2504.0 | 2377.0 | 2391.0 | 9374.0 |
| 2010-08-06 | CC | Futures | 2603.0 | 2610.0 | 2488.0 | 2513.0 | 12479.0 |
| 2010-08-06 | CT | Futures | 71.36 | 71.36 | 70.37 | 71.0 | 38.0 |
| 2010-08-06 | DC | Futures | 23.43 | 23.55 | 23.43 | 23.54 | 107.0 |
| 2010-08-06 | DX | Futures | 81.53 | 81.873 | 80.805 | 81.133 | 19982.0 |
| 2010-08-06 | E1 | Futures | 1.25554 | 1.27169 | 1.25015 | 1.26631 | 41525.0 |
| 2010-08-06 | E6 | Futures | 1.55912 | 1.57662 | 1.55569 | 1.56964 | 288250.0 |
| 2010-08-06 | E7 | Futures | 1.5479 | 1.5653 | 1.5414 | 1.5583 | 3394.0 |
| 2010-08-06 | ED | Futures | 94.5226 | 94.5369 | 94.5131 | 94.5274 | 156091.0 |
| 2010-08-06 | ER | Futures | 97.232 | 97.237 | 97.222 | 97.227 | 61699.0 |
| 2010-08-06 | EW | Futures | 757.3 | 760.0 | 743.6 | 755.8 | 29242.0 |
| 2010-08-06 | FBTP | Futures | 66.77 | 67.07 | 66.76 | 67.03 | 2129.0 |
| 2010-08-06 | FCE | Futures | 2480.2 | 2489.4 | 2424.4 | 2437.5 | 124873.0 |
| 2010-08-06 | FDAX | Futures | 6920.0 | 6953.2 | 6796.6 | 6816.7 | 144394.0 |
| 2010-08-06 | FESX | Futures | 1749.8 | 1759.0 | 1710.8 | 1720.0 | 1214752.0 |
| 2010-08-06 | FEU3 | Futures | 97.785 | 97.785 | 97.785 | 97.785 | 178.0 |
| 2010-08-06 | FGBL | Futures | 101.25 | 101.65 | 101.09 | 101.61 | 713895.0 |
| 2010-08-06 | FGBM | Futures | 105.33 | 105.51 | 105.21 | 105.44 | 363371.0 |
| 2010-08-06 | FGBS | Futures | 107.426 | 107.46 | 107.362 | 107.397 | 345749.0 |
| 2010-08-06 | FGBX | Futures | 101.43 | 102.17 | 101.25 | 102.08 | 2058.0 |
| 2010-08-06 | FTDX | Futures | 686.2 | 686.2 | 674.7 | 678.7 | 437.0 |
| 2010-08-06 | FTI | Futures | 268.04 | 269.15 | 261.76 | 262.87 | 31779.0 |
| 2010-08-06 | FTUK | Futures | 3702.3 | 3711.3 | 3640.0 | 3659.0 | 94005.0 |
| 2010-08-06 | G | Futures | 82.13 | 82.4 | 82.04 | 82.33 | 65964.0 |
| 2010-08-06 | GF | Futures | 285.581 | 285.645 | 283.687 | 283.939 | 907.0 |
| 2010-08-06 | GSCI | Futures | 920.99 | 922.35 | 901.39 | 904.7 | 2933.0 |
| 2010-08-06 | HE | Futures | 99.426 | 99.854 | 97.581 | 97.581 | 17788.0 |
| 2010-08-06 | HG | Futures | 4.4758 | 4.5267 | 4.4531 | 4.4772 | 35461.0 |
| 2010-08-06 | HO | Futures | 1.9228 | 1.9317 | 1.8691 | 1.8817 | 56218.0 |
| 2010-08-06 | HRC | Futures | 2729.3 | 2729.3 | 2729.3 | 2729.3 | 0.0 |
| 2010-08-06 | J1 | Futures | 0.0146607 | 0.0148029 | 0.0146028 | 0.0147299 | 132070.0 |
| 2010-08-06 | J7 | Futures | 0.014542 | 0.01469 | 0.014492 | 0.014619 | 359.0 |
| 2010-08-06 | JB | Futures | 120.95 | 121.07 | 120.73 | 120.8 | 2724.0 |
| 2010-08-06 | KC | Futures | 427.69 | 430.32 | 415.0 | 420.4 | 14196.0 |
| 2010-08-06 | KE | Futures | 3323.87 | 3506.04 | 3068.19 | 3068.19 | 22218.0 |
| 2010-08-06 | L | Futures | 98.096 | 98.106 | 98.086 | 98.096 | 21395.0 |
| 2010-08-06 | LBS | Futures | 609.3 | 611.4 | 591.9 | 593.6 | 535.0 |
> showing 50 of 89 rows — these rows as CSV