PREVIEW / futures_daily / 2008-11-19
file: by_date/futures_daily/2008/2008-11-19.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 |
|---|---|---|---|---|---|---|---|
| 2008-11-19 | ES | Futures | 814.74 | 815.45 | 757.3 | 765.07 | 3430032.0 |
| 2008-11-19 | NQ | Futures | 1306.91 | 1310.82 | 1211.0 | 1221.9 | 469239.0 |
| 2008-11-19 | YM | Futures | 7533.2 | 7548.3 | 7080.1 | 7130.8 | 324038.0 |
| 2008-11-19 | CL | Futures | 232.9 | 235.73 | 225.62 | 228.75 | 219553.0 |
| 2008-11-19 | GC | Futures | 1031.8 | 1069.6 | 1022.8 | 1029.3 | 143008.0 |
| 2008-11-19 | ZN | Futures | 88.57329 | 89.473283 | 88.549914 | 89.204454 | 728414.0 |
| 2008-11-19 | A6 | Futures | 0.51081 | 0.5179 | 0.49877 | 0.50672 | 26359.0 |
| 2008-11-19 | AD | Futures | 0.80034 | 0.80271 | 0.78456 | 0.79018 | 26605.0 |
| 2008-11-19 | B | Futures | 58.97 | 60.18 | 57.52 | 58.79 | 107680.0 |
| 2008-11-19 | B6 | Futures | 1.5531 | 1.5832 | 1.5468 | 1.5597 | 73018.0 |
| 2008-11-19 | BFX | Futures | 2254.6 | 2254.6 | 2179.4 | 2182.5 | 3213.0 |
| 2008-11-19 | BR | Futures | 0.15985 | 0.15985 | 0.15645 | 0.15721 | 19.0 |
| 2008-11-19 | BZ | Futures | 57.77 | 58.11 | 56.63 | 56.95 | 186.0 |
| 2008-11-19 | C | Futures | 1303.0 | 1322.0 | 1286.0 | 1319.0 | 1585.0 |
| 2008-11-19 | CC | Futures | 1809.0 | 1860.0 | 1787.0 | 1828.0 | 6815.0 |
| 2008-11-19 | CT | Futures | 39.03 | 41.54 | 38.54 | 40.63 | 3232.0 |
| 2008-11-19 | DC | Futures | 38.61 | 38.73 | 37.79 | 37.84 | 120.0 |
| 2008-11-19 | DX | Futures | 91.698 | 93.494 | 90.483 | 91.729 | 4826.0 |
| 2008-11-19 | E1 | Futures | 1.11052 | 1.1184 | 1.09931 | 1.10345 | 39287.0 |
| 2008-11-19 | E6 | Futures | 1.49096 | 1.51223 | 1.47324 | 1.48718 | 217601.0 |
| 2008-11-19 | E7 | Futures | 1.4762 | 1.4977 | 1.4591 | 1.4729 | 3839.0 |
| 2008-11-19 | ED | Futures | 92.5262 | 92.571 | 92.4718 | 92.5521 | 143149.0 |
| 2008-11-19 | ER | Futures | 95.144 | 95.257 | 95.144 | 95.188 | 79323.0 |
| 2008-11-19 | EW | Futures | 489.5 | 489.6 | 443.2 | 446.6 | 43730.0 |
| 2008-11-19 | FCE | Futures | 1933.8 | 1942.2 | 1811.0 | 1847.8 | 123022.0 |
| 2008-11-19 | FDAX | Futures | 5172.6 | 5187.7 | 4787.3 | 4870.1 | 196490.0 |
| 2008-11-19 | FESX | Futures | 1392.9 | 1395.8 | 1299.8 | 1327.6 | 1768353.0 |
| 2008-11-19 | FEU3 | Futures | 95.734 | 95.788 | 95.734 | 95.754 | 886.0 |
| 2008-11-19 | FGBL | Futures | 89.74 | 90.28 | 89.58 | 90.06 | 728119.0 |
| 2008-11-19 | FGBM | Futures | 95.99 | 96.21 | 95.86 | 96.11 | 483336.0 |
| 2008-11-19 | FGBS | Futures | 102.74 | 102.74 | 102.629 | 102.668 | 417367.0 |
| 2008-11-19 | FGBX | Futures | 80.75 | 81.96 | 80.75 | 81.62 | 2985.0 |
| 2008-11-19 | FTDX | Futures | 439.4 | 439.4 | 406.3 | 409.9 | 501.0 |
| 2008-11-19 | FTI | Futures | 201.3 | 201.86 | 190.47 | 190.99 | 29194.0 |
| 2008-11-19 | FTUK | Futures | 2726.6 | 2735.3 | 2538.5 | 2595.9 | 144249.0 |
| 2008-11-19 | G | Futures | 71.59 | 71.74 | 71.41 | 71.59 | 71558.0 |
| 2008-11-19 | GF | Futures | 253.017 | 254.883 | 244.724 | 248.386 | 900.0 |
| 2008-11-19 | GSCI | Futures | 974.89 | 995.56 | 973.13 | 977.27 | 74.0 |
| 2008-11-19 | HE | Futures | 120.625 | 122.075 | 120.383 | 121.591 | 4781.0 |
| 2008-11-19 | HG | Futures | 2.3857 | 2.3857 | 2.2449 | 2.2653 | 7057.0 |
| 2008-11-19 | HO | Futures | 2.0215 | 2.0443 | 2.0036 | 2.0067 | 3497.0 |
| 2008-11-19 | HRC | Futures | 3762.7 | 3762.7 | 3762.7 | 3762.7 | 0.0 |
| 2008-11-19 | J1 | Futures | 0.0130354 | 0.0132186 | 0.0130165 | 0.0131112 | 103079.0 |
| 2008-11-19 | J7 | Futures | 0.012918 | 0.01301 | 0.012826 | 0.012912 | 28.0 |
| 2008-11-19 | JB | Futures | 115.56 | 115.6 | 115.31 | 115.52 | 1.0 |
| 2008-11-19 | KC | Futures | 326.24 | 336.82 | 322.1 | 325.96 | 11042.0 |
| 2008-11-19 | KE | Futures | 2891.07 | 2949.07 | 2880.76 | 2884.62 | 5358.0 |
| 2008-11-19 | L | Futures | 95.783 | 95.852 | 95.679 | 95.738 | 50342.0 |
| 2008-11-19 | LBS | Futures | 1208.8 | 1216.6 | 1198.1 | 1215.0 | 37.0 |
| 2008-11-19 | LE | Futures | 156.985 | 158.014 | 151.44 | 152.334 | 5968.0 |
> showing 50 of 85 rows — these rows as CSV