PREVIEW / futures_daily / 2009-01-26
file: by_date/futures_daily/2009/2009-01-26.parquet size: 8 KB rows: 85
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-01-26 | ES | Futures | 777.62 | 802.17 | 765.58 | 784.47 | 2254244.0 |
| 2009-01-26 | NQ | Futures | 1302.45 | 1342.98 | 1282.05 | 1318.67 | 300366.0 |
| 2009-01-26 | YM | Futures | 7106.2 | 7285.2 | 7009.2 | 7156.1 | 209673.0 |
| 2009-01-26 | CL | Futures | 152.98 | 161.42 | 150.32 | 151.92 | 277496.0 |
| 2009-01-26 | GC | Futures | 1248.9 | 1274.2 | 1236.7 | 1263.8 | 54981.0 |
| 2009-01-26 | ZN | Futures | 94.774086 | 94.941426 | 94.224255 | 94.594793 | 490652.0 |
| 2009-01-26 | A6 | Futures | 0.51877 | 0.52487 | 0.51298 | 0.51908 | 27248.0 |
| 2009-01-26 | AD | Futures | 0.79721 | 0.8089 | 0.79259 | 0.80124 | 30095.0 |
| 2009-01-26 | B | Futures | 49.43 | 51.44 | 48.59 | 48.96 | 55616.0 |
| 2009-01-26 | B6 | Futures | 1.4349 | 1.4533 | 1.4064 | 1.4474 | 75808.0 |
| 2009-01-26 | BFX | Futures | 2038.5 | 2088.3 | 2029.1 | 2078.1 | 302.0 |
| 2009-01-26 | BZ | Futures | 50.93 | 52.58 | 50.32 | 50.32 | 40.0 |
| 2009-01-26 | C | Futures | 2010.0 | 2028.0 | 1955.0 | 1973.0 | 10593.0 |
| 2009-01-26 | CB | Futures | 76.342 | 76.672 | 76.342 | 76.672 | 5.0 |
| 2009-01-26 | CC | Futures | 2357.0 | 2396.0 | 2320.0 | 2353.0 | 5467.0 |
| 2009-01-26 | CT | Futures | 49.17 | 50.81 | 48.97 | 50.68 | 6676.0 |
| 2009-01-26 | DC | Futures | 26.97 | 27.67 | 26.35 | 26.86 | 307.0 |
| 2009-01-26 | DX | Futures | 89.451 | 90.068 | 88.004 | 88.352 | 3498.0 |
| 2009-01-26 | E1 | Futures | 1.15344 | 1.17272 | 1.14201 | 1.16634 | 34294.0 |
| 2009-01-26 | E6 | Futures | 1.53528 | 1.5624 | 1.52155 | 1.55387 | 178461.0 |
| 2009-01-26 | E7 | Futures | 1.5156 | 1.5445 | 1.5045 | 1.5361 | 3102.0 |
| 2009-01-26 | EBM | Futures | 233.16 | 239.68 | 233.16 | 236.22 | 3592.0 |
| 2009-01-26 | ED | Futures | 93.086 | 93.1378 | 93.0719 | 93.1095 | 152318.0 |
| 2009-01-26 | ER | Futures | 96.297 | 96.317 | 96.174 | 96.199 | 176214.0 |
| 2009-01-26 | EW | Futures | 485.4 | 501.8 | 477.0 | 490.0 | 33020.0 |
| 2009-01-26 | FCE | Futures | 1751.6 | 1837.8 | 1744.2 | 1828.0 | 131823.0 |
| 2009-01-26 | FDAX | Futures | 4525.0 | 4785.4 | 4521.7 | 4727.5 | 175202.0 |
| 2009-01-26 | FESX | Futures | 1223.2 | 1289.2 | 1221.4 | 1277.2 | 1304865.0 |
| 2009-01-26 | FEU3 | Futures | 96.864 | 96.864 | 96.746 | 96.771 | 633.0 |
| 2009-01-26 | FGBL | Futures | 92.09 | 92.14 | 91.22 | 91.4 | 660543.0 |
| 2009-01-26 | FGBM | Futures | 97.38 | 97.42 | 96.6 | 96.68 | 446682.0 |
| 2009-01-26 | FGBS | Futures | 103.604 | 103.623 | 103.133 | 103.177 | 616627.0 |
| 2009-01-26 | FGBX | Futures | 81.23 | 81.23 | 80.28 | 80.53 | 2298.0 |
| 2009-01-26 | FTDX | Futures | 401.8 | 416.1 | 396.5 | 413.5 | 717.0 |
| 2009-01-26 | FTI | Futures | 187.57 | 199.75 | 186.12 | 199.03 | 36665.0 |
| 2009-01-26 | FTUK | Futures | 2622.7 | 2745.6 | 2619.0 | 2732.2 | 126631.0 |
| 2009-01-26 | G | Futures | 73.55 | 73.74 | 73.22 | 73.48 | 50180.0 |
| 2009-01-26 | GF | Futures | 261.608 | 263.712 | 256.418 | 257.33 | 379.0 |
| 2009-01-26 | GSCI | Futures | 820.86 | 849.01 | 818.28 | 819.69 | 58.0 |
| 2009-01-26 | HE | Futures | 125.071 | 125.071 | 121.205 | 121.35 | 5079.0 |
| 2009-01-26 | HG | Futures | 2.0648 | 2.2956 | 2.031 | 2.2329 | 16649.0 |
| 2009-01-26 | HO | Futures | 1.6038 | 1.6498 | 1.5618 | 1.5843 | 34404.0 |
| 2009-01-26 | HRC | Futures | 3189.6 | 3189.6 | 3189.6 | 3189.6 | 0.0 |
| 2009-01-26 | J1 | Futures | 0.0142531 | 0.0143239 | 0.0140927 | 0.0142102 | 74114.0 |
| 2009-01-26 | J7 | Futures | 0.014107 | 0.014147 | 0.013928 | 0.014039 | 53.0 |
| 2009-01-26 | JB | Futures | 117.02 | 117.02 | 116.82 | 116.9 | 898.0 |
| 2009-01-26 | KC | Futures | 340.25 | 350.11 | 339.39 | 349.25 | 8555.0 |
| 2009-01-26 | KE | Futures | 3050.37 | 3177.78 | 3049.12 | 3106.58 | 6936.0 |
| 2009-01-26 | L | Futures | 96.95 | 97.004 | 96.925 | 96.96 | 33372.0 |
| 2009-01-26 | LBS | Futures | 858.2 | 871.1 | 831.3 | 831.3 | 32.0 |
> showing 50 of 85 rows — these rows as CSV