PREVIEW / futures_daily / 2009-11-06
file: by_date/futures_daily/2009/2009-11-06.parquet size: 9 KB rows: 89
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-11-06 | ES | Futures | 1025.54 | 1031.57 | 1016.14 | 1028.43 | 2082058.0 |
| 2009-11-06 | NQ | Futures | 1940.48 | 1961.36 | 1924.67 | 1952.61 | 293095.0 |
| 2009-11-06 | YM | Futures | 9036.0 | 9085.0 | 8964.3 | 9058.7 | 151789.0 |
| 2009-11-06 | CL | Futures | 195.54 | 196.86 | 187.97 | 189.73 | 395797.0 |
| 2009-11-06 | GC | Futures | 1507.7 | 1523.3 | 1502.0 | 1514.7 | 168440.0 |
| 2009-11-06 | ZN | Futures | 94.102432 | 94.600592 | 94.040162 | 94.388874 | 1204699.0 |
| 2009-11-06 | A6 | Futures | 0.73257 | 0.7409 | 0.73233 | 0.73774 | 108632.0 |
| 2009-11-06 | AD | Futures | 0.92478 | 0.92951 | 0.91442 | 0.91551 | 89249.0 |
| 2009-11-06 | B | Futures | 73.55 | 73.9 | 70.58 | 71.18 | 96320.0 |
| 2009-11-06 | B6 | Futures | 1.7247 | 1.7306 | 1.7183 | 1.7269 | 106676.0 |
| 2009-11-06 | BFX | Futures | 2758.1 | 2760.9 | 2748.1 | 2748.2 | 639.0 |
| 2009-11-06 | BR | Futures | 0.22995 | 0.22995 | 0.22995 | 0.22995 | 15.0 |
| 2009-11-06 | BZ | Futures | 76.88 | 76.88 | 75.6 | 75.78 | 2.0 |
| 2009-11-06 | C | Futures | 2189.0 | 2210.0 | 2180.0 | 2182.0 | 5439.0 |
| 2009-11-06 | CB | Futures | 80.686 | 80.686 | 80.686 | 80.686 | 10.0 |
| 2009-11-06 | CC | Futures | 2809.0 | 2833.0 | 2773.0 | 2781.0 | 7844.0 |
| 2009-11-06 | CT | Futures | 58.24 | 58.53 | 57.36 | 57.42 | 14314.0 |
| 2009-11-06 | DC | Futures | 25.22 | 25.31 | 24.97 | 25.09 | 114.0 |
| 2009-11-06 | DX | Futures | 77.465 | 77.705 | 77.174 | 77.531 | 19608.0 |
| 2009-11-06 | E1 | Futures | 1.30016 | 1.30505 | 1.29488 | 1.29792 | 50544.0 |
| 2009-11-06 | E6 | Futures | 1.76255 | 1.76741 | 1.75544 | 1.75816 | 260485.0 |
| 2009-11-06 | E7 | Futures | 1.7455 | 1.7505 | 1.7385 | 1.7413 | 3599.0 |
| 2009-11-06 | ED | Futures | 94.2521 | 94.2569 | 94.2474 | 94.2521 | 102854.0 |
| 2009-11-06 | ER | Futures | 97.169 | 97.184 | 97.159 | 97.179 | 120203.0 |
| 2009-11-06 | EW | Futures | 659.9 | 664.6 | 651.3 | 658.1 | 43534.0 |
| 2009-11-06 | FBTP | Futures | 62.49 | 62.63 | 62.34 | 62.46 | 2856.0 |
| 2009-11-06 | FCE | Futures | 2437.5 | 2454.0 | 2405.7 | 2439.4 | 139665.0 |
| 2009-11-06 | FDAX | Futures | 5962.2 | 6019.9 | 5887.2 | 5972.0 | 177124.0 |
| 2009-11-06 | FESX | Futures | 1660.5 | 1671.3 | 1637.2 | 1661.7 | 1380838.0 |
| 2009-11-06 | FEU3 | Futures | 97.741 | 97.756 | 97.741 | 97.751 | 164.0 |
| 2009-11-06 | FGBL | Futures | 93.34 | 93.52 | 93.03 | 93.21 | 844860.0 |
| 2009-11-06 | FGBM | Futures | 98.98 | 99.11 | 98.86 | 98.99 | 439680.0 |
| 2009-11-06 | FGBS | Futures | 104.731 | 104.827 | 104.721 | 104.794 | 584441.0 |
| 2009-11-06 | FGBX | Futures | 85.91 | 86.39 | 85.64 | 85.93 | 1564.0 |
| 2009-11-06 | FTDX | Futures | 670.5 | 675.4 | 660.7 | 666.5 | 424.0 |
| 2009-11-06 | FTI | Futures | 251.69 | 252.96 | 247.81 | 250.88 | 39029.0 |
| 2009-11-06 | FTUK | Futures | 3388.0 | 3411.2 | 3353.2 | 3398.3 | 100793.0 |
| 2009-11-06 | G | Futures | 75.51 | 75.8 | 75.42 | 75.5 | 78586.0 |
| 2009-11-06 | GF | Futures | 263.158 | 264.396 | 259.581 | 260.407 | 1120.0 |
| 2009-11-06 | GSCI | Futures | 981.89 | 989.96 | 970.67 | 975.0 | 3240.0 |
| 2009-11-06 | HE | Futures | 86.396 | 86.891 | 84.795 | 84.909 | 18788.0 |
| 2009-11-06 | HG | Futures | 4.1353 | 4.1868 | 4.0761 | 4.1144 | 35638.0 |
| 2009-11-06 | HO | Futures | 1.9973 | 2.009 | 1.9144 | 1.9408 | 40318.0 |
| 2009-11-06 | HRC | Futures | 2586.3 | 2586.3 | 2586.3 | 2586.3 | 0.0 |
| 2009-11-06 | J1 | Futures | 0.0138363 | 0.0140158 | 0.0138212 | 0.0139606 | 127960.0 |
| 2009-11-06 | J7 | Futures | 0.013699 | 0.013829 | 0.013671 | 0.013778 | 40.0 |
| 2009-11-06 | JB | Futures | 116.11 | 116.13 | 116.0 | 116.06 | 1692.0 |
| 2009-11-06 | KC | Futures | 375.1 | 377.87 | 364.54 | 366.65 | 15447.0 |
| 2009-11-06 | KE | Futures | 2402.13 | 2417.26 | 2328.85 | 2331.17 | 9002.0 |
| 2009-11-06 | L | Futures | 97.73 | 97.75 | 97.72 | 97.75 | 42779.0 |
> showing 50 of 89 rows — these rows as CSV