PREVIEW / etf_5min / 2020-11-06
file: by_date/etf_5min/2020/2020-11-06.parquet size: 1.7 MB rows: 75,161
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 |
|---|---|---|---|---|---|---|---|
| 2020-11-06 04:00:00 | SPY | ETF | 348.07 | 348.11 | 347.64 | 347.75 | 9112.0 |
| 2020-11-06 04:05:00 | SPY | ETF | 347.63 | 347.73 | 347.18 | 347.2 | 6309.0 |
| 2020-11-06 04:10:00 | SPY | ETF | 347.18 | 347.44 | 347.0 | 347.37 | 15939.0 |
| 2020-11-06 04:15:00 | SPY | ETF | 347.3 | 347.77 | 347.27 | 347.77 | 7099.0 |
| 2020-11-06 04:20:00 | SPY | ETF | 347.72 | 347.76 | 347.54 | 347.62 | 54416.0 |
| 2020-11-06 04:25:00 | SPY | ETF | 347.71 | 347.77 | 347.61 | 347.76 | 842.0 |
| 2020-11-06 04:30:00 | SPY | ETF | 347.67 | 347.77 | 347.55 | 347.58 | 4757.0 |
| 2020-11-06 04:35:00 | SPY | ETF | 347.6 | 347.6 | 347.52 | 347.54 | 659.0 |
| 2020-11-06 04:40:00 | SPY | ETF | 347.13 | 347.48 | 346.92 | 347.26 | 14476.0 |
| 2020-11-06 04:45:00 | SPY | ETF | 347.29 | 347.41 | 347.05 | 347.05 | 5021.0 |
| 2020-11-06 04:50:00 | SPY | ETF | 347.14 | 347.24 | 346.49 | 346.54 | 23538.0 |
| 2020-11-06 04:55:00 | SPY | ETF | 346.5 | 346.5 | 346.12 | 346.3 | 7947.0 |
| 2020-11-06 05:00:00 | SPY | ETF | 346.3 | 346.39 | 345.77 | 345.98 | 3098.0 |
| 2020-11-06 05:05:00 | SPY | ETF | 345.88 | 346.5 | 345.88 | 346.37 | 6005.0 |
| 2020-11-06 05:10:00 | SPY | ETF | 346.3 | 346.75 | 346.3 | 346.68 | 4106.0 |
| 2020-11-06 05:15:00 | SPY | ETF | 346.7 | 346.72 | 346.5 | 346.5 | 8087.0 |
| 2020-11-06 05:20:00 | SPY | ETF | 346.76 | 346.81 | 346.58 | 346.78 | 2706.0 |
| 2020-11-06 05:25:00 | SPY | ETF | 346.9 | 347.2 | 346.78 | 347.2 | 4421.0 |
| 2020-11-06 05:30:00 | SPY | ETF | 347.21 | 347.3 | 347.08 | 347.21 | 21382.0 |
| 2020-11-06 05:35:00 | SPY | ETF | 347.34 | 347.52 | 347.21 | 347.46 | 8074.0 |
| 2020-11-06 05:40:00 | SPY | ETF | 347.57 | 347.57 | 347.42 | 347.56 | 1545.0 |
| 2020-11-06 05:45:00 | SPY | ETF | 347.53 | 347.72 | 347.48 | 347.62 | 13211.0 |
| 2020-11-06 05:50:00 | SPY | ETF | 347.72 | 347.86 | 347.65 | 347.65 | 4906.0 |
| 2020-11-06 05:55:00 | SPY | ETF | 347.68 | 347.68 | 347.28 | 347.5 | 4256.0 |
| 2020-11-06 06:00:00 | SPY | ETF | 347.69 | 348.16 | 347.69 | 347.9 | 14096.0 |
| 2020-11-06 06:05:00 | SPY | ETF | 348.08 | 348.28 | 347.85 | 348.28 | 3204.0 |
| 2020-11-06 06:10:00 | SPY | ETF | 348.19 | 348.24 | 347.89 | 347.89 | 8254.0 |
| 2020-11-06 06:15:00 | SPY | ETF | 348.09 | 348.12 | 347.97 | 347.97 | 2466.0 |
| 2020-11-06 06:20:00 | SPY | ETF | 348.1 | 348.17 | 347.99 | 348.17 | 2505.0 |
| 2020-11-06 06:25:00 | SPY | ETF | 348.13 | 348.13 | 347.82 | 347.82 | 3553.0 |
| 2020-11-06 06:30:00 | SPY | ETF | 347.89 | 348.04 | 347.7 | 348.04 | 16043.0 |
| 2020-11-06 06:35:00 | SPY | ETF | 347.95 | 347.96 | 347.79 | 347.82 | 1900.0 |
| 2020-11-06 06:40:00 | SPY | ETF | 347.81 | 347.9 | 347.77 | 347.9 | 3216.0 |
| 2020-11-06 06:45:00 | SPY | ETF | 347.98 | 348.17 | 347.4 | 347.41 | 36441.0 |
| 2020-11-06 06:50:00 | SPY | ETF | 347.5 | 347.69 | 347.5 | 347.69 | 6403.0 |
| 2020-11-06 06:55:00 | SPY | ETF | 347.75 | 347.86 | 347.74 | 347.86 | 4686.0 |
| 2020-11-06 07:00:00 | SPY | ETF | 347.84 | 348.21 | 347.84 | 348.21 | 21786.0 |
| 2020-11-06 07:05:00 | SPY | ETF | 348.19 | 348.53 | 348.16 | 348.46 | 28265.0 |
| 2020-11-06 07:10:00 | SPY | ETF | 348.43 | 348.44 | 348.03 | 348.05 | 36906.0 |
| 2020-11-06 07:15:00 | SPY | ETF | 348.08 | 348.1 | 347.82 | 347.97 | 9898.0 |
| 2020-11-06 07:20:00 | SPY | ETF | 347.96 | 347.96 | 347.7 | 347.71 | 9522.0 |
| 2020-11-06 07:25:00 | SPY | ETF | 347.64 | 347.84 | 347.36 | 347.59 | 22032.0 |
| 2020-11-06 07:30:00 | SPY | ETF | 347.54 | 347.55 | 347.25 | 347.25 | 9463.0 |
| 2020-11-06 07:35:00 | SPY | ETF | 347.27 | 347.36 | 347.0 | 347.0 | 14241.0 |
| 2020-11-06 07:40:00 | SPY | ETF | 347.0 | 347.42 | 346.78 | 347.35 | 77212.0 |
| 2020-11-06 07:45:00 | SPY | ETF | 347.31 | 347.46 | 347.24 | 347.31 | 50833.0 |
| 2020-11-06 07:50:00 | SPY | ETF | 347.4 | 347.57 | 347.36 | 347.39 | 42886.0 |
| 2020-11-06 07:55:00 | SPY | ETF | 347.35 | 347.57 | 346.99 | 346.99 | 47049.0 |
| 2020-11-06 08:00:00 | SPY | ETF | 348.3599 | 350.0 | 346.54 | 346.92 | 137360.0 |
| 2020-11-06 08:05:00 | SPY | ETF | 346.88 | 346.89 | 346.64 | 346.76 | 17942.0 |
> showing 50 of 75,161 rows — these rows as CSV