PREVIEW / futures_daily / 2015-10-30
file: by_date/futures_daily/2015/2015-10-30.parquet size: 9 KB rows: 109
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 |
|---|---|---|---|---|---|---|---|
| 2015-10-30 | ES | Futures | 2217.66 | 2228.29 | 2201.7 | 2205.96 | 1751269.0 |
| 2015-10-30 | NQ | Futures | 5455.53 | 5483.88 | 5420.45 | 5428.93 | 211241.0 |
| 2015-10-30 | YM | Futures | 18252.1 | 18333.7 | 18120.1 | 18153.1 | 121465.0 |
| 2015-10-30 | CL | Futures | 72.63 | 74.67 | 72.21 | 73.98 | 363307.0 |
| 2015-10-30 | GC | Futures | 1480.1 | 1484.3 | 1469.5 | 1473.4 | 123166.0 |
| 2015-10-30 | ZN | Futures | 122.254659 | 122.449237 | 122.090016 | 122.314529 | 1471261.0 |
| 2015-10-30 | A6 | Futures | 0.70643 | 0.71353 | 0.70643 | 0.71183 | 84246.0 |
| 2015-10-30 | AD | Futures | 0.77742 | 0.78428 | 0.77609 | 0.78305 | 68905.0 |
| 2015-10-30 | ALI | Futures | 2032.57 | 2032.57 | 2032.57 | 2032.57 | 0.0 |
| 2015-10-30 | B | Futures | 43.56 | 44.77 | 43.28 | 44.38 | 120394.0 |
| 2015-10-30 | B6 | Futures | 1.612 | 1.6287 | 1.6118 | 1.6241 | 108341.0 |
| 2015-10-30 | BFX | Futures | 4370.5 | 4383.9 | 4343.8 | 4370.5 | 14.0 |
| 2015-10-30 | BR | Futures | 0.15795 | 0.15927 | 0.15678 | 0.15758 | 496.0 |
| 2015-10-30 | BZ | Futures | 43.32 | 44.49 | 43.03 | 44.1 | 15224.0 |
| 2015-10-30 | C | Futures | 2341.0 | 2362.0 | 2338.0 | 2354.0 | 4123.0 |
| 2015-10-30 | CB | Futures | 206.664 | 212.544 | 206.664 | 209.641 | 24.0 |
| 2015-10-30 | CC | Futures | 2357.0 | 2392.0 | 2357.0 | 2390.0 | 19472.0 |
| 2015-10-30 | CNH | Futures | 7.077 | 7.077 | 7.0401 | 7.0501 | 22.0 |
| 2015-10-30 | CSC | Futures | 4.253 | 4.255 | 4.222 | 4.227 | 79.0 |
| 2015-10-30 | CT | Futures | 74.81 | 76.1 | 74.81 | 75.96 | 14928.0 |
| 2015-10-30 | DC | Futures | 34.01 | 34.19 | 33.88 | 34.08 | 193.0 |
| 2015-10-30 | DX | Futures | 91.001 | 91.136 | 90.393 | 90.738 | 41184.0 |
| 2015-10-30 | E1 | Futures | 1.28442 | 1.28988 | 1.2815 | 1.28506 | 22721.0 |
| 2015-10-30 | E6 | Futures | 1.28764 | 1.29783 | 1.2853 | 1.28963 | 279028.0 |
| 2015-10-30 | E7 | Futures | 1.2811 | 1.2907 | 1.2786 | 1.2825 | 5281.0 |
| 2015-10-30 | EBM | Futures | 264.53 | 265.99 | 263.44 | 264.17 | 15134.0 |
| 2015-10-30 | ED | Futures | 95.7159 | 95.7256 | 95.7111 | 95.7208 | 176193.0 |
| 2015-10-30 | ER | Futures | 98.195 | 98.205 | 98.195 | 98.195 | 60658.0 |
| 2015-10-30 | EW | Futures | 1521.8 | 1528.5 | 1516.6 | 1520.4 | 18110.0 |
| 2015-10-30 | FBON | Futures | 115.99 | 116.3 | 115.5 | 115.67 | 850.0 |
| 2015-10-30 | FBTP | Futures | 104.72 | 105.02 | 104.42 | 104.57 | 98701.0 |
| 2015-10-30 | FBTS | Futures | 100.552 | 100.606 | 100.543 | 100.579 | 16142.0 |
| 2015-10-30 | FCE | Futures | 4086.7 | 4094.2 | 4056.2 | 4082.9 | 65814.0 |
| 2015-10-30 | FDAX | Futures | 11944.9 | 11982.9 | 11835.8 | 11916.2 | 75105.0 |
| 2015-10-30 | FDXM | Futures | 11162.6 | 11190.4 | 11058.7 | 11129.7 | 5131.0 |
| 2015-10-30 | FESX | Futures | 2563.2 | 2566.2 | 2537.7 | 2550.4 | 875975.0 |
| 2015-10-30 | FEU3 | Futures | 98.843 | 98.848 | 98.843 | 98.848 | 1.0 |
| 2015-10-30 | FGBL | Futures | 139.89 | 140.2 | 139.67 | 139.89 | 637663.0 |
| 2015-10-30 | FGBM | Futures | 125.64 | 125.75 | 125.53 | 125.6 | 381204.0 |
| 2015-10-30 | FGBS | Futures | 111.443 | 111.458 | 111.413 | 111.423 | 231583.0 |
| 2015-10-30 | FGBX | Futures | 160.73 | 161.5 | 160.12 | 160.69 | 31006.0 |
| 2015-10-30 | FMWO | Futures | 5717.6 | 5720.1 | 5701.5 | 5702.8 | 446.0 |
| 2015-10-30 | FOAT | Futures | 128.54 | 128.78 | 128.2 | 128.43 | 95420.0 |
| 2015-10-30 | FTDX | Futures | 1708.8 | 1710.2 | 1692.7 | 1701.2 | 118.0 |
| 2015-10-30 | FTI | Futures | 403.81 | 404.55 | 398.45 | 402.06 | 27079.0 |
| 2015-10-30 | FTUK | Futures | 5131.3 | 5142.6 | 5077.1 | 5081.9 | 89602.0 |
| 2015-10-30 | FVSA | Futures | 2012.67 | 2049.43 | 1985.1 | 2012.67 | 5674.0 |
| 2015-10-30 | FXXP | Futures | 293.5 | 293.5 | 290.4 | 291.7 | 11672.0 |
| 2015-10-30 | G | Futures | 104.18 | 104.35 | 103.95 | 104.14 | 191671.0 |
| 2015-10-30 | GF | Futures | 346.736 | 347.142 | 343.574 | 344.929 | 2392.0 |
> showing 50 of 109 rows — these rows as CSV