PREVIEW / futures_daily / 2009-09-15
file: by_date/futures_daily/2009/2009-09-15.parquet size: 9 KB rows: 88
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-09-15 | ES | Futures | 1006.25 | 1014.69 | 1001.43 | 1008.9 | 2605342.0 |
| 2009-09-15 | NQ | Futures | 1906.05 | 1921.29 | 1896.17 | 1913.39 | 328788.0 |
| 2009-09-15 | YM | Futures | 8669.2 | 8764.5 | 8641.1 | 8718.2 | 172147.0 |
| 2009-09-15 | CL | Futures | 171.4 | 177.14 | 170.78 | 176.57 | 130966.0 |
| 2009-09-15 | GC | Futures | 1383.7 | 1398.3 | 1372.8 | 1391.1 | 114627.0 |
| 2009-09-15 | ZN | Futures | 93.591818 | 93.728812 | 93.180836 | 93.405008 | 795196.0 |
| 2009-09-15 | A6 | Futures | 0.69192 | 0.69386 | 0.68707 | 0.69257 | 69511.0 |
| 2009-09-15 | AD | Futures | 0.91028 | 0.92073 | 0.90713 | 0.91866 | 69659.0 |
| 2009-09-15 | B | Futures | 64.65 | 66.08 | 63.74 | 65.95 | 148349.0 |
| 2009-09-15 | B6 | Futures | 1.7245 | 1.7336 | 1.7065 | 1.7158 | 128249.0 |
| 2009-09-15 | BFX | Futures | 2779.5 | 2806.9 | 2774.2 | 2802.1 | 1834.0 |
| 2009-09-15 | BR | Futures | 0.21597 | 0.21738 | 0.21597 | 0.21738 | 1.0 |
| 2009-09-15 | BZ | Futures | 66.77 | 68.73 | 66.44 | 68.65 | 13.0 |
| 2009-09-15 | C | Futures | 2020.0 | 2069.0 | 2017.0 | 2061.0 | 16645.0 |
| 2009-09-15 | CB | Futures | 69.121 | 69.928 | 69.121 | 69.928 | 20.0 |
| 2009-09-15 | CC | Futures | 2689.0 | 2735.0 | 2681.0 | 2715.0 | 6943.0 |
| 2009-09-15 | CT | Futures | 54.27 | 54.62 | 53.91 | 54.33 | 73.0 |
| 2009-09-15 | DC | Futures | 23.48 | 23.82 | 23.48 | 23.5 | 96.0 |
| 2009-09-15 | DX | Futures | 78.445 | 78.935 | 78.266 | 78.394 | 7712.0 |
| 2009-09-15 | E1 | Futures | 1.27824 | 1.28061 | 1.26859 | 1.27705 | 33583.0 |
| 2009-09-15 | E6 | Futures | 1.73327 | 1.74038 | 1.72533 | 1.73718 | 233857.0 |
| 2009-09-15 | E7 | Futures | 1.7162 | 1.7241 | 1.7089 | 1.7205 | 2191.0 |
| 2009-09-15 | ED | Futures | 94.1056 | 94.1245 | 94.082 | 94.1009 | 193061.0 |
| 2009-09-15 | ER | Futures | 97.184 | 97.198 | 97.159 | 97.164 | 137900.0 |
| 2009-09-15 | EW | Futures | 661.8 | 671.3 | 659.4 | 668.0 | 47645.0 |
| 2009-09-15 | FCE | Futures | 2462.6 | 2487.7 | 2457.7 | 2475.5 | 101547.0 |
| 2009-09-15 | FDAX | Futures | 6172.1 | 6199.0 | 6125.5 | 6166.6 | 167328.0 |
| 2009-09-15 | FESX | Futures | 1683.2 | 1698.7 | 1673.7 | 1686.8 | 871320.0 |
| 2009-09-15 | FEU3 | Futures | 97.756 | 97.756 | 97.736 | 97.736 | 3522.0 |
| 2009-09-15 | FGBL | Futures | 93.46 | 93.54 | 93.07 | 93.3 | 821552.0 |
| 2009-09-15 | FGBM | Futures | 98.95 | 99.0 | 98.72 | 98.86 | 502653.0 |
| 2009-09-15 | FGBS | Futures | 104.706 | 104.721 | 104.614 | 104.668 | 532748.0 |
| 2009-09-15 | FGBX | Futures | 86.27 | 86.66 | 85.93 | 86.27 | 2030.0 |
| 2009-09-15 | FTDX | Futures | 658.9 | 672.3 | 658.9 | 669.2 | 1416.0 |
| 2009-09-15 | FTI | Futures | 252.68 | 255.23 | 251.65 | 253.83 | 25039.0 |
| 2009-09-15 | FTUK | Futures | 3323.7 | 3340.3 | 3293.8 | 3323.7 | 147878.0 |
| 2009-09-15 | G | Futures | 76.62 | 76.76 | 76.45 | 76.65 | 71330.0 |
| 2009-09-15 | GF | Futures | 272.454 | 273.142 | 270.182 | 271.008 | 2032.0 |
| 2009-09-15 | GSCI | Futures | 912.05 | 929.66 | 902.95 | 924.56 | 2328.0 |
| 2009-09-15 | HE | Futures | 76.897 | 80.495 | 76.073 | 80.083 | 21174.0 |
| 2009-09-15 | HG | Futures | 3.9088 | 3.9904 | 3.8949 | 3.9646 | 18254.0 |
| 2009-09-15 | HO | Futures | 1.7593 | 1.7961 | 1.7409 | 1.7891 | 12000.0 |
| 2009-09-15 | HRC | Futures | 2738.7 | 2738.7 | 2738.7 | 2738.7 | 0.0 |
| 2009-09-15 | J1 | Futures | 0.0138212 | 0.01384 | 0.0137107 | 0.0137911 | 83854.0 |
| 2009-09-15 | J7 | Futures | 0.013632 | 0.01365 | 0.013533 | 0.013611 | 24.0 |
| 2009-09-15 | JB | Futures | 117.47 | 117.47 | 117.21 | 117.25 | 1295.0 |
| 2009-09-15 | KC | Futures | 353.32 | 356.89 | 347.38 | 355.3 | 11931.0 |
| 2009-09-15 | KE | Futures | 2170.64 | 2299.77 | 2156.68 | 2243.93 | 14200.0 |
| 2009-09-15 | L | Futures | 97.73 | 97.838 | 97.691 | 97.819 | 245097.0 |
| 2009-09-15 | LBS | Futures | 726.7 | 738.1 | 722.6 | 726.7 | 684.0 |
> showing 50 of 88 rows — these rows as CSV