PREVIEW / futures_daily / 2009-03-09
file: by_date/futures_daily/2009/2009-03-09.parquet size: 8 KB rows: 86
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-03-09 | ES | Futures | 650.38 | 656.04 | 633.38 | 638.34 | 2721975.0 |
| 2009-03-09 | NQ | Futures | 1203.79 | 1216.09 | 1162.99 | 1170.53 | 421893.0 |
| 2009-03-09 | YM | Futures | 5948.7 | 5977.2 | 5794.7 | 5812.5 | 226019.0 |
| 2009-03-09 | CL | Futures | 128.83 | 137.47 | 126.6 | 132.51 | 390590.0 |
| 2009-03-09 | GC | Futures | 1306.1 | 1308.3 | 1264.4 | 1273.9 | 108004.0 |
| 2009-03-09 | ZN | Futures | 94.439406 | 94.718562 | 94.026742 | 94.487955 | 578376.0 |
| 2009-03-09 | A6 | Futures | 0.5075 | 0.51139 | 0.49989 | 0.50172 | 45448.0 |
| 2009-03-09 | AD | Futures | 0.76391 | 0.76656 | 0.75183 | 0.75811 | 49509.0 |
| 2009-03-09 | B | Futures | 45.48 | 45.85 | 43.17 | 44.39 | 127739.0 |
| 2009-03-09 | B6 | Futures | 1.4677 | 1.4737 | 1.4278 | 1.4338 | 101435.0 |
| 2009-03-09 | BFX | Futures | 1716.9 | 1716.9 | 1687.8 | 1705.0 | 317.0 |
| 2009-03-09 | BZ | Futures | 46.55 | 46.91 | 46.23 | 46.3 | 16.0 |
| 2009-03-09 | C | Futures | 1805.0 | 1841.0 | 1797.0 | 1824.0 | 3421.0 |
| 2009-03-09 | CB | Futures | 77.339 | 77.339 | 77.339 | 77.339 | 3.0 |
| 2009-03-09 | CC | Futures | 1993.0 | 2010.0 | 1953.0 | 1993.0 | 4310.0 |
| 2009-03-09 | CT | Futures | 39.37 | 39.62 | 38.69 | 38.85 | 5338.0 |
| 2009-03-09 | DC | Futures | 28.08 | 28.48 | 28.03 | 28.39 | 155.0 |
| 2009-03-09 | DX | Futures | 91.893 | 92.774 | 91.411 | 92.287 | 9104.0 |
| 2009-03-09 | E1 | Futures | 1.14813 | 1.15265 | 1.13776 | 1.1472 | 32026.0 |
| 2009-03-09 | E6 | Futures | 1.49929 | 1.50675 | 1.48639 | 1.49515 | 184570.0 |
| 2009-03-09 | E7 | Futures | 1.483 | 1.4894 | 1.4693 | 1.478 | 1480.0 |
| 2009-03-09 | EBM | Futures | 213.63 | 216.72 | 212.85 | 214.01 | 4689.0 |
| 2009-03-09 | ED | Futures | 92.9353 | 92.9353 | 92.827 | 92.8364 | 199601.0 |
| 2009-03-09 | ER | Futures | 96.444 | 96.449 | 96.424 | 96.439 | 116750.0 |
| 2009-03-09 | EW | Futures | 403.4 | 405.7 | 392.8 | 397.2 | 34221.0 |
| 2009-03-09 | FCE | Futures | 1584.4 | 1595.6 | 1536.7 | 1570.7 | 159182.0 |
| 2009-03-09 | FDAX | Futures | 4011.3 | 4049.5 | 3918.0 | 4035.3 | 193277.0 |
| 2009-03-09 | FESX | Futures | 1043.3 | 1050.8 | 1011.7 | 1040.5 | 1749371.0 |
| 2009-03-09 | FEU3 | Futures | 97.012 | 97.012 | 97.002 | 97.007 | 1800.0 |
| 2009-03-09 | FGBL | Futures | 94.49 | 94.82 | 94.34 | 94.42 | 561765.0 |
| 2009-03-09 | FGBM | Futures | 98.81 | 98.89 | 98.51 | 98.59 | 275426.0 |
| 2009-03-09 | FGBS | Futures | 104.011 | 104.026 | 103.805 | 103.819 | 359279.0 |
| 2009-03-09 | FGBX | Futures | 86.22 | 86.46 | 85.77 | 86.08 | 832.0 |
| 2009-03-09 | FTDX | Futures | 366.9 | 368.7 | 358.0 | 366.9 | 260.0 |
| 2009-03-09 | FTI | Futures | 163.55 | 164.33 | 158.87 | 162.29 | 37956.0 |
| 2009-03-09 | FTUK | Futures | 2308.3 | 2328.3 | 2257.5 | 2313.5 | 163212.0 |
| 2009-03-09 | G | Futures | 78.67 | 79.65 | 78.41 | 78.51 | 109015.0 |
| 2009-03-09 | GF | Futures | 255.576 | 256.699 | 254.033 | 254.524 | 165.0 |
| 2009-03-09 | GSCI | Futures | 726.67 | 756.2 | 723.6 | 733.01 | 60.0 |
| 2009-03-09 | HE | Futures | 120.818 | 122.075 | 120.142 | 120.673 | 7648.0 |
| 2009-03-09 | HG | Futures | 2.3845 | 2.3964 | 2.2908 | 2.3098 | 12895.0 |
| 2009-03-09 | HO | Futures | 1.3954 | 1.4141 | 1.3532 | 1.3647 | 6558.0 |
| 2009-03-09 | HRC | Futures | 2959.0 | 2959.0 | 2959.0 | 2959.0 | 0.0 |
| 2009-03-09 | J1 | Futures | 0.0128359 | 0.0129003 | 0.0127349 | 0.0127841 | 70487.0 |
| 2009-03-09 | J7 | Futures | 0.012694 | 0.012735 | 0.012584 | 0.01263 | 156.0 |
| 2009-03-09 | JB | Futures | 116.09 | 116.33 | 115.88 | 116.33 | 606.0 |
| 2009-03-09 | KC | Futures | 301.83 | 302.82 | 293.53 | 299.02 | 7983.0 |
| 2009-03-09 | KE | Futures | 2829.84 | 2885.3 | 2808.89 | 2833.54 | 7410.0 |
| 2009-03-09 | L | Futures | 96.463 | 96.492 | 96.443 | 96.482 | 44746.0 |
| 2009-03-09 | LBS | Futures | 836.3 | 836.3 | 812.2 | 816.7 | 138.0 |
> showing 50 of 86 rows — these rows as CSV