PREVIEW / etf_5min / 2024-05-22
file: by_date/etf_5min/2024/2024-05-22.parquet size: 2.2 MB rows: 110,133
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 |
|---|---|---|---|---|---|---|---|
| 2024-05-22 04:00:00 | SPY | ETF | 531.11 | 531.15 | 531.08 | 531.15 | 919.0 |
| 2024-05-22 04:05:00 | SPY | ETF | 531.13 | 531.13 | 531.09 | 531.09 | 560.0 |
| 2024-05-22 04:15:00 | SPY | ETF | 531.06 | 531.06 | 531.05 | 531.05 | 200.0 |
| 2024-05-22 04:20:00 | SPY | ETF | 531.12 | 531.12 | 531.12 | 531.12 | 100.0 |
| 2024-05-22 04:25:00 | SPY | ETF | 531.0 | 531.0 | 530.96 | 530.96 | 260.0 |
| 2024-05-22 04:35:00 | SPY | ETF | 530.96 | 530.96 | 530.9 | 530.9 | 1037.0 |
| 2024-05-22 04:40:00 | SPY | ETF | 530.9 | 530.9 | 530.9 | 530.9 | 326.0 |
| 2024-05-22 04:45:00 | SPY | ETF | 530.93 | 530.93 | 530.93 | 530.93 | 200.0 |
| 2024-05-22 04:55:00 | SPY | ETF | 530.83 | 530.83 | 530.73 | 530.73 | 1279.0 |
| 2024-05-22 05:35:00 | SPY | ETF | 530.6 | 530.6 | 530.6 | 530.6 | 100.0 |
| 2024-05-22 05:40:00 | SPY | ETF | 530.59 | 530.68 | 530.59 | 530.68 | 300.0 |
| 2024-05-22 05:45:00 | SPY | ETF | 530.59 | 530.72 | 530.59 | 530.72 | 513.0 |
| 2024-05-22 05:50:00 | SPY | ETF | 530.58 | 530.58 | 530.58 | 530.58 | 100.0 |
| 2024-05-22 06:00:00 | SPY | ETF | 530.67 | 530.69 | 530.67 | 530.69 | 200.0 |
| 2024-05-22 06:05:00 | SPY | ETF | 530.73 | 530.74 | 530.73 | 530.74 | 1100.0 |
| 2024-05-22 06:10:00 | SPY | ETF | 530.72 | 530.73 | 530.72 | 530.73 | 587.0 |
| 2024-05-22 06:15:00 | SPY | ETF | 530.73 | 530.73 | 530.73 | 530.73 | 722.0 |
| 2024-05-22 06:20:00 | SPY | ETF | 530.65 | 530.65 | 530.64 | 530.65 | 2214.0 |
| 2024-05-22 06:25:00 | SPY | ETF | 530.55 | 530.55 | 530.55 | 530.55 | 4300.0 |
| 2024-05-22 06:30:00 | SPY | ETF | 530.5 | 530.57 | 530.4 | 530.4 | 2205.0 |
| 2024-05-22 06:35:00 | SPY | ETF | 530.4 | 530.4 | 530.35 | 530.38 | 4651.0 |
| 2024-05-22 06:40:00 | SPY | ETF | 530.44 | 530.49 | 530.44 | 530.49 | 439.0 |
| 2024-05-22 06:45:00 | SPY | ETF | 530.5 | 530.5 | 530.49 | 530.49 | 725.0 |
| 2024-05-22 06:50:00 | SPY | ETF | 530.49 | 530.49 | 530.45 | 530.45 | 3013.0 |
| 2024-05-22 06:55:00 | SPY | ETF | 530.43 | 530.5 | 530.43 | 530.5 | 1825.0 |
| 2024-05-22 07:00:00 | SPY | ETF | 530.49 | 530.87 | 530.48 | 530.87 | 9188.0 |
| 2024-05-22 07:05:00 | SPY | ETF | 530.85 | 530.96 | 530.85 | 530.93 | 8822.0 |
| 2024-05-22 07:10:00 | SPY | ETF | 530.92 | 530.92 | 530.7 | 530.7 | 3500.0 |
| 2024-05-22 07:15:00 | SPY | ETF | 530.73 | 530.89 | 530.73 | 530.86 | 400.0 |
| 2024-05-22 07:20:00 | SPY | ETF | 530.85 | 530.85 | 530.78 | 530.8 | 5990.0 |
| 2024-05-22 07:25:00 | SPY | ETF | 530.84 | 530.84 | 530.8 | 530.8 | 3444.0 |
| 2024-05-22 07:30:00 | SPY | ETF | 530.8 | 530.85 | 530.72 | 530.8 | 20641.0 |
| 2024-05-22 07:35:00 | SPY | ETF | 530.82 | 530.82 | 530.63 | 530.63 | 6181.0 |
| 2024-05-22 07:40:00 | SPY | ETF | 530.61 | 530.66 | 530.61 | 530.66 | 2285.0 |
| 2024-05-22 07:45:00 | SPY | ETF | 530.66 | 530.69 | 530.62 | 530.63 | 14331.0 |
| 2024-05-22 07:50:00 | SPY | ETF | 530.599 | 530.6 | 530.46 | 530.46 | 10433.0 |
| 2024-05-22 07:55:00 | SPY | ETF | 530.48 | 530.48 | 530.38 | 530.38 | 54269.0 |
| 2024-05-22 08:00:00 | SPY | ETF | 530.89 | 531.54 | 530.37 | 530.5 | 33777.0 |
| 2024-05-22 08:05:00 | SPY | ETF | 530.55 | 530.59 | 530.51 | 530.51 | 5093.0 |
| 2024-05-22 08:10:00 | SPY | ETF | 530.5 | 530.51 | 530.42 | 530.42 | 10337.0 |
| 2024-05-22 08:15:00 | SPY | ETF | 530.36 | 530.53 | 530.35 | 530.53 | 5091.0 |
| 2024-05-22 08:20:00 | SPY | ETF | 530.55 | 530.56 | 530.52 | 530.53 | 1400.0 |
| 2024-05-22 08:25:00 | SPY | ETF | 530.53 | 530.53 | 530.43 | 530.43 | 5876.0 |
| 2024-05-22 08:30:00 | SPY | ETF | 530.47 | 530.49 | 530.46 | 530.49 | 2557.0 |
| 2024-05-22 08:35:00 | SPY | ETF | 530.46 | 530.57 | 530.37 | 530.57 | 4700.0 |
| 2024-05-22 08:40:00 | SPY | ETF | 530.52 | 530.61 | 530.52 | 530.61 | 6941.0 |
| 2024-05-22 08:45:00 | SPY | ETF | 530.59 | 530.69 | 530.59 | 530.66 | 15099.0 |
| 2024-05-22 08:50:00 | SPY | ETF | 530.62 | 530.64 | 530.54 | 530.63 | 17824.0 |
| 2024-05-22 08:55:00 | SPY | ETF | 530.64 | 530.65 | 530.6 | 530.6 | 7906.0 |
| 2024-05-22 09:00:00 | SPY | ETF | 530.6 | 530.68 | 530.58 | 530.68 | 17974.0 |
> showing 50 of 110,133 rows — these rows as CSV