PREVIEW / futures_daily / 2010-01-04
file: by_date/futures_daily/2010/2010-01-04.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 |
|---|---|---|---|---|---|---|---|
| 2010-01-04 | ES | Futures | 1079.61 | 1095.12 | 1079.12 | 1094.15 | 1291254.0 |
| 2010-01-04 | NQ | Futures | 2109.97 | 2136.55 | 2109.97 | 2134.0 | 205157.0 |
| 2010-01-04 | YM | Futures | 9485.1 | 9634.9 | 9485.1 | 9608.4 | 93770.0 |
| 2010-01-04 | CL | Futures | 188.84 | 193.96 | 188.84 | 193.3 | 263542.0 |
| 2010-01-04 | GC | Futures | 1512.7 | 1547.9 | 1505.5 | 1539.2 | 155479.0 |
| 2010-01-04 | ZN | Futures | 92.84207 | 93.282855 | 92.665755 | 93.119135 | 611675.0 |
| 2010-01-04 | A6 | Futures | 0.7251 | 0.73713 | 0.72104 | 0.73534 | 65306.0 |
| 2010-01-04 | AD | Futures | 0.94273 | 0.95369 | 0.93868 | 0.94717 | 65261.0 |
| 2010-01-04 | B | Futures | 71.74 | 73.46 | 71.73 | 73.27 | 71176.0 |
| 2010-01-04 | B6 | Futures | 1.6741 | 1.6862 | 1.6672 | 1.6706 | 107463.0 |
| 2010-01-04 | BFX | Futures | 2865.0 | 2902.3 | 2859.4 | 2902.3 | 816.0 |
| 2010-01-04 | BR | Futures | 0.23099 | 0.2316 | 0.23099 | 0.2316 | 50.0 |
| 2010-01-04 | C | Futures | 2269.0 | 2279.0 | 2237.0 | 2254.0 | 4554.0 |
| 2010-01-04 | CB | Futures | 71.557 | 71.803 | 71.557 | 71.557 | 4.0 |
| 2010-01-04 | CC | Futures | 2825.0 | 2845.0 | 2788.0 | 2797.0 | 5875.0 |
| 2010-01-04 | CT | Futures | 61.88 | 62.59 | 61.69 | 61.96 | 10341.0 |
| 2010-01-04 | DC | Futures | 23.78 | 23.9 | 23.63 | 23.65 | 257.0 |
| 2010-01-04 | DX | Futures | 79.683 | 79.922 | 78.889 | 79.149 | 18278.0 |
| 2010-01-04 | E1 | Futures | 1.27601 | 1.28537 | 1.26585 | 1.28168 | 59906.0 |
| 2010-01-04 | E6 | Futures | 1.69564 | 1.71127 | 1.68771 | 1.70594 | 221750.0 |
| 2010-01-04 | E7 | Futures | 1.6841 | 1.6992 | 1.676 | 1.6941 | 2870.0 |
| 2010-01-04 | EBM | Futures | 227.74 | 228.16 | 226.47 | 227.32 | 2437.0 |
| 2010-01-04 | ED | Futures | 94.3157 | 94.3252 | 94.2968 | 94.3205 | 140640.0 |
| 2010-01-04 | ER | Futures | 97.233 | 97.247 | 97.223 | 97.242 | 103478.0 |
| 2010-01-04 | EW | Futures | 705.5 | 717.1 | 705.5 | 714.9 | 26265.0 |
| 2010-01-04 | FBTP | Futures | 62.71 | 63.01 | 62.65 | 62.99 | 1449.0 |
| 2010-01-04 | FCE | Futures | 2580.5 | 2625.3 | 2574.3 | 2624.0 | 89195.0 |
| 2010-01-04 | FDAX | Futures | 6557.4 | 6622.9 | 6532.8 | 6603.8 | 100960.0 |
| 2010-01-04 | FESX | Futures | 1783.2 | 1811.9 | 1780.2 | 1804.7 | 867757.0 |
| 2010-01-04 | FEU3 | Futures | 97.796 | 97.805 | 97.796 | 97.805 | 761.0 |
| 2010-01-04 | FGBL | Futures | 93.29 | 93.62 | 93.17 | 93.56 | 469426.0 |
| 2010-01-04 | FGBM | Futures | 99.31 | 99.52 | 99.15 | 99.46 | 295973.0 |
| 2010-01-04 | FGBS | Futures | 105.051 | 105.158 | 104.982 | 105.128 | 430722.0 |
| 2010-01-04 | FGBX | Futures | 86.58 | 87.15 | 86.02 | 86.99 | 4756.0 |
| 2010-01-04 | FTDX | Futures | 724.8 | 740.2 | 720.3 | 734.5 | 313.0 |
| 2010-01-04 | FTI | Futures | 274.06 | 280.13 | 273.93 | 279.97 | 25190.0 |
| 2010-01-04 | FTUK | Futures | 3596.0 | 3661.6 | 3593.3 | 3654.6 | 77744.0 |
| 2010-01-04 | G | Futures | 74.82 | 75.6 | 74.77 | 75.46 | 81793.0 |
| 2010-01-04 | GF | Futures | 259.916 | 260.323 | 258.153 | 260.052 | 1413.0 |
| 2010-01-04 | GSCI | Futures | 1014.27 | 1021.85 | 1014.27 | 1021.85 | 642.0 |
| 2010-01-04 | HE | Futures | 88.215 | 88.884 | 87.647 | 88.115 | 11089.0 |
| 2010-01-04 | HG | Futures | 4.6215 | 4.7305 | 4.6166 | 4.6987 | 22606.0 |
| 2010-01-04 | HO | Futures | 1.9902 | 2.0471 | 1.9895 | 2.0411 | 24388.0 |
| 2010-01-04 | HRC | Futures | 2729.2 | 2729.2 | 2633.5 | 2633.5 | 1.0 |
| 2010-01-04 | J1 | Futures | 0.0135445 | 0.0136565 | 0.0135043 | 0.0135961 | 95881.0 |
| 2010-01-04 | J7 | Futures | 0.01339 | 0.013483 | 0.013338 | 0.013426 | 445.0 |
| 2010-01-04 | JB | Futures | 117.93 | 117.98 | 117.55 | 117.56 | 3303.0 |
| 2010-01-04 | KC | Futures | 354.0 | 370.79 | 354.0 | 369.23 | 13246.0 |
| 2010-01-04 | KE | Futures | 2439.85 | 2506.56 | 2436.46 | 2490.73 | 8853.0 |
| 2010-01-04 | L | Futures | 97.789 | 97.809 | 97.769 | 97.799 | 46726.0 |
> showing 50 of 89 rows — these rows as CSV