PREVIEW / futures_daily / 2008-09-23
file: by_date/futures_daily/2008/2008-09-23.parquet size: 8 KB rows: 83
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 |
|---|---|---|---|---|---|---|---|
| 2008-09-23 | ES | Futures | 1142.19 | 1151.37 | 1116.3 | 1117.71 | 3098102.0 |
| 2008-09-23 | NQ | Futures | 1867.25 | 1903.32 | 1842.92 | 1846.0 | 423082.0 |
| 2008-09-23 | YM | Futures | 9827.8 | 9900.7 | 9621.7 | 9642.1 | 237879.0 |
| 2008-09-23 | CL | Futures | 470.66 | 473.25 | 449.36 | 460.42 | 316025.0 |
| 2008-09-23 | GC | Futures | 1267.0 | 1279.9 | 1237.7 | 1246.3 | 152405.0 |
| 2008-09-23 | ZN | Futures | 86.107077 | 86.387594 | 85.709678 | 85.920066 | 909342.0 |
| 2008-09-23 | A6 | Futures | 0.65852 | 0.66174 | 0.6471 | 0.65529 | 39129.0 |
| 2008-09-23 | AD | Futures | 0.95465 | 0.9582 | 0.94942 | 0.95406 | 34230.0 |
| 2008-09-23 | B | Futures | 124.62 | 124.62 | 118.14 | 121.09 | 125254.0 |
| 2008-09-23 | B6 | Futures | 1.922 | 1.9284 | 1.9113 | 1.9248 | 60924.0 |
| 2008-09-23 | BFX | Futures | 3309.0 | 3309.0 | 3235.8 | 3253.9 | 411.0 |
| 2008-09-23 | BR | Futures | 0.2049 | 0.2049 | 0.20342 | 0.20342 | 9.0 |
| 2008-09-23 | BZ | Futures | 119.43 | 120.94 | 115.9 | 118.57 | 784.0 |
| 2008-09-23 | C | Futures | 1349.0 | 1362.0 | 1323.0 | 1332.0 | 3937.0 |
| 2008-09-23 | CB | Futures | 96.065 | 96.065 | 96.065 | 96.065 | 13.0 |
| 2008-09-23 | CC | Futures | 2427.0 | 2439.0 | 2386.0 | 2401.0 | 4659.0 |
| 2008-09-23 | CT | Futures | 63.56 | 63.79 | 61.68 | 62.03 | 641.0 |
| 2008-09-23 | DC | Futures | 42.87 | 43.58 | 42.29 | 42.31 | 152.0 |
| 2008-09-23 | DX | Futures | 79.96 | 80.782 | 79.86 | 80.295 | 8356.0 |
| 2008-09-23 | E1 | Futures | 1.25019 | 1.25019 | 1.2315 | 1.23951 | 44290.0 |
| 2008-09-23 | E6 | Futures | 1.7452 | 1.74934 | 1.72607 | 1.73693 | 207265.0 |
| 2008-09-23 | E7 | Futures | 1.7281 | 1.7325 | 1.7096 | 1.7203 | 4631.0 |
| 2008-09-23 | ED | Futures | 91.4211 | 91.4352 | 91.1755 | 91.251 | 309236.0 |
| 2008-09-23 | ER | Futures | 93.507 | 93.507 | 93.398 | 93.452 | 125899.0 |
| 2008-09-23 | EW | Futures | 757.6 | 764.5 | 743.4 | 747.5 | 38069.0 |
| 2008-09-23 | FCE | Futures | 2695.3 | 2711.0 | 2625.0 | 2665.4 | 151208.0 |
| 2008-09-23 | FDAX | Futures | 6847.6 | 6911.4 | 6772.7 | 6856.0 | 182053.0 |
| 2008-09-23 | FESX | Futures | 1832.6 | 1846.5 | 1799.0 | 1829.1 | 1687035.0 |
| 2008-09-23 | FEU3 | Futures | 94.057 | 94.057 | 93.998 | 94.008 | 1706.0 |
| 2008-09-23 | FGBL | Futures | 85.21 | 85.53 | 85.18 | 85.25 | 846723.0 |
| 2008-09-23 | FGBM | Futures | 91.07 | 91.44 | 91.05 | 91.28 | 545687.0 |
| 2008-09-23 | FGBS | Futures | 99.658 | 99.995 | 99.658 | 99.899 | 711256.0 |
| 2008-09-23 | FGBX | Futures | 73.72 | 74.28 | 73.6 | 73.77 | 1374.0 |
| 2008-09-23 | FTDX | Futures | 667.1 | 671.6 | 660.9 | 668.9 | 299.0 |
| 2008-09-23 | FTI | Futures | 288.07 | 290.78 | 283.21 | 285.02 | 47166.0 |
| 2008-09-23 | FTUK | Futures | 3400.9 | 3413.6 | 3301.4 | 3364.6 | 165096.0 |
| 2008-09-23 | G | Futures | 68.46 | 68.69 | 68.4 | 68.48 | 82301.0 |
| 2008-09-23 | GF | Futures | 286.242 | 287.586 | 285.57 | 286.511 | 318.0 |
| 2008-09-23 | GSCI | Futures | 1661.5 | 1681.48 | 1618.77 | 1654.0 | 273.0 |
| 2008-09-23 | HE | Futures | 145.438 | 145.982 | 143.536 | 144.134 | 5193.0 |
| 2008-09-23 | HG | Futures | 4.5739 | 4.6082 | 4.3758 | 4.4122 | 13191.0 |
| 2008-09-23 | HO | Futures | 3.4567 | 3.5075 | 3.3827 | 3.4428 | 12523.0 |
| 2008-09-23 | J1 | Futures | 0.0120665 | 0.0121069 | 0.0120097 | 0.0120855 | 78355.0 |
| 2008-09-23 | J7 | Futures | 0.011868 | 0.011918 | 0.011832 | 0.011902 | 34.0 |
| 2008-09-23 | KC | Futures | 404.12 | 406.48 | 396.89 | 397.92 | 7640.0 |
| 2008-09-23 | KE | Futures | 3990.53 | 4054.97 | 3944.12 | 4029.19 | 9467.0 |
| 2008-09-23 | L | Futures | 93.249 | 93.249 | 93.021 | 93.15 | 74700.0 |
| 2008-09-23 | LE | Futures | 190.497 | 190.497 | 188.755 | 189.672 | 5210.0 |
| 2008-09-23 | MP | Futures | 0.04554 | 0.04554 | 0.04468 | 0.04505 | 19539.0 |
| 2008-09-23 | N6 | Futures | 0.53496 | 0.53653 | 0.52501 | 0.53034 | 587.0 |
> showing 50 of 83 rows — these rows as CSV