PREVIEW / etf_5min / 2024-08-21
file: by_date/etf_5min/2024/2024-08-21.parquet size: 2.2 MB rows: 110,101
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-08-21 04:00:00 | SPY | ETF | 559.0 | 559.05 | 558.9 | 558.94 | 852.0 |
| 2024-08-21 04:05:00 | SPY | ETF | 558.86 | 558.86 | 558.86 | 558.86 | 100.0 |
| 2024-08-21 04:10:00 | SPY | ETF | 558.89 | 558.89 | 558.85 | 558.85 | 300.0 |
| 2024-08-21 04:15:00 | SPY | ETF | 558.95 | 559.12 | 558.95 | 559.12 | 1290.0 |
| 2024-08-21 04:20:00 | SPY | ETF | 559.14 | 559.21 | 558.82 | 558.89 | 1050.0 |
| 2024-08-21 04:25:00 | SPY | ETF | 558.7 | 558.7 | 558.62 | 558.65 | 816.0 |
| 2024-08-21 04:30:00 | SPY | ETF | 558.74 | 558.78 | 558.68 | 558.68 | 2253.0 |
| 2024-08-21 04:35:00 | SPY | ETF | 558.77 | 558.77 | 558.77 | 558.77 | 291.0 |
| 2024-08-21 04:45:00 | SPY | ETF | 558.91 | 558.97 | 558.91 | 558.97 | 200.0 |
| 2024-08-21 04:50:00 | SPY | ETF | 558.79 | 558.88 | 558.79 | 558.88 | 500.0 |
| 2024-08-21 04:55:00 | SPY | ETF | 558.69 | 558.71 | 558.69 | 558.71 | 307.0 |
| 2024-08-21 05:00:00 | SPY | ETF | 558.64 | 558.68 | 558.63 | 558.63 | 1997.0 |
| 2024-08-21 05:05:00 | SPY | ETF | 558.74 | 558.87 | 558.74 | 558.87 | 2100.0 |
| 2024-08-21 05:10:00 | SPY | ETF | 558.93 | 558.93 | 558.87 | 558.87 | 200.0 |
| 2024-08-21 05:15:00 | SPY | ETF | 558.78 | 558.78 | 558.78 | 558.78 | 100.0 |
| 2024-08-21 05:30:00 | SPY | ETF | 558.69 | 558.69 | 558.69 | 558.69 | 141.0 |
| 2024-08-21 05:35:00 | SPY | ETF | 558.77 | 558.87 | 558.77 | 558.87 | 304.0 |
| 2024-08-21 05:40:00 | SPY | ETF | 558.9 | 558.96 | 558.9 | 558.96 | 549.0 |
| 2024-08-21 05:50:00 | SPY | ETF | 558.77 | 558.77 | 558.6 | 558.6 | 730.0 |
| 2024-08-21 06:00:00 | SPY | ETF | 558.76 | 558.8 | 558.76 | 558.8 | 650.0 |
| 2024-08-21 06:10:00 | SPY | ETF | 559.03 | 559.03 | 558.99 | 558.99 | 310.0 |
| 2024-08-21 06:15:00 | SPY | ETF | 558.99 | 558.99 | 558.99 | 558.99 | 699.0 |
| 2024-08-21 06:20:00 | SPY | ETF | 558.97 | 558.97 | 558.97 | 558.97 | 298.0 |
| 2024-08-21 06:30:00 | SPY | ETF | 558.97 | 559.32 | 558.97 | 559.3 | 18031.0 |
| 2024-08-21 06:35:00 | SPY | ETF | 559.21 | 559.21 | 559.21 | 559.21 | 1006.0 |
| 2024-08-21 06:40:00 | SPY | ETF | 559.22 | 559.32 | 559.22 | 559.23 | 3097.0 |
| 2024-08-21 06:45:00 | SPY | ETF | 559.22 | 559.49 | 559.21 | 559.49 | 3000.0 |
| 2024-08-21 06:50:00 | SPY | ETF | 559.48 | 559.53 | 559.48 | 559.5 | 2418.0 |
| 2024-08-21 06:55:00 | SPY | ETF | 559.6 | 559.6 | 559.52 | 559.6 | 2700.0 |
| 2024-08-21 07:00:00 | SPY | ETF | 559.55 | 559.81 | 559.26 | 559.69 | 146682.0 |
| 2024-08-21 07:05:00 | SPY | ETF | 559.7 | 559.74 | 559.56 | 559.62 | 5470.0 |
| 2024-08-21 07:10:00 | SPY | ETF | 559.67 | 559.69 | 559.58 | 559.69 | 1853.0 |
| 2024-08-21 07:15:00 | SPY | ETF | 559.63 | 559.66 | 559.59 | 559.66 | 12474.0 |
| 2024-08-21 07:20:00 | SPY | ETF | 559.58 | 559.58 | 559.5 | 559.5 | 2392.0 |
| 2024-08-21 07:25:00 | SPY | ETF | 559.53 | 559.61 | 559.53 | 559.61 | 960.0 |
| 2024-08-21 07:30:00 | SPY | ETF | 559.47 | 559.56 | 559.46 | 559.56 | 785.0 |
| 2024-08-21 07:35:00 | SPY | ETF | 559.54 | 559.74 | 559.54 | 559.62 | 4168.0 |
| 2024-08-21 07:40:00 | SPY | ETF | 559.55 | 559.55 | 559.44 | 559.44 | 2646.0 |
| 2024-08-21 07:45:00 | SPY | ETF | 559.42 | 559.43 | 559.33 | 559.39 | 4788.0 |
| 2024-08-21 07:50:00 | SPY | ETF | 559.38 | 559.54 | 559.38 | 559.5 | 2793.0 |
| 2024-08-21 07:55:00 | SPY | ETF | 559.5 | 559.55 | 559.5 | 559.52 | 2500.0 |
| 2024-08-21 08:00:00 | SPY | ETF | 559.52 | 559.78 | 558.99 | 559.4 | 21141.0 |
| 2024-08-21 08:05:00 | SPY | ETF | 559.42 | 559.45 | 559.35 | 559.45 | 3550.0 |
| 2024-08-21 08:10:00 | SPY | ETF | 559.38 | 559.52 | 559.38 | 559.52 | 1653.0 |
| 2024-08-21 08:15:00 | SPY | ETF | 559.5 | 559.5996 | 559.39 | 559.5996 | 2527.0 |
| 2024-08-21 08:20:00 | SPY | ETF | 559.61 | 559.71 | 559.61 | 559.7 | 3548.0 |
| 2024-08-21 08:25:00 | SPY | ETF | 559.72 | 559.95 | 559.72 | 559.94 | 112184.0 |
| 2024-08-21 08:30:00 | SPY | ETF | 559.95 | 559.98 | 559.72 | 559.72 | 31120.0 |
| 2024-08-21 08:35:00 | SPY | ETF | 559.8 | 559.8 | 559.68 | 559.68 | 2437.0 |
| 2024-08-21 08:40:00 | SPY | ETF | 559.7109 | 559.89 | 559.68 | 559.84 | 13117.0 |
> showing 50 of 110,101 rows — these rows as CSV