PREVIEW / futures_daily / 2008-12-19
file: by_date/futures_daily/2008/2008-12-19.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 |
|---|---|---|---|---|---|---|---|
| 2008-12-19 | ES | Futures | 841.36 | 853.16 | 827.67 | 832.15 | 1844441.0 |
| 2008-12-19 | NQ | Futures | 1365.62 | 1383.79 | 1351.65 | 1353.88 | 231281.0 |
| 2008-12-19 | YM | Futures | 7710.8 | 7803.4 | 7548.7 | 7597.7 | 172162.0 |
| 2008-12-19 | CL | Futures | 167.42 | 171.71 | 162.38 | 168.17 | 194858.0 |
| 2008-12-19 | GC | Futures | 1190.1 | 1191.9 | 1157.3 | 1167.5 | 73520.0 |
| 2008-12-19 | ZN | Futures | 97.893778 | 98.096976 | 96.997315 | 97.140749 | 253925.0 |
| 2008-12-19 | A6 | Futures | 0.54074 | 0.54502 | 0.53233 | 0.53701 | 26528.0 |
| 2008-12-19 | AD | Futures | 0.81342 | 0.81637 | 0.7922 | 0.80311 | 28826.0 |
| 2008-12-19 | B | Futures | 48.28 | 50.2 | 47.84 | 48.92 | 85265.0 |
| 2008-12-19 | B6 | Futures | 1.5604 | 1.5765 | 1.5362 | 1.542 | 57917.0 |
| 2008-12-19 | BFX | Futures | 2051.5 | 2091.2 | 2051.5 | 2088.5 | 344.0 |
| 2008-12-19 | BZ | Futures | 49.96 | 51.11 | 49.17 | 49.93 | 568.0 |
| 2008-12-19 | C | Futures | 1802.0 | 1810.0 | 1744.0 | 1766.0 | 5124.0 |
| 2008-12-19 | CB | Futures | 77.994 | 77.994 | 77.333 | 77.333 | 9.0 |
| 2008-12-19 | CC | Futures | 2372.0 | 2392.0 | 2279.0 | 2290.0 | 4939.0 |
| 2008-12-19 | CT | Futures | 44.04 | 44.29 | 43.03 | 44.03 | 6869.0 |
| 2008-12-19 | DC | Futures | 33.11 | 33.33 | 32.6 | 32.82 | 158.0 |
| 2008-12-19 | DX | Futures | 83.846 | 85.822 | 83.494 | 85.479 | 6138.0 |
| 2008-12-19 | E1 | Futures | 1.23306 | 1.24117 | 1.19638 | 1.20302 | 33261.0 |
| 2008-12-19 | E6 | Futures | 1.68469 | 1.69109 | 1.6326 | 1.64006 | 176640.0 |
| 2008-12-19 | E7 | Futures | 1.666 | 1.671 | 1.613 | 1.6213 | 3339.0 |
| 2008-12-19 | EBM | Futures | 197.11 | 201.33 | 196.73 | 200.56 | 1440.0 |
| 2008-12-19 | ED | Futures | 93.0483 | 93.0954 | 93.0106 | 93.0672 | 127797.0 |
| 2008-12-19 | ER | Futures | 95.723 | 95.738 | 95.684 | 95.733 | 55009.0 |
| 2008-12-19 | EW | Futures | 513.0 | 519.5 | 504.4 | 506.5 | 32951.0 |
| 2008-12-19 | FCE | Futures | 1959.3 | 2006.1 | 1940.5 | 1990.1 | 117795.0 |
| 2008-12-19 | FDAX | Futures | 5163.2 | 5254.3 | 5096.6 | 5178.5 | 152651.0 |
| 2008-12-19 | FESX | Futures | 1400.7 | 1426.0 | 1381.7 | 1408.2 | 1071477.0 |
| 2008-12-19 | FEU3 | Futures | 96.277 | 96.297 | 96.258 | 96.297 | 4239.0 |
| 2008-12-19 | FGBL | Futures | 93.07 | 93.3 | 92.54 | 92.89 | 284789.0 |
| 2008-12-19 | FGBM | Futures | 97.15 | 97.25 | 96.96 | 97.15 | 168992.0 |
| 2008-12-19 | FGBS | Futures | 103.013 | 103.028 | 102.917 | 102.999 | 159924.0 |
| 2008-12-19 | FGBX | Futures | 88.24 | 88.37 | 85.21 | 86.86 | 862.0 |
| 2008-12-19 | FTDX | Futures | 416.1 | 425.1 | 416.1 | 422.4 | 1859.0 |
| 2008-12-19 | FTI | Futures | 196.86 | 203.58 | 196.22 | 203.58 | 30555.0 |
| 2008-12-19 | FTUK | Futures | 2790.5 | 2827.2 | 2737.4 | 2789.5 | 123951.0 |
| 2008-12-19 | G | Futures | 76.51 | 76.55 | 76.1 | 76.36 | 37850.0 |
| 2008-12-19 | GF | Futures | 254.054 | 261.794 | 253.362 | 258.477 | 497.0 |
| 2008-12-19 | GSCI | Futures | 792.11 | 804.72 | 787.35 | 798.06 | 90.0 |
| 2008-12-19 | HE | Futures | 120.915 | 121.012 | 119.223 | 119.272 | 5555.0 |
| 2008-12-19 | HG | Futures | 1.8121 | 1.886 | 1.8121 | 1.867 | 6491.0 |
| 2008-12-19 | HO | Futures | 1.6073 | 1.635 | 1.5815 | 1.6059 | 6148.0 |
| 2008-12-19 | HRC | Futures | 3130.5 | 3130.5 | 3130.5 | 3130.5 | 0.0 |
| 2008-12-19 | J1 | Futures | 0.0141104 | 0.0143087 | 0.0140738 | 0.0141445 | 50004.0 |
| 2008-12-19 | J7 | Futures | 0.013989 | 0.014129 | 0.01392 | 0.013974 | 60.0 |
| 2008-12-19 | JB | Futures | 116.84 | 117.14 | 116.01 | 116.88 | 38.0 |
| 2008-12-19 | KC | Futures | 320.81 | 321.1 | 315.1 | 317.1 | 4120.0 |
| 2008-12-19 | KE | Futures | 2941.69 | 2947.94 | 2895.47 | 2912.96 | 3891.0 |
| 2008-12-19 | L | Futures | 96.635 | 96.669 | 95.478 | 96.536 | 31377.0 |
| 2008-12-19 | LBS | Futures | 1082.6 | 1121.3 | 1082.6 | 1104.5 | 40.0 |
> showing 50 of 86 rows — these rows as CSV