PREVIEW / futures_daily / 2010-04-07
file: by_date/futures_daily/2010/2010-04-07.parquet size: 9 KB rows: 90
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-04-07 | ES | Futures | 1154.67 | 1155.15 | 1142.49 | 1148.09 | 2171684.0 |
| 2010-04-07 | NQ | Futures | 2245.04 | 2251.28 | 2228.31 | 2240.51 | 259268.0 |
| 2010-04-07 | YM | Futures | 10029.2 | 10031.0 | 9919.8 | 9973.1 | 149803.0 |
| 2010-04-07 | CL | Futures | 202.99 | 203.56 | 200.09 | 200.94 | 379528.0 |
| 2010-04-07 | GC | Futures | 1557.5 | 1583.6 | 1554.9 | 1582.0 | 163437.0 |
| 2010-04-07 | ZN | Futures | 94.147333 | 94.734 | 94.109072 | 94.695739 | 1194194.0 |
| 2010-04-07 | A6 | Futures | 0.7553 | 0.75718 | 0.75316 | 0.75587 | 78051.0 |
| 2010-04-07 | AD | Futures | 0.98567 | 0.98933 | 0.98123 | 0.9834 | 74358.0 |
| 2010-04-07 | B | Futures | 77.34 | 77.7 | 76.57 | 76.96 | 113602.0 |
| 2010-04-07 | B6 | Futures | 1.5844 | 1.5865 | 1.571 | 1.585 | 109151.0 |
| 2010-04-07 | BFX | Futures | 3017.8 | 3055.2 | 3015.9 | 3034.5 | 136.0 |
| 2010-04-07 | BR | Futures | 0.22828 | 0.22828 | 0.22828 | 0.22828 | 53.0 |
| 2010-04-07 | BZ | Futures | 80.64 | 80.64 | 80.64 | 80.64 | 1.0 |
| 2010-04-07 | C | Futures | 2182.0 | 2196.0 | 2155.0 | 2159.0 | 6246.0 |
| 2010-04-07 | CC | Futures | 2455.0 | 2461.0 | 2414.0 | 2421.0 | 8022.0 |
| 2010-04-07 | CT | Futures | 66.97 | 66.97 | 65.51 | 65.85 | 9743.0 |
| 2010-04-07 | DC | Futures | 23.56 | 23.79 | 23.28 | 23.51 | 411.0 |
| 2010-04-07 | DX | Futures | 82.705 | 83.004 | 82.629 | 82.702 | 17822.0 |
| 2010-04-07 | E1 | Futures | 1.23209 | 1.23301 | 1.22564 | 1.22853 | 49370.0 |
| 2010-04-07 | E6 | Futures | 1.58473 | 1.58627 | 1.57645 | 1.58189 | 289314.0 |
| 2010-04-07 | E7 | Futures | 1.5722 | 1.5735 | 1.5636 | 1.5689 | 3840.0 |
| 2010-04-07 | EBM | Futures | 206.86 | 208.5 | 206.45 | 207.68 | 5463.0 |
| 2010-04-07 | ED | Futures | 94.3897 | 94.4134 | 94.3897 | 94.4039 | 198334.0 |
| 2010-04-07 | ER | Futures | 97.355 | 97.37 | 97.35 | 97.36 | 97574.0 |
| 2010-04-07 | EW | Futures | 791.3 | 791.3 | 781.2 | 786.3 | 27781.0 |
| 2010-04-07 | FBTP | Futures | 64.76 | 64.86 | 64.72 | 64.8 | 2835.0 |
| 2010-04-07 | FCE | Futures | 2593.7 | 2604.6 | 2561.4 | 2578.4 | 92446.0 |
| 2010-04-07 | FDAX | Futures | 6813.4 | 6814.0 | 6743.8 | 6780.2 | 105657.0 |
| 2010-04-07 | FESX | Futures | 1787.6 | 1788.2 | 1766.8 | 1779.0 | 834774.0 |
| 2010-04-07 | FEU3 | Futures | 97.914 | 97.929 | 97.914 | 97.919 | 175.0 |
| 2010-04-07 | FGBL | Futures | 95.9 | 96.31 | 95.86 | 96.08 | 821389.0 |
| 2010-04-07 | FGBM | Futures | 101.68 | 102.04 | 101.64 | 101.82 | 471510.0 |
| 2010-04-07 | FGBS | Futures | 106.37 | 106.493 | 106.361 | 106.424 | 479368.0 |
| 2010-04-07 | FGBX | Futures | 91.58 | 91.89 | 91.39 | 91.42 | 2581.0 |
| 2010-04-07 | FTDX | Futures | 742.9 | 743.3 | 736.7 | 739.4 | 589.0 |
| 2010-04-07 | FTI | Futures | 285.59 | 287.7 | 284.26 | 286.04 | 26303.0 |
| 2010-04-07 | FTUK | Futures | 3875.6 | 3883.0 | 3845.1 | 3872.6 | 83648.0 |
| 2010-04-07 | G | Futures | 76.19 | 76.33 | 75.78 | 75.87 | 106159.0 |
| 2010-04-07 | GF | Futures | 297.277 | 297.995 | 293.037 | 294.994 | 1053.0 |
| 2010-04-07 | GSCI | Futures | 1001.27 | 1010.01 | 998.88 | 1001.09 | 2027.0 |
| 2010-04-07 | HE | Futures | 101.668 | 102.156 | 100.691 | 100.905 | 632.0 |
| 2010-04-07 | HG | Futures | 4.9458 | 4.9663 | 4.8679 | 4.9151 | 31829.0 |
| 2010-04-07 | HO | Futures | 2.0764 | 2.0828 | 2.0531 | 2.0608 | 29233.0 |
| 2010-04-07 | HRC | Futures | 3221.8 | 3221.8 | 3221.8 | 3221.8 | 0.0 |
| 2010-04-07 | J1 | Futures | 0.0134129 | 0.0135034 | 0.0133425 | 0.0134884 | 112985.0 |
| 2010-04-07 | J7 | Futures | 0.013308 | 0.013394 | 0.013237 | 0.013381 | 199.0 |
| 2010-04-07 | JB | Futures | 117.44 | 117.59 | 117.25 | 117.25 | 2100.0 |
| 2010-04-07 | KC | Futures | 356.61 | 357.51 | 350.57 | 353.27 | 11160.0 |
| 2010-04-07 | KE | Futures | 2131.44 | 2181.29 | 2103.75 | 2180.18 | 8465.0 |
| 2010-04-07 | L | Futures | 97.878 | 97.888 | 97.878 | 97.888 | 16139.0 |
> showing 50 of 90 rows — these rows as CSV