PREVIEW / futures_daily / 2009-06-05
file: by_date/futures_daily/2009/2009-06-05.parquet size: 8 KB rows: 85
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 |
|---|---|---|---|---|---|---|---|
| 2009-06-05 | ES | Futures | 896.86 | 912.59 | 889.47 | 896.38 | 2399049.0 |
| 2009-06-05 | NQ | Futures | 1677.12 | 1699.87 | 1661.11 | 1679.65 | 289129.0 |
| 2009-06-05 | YM | Futures | 7834.3 | 7983.2 | 7795.7 | 7859.4 | 161873.0 |
| 2009-06-05 | CL | Futures | 182.97 | 187.21 | 179.8 | 182.2 | 329259.0 |
| 2009-06-05 | GC | Futures | 1358.7 | 1363.7 | 1320.5 | 1332.7 | 150846.0 |
| 2009-06-05 | ZN | Futures | 90.664743 | 90.689017 | 89.366065 | 89.426751 | 23472.0 |
| 2009-06-05 | A6 | Futures | 0.63945 | 0.64758 | 0.63099 | 0.63362 | 87901.0 |
| 2009-06-05 | AD | Futures | 0.89644 | 0.89822 | 0.87872 | 0.8804 | 88607.0 |
| 2009-06-05 | B | Futures | 66.85 | 67.57 | 65.16 | 66.06 | 66601.0 |
| 2009-06-05 | B6 | Futures | 1.6795 | 1.6901 | 1.658 | 1.6622 | 127973.0 |
| 2009-06-05 | BFX | Futures | 2373.0 | 2376.9 | 2346.4 | 2354.8 | 93.0 |
| 2009-06-05 | BR | Futures | 0.19574 | 0.19601 | 0.19251 | 0.19529 | 303.0 |
| 2009-06-05 | BZ | Futures | 72.38 | 72.61 | 71.29 | 72.09 | 11.0 |
| 2009-06-05 | C | Futures | 1894.0 | 1937.0 | 1884.0 | 1906.0 | 3820.0 |
| 2009-06-05 | CC | Futures | 2419.0 | 2478.0 | 2405.0 | 2424.0 | 5951.0 |
| 2009-06-05 | CT | Futures | 52.51 | 52.64 | 50.75 | 50.99 | 8812.0 |
| 2009-06-05 | DC | Futures | 23.48 | 23.51 | 22.82 | 22.86 | 206.0 |
| 2009-06-05 | DX | Futures | 81.871 | 83.292 | 81.541 | 83.132 | 9319.0 |
| 2009-06-05 | E1 | Futures | 1.24028 | 1.24333 | 1.21561 | 1.22079 | 62413.0 |
| 2009-06-05 | E6 | Futures | 1.68068 | 1.69135 | 1.65152 | 1.65507 | 278203.0 |
| 2009-06-05 | E7 | Futures | 1.6608 | 1.672 | 1.6326 | 1.6359 | 3275.0 |
| 2009-06-05 | ED | Futures | 93.6667 | 93.6714 | 93.5936 | 93.6125 | 331030.0 |
| 2009-06-05 | ER | Futures | 96.679 | 96.694 | 96.655 | 96.664 | 160371.0 |
| 2009-06-05 | EW | Futures | 576.6 | 587.6 | 569.9 | 575.3 | 29914.0 |
| 2009-06-05 | FCE | Futures | 2164.5 | 2205.8 | 2156.1 | 2171.7 | 134593.0 |
| 2009-06-05 | FDAX | Futures | 5550.1 | 5625.3 | 5496.2 | 5534.9 | 155090.0 |
| 2009-06-05 | FESX | Futures | 1499.5 | 1527.7 | 1491.7 | 1503.1 | 1263093.0 |
| 2009-06-05 | FEU3 | Futures | 97.268 | 97.268 | 97.244 | 97.244 | 580.0 |
| 2009-06-05 | FGBL | Futures | 89.99 | 90.18 | 89.36 | 89.43 | 808404.0 |
| 2009-06-05 | FGBM | Futures | 96.79 | 96.81 | 95.99 | 96.17 | 594762.0 |
| 2009-06-05 | FGBS | Futures | 103.661 | 103.661 | 103.247 | 103.348 | 797064.0 |
| 2009-06-05 | FGBX | Futures | 79.68 | 80.92 | 79.68 | 80.29 | 5487.0 |
| 2009-06-05 | FTDX | Futures | 589.1 | 594.4 | 584.6 | 588.2 | 497.0 |
| 2009-06-05 | FTI | Futures | 218.45 | 222.48 | 218.45 | 219.81 | 35645.0 |
| 2009-06-05 | FTUK | Futures | 2948.4 | 2994.3 | 2937.1 | 2952.4 | 113855.0 |
| 2009-06-05 | G | Futures | 74.55 | 74.71 | 74.07 | 74.24 | 56990.0 |
| 2009-06-05 | GF | Futures | 266.259 | 268.877 | 265.019 | 266.328 | 1478.0 |
| 2009-06-05 | GSCI | Futures | 984.51 | 987.18 | 961.47 | 968.51 | 191.0 |
| 2009-06-05 | HE | Futures | 89.446 | 90.214 | 86.741 | 87.838 | 7438.0 |
| 2009-06-05 | HG | Futures | 3.2373 | 3.2837 | 3.1402 | 3.2134 | 24088.0 |
| 2009-06-05 | HO | Futures | 1.8806 | 1.9026 | 1.8484 | 1.8632 | 7482.0 |
| 2009-06-05 | HRC | Futures | 2310.2 | 2310.2 | 2310.2 | 2310.2 | 0.0 |
| 2009-06-05 | J1 | Futures | 0.0130362 | 0.0130513 | 0.0127438 | 0.0128131 | 110488.0 |
| 2009-06-05 | J7 | Futures | 0.012839 | 0.012947 | 0.012557 | 0.012639 | 263.0 |
| 2009-06-05 | JB | Futures | 114.58 | 114.64 | 114.33 | 114.59 | 1130.0 |
| 2009-06-05 | KC | Futures | 385.56 | 386.53 | 370.05 | 370.88 | 12604.0 |
| 2009-06-05 | KE | Futures | 3381.34 | 3381.34 | 3291.14 | 3291.14 | 9006.0 |
| 2009-06-05 | L | Futures | 97.023 | 97.023 | 96.876 | 96.934 | 87238.0 |
| 2009-06-05 | LBS | Futures | 952.4 | 975.2 | 947.4 | 975.2 | 393.0 |
| 2009-06-05 | LE | Futures | 143.276 | 143.937 | 142.483 | 143.012 | 5916.0 |
> showing 50 of 85 rows — these rows as CSV