PREVIEW / futures_30min / 2013-06-09
file: by_date/futures_30min/2013/2013-06-09.parquet size: 20 KB rows: 482
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2013-06-09 18:00:00 | ES | Futures | 1686.15 | 1687.43 | 1684.09 | 1685.37 | 8124.0 |
| 2013-06-09 18:30:00 | ES | Futures | 1685.12 | 1686.15 | 1685.12 | 1685.63 | 2127.0 |
| 2013-06-09 19:00:00 | ES | Futures | 1685.63 | 1686.66 | 1685.37 | 1686.15 | 1248.0 |
| 2013-06-09 19:30:00 | ES | Futures | 1686.15 | 1688.21 | 1685.89 | 1687.69 | 2986.0 |
| 2013-06-09 20:00:00 | ES | Futures | 1687.69 | 1689.24 | 1687.18 | 1688.98 | 4462.0 |
| 2013-06-09 20:30:00 | ES | Futures | 1688.72 | 1689.24 | 1687.69 | 1687.69 | 2701.0 |
| 2013-06-09 21:00:00 | ES | Futures | 1687.95 | 1690.27 | 1687.43 | 1690.01 | 3935.0 |
| 2013-06-09 21:30:00 | ES | Futures | 1690.01 | 1690.53 | 1689.5 | 1690.01 | 2801.0 |
| 2013-06-09 22:00:00 | ES | Futures | 1690.27 | 1691.3 | 1689.75 | 1690.53 | 2897.0 |
| 2013-06-09 22:30:00 | ES | Futures | 1690.53 | 1690.78 | 1689.24 | 1689.75 | 1586.0 |
| 2013-06-09 23:00:00 | ES | Futures | 1689.5 | 1691.04 | 1689.5 | 1691.04 | 1419.0 |
| 2013-06-09 23:30:00 | ES | Futures | 1691.04 | 1691.3 | 1689.75 | 1690.53 | 1153.0 |
| 2013-06-09 18:00:00 | NQ | Futures | 3477.85 | 3477.85 | 3472.31 | 3475.22 | 580.0 |
| 2013-06-09 18:30:00 | NQ | Futures | 3474.93 | 3476.68 | 3474.64 | 3475.81 | 224.0 |
| 2013-06-09 19:00:00 | NQ | Futures | 3475.81 | 3477.56 | 3475.81 | 3476.39 | 199.0 |
| 2013-06-09 19:30:00 | NQ | Futures | 3476.68 | 3479.6 | 3476.1 | 3479.02 | 325.0 |
| 2013-06-09 20:00:00 | NQ | Futures | 3479.02 | 3481.35 | 3478.14 | 3480.47 | 422.0 |
| 2013-06-09 20:30:00 | NQ | Futures | 3480.47 | 3481.06 | 3479.89 | 3479.89 | 290.0 |
| 2013-06-09 21:00:00 | NQ | Futures | 3479.89 | 3483.97 | 3479.31 | 3483.68 | 708.0 |
| 2013-06-09 21:30:00 | NQ | Futures | 3483.97 | 3484.85 | 3483.1 | 3484.56 | 263.0 |
| 2013-06-09 22:00:00 | NQ | Futures | 3484.85 | 3487.47 | 3484.27 | 3487.18 | 603.0 |
| 2013-06-09 22:30:00 | NQ | Futures | 3486.89 | 3487.18 | 3484.27 | 3484.85 | 189.0 |
| 2013-06-09 23:00:00 | NQ | Futures | 3484.85 | 3486.89 | 3484.85 | 3486.6 | 211.0 |
| 2013-06-09 23:30:00 | NQ | Futures | 3486.6 | 3486.89 | 3484.27 | 3484.85 | 193.0 |
| 2013-06-09 18:00:00 | YM | Futures | 15360.3 | 15361.3 | 15344.1 | 15354.2 | 527.0 |
| 2013-06-09 18:30:00 | YM | Futures | 15354.2 | 15364.3 | 15354.2 | 15360.3 | 246.0 |
| 2013-06-09 19:00:00 | YM | Futures | 15359.3 | 15366.4 | 15359.3 | 15362.3 | 227.0 |
| 2013-06-09 19:30:00 | YM | Futures | 15362.3 | 15375.5 | 15360.3 | 15373.4 | 379.0 |
| 2013-06-09 20:00:00 | YM | Futures | 15373.4 | 15383.6 | 15369.4 | 15381.5 | 556.0 |
| 2013-06-09 20:30:00 | YM | Futures | 15381.5 | 15383.6 | 15373.4 | 15373.4 | 251.0 |
| 2013-06-09 21:00:00 | YM | Futures | 15374.5 | 15390.6 | 15370.4 | 15388.6 | 454.0 |
| 2013-06-09 21:30:00 | YM | Futures | 15389.6 | 15393.7 | 15385.6 | 15389.6 | 315.0 |
| 2013-06-09 22:00:00 | YM | Futures | 15389.6 | 15399.7 | 15386.6 | 15395.7 | 373.0 |
| 2013-06-09 22:30:00 | YM | Futures | 15395.7 | 15395.7 | 15386.6 | 15389.6 | 330.0 |
| 2013-06-09 23:00:00 | YM | Futures | 15389.6 | 15398.7 | 15389.6 | 15396.7 | 196.0 |
| 2013-06-09 23:30:00 | YM | Futures | 15397.7 | 15400.7 | 15390.6 | 15392.6 | 173.0 |
| 2013-06-09 18:00:00 | CL | Futures | 150.55 | 150.75 | 150.47 | 150.63 | 650.0 |
| 2013-06-09 18:30:00 | CL | Futures | 150.64 | 150.75 | 150.64 | 150.71 | 123.0 |
| 2013-06-09 19:00:00 | CL | Futures | 150.72 | 150.8 | 150.69 | 150.74 | 167.0 |
| 2013-06-09 19:30:00 | CL | Futures | 150.74 | 150.77 | 150.72 | 150.77 | 114.0 |
| 2013-06-09 20:00:00 | CL | Futures | 150.74 | 150.77 | 150.66 | 150.66 | 293.0 |
| 2013-06-09 20:30:00 | CL | Futures | 150.69 | 150.71 | 150.46 | 150.53 | 571.0 |
| 2013-06-09 21:00:00 | CL | Futures | 150.53 | 150.66 | 150.52 | 150.6 | 461.0 |
| 2013-06-09 21:30:00 | CL | Futures | 150.6 | 150.67 | 150.57 | 150.64 | 259.0 |
| 2013-06-09 22:00:00 | CL | Futures | 150.63 | 150.64 | 150.58 | 150.64 | 189.0 |
| 2013-06-09 22:30:00 | CL | Futures | 150.64 | 150.75 | 150.64 | 150.71 | 383.0 |
| 2013-06-09 23:00:00 | CL | Futures | 150.72 | 150.75 | 150.63 | 150.64 | 180.0 |
| 2013-06-09 23:30:00 | CL | Futures | 150.64 | 150.69 | 150.6 | 150.61 | 113.0 |
| 2013-06-09 18:00:00 | GC | Futures | 1896.8 | 1897.9 | 1889.1 | 1896.4 | 2031.0 |
| 2013-06-09 18:30:00 | GC | Futures | 1896.2 | 1896.8 | 1893.3 | 1895.1 | 928.0 |
> showing 50 of 482 rows — these rows as CSV