PREVIEW / futures_daily / 2010-08-13
file: by_date/futures_daily/2010/2010-08-13.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-13 | ES | Futures | 1052.89 | 1062.16 | 1046.07 | 1049.48 | 1479393.0 |
| 2010-08-13 | NQ | Futures | 2071.24 | 2085.67 | 2054.54 | 2054.54 | 239248.0 |
| 2010-08-13 | YM | Futures | 9496.5 | 9576.0 | 9451.1 | 9491.8 | 105146.0 |
| 2010-08-13 | CL | Futures | 160.83 | 162.93 | 159.26 | 160.06 | 286126.0 |
| 2010-08-13 | GC | Futures | 1653.0 | 1658.0 | 1647.8 | 1653.7 | 73006.0 |
| 2010-08-13 | ZN | Futures | 102.706269 | 102.9752 | 102.642237 | 102.923975 | 838514.0 |
| 2010-08-13 | A6 | Futures | 0.74016 | 0.74629 | 0.73684 | 0.73776 | 87736.0 |
| 2010-08-13 | AD | Futures | 0.94658 | 0.95379 | 0.94569 | 0.94718 | 70227.0 |
| 2010-08-13 | B | Futures | 66.08 | 66.71 | 65.23 | 65.61 | 174449.0 |
| 2010-08-13 | B6 | Futures | 1.6161 | 1.6273 | 1.6158 | 1.6178 | 94139.0 |
| 2010-08-13 | BR | Futures | 0.2353 | 0.2353 | 0.2347 | 0.2347 | 15.0 |
| 2010-08-13 | BZ | Futures | 70.69 | 70.69 | 70.22 | 70.6 | 80.0 |
| 2010-08-13 | C | Futures | 2311.0 | 2320.0 | 2300.0 | 2300.0 | 1947.0 |
| 2010-08-13 | CB | Futures | 92.227 | 92.71 | 91.503 | 91.503 | 16.0 |
| 2010-08-13 | CC | Futures | 2401.0 | 2409.0 | 2378.0 | 2389.0 | 6103.0 |
| 2010-08-13 | CT | Futures | 73.19 | 75.01 | 73.19 | 73.6 | 72.0 |
| 2010-08-13 | DC | Futures | 23.83 | 23.89 | 23.65 | 23.68 | 80.0 |
| 2010-08-13 | DX | Futures | 83.355 | 84.01 | 82.941 | 83.695 | 15089.0 |
| 2010-08-13 | E1 | Futures | 1.25134 | 1.25331 | 1.24516 | 1.24687 | 27481.0 |
| 2010-08-13 | E6 | Futures | 1.51667 | 1.52613 | 1.50756 | 1.50792 | 281618.0 |
| 2010-08-13 | E7 | Futures | 1.5059 | 1.5149 | 1.4966 | 1.4971 | 4137.0 |
| 2010-08-13 | ED | Futures | 94.5369 | 94.5464 | 94.5226 | 94.5321 | 168859.0 |
| 2010-08-13 | ER | Futures | 97.281 | 97.301 | 97.272 | 97.286 | 54225.0 |
| 2010-08-13 | EW | Futures | 721.3 | 728.4 | 716.3 | 718.6 | 18275.0 |
| 2010-08-13 | FBTP | Futures | 66.72 | 66.74 | 66.41 | 66.64 | 5605.0 |
| 2010-08-13 | FCE | Futures | 2395.3 | 2405.9 | 2356.7 | 2377.5 | 4070.0 |
| 2010-08-13 | FDAX | Futures | 6701.4 | 6721.5 | 6604.6 | 6650.8 | 128942.0 |
| 2010-08-13 | FESX | Futures | 1694.1 | 1700.9 | 1662.5 | 1674.9 | 1122453.0 |
| 2010-08-13 | FEU3 | Futures | 97.845 | 97.845 | 97.84 | 97.845 | 107.0 |
| 2010-08-13 | FGBL | Futures | 102.3 | 102.73 | 102.27 | 102.69 | 698263.0 |
| 2010-08-13 | FGBM | Futures | 106.09 | 106.24 | 106.02 | 106.19 | 379383.0 |
| 2010-08-13 | FGBS | Futures | 107.716 | 107.765 | 107.662 | 107.74 | 335607.0 |
| 2010-08-13 | FGBX | Futures | 102.49 | 103.19 | 102.49 | 103.08 | 3040.0 |
| 2010-08-13 | FTDX | Futures | 663.7 | 665.0 | 654.0 | 655.8 | 196.0 |
| 2010-08-13 | FTI | Futures | 260.41 | 260.73 | 256.58 | 258.7 | 4206.0 |
| 2010-08-13 | FTUK | Futures | 3641.4 | 3645.9 | 3587.0 | 3623.2 | 88250.0 |
| 2010-08-13 | G | Futures | 82.99 | 83.09 | 82.89 | 83.04 | 67160.0 |
| 2010-08-13 | GF | Futures | 282.928 | 283.055 | 281.033 | 281.349 | 1128.0 |
| 2010-08-13 | GSCI | Futures | 874.14 | 874.99 | 867.52 | 868.63 | 687.0 |
| 2010-08-13 | HE | Futures | 98.767 | 99.623 | 97.647 | 98.339 | 13778.0 |
| 2010-08-13 | HG | Futures | 4.4008 | 4.4357 | 4.3339 | 4.3553 | 37033.0 |
| 2010-08-13 | HO | Futures | 1.754 | 1.7773 | 1.7417 | 1.7488 | 43580.0 |
| 2010-08-13 | HRC | Futures | 2753.7 | 2753.7 | 2753.7 | 2753.7 | 0.0 |
| 2010-08-13 | J1 | Futures | 0.0146519 | 0.0147073 | 0.0145676 | 0.014594 | 93452.0 |
| 2010-08-13 | J7 | Futures | 0.014525 | 0.014595 | 0.014459 | 0.014484 | 214.0 |
| 2010-08-13 | JB | Futures | 121.13 | 121.32 | 121.04 | 121.31 | 2207.0 |
| 2010-08-13 | KC | Futures | 442.0 | 448.66 | 435.22 | 440.74 | 12098.0 |
| 2010-08-13 | KE | Futures | 3089.49 | 3156.61 | 3072.45 | 3083.1 | 7921.0 |
| 2010-08-13 | L | Futures | 98.125 | 98.135 | 98.125 | 98.135 | 32170.0 |
| 2010-08-13 | LBS | Futures | 588.0 | 600.1 | 588.0 | 596.6 | 137.0 |
> showing 50 of 89 rows — these rows as CSV