PREVIEW / etf_5min / 2016-02-23
file: by_date/etf_5min/2016/2016-02-23.parquet size: 1.1 MB rows: 48,635
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-02-23 04:00:00 | SPY | ETF | 193.82 | 193.82 | 193.75 | 193.75 | 1771.0 |
| 2016-02-23 04:05:00 | SPY | ETF | 193.71 | 193.91 | 193.71 | 193.91 | 2786.0 |
| 2016-02-23 04:10:00 | SPY | ETF | 193.97 | 193.97 | 193.92 | 193.95 | 1800.0 |
| 2016-02-23 04:15:00 | SPY | ETF | 194.0 | 194.0 | 194.0 | 194.0 | 105.0 |
| 2016-02-23 04:20:00 | SPY | ETF | 193.93 | 193.93 | 193.83 | 193.83 | 853.0 |
| 2016-02-23 04:25:00 | SPY | ETF | 193.85 | 193.87 | 193.74 | 193.78 | 1641.0 |
| 2016-02-23 04:30:00 | SPY | ETF | 193.73 | 193.75 | 193.73 | 193.75 | 3311.0 |
| 2016-02-23 04:35:00 | SPY | ETF | 193.8 | 193.88 | 193.78 | 193.86 | 3414.0 |
| 2016-02-23 04:40:00 | SPY | ETF | 193.86 | 193.86 | 193.75 | 193.75 | 3502.0 |
| 2016-02-23 04:45:00 | SPY | ETF | 193.69 | 193.69 | 193.47 | 193.53 | 3375.0 |
| 2016-02-23 04:50:00 | SPY | ETF | 193.52 | 193.57 | 193.49 | 193.56 | 3119.0 |
| 2016-02-23 04:55:00 | SPY | ETF | 193.52 | 193.52 | 193.47 | 193.48 | 1668.0 |
| 2016-02-23 05:00:00 | SPY | ETF | 193.52 | 193.52 | 193.47 | 193.47 | 1036.0 |
| 2016-02-23 05:05:00 | SPY | ETF | 193.56 | 193.67 | 193.56 | 193.67 | 1647.0 |
| 2016-02-23 05:15:00 | SPY | ETF | 193.53 | 193.53 | 193.52 | 193.53 | 1575.0 |
| 2016-02-23 05:20:00 | SPY | ETF | 193.5 | 193.52 | 193.46 | 193.46 | 1142.0 |
| 2016-02-23 05:25:00 | SPY | ETF | 193.48 | 193.48 | 193.39 | 193.39 | 3152.0 |
| 2016-02-23 05:30:00 | SPY | ETF | 193.46 | 193.46 | 193.43 | 193.45 | 402.0 |
| 2016-02-23 05:35:00 | SPY | ETF | 193.46 | 193.48 | 193.46 | 193.48 | 203.0 |
| 2016-02-23 05:40:00 | SPY | ETF | 193.58 | 193.59 | 193.58 | 193.59 | 206.0 |
| 2016-02-23 05:45:00 | SPY | ETF | 193.63 | 193.63 | 193.63 | 193.63 | 1232.0 |
| 2016-02-23 05:50:00 | SPY | ETF | 193.54 | 193.54 | 193.53 | 193.53 | 1648.0 |
| 2016-02-23 05:55:00 | SPY | ETF | 193.56 | 193.81 | 193.56 | 193.8 | 4570.0 |
| 2016-02-23 06:00:00 | SPY | ETF | 193.81 | 193.92 | 193.79 | 193.92 | 3243.0 |
| 2016-02-23 06:05:00 | SPY | ETF | 193.9 | 193.97 | 193.84 | 193.96 | 6950.0 |
| 2016-02-23 06:10:00 | SPY | ETF | 193.93 | 193.94 | 193.92 | 193.94 | 2649.0 |
| 2016-02-23 06:15:00 | SPY | ETF | 194.01 | 194.06 | 193.99 | 194.02 | 3849.0 |
| 2016-02-23 06:20:00 | SPY | ETF | 194.04 | 194.1 | 194.02 | 194.04 | 5005.0 |
| 2016-02-23 06:25:00 | SPY | ETF | 194.03 | 194.03 | 193.89 | 193.96 | 5204.0 |
| 2016-02-23 06:30:00 | SPY | ETF | 193.93 | 193.93 | 193.93 | 193.93 | 2400.0 |
| 2016-02-23 06:35:00 | SPY | ETF | 193.95 | 194.03 | 193.95 | 194.03 | 10073.0 |
| 2016-02-23 06:40:00 | SPY | ETF | 193.99 | 193.99 | 193.98 | 193.98 | 418.0 |
| 2016-02-23 06:45:00 | SPY | ETF | 193.96 | 193.96 | 193.94 | 193.94 | 301.0 |
| 2016-02-23 06:50:00 | SPY | ETF | 193.92 | 193.93 | 193.88 | 193.93 | 7424.0 |
| 2016-02-23 06:55:00 | SPY | ETF | 193.93 | 193.93 | 193.9 | 193.9 | 8804.0 |
| 2016-02-23 07:00:00 | SPY | ETF | 193.95 | 194.14 | 193.94 | 194.12 | 10752.0 |
| 2016-02-23 07:05:00 | SPY | ETF | 194.09 | 194.2 | 194.09 | 194.18 | 17090.0 |
| 2016-02-23 07:10:00 | SPY | ETF | 194.18 | 194.18 | 194.09 | 194.09 | 15943.0 |
| 2016-02-23 07:15:00 | SPY | ETF | 194.09 | 194.24 | 194.09 | 194.24 | 16816.0 |
| 2016-02-23 07:20:00 | SPY | ETF | 194.19 | 194.23 | 194.14 | 194.14 | 4582.0 |
| 2016-02-23 07:25:00 | SPY | ETF | 194.16 | 194.2 | 194.12 | 194.18 | 15302.0 |
| 2016-02-23 07:30:00 | SPY | ETF | 194.15 | 194.2 | 194.15 | 194.17 | 23431.0 |
| 2016-02-23 07:35:00 | SPY | ETF | 194.2 | 194.2 | 194.15 | 194.15 | 5403.0 |
| 2016-02-23 07:40:00 | SPY | ETF | 194.15 | 194.16 | 194.09 | 194.16 | 21722.0 |
| 2016-02-23 07:45:00 | SPY | ETF | 194.17 | 194.18 | 194.02 | 194.05 | 31039.0 |
| 2016-02-23 07:50:00 | SPY | ETF | 194.02 | 194.02 | 193.86 | 193.91 | 61345.0 |
| 2016-02-23 07:55:00 | SPY | ETF | 193.91 | 193.97 | 193.88 | 193.97 | 9209.0 |
| 2016-02-23 08:00:00 | SPY | ETF | 193.96 | 194.2 | 193.77 | 193.8 | 135619.0 |
| 2016-02-23 08:05:00 | SPY | ETF | 193.8 | 193.85 | 193.74 | 193.85 | 148720.0 |
| 2016-02-23 08:10:00 | SPY | ETF | 193.84 | 193.87 | 193.78 | 193.8 | 32315.0 |
> showing 50 of 48,635 rows — these rows as CSV