PREVIEW / futures_daily / 2011-05-11
file: by_date/futures_daily/2011/2011-05-11.parquet size: 9 KB rows: 93
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-05-11 | ES | Futures | 1340.23 | 1344.68 | 1319.68 | 1325.38 | 2190906.0 |
| 2011-05-11 | NQ | Futures | 2741.87 | 2750.69 | 2703.72 | 2725.92 | 297723.0 |
| 2011-05-11 | YM | Futures | 11944.0 | 11977.8 | 11791.7 | 11843.4 | 124193.0 |
| 2011-05-11 | CL | Futures | 199.82 | 201.57 | 187.89 | 189.26 | 524761.0 |
| 2011-05-11 | GC | Futures | 2051.8 | 2066.5 | 2024.0 | 2032.2 | 198028.0 |
| 2011-05-11 | ZN | Futures | 102.738455 | 103.225679 | 102.593605 | 103.173007 | 1273064.0 |
| 2011-05-11 | A6 | Futures | 0.9256 | 0.92998 | 0.91068 | 0.91239 | 143921.0 |
| 2011-05-11 | AD | Futures | 1.03924 | 1.04581 | 1.03207 | 1.03446 | 101341.0 |
| 2011-05-11 | B | Futures | 99.56 | 100.04 | 94.51 | 95.02 | 229193.0 |
| 2011-05-11 | B6 | Futures | 1.6996 | 1.7154 | 1.6949 | 1.6972 | 149889.0 |
| 2011-05-11 | BR | Futures | 0.27245 | 0.27245 | 0.26992 | 0.27003 | 454.0 |
| 2011-05-11 | BZ | Futures | 105.07 | 105.07 | 100.12 | 100.12 | 1032.0 |
| 2011-05-11 | C | Futures | 2085.0 | 2106.0 | 2052.0 | 2079.0 | 6741.0 |
| 2011-05-11 | CB | Futures | 117.335 | 117.335 | 116.749 | 116.749 | 10.0 |
| 2011-05-11 | CC | Futures | 2483.0 | 2525.0 | 2443.0 | 2482.0 | 8286.0 |
| 2011-05-11 | CSC | Futures | 4.371 | 4.381 | 4.278 | 4.278 | 9.0 |
| 2011-05-11 | CT | Futures | 150.44 | 153.53 | 146.25 | 148.76 | 11625.0 |
| 2011-05-11 | DC | Futures | 30.02 | 30.03 | 28.81 | 28.93 | 560.0 |
| 2011-05-11 | DX | Futures | 74.362 | 75.243 | 74.158 | 75.14 | 54998.0 |
| 2011-05-11 | E1 | Futures | 1.4876 | 1.49101 | 1.47398 | 1.47477 | 41921.0 |
| 2011-05-11 | E6 | Futures | 1.70555 | 1.70721 | 1.67736 | 1.68009 | 360158.0 |
| 2011-05-11 | E7 | Futures | 1.6924 | 1.6946 | 1.665 | 1.6676 | 7412.0 |
| 2011-05-11 | ED | Futures | 94.9549 | 94.9644 | 94.9502 | 94.9597 | 125004.0 |
| 2011-05-11 | ER | Futures | 97.291 | 97.301 | 97.277 | 97.281 | 124322.0 |
| 2011-05-11 | EW | Futures | 1001.6 | 1004.7 | 986.1 | 991.1 | 26538.0 |
| 2011-05-11 | FBTP | Futures | 65.01 | 65.11 | 64.98 | 65.06 | 4268.0 |
| 2011-05-11 | FCE | Futures | 2747.7 | 2755.6 | 2711.3 | 2744.0 | 133272.0 |
| 2011-05-11 | FDAX | Futures | 8046.1 | 8093.6 | 7955.3 | 8023.2 | 135220.0 |
| 2011-05-11 | FESX | Futures | 1870.2 | 1879.9 | 1846.5 | 1866.4 | 1109742.0 |
| 2011-05-11 | FEU3 | Futures | 97.835 | 97.835 | 97.825 | 97.825 | 7.0 |
| 2011-05-11 | FGBL | Futures | 99.1 | 99.48 | 98.88 | 99.16 | 1055035.0 |
| 2011-05-11 | FGBM | Futures | 103.64 | 103.97 | 103.57 | 103.75 | 662667.0 |
| 2011-05-11 | FGBS | Futures | 106.469 | 106.573 | 106.429 | 106.503 | 806540.0 |
| 2011-05-11 | FGBX | Futures | 95.75 | 96.3 | 95.57 | 95.81 | 4974.0 |
| 2011-05-11 | FTDX | Futures | 832.4 | 835.9 | 825.2 | 830.6 | 492.0 |
| 2011-05-11 | FTI | Futures | 296.81 | 297.71 | 294.06 | 295.91 | 115.0 |
| 2011-05-11 | FTUK | Futures | 4207.5 | 4216.6 | 4132.2 | 4170.0 | 96231.0 |
| 2011-05-11 | FXXP | Futures | 188.1 | 189.4 | 187.0 | 188.6 | 7892.0 |
| 2011-05-11 | G | Futures | 83.5 | 83.54 | 83.06 | 83.21 | 153026.0 |
| 2011-05-11 | GF | Futures | 308.863 | 311.536 | 308.689 | 309.153 | 3059.0 |
| 2011-05-11 | GSCI | Futures | 1103.64 | 1103.64 | 1061.77 | 1069.83 | 2249.0 |
| 2011-05-11 | HE | Futures | 99.408 | 99.779 | 98.429 | 98.72 | 24620.0 |
| 2011-05-11 | HG | Futures | 5.3733 | 5.4052 | 5.1787 | 5.1993 | 41755.0 |
| 2011-05-11 | HO | Futures | 2.5032 | 2.5114 | 2.4023 | 2.4083 | 66431.0 |
| 2011-05-11 | HRC | Futures | 3077.0 | 3077.0 | 3077.0 | 3077.0 | 0.0 |
| 2011-05-11 | J1 | Futures | 0.0155405 | 0.0155883 | 0.0154488 | 0.0155267 | 121909.0 |
| 2011-05-11 | J7 | Futures | 0.015439 | 0.01549 | 0.015355 | 0.015432 | 978.0 |
| 2011-05-11 | JB | Futures | 122.33 | 122.51 | 122.27 | 122.44 | 162.0 |
| 2011-05-11 | KC | Futures | 678.63 | 680.07 | 653.57 | 655.01 | 18287.0 |
| 2011-05-11 | KE | Futures | 3674.18 | 3692.94 | 3537.92 | 3554.7 | 16419.0 |
> showing 50 of 93 rows — these rows as CSV