PREVIEW / futures_daily / 2009-02-03
file: by_date/futures_daily/2009/2009-02-03.parquet size: 8 KB rows: 86
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 |
|---|---|---|---|---|---|---|---|
| 2009-02-03 | ES | Futures | 775.97 | 792.97 | 770.54 | 785.18 | 2093215.0 |
| 2009-02-03 | NQ | Futures | 1330.12 | 1361.43 | 1316.43 | 1350.25 | 305832.0 |
| 2009-02-03 | YM | Futures | 7022.5 | 7179.2 | 6980.7 | 7110.7 | 178574.0 |
| 2009-02-03 | CL | Futures | 133.81 | 136.77 | 131.72 | 135.47 | 244615.0 |
| 2009-02-03 | GC | Futures | 1255.1 | 1268.8 | 1235.5 | 1238.5 | 107990.0 |
| 2009-02-03 | ZN | Futures | 94.714322 | 94.726275 | 93.411462 | 93.746142 | 493337.0 |
| 2009-02-03 | A6 | Futures | 0.49846 | 0.51766 | 0.4983 | 0.51615 | 34310.0 |
| 2009-02-03 | AD | Futures | 0.78916 | 0.79937 | 0.78415 | 0.79544 | 28613.0 |
| 2009-02-03 | B | Futures | 46.53 | 46.65 | 45.59 | 45.81 | 76049.0 |
| 2009-02-03 | B6 | Futures | 1.4793 | 1.5046 | 1.4701 | 1.498 | 77283.0 |
| 2009-02-03 | BFX | Futures | 2050.6 | 2070.3 | 2048.0 | 2068.4 | 1618.0 |
| 2009-02-03 | BZ | Futures | 47.3 | 47.32 | 47.08 | 47.08 | 60.0 |
| 2009-02-03 | C | Futures | 1944.0 | 1979.0 | 1944.0 | 1959.0 | 4460.0 |
| 2009-02-03 | CB | Futures | 74.689 | 74.689 | 74.689 | 74.689 | 7.0 |
| 2009-02-03 | CC | Futures | 2398.0 | 2435.0 | 2377.0 | 2418.0 | 4173.0 |
| 2009-02-03 | CT | Futures | 48.21 | 48.62 | 47.45 | 48.07 | 8333.0 |
| 2009-02-03 | DC | Futures | 26.73 | 27.1 | 26.3 | 26.43 | 244.0 |
| 2009-02-03 | DX | Futures | 89.632 | 89.866 | 88.31 | 88.585 | 5578.0 |
| 2009-02-03 | E1 | Futures | 1.14467 | 1.16674 | 1.14015 | 1.16182 | 36754.0 |
| 2009-02-03 | E6 | Futures | 1.51705 | 1.54499 | 1.51468 | 1.53907 | 196768.0 |
| 2009-02-03 | E7 | Futures | 1.4995 | 1.5273 | 1.4975 | 1.5215 | 2660.0 |
| 2009-02-03 | EBM | Futures | 229.32 | 229.32 | 223.95 | 224.34 | 2835.0 |
| 2009-02-03 | ED | Futures | 92.973 | 93.053 | 92.9494 | 93.0154 | 207872.0 |
| 2009-02-03 | ER | Futures | 96.214 | 96.268 | 96.209 | 96.248 | 91246.0 |
| 2009-02-03 | EW | Futures | 485.4 | 494.7 | 482.0 | 488.4 | 29038.0 |
| 2009-02-03 | FCE | Futures | 1814.0 | 1867.2 | 1792.1 | 1843.7 | 131715.0 |
| 2009-02-03 | FDAX | Futures | 4668.6 | 4836.7 | 4614.5 | 4776.7 | 164821.0 |
| 2009-02-03 | FESX | Futures | 1263.4 | 1307.1 | 1253.0 | 1289.2 | 1230700.0 |
| 2009-02-03 | FEU3 | Futures | 96.795 | 96.83 | 96.795 | 96.815 | 1287.0 |
| 2009-02-03 | FGBL | Futures | 91.61 | 91.75 | 91.0 | 91.26 | 591544.0 |
| 2009-02-03 | FGBM | Futures | 97.17 | 97.41 | 96.96 | 97.15 | 281030.0 |
| 2009-02-03 | FGBS | Futures | 103.484 | 103.604 | 103.45 | 103.508 | 341192.0 |
| 2009-02-03 | FGBX | Futures | 83.32 | 84.48 | 82.96 | 83.39 | 1298.0 |
| 2009-02-03 | FTDX | Futures | 420.6 | 428.7 | 416.1 | 424.2 | 393.0 |
| 2009-02-03 | FTI | Futures | 198.34 | 202.17 | 195.07 | 201.77 | 34161.0 |
| 2009-02-03 | FTUK | Futures | 2659.4 | 2743.6 | 2624.0 | 2706.6 | 124641.0 |
| 2009-02-03 | G | Futures | 73.65 | 73.65 | 73.04 | 73.26 | 74082.0 |
| 2009-02-03 | GF | Futures | 263.081 | 263.572 | 261.047 | 262.099 | 488.0 |
| 2009-02-03 | GSCI | Futures | 768.33 | 773.96 | 763.64 | 769.27 | 203.0 |
| 2009-02-03 | HE | Futures | 118.885 | 120.867 | 116.759 | 120.142 | 4846.0 |
| 2009-02-03 | HG | Futures | 2.0289 | 2.1605 | 2.0275 | 2.1422 | 13386.0 |
| 2009-02-03 | HO | Futures | 1.4629 | 1.5147 | 1.4629 | 1.4762 | 32186.0 |
| 2009-02-03 | HRC | Futures | 3041.9 | 3041.9 | 3041.9 | 3041.9 | 0.0 |
| 2009-02-03 | J1 | Futures | 0.0141483 | 0.0142734 | 0.014051 | 0.0141672 | 95760.0 |
| 2009-02-03 | J7 | Futures | 0.013977 | 0.014107 | 0.013886 | 0.013997 | 69.0 |
| 2009-02-03 | JB | Futures | 116.12 | 116.4 | 115.89 | 116.12 | 77.0 |
| 2009-02-03 | KC | Futures | 342.25 | 343.54 | 336.68 | 340.82 | 9464.0 |
| 2009-02-03 | KE | Futures | 2962.93 | 3000.4 | 2902.97 | 2902.97 | 6717.0 |
| 2009-02-03 | L | Futures | 96.792 | 96.817 | 96.782 | 96.812 | 36725.0 |
| 2009-02-03 | LBS | Futures | 898.6 | 926.1 | 889.6 | 918.2 | 214.0 |
> showing 50 of 86 rows — these rows as CSV