PREVIEW / futures_daily / 2010-12-29
file: by_date/futures_daily/2010/2010-12-29.parquet size: 9 KB rows: 93
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-29 | ES | Futures | 1234.34 | 1238.77 | 1233.6 | 1236.07 | 588441.0 |
| 2010-12-29 | NQ | Futures | 2528.61 | 2538.26 | 2525.2 | 2530.03 | 64609.0 |
| 2010-12-29 | YM | Futures | 10768.8 | 10823.1 | 10764.1 | 10793.1 | 30402.0 |
| 2010-12-29 | CL | Futures | 187.04 | 187.57 | 186.08 | 186.73 | 117853.0 |
| 2010-12-29 | GC | Futures | 1912.3 | 1923.2 | 1905.0 | 1921.3 | 75104.0 |
| 2010-12-29 | ZN | Futures | 98.996713 | 100.127584 | 98.957717 | 100.036594 | 575393.0 |
| 2010-12-29 | A6 | Futures | 0.84758 | 0.85546 | 0.84732 | 0.85479 | 40132.0 |
| 2010-12-29 | AD | Futures | 0.98868 | 0.99344 | 0.9855 | 0.99056 | 41762.0 |
| 2010-12-29 | B | Futures | 80.09 | 80.24 | 79.58 | 80.03 | 41881.0 |
| 2010-12-29 | B6 | Futures | 1.5938 | 1.6089 | 1.5915 | 1.608 | 58950.0 |
| 2010-12-29 | BFX | Futures | 2987.7 | 3035.8 | 2987.7 | 3035.8 | 63.0 |
| 2010-12-29 | BR | Futures | 0.25231 | 0.25328 | 0.25231 | 0.25328 | 105.0 |
| 2010-12-29 | BZ | Futures | 85.25 | 85.25 | 85.25 | 85.25 | 122.0 |
| 2010-12-29 | C | Futures | 2238.0 | 2247.0 | 2193.0 | 2243.0 | 7719.0 |
| 2010-12-29 | CB | Futures | 101.495 | 101.495 | 101.495 | 101.495 | 3.0 |
| 2010-12-29 | CC | Futures | 2487.0 | 2490.0 | 2409.0 | 2487.0 | 7748.0 |
| 2010-12-29 | CT | Futures | 123.36 | 125.5 | 120.38 | 120.42 | 6900.0 |
| 2010-12-29 | DC | Futures | 22.65 | 23.05 | 22.65 | 23.05 | 224.0 |
| 2010-12-29 | DX | Futures | 80.57 | 80.57 | 79.851 | 79.958 | 8917.0 |
| 2010-12-29 | E1 | Futures | 1.37771 | 1.38833 | 1.37653 | 1.38649 | 24321.0 |
| 2010-12-29 | E6 | Futures | 1.55026 | 1.56635 | 1.54742 | 1.56292 | 154904.0 |
| 2010-12-29 | E7 | Futures | 1.5387 | 1.5545 | 1.5359 | 1.5513 | 3400.0 |
| 2010-12-29 | EBM | Futures | 225.14 | 226.27 | 224.0 | 225.82 | 2788.0 |
| 2010-12-29 | ED | Futures | 94.7814 | 94.8099 | 94.7718 | 94.7956 | 108148.0 |
| 2010-12-29 | ER | Futures | 97.38 | 97.38 | 97.36 | 97.37 | 47214.0 |
| 2010-12-29 | EW | Futures | 894.3 | 898.7 | 894.3 | 896.6 | 5753.0 |
| 2010-12-29 | FBTP | Futures | 63.39 | 63.53 | 63.18 | 63.28 | 1872.0 |
| 2010-12-29 | FCE | Futures | 2586.7 | 2607.3 | 2580.6 | 2597.3 | 40532.0 |
| 2010-12-29 | FDAX | Futures | 7503.0 | 7521.7 | 7492.3 | 7501.4 | 48768.0 |
| 2010-12-29 | FESX | Futures | 1758.2 | 1770.0 | 1755.7 | 1763.2 | 331181.0 |
| 2010-12-29 | FEU3 | Futures | 97.939 | 97.939 | 97.929 | 97.929 | 1.0 |
| 2010-12-29 | FGBL | Futures | 98.66 | 99.31 | 98.62 | 98.81 | 216201.0 |
| 2010-12-29 | FGBM | Futures | 104.68 | 105.02 | 104.68 | 104.78 | 122430.0 |
| 2010-12-29 | FGBS | Futures | 107.494 | 107.558 | 107.469 | 107.514 | 134351.0 |
| 2010-12-29 | FGBX | Futures | 96.94 | 98.1 | 96.94 | 97.25 | 1345.0 |
| 2010-12-29 | FTDX | Futures | 746.8 | 750.4 | 746.4 | 748.2 | 173.0 |
| 2010-12-29 | FTI | Futures | 286.28 | 287.36 | 285.84 | 286.68 | 11083.0 |
| 2010-12-29 | FTUK | Futures | 4128.7 | 4157.2 | 4124.9 | 4140.9 | 47136.0 |
| 2010-12-29 | FXXP | Futures | 181.3 | 181.8 | 181.3 | 181.6 | 889.0 |
| 2010-12-29 | G | Futures | 81.26 | 81.27 | 80.73 | 80.97 | 35745.0 |
| 2010-12-29 | GF | Futures | 300.672 | 302.416 | 300.049 | 301.046 | 829.0 |
| 2010-12-29 | GSCI | Futures | 1022.57 | 1022.97 | 1020.38 | 1021.68 | 240.0 |
| 2010-12-29 | HE | Futures | 98.637 | 100.204 | 98.448 | 99.828 | 13861.0 |
| 2010-12-29 | HG | Futures | 5.766 | 5.7734 | 5.716 | 5.746 | 15161.0 |
| 2010-12-29 | HO | Futures | 2.1205 | 2.1291 | 2.1158 | 2.1235 | 9652.0 |
| 2010-12-29 | HRC | Futures | 2615.9 | 2615.9 | 2615.9 | 2615.9 | 0.0 |
| 2010-12-29 | J1 | Futures | 0.0152516 | 0.015401 | 0.0152453 | 0.015396 | 81506.0 |
| 2010-12-29 | J7 | Futures | 0.015143 | 0.015291 | 0.015141 | 0.015286 | 302.0 |
| 2010-12-29 | JB | Futures | 121.29 | 121.3 | 120.83 | 121.11 | 1013.0 |
| 2010-12-29 | KC | Futures | 585.11 | 590.14 | 576.65 | 587.69 | 3705.0 |
> showing 50 of 93 rows — these rows as CSV