PREVIEW / futures_daily / 2009-12-07
file: by_date/futures_daily/2009/2009-12-07.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 |
|---|---|---|---|---|---|---|---|
| 2009-12-07 | ES | Futures | 1068.7 | 1071.36 | 1059.78 | 1064.6 | 1572214.0 |
| 2009-12-07 | NQ | Futures | 2026.27 | 2030.79 | 2008.21 | 2013.85 | 239154.0 |
| 2009-12-07 | YM | Futures | 9440.0 | 9473.6 | 9373.7 | 9433.6 | 107836.0 |
| 2009-12-07 | CL | Futures | 184.47 | 185.2 | 179.36 | 179.92 | 359248.0 |
| 2009-12-07 | GC | Futures | 1597.1 | 1605.2 | 1563.7 | 1602.1 | 276335.0 |
| 2009-12-07 | ZN | Futures | 94.87458 | 95.43501 | 94.87458 | 95.31047 | 17961.0 |
| 2009-12-07 | A6 | Futures | 0.73936 | 0.74203 | 0.73096 | 0.73661 | 103313.0 |
| 2009-12-07 | AD | Futures | 0.93326 | 0.94065 | 0.92576 | 0.93631 | 102974.0 |
| 2009-12-07 | B | Futures | 72.35 | 72.53 | 70.89 | 71.01 | 85679.0 |
| 2009-12-07 | B6 | Futures | 1.7128 | 1.7183 | 1.6973 | 1.7105 | 119422.0 |
| 2009-12-07 | BFX | Futures | 2859.4 | 2870.2 | 2839.1 | 2864.7 | 147.0 |
| 2009-12-07 | BR | Futures | 0.2299 | 0.23014 | 0.22986 | 0.22986 | 210.0 |
| 2009-12-07 | C | Futures | 2270.0 | 2283.0 | 2248.0 | 2277.0 | 2787.0 |
| 2009-12-07 | CB | Futures | 73.037 | 73.037 | 72.544 | 72.79 | 36.0 |
| 2009-12-07 | CC | Futures | 2896.0 | 2908.0 | 2858.0 | 2902.0 | 3644.0 |
| 2009-12-07 | CT | Futures | 60.56 | 61.06 | 60.17 | 60.89 | 5360.0 |
| 2009-12-07 | DC | Futures | 24.86 | 24.89 | 24.72 | 24.79 | 182.0 |
| 2009-12-07 | DX | Futures | 77.337 | 77.853 | 77.062 | 77.399 | 30741.0 |
| 2009-12-07 | E1 | Futures | 1.30109 | 1.30307 | 1.2892 | 1.2958 | 77719.0 |
| 2009-12-07 | E6 | Futures | 1.76243 | 1.76646 | 1.74868 | 1.75638 | 310855.0 |
| 2009-12-07 | E7 | Futures | 1.7448 | 1.7493 | 1.732 | 1.7396 | 3746.0 |
| 2009-12-07 | EBM | Futures | 225.62 | 226.05 | 223.51 | 224.35 | 2932.0 |
| 2009-12-07 | ED | Futures | 94.2829 | 94.2852 | 94.2805 | 94.2829 | 66384.0 |
| 2009-12-07 | ER | Futures | 97.179 | 97.184 | 97.164 | 97.184 | 63853.0 |
| 2009-12-07 | EW | Futures | 681.3 | 684.4 | 674.3 | 679.0 | 27204.0 |
| 2009-12-07 | FBTP | Futures | 63.31 | 63.63 | 63.28 | 63.6 | 5165.0 |
| 2009-12-07 | FCE | Futures | 2537.0 | 2555.6 | 2521.1 | 2547.3 | 79613.0 |
| 2009-12-07 | FDAX | Futures | 6306.0 | 6326.2 | 6249.5 | 6293.0 | 123227.0 |
| 2009-12-07 | FESX | Futures | 1729.8 | 1737.0 | 1716.7 | 1729.8 | 944302.0 |
| 2009-12-07 | FEU3 | Futures | 97.746 | 97.756 | 97.746 | 97.756 | 197.0 |
| 2009-12-07 | FGBL | Futures | 94.59 | 94.89 | 94.54 | 94.81 | 736344.0 |
| 2009-12-07 | FGBM | Futures | 99.69 | 100.01 | 99.69 | 99.96 | 609199.0 |
| 2009-12-07 | FGBS | Futures | 104.968 | 105.119 | 104.968 | 105.09 | 711284.0 |
| 2009-12-07 | FGBX | Futures | 88.1 | 88.6 | 87.94 | 88.49 | 7909.0 |
| 2009-12-07 | FTDX | Futures | 717.3 | 727.9 | 715.0 | 725.7 | 475.0 |
| 2009-12-07 | FTI | Futures | 261.18 | 263.01 | 260.16 | 261.59 | 26168.0 |
| 2009-12-07 | FTUK | Futures | 3519.0 | 3535.9 | 3482.2 | 3520.7 | 83316.0 |
| 2009-12-07 | G | Futures | 76.66 | 76.92 | 76.62 | 76.79 | 72316.0 |
| 2009-12-07 | GF | Futures | 253.881 | 254.288 | 251.847 | 251.847 | 2810.0 |
| 2009-12-07 | GSCI | Futures | 965.54 | 974.43 | 961.86 | 961.86 | 3551.0 |
| 2009-12-07 | HE | Futures | 89.487 | 90.59 | 88.449 | 89.052 | 10633.0 |
| 2009-12-07 | HG | Futures | 4.4207 | 4.449 | 4.3538 | 4.427 | 19510.0 |
| 2009-12-07 | HO | Futures | 1.954 | 1.954 | 1.9161 | 1.9196 | 10376.0 |
| 2009-12-07 | HRC | Futures | 2511.4 | 2511.4 | 2486.3 | 2511.4 | 30.0 |
| 2009-12-07 | J1 | Futures | 0.0139116 | 0.0141025 | 0.013894 | 0.0140359 | 104215.0 |
| 2009-12-07 | J7 | Futures | 0.013725 | 0.013917 | 0.013725 | 0.013853 | 115.0 |
| 2009-12-07 | JB | Futures | 118.06 | 118.1 | 117.65 | 118.02 | 9656.0 |
| 2009-12-07 | KC | Futures | 369.62 | 384.97 | 365.84 | 381.59 | 16135.0 |
| 2009-12-07 | KE | Futures | 2482.81 | 2496.38 | 2427.41 | 2428.55 | 6889.0 |
| 2009-12-07 | KRW | Futures | 0.0008489 | 0.0008494 | 0.0008489 | 0.0008494 | 10.0 |
> showing 50 of 90 rows — these rows as CSV