PREVIEW / futures_daily / 2010-11-22
file: by_date/futures_daily/2010/2010-11-22.parquet size: 9 KB rows: 91
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-11-22 | ES | Futures | 1178.89 | 1182.07 | 1159.04 | 1174.23 | 2212329.0 |
| 2010-11-22 | NQ | Futures | 2425.4 | 2444.11 | 2404.7 | 2442.97 | 284564.0 |
| 2010-11-22 | YM | Futures | 10448.5 | 10462.5 | 10264.3 | 10388.9 | 115366.0 |
| 2010-11-22 | CL | Futures | 168.69 | 170.17 | 165.67 | 167.85 | 290222.0 |
| 2010-11-22 | GC | Futures | 1844.5 | 1858.6 | 1832.1 | 1845.6 | 182134.0 |
| 2010-11-22 | ZN | Futures | 102.703043 | 103.425668 | 102.574003 | 103.309532 | 1009444.0 |
| 2010-11-22 | A6 | Futures | 0.82762 | 0.83333 | 0.82225 | 0.82594 | 97045.0 |
| 2010-11-22 | AD | Futures | 0.97449 | 0.97836 | 0.96924 | 0.97221 | 82395.0 |
| 2010-11-22 | B | Futures | 71.75 | 72.69 | 70.7 | 71.43 | 141260.0 |
| 2010-11-22 | B6 | Futures | 1.6605 | 1.6695 | 1.6501 | 1.6552 | 92170.0 |
| 2010-11-22 | BFX | Futures | 3103.9 | 3103.9 | 3039.6 | 3049.5 | 652.0 |
| 2010-11-22 | BR | Futures | 0.24747 | 0.24768 | 0.24747 | 0.24768 | 285.0 |
| 2010-11-22 | BZ | Futures | 76.33 | 76.35 | 74.8 | 75.55 | 402.0 |
| 2010-11-22 | C | Futures | 2057.0 | 2079.0 | 2049.0 | 2050.0 | 3550.0 |
| 2010-11-22 | CB | Futures | 93.868 | 93.868 | 93.868 | 93.868 | 10.0 |
| 2010-11-22 | CC | Futures | 2339.0 | 2349.0 | 2297.0 | 2304.0 | 4804.0 |
| 2010-11-22 | CT | Futures | 107.92 | 108.26 | 103.18 | 103.18 | 2801.0 |
| 2010-11-22 | DC | Futures | 22.96 | 23.28 | 22.86 | 23.01 | 350.0 |
| 2010-11-22 | DX | Futures | 78.6 | 79.227 | 78.309 | 79.019 | 20197.0 |
| 2010-11-22 | E1 | Futures | 1.32409 | 1.32947 | 1.3208 | 1.3254 | 39200.0 |
| 2010-11-22 | E6 | Futures | 1.62467 | 1.63058 | 1.60586 | 1.61024 | 336710.0 |
| 2010-11-22 | E7 | Futures | 1.612 | 1.6181 | 1.5936 | 1.598 | 4905.0 |
| 2010-11-22 | ED | Futures | 94.753 | 94.7577 | 94.7458 | 94.753 | 153953.0 |
| 2010-11-22 | ER | Futures | 97.237 | 97.276 | 97.232 | 97.247 | 81307.0 |
| 2010-11-22 | EW | Futures | 836.9 | 841.5 | 829.2 | 841.4 | 24465.0 |
| 2010-11-22 | FBTP | Futures | 65.81 | 65.99 | 65.69 | 65.92 | 6817.0 |
| 2010-11-22 | FCE | Futures | 2604.1 | 2616.1 | 2536.8 | 2557.5 | 121885.0 |
| 2010-11-22 | FDAX | Futures | 7408.1 | 7429.6 | 7310.7 | 7345.2 | 159143.0 |
| 2010-11-22 | FESX | Futures | 1793.7 | 1806.8 | 1740.6 | 1756.3 | 1381368.0 |
| 2010-11-22 | FEU3 | Futures | 97.8 | 97.81 | 97.8 | 97.81 | 30.0 |
| 2010-11-22 | FGBL | Futures | 100.63 | 101.36 | 100.53 | 101.17 | 792659.0 |
| 2010-11-22 | FGBM | Futures | 104.99 | 105.48 | 104.97 | 105.42 | 524582.0 |
| 2010-11-22 | FGBS | Futures | 107.115 | 107.302 | 107.11 | 107.277 | 470362.0 |
| 2010-11-22 | FGBX | Futures | 101.7 | 102.77 | 101.48 | 102.44 | 2902.0 |
| 2010-11-22 | FTDX | Futures | 690.6 | 706.4 | 690.6 | 694.5 | 502.0 |
| 2010-11-22 | FTI | Futures | 279.59 | 280.31 | 273.88 | 275.81 | 34410.0 |
| 2010-11-22 | FTUK | Futures | 3986.4 | 4003.7 | 3900.7 | 3929.0 | 119841.0 |
| 2010-11-22 | G | Futures | 82.02 | 82.37 | 81.88 | 82.33 | 91405.0 |
| 2010-11-22 | GF | Futures | 292.389 | 293.822 | 291.081 | 292.452 | 1836.0 |
| 2010-11-22 | GSCI | Futures | 921.9 | 921.9 | 911.08 | 919.95 | 242.0 |
| 2010-11-22 | HE | Futures | 96.379 | 97.414 | 96.097 | 96.473 | 9710.0 |
| 2010-11-22 | HG | Futures | 5.1277 | 5.169 | 4.9811 | 5.0137 | 16231.0 |
| 2010-11-22 | HO | Futures | 1.9319 | 1.9492 | 1.9035 | 1.9212 | 5439.0 |
| 2010-11-22 | HRC | Futures | 2391.9 | 2391.9 | 2391.9 | 2391.9 | 0.0 |
| 2010-11-22 | J1 | Futures | 0.0150544 | 0.0150946 | 0.0150318 | 0.0150858 | 80561.0 |
| 2010-11-22 | J7 | Futures | 0.01494 | 0.01499 | 0.01493 | 0.014982 | 76.0 |
| 2010-11-22 | JB | Futures | 120.63 | 120.7 | 120.17 | 120.25 | 3502.0 |
| 2010-11-22 | KC | Futures | 518.17 | 522.95 | 505.17 | 507.99 | 6467.0 |
| 2010-11-22 | KE | Futures | 2960.08 | 3001.8 | 2944.43 | 2972.6 | 12922.0 |
| 2010-11-22 | L | Futures | 98.155 | 98.185 | 98.155 | 98.165 | 14809.0 |
> showing 50 of 91 rows — these rows as CSV