PREVIEW / futures_daily / 2009-08-17
file: by_date/futures_daily/2009/2009-08-17.parquet size: 8 KB rows: 86
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-17 | ES | Futures | 963.52 | 963.52 | 935.93 | 938.57 | 2201445.0 |
| 2009-08-17 | NQ | Futures | 1815.66 | 1815.94 | 1758.22 | 1763.85 | 366441.0 |
| 2009-08-17 | YM | Futures | 8395.4 | 8396.3 | 8202.4 | 8228.5 | 146224.0 |
| 2009-08-17 | CL | Futures | 173.9 | 174.1 | 168.22 | 171.68 | 143205.0 |
| 2009-08-17 | GC | Futures | 1312.2 | 1313.9 | 1287.5 | 1293.7 | 93505.0 |
| 2009-08-17 | ZN | Futures | 92.381786 | 92.972793 | 92.35716 | 92.788103 | 589467.0 |
| 2009-08-17 | A6 | Futures | 0.66564 | 0.66677 | 0.65383 | 0.65938 | 89565.0 |
| 2009-08-17 | AD | Futures | 0.89832 | 0.89882 | 0.88766 | 0.89358 | 61117.0 |
| 2009-08-17 | B | Futures | 67.58 | 67.66 | 65.55 | 66.81 | 106202.0 |
| 2009-08-17 | B6 | Futures | 1.7191 | 1.7208 | 1.6949 | 1.7017 | 87969.0 |
| 2009-08-17 | BFX | Futures | 2539.7 | 2539.7 | 2539.7 | 2539.7 | 40.0 |
| 2009-08-17 | BR | Futures | 0.20649 | 0.20681 | 0.20649 | 0.20681 | 11.0 |
| 2009-08-17 | BZ | Futures | 69.2 | 69.69 | 68.42 | 69.69 | 11.0 |
| 2009-08-17 | C | Futures | 1880.0 | 1889.0 | 1834.0 | 1836.0 | 1929.0 |
| 2009-08-17 | CB | Futures | 69.916 | 69.916 | 69.347 | 69.347 | 3.0 |
| 2009-08-17 | CC | Futures | 2479.0 | 2481.0 | 2382.0 | 2389.0 | 10468.0 |
| 2009-08-17 | CT | Futures | 52.28 | 52.28 | 50.24 | 50.67 | 361.0 |
| 2009-08-17 | DC | Futures | 22.45 | 22.59 | 21.91 | 22.07 | 135.0 |
| 2009-08-17 | DX | Futures | 80.849 | 81.571 | 80.716 | 81.269 | 8219.0 |
| 2009-08-17 | E1 | Futures | 1.23218 | 1.23417 | 1.22199 | 1.22821 | 32992.0 |
| 2009-08-17 | E6 | Futures | 1.68473 | 1.68509 | 1.66728 | 1.67167 | 186801.0 |
| 2009-08-17 | E7 | Futures | 1.6672 | 1.6677 | 1.6502 | 1.6545 | 1572.0 |
| 2009-08-17 | ED | Futures | 94.0085 | 94.0133 | 93.9896 | 93.9967 | 134444.0 |
| 2009-08-17 | ER | Futures | 97.135 | 97.149 | 97.12 | 97.135 | 74070.0 |
| 2009-08-17 | EW | Futures | 626.6 | 626.6 | 604.5 | 607.1 | 42599.0 |
| 2009-08-17 | FCE | Futures | 2282.1 | 2282.1 | 2218.9 | 2233.7 | 51355.0 |
| 2009-08-17 | FDAX | Futures | 5824.9 | 5824.9 | 5680.1 | 5717.9 | 155964.0 |
| 2009-08-17 | FESX | Futures | 1588.9 | 1589.5 | 1541.2 | 1552.5 | 1417865.0 |
| 2009-08-17 | FEU3 | Futures | 97.712 | 97.717 | 97.702 | 97.712 | 905.0 |
| 2009-08-17 | FGBL | Futures | 92.84 | 92.99 | 92.67 | 92.91 | 542933.0 |
| 2009-08-17 | FGBM | Futures | 98.41 | 98.45 | 98.14 | 98.3 | 290632.0 |
| 2009-08-17 | FGBS | Futures | 104.215 | 104.22 | 104.056 | 104.123 | 313900.0 |
| 2009-08-17 | FGBX | Futures | 86.32 | 86.5 | 86.06 | 86.44 | 663.0 |
| 2009-08-17 | FTDX | Futures | 616.6 | 619.7 | 605.4 | 608.5 | 1465.0 |
| 2009-08-17 | FTI | Futures | 237.33 | 237.33 | 231.96 | 232.83 | 3303.0 |
| 2009-08-17 | FTUK | Futures | 3105.6 | 3109.6 | 3049.2 | 3076.8 | 117881.0 |
| 2009-08-17 | G | Futures | 76.33 | 76.66 | 76.25 | 76.65 | 60771.0 |
| 2009-08-17 | GF | Futures | 276.449 | 278.245 | 276.241 | 277.554 | 757.0 |
| 2009-08-17 | GSCI | Futures | 915.15 | 921.67 | 907.4 | 917.18 | 559.0 |
| 2009-08-17 | HE | Futures | 66.554 | 67.679 | 65.43 | 67.004 | 8598.0 |
| 2009-08-17 | HG | Futures | 3.9877 | 3.9877 | 3.8283 | 3.8901 | 23218.0 |
| 2009-08-17 | HO | Futures | 1.8694 | 1.8748 | 1.8055 | 1.8485 | 29683.0 |
| 2009-08-17 | HRC | Futures | 2586.5 | 2586.5 | 2586.5 | 2586.5 | 0.0 |
| 2009-08-17 | J1 | Futures | 0.0132904 | 0.0133672 | 0.0132702 | 0.0133281 | 79183.0 |
| 2009-08-17 | J7 | Futures | 0.013142 | 0.013184 | 0.013112 | 0.013145 | 63.0 |
| 2009-08-17 | JB | Futures | 116.24 | 116.93 | 116.2 | 116.89 | 2397.0 |
| 2009-08-17 | KC | Futures | 347.18 | 347.18 | 337.14 | 340.4 | 7374.0 |
| 2009-08-17 | KE | Futures | 2436.55 | 2436.55 | 2371.8 | 2399.38 | 5003.0 |
| 2009-08-17 | L | Futures | 97.583 | 97.602 | 97.543 | 97.543 | 35879.0 |
| 2009-08-17 | LBS | Futures | 772.5 | 779.4 | 738.4 | 741.7 | 625.0 |
> showing 50 of 86 rows — these rows as CSV