PREVIEW / etf_5min / 2022-12-05
file: by_date/etf_5min/2022/2022-12-05.parquet size: 2.0 MB rows: 99,331
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-12-05 04:00:00 | SPY | ETF | 406.91 | 406.91 | 405.63 | 405.8 | 5350.0 |
| 2022-12-05 04:05:00 | SPY | ETF | 405.88 | 405.89 | 404.94 | 405.04 | 4307.0 |
| 2022-12-05 04:10:00 | SPY | ETF | 404.97 | 405.22 | 404.8 | 405.11 | 13275.0 |
| 2022-12-05 04:15:00 | SPY | ETF | 405.1 | 405.31 | 405.1 | 405.27 | 9625.0 |
| 2022-12-05 04:20:00 | SPY | ETF | 405.39 | 405.45 | 405.3 | 405.4 | 5240.0 |
| 2022-12-05 04:25:00 | SPY | ETF | 405.33 | 405.67 | 405.3 | 405.67 | 2017.0 |
| 2022-12-05 04:30:00 | SPY | ETF | 405.56 | 405.73 | 405.55 | 405.55 | 1662.0 |
| 2022-12-05 04:35:00 | SPY | ETF | 405.49 | 405.62 | 405.4 | 405.6 | 1161.0 |
| 2022-12-05 04:40:00 | SPY | ETF | 405.6 | 405.71 | 405.57 | 405.65 | 1967.0 |
| 2022-12-05 04:45:00 | SPY | ETF | 405.68 | 405.69 | 405.46 | 405.63 | 20456.0 |
| 2022-12-05 04:50:00 | SPY | ETF | 405.56 | 405.61 | 405.4 | 405.52 | 34857.0 |
| 2022-12-05 04:55:00 | SPY | ETF | 405.55 | 405.55 | 405.36 | 405.5 | 2650.0 |
| 2022-12-05 05:00:00 | SPY | ETF | 405.46 | 405.63 | 405.46 | 405.5 | 2551.0 |
| 2022-12-05 05:05:00 | SPY | ETF | 405.48 | 405.51 | 405.36 | 405.5 | 4829.0 |
| 2022-12-05 05:10:00 | SPY | ETF | 405.55 | 405.72 | 405.55 | 405.67 | 4804.0 |
| 2022-12-05 05:15:00 | SPY | ETF | 405.6 | 405.6 | 405.35 | 405.42 | 2000.0 |
| 2022-12-05 05:20:00 | SPY | ETF | 405.35 | 405.38 | 405.17 | 405.2 | 2851.0 |
| 2022-12-05 05:25:00 | SPY | ETF | 405.25 | 405.28 | 405.18 | 405.26 | 2324.0 |
| 2022-12-05 05:30:00 | SPY | ETF | 405.13 | 405.27 | 404.89 | 405.23 | 8711.0 |
| 2022-12-05 05:35:00 | SPY | ETF | 405.05 | 405.1 | 405.0 | 405.1 | 32040.0 |
| 2022-12-05 05:40:00 | SPY | ETF | 405.1 | 405.23 | 405.1 | 405.19 | 11359.0 |
| 2022-12-05 05:45:00 | SPY | ETF | 405.22 | 405.22 | 405.07 | 405.21 | 11250.0 |
| 2022-12-05 05:50:00 | SPY | ETF | 405.24 | 405.24 | 405.02 | 405.17 | 7702.0 |
| 2022-12-05 05:55:00 | SPY | ETF | 405.15 | 405.19 | 404.99 | 405.05 | 2552.0 |
| 2022-12-05 06:00:00 | SPY | ETF | 405.17 | 405.24 | 405.14 | 405.21 | 3154.0 |
| 2022-12-05 06:05:00 | SPY | ETF | 405.08 | 405.23 | 405.0 | 405.23 | 3255.0 |
| 2022-12-05 06:10:00 | SPY | ETF | 405.24 | 405.41 | 405.24 | 405.38 | 9240.0 |
| 2022-12-05 06:15:00 | SPY | ETF | 405.34 | 405.4 | 405.3 | 405.33 | 17124.0 |
| 2022-12-05 06:20:00 | SPY | ETF | 405.33 | 405.45 | 405.33 | 405.39 | 16445.0 |
| 2022-12-05 06:25:00 | SPY | ETF | 405.4 | 405.45 | 405.25 | 405.25 | 2930.0 |
| 2022-12-05 06:30:00 | SPY | ETF | 405.22 | 405.29 | 405.13 | 405.29 | 2693.0 |
| 2022-12-05 06:35:00 | SPY | ETF | 405.39 | 405.45 | 405.3 | 405.38 | 3013.0 |
| 2022-12-05 06:40:00 | SPY | ETF | 405.41 | 405.5 | 405.35 | 405.5 | 4361.0 |
| 2022-12-05 06:45:00 | SPY | ETF | 405.5 | 405.64 | 405.5 | 405.64 | 5191.0 |
| 2022-12-05 06:50:00 | SPY | ETF | 405.7 | 405.75 | 405.59 | 405.62 | 4952.0 |
| 2022-12-05 06:55:00 | SPY | ETF | 405.64 | 405.75 | 405.59 | 405.65 | 5564.0 |
| 2022-12-05 07:00:00 | SPY | ETF | 405.71 | 405.72 | 405.55 | 405.71 | 123974.0 |
| 2022-12-05 07:05:00 | SPY | ETF | 405.67 | 405.67 | 405.46 | 405.51 | 15540.0 |
| 2022-12-05 07:10:00 | SPY | ETF | 405.54 | 405.55 | 405.26 | 405.3 | 30167.0 |
| 2022-12-05 07:15:00 | SPY | ETF | 405.27 | 405.27 | 405.0 | 405.02 | 36111.0 |
| 2022-12-05 07:20:00 | SPY | ETF | 405.07 | 405.16 | 405.02 | 405.06 | 22889.0 |
| 2022-12-05 07:25:00 | SPY | ETF | 405.04 | 405.1 | 404.95 | 404.95 | 55729.0 |
| 2022-12-05 07:30:00 | SPY | ETF | 404.97 | 405.01 | 404.74 | 404.88 | 23021.0 |
| 2022-12-05 07:35:00 | SPY | ETF | 404.89 | 404.89 | 404.64 | 404.64 | 47485.0 |
| 2022-12-05 07:40:00 | SPY | ETF | 404.65 | 404.89 | 404.65 | 404.82 | 33083.0 |
| 2022-12-05 07:45:00 | SPY | ETF | 404.85 | 404.85 | 404.68 | 404.84 | 16287.0 |
| 2022-12-05 07:50:00 | SPY | ETF | 404.85 | 404.87 | 404.8 | 404.87 | 11957.0 |
| 2022-12-05 07:55:00 | SPY | ETF | 404.88 | 405.04 | 404.86 | 404.95 | 33364.0 |
| 2022-12-05 08:00:00 | SPY | ETF | 404.96 | 406.2 | 404.65 | 404.84 | 111379.0 |
| 2022-12-05 08:05:00 | SPY | ETF | 404.86 | 404.89 | 404.65 | 404.65 | 30685.0 |
> showing 50 of 99,331 rows — these rows as CSV