PREVIEW / etf_5min / 2019-06-10
file: by_date/etf_5min/2019/2019-06-10.parquet size: 1.4 MB rows: 63,139
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-06-10 04:00:00 | SPY | ETF | 288.8 | 288.94 | 288.78 | 288.84 | 6197.0 |
| 2019-06-10 04:05:00 | SPY | ETF | 288.83 | 288.83 | 288.76 | 288.76 | 200.0 |
| 2019-06-10 04:10:00 | SPY | ETF | 288.76 | 288.76 | 288.76 | 288.76 | 1000.0 |
| 2019-06-10 04:15:00 | SPY | ETF | 288.76 | 288.79 | 288.63 | 288.72 | 5734.0 |
| 2019-06-10 04:25:00 | SPY | ETF | 288.72 | 288.72 | 288.72 | 288.72 | 410.0 |
| 2019-06-10 04:30:00 | SPY | ETF | 288.55 | 288.6 | 288.55 | 288.6 | 400.0 |
| 2019-06-10 04:40:00 | SPY | ETF | 288.51 | 288.59 | 288.51 | 288.51 | 1804.0 |
| 2019-06-10 04:45:00 | SPY | ETF | 288.6 | 288.6 | 288.6 | 288.6 | 500.0 |
| 2019-06-10 04:50:00 | SPY | ETF | 288.6 | 288.6 | 288.6 | 288.6 | 150.0 |
| 2019-06-10 04:55:00 | SPY | ETF | 288.62 | 288.62 | 288.62 | 288.62 | 200.0 |
| 2019-06-10 05:00:00 | SPY | ETF | 288.51 | 288.51 | 288.51 | 288.51 | 500.0 |
| 2019-06-10 05:05:00 | SPY | ETF | 288.6 | 288.6 | 288.53 | 288.6 | 3243.0 |
| 2019-06-10 05:10:00 | SPY | ETF | 288.55 | 288.58 | 288.55 | 288.58 | 508.0 |
| 2019-06-10 05:15:00 | SPY | ETF | 288.5 | 288.63 | 288.5 | 288.63 | 300.0 |
| 2019-06-10 05:20:00 | SPY | ETF | 288.61 | 288.61 | 288.61 | 288.61 | 1620.0 |
| 2019-06-10 05:25:00 | SPY | ETF | 288.63 | 288.63 | 288.63 | 288.63 | 2500.0 |
| 2019-06-10 05:30:00 | SPY | ETF | 288.56 | 288.57 | 288.56 | 288.57 | 500.0 |
| 2019-06-10 05:35:00 | SPY | ETF | 288.5 | 288.55 | 288.5 | 288.55 | 2680.0 |
| 2019-06-10 05:45:00 | SPY | ETF | 288.55 | 288.65 | 288.55 | 288.65 | 2883.0 |
| 2019-06-10 05:55:00 | SPY | ETF | 288.67 | 288.67 | 288.67 | 288.67 | 1000.0 |
| 2019-06-10 06:00:00 | SPY | ETF | 288.71 | 288.71 | 288.71 | 288.71 | 129.0 |
| 2019-06-10 06:05:00 | SPY | ETF | 288.75 | 288.75 | 288.75 | 288.75 | 450.0 |
| 2019-06-10 06:10:00 | SPY | ETF | 288.73 | 288.73 | 288.69 | 288.69 | 1290.0 |
| 2019-06-10 06:20:00 | SPY | ETF | 288.8 | 288.8 | 288.8 | 288.8 | 300.0 |
| 2019-06-10 06:25:00 | SPY | ETF | 288.77 | 288.8 | 288.74 | 288.8 | 12650.0 |
| 2019-06-10 06:30:00 | SPY | ETF | 288.85 | 288.85 | 288.75 | 288.77 | 1810.0 |
| 2019-06-10 06:35:00 | SPY | ETF | 288.77 | 288.78 | 288.77 | 288.78 | 1457.0 |
| 2019-06-10 06:40:00 | SPY | ETF | 288.8 | 288.95 | 288.8 | 288.91 | 2700.0 |
| 2019-06-10 06:45:00 | SPY | ETF | 288.92 | 288.92 | 288.85 | 288.85 | 1200.0 |
| 2019-06-10 06:50:00 | SPY | ETF | 288.85 | 288.9 | 288.84 | 288.9 | 6500.0 |
| 2019-06-10 06:55:00 | SPY | ETF | 288.76 | 288.76 | 288.67 | 288.67 | 1049.0 |
| 2019-06-10 07:00:00 | SPY | ETF | 288.72 | 288.8 | 288.57 | 288.8 | 11680.0 |
| 2019-06-10 07:05:00 | SPY | ETF | 288.8 | 288.89 | 288.77 | 288.89 | 5687.0 |
| 2019-06-10 07:10:00 | SPY | ETF | 288.88 | 289.02 | 288.86 | 289.02 | 26787.0 |
| 2019-06-10 07:15:00 | SPY | ETF | 289.04 | 289.05 | 288.98 | 289.0 | 7507.0 |
| 2019-06-10 07:20:00 | SPY | ETF | 288.98 | 289.0 | 288.96 | 289.0 | 15643.0 |
| 2019-06-10 07:25:00 | SPY | ETF | 289.0 | 289.06 | 288.95 | 289.01 | 20672.0 |
| 2019-06-10 07:30:00 | SPY | ETF | 289.02 | 289.07 | 288.93 | 289.055 | 10567.0 |
| 2019-06-10 07:35:00 | SPY | ETF | 289.04 | 289.04 | 288.97 | 288.99 | 2623.0 |
| 2019-06-10 07:40:00 | SPY | ETF | 289.0 | 289.12 | 289.0 | 289.12 | 13502.0 |
| 2019-06-10 07:45:00 | SPY | ETF | 289.12 | 289.16 | 289.08 | 289.16 | 40133.0 |
| 2019-06-10 07:50:00 | SPY | ETF | 289.17 | 289.17 | 289.12 | 289.16 | 9812.0 |
| 2019-06-10 07:55:00 | SPY | ETF | 289.18 | 289.19 | 289.15 | 289.19 | 7234.0 |
| 2019-06-10 08:00:00 | SPY | ETF | 288.99 | 289.2 | 288.65 | 289.09 | 33555.0 |
| 2019-06-10 08:05:00 | SPY | ETF | 289.09 | 289.24 | 289.09 | 289.24 | 48916.0 |
| 2019-06-10 08:10:00 | SPY | ETF | 289.19 | 289.3 | 289.09 | 289.26 | 26081.0 |
| 2019-06-10 08:15:00 | SPY | ETF | 289.26 | 289.31 | 289.13 | 289.14 | 20275.0 |
| 2019-06-10 08:20:00 | SPY | ETF | 289.12 | 289.12 | 288.99 | 289.04 | 65792.0 |
| 2019-06-10 08:25:00 | SPY | ETF | 289.07 | 289.1 | 289.03 | 289.04 | 31730.0 |
| 2019-06-10 08:30:00 | SPY | ETF | 289.07 | 289.12 | 289.05 | 289.12 | 14805.0 |
> showing 50 of 63,139 rows — these rows as CSV