PREVIEW / etf_5min / 2019-01-25
file: by_date/etf_5min/2019/2019-01-25.parquet size: 1.4 MB rows: 62,898
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 |
|---|---|---|---|---|---|---|---|
| 2019-01-25 04:00:00 | SPY | ETF | 264.53 | 264.78 | 264.53 | 264.75 | 7461.0 |
| 2019-01-25 04:05:00 | SPY | ETF | 264.66 | 264.66 | 264.58 | 264.61 | 4024.0 |
| 2019-01-25 04:10:00 | SPY | ETF | 264.63 | 264.66 | 264.51 | 264.51 | 2800.0 |
| 2019-01-25 04:15:00 | SPY | ETF | 264.61 | 264.64 | 264.53 | 264.53 | 4400.0 |
| 2019-01-25 04:20:00 | SPY | ETF | 264.54 | 264.54 | 264.54 | 264.54 | 500.0 |
| 2019-01-25 04:25:00 | SPY | ETF | 264.48 | 264.53 | 264.43 | 264.53 | 2495.0 |
| 2019-01-25 04:30:00 | SPY | ETF | 264.5 | 264.59 | 264.5 | 264.59 | 500.0 |
| 2019-01-25 04:35:00 | SPY | ETF | 264.6 | 264.64 | 264.53 | 264.64 | 3000.0 |
| 2019-01-25 04:45:00 | SPY | ETF | 264.52 | 264.6 | 264.5 | 264.57 | 1950.0 |
| 2019-01-25 04:55:00 | SPY | ETF | 264.32 | 264.32 | 264.3 | 264.3 | 200.0 |
| 2019-01-25 05:00:00 | SPY | ETF | 264.31 | 264.31 | 264.31 | 264.31 | 400.0 |
| 2019-01-25 05:05:00 | SPY | ETF | 264.42 | 264.42 | 264.39 | 264.39 | 400.0 |
| 2019-01-25 05:15:00 | SPY | ETF | 264.24 | 264.3 | 264.24 | 264.3 | 500.0 |
| 2019-01-25 05:20:00 | SPY | ETF | 264.45 | 264.45 | 264.45 | 264.45 | 265.0 |
| 2019-01-25 05:25:00 | SPY | ETF | 264.57 | 264.57 | 264.53 | 264.53 | 800.0 |
| 2019-01-25 05:30:00 | SPY | ETF | 264.58 | 264.65 | 264.58 | 264.65 | 800.0 |
| 2019-01-25 05:35:00 | SPY | ETF | 264.68 | 264.74 | 264.6 | 264.72 | 1900.0 |
| 2019-01-25 05:40:00 | SPY | ETF | 264.73 | 264.8 | 264.73 | 264.75 | 2220.0 |
| 2019-01-25 05:45:00 | SPY | ETF | 264.8 | 264.97 | 264.75 | 264.8 | 5002.0 |
| 2019-01-25 05:50:00 | SPY | ETF | 264.77 | 264.84 | 264.77 | 264.8 | 700.0 |
| 2019-01-25 05:55:00 | SPY | ETF | 264.8 | 264.8 | 264.8 | 264.8 | 100.0 |
| 2019-01-25 06:00:00 | SPY | ETF | 264.83 | 264.94 | 264.83 | 264.94 | 1588.0 |
| 2019-01-25 06:05:00 | SPY | ETF | 264.9 | 264.95 | 264.88 | 264.94 | 11948.0 |
| 2019-01-25 06:10:00 | SPY | ETF | 264.85 | 264.9 | 264.85 | 264.9 | 4300.0 |
| 2019-01-25 06:15:00 | SPY | ETF | 264.9 | 265.07 | 264.9 | 265.06 | 23217.0 |
| 2019-01-25 06:20:00 | SPY | ETF | 265.02 | 265.09 | 264.98 | 265.09 | 15976.0 |
| 2019-01-25 06:25:00 | SPY | ETF | 265.04 | 265.04 | 264.95 | 265.0 | 5703.0 |
| 2019-01-25 06:30:00 | SPY | ETF | 264.96 | 265.0 | 264.95 | 264.96 | 1804.0 |
| 2019-01-25 06:35:00 | SPY | ETF | 264.93 | 264.94 | 264.78 | 264.83 | 5552.0 |
| 2019-01-25 06:40:00 | SPY | ETF | 264.81 | 264.81 | 264.78 | 264.79 | 2638.0 |
| 2019-01-25 06:45:00 | SPY | ETF | 264.77 | 264.88 | 264.77 | 264.88 | 2200.0 |
| 2019-01-25 06:50:00 | SPY | ETF | 264.88 | 265.05 | 264.88 | 265.02 | 3384.0 |
| 2019-01-25 06:55:00 | SPY | ETF | 264.96 | 264.96 | 264.9 | 264.91 | 3219.0 |
| 2019-01-25 07:00:00 | SPY | ETF | 264.79 | 264.83 | 264.74 | 264.74 | 19466.0 |
| 2019-01-25 07:05:00 | SPY | ETF | 264.73 | 264.73 | 264.59 | 264.71 | 8603.0 |
| 2019-01-25 07:10:00 | SPY | ETF | 264.76 | 264.86 | 264.72 | 264.85 | 35520.0 |
| 2019-01-25 07:15:00 | SPY | ETF | 264.85 | 264.85 | 264.75 | 264.84 | 7965.0 |
| 2019-01-25 07:20:00 | SPY | ETF | 264.82 | 264.85 | 264.8 | 264.82 | 20099.0 |
| 2019-01-25 07:25:00 | SPY | ETF | 264.8 | 264.8 | 264.66 | 264.73 | 28807.0 |
| 2019-01-25 07:30:00 | SPY | ETF | 264.73 | 264.73 | 264.62 | 264.67 | 11635.0 |
| 2019-01-25 07:35:00 | SPY | ETF | 264.68 | 264.69 | 264.6 | 264.64 | 7175.0 |
| 2019-01-25 07:40:00 | SPY | ETF | 264.64 | 264.66 | 264.6 | 264.6 | 11384.0 |
| 2019-01-25 07:45:00 | SPY | ETF | 264.6 | 264.61 | 264.55 | 264.61 | 4074.0 |
| 2019-01-25 07:50:00 | SPY | ETF | 264.62 | 264.73 | 264.62 | 264.7 | 11963.0 |
| 2019-01-25 07:55:00 | SPY | ETF | 264.73 | 264.84 | 264.73 | 264.84 | 13811.0 |
| 2019-01-25 08:00:00 | SPY | ETF | 264.81 | 264.84 | 264.08 | 264.8 | 22633.0 |
| 2019-01-25 08:05:00 | SPY | ETF | 264.36 | 264.95 | 264.36 | 264.93 | 82988.0 |
| 2019-01-25 08:10:00 | SPY | ETF | 264.92 | 264.99 | 264.9 | 264.99 | 35166.0 |
| 2019-01-25 08:15:00 | SPY | ETF | 264.98 | 265.01 | 264.95 | 264.95 | 22986.0 |
| 2019-01-25 08:20:00 | SPY | ETF | 264.97 | 265.0 | 264.96 | 264.98 | 7836.0 |
> showing 50 of 62,898 rows — these rows as CSV