PREVIEW / etf_5min / 2021-11-23
file: by_date/etf_5min/2021/2021-11-23.parquet size: 1.9 MB rows: 89,905
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 |
|---|---|---|---|---|---|---|---|
| 2021-11-23 04:00:00 | SPY | ETF | 466.66 | 466.66 | 465.96 | 465.99 | 5835.0 |
| 2021-11-23 04:05:00 | SPY | ETF | 466.0 | 466.03 | 465.78 | 465.89 | 6294.0 |
| 2021-11-23 04:10:00 | SPY | ETF | 465.81 | 465.85 | 465.71 | 465.85 | 1363.0 |
| 2021-11-23 04:15:00 | SPY | ETF | 465.85 | 466.38 | 465.85 | 466.26 | 9656.0 |
| 2021-11-23 04:20:00 | SPY | ETF | 466.37 | 466.6 | 466.37 | 466.6 | 7226.0 |
| 2021-11-23 04:25:00 | SPY | ETF | 466.5 | 466.5 | 466.25 | 466.25 | 4004.0 |
| 2021-11-23 04:30:00 | SPY | ETF | 466.3 | 466.37 | 466.17 | 466.27 | 6729.0 |
| 2021-11-23 04:35:00 | SPY | ETF | 466.27 | 466.72 | 466.27 | 466.57 | 4912.0 |
| 2021-11-23 04:40:00 | SPY | ETF | 466.6 | 466.74 | 466.6 | 466.74 | 3155.0 |
| 2021-11-23 04:45:00 | SPY | ETF | 466.61 | 467.0 | 466.61 | 466.87 | 5292.0 |
| 2021-11-23 04:50:00 | SPY | ETF | 466.97 | 466.97 | 466.93 | 466.94 | 450.0 |
| 2021-11-23 04:55:00 | SPY | ETF | 466.81 | 466.98 | 466.79 | 466.98 | 2099.0 |
| 2021-11-23 05:00:00 | SPY | ETF | 467.13 | 467.25 | 467.13 | 467.23 | 2155.0 |
| 2021-11-23 05:05:00 | SPY | ETF | 467.12 | 467.21 | 467.12 | 467.12 | 1600.0 |
| 2021-11-23 05:10:00 | SPY | ETF | 467.21 | 467.35 | 467.2 | 467.34 | 2030.0 |
| 2021-11-23 05:15:00 | SPY | ETF | 467.37 | 467.5 | 467.35 | 467.4 | 4418.0 |
| 2021-11-23 05:20:00 | SPY | ETF | 467.4 | 467.4 | 467.36 | 467.36 | 21105.0 |
| 2021-11-23 05:25:00 | SPY | ETF | 467.36 | 467.37 | 467.23 | 467.26 | 28546.0 |
| 2021-11-23 05:30:00 | SPY | ETF | 467.1 | 467.1 | 467.1 | 467.1 | 486.0 |
| 2021-11-23 05:35:00 | SPY | ETF | 467.21 | 467.27 | 467.17 | 467.23 | 1600.0 |
| 2021-11-23 05:40:00 | SPY | ETF | 467.39 | 467.39 | 467.39 | 467.39 | 200.0 |
| 2021-11-23 05:45:00 | SPY | ETF | 467.3 | 467.3 | 467.11 | 467.16 | 3170.0 |
| 2021-11-23 05:50:00 | SPY | ETF | 467.13 | 467.25 | 467.09 | 467.25 | 2900.0 |
| 2021-11-23 05:55:00 | SPY | ETF | 467.23 | 467.27 | 467.17 | 467.17 | 3398.0 |
| 2021-11-23 06:00:00 | SPY | ETF | 467.19 | 467.19 | 466.85 | 466.9 | 13035.0 |
| 2021-11-23 06:05:00 | SPY | ETF | 466.88 | 466.92 | 466.78 | 466.79 | 1872.0 |
| 2021-11-23 06:10:00 | SPY | ETF | 466.62 | 466.62 | 466.42 | 466.42 | 500.0 |
| 2021-11-23 06:15:00 | SPY | ETF | 466.6 | 466.6 | 466.44 | 466.44 | 650.0 |
| 2021-11-23 06:20:00 | SPY | ETF | 466.74 | 466.86 | 466.68 | 466.74 | 1504.0 |
| 2021-11-23 06:25:00 | SPY | ETF | 466.66 | 466.91 | 466.66 | 466.91 | 1343.0 |
| 2021-11-23 06:30:00 | SPY | ETF | 466.96 | 467.0 | 466.9 | 466.9 | 5300.0 |
| 2021-11-23 06:35:00 | SPY | ETF | 466.88 | 467.03 | 466.88 | 467.03 | 1000.0 |
| 2021-11-23 06:40:00 | SPY | ETF | 467.04 | 467.05 | 466.98 | 466.98 | 10700.0 |
| 2021-11-23 06:45:00 | SPY | ETF | 467.19 | 467.29 | 467.19 | 467.22 | 2031.0 |
| 2021-11-23 06:50:00 | SPY | ETF | 467.27 | 467.41 | 467.27 | 467.38 | 1677.0 |
| 2021-11-23 06:55:00 | SPY | ETF | 467.44 | 467.53 | 467.3 | 467.3 | 3441.0 |
| 2021-11-23 07:00:00 | SPY | ETF | 467.28 | 467.4 | 467.28 | 467.34 | 20191.0 |
| 2021-11-23 07:05:00 | SPY | ETF | 467.29 | 467.72 | 467.29 | 467.62 | 13901.0 |
| 2021-11-23 07:10:00 | SPY | ETF | 467.6 | 467.6 | 467.32 | 467.32 | 9707.0 |
| 2021-11-23 07:15:00 | SPY | ETF | 467.39 | 467.39 | 467.16 | 467.19 | 18767.0 |
| 2021-11-23 07:20:00 | SPY | ETF | 467.14 | 467.52 | 467.13 | 467.41 | 15893.0 |
| 2021-11-23 07:25:00 | SPY | ETF | 467.47 | 467.47 | 467.17 | 467.2 | 10342.0 |
| 2021-11-23 07:30:00 | SPY | ETF | 467.11 | 467.15 | 466.9 | 467.14 | 16986.0 |
| 2021-11-23 07:35:00 | SPY | ETF | 467.16 | 467.3 | 467.16 | 467.2 | 10658.0 |
| 2021-11-23 07:40:00 | SPY | ETF | 467.27 | 467.35 | 467.2 | 467.31 | 15754.0 |
| 2021-11-23 07:45:00 | SPY | ETF | 467.28 | 467.31 | 466.99 | 467.06 | 15678.0 |
| 2021-11-23 07:50:00 | SPY | ETF | 467.02 | 467.19 | 466.99 | 467.16 | 6763.0 |
| 2021-11-23 07:55:00 | SPY | ETF | 467.16 | 467.25 | 467.07 | 467.12 | 10261.0 |
| 2021-11-23 08:00:00 | SPY | ETF | 467.49 | 467.72 | 465.9696 | 467.36 | 47024.0 |
| 2021-11-23 08:05:00 | SPY | ETF | 467.41 | 467.51 | 467.12 | 467.12 | 59056.0 |
> showing 50 of 89,905 rows — these rows as CSV