PREVIEW / etf_5min / 2016-01-26
file: by_date/etf_5min/2016/2016-01-26.parquet size: 1.2 MB rows: 50,913
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 |
|---|---|---|---|---|---|---|---|
| 2016-01-26 04:00:00 | SPY | ETF | 186.52 | 186.66 | 186.25 | 186.25 | 2331.0 |
| 2016-01-26 04:05:00 | SPY | ETF | 186.28 | 186.39 | 186.28 | 186.39 | 1932.0 |
| 2016-01-26 04:10:00 | SPY | ETF | 186.42 | 186.6 | 186.42 | 186.6 | 700.0 |
| 2016-01-26 04:15:00 | SPY | ETF | 186.51 | 186.61 | 186.5 | 186.53 | 17165.0 |
| 2016-01-26 04:20:00 | SPY | ETF | 186.56 | 186.63 | 186.51 | 186.54 | 4110.0 |
| 2016-01-26 04:25:00 | SPY | ETF | 186.5 | 186.5 | 186.34 | 186.36 | 1715.0 |
| 2016-01-26 04:30:00 | SPY | ETF | 186.3 | 186.31 | 186.26 | 186.26 | 4279.0 |
| 2016-01-26 04:35:00 | SPY | ETF | 186.38 | 186.44 | 186.3 | 186.44 | 901.0 |
| 2016-01-26 04:40:00 | SPY | ETF | 186.31 | 186.44 | 186.27 | 186.44 | 2400.0 |
| 2016-01-26 04:45:00 | SPY | ETF | 186.43 | 186.64 | 186.43 | 186.59 | 1005.0 |
| 2016-01-26 04:50:00 | SPY | ETF | 186.54 | 186.76 | 186.52 | 186.7 | 9163.0 |
| 2016-01-26 04:55:00 | SPY | ETF | 186.75 | 186.95 | 186.75 | 186.95 | 4456.0 |
| 2016-01-26 05:00:00 | SPY | ETF | 186.93 | 187.06 | 186.81 | 187.02 | 2592.0 |
| 2016-01-26 05:05:00 | SPY | ETF | 187.13 | 187.25 | 186.99 | 187.25 | 7761.0 |
| 2016-01-26 05:10:00 | SPY | ETF | 187.16 | 187.16 | 186.93 | 187.03 | 9705.0 |
| 2016-01-26 05:15:00 | SPY | ETF | 187.04 | 187.16 | 186.99 | 187.0 | 8529.0 |
| 2016-01-26 05:20:00 | SPY | ETF | 187.01 | 187.01 | 186.96 | 187.01 | 3050.0 |
| 2016-01-26 05:25:00 | SPY | ETF | 187.01 | 187.22 | 187.01 | 187.22 | 12650.0 |
| 2016-01-26 05:30:00 | SPY | ETF | 187.29 | 187.29 | 187.23 | 187.24 | 5735.0 |
| 2016-01-26 05:35:00 | SPY | ETF | 187.18 | 187.34 | 187.18 | 187.25 | 5905.0 |
| 2016-01-26 05:40:00 | SPY | ETF | 187.25 | 187.28 | 187.25 | 187.28 | 2000.0 |
| 2016-01-26 05:45:00 | SPY | ETF | 187.14 | 187.24 | 187.14 | 187.24 | 8410.0 |
| 2016-01-26 05:50:00 | SPY | ETF | 187.26 | 187.54 | 187.24 | 187.54 | 8092.0 |
| 2016-01-26 05:55:00 | SPY | ETF | 187.54 | 187.54 | 187.41 | 187.41 | 8311.0 |
| 2016-01-26 06:00:00 | SPY | ETF | 187.44 | 187.51 | 187.44 | 187.47 | 5500.0 |
| 2016-01-26 06:05:00 | SPY | ETF | 187.35 | 187.37 | 187.23 | 187.3 | 8160.0 |
| 2016-01-26 06:10:00 | SPY | ETF | 187.32 | 187.59 | 187.29 | 187.59 | 11230.0 |
| 2016-01-26 06:15:00 | SPY | ETF | 187.6 | 187.67 | 187.36 | 187.36 | 7555.0 |
| 2016-01-26 06:20:00 | SPY | ETF | 187.35 | 187.38 | 187.3 | 187.3 | 3810.0 |
| 2016-01-26 06:25:00 | SPY | ETF | 187.27 | 187.35 | 187.27 | 187.29 | 11800.0 |
| 2016-01-26 06:30:00 | SPY | ETF | 187.32 | 187.55 | 187.32 | 187.55 | 16106.0 |
| 2016-01-26 06:35:00 | SPY | ETF | 187.55 | 187.67 | 187.55 | 187.65 | 12765.0 |
| 2016-01-26 06:40:00 | SPY | ETF | 187.66 | 187.98 | 187.66 | 187.97 | 51841.0 |
| 2016-01-26 06:45:00 | SPY | ETF | 187.93 | 188.29 | 187.92 | 188.24 | 35752.0 |
| 2016-01-26 06:50:00 | SPY | ETF | 188.13 | 188.19 | 188.1 | 188.11 | 24471.0 |
| 2016-01-26 06:55:00 | SPY | ETF | 188.11 | 188.16 | 188.08 | 188.11 | 7760.0 |
| 2016-01-26 07:00:00 | SPY | ETF | 188.08 | 188.3 | 188.08 | 188.29 | 46613.0 |
| 2016-01-26 07:05:00 | SPY | ETF | 188.29 | 188.53 | 188.29 | 188.36 | 113626.0 |
| 2016-01-26 07:10:00 | SPY | ETF | 188.42 | 188.51 | 188.35 | 188.51 | 49755.0 |
| 2016-01-26 07:15:00 | SPY | ETF | 188.51 | 188.51 | 188.19 | 188.21 | 51546.0 |
| 2016-01-26 07:20:00 | SPY | ETF | 188.18 | 188.23 | 188.06 | 188.06 | 14550.0 |
| 2016-01-26 07:25:00 | SPY | ETF | 188.08 | 188.3 | 188.08 | 188.2 | 52440.0 |
| 2016-01-26 07:30:00 | SPY | ETF | 188.25 | 188.25 | 188.14 | 188.25 | 23886.0 |
| 2016-01-26 07:35:00 | SPY | ETF | 188.25 | 188.29 | 188.22 | 188.28 | 36640.0 |
| 2016-01-26 07:40:00 | SPY | ETF | 188.28 | 188.29 | 188.16 | 188.16 | 56076.0 |
| 2016-01-26 07:45:00 | SPY | ETF | 188.15 | 188.15 | 187.77 | 187.8 | 121372.0 |
| 2016-01-26 07:50:00 | SPY | ETF | 187.8 | 187.95 | 187.74 | 187.89 | 71090.0 |
| 2016-01-26 07:55:00 | SPY | ETF | 187.86 | 187.97 | 187.86 | 187.9 | 16800.0 |
| 2016-01-26 08:00:00 | SPY | ETF | 187.87 | 188.5 | 186.43 | 187.56 | 202210.0 |
| 2016-01-26 08:05:00 | SPY | ETF | 187.77 | 187.85 | 187.69 | 187.7 | 200263.0 |
> showing 50 of 50,913 rows — these rows as CSV