PREVIEW / futures_daily / 2011-06-10
file: by_date/futures_daily/2011/2011-06-10.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 |
|---|---|---|---|---|---|---|---|
| 2011-06-10 | ES | Futures | 1274.88 | 1275.87 | 1254.34 | 1256.57 | 1453530.0 |
| 2011-06-10 | NQ | Futures | 2565.34 | 2569.04 | 2526.62 | 2529.75 | 136078.0 |
| 2011-06-10 | YM | Futures | 11388.4 | 11399.7 | 11206.8 | 11224.8 | 94561.0 |
| 2011-06-10 | CL | Futures | 195.65 | 196.24 | 189.42 | 190.75 | 379238.0 |
| 2011-06-10 | GC | Futures | 2091.2 | 2093.1 | 2066.3 | 2069.7 | 129478.0 |
| 2011-06-10 | ZN | Futures | 104.962927 | 105.428601 | 104.909707 | 105.175807 | 1076705.0 |
| 2011-06-10 | A6 | Futures | 0.91265 | 0.91526 | 0.90421 | 0.90795 | 117274.0 |
| 2011-06-10 | AD | Futures | 1.02251 | 1.02511 | 1.01612 | 1.01922 | 99241.0 |
| 2011-06-10 | B | Futures | 102.03 | 102.33 | 100.26 | 101.26 | 128408.0 |
| 2011-06-10 | B6 | Futures | 1.7001 | 1.7021 | 1.684 | 1.6872 | 141743.0 |
| 2011-06-10 | BFX | Futures | 3096.5 | 3096.6 | 3058.1 | 3058.1 | 164.0 |
| 2011-06-10 | BR | Futures | 0.27579 | 0.27579 | 0.2735 | 0.27415 | 120.0 |
| 2011-06-10 | BZ | Futures | 105.97 | 105.97 | 104.77 | 105.59 | 937.0 |
| 2011-06-10 | C | Futures | 2012.0 | 2024.0 | 2002.0 | 2010.0 | 3847.0 |
| 2011-06-10 | CB | Futures | 117.258 | 117.258 | 117.258 | 117.258 | 20.0 |
| 2011-06-10 | CC | Futures | 2378.0 | 2387.0 | 2354.0 | 2364.0 | 9926.0 |
| 2011-06-10 | CT | Futures | 150.64 | 152.82 | 146.98 | 148.49 | 13947.0 |
| 2011-06-10 | DC | Futures | 30.73 | 30.78 | 30.52 | 30.6 | 211.0 |
| 2011-06-10 | DX | Futures | 73.831 | 74.613 | 73.722 | 74.461 | 36278.0 |
| 2011-06-10 | E1 | Futures | 1.5549 | 1.55831 | 1.55033 | 1.55412 | 42535.0 |
| 2011-06-10 | E6 | Futures | 1.71858 | 1.72333 | 1.69613 | 1.69982 | 327614.0 |
| 2011-06-10 | E7 | Futures | 1.7058 | 1.7105 | 1.6839 | 1.6874 | 5156.0 |
| 2011-06-10 | ED | Futures | 94.9716 | 94.9763 | 94.9668 | 94.9763 | 176748.0 |
| 2011-06-10 | ER | Futures | 97.311 | 97.341 | 97.296 | 97.331 | 231504.0 |
| 2011-06-10 | EW | Futures | 938.6 | 938.6 | 918.4 | 921.1 | 36752.0 |
| 2011-06-10 | FBTP | Futures | 64.88 | 65.09 | 64.71 | 65.07 | 5280.0 |
| 2011-06-10 | FCE | Futures | 2683.2 | 2690.2 | 2629.8 | 2640.2 | 145091.0 |
| 2011-06-10 | FDAX | Futures | 7631.8 | 7672.4 | 7523.9 | 7553.8 | 159799.0 |
| 2011-06-10 | FESX | Futures | 1776.7 | 1784.4 | 1744.0 | 1753.0 | 238942.0 |
| 2011-06-10 | FEU3 | Futures | 97.855 | 97.87 | 97.85 | 97.865 | 294.0 |
| 2011-06-10 | FGBL | Futures | 100.4 | 101.08 | 100.4 | 100.98 | 920970.0 |
| 2011-06-10 | FGBM | Futures | 104.86 | 105.38 | 104.86 | 105.3 | 669291.0 |
| 2011-06-10 | FGBS | Futures | 106.886 | 107.099 | 106.881 | 107.065 | 652875.0 |
| 2011-06-10 | FGBX | Futures | 95.87 | 96.89 | 95.85 | 96.83 | 3609.0 |
| 2011-06-10 | FTI | Futures | 277.09 | 277.63 | 273.85 | 274.22 | 6528.0 |
| 2011-06-10 | FTUK | Futures | 4097.3 | 4111.4 | 4021.8 | 4047.5 | 37839.0 |
| 2011-06-10 | FXXP | Futures | 181.6 | 181.6 | 181.0 | 181.3 | 15383.0 |
| 2011-06-10 | G | Futures | 84.35 | 84.72 | 84.32 | 84.68 | 126758.0 |
| 2011-06-10 | GF | Futures | 291.375 | 292.13 | 287.191 | 287.308 | 2831.0 |
| 2011-06-10 | GSCI | Futures | 1113.66 | 1113.66 | 1100.18 | 1106.96 | 1817.0 |
| 2011-06-10 | HE | Futures | 99.171 | 100.238 | 99.091 | 99.464 | 17434.0 |
| 2011-06-10 | HG | Futures | 5.457 | 5.4776 | 5.3514 | 5.3886 | 44947.0 |
| 2011-06-10 | HO | Futures | 2.5646 | 2.5646 | 2.5253 | 2.5398 | 11858.0 |
| 2011-06-10 | HRC | Futures | 3118.0 | 3118.0 | 3118.0 | 3118.0 | 0.0 |
| 2011-06-10 | J1 | Futures | 0.0156435 | 0.0157265 | 0.0156285 | 0.0156536 | 95349.0 |
| 2011-06-10 | J7 | Futures | 0.015548 | 0.015619 | 0.015537 | 0.015549 | 408.0 |
| 2011-06-10 | JB | Futures | 122.51 | 122.74 | 122.4 | 122.69 | 1597.0 |
| 2011-06-10 | KC | Futures | 640.74 | 644.58 | 627.19 | 635.35 | 14299.0 |
| 2011-06-10 | KE | Futures | 3439.17 | 3459.91 | 3373.02 | 3428.31 | 19317.0 |
| 2011-06-10 | L | Futures | 98.453 | 98.483 | 98.423 | 98.473 | 57884.0 |
> showing 50 of 90 rows — these rows as CSV