PREVIEW / futures_daily / 2011-04-19
file: by_date/futures_daily/2011/2011-04-19.parquet size: 9 KB rows: 94
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-04-19 | ES | Futures | 1288.0 | 1296.42 | 1281.07 | 1295.43 | 1528995.0 |
| 2011-04-19 | NQ | Futures | 2606.91 | 2639.37 | 2594.1 | 2631.97 | 226895.0 |
| 2011-04-19 | YM | Futures | 11413.7 | 11508.7 | 11366.7 | 11494.6 | 94611.0 |
| 2011-04-19 | CL | Futures | 208.24 | 210.24 | 204.29 | 208.66 | 324778.0 |
| 2011-04-19 | GC | Futures | 2025.7 | 2030.9 | 2014.3 | 2023.6 | 131690.0 |
| 2011-04-19 | ZN | Futures | 101.22411 | 101.434801 | 101.013418 | 101.342624 | 923723.0 |
| 2011-04-19 | A6 | Futures | 0.89447 | 0.89722 | 0.88941 | 0.89593 | 85586.0 |
| 2011-04-19 | AD | Futures | 1.03107 | 1.04143 | 1.02878 | 1.03924 | 82977.0 |
| 2011-04-19 | B | Futures | 103.29 | 103.73 | 100.97 | 102.92 | 218996.0 |
| 2011-04-19 | B6 | Futures | 1.6891 | 1.6969 | 1.685 | 1.6938 | 107014.0 |
| 2011-04-19 | BFX | Futures | 3107.4 | 3125.2 | 3097.5 | 3119.3 | 82.0 |
| 2011-04-19 | BR | Futures | 0.2763 | 0.27806 | 0.27621 | 0.27801 | 107.0 |
| 2011-04-19 | BZ | Futures | 108.43 | 109.31 | 106.55 | 108.51 | 915.0 |
| 2011-04-19 | C | Futures | 2115.0 | 2138.0 | 2110.0 | 2125.0 | 1074.0 |
| 2011-04-19 | CB | Futures | 118.509 | 118.802 | 118.509 | 118.802 | 27.0 |
| 2011-04-19 | CC | Futures | 2415.0 | 2457.0 | 2404.0 | 2442.0 | 6070.0 |
| 2011-04-19 | CSC | Futures | 4.425 | 4.425 | 4.425 | 4.425 | 2.0 |
| 2011-04-19 | CT | Futures | 175.67 | 176.04 | 169.55 | 169.74 | 8939.0 |
| 2011-04-19 | DC | Futures | 29.26 | 29.57 | 28.96 | 29.29 | 292.0 |
| 2011-04-19 | DX | Futures | 75.307 | 75.466 | 74.83 | 74.873 | 21973.0 |
| 2011-04-19 | E1 | Futures | 1.46155 | 1.46416 | 1.45408 | 1.45657 | 37392.0 |
| 2011-04-19 | E6 | Futures | 1.68364 | 1.69785 | 1.68032 | 1.69631 | 258471.0 |
| 2011-04-19 | E7 | Futures | 1.6706 | 1.6851 | 1.6678 | 1.6837 | 3980.0 |
| 2011-04-19 | EBM | Futures | 232.97 | 236.96 | 232.97 | 236.02 | 8739.0 |
| 2011-04-19 | ED | Futures | 94.9264 | 94.9264 | 94.9168 | 94.9216 | 136696.0 |
| 2011-04-19 | ER | Futures | 97.262 | 97.262 | 97.227 | 97.237 | 81162.0 |
| 2011-04-19 | EW | Futures | 961.3 | 965.1 | 955.8 | 963.9 | 19974.0 |
| 2011-04-19 | FBTP | Futures | 64.15 | 64.45 | 64.12 | 64.37 | 7171.0 |
| 2011-04-19 | FCE | Futures | 2596.9 | 2628.6 | 2596.9 | 2614.6 | 113005.0 |
| 2011-04-19 | FDAX | Futures | 7529.3 | 7579.5 | 7521.3 | 7527.1 | 106707.0 |
| 2011-04-19 | FESX | Futures | 1779.3 | 1795.3 | 1779.3 | 1781.8 | 920110.0 |
| 2011-04-19 | FEU3 | Futures | 97.79 | 97.79 | 97.775 | 97.78 | 157.0 |
| 2011-04-19 | FGBL | Futures | 98.14 | 98.14 | 97.5 | 97.76 | 1031444.0 |
| 2011-04-19 | FGBM | Futures | 103.26 | 103.31 | 102.77 | 102.94 | 574118.0 |
| 2011-04-19 | FGBS | Futures | 106.459 | 106.469 | 106.251 | 106.31 | 649770.0 |
| 2011-04-19 | FGBX | Futures | 94.52 | 94.52 | 93.22 | 93.75 | 3749.0 |
| 2011-04-19 | FTDX | Futures | 804.7 | 814.1 | 802.0 | 802.9 | 268.0 |
| 2011-04-19 | FTI | Futures | 287.36 | 288.76 | 286.91 | 287.4 | 23491.0 |
| 2011-04-19 | FTUK | Futures | 4095.9 | 4118.6 | 4083.6 | 4096.9 | 70729.0 |
| 2011-04-19 | FXXP | Futures | 181.7 | 181.8 | 180.9 | 180.9 | 769.0 |
| 2011-04-19 | G | Futures | 82.1 | 82.16 | 81.93 | 82.09 | 117619.0 |
| 2011-04-19 | GF | Futures | 321.106 | 324.354 | 320.925 | 323.632 | 1552.0 |
| 2011-04-19 | GSCI | Futures | 1141.27 | 1155.09 | 1133.61 | 1148.14 | 186.0 |
| 2011-04-19 | HE | Futures | 108.912 | 109.735 | 108.301 | 109.47 | 529.0 |
| 2011-04-19 | HG | Futures | 5.6317 | 5.6862 | 5.5819 | 5.6444 | 13028.0 |
| 2011-04-19 | HO | Futures | 2.6625 | 2.6625 | 2.6029 | 2.6361 | 51114.0 |
| 2011-04-19 | HRC | Futures | 3000.1 | 3000.1 | 3000.1 | 3000.1 | 0.0 |
| 2011-04-19 | J1 | Futures | 0.0152277 | 0.0152641 | 0.0151837 | 0.0152503 | 107862.0 |
| 2011-04-19 | J7 | Futures | 0.015134 | 0.015167 | 0.015092 | 0.015157 | 636.0 |
| 2011-04-19 | JB | Futures | 121.48 | 121.57 | 121.4 | 121.43 | 63.0 |
> showing 50 of 94 rows — these rows as CSV