PREVIEW / futures_daily / 2009-01-05
file: by_date/futures_daily/2009/2009-01-05.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-05 | ES | Futures | 873.23 | 882.2 | 865.44 | 875.83 | 1606235.0 |
| 2009-01-05 | NQ | Futures | 1399.44 | 1425.43 | 1391.06 | 1414.25 | 206046.0 |
| 2009-01-05 | YM | Futures | 7960.1 | 8004.6 | 7871.9 | 7940.5 | 138299.0 |
| 2009-01-05 | CL | Futures | 186.75 | 195.65 | 180.88 | 193.78 | 258762.0 |
| 2009-01-05 | GC | Futures | 1227.9 | 1234.6 | 1176.0 | 1196.0 | 95451.0 |
| 2009-01-05 | ZN | Futures | 95.240247 | 95.455398 | 94.570888 | 94.989237 | 400874.0 |
| 2009-01-05 | A6 | Futures | 0.56215 | 0.56786 | 0.55644 | 0.56366 | 20633.0 |
| 2009-01-05 | AD | Futures | 0.8145 | 0.82767 | 0.8032 | 0.8259 | 29642.0 |
| 2009-01-05 | B | Futures | 51.44 | 54.51 | 50.59 | 54.07 | 78182.0 |
| 2009-01-05 | B6 | Futures | 1.5089 | 1.5297 | 1.4969 | 1.5281 | 45461.0 |
| 2009-01-05 | BFX | Futures | 2228.3 | 2228.9 | 2176.3 | 2204.6 | 395.0 |
| 2009-01-05 | BZ | Futures | 53.15 | 54.28 | 53.15 | 54.28 | 352.0 |
| 2009-01-05 | C | Futures | 1782.0 | 1805.0 | 1767.0 | 1793.0 | 3499.0 |
| 2009-01-05 | CB | Futures | 77.664 | 77.994 | 77.664 | 77.664 | 45.0 |
| 2009-01-05 | CC | Futures | 2226.0 | 2272.0 | 2215.0 | 2254.0 | 4038.0 |
| 2009-01-05 | CT | Futures | 46.8 | 47.6 | 45.65 | 47.02 | 6239.0 |
| 2009-01-05 | DC | Futures | 28.9 | 29.04 | 28.31 | 28.82 | 230.0 |
| 2009-01-05 | DX | Futures | 85.51 | 87.206 | 85.236 | 86.661 | 4415.0 |
| 2009-01-05 | E1 | Futures | 1.22987 | 1.24276 | 1.19491 | 1.20023 | 35398.0 |
| 2009-01-05 | E6 | Futures | 1.64255 | 1.64941 | 1.59981 | 1.60691 | 144156.0 |
| 2009-01-05 | E7 | Futures | 1.6232 | 1.6303 | 1.5815 | 1.5885 | 2932.0 |
| 2009-01-05 | EBM | Futures | 213.22 | 220.12 | 213.22 | 219.74 | 2480.0 |
| 2009-01-05 | ED | Futures | 93.0954 | 93.1943 | 93.0766 | 93.1661 | 171123.0 |
| 2009-01-05 | ER | Futures | 95.861 | 95.875 | 95.821 | 95.866 | 103866.0 |
| 2009-01-05 | EW | Futures | 533.9 | 541.1 | 526.8 | 538.1 | 26082.0 |
| 2009-01-05 | FCE | Futures | 2079.7 | 2085.6 | 2047.4 | 2069.6 | 77876.0 |
| 2009-01-05 | FDAX | Futures | 5494.0 | 5521.3 | 5422.5 | 5451.4 | 95826.0 |
| 2009-01-05 | FESX | Futures | 1469.1 | 1478.8 | 1454.7 | 1465.6 | 771465.0 |
| 2009-01-05 | FEU3 | Futures | 96.435 | 96.435 | 96.396 | 96.43 | 1084.0 |
| 2009-01-05 | FGBL | Futures | 93.21 | 93.29 | 92.63 | 93.11 | 428405.0 |
| 2009-01-05 | FGBM | Futures | 97.64 | 97.72 | 97.3 | 97.62 | 242857.0 |
| 2009-01-05 | FGBS | Futures | 103.124 | 103.253 | 103.047 | 103.186 | 277114.0 |
| 2009-01-05 | FGBX | Futures | 86.77 | 87.18 | 86.31 | 86.86 | 1241.0 |
| 2009-01-05 | FTDX | Futures | 460.9 | 480.6 | 460.9 | 477.9 | 626.0 |
| 2009-01-05 | FTI | Futures | 208.18 | 209.74 | 205.22 | 209.14 | 23925.0 |
| 2009-01-05 | FTUK | Futures | 3009.5 | 3009.5 | 2941.3 | 2977.0 | 96971.0 |
| 2009-01-05 | G | Futures | 76.7 | 76.83 | 76.39 | 76.47 | 63860.0 |
| 2009-01-05 | GF | Futures | 265.388 | 270.226 | 263.245 | 268.152 | 131.0 |
| 2009-01-05 | GSCI | Futures | 849.2 | 887.97 | 847.77 | 884.64 | 627.0 |
| 2009-01-05 | HE | Futures | 123.621 | 123.621 | 120.625 | 121.157 | 7689.0 |
| 2009-01-05 | HG | Futures | 2.0676 | 2.1084 | 1.993 | 2.0535 | 10650.0 |
| 2009-01-05 | HO | Futures | 1.7036 | 1.783 | 1.6655 | 1.7757 | 12403.0 |
| 2009-01-05 | HRC | Futures | 3101.0 | 3101.0 | 3101.0 | 3101.0 | 0.0 |
| 2009-01-05 | J1 | Futures | 0.0137378 | 0.0137744 | 0.0135104 | 0.0135711 | 68634.0 |
| 2009-01-05 | J7 | Futures | 0.01355 | 0.013605 | 0.013353 | 0.013408 | 56.0 |
| 2009-01-05 | JB | Futures | 117.0 | 117.17 | 116.91 | 117.0 | 1651.0 |
| 2009-01-05 | KC | Futures | 316.96 | 318.96 | 303.09 | 307.81 | 12052.0 |
| 2009-01-05 | KE | Futures | 3162.79 | 3277.71 | 3092.84 | 3209.01 | 6824.0 |
| 2009-01-05 | L | Futures | 96.738 | 96.748 | 96.689 | 96.723 | 33400.0 |
| 2009-01-05 | LBS | Futures | 1045.0 | 1045.0 | 1013.6 | 1015.8 | 73.0 |
> showing 50 of 85 rows — these rows as CSV