PREVIEW / futures_daily / 2009-11-13
file: by_date/futures_daily/2009/2009-11-13.parquet size: 9 KB rows: 88
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-13 | ES | Futures | 1048.93 | 1057.13 | 1044.35 | 1052.79 | 1478254.0 |
| 2009-11-13 | NQ | Futures | 2001.15 | 2023.45 | 1998.33 | 2018.65 | 253483.0 |
| 2009-11-13 | YM | Futures | 9247.5 | 9324.7 | 9222.1 | 9298.4 | 116549.0 |
| 2009-11-13 | CL | Futures | 188.53 | 190.72 | 185.61 | 187.46 | 140732.0 |
| 2009-11-13 | GC | Futures | 1525.2 | 1547.9 | 1522.3 | 1543.8 | 149129.0 |
| 2009-11-13 | ZN | Futures | 94.762494 | 94.899488 | 94.650408 | 94.81231 | 629928.0 |
| 2009-11-13 | A6 | Futures | 0.74429 | 0.7531 | 0.74429 | 0.75108 | 86337.0 |
| 2009-11-13 | AD | Futures | 0.93395 | 0.94154 | 0.93306 | 0.9375 | 63889.0 |
| 2009-11-13 | B | Futures | 71.02 | 72.12 | 70.18 | 70.89 | 139155.0 |
| 2009-11-13 | B6 | Futures | 1.7244 | 1.738 | 1.7242 | 1.7346 | 111219.0 |
| 2009-11-13 | BR | Futures | 0.23056 | 0.23056 | 0.22897 | 0.23056 | 4.0 |
| 2009-11-13 | BZ | Futures | 75.12 | 75.47 | 74.89 | 75.47 | 3.0 |
| 2009-11-13 | C | Futures | 2120.0 | 2121.0 | 2091.0 | 2098.0 | 7441.0 |
| 2009-11-13 | CB | Futures | 80.686 | 80.686 | 80.686 | 80.686 | 2.0 |
| 2009-11-13 | CC | Futures | 2698.0 | 2709.0 | 2666.0 | 2693.0 | 8841.0 |
| 2009-11-13 | CT | Futures | 57.25 | 58.16 | 57.23 | 57.91 | 14854.0 |
| 2009-11-13 | DC | Futures | 24.44 | 25.1 | 24.3 | 24.61 | 300.0 |
| 2009-11-13 | DX | Futures | 77.281 | 77.348 | 76.801 | 77.006 | 17570.0 |
| 2009-11-13 | E1 | Futures | 1.29871 | 1.30822 | 1.29699 | 1.3032 | 53916.0 |
| 2009-11-13 | E6 | Futures | 1.75947 | 1.77025 | 1.75674 | 1.76504 | 246095.0 |
| 2009-11-13 | E7 | Futures | 1.7426 | 1.7534 | 1.7399 | 1.7481 | 2495.0 |
| 2009-11-13 | ED | Futures | 94.2663 | 94.271 | 94.2616 | 94.2663 | 74983.0 |
| 2009-11-13 | ER | Futures | 97.184 | 97.193 | 97.179 | 97.179 | 60696.0 |
| 2009-11-13 | EW | Futures | 671.1 | 678.6 | 666.8 | 676.0 | 33429.0 |
| 2009-11-13 | FBTP | Futures | 62.96 | 63.0 | 62.63 | 62.68 | 4568.0 |
| 2009-11-13 | FCE | Futures | 2510.8 | 2528.7 | 2493.5 | 2521.8 | 27236.0 |
| 2009-11-13 | FDAX | Futures | 6170.6 | 6206.5 | 6110.7 | 6190.7 | 129319.0 |
| 2009-11-13 | FESX | Futures | 1712.5 | 1726.8 | 1699.9 | 1719.6 | 894797.0 |
| 2009-11-13 | FEU3 | Futures | 97.766 | 97.766 | 97.751 | 97.751 | 108.0 |
| 2009-11-13 | FGBL | Futures | 93.66 | 93.85 | 93.37 | 93.49 | 792876.0 |
| 2009-11-13 | FGBM | Futures | 99.38 | 99.46 | 99.25 | 99.33 | 402437.0 |
| 2009-11-13 | FGBS | Futures | 104.948 | 104.977 | 104.915 | 104.948 | 421019.0 |
| 2009-11-13 | FGBX | Futures | 86.62 | 86.87 | 86.16 | 86.34 | 1320.0 |
| 2009-11-13 | FTDX | Futures | 676.7 | 679.9 | 674.1 | 678.1 | 207.0 |
| 2009-11-13 | FTI | Futures | 257.91 | 259.42 | 256.65 | 258.69 | 1515.0 |
| 2009-11-13 | FTUK | Futures | 3494.5 | 3511.1 | 3473.2 | 3500.8 | 70239.0 |
| 2009-11-13 | G | Futures | 76.22 | 76.48 | 76.02 | 76.07 | 81940.0 |
| 2009-11-13 | GF | Futures | 250.898 | 251.983 | 250.084 | 251.101 | 1182.0 |
| 2009-11-13 | GSCI | Futures | 968.63 | 973.46 | 962.73 | 968.34 | 2125.0 |
| 2009-11-13 | HE | Futures | 83.156 | 84.3 | 82.89 | 83.842 | 12798.0 |
| 2009-11-13 | HG | Futures | 4.0949 | 4.145 | 4.0844 | 4.1422 | 25151.0 |
| 2009-11-13 | HO | Futures | 1.9268 | 1.9441 | 1.8894 | 1.9046 | 41893.0 |
| 2009-11-13 | HRC | Futures | 2637.0 | 2637.0 | 2637.0 | 2637.0 | 0.0 |
| 2009-11-13 | J1 | Futures | 0.0138966 | 0.0140372 | 0.013889 | 0.0140033 | 97732.0 |
| 2009-11-13 | J7 | Futures | 0.013719 | 0.013852 | 0.013707 | 0.013821 | 38.0 |
| 2009-11-13 | JB | Futures | 116.97 | 117.29 | 116.85 | 117.14 | 3889.0 |
| 2009-11-13 | KC | Futures | 343.42 | 350.02 | 343.16 | 346.06 | 13820.0 |
| 2009-11-13 | KE | Futures | 2484.72 | 2533.58 | 2477.74 | 2514.97 | 5757.0 |
| 2009-11-13 | L | Futures | 97.74 | 97.74 | 97.73 | 97.74 | 7244.0 |
| 2009-11-13 | LBS | Futures | 769.8 | 788.9 | 767.8 | 787.3 | 276.0 |
> showing 50 of 88 rows — these rows as CSV