PREVIEW / futures_daily / 2009-05-19
file: by_date/futures_daily/2009/2009-05-19.parquet size: 8 KB rows: 84
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-05-19 | ES | Futures | 865.17 | 872.79 | 861.12 | 863.98 | 1981787.0 |
| 2009-05-19 | NQ | Futures | 1560.56 | 1584.71 | 1549.32 | 1566.17 | 266271.0 |
| 2009-05-19 | YM | Futures | 7602.0 | 7669.2 | 7571.5 | 7578.6 | 131754.0 |
| 2009-05-19 | CL | Futures | 159.04 | 162.37 | 156.88 | 160.0 | 252709.0 |
| 2009-05-19 | GC | Futures | 1271.4 | 1287.6 | 1270.5 | 1283.1 | 87155.0 |
| 2009-05-19 | ZN | Futures | 93.73545 | 93.808273 | 93.468432 | 93.723313 | 645954.0 |
| 2009-05-19 | A6 | Futures | 0.60842 | 0.61967 | 0.60723 | 0.61927 | 48530.0 |
| 2009-05-19 | AD | Futures | 0.84682 | 0.8547 | 0.84446 | 0.85411 | 52911.0 |
| 2009-05-19 | B | Futures | 56.35 | 57.45 | 55.57 | 56.75 | 116376.0 |
| 2009-05-19 | B6 | Futures | 1.5955 | 1.6151 | 1.5913 | 1.6139 | 90957.0 |
| 2009-05-19 | BFX | Futures | 2368.4 | 2382.2 | 2349.3 | 2356.0 | 164.0 |
| 2009-05-19 | BZ | Futures | 61.63 | 61.85 | 60.25 | 61.5 | 95.0 |
| 2009-05-19 | C | Futures | 1705.0 | 1721.0 | 1701.0 | 1705.0 | 12698.0 |
| 2009-05-19 | CC | Futures | 2033.0 | 2062.0 | 2027.0 | 2041.0 | 5251.0 |
| 2009-05-19 | CT | Futures | 53.25 | 53.57 | 51.61 | 52.02 | 8961.0 |
| 2009-05-19 | DC | Futures | 24.6 | 24.91 | 24.6 | 24.7 | 60.0 |
| 2009-05-19 | DX | Futures | 85.109 | 85.202 | 84.409 | 84.497 | 5174.0 |
| 2009-05-19 | E1 | Futures | 1.18963 | 1.19811 | 1.1879 | 1.19732 | 31297.0 |
| 2009-05-19 | E6 | Futures | 1.60647 | 1.61998 | 1.60374 | 1.61797 | 194041.0 |
| 2009-05-19 | E7 | Futures | 1.5884 | 1.6011 | 1.5853 | 1.5992 | 2344.0 |
| 2009-05-19 | ED | Futures | 93.5983 | 93.6549 | 93.5983 | 93.6384 | 202620.0 |
| 2009-05-19 | ER | Futures | 96.86 | 96.865 | 96.802 | 96.811 | 136977.0 |
| 2009-05-19 | EW | Futures | 545.4 | 554.1 | 541.6 | 548.5 | 26160.0 |
| 2009-05-19 | FCE | Futures | 2091.3 | 2119.9 | 2087.4 | 2106.6 | 124221.0 |
| 2009-05-19 | FDAX | Futures | 5328.5 | 5461.3 | 5322.5 | 5390.0 | 178526.0 |
| 2009-05-19 | FESX | Futures | 1454.5 | 1479.7 | 1452.7 | 1464.7 | 1315739.0 |
| 2009-05-19 | FEU3 | Futures | 97.431 | 97.441 | 97.392 | 97.392 | 884.0 |
| 2009-05-19 | FGBL | Futures | 91.29 | 91.29 | 90.82 | 90.95 | 763983.0 |
| 2009-05-19 | FGBM | Futures | 97.66 | 97.67 | 97.27 | 97.35 | 466281.0 |
| 2009-05-19 | FGBS | Futures | 103.959 | 103.968 | 103.824 | 103.834 | 509991.0 |
| 2009-05-19 | FGBX | Futures | 80.62 | 80.76 | 80.25 | 80.37 | 1397.0 |
| 2009-05-19 | FTDX | Futures | 561.2 | 572.0 | 557.6 | 570.2 | 1245.0 |
| 2009-05-19 | FTI | Futures | 215.77 | 217.13 | 213.67 | 215.98 | 37376.0 |
| 2009-05-19 | FTUK | Futures | 2960.7 | 2986.4 | 2939.1 | 2956.7 | 111562.0 |
| 2009-05-19 | G | Futures | 76.39 | 76.76 | 76.31 | 76.62 | 105120.0 |
| 2009-05-19 | GF | Futures | 280.867 | 281.419 | 278.387 | 279.42 | 802.0 |
| 2009-05-19 | GSCI | Futures | 879.23 | 884.46 | 872.3 | 884.25 | 420.0 |
| 2009-05-19 | HE | Futures | 100.077 | 100.452 | 98.916 | 99.253 | 4756.0 |
| 2009-05-19 | HG | Futures | 2.9095 | 2.9953 | 2.8842 | 2.9116 | 14668.0 |
| 2009-05-19 | HO | Futures | 1.6238 | 1.6238 | 1.5752 | 1.6025 | 3317.0 |
| 2009-05-19 | HRC | Futures | 2495.0 | 2495.0 | 2495.0 | 2495.0 | 0.0 |
| 2009-05-19 | J1 | Futures | 0.0130929 | 0.0131433 | 0.0130362 | 0.0131118 | 68585.0 |
| 2009-05-19 | J7 | Futures | 0.012906 | 0.012962 | 0.012868 | 0.012934 | 43.0 |
| 2009-05-19 | JB | Futures | 115.0 | 115.0 | 114.72 | 114.85 | 1575.0 |
| 2009-05-19 | KC | Futures | 358.55 | 367.0 | 357.72 | 366.58 | 8651.0 |
| 2009-05-19 | KE | Futures | 3131.46 | 3169.25 | 3110.74 | 3133.9 | 7854.0 |
| 2009-05-19 | L | Futures | 97.111 | 97.16 | 97.101 | 97.16 | 51473.0 |
| 2009-05-19 | LBS | Futures | 835.1 | 840.1 | 801.3 | 811.4 | 225.0 |
| 2009-05-19 | LE | Futures | 146.669 | 147.021 | 145.215 | 145.611 | 4711.0 |
| 2009-05-19 | MP | Futures | 0.03947 | 0.03984 | 0.03937 | 0.0397 | 9490.0 |
> showing 50 of 84 rows — these rows as CSV