PREVIEW / futures_daily / 2012-10-17
file: by_date/futures_daily/2012/2012-10-17.parquet size: 9 KB rows: 99
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-10-17 | ES | Futures | 1475.02 | 1483.67 | 1471.97 | 1482.91 | 1534392.0 |
| 2012-10-17 | NQ | Futures | 3182.3 | 3197.26 | 3168.21 | 3187.77 | 228333.0 |
| 2012-10-17 | YM | Futures | 13131.9 | 13180.7 | 13116.2 | 13171.9 | 110838.0 |
| 2012-10-17 | CL | Futures | 166.75 | 168.1 | 165.79 | 166.87 | 158428.0 |
| 2012-10-17 | GC | Futures | 2336.5 | 2343.2 | 2328.5 | 2340.5 | 112841.0 |
| 2012-10-17 | ZN | Futures | 116.711418 | 116.75262 | 116.024719 | 116.093389 | 1228766.0 |
| 2012-10-17 | A6 | Futures | 0.93208 | 0.93953 | 0.93053 | 0.93835 | 134525.0 |
| 2012-10-17 | AD | Futures | 1.01633 | 1.02567 | 1.01543 | 1.02516 | 94272.0 |
| 2012-10-17 | B | Futures | 104.41 | 104.76 | 103.37 | 103.76 | 197956.0 |
| 2012-10-17 | B6 | Futures | 1.6823 | 1.6893 | 1.6823 | 1.6867 | 93807.0 |
| 2012-10-17 | BFX | Futures | 2877.5 | 2901.0 | 2877.5 | 2901.0 | 813.0 |
| 2012-10-17 | BR | Futures | 0.2374 | 0.23774 | 0.2374 | 0.23774 | 39.0 |
| 2012-10-17 | BZ | Futures | 108.4 | 108.66 | 107.26 | 107.67 | 454.0 |
| 2012-10-17 | C | Futures | 1565.0 | 1574.0 | 1540.0 | 1548.0 | 2801.0 |
| 2012-10-17 | CB | Futures | 93.264 | 93.398 | 93.264 | 93.344 | 16.0 |
| 2012-10-17 | CC | Futures | 1811.0 | 1831.0 | 1790.0 | 1799.0 | 8659.0 |
| 2012-10-17 | CSC | Futures | 4.099 | 4.105 | 4.099 | 4.105 | 30.0 |
| 2012-10-17 | CT | Futures | 96.26 | 100.47 | 95.88 | 100.47 | 39237.0 |
| 2012-10-17 | DC | Futures | 30.62 | 30.77 | 30.3 | 30.71 | 265.0 |
| 2012-10-17 | DX | Futures | 76.729 | 76.787 | 76.491 | 76.577 | 18829.0 |
| 2012-10-17 | E1 | Futures | 1.3959 | 1.39796 | 1.39307 | 1.39745 | 33367.0 |
| 2012-10-17 | E6 | Futures | 1.5424 | 1.54817 | 1.54145 | 1.5464 | 237578.0 |
| 2012-10-17 | E7 | Futures | 1.5328 | 1.5389 | 1.5322 | 1.5371 | 3688.0 |
| 2012-10-17 | ED | Futures | 95.2635 | 95.2635 | 95.2492 | 95.2587 | 139531.0 |
| 2012-10-17 | ER | Futures | 97.857 | 97.866 | 97.852 | 97.857 | 91555.0 |
| 2012-10-17 | EW | Futures | 1010.9 | 1021.6 | 1009.4 | 1020.8 | 19650.0 |
| 2012-10-17 | FBTP | Futures | 72.42 | 73.29 | 72.42 | 73.21 | 20930.0 |
| 2012-10-17 | FBTS | Futures | 89.776 | 90.027 | 89.776 | 90.002 | 3404.0 |
| 2012-10-17 | FCE | Futures | 2640.3 | 2652.7 | 2625.3 | 2648.6 | 171042.0 |
| 2012-10-17 | FDAX | Futures | 8096.1 | 8112.0 | 8073.7 | 8105.4 | 111234.0 |
| 2012-10-17 | FESX | Futures | 1734.8 | 1749.1 | 1731.4 | 1747.8 | 1112278.0 |
| 2012-10-17 | FGBL | Futures | 117.47 | 117.5 | 116.65 | 116.8 | 865307.0 |
| 2012-10-17 | FGBM | Futures | 115.91 | 115.95 | 115.53 | 115.64 | 477332.0 |
| 2012-10-17 | FGBS | Futures | 110.258 | 110.278 | 110.208 | 110.223 | 433697.0 |
| 2012-10-17 | FGBX | Futures | 123.52 | 123.52 | 121.76 | 121.83 | 4691.0 |
| 2012-10-17 | FOAT | Futures | 103.68 | 103.8 | 103.41 | 103.46 | 19157.0 |
| 2012-10-17 | FTDX | Futures | 778.2 | 778.7 | 777.3 | 778.2 | 49.0 |
| 2012-10-17 | FTI | Futures | 285.35 | 287.46 | 284.88 | 287.2 | 33114.0 |
| 2012-10-17 | FTUK | Futures | 4288.1 | 4314.9 | 4275.0 | 4305.0 | 90302.0 |
| 2012-10-17 | FVSA | Futures | 5104.88 | 5172.64 | 5048.41 | 5048.41 | 4282.0 |
| 2012-10-17 | FXXP | Futures | 197.4 | 198.6 | 197.3 | 198.5 | 1070.0 |
| 2012-10-17 | G | Futures | 98.34 | 98.5 | 97.78 | 97.89 | 192261.0 |
| 2012-10-17 | GF | Futures | 283.091 | 287.556 | 283.091 | 286.644 | 4970.0 |
| 2012-10-17 | GSCI | Futures | 1076.54 | 1077.59 | 1070.72 | 1075.33 | 29.0 |
| 2012-10-17 | HE | Futures | 97.605 | 98.724 | 97.326 | 98.413 | 18424.0 |
| 2012-10-17 | HG | Futures | 4.7677 | 4.8255 | 4.74 | 4.8165 | 48537.0 |
| 2012-10-17 | HH | Futures | 44.247 | 44.247 | 44.247 | 44.247 | 2267.0 |
| 2012-10-17 | HO | Futures | 2.5687 | 2.5812 | 2.5595 | 2.575 | 40660.0 |
| 2012-10-17 | HRC | Futures | 2418.5 | 2426.7 | 2418.5 | 2418.5 | 13.0 |
| 2012-10-17 | J1 | Futures | 0.0158831 | 0.0159344 | 0.0158455 | 0.0158605 | 86804.0 |
> showing 50 of 99 rows — these rows as CSV