PREVIEW / etf_5min / 2024-03-14
file: by_date/etf_5min/2024/2024-03-14.parquet size: 2.2 MB rows: 109,948
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-03-14 04:00:00 | SPY | ETF | 517.0 | 517.49 | 517.0 | 517.48 | 18429.0 |
| 2024-03-14 04:05:00 | SPY | ETF | 517.48 | 517.62 | 517.43 | 517.59 | 3810.0 |
| 2024-03-14 04:10:00 | SPY | ETF | 517.64 | 517.81 | 517.64 | 517.81 | 8983.0 |
| 2024-03-14 04:15:00 | SPY | ETF | 517.73 | 517.96 | 517.73 | 517.96 | 3435.0 |
| 2024-03-14 04:20:00 | SPY | ETF | 517.94 | 518.0 | 517.94 | 518.0 | 600.0 |
| 2024-03-14 04:25:00 | SPY | ETF | 517.92 | 517.97 | 517.92 | 517.96 | 2191.0 |
| 2024-03-14 04:30:00 | SPY | ETF | 517.85 | 517.89 | 517.8 | 517.8 | 2990.0 |
| 2024-03-14 04:35:00 | SPY | ETF | 517.86 | 517.95 | 517.86 | 517.95 | 771.0 |
| 2024-03-14 04:40:00 | SPY | ETF | 517.92 | 517.92 | 517.7 | 517.7 | 1490.0 |
| 2024-03-14 05:00:00 | SPY | ETF | 517.91 | 517.91 | 517.91 | 517.91 | 200.0 |
| 2024-03-14 05:05:00 | SPY | ETF | 517.88 | 517.92 | 517.87 | 517.92 | 1385.0 |
| 2024-03-14 05:10:00 | SPY | ETF | 517.93 | 518.0 | 517.89 | 517.96 | 594.0 |
| 2024-03-14 05:15:00 | SPY | ETF | 517.9 | 517.91 | 517.77 | 517.81 | 1000.0 |
| 2024-03-14 05:20:00 | SPY | ETF | 517.88 | 517.91 | 517.87 | 517.91 | 850.0 |
| 2024-03-14 05:25:00 | SPY | ETF | 518.0 | 518.0 | 517.9 | 517.91 | 1100.0 |
| 2024-03-14 05:30:00 | SPY | ETF | 518.0 | 518.07 | 518.0 | 518.01 | 799.0 |
| 2024-03-14 05:35:00 | SPY | ETF | 518.08 | 518.08 | 518.01 | 518.04 | 300.0 |
| 2024-03-14 05:40:00 | SPY | ETF | 518.05 | 518.12 | 518.03 | 518.07 | 1247.0 |
| 2024-03-14 05:45:00 | SPY | ETF | 518.01 | 518.01 | 518.01 | 518.01 | 100.0 |
| 2024-03-14 05:50:00 | SPY | ETF | 517.91 | 517.91 | 517.87 | 517.89 | 1600.0 |
| 2024-03-14 05:55:00 | SPY | ETF | 517.88 | 517.88 | 517.88 | 517.88 | 1100.0 |
| 2024-03-14 06:00:00 | SPY | ETF | 518.0 | 518.0 | 517.8 | 517.87 | 5709.0 |
| 2024-03-14 06:05:00 | SPY | ETF | 517.98 | 518.05 | 517.98 | 518.05 | 300.0 |
| 2024-03-14 06:10:00 | SPY | ETF | 517.93 | 517.93 | 517.93 | 517.93 | 400.0 |
| 2024-03-14 06:15:00 | SPY | ETF | 518.01 | 518.01 | 518.01 | 518.01 | 400.0 |
| 2024-03-14 06:20:00 | SPY | ETF | 518.02 | 518.02 | 518.02 | 518.02 | 573.0 |
| 2024-03-14 06:35:00 | SPY | ETF | 518.0 | 518.0 | 517.95 | 517.95 | 200.0 |
| 2024-03-14 06:40:00 | SPY | ETF | 517.88 | 517.88 | 517.81 | 517.81 | 600.0 |
| 2024-03-14 06:45:00 | SPY | ETF | 517.77 | 517.77 | 517.73 | 517.73 | 316.0 |
| 2024-03-14 06:50:00 | SPY | ETF | 517.78 | 517.78 | 517.78 | 517.78 | 200.0 |
| 2024-03-14 06:55:00 | SPY | ETF | 517.96 | 517.96 | 517.96 | 517.96 | 100.0 |
| 2024-03-14 07:00:00 | SPY | ETF | 517.94 | 517.97 | 517.82 | 517.97 | 5569.0 |
| 2024-03-14 07:05:00 | SPY | ETF | 517.99 | 518.0 | 517.91 | 517.97 | 2838.0 |
| 2024-03-14 07:10:00 | SPY | ETF | 517.99 | 518.01 | 517.97 | 517.98 | 17871.0 |
| 2024-03-14 07:15:00 | SPY | ETF | 517.98 | 518.21 | 517.97 | 518.21 | 10789.0 |
| 2024-03-14 07:20:00 | SPY | ETF | 518.25 | 518.32 | 518.2 | 518.2 | 12534.0 |
| 2024-03-14 07:25:00 | SPY | ETF | 518.1 | 518.1 | 517.97 | 518.03 | 8115.0 |
| 2024-03-14 07:30:00 | SPY | ETF | 517.971 | 517.98 | 517.86 | 517.93 | 19866.0 |
| 2024-03-14 07:35:00 | SPY | ETF | 517.94 | 517.94 | 517.85 | 517.91 | 7841.0 |
| 2024-03-14 07:40:00 | SPY | ETF | 517.89 | 517.92 | 517.84 | 517.87 | 3677.0 |
| 2024-03-14 07:45:00 | SPY | ETF | 517.87 | 517.88 | 517.78 | 517.84 | 11689.0 |
| 2024-03-14 07:50:00 | SPY | ETF | 517.84 | 517.87 | 517.8 | 517.82 | 1531.0 |
| 2024-03-14 07:55:00 | SPY | ETF | 517.84 | 517.85 | 517.83 | 517.85 | 4763.0 |
| 2024-03-14 08:00:00 | SPY | ETF | 517.87 | 518.31 | 516.8 | 517.93 | 56736.0 |
| 2024-03-14 08:05:00 | SPY | ETF | 516.71 | 517.9 | 516.71 | 517.9 | 14665.0 |
| 2024-03-14 08:10:00 | SPY | ETF | 517.86 | 517.87 | 517.82 | 517.82 | 9471.0 |
| 2024-03-14 08:15:00 | SPY | ETF | 517.84 | 517.96 | 517.82 | 517.92 | 11735.0 |
| 2024-03-14 08:20:00 | SPY | ETF | 517.87 | 517.87 | 517.75 | 517.75 | 25932.0 |
| 2024-03-14 08:25:00 | SPY | ETF | 517.75 | 517.96 | 517.7 | 517.92 | 20166.0 |
| 2024-03-14 08:30:00 | SPY | ETF | 518.07 | 518.13 | 516.87 | 517.25 | 202559.0 |
> showing 50 of 109,948 rows — these rows as CSV