PREVIEW / futures_daily / 2015-01-21
file: by_date/futures_daily/2015/2015-01-21.parquet size: 9 KB rows: 107
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-01-21 | ES | Futures | 2112.76 | 2130.58 | 2101.76 | 2124.03 | 1639269.0 |
| 2015-01-21 | NQ | Futures | 4833.77 | 4879.32 | 4800.13 | 4853.21 | 327200.0 |
| 2015-01-21 | YM | Futures | 17739.8 | 17859.0 | 17645.1 | 17814.2 | 179017.0 |
| 2015-01-21 | CL | Futures | 89.72 | 92.63 | 89.46 | 91.82 | 340252.0 |
| 2015-01-21 | GC | Futures | 1695.4 | 1710.8 | 1681.4 | 1693.3 | 210391.0 |
| 2015-01-21 | ZN | Futures | 122.425761 | 122.617143 | 121.807449 | 121.954666 | 1567621.0 |
| 2015-01-21 | A6 | Futures | 0.7967 | 0.80355 | 0.78827 | 0.78925 | 113678.0 |
| 2015-01-21 | AD | Futures | 0.8403 | 0.84325 | 0.82125 | 0.8239 | 107653.0 |
| 2015-01-21 | ALI | Futures | 2888.47 | 2888.47 | 2888.47 | 2888.47 | 5.0 |
| 2015-01-21 | B | Futures | 49.31 | 50.64 | 49.23 | 50.07 | 268649.0 |
| 2015-01-21 | B6 | Futures | 1.592 | 1.5954 | 1.5846 | 1.5895 | 102210.0 |
| 2015-01-21 | BFX | Futures | 4108.4 | 4130.7 | 4102.4 | 4130.7 | 16.0 |
| 2015-01-21 | BR | Futures | 0.21043 | 0.21115 | 0.20938 | 0.20944 | 402.0 |
| 2015-01-21 | BZ | Futures | 49.55 | 50.92 | 49.49 | 50.34 | 28618.0 |
| 2015-01-21 | C | Futures | 2202.0 | 2209.0 | 2167.0 | 2168.0 | 9308.0 |
| 2015-01-21 | CB | Futures | 131.051 | 134.111 | 131.03 | 131.03 | 5.0 |
| 2015-01-21 | CC | Futures | 2154.0 | 2156.0 | 2096.0 | 2105.0 | 26637.0 |
| 2015-01-21 | CSC | Futures | 4.273 | 4.316 | 4.273 | 4.313 | 45.0 |
| 2015-01-21 | CT | Futures | 73.82 | 74.37 | 73.66 | 74.09 | 13834.0 |
| 2015-01-21 | DC | Futures | 32.94 | 33.66 | 32.94 | 33.47 | 145.0 |
| 2015-01-21 | DX | Futures | 88.315 | 88.339 | 87.425 | 88.164 | 55506.0 |
| 2015-01-21 | E1 | Futures | 1.46514 | 1.50893 | 1.46054 | 1.49157 | 26025.0 |
| 2015-01-21 | E6 | Futures | 1.35951 | 1.37469 | 1.35822 | 1.3641 | 277265.0 |
| 2015-01-21 | E7 | Futures | 1.3518 | 1.3665 | 1.3502 | 1.356 | 6654.0 |
| 2015-01-21 | EBM | Futures | 319.55 | 322.79 | 316.3 | 320.76 | 21366.0 |
| 2015-01-21 | ED | Futures | 95.4546 | 95.4594 | 95.4498 | 95.4546 | 166089.0 |
| 2015-01-21 | ER | Futures | 98.063 | 98.068 | 98.048 | 98.058 | 105592.0 |
| 2015-01-21 | EW | Futures | 1489.3 | 1501.0 | 1480.7 | 1499.0 | 17683.0 |
| 2015-01-21 | FBTP | Futures | 100.27 | 100.35 | 99.67 | 100.08 | 129688.0 |
| 2015-01-21 | FBTS | Futures | 99.014 | 99.04 | 98.907 | 99.005 | 28467.0 |
| 2015-01-21 | FCE | Futures | 3636.8 | 3662.9 | 3594.4 | 3657.2 | 149120.0 |
| 2015-01-21 | FDAX | Futures | 11408.3 | 11456.6 | 11271.8 | 11433.3 | 147497.0 |
| 2015-01-21 | FDIV | Futures | 145.25 | 147.1 | 145.25 | 147.1 | 54.0 |
| 2015-01-21 | FESX | Futures | 2338.8 | 2358.2 | 2310.7 | 2351.7 | 1511789.0 |
| 2015-01-21 | FEU3 | Futures | 98.685 | 98.685 | 98.675 | 98.675 | 90.0 |
| 2015-01-21 | FGBL | Futures | 138.07 | 138.13 | 137.12 | 137.3 | 1052782.0 |
| 2015-01-21 | FGBM | Futures | 124.03 | 124.05 | 123.79 | 123.82 | 654388.0 |
| 2015-01-21 | FGBS | Futures | 111.063 | 111.098 | 111.058 | 111.088 | 373670.0 |
| 2015-01-21 | FGBX | Futures | 162.47 | 162.91 | 160.0 | 160.74 | 39304.0 |
| 2015-01-21 | FMWO | Futures | 5551.9 | 5580.3 | 5533.3 | 5576.6 | 1271.0 |
| 2015-01-21 | FOAT | Futures | 127.23 | 127.31 | 126.57 | 126.73 | 97599.0 |
| 2015-01-21 | FTDX | Futures | 1356.6 | 1362.3 | 1355.2 | 1359.9 | 256.0 |
| 2015-01-21 | FTI | Futures | 379.39 | 381.12 | 375.93 | 380.43 | 43502.0 |
| 2015-01-21 | FTUK | Futures | 5136.6 | 5201.7 | 5131.1 | 5191.2 | 114458.0 |
| 2015-01-21 | FVSA | Futures | 2066.07 | 2165.07 | 2040.25 | 2061.77 | 17778.0 |
| 2015-01-21 | FXXP | Futures | 269.6 | 270.1 | 266.1 | 269.5 | 11996.0 |
| 2015-01-21 | G | Futures | 105.06 | 105.74 | 104.79 | 105.5 | 243315.0 |
| 2015-01-21 | GF | Futures | 342.455 | 347.22 | 338.701 | 346.335 | 4809.0 |
| 2015-01-21 | GSCI | Futures | 661.93 | 668.14 | 661.93 | 667.1 | 331.0 |
| 2015-01-21 | HE | Futures | 100.718 | 100.952 | 98.672 | 99.577 | 13662.0 |
> showing 50 of 107 rows — these rows as CSV