PREVIEW / futures_daily / 2010-04-27
file: by_date/futures_daily/2010/2010-04-27.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-04-27 | ES | Futures | 1176.09 | 1178.28 | 1146.63 | 1150.04 | 3590721.0 |
| 2010-04-27 | NQ | Futures | 2320.77 | 2326.16 | 2267.17 | 2278.79 | 436324.0 |
| 2010-04-27 | YM | Futures | 10248.9 | 10266.4 | 10039.3 | 10070.6 | 211012.0 |
| 2010-04-27 | CL | Futures | 193.98 | 195.0 | 188.92 | 190.63 | 462842.0 |
| 2010-04-27 | GC | Futures | 1583.6 | 1609.9 | 1573.2 | 1594.6 | 182681.0 |
| 2010-04-27 | ZN | Futures | 95.205884 | 96.187914 | 95.180377 | 96.034871 | 1594625.0 |
| 2010-04-27 | A6 | Futures | 0.75669 | 0.75792 | 0.74537 | 0.7475 | 134572.0 |
| 2010-04-27 | AD | Futures | 0.98627 | 0.98725 | 0.96948 | 0.97314 | 129888.0 |
| 2010-04-27 | B | Futures | 77.64 | 77.87 | 76.17 | 76.71 | 105306.0 |
| 2010-04-27 | B6 | Futures | 1.6045 | 1.6073 | 1.5818 | 1.5837 | 164488.0 |
| 2010-04-27 | BFX | Futures | 2987.5 | 2988.9 | 2888.2 | 2888.2 | 402.0 |
| 2010-04-27 | BR | Futures | 0.23168 | 0.23168 | 0.23002 | 0.23002 | 33.0 |
| 2010-04-27 | BZ | Futures | 80.72 | 80.72 | 80.72 | 80.72 | 1.0 |
| 2010-04-27 | C | Futures | 2341.0 | 2373.0 | 2339.0 | 2356.0 | 5531.0 |
| 2010-04-27 | CC | Futures | 2707.0 | 2723.0 | 2680.0 | 2692.0 | 6580.0 |
| 2010-04-27 | CT | Futures | 68.24 | 68.42 | 67.21 | 67.72 | 8149.0 |
| 2010-04-27 | DC | Futures | 22.67 | 23.03 | 22.67 | 22.99 | 320.0 |
| 2010-04-27 | DX | Futures | 82.467 | 83.856 | 82.447 | 83.41 | 34096.0 |
| 2010-04-27 | E1 | Futures | 1.22866 | 1.23051 | 1.20984 | 1.21313 | 65340.0 |
| 2010-04-27 | E6 | Futures | 1.58437 | 1.58698 | 1.5574 | 1.56261 | 539793.0 |
| 2010-04-27 | E7 | Futures | 1.571 | 1.5739 | 1.5446 | 1.5498 | 7149.0 |
| 2010-04-27 | EBM | Futures | 216.3 | 217.94 | 212.6 | 213.42 | 6152.0 |
| 2010-04-27 | ED | Futures | 94.3613 | 94.3613 | 94.2902 | 94.3092 | 486577.0 |
| 2010-04-27 | ER | Futures | 97.36 | 97.365 | 97.252 | 97.33 | 382081.0 |
| 2010-04-27 | EW | Futures | 822.7 | 824.4 | 801.6 | 803.4 | 41760.0 |
| 2010-04-27 | FBTP | Futures | 64.59 | 64.59 | 64.08 | 64.32 | 9400.0 |
| 2010-04-27 | FCE | Futures | 2533.5 | 2541.6 | 2411.4 | 2442.5 | 187034.0 |
| 2010-04-27 | FDAX | Futures | 6884.7 | 6895.0 | 6647.0 | 6726.4 | 249665.0 |
| 2010-04-27 | FESX | Futures | 1756.4 | 1761.3 | 1670.6 | 1701.2 | 1989543.0 |
| 2010-04-27 | FEU3 | Futures | 97.894 | 97.894 | 97.889 | 97.889 | 10.0 |
| 2010-04-27 | FGBL | Futures | 96.84 | 97.82 | 96.81 | 97.27 | 1109904.0 |
| 2010-04-27 | FGBM | Futures | 102.33 | 102.95 | 102.3 | 102.61 | 644375.0 |
| 2010-04-27 | FGBS | Futures | 106.62 | 106.86 | 106.6 | 106.737 | 858388.0 |
| 2010-04-27 | FGBX | Futures | 92.65 | 94.83 | 92.65 | 93.93 | 4980.0 |
| 2010-04-27 | FTDX | Futures | 745.1 | 745.1 | 708.9 | 729.2 | 951.0 |
| 2010-04-27 | FTI | Futures | 287.26 | 288.52 | 278.59 | 282.33 | 39886.0 |
| 2010-04-27 | FTUK | Futures | 3860.7 | 3868.5 | 3731.1 | 3784.2 | 143687.0 |
| 2010-04-27 | G | Futures | 76.27 | 76.85 | 76.08 | 76.45 | 100428.0 |
| 2010-04-27 | GF | Futures | 294.831 | 296.643 | 290.689 | 292.695 | 2128.0 |
| 2010-04-27 | GSCI | Futures | 983.9 | 990.89 | 970.2 | 970.92 | 479.0 |
| 2010-04-27 | HE | Futures | 106.153 | 108.167 | 106.153 | 107.556 | 1637.0 |
| 2010-04-27 | HG | Futures | 4.8132 | 4.822 | 4.5735 | 4.5932 | 26385.0 |
| 2010-04-27 | HO | Futures | 2.0598 | 2.0806 | 2.042 | 2.0553 | 54190.0 |
| 2010-04-27 | HRC | Futures | 3130.4 | 3130.4 | 3130.4 | 3130.4 | 0.0 |
| 2010-04-27 | J1 | Futures | 0.0133752 | 0.0135525 | 0.0133752 | 0.0135085 | 179823.0 |
| 2010-04-27 | J7 | Futures | 0.013273 | 0.013443 | 0.013272 | 0.013401 | 338.0 |
| 2010-04-27 | JB | Futures | 118.34 | 118.57 | 118.29 | 118.56 | 1157.0 |
| 2010-04-27 | KC | Futures | 335.37 | 336.14 | 330.55 | 332.2 | 10627.0 |
| 2010-04-27 | KE | Futures | 2180.25 | 2200.9 | 2162.86 | 2186.77 | 10505.0 |
| 2010-04-27 | L | Futures | 97.848 | 97.858 | 97.789 | 97.829 | 107037.0 |
> showing 50 of 90 rows — these rows as CSV