PREVIEW / futures_daily / 2009-02-05
file: by_date/futures_daily/2009/2009-02-05.parquet size: 9 KB rows: 87
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-02-05 | ES | Futures | 784.23 | 801.7 | 771.25 | 793.67 | 2616179.0 |
| 2009-02-05 | NQ | Futures | 1358.07 | 1396.65 | 1324.81 | 1380.15 | 428893.0 |
| 2009-02-05 | YM | Futures | 7051.0 | 7184.6 | 6944.2 | 7117.8 | 247523.0 |
| 2009-02-05 | CL | Futures | 133.88 | 137.03 | 131.09 | 136.77 | 229734.0 |
| 2009-02-05 | GC | Futures | 1257.8 | 1285.4 | 1253.7 | 1268.7 | 100190.0 |
| 2009-02-05 | ZN | Futures | 93.303886 | 93.901528 | 93.232169 | 93.61466 | 490157.0 |
| 2009-02-05 | A6 | Futures | 0.50703 | 0.52051 | 0.50647 | 0.51758 | 32358.0 |
| 2009-02-05 | AD | Futures | 0.79692 | 0.8033 | 0.79289 | 0.79957 | 26972.0 |
| 2009-02-05 | B | Futures | 46.22 | 48.41 | 46.07 | 48.28 | 74673.0 |
| 2009-02-05 | B6 | Futures | 1.4999 | 1.5274 | 1.492 | 1.5199 | 87646.0 |
| 2009-02-05 | BFX | Futures | 2067.1 | 2098.7 | 2061.9 | 2089.1 | 166.0 |
| 2009-02-05 | BR | Futures | 0.15853 | 0.15853 | 0.15853 | 0.15853 | 1.0 |
| 2009-02-05 | BZ | Futures | 48.21 | 49.62 | 48.21 | 49.62 | 7.0 |
| 2009-02-05 | C | Futures | 1938.0 | 1960.0 | 1933.0 | 1957.0 | 5638.0 |
| 2009-02-05 | CB | Futures | 75.35 | 75.35 | 74.689 | 74.855 | 13.0 |
| 2009-02-05 | CC | Futures | 2374.0 | 2458.0 | 2373.0 | 2437.0 | 7038.0 |
| 2009-02-05 | CT | Futures | 48.57 | 48.75 | 48.13 | 48.39 | 7134.0 |
| 2009-02-05 | DC | Futures | 26.57 | 27.18 | 26.43 | 26.67 | 154.0 |
| 2009-02-05 | DX | Futures | 89.477 | 89.627 | 88.912 | 89.549 | 3187.0 |
| 2009-02-05 | E1 | Futures | 1.1472 | 1.14959 | 1.13311 | 1.1359 | 32080.0 |
| 2009-02-05 | E6 | Futures | 1.51895 | 1.527 | 1.50983 | 1.51386 | 198800.0 |
| 2009-02-05 | E7 | Futures | 1.5011 | 1.5096 | 1.4927 | 1.4965 | 2427.0 |
| 2009-02-05 | EBM | Futures | 222.42 | 230.09 | 221.27 | 228.17 | 4460.0 |
| 2009-02-05 | ED | Futures | 93.0106 | 93.0577 | 93.0012 | 93.0436 | 175964.0 |
| 2009-02-05 | ER | Futures | 96.307 | 96.361 | 96.272 | 96.351 | 218865.0 |
| 2009-02-05 | EW | Futures | 492.7 | 502.7 | 482.3 | 496.2 | 28272.0 |
| 2009-02-05 | FCE | Futures | 1864.1 | 1923.2 | 1838.5 | 1894.4 | 146469.0 |
| 2009-02-05 | FDAX | Futures | 4831.3 | 4991.8 | 4794.7 | 4918.6 | 184736.0 |
| 2009-02-05 | FESX | Futures | 1299.0 | 1338.1 | 1280.1 | 1315.7 | 1432481.0 |
| 2009-02-05 | FEU3 | Futures | 96.869 | 96.919 | 96.859 | 96.919 | 2054.0 |
| 2009-02-05 | FGBL | Futures | 90.98 | 91.59 | 90.81 | 91.32 | 753003.0 |
| 2009-02-05 | FGBM | Futures | 97.09 | 97.56 | 96.86 | 97.38 | 488608.0 |
| 2009-02-05 | FGBS | Futures | 103.508 | 103.714 | 103.445 | 103.637 | 557090.0 |
| 2009-02-05 | FGBX | Futures | 82.62 | 83.24 | 82.32 | 82.96 | 2453.0 |
| 2009-02-05 | FTDX | Futures | 430.5 | 439.4 | 426.0 | 436.7 | 555.0 |
| 2009-02-05 | FTI | Futures | 202.5 | 205.68 | 198.3 | 203.34 | 36393.0 |
| 2009-02-05 | FTUK | Futures | 2701.3 | 2795.4 | 2690.2 | 2745.3 | 133872.0 |
| 2009-02-05 | G | Futures | 73.0 | 73.62 | 72.93 | 73.4 | 60248.0 |
| 2009-02-05 | GF | Futures | 261.678 | 264.975 | 260.205 | 264.063 | 702.0 |
| 2009-02-05 | GSCI | Futures | 770.44 | 788.03 | 763.4 | 788.03 | 173.0 |
| 2009-02-05 | HE | Futures | 117.435 | 117.677 | 115.599 | 116.469 | 9516.0 |
| 2009-02-05 | HG | Futures | 2.126 | 2.1816 | 2.0845 | 2.1112 | 16439.0 |
| 2009-02-05 | HO | Futures | 1.4715 | 1.5343 | 1.4708 | 1.5227 | 28296.0 |
| 2009-02-05 | HRC | Futures | 3041.9 | 3041.9 | 3041.9 | 3041.9 | 0.0 |
| 2009-02-05 | J1 | Futures | 0.0141534 | 0.0141723 | 0.0136999 | 0.0138212 | 118841.0 |
| 2009-02-05 | J7 | Futures | 0.013963 | 0.013998 | 0.013535 | 0.013655 | 159.0 |
| 2009-02-05 | JB | Futures | 115.88 | 115.97 | 115.78 | 115.78 | 870.0 |
| 2009-02-05 | KC | Futures | 331.1 | 342.53 | 326.1 | 340.68 | 13370.0 |
| 2009-02-05 | KE | Futures | 2864.25 | 2980.42 | 2856.75 | 2947.94 | 7385.0 |
| 2009-02-05 | L | Futures | 96.768 | 96.787 | 96.664 | 96.694 | 116079.0 |
> showing 50 of 87 rows — these rows as CSV