PREVIEW / etf_5min / 2024-11-05
file: by_date/etf_5min/2024/2024-11-05.parquet size: 2.4 MB rows: 116,720
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-11-05 04:00:00 | SPY | ETF | 570.77 | 570.86 | 570.67 | 570.67 | 2868.0 |
| 2024-11-05 04:05:00 | SPY | ETF | 571.0 | 571.0 | 571.0 | 571.0 | 119.0 |
| 2024-11-05 04:10:00 | SPY | ETF | 571.08 | 571.08 | 571.0 | 571.0 | 795.0 |
| 2024-11-05 04:15:00 | SPY | ETF | 571.0 | 571.0 | 570.98 | 570.98 | 2175.0 |
| 2024-11-05 04:25:00 | SPY | ETF | 571.0 | 571.0 | 570.92 | 570.92 | 221.0 |
| 2024-11-05 04:30:00 | SPY | ETF | 570.86 | 570.95 | 570.82 | 570.95 | 1761.0 |
| 2024-11-05 04:35:00 | SPY | ETF | 570.84 | 571.06 | 570.84 | 571.05 | 3773.0 |
| 2024-11-05 04:45:00 | SPY | ETF | 570.99 | 570.99 | 570.84 | 570.91 | 2437.0 |
| 2024-11-05 04:55:00 | SPY | ETF | 570.86 | 570.91 | 570.86 | 570.91 | 600.0 |
| 2024-11-05 05:00:00 | SPY | ETF | 570.66 | 570.78 | 570.66 | 570.78 | 1300.0 |
| 2024-11-05 05:05:00 | SPY | ETF | 570.5 | 570.5 | 570.5 | 570.5 | 487.0 |
| 2024-11-05 05:10:00 | SPY | ETF | 570.48 | 570.5 | 570.48 | 570.5 | 693.0 |
| 2024-11-05 05:15:00 | SPY | ETF | 570.35 | 570.35 | 570.15 | 570.28 | 704.0 |
| 2024-11-05 05:25:00 | SPY | ETF | 570.81 | 570.82 | 570.75 | 570.75 | 1117.0 |
| 2024-11-05 05:40:00 | SPY | ETF | 570.68 | 570.68 | 570.68 | 570.68 | 100.0 |
| 2024-11-05 05:50:00 | SPY | ETF | 570.64 | 570.64 | 570.61 | 570.62 | 507.0 |
| 2024-11-05 05:55:00 | SPY | ETF | 570.75 | 570.75 | 570.75 | 570.75 | 200.0 |
| 2024-11-05 06:00:00 | SPY | ETF | 570.96 | 570.96 | 570.96 | 570.96 | 787.0 |
| 2024-11-05 06:05:00 | SPY | ETF | 571.06 | 571.09 | 570.98 | 570.98 | 2389.0 |
| 2024-11-05 06:10:00 | SPY | ETF | 571.0 | 571.04 | 571.0 | 571.04 | 873.0 |
| 2024-11-05 06:15:00 | SPY | ETF | 571.08 | 571.1 | 571.08 | 571.1 | 1592.0 |
| 2024-11-05 06:20:00 | SPY | ETF | 571.12 | 571.15 | 571.12 | 571.14 | 1982.0 |
| 2024-11-05 06:25:00 | SPY | ETF | 571.19 | 571.19 | 571.19 | 571.19 | 1200.0 |
| 2024-11-05 06:30:00 | SPY | ETF | 571.17 | 571.25 | 571.14 | 571.25 | 525.0 |
| 2024-11-05 06:35:00 | SPY | ETF | 571.24 | 571.24 | 571.24 | 571.24 | 317.0 |
| 2024-11-05 06:40:00 | SPY | ETF | 571.22 | 571.35 | 571.22 | 571.31 | 8866.0 |
| 2024-11-05 06:45:00 | SPY | ETF | 571.26 | 571.31 | 571.26 | 571.31 | 896.0 |
| 2024-11-05 06:55:00 | SPY | ETF | 571.13 | 571.16 | 571.13 | 571.16 | 587.0 |
| 2024-11-05 07:00:00 | SPY | ETF | 570.9 | 571.21 | 570.9 | 571.11 | 6408.0 |
| 2024-11-05 07:05:00 | SPY | ETF | 571.02 | 571.02 | 570.91 | 571.011 | 6090.0 |
| 2024-11-05 07:10:00 | SPY | ETF | 570.96 | 570.97 | 570.9 | 570.96 | 3485.0 |
| 2024-11-05 07:15:00 | SPY | ETF | 570.96 | 571.03 | 570.95 | 571.03 | 11366.0 |
| 2024-11-05 07:20:00 | SPY | ETF | 570.76 | 570.76 | 570.6 | 570.6 | 16523.0 |
| 2024-11-05 07:25:00 | SPY | ETF | 570.62 | 570.65 | 570.49 | 570.49 | 17683.0 |
| 2024-11-05 07:30:00 | SPY | ETF | 570.54 | 570.7 | 570.54 | 570.55 | 1924.0 |
| 2024-11-05 07:35:00 | SPY | ETF | 570.5 | 570.5 | 570.34 | 570.36 | 9066.0 |
| 2024-11-05 07:40:00 | SPY | ETF | 570.44 | 570.5 | 570.4 | 570.4 | 11421.0 |
| 2024-11-05 07:45:00 | SPY | ETF | 570.52 | 570.57 | 570.49 | 570.49 | 13451.0 |
| 2024-11-05 07:50:00 | SPY | ETF | 570.85 | 570.85 | 570.62 | 570.7 | 5449.0 |
| 2024-11-05 07:55:00 | SPY | ETF | 570.69 | 570.69 | 570.69 | 570.69 | 4085.0 |
| 2024-11-05 08:00:00 | SPY | ETF | 571.01 | 571.15 | 569.93 | 570.8 | 42979.0 |
| 2024-11-05 08:05:00 | SPY | ETF | 570.88 | 570.88 | 570.75 | 570.75 | 723.0 |
| 2024-11-05 08:10:00 | SPY | ETF | 570.74 | 570.74 | 570.48 | 570.48 | 3959.0 |
| 2024-11-05 08:15:00 | SPY | ETF | 570.52 | 570.67 | 570.52 | 570.65 | 8241.0 |
| 2024-11-05 08:20:00 | SPY | ETF | 570.621 | 570.83 | 570.621 | 570.83 | 10899.0 |
| 2024-11-05 08:25:00 | SPY | ETF | 570.78 | 570.94 | 570.78 | 570.94 | 1460.0 |
| 2024-11-05 08:30:00 | SPY | ETF | 570.95 | 571.1 | 570.9101 | 571.07 | 17472.0 |
| 2024-11-05 08:35:00 | SPY | ETF | 571.08 | 571.08 | 571.0 | 571.05 | 12931.0 |
| 2024-11-05 08:40:00 | SPY | ETF | 571.01 | 571.09 | 570.95 | 571.09 | 500.0 |
| 2024-11-05 08:45:00 | SPY | ETF | 571.05 | 571.06 | 570.92 | 571.06 | 3938.0 |
> showing 50 of 116,720 rows — these rows as CSV