PREVIEW / futures_daily / 2012-12-07
file: by_date/futures_daily/2012/2012-12-07.parquet size: 9 KB rows: 101
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 |
|---|---|---|---|---|---|---|---|
| 2012-12-07 | ES | Futures | 1437.37 | 1447.54 | 1433.55 | 1441.18 | 1772166.0 |
| 2012-12-07 | NQ | Futures | 3054.87 | 3075.87 | 3025.53 | 3033.01 | 276669.0 |
| 2012-12-07 | YM | Futures | 12762.7 | 12844.8 | 12730.5 | 12834.0 | 141385.0 |
| 2012-12-07 | CL | Futures | 154.69 | 155.63 | 153.58 | 153.86 | 244993.0 |
| 2012-12-07 | GC | Futures | 2267.2 | 2274.7 | 2244.3 | 2272.8 | 145925.0 |
| 2012-12-07 | ZN | Futures | 118.084817 | 118.620442 | 117.768935 | 117.837605 | 36187.0 |
| 2012-12-07 | A6 | Futures | 0.95098 | 0.95325 | 0.94989 | 0.95243 | 88332.0 |
| 2012-12-07 | AD | Futures | 1.01212 | 1.01613 | 1.01011 | 1.01382 | 94406.0 |
| 2012-12-07 | B | Futures | 98.98 | 99.81 | 98.66 | 99.0 | 141477.0 |
| 2012-12-07 | B6 | Futures | 1.6755 | 1.6774 | 1.6713 | 1.6747 | 123008.0 |
| 2012-12-07 | BFX | Futures | 2915.5 | 2930.1 | 2914.2 | 2928.0 | 14.0 |
| 2012-12-07 | BR | Futures | 0.23358 | 0.23358 | 0.23201 | 0.23245 | 237.0 |
| 2012-12-07 | BZ | Futures | 102.25 | 102.5 | 101.84 | 101.99 | 293.0 |
| 2012-12-07 | C | Futures | 1645.0 | 1652.0 | 1629.0 | 1643.0 | 6423.0 |
| 2012-12-07 | CB | Futures | 87.834 | 87.834 | 87.834 | 87.834 | 8.0 |
| 2012-12-07 | CC | Futures | 1826.0 | 1835.0 | 1801.0 | 1820.0 | 10234.0 |
| 2012-12-07 | CSC | Futures | 3.909 | 3.92 | 3.897 | 3.909 | 30.0 |
| 2012-12-07 | CT | Futures | 92.55 | 93.03 | 92.0 | 92.87 | 7916.0 |
| 2012-12-07 | DC | Futures | 28.94 | 28.97 | 28.8 | 28.93 | 93.0 |
| 2012-12-07 | DX | Futures | 77.75 | 78.433 | 77.707 | 77.878 | 32250.0 |
| 2012-12-07 | E1 | Futures | 1.37969 | 1.3811 | 1.37183 | 1.37737 | 30583.0 |
| 2012-12-07 | E6 | Futures | 1.52614 | 1.52779 | 1.51637 | 1.52238 | 270296.0 |
| 2012-12-07 | E7 | Futures | 1.5172 | 1.5185 | 1.5073 | 1.5133 | 3940.0 |
| 2012-12-07 | EBM | Futures | 297.59 | 299.81 | 297.03 | 298.7 | 12573.0 |
| 2012-12-07 | ED | Futures | 95.2349 | 95.2372 | 95.2325 | 95.2349 | 67604.0 |
| 2012-12-07 | ER | Futures | 97.881 | 97.901 | 97.876 | 97.891 | 105777.0 |
| 2012-12-07 | EW | Futures | 1020.6 | 1027.0 | 1017.6 | 1020.8 | 16610.0 |
| 2012-12-07 | FBTP | Futures | 74.78 | 75.03 | 74.25 | 74.89 | 26573.0 |
| 2012-12-07 | FBTS | Futures | 90.553 | 90.697 | 90.239 | 90.595 | 5815.0 |
| 2012-12-07 | FCE | Futures | 2721.7 | 2729.3 | 2703.2 | 2715.3 | 91368.0 |
| 2012-12-07 | FDAX | Futures | 8267.6 | 8276.9 | 8202.9 | 8226.5 | 125653.0 |
| 2012-12-07 | FESX | Futures | 1778.4 | 1780.4 | 1762.1 | 1768.2 | 956713.0 |
| 2012-12-07 | FGBL | Futures | 120.34 | 120.58 | 120.2 | 120.44 | 619919.0 |
| 2012-12-07 | FGBM | Futures | 117.51 | 117.68 | 117.5 | 117.61 | 390989.0 |
| 2012-12-07 | FGBS | Futures | 110.592 | 110.677 | 110.577 | 110.662 | 405537.0 |
| 2012-12-07 | FGBX | Futures | 127.29 | 127.66 | 126.46 | 126.98 | 9266.0 |
| 2012-12-07 | FOAT | Futures | 106.11 | 106.4 | 106.0 | 106.34 | 28709.0 |
| 2012-12-07 | FTDX | Futures | 790.0 | 791.4 | 783.4 | 786.2 | 91.0 |
| 2012-12-07 | FTI | Futures | 293.07 | 294.79 | 292.56 | 293.71 | 36379.0 |
| 2012-12-07 | FTUK | Futures | 4331.3 | 4339.4 | 4310.1 | 4326.9 | 73198.0 |
| 2012-12-07 | FVSA | Futures | 4047.44 | 4150.92 | 4024.44 | 4127.92 | 25150.0 |
| 2012-12-07 | FXXP | Futures | 201.8 | 202.0 | 200.8 | 201.4 | 2457.0 |
| 2012-12-07 | G | Futures | 99.42 | 99.55 | 99.19 | 99.48 | 158871.0 |
| 2012-12-07 | GF | Futures | 281.168 | 282.734 | 280.551 | 282.307 | 3478.0 |
| 2012-12-07 | GSCI | Futures | 1026.17 | 1027.95 | 1016.65 | 1021.33 | 1386.0 |
| 2012-12-07 | HE | Futures | 96.658 | 96.859 | 95.482 | 95.798 | 23656.0 |
| 2012-12-07 | HG | Futures | 4.6852 | 4.7244 | 4.675 | 4.7039 | 40143.0 |
| 2012-12-07 | HH | Futures | 41.69 | 41.69 | 41.69 | 41.69 | 1562.0 |
| 2012-12-07 | HO | Futures | 2.3785 | 2.3858 | 2.3547 | 2.3574 | 20073.0 |
| 2012-12-07 | HRC | Futures | 2458.3 | 2458.3 | 2458.3 | 2458.3 | 0.0 |
> showing 50 of 101 rows — these rows as CSV