PREVIEW / futures_daily / 2011-08-26
file: by_date/futures_daily/2011/2011-08-26.parquet size: 9 KB rows: 94
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 |
|---|---|---|---|---|---|---|---|
| 2011-08-26 | ES | Futures | 1149.06 | 1171.65 | 1124.97 | 1167.93 | 3053686.0 |
| 2011-08-26 | NQ | Futures | 2403.92 | 2469.97 | 2369.47 | 2464.27 | 344089.0 |
| 2011-08-26 | YM | Futures | 10523.3 | 10692.5 | 10313.4 | 10663.2 | 152729.0 |
| 2011-08-26 | CL | Futures | 162.08 | 163.13 | 158.01 | 162.62 | 283261.0 |
| 2011-08-26 | GC | Futures | 2398.4 | 2474.2 | 2375.6 | 2426.6 | 265243.0 |
| 2011-08-26 | ZN | Futures | 110.590931 | 111.389229 | 110.511101 | 110.93686 | 1944811.0 |
| 2011-08-26 | A6 | Futures | 0.90465 | 0.91891 | 0.90378 | 0.91587 | 128266.0 |
| 2011-08-26 | AD | Futures | 1.00944 | 1.01692 | 1.00504 | 1.01263 | 100553.0 |
| 2011-08-26 | B | Futures | 94.64 | 95.37 | 93.34 | 95.08 | 80145.0 |
| 2011-08-26 | B6 | Futures | 1.694 | 1.7038 | 1.6857 | 1.699 | 94879.0 |
| 2011-08-26 | BFX | Futures | 2620.9 | 2620.9 | 2603.6 | 2610.9 | 56.0 |
| 2011-08-26 | BR | Futures | 0.27633 | 0.27746 | 0.27633 | 0.27746 | 595.0 |
| 2011-08-26 | BZ | Futures | 97.45 | 98.76 | 96.91 | 98.49 | 1380.0 |
| 2011-08-26 | C | Futures | 2057.0 | 2089.0 | 2057.0 | 2080.0 | 1291.0 |
| 2011-08-26 | CC | Futures | 2388.0 | 2424.0 | 2385.0 | 2411.0 | 5714.0 |
| 2011-08-26 | CT | Futures | 133.8 | 136.08 | 132.23 | 134.86 | 16.0 |
| 2011-08-26 | DC | Futures | 30.26 | 30.3 | 29.89 | 30.21 | 72.0 |
| 2011-08-26 | DX | Futures | 73.568 | 73.831 | 73.053 | 73.156 | 29768.0 |
| 2011-08-26 | E1 | Futures | 1.6492 | 1.65809 | 1.60408 | 1.62108 | 39053.0 |
| 2011-08-26 | E6 | Futures | 1.7067 | 1.72214 | 1.70124 | 1.71977 | 350854.0 |
| 2011-08-26 | E7 | Futures | 1.6945 | 1.7093 | 1.6888 | 1.7072 | 5505.0 |
| 2011-08-26 | ED | Futures | 94.9311 | 94.943 | 94.9287 | 94.9311 | 174092.0 |
| 2011-08-26 | ER | Futures | 97.504 | 97.519 | 97.494 | 97.504 | 55388.0 |
| 2011-08-26 | EW | Futures | 807.7 | 830.1 | 789.9 | 827.3 | 36024.0 |
| 2011-08-26 | FBTP | Futures | 64.52 | 64.58 | 64.4 | 64.49 | 5957.0 |
| 2011-08-26 | FCE | Futures | 2189.9 | 2192.0 | 2110.6 | 2164.3 | 90774.0 |
| 2011-08-26 | FDAX | Futures | 5964.4 | 5975.1 | 5775.3 | 5911.5 | 200947.0 |
| 2011-08-26 | FESX | Futures | 1420.7 | 1424.6 | 1370.7 | 1400.8 | 1399927.0 |
| 2011-08-26 | FEU3 | Futures | 98.044 | 98.054 | 98.044 | 98.044 | 64.0 |
| 2011-08-26 | FGBL | Futures | 108.11 | 108.97 | 108.03 | 108.47 | 685610.0 |
| 2011-08-26 | FGBM | Futures | 109.84 | 110.37 | 109.78 | 109.97 | 401070.0 |
| 2011-08-26 | FGBS | Futures | 108.92 | 109.059 | 108.855 | 108.89 | 417483.0 |
| 2011-08-26 | FGBX | Futures | 106.1 | 107.82 | 106.07 | 107.07 | 3784.0 |
| 2011-08-26 | FTDX | Futures | 638.6 | 641.7 | 622.5 | 636.8 | 292.0 |
| 2011-08-26 | FTI | Futures | 227.4 | 227.77 | 220.22 | 225.81 | 45173.0 |
| 2011-08-26 | FTUK | Futures | 3608.7 | 3648.6 | 3531.8 | 3613.7 | 125235.0 |
| 2011-08-26 | FVSA | Futures | 15368.44 | 16105.82 | 15310.23 | 15349.04 | 1603.0 |
| 2011-08-26 | FXXP | Futures | 152.4 | 152.7 | 150.5 | 152.5 | 5356.0 |
| 2011-08-26 | G | Futures | 90.44 | 90.7 | 90.06 | 90.07 | 171186.0 |
| 2011-08-26 | GF | Futures | 303.207 | 305.783 | 300.517 | 303.608 | 1508.0 |
| 2011-08-26 | GSCI | Futures | 1026.89 | 1032.21 | 1011.22 | 1031.9 | 131.0 |
| 2011-08-26 | HE | Futures | 106.504 | 107.145 | 105.924 | 106.382 | 15328.0 |
| 2011-08-26 | HG | Futures | 5.4268 | 5.485 | 5.3798 | 5.4486 | 22368.0 |
| 2011-08-26 | HO | Futures | 2.4158 | 2.4372 | 2.3916 | 2.4309 | 14511.0 |
| 2011-08-26 | HRC | Futures | 2910.3 | 2910.3 | 2910.3 | 2910.3 | 0.0 |
| 2011-08-26 | J1 | Futures | 0.0162356 | 0.0164341 | 0.016228 | 0.0163914 | 116453.0 |
| 2011-08-26 | J7 | Futures | 0.016133 | 0.016322 | 0.016123 | 0.016282 | 525.0 |
| 2011-08-26 | JB | Futures | 123.95 | 124.06 | 123.84 | 123.96 | 1257.0 |
| 2011-08-26 | KC | Futures | 649.79 | 660.99 | 648.61 | 657.92 | 10415.0 |
| 2011-08-26 | KE | Futures | 3256.84 | 3346.69 | 3238.13 | 3339.2 | 22308.0 |
> showing 50 of 94 rows — these rows as CSV