PREVIEW / futures_30min / 2014-07-08
file: by_date/futures_30min/2014/2014-07-08.parquet size: 72 KB rows: 2,815
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 |
|---|---|---|---|---|---|---|---|
| 2014-07-08 00:00:00 | ES | Futures | 2052.86 | 2053.12 | 2052.6 | 2053.12 | 410.0 |
| 2014-07-08 00:30:00 | ES | Futures | 2053.12 | 2053.12 | 2052.6 | 2052.6 | 253.0 |
| 2014-07-08 01:00:00 | ES | Futures | 2052.86 | 2052.86 | 2052.07 | 2052.34 | 381.0 |
| 2014-07-08 01:30:00 | ES | Futures | 2052.07 | 2053.64 | 2052.07 | 2052.86 | 1192.0 |
| 2014-07-08 02:00:00 | ES | Futures | 2052.86 | 2053.64 | 2052.86 | 2053.38 | 1630.0 |
| 2014-07-08 02:30:00 | ES | Futures | 2053.38 | 2054.16 | 2052.86 | 2053.38 | 2769.0 |
| 2014-07-08 03:00:00 | ES | Futures | 2053.12 | 2053.64 | 2051.55 | 2052.34 | 15881.0 |
| 2014-07-08 03:30:00 | ES | Futures | 2052.07 | 2053.9 | 2051.81 | 2053.64 | 8231.0 |
| 2014-07-08 04:00:00 | ES | Futures | 2053.64 | 2053.64 | 2052.07 | 2052.6 | 5904.0 |
| 2014-07-08 04:30:00 | ES | Futures | 2052.86 | 2052.86 | 2051.03 | 2051.29 | 10342.0 |
| 2014-07-08 05:00:00 | ES | Futures | 2051.29 | 2052.07 | 2050.77 | 2051.29 | 7292.0 |
| 2014-07-08 05:30:00 | ES | Futures | 2051.29 | 2051.81 | 2050.77 | 2051.03 | 2491.0 |
| 2014-07-08 06:00:00 | ES | Futures | 2050.77 | 2051.29 | 2049.99 | 2051.29 | 8184.0 |
| 2014-07-08 06:30:00 | ES | Futures | 2051.03 | 2052.34 | 2051.03 | 2051.81 | 4103.0 |
| 2014-07-08 07:00:00 | ES | Futures | 2051.81 | 2052.86 | 2051.29 | 2052.34 | 6110.0 |
| 2014-07-08 07:30:00 | ES | Futures | 2052.34 | 2052.34 | 2051.03 | 2052.07 | 5962.0 |
| 2014-07-08 08:00:00 | ES | Futures | 2052.34 | 2052.34 | 2051.29 | 2051.29 | 4955.0 |
| 2014-07-08 08:30:00 | ES | Futures | 2051.29 | 2051.81 | 2050.25 | 2050.77 | 15025.0 |
| 2014-07-08 09:00:00 | ES | Futures | 2051.03 | 2051.03 | 2049.21 | 2050.25 | 25105.0 |
| 2014-07-08 09:30:00 | ES | Futures | 2050.25 | 2051.03 | 2042.95 | 2045.82 | 238913.0 |
| 2014-07-08 10:00:00 | ES | Futures | 2045.82 | 2045.82 | 2040.87 | 2041.91 | 176469.0 |
| 2014-07-08 10:30:00 | ES | Futures | 2041.91 | 2043.21 | 2038.78 | 2042.17 | 162734.0 |
| 2014-07-08 11:00:00 | ES | Futures | 2042.17 | 2042.43 | 2036.7 | 2037.22 | 133674.0 |
| 2014-07-08 11:30:00 | ES | Futures | 2036.96 | 2040.87 | 2036.44 | 2038.78 | 141521.0 |
| 2014-07-08 12:00:00 | ES | Futures | 2038.52 | 2039.3 | 2035.66 | 2038.0 | 98755.0 |
| 2014-07-08 12:30:00 | ES | Futures | 2037.74 | 2040.35 | 2036.7 | 2039.57 | 75233.0 |
| 2014-07-08 13:00:00 | ES | Futures | 2039.83 | 2042.69 | 2038.26 | 2041.91 | 67329.0 |
| 2014-07-08 13:30:00 | ES | Futures | 2041.91 | 2044.52 | 2041.65 | 2043.21 | 79080.0 |
| 2014-07-08 14:00:00 | ES | Futures | 2043.47 | 2043.47 | 2041.65 | 2042.17 | 61449.0 |
| 2014-07-08 14:30:00 | ES | Futures | 2042.43 | 2043.21 | 2040.61 | 2040.87 | 53994.0 |
| 2014-07-08 15:00:00 | ES | Futures | 2040.87 | 2041.91 | 2038.78 | 2040.35 | 81410.0 |
| 2014-07-08 15:30:00 | ES | Futures | 2040.35 | 2041.65 | 2039.83 | 2041.13 | 161005.0 |
| 2014-07-08 16:00:00 | ES | Futures | 2041.13 | 2043.73 | 2040.87 | 2043.73 | 91480.0 |
| 2014-07-08 16:30:00 | ES | Futures | 2043.47 | 2044.0 | 2043.21 | 2043.21 | 6199.0 |
| 2014-07-08 17:00:00 | ES | Futures | 2043.47 | 2043.73 | 2043.21 | 2043.73 | 3379.0 |
| 2014-07-08 18:00:00 | ES | Futures | 2043.73 | 2044.0 | 2043.21 | 2043.47 | 1674.0 |
| 2014-07-08 18:30:00 | ES | Futures | 2043.73 | 2044.0 | 2043.47 | 2043.47 | 479.0 |
| 2014-07-08 19:00:00 | ES | Futures | 2043.73 | 2044.0 | 2043.47 | 2044.0 | 422.0 |
| 2014-07-08 19:30:00 | ES | Futures | 2043.73 | 2044.0 | 2043.21 | 2043.47 | 810.0 |
| 2014-07-08 20:00:00 | ES | Futures | 2043.47 | 2044.52 | 2043.47 | 2044.26 | 2417.0 |
| 2014-07-08 20:30:00 | ES | Futures | 2044.0 | 2045.04 | 2044.0 | 2044.78 | 3245.0 |
| 2014-07-08 21:00:00 | ES | Futures | 2044.52 | 2045.04 | 2044.26 | 2044.78 | 1128.0 |
| 2014-07-08 21:30:00 | ES | Futures | 2044.78 | 2045.04 | 2043.73 | 2044.26 | 1918.0 |
| 2014-07-08 22:00:00 | ES | Futures | 2044.26 | 2044.78 | 2043.73 | 2044.52 | 2120.0 |
| 2014-07-08 22:30:00 | ES | Futures | 2044.78 | 2045.56 | 2044.52 | 2044.78 | 3653.0 |
| 2014-07-08 23:00:00 | ES | Futures | 2045.04 | 2045.04 | 2043.73 | 2044.26 | 1670.0 |
| 2014-07-08 23:30:00 | ES | Futures | 2044.52 | 2044.52 | 2043.73 | 2044.26 | 974.0 |
| 2014-07-08 00:00:00 | NQ | Futures | 4559.52 | 4559.81 | 4558.93 | 4559.81 | 142.0 |
| 2014-07-08 00:30:00 | NQ | Futures | 4559.81 | 4560.1 | 4559.23 | 4559.23 | 74.0 |
| 2014-07-08 01:00:00 | NQ | Futures | 4559.23 | 4559.52 | 4558.06 | 4558.35 | 101.0 |
> showing 50 of 2,815 rows — these rows as CSV