PREVIEW / futures_daily / 2009-08-31
file: by_date/futures_daily/2009/2009-08-31.parquet size: 8 KB rows: 80
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-08-31 | ES | Futures | 984.87 | 989.18 | 972.15 | 978.39 | 1647166.0 |
| 2009-08-31 | NQ | Futures | 1848.31 | 1852.54 | 1819.6 | 1830.01 | 239131.0 |
| 2009-08-31 | YM | Futures | 8592.1 | 8623.7 | 8504.6 | 8558.7 | 124591.0 |
| 2009-08-31 | CL | Futures | 181.51 | 183.04 | 172.48 | 174.55 | 276967.0 |
| 2009-08-31 | GC | Futures | 1323.5 | 1330.0 | 1305.4 | 1318.2 | 73127.0 |
| 2009-08-31 | ZN | Futures | 93.132857 | 93.489924 | 92.972793 | 93.416048 | 159723.0 |
| 2009-08-31 | A6 | Futures | 0.67585 | 0.67931 | 0.66942 | 0.67698 | 77150.0 |
| 2009-08-31 | AD | Futures | 0.90386 | 0.90583 | 0.89023 | 0.90228 | 72556.0 |
| 2009-08-31 | B | Futures | 69.35 | 69.48 | 65.71 | 66.44 | 37026.0 |
| 2009-08-31 | B6 | Futures | 1.6945 | 1.7008 | 1.6854 | 1.6942 | 68543.0 |
| 2009-08-31 | BFX | Futures | 2700.2 | 2702.6 | 2689.8 | 2690.6 | 91.0 |
| 2009-08-31 | BR | Futures | 0.20667 | 0.20771 | 0.20633 | 0.20759 | 52.0 |
| 2009-08-31 | BZ | Futures | 69.12 | 69.16 | 68.9 | 69.16 | 6.0 |
| 2009-08-31 | CB | Futures | 67.776 | 67.776 | 67.776 | 67.776 | 20.0 |
| 2009-08-31 | CC | Futures | 2455.0 | 2495.0 | 2427.0 | 2452.0 | 3971.0 |
| 2009-08-31 | CT | Futures | 49.42 | 51.09 | 49.09 | 51.09 | 90.0 |
| 2009-08-31 | DC | Futures | 22.44 | 22.44 | 22.24 | 22.36 | 245.0 |
| 2009-08-31 | DX | Futures | 80.199 | 80.486 | 79.862 | 80.061 | 5286.0 |
| 2009-08-31 | E1 | Futures | 1.24913 | 1.25416 | 1.24476 | 1.24953 | 23519.0 |
| 2009-08-31 | E6 | Futures | 1.69815 | 1.70563 | 1.69233 | 1.70111 | 162745.0 |
| 2009-08-31 | E7 | Futures | 1.6807 | 1.6881 | 1.6752 | 1.6837 | 1450.0 |
| 2009-08-31 | ED | Futures | 94.1171 | 94.1195 | 94.103 | 94.11 | 78963.0 |
| 2009-08-31 | ER | Futures | 97.174 | 97.184 | 97.164 | 97.174 | 21303.0 |
| 2009-08-31 | EW | Futures | 639.5 | 641.8 | 628.6 | 632.4 | 33478.0 |
| 2009-08-31 | FCE | Futures | 2402.9 | 2412.4 | 2388.5 | 2393.7 | 100349.0 |
| 2009-08-31 | FDAX | Futures | 6012.5 | 6031.1 | 5965.9 | 6000.4 | 97996.0 |
| 2009-08-31 | FESX | Futures | 1662.3 | 1668.3 | 1651.0 | 1655.8 | 744284.0 |
| 2009-08-31 | FEU3 | Futures | 97.746 | 97.751 | 97.746 | 97.751 | 86.0 |
| 2009-08-31 | FGBL | Futures | 93.43 | 93.51 | 93.01 | 93.21 | 310909.0 |
| 2009-08-31 | FGBM | Futures | 98.68 | 98.73 | 98.46 | 98.57 | 198336.0 |
| 2009-08-31 | FGBS | Futures | 104.316 | 104.345 | 104.268 | 104.297 | 220780.0 |
| 2009-08-31 | FGBX | Futures | 86.69 | 86.97 | 86.5 | 86.69 | 2791.0 |
| 2009-08-31 | FTDX | Futures | 624.6 | 628.2 | 620.1 | 622.4 | 475.0 |
| 2009-08-31 | FTI | Futures | 246.28 | 246.37 | 244.14 | 244.92 | 21239.0 |
| 2009-08-31 | GF | Futures | 270.781 | 270.781 | 268.777 | 268.846 | 734.0 |
| 2009-08-31 | GSCI | Futures | 931.45 | 931.45 | 911.88 | 921.06 | 680.0 |
| 2009-08-31 | HE | Futures | 70.902 | 72.85 | 70.902 | 72.176 | 8197.0 |
| 2009-08-31 | HG | Futures | 4.1374 | 4.1652 | 3.8991 | 3.9388 | 21650.0 |
| 2009-08-31 | HO | Futures | 1.8595 | 1.8595 | 1.7881 | 1.8126 | 11603.0 |
| 2009-08-31 | HRC | Futures | 2662.6 | 2662.6 | 2662.6 | 2662.6 | 0.0 |
| 2009-08-31 | J1 | Futures | 0.0134641 | 0.0136064 | 0.0134578 | 0.0135409 | 96487.0 |
| 2009-08-31 | J7 | Futures | 0.01331 | 0.013409 | 0.01331 | 0.013354 | 46.0 |
| 2009-08-31 | JB | Futures | 117.1 | 117.32 | 117.0 | 117.19 | 2091.0 |
| 2009-08-31 | KC | Futures | 322.44 | 323.89 | 317.56 | 322.84 | 6080.0 |
| 2009-08-31 | KE | Futures | 2404.46 | 2438.19 | 2340.48 | 2423.07 | 9920.0 |
| 2009-08-31 | LBS | Futures | 709.6 | 720.5 | 702.7 | 717.7 | 689.0 |
| 2009-08-31 | LE | Futures | 144.016 | 144.64 | 143.059 | 144.307 | 25849.0 |
| 2009-08-31 | MP | Futures | 0.03944 | 0.03945 | 0.03909 | 0.03913 | 22472.0 |
| 2009-08-31 | N6 | Futures | 0.54753 | 0.54921 | 0.54337 | 0.54777 | 4740.0 |
| 2009-08-31 | NG | Futures | 146.259 | 150.204 | 141.924 | 144.993 | 73544.0 |
> showing 50 of 80 rows — these rows as CSV