PREVIEW / futures_daily / 2012-08-28
file: by_date/futures_daily/2012/2012-08-28.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-28 | ES | Futures | 1426.16 | 1429.96 | 1421.1 | 1425.66 | 1210117.0 |
| 2012-08-28 | NQ | Futures | 3194.51 | 3202.83 | 3180.45 | 3191.64 | 173035.0 |
| 2012-08-28 | YM | Futures | 12713.2 | 12743.3 | 12673.4 | 12695.7 | 90855.0 |
| 2012-08-28 | CL | Futures | 173.06 | 174.65 | 172.12 | 174.27 | 198458.0 |
| 2012-08-28 | GC | Futures | 2224.3 | 2236.2 | 2215.1 | 2229.3 | 105051.0 |
| 2012-08-28 | ZN | Futures | 116.60408 | 116.876456 | 116.549605 | 116.753887 | 1272631.0 |
| 2012-08-28 | A6 | Futures | 0.93003 | 0.93281 | 0.9285 | 0.9312 | 89356.0 |
| 2012-08-28 | AD | Futures | 1.01163 | 1.01825 | 1.01053 | 1.01424 | 82062.0 |
| 2012-08-28 | B | Futures | 102.08 | 102.6 | 101.4 | 102.29 | 99838.0 |
| 2012-08-28 | B6 | Futures | 1.65 | 1.6551 | 1.6463 | 1.6534 | 84801.0 |
| 2012-08-28 | BFX | Futures | 2822.6 | 2828.8 | 2813.7 | 2813.7 | 79.0 |
| 2012-08-28 | BR | Futures | 0.23449 | 0.23449 | 0.2341 | 0.23432 | 1115.0 |
| 2012-08-28 | BZ | Futures | 107.2 | 107.2 | 107.2 | 107.2 | 1413.0 |
| 2012-08-28 | C | Futures | 1637.0 | 1710.0 | 1624.0 | 1707.0 | 5404.0 |
| 2012-08-28 | CB | Futures | 97.118 | 97.144 | 97.118 | 97.144 | 2.0 |
| 2012-08-28 | CC | Futures | 1865.0 | 1953.0 | 1842.0 | 1937.0 | 27738.0 |
| 2012-08-28 | CT | Futures | 98.49 | 98.65 | 98.14 | 98.52 | 17.0 |
| 2012-08-28 | DC | Futures | 30.6 | 30.65 | 30.5 | 30.6 | 87.0 |
| 2012-08-28 | DX | Futures | 79.299 | 79.435 | 78.887 | 78.99 | 12832.0 |
| 2012-08-28 | E1 | Futures | 1.34384 | 1.35262 | 1.34048 | 1.3512 | 33263.0 |
| 2012-08-28 | E6 | Futures | 1.47451 | 1.48394 | 1.47061 | 1.48217 | 208471.0 |
| 2012-08-28 | E7 | Futures | 1.4652 | 1.4747 | 1.4617 | 1.473 | 3122.0 |
| 2012-08-28 | ED | Futures | 95.1823 | 95.1919 | 95.1823 | 95.1895 | 92569.0 |
| 2012-08-28 | ER | Futures | 97.866 | 97.871 | 97.847 | 97.857 | 48418.0 |
| 2012-08-28 | EW | Futures | 981.5 | 987.8 | 978.7 | 985.6 | 16955.0 |
| 2012-08-28 | FBTP | Futures | 67.05 | 67.14 | 66.4 | 66.57 | 20424.0 |
| 2012-08-28 | FBTS | Futures | 87.163 | 87.337 | 87.072 | 87.295 | 4003.0 |
| 2012-08-28 | FCE | Futures | 2564.6 | 2572.1 | 2544.9 | 2551.2 | 81148.0 |
| 2012-08-28 | FDAX | Futures | 7653.4 | 7676.9 | 7615.2 | 7646.3 | 110364.0 |
| 2012-08-28 | FESX | Futures | 1654.2 | 1662.4 | 1644.1 | 1650.9 | 757707.0 |
| 2012-08-28 | FGBL | Futures | 118.86 | 118.99 | 118.63 | 118.91 | 515214.0 |
| 2012-08-28 | FGBM | Futures | 116.52 | 116.57 | 116.35 | 116.52 | 294490.0 |
| 2012-08-28 | FGBS | Futures | 110.457 | 110.477 | 110.442 | 110.472 | 261008.0 |
| 2012-08-28 | FGBX | Futures | 127.9 | 128.2 | 127.43 | 127.99 | 3392.0 |
| 2012-08-28 | FOAT | Futures | 103.31 | 103.39 | 103.16 | 103.24 | 19349.0 |
| 2012-08-28 | FTDX | Futures | 735.2 | 737.5 | 734.7 | 736.6 | 32.0 |
| 2012-08-28 | FTI | Futures | 281.49 | 281.88 | 279.58 | 280.26 | 27554.0 |
| 2012-08-28 | FTUK | Futures | 4201.5 | 4206.2 | 4179.6 | 4194.9 | 66284.0 |
| 2012-08-28 | FVSA | Futures | 6724.92 | 6827.39 | 6712.11 | 6724.92 | 2901.0 |
| 2012-08-28 | FXXP | Futures | 192.3 | 192.5 | 191.1 | 191.7 | 3138.0 |
| 2012-08-28 | G | Futures | 99.6 | 99.83 | 99.49 | 99.79 | 290028.0 |
| 2012-08-28 | GF | Futures | 281.718 | 283.885 | 281.324 | 282.9 | 1258.0 |
| 2012-08-28 | GSCI | Futures | 1074.96 | 1077.21 | 1071.74 | 1076.65 | 79.0 |
| 2012-08-28 | HE | Futures | 90.464 | 90.928 | 90.186 | 90.526 | 10025.0 |
| 2012-08-28 | HG | Futures | 4.4657 | 4.4689 | 4.4316 | 4.458 | 23376.0 |
| 2012-08-28 | HH | Futures | 35.296 | 35.296 | 35.296 | 35.296 | 617.0 |
| 2012-08-28 | HO | Futures | 2.5279 | 2.5469 | 2.5232 | 2.5379 | 19820.0 |
| 2012-08-28 | HRC | Futures | 2471.7 | 2471.7 | 2471.7 | 2471.7 | 25.0 |
| 2012-08-28 | J1 | Futures | 0.0159143 | 0.0159757 | 0.0159118 | 0.0159619 | 53851.0 |
| 2012-08-28 | J7 | Futures | 0.015852 | 0.015912 | 0.015851 | 0.015899 | 204.0 |
> showing 50 of 98 rows — these rows as CSV