PREVIEW / etf_5min / 2025-05-09
file: by_date/etf_5min/2025/2025-05-09.parquet size: 2.6 MB rows: 127,526
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 |
|---|---|---|---|---|---|---|---|
| 2025-05-09 04:00:00 | SPY | ETF | 565.38 | 565.6 | 565.36 | 565.54 | 5362.0 |
| 2025-05-09 04:05:00 | SPY | ETF | 565.5 | 565.54 | 565.46 | 565.46 | 700.0 |
| 2025-05-09 04:10:00 | SPY | ETF | 565.45 | 565.45 | 565.13 | 565.13 | 711.0 |
| 2025-05-09 04:15:00 | SPY | ETF | 565.09 | 565.09 | 564.79 | 564.98 | 1288.0 |
| 2025-05-09 04:20:00 | SPY | ETF | 565.02 | 565.02 | 565.02 | 565.02 | 800.0 |
| 2025-05-09 04:25:00 | SPY | ETF | 565.07 | 565.5 | 565.07 | 565.5 | 770.0 |
| 2025-05-09 04:30:00 | SPY | ETF | 565.47 | 565.47 | 565.38 | 565.46 | 300.0 |
| 2025-05-09 04:35:00 | SPY | ETF | 565.42 | 565.42 | 565.07 | 565.15 | 1885.0 |
| 2025-05-09 04:40:00 | SPY | ETF | 565.09 | 565.09 | 565.09 | 565.09 | 203.0 |
| 2025-05-09 04:45:00 | SPY | ETF | 565.08 | 565.08 | 565.08 | 565.08 | 488.0 |
| 2025-05-09 04:50:00 | SPY | ETF | 565.1 | 565.1 | 565.05 | 565.05 | 300.0 |
| 2025-05-09 04:55:00 | SPY | ETF | 565.01 | 565.01 | 565.01 | 565.01 | 128.0 |
| 2025-05-09 05:00:00 | SPY | ETF | 565.28 | 565.31 | 565.28 | 565.31 | 500.0 |
| 2025-05-09 05:05:00 | SPY | ETF | 565.4 | 565.4 | 565.4 | 565.4 | 185.0 |
| 2025-05-09 05:10:00 | SPY | ETF | 565.5 | 565.5 | 565.48 | 565.48 | 200.0 |
| 2025-05-09 05:15:00 | SPY | ETF | 565.45 | 565.47 | 565.28 | 565.47 | 900.0 |
| 2025-05-09 05:20:00 | SPY | ETF | 565.54 | 565.54 | 565.43 | 565.53 | 318.0 |
| 2025-05-09 05:25:00 | SPY | ETF | 565.49 | 565.49 | 565.31 | 565.31 | 1200.0 |
| 2025-05-09 05:30:00 | SPY | ETF | 565.21 | 565.35 | 565.19 | 565.32 | 881.0 |
| 2025-05-09 05:35:00 | SPY | ETF | 565.3 | 565.51 | 565.29 | 565.5 | 2040.0 |
| 2025-05-09 05:40:00 | SPY | ETF | 565.65 | 565.65 | 565.65 | 565.65 | 266.0 |
| 2025-05-09 05:45:00 | SPY | ETF | 565.63 | 565.63 | 565.63 | 565.63 | 198.0 |
| 2025-05-09 05:50:00 | SPY | ETF | 565.75 | 565.75 | 565.68 | 565.68 | 400.0 |
| 2025-05-09 05:55:00 | SPY | ETF | 565.76 | 565.77 | 565.75 | 565.77 | 655.0 |
| 2025-05-09 06:00:00 | SPY | ETF | 566.03 | 566.03 | 566.03 | 566.03 | 100.0 |
| 2025-05-09 06:05:00 | SPY | ETF | 566.1 | 566.2 | 566.08 | 566.2 | 1571.0 |
| 2025-05-09 06:10:00 | SPY | ETF | 566.25 | 566.39 | 566.2 | 566.39 | 2624.0 |
| 2025-05-09 06:15:00 | SPY | ETF | 566.4 | 566.56 | 566.39 | 566.56 | 1500.0 |
| 2025-05-09 06:20:00 | SPY | ETF | 566.46 | 566.46 | 566.38 | 566.39 | 483.0 |
| 2025-05-09 06:25:00 | SPY | ETF | 566.34 | 566.4 | 566.3 | 566.4 | 12319.0 |
| 2025-05-09 06:30:00 | SPY | ETF | 566.56 | 566.78 | 566.56 | 566.68 | 9411.0 |
| 2025-05-09 06:35:00 | SPY | ETF | 566.73 | 566.73 | 566.66 | 566.7 | 4359.0 |
| 2025-05-09 06:40:00 | SPY | ETF | 566.74 | 566.81 | 566.54 | 566.56 | 9574.0 |
| 2025-05-09 06:45:00 | SPY | ETF | 566.59 | 566.67 | 566.52 | 566.6 | 3004.0 |
| 2025-05-09 06:50:00 | SPY | ETF | 566.56 | 566.6 | 566.5 | 566.5 | 900.0 |
| 2025-05-09 06:55:00 | SPY | ETF | 566.59 | 566.62 | 566.59 | 566.62 | 595.0 |
| 2025-05-09 07:00:00 | SPY | ETF | 566.57 | 566.57 | 566.42 | 566.47 | 8564.0 |
| 2025-05-09 07:05:00 | SPY | ETF | 566.43 | 566.8 | 566.39 | 566.69 | 10731.0 |
| 2025-05-09 07:10:00 | SPY | ETF | 566.76 | 566.94 | 566.76 | 566.94 | 11439.0 |
| 2025-05-09 07:15:00 | SPY | ETF | 566.95 | 567.03 | 566.85 | 566.99 | 23254.0 |
| 2025-05-09 07:20:00 | SPY | ETF | 566.87 | 566.92 | 566.81 | 566.9 | 6663.0 |
| 2025-05-09 07:25:00 | SPY | ETF | 566.91 | 567.99 | 564.14 | 565.81 | 434532.0 |
| 2025-05-09 07:30:00 | SPY | ETF | 565.71 | 566.43 | 565.29 | 565.37 | 144096.0 |
| 2025-05-09 07:35:00 | SPY | ETF | 565.55 | 565.75 | 564.92 | 565.3 | 48990.0 |
| 2025-05-09 07:40:00 | SPY | ETF | 565.3 | 566.09 | 565.1 | 566.09 | 28349.0 |
| 2025-05-09 07:45:00 | SPY | ETF | 566.05 | 566.84 | 566.05 | 566.44 | 93154.0 |
| 2025-05-09 07:50:00 | SPY | ETF | 566.39 | 566.44 | 566.06 | 566.06 | 7577.0 |
| 2025-05-09 07:55:00 | SPY | ETF | 566.36 | 566.38 | 566.12 | 566.22 | 6213.0 |
| 2025-05-09 08:00:00 | SPY | ETF | 566.13 | 567.63 | 564.2 | 566.5 | 147371.0 |
| 2025-05-09 08:05:00 | SPY | ETF | 566.55 | 566.78 | 566.5 | 566.5 | 9770.0 |
> showing 50 of 127,526 rows — these rows as CSV