PREVIEW / futures_daily / 2010-01-22
file: by_date/futures_daily/2010/2010-01-22.parquet size: 9 KB rows: 90
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-22 | ES | Futures | 1075.73 | 1081.55 | 1052.95 | 1057.56 | 3544446.0 |
| 2010-01-22 | NQ | Futures | 2082.54 | 2091.59 | 2024.01 | 2033.34 | 527630.0 |
| 2010-01-22 | YM | Futures | 9441.3 | 9476.9 | 9235.8 | 9272.3 | 213602.0 |
| 2010-01-22 | CL | Futures | 179.13 | 180.69 | 174.81 | 176.06 | 348819.0 |
| 2010-01-22 | GC | Futures | 1507.7 | 1512.5 | 1489.1 | 1499.9 | 214203.0 |
| 2010-01-22 | ZN | Futures | 95.033404 | 95.146749 | 94.882278 | 95.033404 | 960239.0 |
| 2010-01-22 | A6 | Futures | 0.72884 | 0.73501 | 0.72607 | 0.729 | 110001.0 |
| 2010-01-22 | AD | Futures | 0.93858 | 0.94342 | 0.93098 | 0.93236 | 89698.0 |
| 2010-01-22 | B | Futures | 67.47 | 68.15 | 65.45 | 66.05 | 175629.0 |
| 2010-01-22 | B6 | Futures | 1.6811 | 1.6908 | 1.6692 | 1.6734 | 154259.0 |
| 2010-01-22 | BFX | Futures | 2785.2 | 2804.4 | 2773.3 | 2773.3 | 500.0 |
| 2010-01-22 | BR | Futures | 0.21956 | 0.21956 | 0.21956 | 0.21956 | 176.0 |
| 2010-01-22 | BZ | Futures | 68.67 | 68.83 | 67.49 | 67.84 | 1.0 |
| 2010-01-22 | C | Futures | 2355.0 | 2378.0 | 2338.0 | 2374.0 | 4810.0 |
| 2010-01-22 | CC | Futures | 2949.0 | 2958.0 | 2883.0 | 2943.0 | 9785.0 |
| 2010-01-22 | CT | Futures | 58.58 | 58.66 | 57.87 | 57.94 | 7973.0 |
| 2010-01-22 | DC | Futures | 23.29 | 23.62 | 22.99 | 23.39 | 321.0 |
| 2010-01-22 | DX | Futures | 79.845 | 80.064 | 79.545 | 79.759 | 20684.0 |
| 2010-01-22 | E1 | Futures | 1.2648 | 1.27126 | 1.26256 | 1.26585 | 50385.0 |
| 2010-01-22 | E6 | Futures | 1.66711 | 1.67871 | 1.66498 | 1.67326 | 272957.0 |
| 2010-01-22 | E7 | Futures | 1.6555 | 1.6672 | 1.6534 | 1.6616 | 3597.0 |
| 2010-01-22 | EBM | Futures | 214.62 | 216.31 | 213.77 | 214.2 | 4751.0 |
| 2010-01-22 | ED | Futures | 94.3867 | 94.3867 | 94.3583 | 94.3678 | 221399.0 |
| 2010-01-22 | ER | Futures | 97.326 | 97.33 | 97.301 | 97.311 | 222062.0 |
| 2010-01-22 | EW | Futures | 713.4 | 717.5 | 698.1 | 700.6 | 46302.0 |
| 2010-01-22 | FBTP | Futures | 63.3 | 63.4 | 63.17 | 63.26 | 6180.0 |
| 2010-01-22 | FCE | Futures | 2499.0 | 2514.0 | 2428.0 | 2488.6 | 163933.0 |
| 2010-01-22 | FDAX | Futures | 6254.8 | 6275.0 | 6079.0 | 6229.2 | 242830.0 |
| 2010-01-22 | FESX | Futures | 1700.0 | 1710.7 | 1653.9 | 1697.6 | 2048380.0 |
| 2010-01-22 | FEU3 | Futures | 97.889 | 97.889 | 97.869 | 97.874 | 316.0 |
| 2010-01-22 | FGBL | Futures | 95.14 | 95.22 | 94.86 | 94.96 | 822516.0 |
| 2010-01-22 | FGBM | Futures | 100.75 | 100.84 | 100.59 | 100.65 | 546740.0 |
| 2010-01-22 | FGBS | Futures | 105.703 | 105.747 | 105.649 | 105.688 | 620025.0 |
| 2010-01-22 | FGBX | Futures | 88.67 | 88.89 | 88.44 | 88.57 | 5175.0 |
| 2010-01-22 | FTDX | Futures | 720.3 | 721.2 | 698.7 | 713.3 | 1015.0 |
| 2010-01-22 | FTI | Futures | 267.66 | 269.73 | 261.48 | 266.93 | 49212.0 |
| 2010-01-22 | FTUK | Futures | 3532.4 | 3550.8 | 3446.6 | 3525.0 | 170086.0 |
| 2010-01-22 | G | Futures | 75.9 | 76.14 | 75.76 | 75.83 | 94155.0 |
| 2010-01-22 | GF | Futures | 267.823 | 269.309 | 267.688 | 269.039 | 1379.0 |
| 2010-01-22 | GSCI | Futures | 947.2 | 947.48 | 935.52 | 937.2 | 343.0 |
| 2010-01-22 | HE | Futures | 96.411 | 97.248 | 95.909 | 96.311 | 11466.0 |
| 2010-01-22 | HG | Futures | 4.5408 | 4.6539 | 4.507 | 4.6173 | 39545.0 |
| 2010-01-22 | HO | Futures | 1.8549 | 1.8679 | 1.8091 | 1.8181 | 48747.0 |
| 2010-01-22 | HRC | Futures | 2729.2 | 2729.2 | 2729.2 | 2729.2 | 0.0 |
| 2010-01-22 | J1 | Futures | 0.0139208 | 0.0140202 | 0.0138982 | 0.0140089 | 150399.0 |
| 2010-01-22 | J7 | Futures | 0.013809 | 0.013847 | 0.013724 | 0.013833 | 101.0 |
| 2010-01-22 | JB | Futures | 117.37 | 117.75 | 117.28 | 117.53 | 2034.0 |
| 2010-01-22 | KC | Futures | 361.16 | 367.66 | 357.38 | 363.37 | 12745.0 |
| 2010-01-22 | KE | Futures | 2281.57 | 2286.09 | 2243.13 | 2270.26 | 7371.0 |
| 2010-01-22 | L | Futures | 97.848 | 97.858 | 97.819 | 97.829 | 48681.0 |
> showing 50 of 90 rows — these rows as CSV