PREVIEW / futures_daily / 2010-05-07
file: by_date/futures_daily/2010/2010-05-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 |
|---|---|---|---|---|---|---|---|
| 2010-05-07 | ES | Futures | 1094.29 | 1105.73 | 1062.16 | 1077.98 | 5013862.0 |
| 2010-05-07 | NQ | Futures | 2137.27 | 2165.92 | 2048.5 | 2097.0 | 710793.0 |
| 2010-05-07 | YM | Futures | 9618.3 | 9725.8 | 9378.4 | 9500.6 | 322300.0 |
| 2010-05-07 | CL | Futures | 177.93 | 180.8 | 172.29 | 173.68 | 601534.0 |
| 2010-05-07 | GC | Futures | 1658.0 | 1666.9 | 1636.8 | 1660.7 | 255295.0 |
| 2010-05-07 | ZN | Futures | 97.845887 | 98.496322 | 97.042408 | 97.692843 | 2093465.0 |
| 2010-05-07 | A6 | Futures | 0.72436 | 0.73043 | 0.71927 | 0.72568 | 263856.0 |
| 2010-05-07 | AD | Futures | 0.9378 | 0.95497 | 0.93395 | 0.94678 | 194265.0 |
| 2010-05-07 | B | Futures | 71.62 | 72.32 | 69.62 | 70.23 | 144825.0 |
| 2010-05-07 | B6 | Futures | 1.5348 | 1.5508 | 1.5029 | 1.5374 | 304790.0 |
| 2010-05-07 | BFX | Futures | 2654.2 | 2714.7 | 2557.0 | 2568.5 | 299.0 |
| 2010-05-07 | BR | Futures | 0.22308 | 0.22554 | 0.22003 | 0.22003 | 570.0 |
| 2010-05-07 | BZ | Futures | 73.91 | 73.91 | 73.91 | 73.91 | 7.0 |
| 2010-05-07 | C | Futures | 2402.0 | 2422.0 | 2341.0 | 2341.0 | 4250.0 |
| 2010-05-07 | CB | Futures | 81.426 | 81.55 | 80.933 | 81.426 | 10.0 |
| 2010-05-07 | CC | Futures | 2645.0 | 2662.0 | 2529.0 | 2534.0 | 19296.0 |
| 2010-05-07 | CT | Futures | 63.59 | 65.41 | 63.59 | 64.15 | 14667.0 |
| 2010-05-07 | DC | Futures | 22.03 | 22.57 | 21.84 | 22.39 | 373.0 |
| 2010-05-07 | DX | Futures | 86.131 | 86.495 | 85.36 | 85.79 | 68758.0 |
| 2010-05-07 | E1 | Futures | 1.18365 | 1.19221 | 1.17904 | 1.18852 | 83612.0 |
| 2010-05-07 | E6 | Futures | 1.49565 | 1.51458 | 1.4895 | 1.50713 | 672554.0 |
| 2010-05-07 | E7 | Futures | 1.4819 | 1.5019 | 1.4771 | 1.4948 | 11017.0 |
| 2010-05-07 | ED | Futures | 94.1102 | 94.1528 | 94.0344 | 94.1292 | 723782.0 |
| 2010-05-07 | ER | Futures | 97.129 | 97.218 | 97.095 | 97.183 | 490503.0 |
| 2010-05-07 | EW | Futures | 754.0 | 760.8 | 727.1 | 735.0 | 59381.0 |
| 2010-05-07 | FBTP | Futures | 62.92 | 63.09 | 62.46 | 62.88 | 9946.0 |
| 2010-05-07 | FCE | Futures | 2205.3 | 2272.4 | 2145.1 | 2177.1 | 432493.0 |
| 2010-05-07 | FDAX | Futures | 6253.2 | 6426.7 | 6155.4 | 6223.9 | 409386.0 |
| 2010-05-07 | FESX | Futures | 1520.6 | 1581.2 | 1474.7 | 1509.6 | 4758356.0 |
| 2010-05-07 | FEU3 | Futures | 97.677 | 97.756 | 97.677 | 97.756 | 157.0 |
| 2010-05-07 | FGBL | Futures | 99.27 | 99.62 | 98.65 | 99.09 | 1693210.0 |
| 2010-05-07 | FGBM | Futures | 104.3 | 104.48 | 103.87 | 104.21 | 895469.0 |
| 2010-05-07 | FGBS | Futures | 107.408 | 107.427 | 107.197 | 107.28 | 951145.0 |
| 2010-05-07 | FGBX | Futures | 97.0 | 98.06 | 96.04 | 96.93 | 5724.0 |
| 2010-05-07 | FTDX | Futures | 661.5 | 674.8 | 653.1 | 661.5 | 1442.0 |
| 2010-05-07 | FTI | Futures | 256.78 | 262.68 | 249.5 | 252.63 | 103146.0 |
| 2010-05-07 | FTUK | Futures | 3456.0 | 3554.2 | 3397.2 | 3451.6 | 391646.0 |
| 2010-05-07 | G | Futures | 78.43 | 78.91 | 76.94 | 77.84 | 233175.0 |
| 2010-05-07 | GF | Futures | 291.401 | 292.954 | 290.56 | 291.013 | 1571.0 |
| 2010-05-07 | GSCI | Futures | 921.92 | 925.55 | 899.78 | 907.95 | 2363.0 |
| 2010-05-07 | HE | Futures | 105.274 | 107.882 | 104.897 | 107.505 | 19930.0 |
| 2010-05-07 | HG | Futures | 4.1791 | 4.3169 | 4.158 | 4.27 | 47858.0 |
| 2010-05-07 | HO | Futures | 1.9194 | 1.9438 | 1.8769 | 1.8953 | 70908.0 |
| 2010-05-07 | HRC | Futures | 3153.1 | 3153.1 | 3153.1 | 3153.1 | 0.0 |
| 2010-05-07 | J1 | Futures | 0.0138542 | 0.013985 | 0.0134871 | 0.0137562 | 370925.0 |
| 2010-05-07 | J7 | Futures | 0.013765 | 0.013775 | 0.013402 | 0.013646 | 584.0 |
| 2010-05-07 | JB | Futures | 118.81 | 119.13 | 118.75 | 118.91 | 4261.0 |
| 2010-05-07 | KC | Futures | 338.17 | 341.72 | 333.22 | 339.94 | 14325.0 |
| 2010-05-07 | KE | Futures | 2235.68 | 2296.54 | 2223.73 | 2265.03 | 8348.0 |
| 2010-05-07 | L | Futures | 97.681 | 97.7 | 97.562 | 97.582 | 102593.0 |
> showing 50 of 90 rows — these rows as CSV