PREVIEW / etf_5min / 2022-08-16
file: by_date/etf_5min/2022/2022-08-16.parquet size: 1.9 MB rows: 91,175
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 |
|---|---|---|---|---|---|---|---|
| 2022-08-16 04:00:00 | SPY | ETF | 428.49 | 428.49 | 428.19 | 428.21 | 3916.0 |
| 2022-08-16 04:05:00 | SPY | ETF | 428.21 | 428.47 | 428.15 | 428.47 | 2489.0 |
| 2022-08-16 04:10:00 | SPY | ETF | 428.5 | 428.55 | 428.42 | 428.55 | 2975.0 |
| 2022-08-16 04:15:00 | SPY | ETF | 428.43 | 428.43 | 428.43 | 428.43 | 300.0 |
| 2022-08-16 04:20:00 | SPY | ETF | 428.34 | 428.38 | 428.34 | 428.38 | 537.0 |
| 2022-08-16 04:25:00 | SPY | ETF | 428.47 | 428.69 | 428.47 | 428.62 | 1342.0 |
| 2022-08-16 04:30:00 | SPY | ETF | 428.55 | 428.61 | 428.55 | 428.61 | 789.0 |
| 2022-08-16 04:35:00 | SPY | ETF | 428.6 | 428.82 | 428.6 | 428.82 | 1674.0 |
| 2022-08-16 04:40:00 | SPY | ETF | 428.8 | 428.8 | 428.79 | 428.79 | 900.0 |
| 2022-08-16 04:45:00 | SPY | ETF | 428.59 | 428.59 | 428.5 | 428.5 | 1175.0 |
| 2022-08-16 04:50:00 | SPY | ETF | 428.55 | 428.63 | 428.55 | 428.63 | 200.0 |
| 2022-08-16 04:55:00 | SPY | ETF | 428.52 | 428.52 | 428.5 | 428.51 | 1080.0 |
| 2022-08-16 05:00:00 | SPY | ETF | 428.44 | 428.44 | 428.28 | 428.28 | 2564.0 |
| 2022-08-16 05:05:00 | SPY | ETF | 428.31 | 428.32 | 428.15 | 428.15 | 1393.0 |
| 2022-08-16 05:10:00 | SPY | ETF | 428.11 | 428.11 | 428.04 | 428.05 | 840.0 |
| 2022-08-16 05:15:00 | SPY | ETF | 428.05 | 428.11 | 428.05 | 428.11 | 670.0 |
| 2022-08-16 05:20:00 | SPY | ETF | 428.11 | 428.11 | 428.06 | 428.07 | 3103.0 |
| 2022-08-16 05:25:00 | SPY | ETF | 428.13 | 428.28 | 428.13 | 428.19 | 1016.0 |
| 2022-08-16 05:30:00 | SPY | ETF | 428.06 | 428.06 | 427.91 | 427.91 | 2783.0 |
| 2022-08-16 05:35:00 | SPY | ETF | 427.93 | 427.96 | 427.82 | 427.96 | 5190.0 |
| 2022-08-16 05:40:00 | SPY | ETF | 427.98 | 427.98 | 427.91 | 427.96 | 1245.0 |
| 2022-08-16 05:45:00 | SPY | ETF | 428.03 | 428.03 | 428.0 | 428.0 | 500.0 |
| 2022-08-16 05:50:00 | SPY | ETF | 428.1 | 428.12 | 428.04 | 428.12 | 670.0 |
| 2022-08-16 06:00:00 | SPY | ETF | 428.11 | 428.15 | 428.08 | 428.09 | 7600.0 |
| 2022-08-16 06:05:00 | SPY | ETF | 428.17 | 428.17 | 428.07 | 428.08 | 2787.0 |
| 2022-08-16 06:10:00 | SPY | ETF | 428.02 | 428.03 | 427.86 | 427.86 | 5195.0 |
| 2022-08-16 06:15:00 | SPY | ETF | 427.8 | 427.8 | 427.76 | 427.76 | 2316.0 |
| 2022-08-16 06:20:00 | SPY | ETF | 427.97 | 428.1 | 427.97 | 428.09 | 1992.0 |
| 2022-08-16 06:25:00 | SPY | ETF | 428.11 | 428.11 | 427.9 | 427.9 | 1260.0 |
| 2022-08-16 06:30:00 | SPY | ETF | 427.96 | 428.0 | 427.91 | 428.0 | 2863.0 |
| 2022-08-16 06:35:00 | SPY | ETF | 427.92 | 427.92 | 427.77 | 427.88 | 2700.0 |
| 2022-08-16 06:40:00 | SPY | ETF | 427.83 | 427.83 | 427.72 | 427.83 | 2996.0 |
| 2022-08-16 06:45:00 | SPY | ETF | 427.88 | 427.88 | 427.77 | 427.79 | 1904.0 |
| 2022-08-16 06:50:00 | SPY | ETF | 427.89 | 427.89 | 427.89 | 427.89 | 636.0 |
| 2022-08-16 06:55:00 | SPY | ETF | 427.95 | 427.96 | 427.92 | 427.92 | 350.0 |
| 2022-08-16 07:00:00 | SPY | ETF | 427.87 | 428.46 | 427.72 | 428.11 | 57060.0 |
| 2022-08-16 07:05:00 | SPY | ETF | 428.06 | 428.29 | 428.04 | 428.26 | 16090.0 |
| 2022-08-16 07:10:00 | SPY | ETF | 428.25 | 428.39 | 428.25 | 428.3 | 23811.0 |
| 2022-08-16 07:15:00 | SPY | ETF | 428.33 | 428.33 | 428.25 | 428.3 | 9716.0 |
| 2022-08-16 07:20:00 | SPY | ETF | 428.34 | 428.43 | 428.34 | 428.41 | 10242.0 |
| 2022-08-16 07:25:00 | SPY | ETF | 428.3 | 428.52 | 428.26 | 428.51 | 28216.0 |
| 2022-08-16 07:30:00 | SPY | ETF | 428.51 | 428.57 | 428.44 | 428.55 | 10849.0 |
| 2022-08-16 07:35:00 | SPY | ETF | 428.56 | 428.64 | 428.53 | 428.59 | 26040.0 |
| 2022-08-16 07:40:00 | SPY | ETF | 428.57 | 428.57 | 428.37 | 428.51 | 8234.0 |
| 2022-08-16 07:45:00 | SPY | ETF | 428.51 | 428.52 | 428.44 | 428.44 | 3458.0 |
| 2022-08-16 07:50:00 | SPY | ETF | 428.43 | 428.52 | 428.39 | 428.52 | 9108.0 |
| 2022-08-16 07:55:00 | SPY | ETF | 428.54 | 428.58 | 428.48 | 428.5 | 10575.0 |
| 2022-08-16 08:00:00 | SPY | ETF | 427.87 | 428.6804 | 427.76 | 428.36 | 28749.0 |
| 2022-08-16 08:05:00 | SPY | ETF | 428.36 | 428.42 | 428.36 | 428.42 | 4778.0 |
| 2022-08-16 08:10:00 | SPY | ETF | 428.45 | 428.74 | 428.45 | 428.62 | 18257.0 |
> showing 50 of 91,175 rows — these rows as CSV