PREVIEW / futures_daily / 2010-12-17
file: by_date/futures_daily/2010/2010-12-17.parquet size: 9 KB rows: 94
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 |
|---|---|---|---|---|---|---|---|
| 2010-12-17 | ES | Futures | 1219.09 | 1221.55 | 1215.15 | 1219.09 | 1340620.0 |
| 2010-12-17 | NQ | Futures | 2522.65 | 2527.75 | 2511.58 | 2512.71 | 158393.0 |
| 2010-12-17 | YM | Futures | 10701.4 | 10713.6 | 10658.4 | 10697.7 | 61409.0 |
| 2010-12-17 | CL | Futures | 181.36 | 182.8 | 179.74 | 181.57 | 225957.0 |
| 2010-12-17 | GC | Futures | 1862.7 | 1875.5 | 1855.9 | 1874.7 | 104813.0 |
| 2010-12-17 | ZN | Futures | 99.477658 | 100.179578 | 99.334674 | 100.036594 | 798541.0 |
| 2010-12-17 | A6 | Futures | 0.83028 | 0.83282 | 0.82553 | 0.82952 | 67927.0 |
| 2010-12-17 | AD | Futures | 0.98461 | 0.98689 | 0.97597 | 0.98024 | 87750.0 |
| 2010-12-17 | B | Futures | 78.03 | 78.45 | 77.19 | 77.84 | 106888.0 |
| 2010-12-17 | B6 | Futures | 1.621 | 1.6223 | 1.6021 | 1.6081 | 95686.0 |
| 2010-12-17 | BFX | Futures | 3031.5 | 3031.5 | 2999.8 | 2999.8 | 128.0 |
| 2010-12-17 | BR | Futures | 0.24765 | 0.24765 | 0.24733 | 0.24733 | 87.0 |
| 2010-12-17 | BZ | Futures | 82.25 | 83.12 | 81.87 | 82.49 | 417.0 |
| 2010-12-17 | C | Futures | 2190.0 | 2198.0 | 2145.0 | 2167.0 | 5780.0 |
| 2010-12-17 | CB | Futures | 100.468 | 101.055 | 100.468 | 100.908 | 5.0 |
| 2010-12-17 | CC | Futures | 2438.0 | 2455.0 | 2380.0 | 2395.0 | 5944.0 |
| 2010-12-17 | CSC | Futures | 3.342 | 3.342 | 3.342 | 3.342 | 4.0 |
| 2010-12-17 | CT | Futures | 125.3 | 128.73 | 122.97 | 128.73 | 10811.0 |
| 2010-12-17 | DC | Futures | 22.62 | 22.72 | 22.6 | 22.62 | 37.0 |
| 2010-12-17 | DX | Futures | 80.225 | 80.864 | 79.751 | 80.607 | 19823.0 |
| 2010-12-17 | E1 | Futures | 1.36015 | 1.37325 | 1.35019 | 1.35543 | 44730.0 |
| 2010-12-17 | E6 | Futures | 1.56611 | 1.58031 | 1.55322 | 1.55842 | 338273.0 |
| 2010-12-17 | E7 | Futures | 1.5546 | 1.5683 | 1.5418 | 1.5468 | 5944.0 |
| 2010-12-17 | EBM | Futures | 212.43 | 214.7 | 210.16 | 213.34 | 3981.0 |
| 2010-12-17 | ED | Futures | 94.7528 | 94.7718 | 94.7433 | 94.7623 | 175896.0 |
| 2010-12-17 | ER | Futures | 97.306 | 97.316 | 97.301 | 97.306 | 47702.0 |
| 2010-12-17 | EW | Futures | 884.9 | 890.3 | 882.1 | 884.8 | 21121.0 |
| 2010-12-17 | FBTP | Futures | 64.24 | 64.3 | 64.08 | 64.16 | 2754.0 |
| 2010-12-17 | FCE | Futures | 2602.7 | 2609.0 | 2579.6 | 2583.7 | 110563.0 |
| 2010-12-17 | FDAX | Futures | 7553.8 | 7561.9 | 7492.8 | 7506.2 | 111393.0 |
| 2010-12-17 | FESX | Futures | 1768.1 | 1775.6 | 1749.5 | 1751.4 | 1014671.0 |
| 2010-12-17 | FEU3 | Futures | 97.864 | 97.864 | 97.864 | 97.864 | 5.0 |
| 2010-12-17 | FGBL | Futures | 98.58 | 98.99 | 98.36 | 98.51 | 463002.0 |
| 2010-12-17 | FGBM | Futures | 104.18 | 104.33 | 104.01 | 104.16 | 271022.0 |
| 2010-12-17 | FGBS | Futures | 107.168 | 107.223 | 107.119 | 107.153 | 209298.0 |
| 2010-12-17 | FGBX | Futures | 97.27 | 97.5 | 96.67 | 96.78 | 3307.0 |
| 2010-12-17 | FTDX | Futures | 732.4 | 733.2 | 729.3 | 729.7 | 1714.0 |
| 2010-12-17 | FTI | Futures | 282.04 | 283.0 | 281.28 | 281.88 | 29595.0 |
| 2010-12-17 | FTUK | Futures | 4063.1 | 4076.9 | 4044.3 | 4048.8 | 96678.0 |
| 2010-12-17 | FXXP | Futures | 179.3 | 179.9 | 178.5 | 179.3 | 1539.0 |
| 2010-12-17 | G | Futures | 80.85 | 81.41 | 80.84 | 81.03 | 97520.0 |
| 2010-12-17 | GF | Futures | 295.628 | 296.811 | 295.129 | 296.5 | 1727.0 |
| 2010-12-17 | GSCI | Futures | 984.52 | 993.28 | 982.58 | 989.63 | 163.0 |
| 2010-12-17 | HE | Futures | 93.84 | 95.815 | 93.557 | 95.25 | 13407.0 |
| 2010-12-17 | HG | Futures | 5.4782 | 5.5868 | 5.4768 | 5.5428 | 22794.0 |
| 2010-12-17 | HO | Futures | 2.0832 | 2.101 | 2.0686 | 2.0804 | 11482.0 |
| 2010-12-17 | HRC | Futures | 2540.0 | 2540.0 | 2540.0 | 2540.0 | 0.0 |
| 2010-12-17 | J1 | Futures | 0.0149577 | 0.0150205 | 0.0149276 | 0.0149841 | 92070.0 |
| 2010-12-17 | J7 | Futures | 0.014856 | 0.014911 | 0.014821 | 0.014878 | 131.0 |
| 2010-12-17 | JB | Futures | 120.27 | 120.86 | 120.07 | 120.78 | 2269.0 |
> showing 50 of 94 rows — these rows as CSV