PREVIEW / etf_5min / 2024-03-25
file: by_date/etf_5min/2024/2024-03-25.parquet size: 2.1 MB rows: 108,073
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-25 04:00:00 | SPY | ETF | 520.85 | 521.08 | 520.85 | 521.08 | 3417.0 |
| 2024-03-25 04:05:00 | SPY | ETF | 521.1 | 521.18 | 521.0 | 521.18 | 5048.0 |
| 2024-03-25 04:10:00 | SPY | ETF | 521.14 | 521.25 | 521.1 | 521.1 | 2475.0 |
| 2024-03-25 04:20:00 | SPY | ETF | 521.15 | 521.15 | 520.91 | 521.05 | 2000.0 |
| 2024-03-25 04:25:00 | SPY | ETF | 521.04 | 521.15 | 521.04 | 521.15 | 569.0 |
| 2024-03-25 04:30:00 | SPY | ETF | 521.22 | 521.35 | 521.14 | 521.34 | 2946.0 |
| 2024-03-25 04:35:00 | SPY | ETF | 521.38 | 521.38 | 521.15 | 521.15 | 1079.0 |
| 2024-03-25 04:50:00 | SPY | ETF | 521.08 | 521.08 | 521.07 | 521.07 | 900.0 |
| 2024-03-25 04:55:00 | SPY | ETF | 521.1 | 521.1 | 521.1 | 521.1 | 600.0 |
| 2024-03-25 05:00:00 | SPY | ETF | 521.08 | 521.13 | 521.08 | 521.13 | 346.0 |
| 2024-03-25 05:05:00 | SPY | ETF | 520.91 | 520.91 | 520.8 | 520.83 | 5062.0 |
| 2024-03-25 05:15:00 | SPY | ETF | 520.86 | 520.86 | 520.79 | 520.79 | 321.0 |
| 2024-03-25 05:20:00 | SPY | ETF | 520.88 | 520.89 | 520.88 | 520.89 | 2900.0 |
| 2024-03-25 05:25:00 | SPY | ETF | 520.8 | 520.8 | 520.74 | 520.74 | 1400.0 |
| 2024-03-25 05:40:00 | SPY | ETF | 520.72 | 520.72 | 520.68 | 520.68 | 2125.0 |
| 2024-03-25 05:45:00 | SPY | ETF | 520.78 | 520.78 | 520.78 | 520.78 | 200.0 |
| 2024-03-25 05:50:00 | SPY | ETF | 520.77 | 520.77 | 520.6 | 520.6 | 798.0 |
| 2024-03-25 05:55:00 | SPY | ETF | 520.54 | 520.54 | 520.28 | 520.3 | 1988.0 |
| 2024-03-25 06:00:00 | SPY | ETF | 520.28 | 520.39 | 520.28 | 520.38 | 750.0 |
| 2024-03-25 06:05:00 | SPY | ETF | 520.42 | 520.42 | 520.32 | 520.32 | 2477.0 |
| 2024-03-25 06:10:00 | SPY | ETF | 520.32 | 520.33 | 520.1 | 520.1 | 4500.0 |
| 2024-03-25 06:15:00 | SPY | ETF | 520.08 | 520.23 | 520.06 | 520.23 | 2487.0 |
| 2024-03-25 06:25:00 | SPY | ETF | 520.21 | 520.21 | 520.21 | 520.21 | 200.0 |
| 2024-03-25 06:30:00 | SPY | ETF | 520.23 | 520.23 | 520.23 | 520.23 | 200.0 |
| 2024-03-25 06:40:00 | SPY | ETF | 520.17 | 520.17 | 520.17 | 520.17 | 100.0 |
| 2024-03-25 06:45:00 | SPY | ETF | 520.08 | 520.11 | 520.07 | 520.07 | 10350.0 |
| 2024-03-25 06:50:00 | SPY | ETF | 520.07 | 520.15 | 520.07 | 520.15 | 1734.0 |
| 2024-03-25 06:55:00 | SPY | ETF | 520.11 | 520.11 | 520.03 | 520.08 | 1153.0 |
| 2024-03-25 07:00:00 | SPY | ETF | 520.13 | 520.13 | 519.84 | 519.88 | 7147.0 |
| 2024-03-25 07:05:00 | SPY | ETF | 519.75 | 519.84 | 519.7 | 519.84 | 8253.0 |
| 2024-03-25 07:10:00 | SPY | ETF | 519.69 | 519.8 | 519.64 | 519.8 | 13500.0 |
| 2024-03-25 07:15:00 | SPY | ETF | 519.8 | 519.8 | 519.73 | 519.73 | 1585.0 |
| 2024-03-25 07:20:00 | SPY | ETF | 519.7 | 519.71 | 519.52 | 519.65 | 3996.0 |
| 2024-03-25 07:25:00 | SPY | ETF | 519.65 | 519.7 | 519.56 | 519.65 | 3600.0 |
| 2024-03-25 07:30:00 | SPY | ETF | 519.65 | 519.73 | 519.65 | 519.65 | 3640.0 |
| 2024-03-25 07:35:00 | SPY | ETF | 519.65 | 519.8 | 519.61 | 519.68 | 36982.0 |
| 2024-03-25 07:40:00 | SPY | ETF | 519.64 | 519.65 | 519.6 | 519.6 | 2500.0 |
| 2024-03-25 07:45:00 | SPY | ETF | 519.69 | 519.72 | 519.61 | 519.631 | 11413.0 |
| 2024-03-25 07:50:00 | SPY | ETF | 519.52 | 519.58 | 519.39 | 519.58 | 4048.0 |
| 2024-03-25 07:55:00 | SPY | ETF | 519.62 | 519.66 | 519.58 | 519.66 | 6925.0 |
| 2024-03-25 08:00:00 | SPY | ETF | 519.79 | 520.84 | 519.49 | 519.8 | 27685.0 |
| 2024-03-25 08:05:00 | SPY | ETF | 519.79 | 521.12 | 519.6 | 519.6 | 7671.0 |
| 2024-03-25 08:10:00 | SPY | ETF | 519.59 | 519.62 | 519.5 | 519.56 | 7925.0 |
| 2024-03-25 08:15:00 | SPY | ETF | 519.61 | 519.86 | 519.61 | 519.85 | 8899.0 |
| 2024-03-25 08:20:00 | SPY | ETF | 519.83 | 519.95 | 519.83 | 519.95 | 5703.0 |
| 2024-03-25 08:25:00 | SPY | ETF | 519.95 | 519.95 | 519.8 | 519.9 | 8024.0 |
| 2024-03-25 08:30:00 | SPY | ETF | 519.92 | 519.95 | 519.85 | 519.9 | 9261.0 |
| 2024-03-25 08:35:00 | SPY | ETF | 519.9 | 519.9 | 519.64 | 519.7 | 12511.0 |
| 2024-03-25 08:40:00 | SPY | ETF | 519.76 | 519.94 | 519.73 | 519.94 | 23485.0 |
| 2024-03-25 08:45:00 | SPY | ETF | 519.95 | 519.98 | 519.9 | 519.9 | 3576.0 |
> showing 50 of 108,073 rows — these rows as CSV