PREVIEW / etf_5min / 2021-10-15
file: by_date/etf_5min/2021/2021-10-15.parquet size: 1.8 MB rows: 82,563
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-10-15 04:00:00 | SPY | ETF | 443.57 | 443.9 | 443.57 | 443.9 | 3961.0 |
| 2021-10-15 04:05:00 | SPY | ETF | 443.94 | 443.98 | 443.9 | 443.98 | 2069.0 |
| 2021-10-15 04:10:00 | SPY | ETF | 444.04 | 444.04 | 443.98 | 443.98 | 463.0 |
| 2021-10-15 04:15:00 | SPY | ETF | 444.13 | 444.14 | 444.13 | 444.14 | 2440.0 |
| 2021-10-15 04:20:00 | SPY | ETF | 444.04 | 444.04 | 443.88 | 443.88 | 2700.0 |
| 2021-10-15 04:30:00 | SPY | ETF | 444.09 | 444.09 | 443.96 | 443.96 | 300.0 |
| 2021-10-15 04:35:00 | SPY | ETF | 443.9 | 443.93 | 443.9 | 443.93 | 400.0 |
| 2021-10-15 04:40:00 | SPY | ETF | 443.93 | 443.93 | 443.9 | 443.9 | 200.0 |
| 2021-10-15 04:45:00 | SPY | ETF | 443.92 | 443.92 | 443.92 | 443.92 | 100.0 |
| 2021-10-15 04:50:00 | SPY | ETF | 443.83 | 443.86 | 443.8 | 443.8 | 3021.0 |
| 2021-10-15 04:55:00 | SPY | ETF | 443.76 | 443.76 | 443.76 | 443.76 | 500.0 |
| 2021-10-15 05:00:00 | SPY | ETF | 443.71 | 443.71 | 443.68 | 443.68 | 1600.0 |
| 2021-10-15 05:05:00 | SPY | ETF | 443.59 | 443.61 | 443.58 | 443.61 | 1300.0 |
| 2021-10-15 05:10:00 | SPY | ETF | 443.61 | 443.65 | 443.61 | 443.65 | 1622.0 |
| 2021-10-15 05:15:00 | SPY | ETF | 443.65 | 443.65 | 443.63 | 443.63 | 704.0 |
| 2021-10-15 05:20:00 | SPY | ETF | 443.63 | 443.63 | 443.63 | 443.63 | 424.0 |
| 2021-10-15 05:25:00 | SPY | ETF | 443.65 | 443.73 | 443.65 | 443.73 | 1436.0 |
| 2021-10-15 05:30:00 | SPY | ETF | 443.66 | 443.69 | 443.66 | 443.69 | 5775.0 |
| 2021-10-15 05:35:00 | SPY | ETF | 443.68 | 443.7 | 443.54 | 443.54 | 1407.0 |
| 2021-10-15 05:40:00 | SPY | ETF | 443.59 | 443.59 | 443.4 | 443.45 | 8612.0 |
| 2021-10-15 05:45:00 | SPY | ETF | 443.4 | 443.65 | 443.4 | 443.65 | 2109.0 |
| 2021-10-15 05:50:00 | SPY | ETF | 443.65 | 443.65 | 443.64 | 443.64 | 400.0 |
| 2021-10-15 05:55:00 | SPY | ETF | 443.7 | 443.93 | 443.7 | 443.84 | 3033.0 |
| 2021-10-15 06:00:00 | SPY | ETF | 443.91 | 444.07 | 443.91 | 444.07 | 7089.0 |
| 2021-10-15 06:05:00 | SPY | ETF | 444.13 | 444.14 | 443.94 | 443.94 | 6296.0 |
| 2021-10-15 06:10:00 | SPY | ETF | 443.94 | 444.05 | 443.94 | 444.01 | 3799.0 |
| 2021-10-15 06:20:00 | SPY | ETF | 443.94 | 443.94 | 443.83 | 443.86 | 700.0 |
| 2021-10-15 06:25:00 | SPY | ETF | 443.91 | 444.2 | 443.88 | 444.19 | 5417.0 |
| 2021-10-15 06:30:00 | SPY | ETF | 444.24 | 444.25 | 443.94 | 444.02 | 4050.0 |
| 2021-10-15 06:35:00 | SPY | ETF | 443.94 | 443.94 | 443.94 | 443.94 | 100.0 |
| 2021-10-15 06:40:00 | SPY | ETF | 443.89 | 444.0 | 443.89 | 443.99 | 50234.0 |
| 2021-10-15 06:45:00 | SPY | ETF | 444.03 | 444.03 | 444.01 | 444.01 | 414.0 |
| 2021-10-15 06:50:00 | SPY | ETF | 443.9 | 443.9 | 443.82 | 443.85 | 700.0 |
| 2021-10-15 06:55:00 | SPY | ETF | 443.8 | 443.82 | 443.77 | 443.81 | 500.0 |
| 2021-10-15 07:00:00 | SPY | ETF | 443.82 | 444.02 | 443.8 | 443.96 | 10544.0 |
| 2021-10-15 07:05:00 | SPY | ETF | 443.98 | 444.03 | 443.92 | 443.92 | 6820.0 |
| 2021-10-15 07:10:00 | SPY | ETF | 443.92 | 444.04 | 443.9 | 444.01 | 4720.0 |
| 2021-10-15 07:15:00 | SPY | ETF | 444.07 | 444.13 | 443.97 | 444.07 | 17921.0 |
| 2021-10-15 07:20:00 | SPY | ETF | 444.12 | 444.21 | 444.07 | 444.07 | 18867.0 |
| 2021-10-15 07:25:00 | SPY | ETF | 444.08 | 444.2 | 444.04 | 444.18 | 57314.0 |
| 2021-10-15 07:30:00 | SPY | ETF | 444.21 | 444.36 | 444.19 | 444.35 | 42641.0 |
| 2021-10-15 07:35:00 | SPY | ETF | 444.31 | 444.37 | 444.29 | 444.3 | 14872.0 |
| 2021-10-15 07:40:00 | SPY | ETF | 444.31 | 444.36 | 444.28 | 444.31 | 38648.0 |
| 2021-10-15 07:45:00 | SPY | ETF | 444.3 | 444.31 | 444.2 | 444.2 | 79118.0 |
| 2021-10-15 07:50:00 | SPY | ETF | 444.2 | 444.22 | 444.14 | 444.22 | 30272.0 |
| 2021-10-15 07:55:00 | SPY | ETF | 444.22 | 444.22 | 444.09 | 444.11 | 46549.0 |
| 2021-10-15 08:00:00 | SPY | ETF | 443.94 | 444.36 | 442.831 | 444.13 | 111976.0 |
| 2021-10-15 08:05:00 | SPY | ETF | 444.12 | 444.17 | 444.11 | 444.15 | 29725.0 |
| 2021-10-15 08:10:00 | SPY | ETF | 444.151 | 444.22 | 444.15 | 444.19 | 30926.0 |
| 2021-10-15 08:15:00 | SPY | ETF | 444.2 | 444.2 | 444.12 | 444.14 | 35108.0 |
> showing 50 of 82,563 rows — these rows as CSV