PREVIEW / etf_5min / 2024-10-11
file: by_date/etf_5min/2024/2024-10-11.parquet size: 2.3 MB rows: 111,483
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-10-11 04:00:00 | SPY | ETF | 575.68 | 576.1 | 575.68 | 575.97 | 5173.0 |
| 2024-10-11 04:05:00 | SPY | ETF | 575.88 | 575.88 | 575.74 | 575.74 | 978.0 |
| 2024-10-11 04:10:00 | SPY | ETF | 575.75 | 575.75 | 575.61 | 575.61 | 901.0 |
| 2024-10-11 04:15:00 | SPY | ETF | 575.68 | 575.68 | 575.68 | 575.68 | 100.0 |
| 2024-10-11 04:20:00 | SPY | ETF | 575.65 | 575.88 | 575.6 | 575.88 | 2819.0 |
| 2024-10-11 04:25:00 | SPY | ETF | 575.81 | 575.82 | 575.81 | 575.82 | 456.0 |
| 2024-10-11 04:30:00 | SPY | ETF | 575.76 | 575.87 | 575.76 | 575.87 | 530.0 |
| 2024-10-11 04:40:00 | SPY | ETF | 575.76 | 575.77 | 575.65 | 575.72 | 1155.0 |
| 2024-10-11 04:45:00 | SPY | ETF | 575.42 | 575.42 | 575.31 | 575.31 | 420.0 |
| 2024-10-11 04:50:00 | SPY | ETF | 575.37 | 575.37 | 575.37 | 575.37 | 150.0 |
| 2024-10-11 04:55:00 | SPY | ETF | 575.4 | 575.41 | 575.27 | 575.28 | 2242.0 |
| 2024-10-11 05:00:00 | SPY | ETF | 575.37 | 575.6 | 575.28 | 575.6 | 1317.0 |
| 2024-10-11 05:05:00 | SPY | ETF | 575.6 | 575.74 | 575.6 | 575.74 | 778.0 |
| 2024-10-11 05:10:00 | SPY | ETF | 575.7 | 575.7 | 575.7 | 575.7 | 6843.0 |
| 2024-10-11 05:15:00 | SPY | ETF | 575.45 | 575.45 | 575.45 | 575.45 | 911.0 |
| 2024-10-11 05:20:00 | SPY | ETF | 575.45 | 575.55 | 575.41 | 575.48 | 3404.0 |
| 2024-10-11 05:25:00 | SPY | ETF | 575.5 | 575.5 | 575.5 | 575.5 | 276.0 |
| 2024-10-11 05:30:00 | SPY | ETF | 575.56 | 575.56 | 575.56 | 575.56 | 187.0 |
| 2024-10-11 05:45:00 | SPY | ETF | 575.42 | 575.5 | 575.42 | 575.5 | 2863.0 |
| 2024-10-11 05:50:00 | SPY | ETF | 575.49 | 575.49 | 575.4 | 575.4 | 2742.0 |
| 2024-10-11 05:55:00 | SPY | ETF | 575.3 | 575.3 | 575.3 | 575.3 | 2674.0 |
| 2024-10-11 06:00:00 | SPY | ETF | 575.35 | 575.42 | 575.35 | 575.42 | 1005.0 |
| 2024-10-11 06:10:00 | SPY | ETF | 575.45 | 575.56 | 575.45 | 575.56 | 600.0 |
| 2024-10-11 06:15:00 | SPY | ETF | 575.81 | 575.81 | 575.81 | 575.81 | 300.0 |
| 2024-10-11 06:20:00 | SPY | ETF | 575.75 | 575.75 | 575.75 | 575.75 | 187.0 |
| 2024-10-11 06:25:00 | SPY | ETF | 575.95 | 575.95 | 575.95 | 575.95 | 100.0 |
| 2024-10-11 06:30:00 | SPY | ETF | 575.76 | 575.76 | 575.76 | 575.76 | 3276.0 |
| 2024-10-11 06:45:00 | SPY | ETF | 575.8 | 576.0 | 575.8 | 575.9 | 4657.0 |
| 2024-10-11 06:50:00 | SPY | ETF | 575.83 | 576.12 | 575.74 | 576.12 | 2306.0 |
| 2024-10-11 06:55:00 | SPY | ETF | 576.01 | 576.28 | 576.01 | 576.25 | 5985.0 |
| 2024-10-11 07:00:00 | SPY | ETF | 576.18 | 576.3 | 576.13 | 576.25 | 4142.0 |
| 2024-10-11 07:05:00 | SPY | ETF | 576.32 | 576.33 | 576.17 | 576.17 | 3164.0 |
| 2024-10-11 07:10:00 | SPY | ETF | 576.19 | 576.23 | 576.16 | 576.17 | 1071.0 |
| 2024-10-11 07:15:00 | SPY | ETF | 576.14 | 576.17 | 576.01 | 576.01 | 2693.0 |
| 2024-10-11 07:20:00 | SPY | ETF | 576.04 | 576.04 | 576.0 | 576.0 | 965.0 |
| 2024-10-11 07:25:00 | SPY | ETF | 576.0 | 576.0 | 575.92 | 575.95 | 1978.0 |
| 2024-10-11 07:30:00 | SPY | ETF | 575.95 | 575.97 | 575.88 | 575.88 | 2058.0 |
| 2024-10-11 07:35:00 | SPY | ETF | 575.93 | 575.97 | 575.93 | 575.97 | 499.0 |
| 2024-10-11 07:40:00 | SPY | ETF | 575.92 | 576.0 | 575.9 | 576.0 | 9438.0 |
| 2024-10-11 07:45:00 | SPY | ETF | 576.03 | 576.03 | 575.88 | 576.0 | 12097.0 |
| 2024-10-11 07:50:00 | SPY | ETF | 575.99 | 575.99 | 575.86 | 575.86 | 2544.0 |
| 2024-10-11 07:55:00 | SPY | ETF | 575.91 | 575.97 | 575.88 | 575.88 | 8972.0 |
| 2024-10-11 08:00:00 | SPY | ETF | 576.0 | 576.83 | 575.38 | 575.89 | 18906.0 |
| 2024-10-11 08:05:00 | SPY | ETF | 575.89 | 576.4 | 575.87 | 576.4 | 23368.0 |
| 2024-10-11 08:10:00 | SPY | ETF | 576.41 | 576.65 | 576.27 | 576.4197 | 10464.0 |
| 2024-10-11 08:15:00 | SPY | ETF | 576.36 | 576.4094 | 576.34 | 576.34 | 4363.0 |
| 2024-10-11 08:20:00 | SPY | ETF | 576.32 | 576.34 | 576.25 | 576.34 | 5904.0 |
| 2024-10-11 08:25:00 | SPY | ETF | 576.312 | 576.38 | 576.25 | 576.29 | 2666.0 |
| 2024-10-11 08:30:00 | SPY | ETF | 576.43 | 577.0 | 576.0 | 576.9 | 158829.0 |
| 2024-10-11 08:35:00 | SPY | ETF | 576.75 | 576.81 | 576.08 | 576.13 | 25711.0 |
> showing 50 of 111,483 rows — these rows as CSV