PREVIEW / futures_daily / 2010-05-06
file: by_date/futures_daily/2010/2010-05-06.parquet size: 9 KB rows: 89
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-06 | ES | Futures | 1133.24 | 1138.11 | 1028.32 | 1093.07 | 5675645.0 |
| 2010-05-06 | NQ | Futures | 2221.22 | 2226.89 | 1962.85 | 2139.54 | 736165.0 |
| 2010-05-06 | YM | Futures | 9960.3 | 9987.8 | 9045.6 | 9612.8 | 326371.0 |
| 2010-05-06 | CL | Futures | 184.13 | 185.89 | 172.45 | 178.3 | 605011.0 |
| 2010-05-06 | GC | Futures | 1613.5 | 1662.8 | 1609.4 | 1642.7 | 271242.0 |
| 2010-05-06 | ZN | Futures | 96.927625 | 98.80241 | 96.621538 | 97.884148 | 2071540.0 |
| 2010-05-06 | A6 | Futures | 0.74069 | 0.74307 | 0.71123 | 0.72108 | 268773.0 |
| 2010-05-06 | AD | Futures | 0.95764 | 0.96011 | 0.91736 | 0.92862 | 220783.0 |
| 2010-05-06 | B | Futures | 74.14 | 74.39 | 69.63 | 71.61 | 149194.0 |
| 2010-05-06 | B6 | Futures | 1.5678 | 1.5727 | 1.521 | 1.5346 | 245381.0 |
| 2010-05-06 | BFX | Futures | 2756.9 | 2794.6 | 2731.6 | 2744.2 | 371.0 |
| 2010-05-06 | BR | Futures | 0.22513 | 0.22513 | 0.21733 | 0.21733 | 225.0 |
| 2010-05-06 | BZ | Futures | 75.35 | 75.35 | 75.35 | 75.35 | 139.0 |
| 2010-05-06 | C | Futures | 2384.0 | 2416.0 | 2384.0 | 2416.0 | 2614.0 |
| 2010-05-06 | CB | Futures | 80.439 | 80.933 | 80.439 | 80.933 | 4.0 |
| 2010-05-06 | CC | Futures | 2697.0 | 2708.0 | 2646.0 | 2691.0 | 10558.0 |
| 2010-05-06 | CT | Futures | 65.4 | 65.57 | 63.43 | 63.47 | 15139.0 |
| 2010-05-06 | DC | Futures | 22.3 | 22.38 | 21.89 | 21.97 | 316.0 |
| 2010-05-06 | DX | Futures | 85.391 | 86.602 | 85.183 | 86.183 | 68343.0 |
| 2010-05-06 | E1 | Futures | 1.17878 | 1.19615 | 1.17141 | 1.18352 | 104597.0 |
| 2010-05-06 | E6 | Futures | 1.51647 | 1.5212 | 1.48169 | 1.49092 | 828859.0 |
| 2010-05-06 | E7 | Futures | 1.5047 | 1.5086 | 1.4646 | 1.4787 | 11817.0 |
| 2010-05-06 | ED | Futures | 94.2334 | 94.2476 | 93.9586 | 94.0723 | 818937.0 |
| 2010-05-06 | ER | Futures | 97.262 | 97.296 | 97.124 | 97.203 | 546372.0 |
| 2010-05-06 | EW | Futures | 783.1 | 786.0 | 716.0 | 754.0 | 56623.0 |
| 2010-05-06 | FBTP | Futures | 64.22 | 64.32 | 62.99 | 63.11 | 12750.0 |
| 2010-05-06 | FCE | Futures | 2320.0 | 2352.4 | 2064.1 | 2279.8 | 297497.0 |
| 2010-05-06 | FDAX | Futures | 6486.0 | 6545.8 | 6044.4 | 6452.8 | 287228.0 |
| 2010-05-06 | FESX | Futures | 1607.5 | 1629.0 | 1428.7 | 1580.0 | 3490277.0 |
| 2010-05-06 | FEU3 | Futures | 97.825 | 97.85 | 97.736 | 97.761 | 1164.0 |
| 2010-05-06 | FGBL | Futures | 98.62 | 99.88 | 98.13 | 99.12 | 1620821.0 |
| 2010-05-06 | FGBM | Futures | 103.63 | 104.75 | 103.38 | 104.28 | 978399.0 |
| 2010-05-06 | FGBS | Futures | 107.163 | 107.54 | 107.09 | 107.325 | 1133805.0 |
| 2010-05-06 | FGBX | Futures | 96.22 | 97.4 | 95.52 | 96.87 | 6063.0 |
| 2010-05-06 | FTDX | Futures | 680.1 | 690.3 | 644.7 | 681.9 | 1068.0 |
| 2010-05-06 | FTI | Futures | 268.5 | 270.9 | 262.56 | 265.12 | 21371.0 |
| 2010-05-06 | FTUK | Futures | 3552.8 | 3622.5 | 3249.0 | 3561.9 | 231947.0 |
| 2010-05-06 | G | Futures | 77.99 | 78.19 | 77.68 | 78.09 | 127002.0 |
| 2010-05-06 | GF | Futures | 295.025 | 295.542 | 290.171 | 293.407 | 1110.0 |
| 2010-05-06 | GSCI | Futures | 941.16 | 942.98 | 909.67 | 915.57 | 710.0 |
| 2010-05-06 | HE | Futures | 106.217 | 108.197 | 104.708 | 105.714 | 24633.0 |
| 2010-05-06 | HG | Futures | 4.2795 | 4.3576 | 4.1417 | 4.2327 | 58525.0 |
| 2010-05-06 | HO | Futures | 1.9869 | 1.9978 | 1.8746 | 1.9264 | 69375.0 |
| 2010-05-06 | J1 | Futures | 0.0133903 | 0.0143018 | 0.013384 | 0.0141434 | 372501.0 |
| 2010-05-06 | J7 | Futures | 0.013283 | 0.014153 | 0.013278 | 0.014031 | 989.0 |
| 2010-05-06 | JB | Futures | 118.93 | 119.11 | 118.74 | 118.82 | 6478.0 |
| 2010-05-06 | KC | Futures | 347.81 | 348.07 | 337.66 | 338.17 | 17957.0 |
| 2010-05-06 | KE | Futures | 2272.63 | 2283.5 | 2226.99 | 2258.5 | 7976.0 |
| 2010-05-06 | L | Futures | 97.75 | 97.779 | 97.691 | 97.73 | 104657.0 |
| 2010-05-06 | LBS | Futures | 893.2 | 897.6 | 846.0 | 864.9 | 687.0 |
> showing 50 of 89 rows — these rows as CSV