PREVIEW / futures_daily / 2011-10-11
file: by_date/futures_daily/2011/2011-10-11.parquet size: 9 KB rows: 95
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 |
|---|---|---|---|---|---|---|---|
| 2011-10-11 | ES | Futures | 1188.41 | 1192.66 | 1178.68 | 1187.41 | 1953734.0 |
| 2011-10-11 | NQ | Futures | 2597.1 | 2621.07 | 2582.26 | 2612.22 | 243144.0 |
| 2011-10-11 | YM | Futures | 10916.9 | 10935.2 | 10847.8 | 10884.3 | 103949.0 |
| 2011-10-11 | CL | Futures | 161.6 | 163.37 | 158.33 | 161.8 | 362324.0 |
| 2011-10-11 | GC | Futures | 2266.0 | 2277.3 | 2235.0 | 2242.6 | 110057.0 |
| 2011-10-11 | ZN | Futures | 109.685976 | 110.23568 | 109.685976 | 110.034569 | 1014445.0 |
| 2011-10-11 | A6 | Futures | 0.87146 | 0.87252 | 0.8639 | 0.87094 | 123509.0 |
| 2011-10-11 | AD | Futures | 0.97254 | 0.97394 | 0.96613 | 0.96984 | 75722.0 |
| 2011-10-11 | B | Futures | 93.2 | 94.86 | 91.97 | 94.47 | 216860.0 |
| 2011-10-11 | B6 | Futures | 1.6332 | 1.6337 | 1.6241 | 1.6259 | 88456.0 |
| 2011-10-11 | BR | Futures | 0.25363 | 0.25395 | 0.25363 | 0.25395 | 74.0 |
| 2011-10-11 | BZ | Futures | 98.19 | 100.22 | 97.31 | 99.84 | 876.0 |
| 2011-10-11 | C | Futures | 1810.0 | 1815.0 | 1770.0 | 1787.0 | 6186.0 |
| 2011-10-11 | CB | Futures | 93.971 | 94.793 | 93.971 | 94.793 | 10.0 |
| 2011-10-11 | CC | Futures | 2083.0 | 2092.0 | 2023.0 | 2042.0 | 9282.0 |
| 2011-10-11 | CSC | Futures | 3.935 | 3.947 | 3.898 | 3.947 | 48.0 |
| 2011-10-11 | CT | Futures | 133.43 | 134.08 | 132.39 | 133.4 | 6316.0 |
| 2011-10-11 | DC | Futures | 27.47 | 27.92 | 27.18 | 27.6 | 452.0 |
| 2011-10-11 | DX | Futures | 76.554 | 76.849 | 76.353 | 76.483 | 21148.0 |
| 2011-10-11 | E1 | Futures | 1.45281 | 1.45569 | 1.44034 | 1.44834 | 20977.0 |
| 2011-10-11 | E6 | Futures | 1.62871 | 1.63457 | 1.62035 | 1.63182 | 286387.0 |
| 2011-10-11 | E7 | Futures | 1.6146 | 1.6205 | 1.6066 | 1.6179 | 5433.0 |
| 2011-10-11 | ED | Futures | 94.9316 | 94.9555 | 94.9316 | 94.9459 | 145385.0 |
| 2011-10-11 | ER | Futures | 97.204 | 97.243 | 97.204 | 97.228 | 90721.0 |
| 2011-10-11 | EW | Futures | 827.8 | 834.5 | 819.4 | 827.2 | 26883.0 |
| 2011-10-11 | FBTP | Futures | 62.66 | 62.72 | 62.41 | 62.52 | 3747.0 |
| 2011-10-11 | FBTS | Futures | 82.425 | 82.433 | 82.313 | 82.337 | 803.0 |
| 2011-10-11 | FCE | Futures | 2258.8 | 2262.0 | 2225.3 | 2251.7 | 99853.0 |
| 2011-10-11 | FDAX | Futures | 6383.0 | 6399.8 | 6279.3 | 6364.5 | 140170.0 |
| 2011-10-11 | FESX | Futures | 1539.1 | 1541.1 | 1513.2 | 1530.5 | 1321991.0 |
| 2011-10-11 | FGBL | Futures | 109.02 | 109.22 | 108.74 | 108.86 | 694801.0 |
| 2011-10-11 | FGBM | Futures | 110.03 | 110.2 | 109.9 | 109.97 | 388380.0 |
| 2011-10-11 | FGBS | Futures | 108.835 | 108.915 | 108.8 | 108.82 | 388171.0 |
| 2011-10-11 | FGBX | Futures | 110.93 | 111.13 | 110.15 | 110.38 | 4215.0 |
| 2011-10-11 | FTDX | Futures | 617.8 | 621.0 | 611.3 | 615.9 | 136.0 |
| 2011-10-11 | FTI | Futures | 239.4 | 241.55 | 239.4 | 241.55 | 27.0 |
| 2011-10-11 | FTUK | Futures | 3861.9 | 3863.3 | 3807.3 | 3844.7 | 94742.0 |
| 2011-10-11 | FVSA | Futures | 16567.55 | 16842.27 | 16208.31 | 16313.97 | 2672.0 |
| 2011-10-11 | FXXP | Futures | 164.2 | 164.2 | 162.1 | 163.2 | 2684.0 |
| 2011-10-11 | G | Futures | 90.07 | 90.26 | 89.71 | 90.1 | 150914.0 |
| 2011-10-11 | GF | Futures | 317.627 | 318.789 | 314.584 | 316.742 | 4773.0 |
| 2011-10-11 | GSCI | Futures | 965.19 | 981.8 | 964.33 | 980.86 | 1304.0 |
| 2011-10-11 | HE | Futures | 112.857 | 113.275 | 111.54 | 111.54 | 17522.0 |
| 2011-10-11 | HG | Futures | 4.4476 | 4.482 | 4.2749 | 4.3543 | 43417.0 |
| 2011-10-11 | HO | Futures | 2.3251 | 2.3407 | 2.2919 | 2.3324 | 40374.0 |
| 2011-10-11 | HRC | Futures | 2706.8 | 2706.8 | 2706.8 | 2706.8 | 0.0 |
| 2011-10-11 | J1 | Futures | 0.0164027 | 0.0164177 | 0.0163838 | 0.0164077 | 54745.0 |
| 2011-10-11 | J7 | Futures | 0.016299 | 0.016317 | 0.016284 | 0.016308 | 206.0 |
| 2011-10-11 | JB | Futures | 124.31 | 124.44 | 124.26 | 124.43 | 2597.0 |
| 2011-10-11 | KC | Futures | 533.27 | 538.1 | 522.31 | 526.43 | 10395.0 |
> showing 50 of 95 rows — these rows as CSV