PREVIEW / etf_5min / 2015-11-05
file: by_date/etf_5min/2015/2015-11-05.parquet size: 1.1 MB rows: 46,868
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 |
|---|---|---|---|---|---|---|---|
| 2015-11-05 04:00:00 | SPY | ETF | 210.12 | 210.12 | 210.12 | 210.12 | 100.0 |
| 2015-11-05 04:05:00 | SPY | ETF | 210.2 | 210.2 | 210.2 | 210.2 | 100.0 |
| 2015-11-05 04:15:00 | SPY | ETF | 210.22 | 210.22 | 210.22 | 210.22 | 100.0 |
| 2015-11-05 04:20:00 | SPY | ETF | 210.16 | 210.27 | 210.16 | 210.27 | 236.0 |
| 2015-11-05 04:25:00 | SPY | ETF | 210.29 | 210.39 | 210.29 | 210.39 | 546.0 |
| 2015-11-05 04:30:00 | SPY | ETF | 210.39 | 210.39 | 210.39 | 210.39 | 123.0 |
| 2015-11-05 04:45:00 | SPY | ETF | 210.27 | 210.27 | 210.22 | 210.23 | 520.0 |
| 2015-11-05 04:50:00 | SPY | ETF | 210.3 | 210.3 | 210.3 | 210.3 | 240.0 |
| 2015-11-05 04:55:00 | SPY | ETF | 210.32 | 210.32 | 210.29 | 210.29 | 320.0 |
| 2015-11-05 05:05:00 | SPY | ETF | 210.33 | 210.33 | 210.33 | 210.33 | 510.0 |
| 2015-11-05 05:10:00 | SPY | ETF | 210.4 | 210.42 | 210.4 | 210.42 | 339.0 |
| 2015-11-05 05:20:00 | SPY | ETF | 210.46 | 210.46 | 210.46 | 210.46 | 133.0 |
| 2015-11-05 05:25:00 | SPY | ETF | 210.5 | 210.57 | 210.49 | 210.57 | 4096.0 |
| 2015-11-05 05:30:00 | SPY | ETF | 210.6 | 210.62 | 210.58 | 210.62 | 2336.0 |
| 2015-11-05 05:35:00 | SPY | ETF | 210.7 | 210.7 | 210.7 | 210.7 | 248.0 |
| 2015-11-05 05:40:00 | SPY | ETF | 210.66 | 210.66 | 210.65 | 210.65 | 700.0 |
| 2015-11-05 05:45:00 | SPY | ETF | 210.61 | 210.61 | 210.61 | 210.61 | 300.0 |
| 2015-11-05 05:50:00 | SPY | ETF | 210.52 | 210.52 | 210.52 | 210.52 | 500.0 |
| 2015-11-05 05:55:00 | SPY | ETF | 210.55 | 210.55 | 210.55 | 210.55 | 1000.0 |
| 2015-11-05 06:00:00 | SPY | ETF | 210.55 | 210.55 | 210.55 | 210.55 | 100.0 |
| 2015-11-05 06:05:00 | SPY | ETF | 210.58 | 210.58 | 210.55 | 210.57 | 1113.0 |
| 2015-11-05 06:10:00 | SPY | ETF | 210.57 | 210.6 | 210.57 | 210.6 | 700.0 |
| 2015-11-05 06:15:00 | SPY | ETF | 210.59 | 210.6 | 210.55 | 210.58 | 8726.0 |
| 2015-11-05 06:20:00 | SPY | ETF | 210.5 | 210.5 | 210.5 | 210.5 | 1500.0 |
| 2015-11-05 06:25:00 | SPY | ETF | 210.56 | 210.56 | 210.52 | 210.52 | 2000.0 |
| 2015-11-05 06:30:00 | SPY | ETF | 210.5 | 210.6 | 210.5 | 210.6 | 3505.0 |
| 2015-11-05 06:35:00 | SPY | ETF | 210.62 | 210.62 | 210.6 | 210.6 | 2280.0 |
| 2015-11-05 06:40:00 | SPY | ETF | 210.69 | 210.89 | 210.69 | 210.87 | 14381.0 |
| 2015-11-05 06:45:00 | SPY | ETF | 210.87 | 210.88 | 210.87 | 210.88 | 7746.0 |
| 2015-11-05 06:50:00 | SPY | ETF | 210.78 | 210.8 | 210.76 | 210.8 | 2501.0 |
| 2015-11-05 06:55:00 | SPY | ETF | 210.79 | 210.79 | 210.72 | 210.72 | 1601.0 |
| 2015-11-05 07:00:00 | SPY | ETF | 210.74 | 210.78 | 210.72 | 210.76 | 6124.0 |
| 2015-11-05 07:05:00 | SPY | ETF | 210.79 | 210.85 | 210.79 | 210.82 | 54405.0 |
| 2015-11-05 07:10:00 | SPY | ETF | 210.83 | 210.98 | 210.83 | 210.98 | 17613.0 |
| 2015-11-05 07:15:00 | SPY | ETF | 210.97 | 211.06 | 210.97 | 210.98 | 31139.0 |
| 2015-11-05 07:20:00 | SPY | ETF | 210.94 | 211.02 | 210.94 | 210.94 | 6095.0 |
| 2015-11-05 07:25:00 | SPY | ETF | 210.97 | 211.02 | 210.97 | 211.02 | 15303.0 |
| 2015-11-05 07:30:00 | SPY | ETF | 211.03 | 211.06 | 211.0 | 211.01 | 28308.0 |
| 2015-11-05 07:35:00 | SPY | ETF | 211.02 | 211.08 | 211.02 | 211.08 | 110898.0 |
| 2015-11-05 07:40:00 | SPY | ETF | 211.09 | 211.09 | 210.97 | 211.02 | 13678.0 |
| 2015-11-05 07:45:00 | SPY | ETF | 211.0 | 211.08 | 210.97 | 211.07 | 13933.0 |
| 2015-11-05 07:50:00 | SPY | ETF | 211.06 | 211.08 | 211.05 | 211.07 | 6168.0 |
| 2015-11-05 07:55:00 | SPY | ETF | 211.06 | 211.12 | 211.04 | 211.05 | 59162.0 |
| 2015-11-05 08:00:00 | SPY | ETF | 210.43 | 211.04 | 210.43 | 210.98 | 45914.0 |
| 2015-11-05 08:05:00 | SPY | ETF | 210.23 | 211.0 | 210.23 | 210.99 | 98106.0 |
| 2015-11-05 08:10:00 | SPY | ETF | 210.97 | 210.97 | 210.9 | 210.92 | 17688.0 |
| 2015-11-05 08:15:00 | SPY | ETF | 210.92 | 210.99 | 210.92 | 210.98 | 23285.0 |
| 2015-11-05 08:20:00 | SPY | ETF | 210.94 | 210.9565 | 210.89 | 210.91 | 60308.0 |
| 2015-11-05 08:25:00 | SPY | ETF | 210.9 | 210.94 | 210.9 | 210.9335 | 26498.0 |
| 2015-11-05 08:30:00 | SPY | ETF | 210.92 | 210.95 | 210.8 | 210.8 | 86250.0 |
> showing 50 of 46,868 rows — these rows as CSV