PREVIEW / futures_daily / 2011-06-17
file: by_date/futures_daily/2011/2011-06-17.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-06-17 | ES | Futures | 1255.07 | 1268.48 | 1249.86 | 1257.31 | 2335210.0 |
| 2011-06-17 | NQ | Futures | 2500.14 | 2526.62 | 2485.34 | 2494.16 | 308529.0 |
| 2011-06-17 | YM | Futures | 11245.6 | 11350.5 | 11210.6 | 11286.2 | 131672.0 |
| 2011-06-17 | CL | Futures | 183.24 | 183.84 | 176.97 | 179.21 | 196081.0 |
| 2011-06-17 | GC | Futures | 2069.5 | 2088.3 | 2061.5 | 2083.1 | 119736.0 |
| 2011-06-17 | ZN | Futures | 105.574956 | 105.694701 | 105.215722 | 105.508431 | 1135289.0 |
| 2011-06-17 | A6 | Futures | 0.90848 | 0.91448 | 0.90308 | 0.91265 | 111366.0 |
| 2011-06-17 | AD | Futures | 1.01453 | 1.01862 | 1.00914 | 1.01572 | 85366.0 |
| 2011-06-17 | B | Futures | 97.72 | 97.8 | 95.01 | 96.86 | 206669.0 |
| 2011-06-17 | B6 | Futures | 1.6794 | 1.6832 | 1.6722 | 1.6809 | 88736.0 |
| 2011-06-17 | BFX | Futures | 3005.4 | 3053.9 | 3005.4 | 3047.1 | 326.0 |
| 2011-06-17 | BR | Futures | 0.27083 | 0.27415 | 0.27083 | 0.27415 | 123.0 |
| 2011-06-17 | BZ | Futures | 100.74 | 101.52 | 99.82 | 101.0 | 859.0 |
| 2011-06-17 | C | Futures | 1947.0 | 1987.0 | 1947.0 | 1981.0 | 999.0 |
| 2011-06-17 | CB | Futures | 116.71 | 116.71 | 116.162 | 116.162 | 2.0 |
| 2011-06-17 | CC | Futures | 2288.0 | 2317.0 | 2288.0 | 2312.0 | 4849.0 |
| 2011-06-17 | CSC | Futures | 4.546 | 4.546 | 4.521 | 4.521 | 6.0 |
| 2011-06-17 | CT | Futures | 144.47 | 146.8 | 142.63 | 143.69 | 3664.0 |
| 2011-06-17 | DC | Futures | 30.9 | 30.98 | 30.47 | 30.47 | 151.0 |
| 2011-06-17 | DX | Futures | 75.187 | 75.514 | 74.628 | 74.733 | 33597.0 |
| 2011-06-17 | E1 | Futures | 1.54392 | 1.5502 | 1.5379 | 1.54261 | 40611.0 |
| 2011-06-17 | E6 | Futures | 1.68366 | 1.69875 | 1.67357 | 1.69554 | 319613.0 |
| 2011-06-17 | E7 | Futures | 1.6711 | 1.6863 | 1.6615 | 1.6832 | 5837.0 |
| 2011-06-17 | ED | Futures | 94.8763 | 94.9334 | 94.8763 | 94.9096 | 412632.0 |
| 2011-06-17 | ER | Futures | 97.276 | 97.296 | 97.237 | 97.281 | 194736.0 |
| 2011-06-17 | EW | Futures | 921.5 | 931.7 | 917.7 | 922.0 | 26613.0 |
| 2011-06-17 | FBTP | Futures | 64.95 | 65.23 | 64.82 | 65.09 | 7395.0 |
| 2011-06-17 | FCE | Futures | 2615.2 | 2669.7 | 2598.5 | 2655.1 | 183899.0 |
| 2011-06-17 | FDAX | Futures | 7589.1 | 7749.9 | 7546.3 | 7694.9 | 218687.0 |
| 2011-06-17 | FESX | Futures | 1738.2 | 1785.0 | 1731.2 | 1779.9 | 2232116.0 |
| 2011-06-17 | FEU3 | Futures | 97.795 | 97.82 | 97.795 | 97.82 | 192.0 |
| 2011-06-17 | FGBL | Futures | 101.47 | 101.53 | 101.02 | 101.13 | 1149191.0 |
| 2011-06-17 | FGBM | Futures | 105.74 | 105.77 | 105.29 | 105.39 | 817191.0 |
| 2011-06-17 | FGBS | Futures | 107.298 | 107.308 | 107.119 | 107.154 | 760211.0 |
| 2011-06-17 | FGBX | Futures | 96.58 | 96.81 | 95.94 | 96.25 | 5396.0 |
| 2011-06-17 | FTDX | Futures | 777.4 | 783.7 | 770.8 | 778.8 | 1493.0 |
| 2011-06-17 | FTI | Futures | 271.67 | 275.53 | 270.28 | 273.64 | 53952.0 |
| 2011-06-17 | FTUK | Futures | 3985.8 | 4017.9 | 3954.7 | 4007.7 | 146858.0 |
| 2011-06-17 | FXXP | Futures | 178.8 | 181.7 | 178.1 | 180.6 | 2280.0 |
| 2011-06-17 | G | Futures | 85.02 | 85.11 | 84.68 | 84.91 | 90295.0 |
| 2011-06-17 | GF | Futures | 304.447 | 309.037 | 303.634 | 308.282 | 4640.0 |
| 2011-06-17 | GSCI | Futures | 1060.82 | 1061.14 | 1047.49 | 1052.14 | 169.0 |
| 2011-06-17 | HE | Futures | 101.251 | 102.612 | 100.851 | 102.052 | 9999.0 |
| 2011-06-17 | HG | Futures | 5.479 | 5.5215 | 5.4159 | 5.4497 | 34117.0 |
| 2011-06-17 | HO | Futures | 2.4641 | 2.4641 | 2.4075 | 2.4415 | 9263.0 |
| 2011-06-17 | HRC | Futures | 3077.0 | 3077.0 | 3077.0 | 3077.0 | 0.0 |
| 2011-06-17 | J1 | Futures | 0.0155996 | 0.0157252 | 0.0155908 | 0.0157089 | 108403.0 |
| 2011-06-17 | J7 | Futures | 0.015498 | 0.015613 | 0.015489 | 0.015604 | 174.0 |
| 2011-06-17 | JB | Futures | 122.82 | 123.05 | 122.75 | 122.96 | 4234.0 |
| 2011-06-17 | KC | Futures | 619.28 | 625.75 | 597.34 | 598.42 | 4786.0 |
> showing 50 of 95 rows — these rows as CSV