PREVIEW / futures_daily / 2012-08-30
file: by_date/futures_daily/2012/2012-08-30.parquet size: 9 KB rows: 98
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-08-30 | ES | Futures | 1424.9 | 1425.66 | 1413.0 | 1414.77 | 1217187.0 |
| 2012-08-30 | NQ | Futures | 3192.22 | 3193.65 | 3156.64 | 3160.65 | 165170.0 |
| 2012-08-30 | YM | Futures | 12691.8 | 12697.7 | 12579.3 | 12594.8 | 103447.0 |
| 2012-08-30 | CL | Futures | 172.41 | 172.95 | 169.96 | 171.18 | 192455.0 |
| 2012-08-30 | GC | Futures | 2214.6 | 2225.3 | 2206.0 | 2212.5 | 96786.0 |
| 2012-08-30 | ZN | Futures | 116.685793 | 117.026263 | 116.617699 | 116.958169 | 1069979.0 |
| 2012-08-30 | A6 | Futures | 0.92895 | 0.92913 | 0.92274 | 0.92481 | 112025.0 |
| 2012-08-30 | AD | Futures | 1.01323 | 1.01333 | 1.00902 | 1.00972 | 74420.0 |
| 2012-08-30 | B | Futures | 102.12 | 102.98 | 101.96 | 102.32 | 83037.0 |
| 2012-08-30 | B6 | Futures | 1.6544 | 1.659 | 1.6481 | 1.6498 | 77994.0 |
| 2012-08-30 | BR | Futures | 0.23342 | 0.2341 | 0.23342 | 0.2341 | 108.0 |
| 2012-08-30 | BZ | Futures | 107.23 | 107.23 | 107.23 | 107.23 | 3194.0 |
| 2012-08-30 | C | Futures | 1715.0 | 1719.0 | 1695.0 | 1717.0 | 1639.0 |
| 2012-08-30 | CC | Futures | 1941.0 | 1976.0 | 1935.0 | 1962.0 | 14489.0 |
| 2012-08-30 | CSC | Futures | 4.149 | 4.149 | 4.128 | 4.128 | 35.0 |
| 2012-08-30 | CT | Futures | 99.6 | 100.75 | 99.18 | 100.31 | 25.0 |
| 2012-08-30 | DC | Futures | 31.17 | 31.23 | 30.68 | 30.85 | 106.0 |
| 2012-08-30 | DX | Futures | 79.173 | 79.377 | 79.018 | 79.312 | 12379.0 |
| 2012-08-30 | E1 | Futures | 1.34771 | 1.35107 | 1.3428 | 1.345 | 30695.0 |
| 2012-08-30 | E6 | Futures | 1.4784 | 1.48229 | 1.47309 | 1.47557 | 183075.0 |
| 2012-08-30 | E7 | Futures | 1.4693 | 1.4731 | 1.4639 | 1.4664 | 2980.0 |
| 2012-08-30 | ED | Futures | 95.1871 | 95.1895 | 95.1847 | 95.1895 | 88330.0 |
| 2012-08-30 | ER | Futures | 97.852 | 97.866 | 97.847 | 97.862 | 81018.0 |
| 2012-08-30 | EW | Futures | 985.0 | 985.0 | 974.5 | 978.5 | 14368.0 |
| 2012-08-30 | FBTP | Futures | 66.77 | 66.98 | 66.48 | 66.73 | 28550.0 |
| 2012-08-30 | FBTS | Futures | 87.378 | 87.485 | 87.213 | 87.378 | 4629.0 |
| 2012-08-30 | FCE | Futures | 2528.5 | 2540.4 | 2508.7 | 2516.6 | 67364.0 |
| 2012-08-30 | FDAX | Futures | 7609.7 | 7622.3 | 7501.1 | 7541.5 | 105435.0 |
| 2012-08-30 | FESX | Futures | 1636.7 | 1644.8 | 1620.4 | 1627.9 | 681615.0 |
| 2012-08-30 | FGBL | Futures | 118.68 | 119.15 | 118.63 | 119.06 | 505821.0 |
| 2012-08-30 | FGBM | Futures | 116.4 | 116.72 | 116.38 | 116.69 | 261691.0 |
| 2012-08-30 | FGBS | Futures | 110.447 | 110.532 | 110.447 | 110.532 | 334221.0 |
| 2012-08-30 | FGBX | Futures | 127.6 | 128.8 | 127.6 | 128.56 | 14596.0 |
| 2012-08-30 | FOAT | Futures | 102.88 | 102.99 | 102.69 | 102.77 | 25855.0 |
| 2012-08-30 | FTDX | Futures | 738.0 | 739.8 | 733.3 | 736.6 | 52.0 |
| 2012-08-30 | FTI | Futures | 280.13 | 280.9 | 278.22 | 278.94 | 21424.0 |
| 2012-08-30 | FTUK | Futures | 4175.6 | 4179.6 | 4148.7 | 4164.7 | 57245.0 |
| 2012-08-30 | FVSA | Futures | 6840.2 | 7032.34 | 6801.78 | 6968.3 | 9784.0 |
| 2012-08-30 | FXXP | Futures | 190.7 | 191.0 | 189.5 | 190.2 | 1326.0 |
| 2012-08-30 | G | Futures | 99.81 | 100.13 | 99.71 | 100.04 | 129371.0 |
| 2012-08-30 | GF | Futures | 283.638 | 284.131 | 281.915 | 282.309 | 1199.0 |
| 2012-08-30 | GSCI | Futures | 1079.06 | 1079.7 | 1070.61 | 1074.63 | 52.0 |
| 2012-08-30 | HE | Futures | 91.206 | 92.04 | 90.835 | 91.638 | 14020.0 |
| 2012-08-30 | HG | Futures | 4.4233 | 4.4914 | 4.4111 | 4.4297 | 45379.0 |
| 2012-08-30 | HH | Futures | 36.838 | 36.838 | 36.838 | 36.838 | 200.0 |
| 2012-08-30 | HO | Futures | 2.5319 | 2.5494 | 2.5295 | 2.5392 | 23089.0 |
| 2012-08-30 | HRC | Futures | 2471.7 | 2471.7 | 2471.7 | 2471.7 | 0.0 |
| 2012-08-30 | J1 | Futures | 0.0159318 | 0.0159669 | 0.0159155 | 0.0159381 | 49943.0 |
| 2012-08-30 | J7 | Futures | 0.015856 | 0.015903 | 0.015856 | 0.015876 | 147.0 |
| 2012-08-30 | JB | Futures | 126.28 | 126.34 | 126.21 | 126.21 | 1812.0 |
> showing 50 of 98 rows — these rows as CSV