PREVIEW / etf_5min / 2024-08-30
file: by_date/etf_5min/2024/2024-08-30.parquet size: 2.2 MB rows: 107,689
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-08-30 04:00:00 | SPY | ETF | 560.76 | 560.99 | 560.76 | 560.99 | 1200.0 |
| 2024-08-30 04:05:00 | SPY | ETF | 560.86 | 560.9 | 560.71 | 560.71 | 1270.0 |
| 2024-08-30 04:10:00 | SPY | ETF | 560.73 | 560.85 | 560.73 | 560.85 | 3081.0 |
| 2024-08-30 04:15:00 | SPY | ETF | 560.9 | 561.09 | 560.9 | 561.09 | 870.0 |
| 2024-08-30 04:25:00 | SPY | ETF | 560.93 | 561.04 | 560.93 | 560.98 | 1109.0 |
| 2024-08-30 04:30:00 | SPY | ETF | 560.99 | 560.99 | 560.99 | 560.99 | 100.0 |
| 2024-08-30 04:35:00 | SPY | ETF | 560.98 | 560.98 | 560.9 | 560.9 | 600.0 |
| 2024-08-30 04:50:00 | SPY | ETF | 560.85 | 560.87 | 560.85 | 560.87 | 200.0 |
| 2024-08-30 04:55:00 | SPY | ETF | 560.87 | 560.87 | 560.87 | 560.87 | 200.0 |
| 2024-08-30 05:00:00 | SPY | ETF | 561.0 | 561.0 | 561.0 | 561.0 | 100.0 |
| 2024-08-30 05:05:00 | SPY | ETF | 560.8 | 560.8 | 560.8 | 560.8 | 300.0 |
| 2024-08-30 05:10:00 | SPY | ETF | 560.9 | 560.98 | 560.9 | 560.98 | 800.0 |
| 2024-08-30 05:15:00 | SPY | ETF | 560.94 | 560.95 | 560.94 | 560.95 | 500.0 |
| 2024-08-30 05:20:00 | SPY | ETF | 560.87 | 560.87 | 560.87 | 560.87 | 100.0 |
| 2024-08-30 05:30:00 | SPY | ETF | 560.72 | 560.81 | 560.71 | 560.81 | 310.0 |
| 2024-08-30 05:35:00 | SPY | ETF | 560.76 | 560.8 | 560.75 | 560.8 | 750.0 |
| 2024-08-30 05:40:00 | SPY | ETF | 560.8 | 560.8 | 560.8 | 560.8 | 676.0 |
| 2024-08-30 05:45:00 | SPY | ETF | 560.81 | 560.89 | 560.81 | 560.89 | 343.0 |
| 2024-08-30 05:50:00 | SPY | ETF | 560.87 | 560.94 | 560.87 | 560.94 | 278.0 |
| 2024-08-30 05:55:00 | SPY | ETF | 560.96 | 560.96 | 560.96 | 560.96 | 100.0 |
| 2024-08-30 06:00:00 | SPY | ETF | 561.0 | 561.0 | 560.88 | 560.88 | 300.0 |
| 2024-08-30 06:05:00 | SPY | ETF | 560.91 | 560.91 | 560.88 | 560.88 | 443.0 |
| 2024-08-30 06:10:00 | SPY | ETF | 560.83 | 560.83 | 560.83 | 560.83 | 100.0 |
| 2024-08-30 06:15:00 | SPY | ETF | 560.88 | 560.88 | 560.76 | 560.79 | 1022.0 |
| 2024-08-30 06:25:00 | SPY | ETF | 560.74 | 560.75 | 560.68 | 560.75 | 619.0 |
| 2024-08-30 06:30:00 | SPY | ETF | 560.75 | 560.75 | 560.75 | 560.75 | 100.0 |
| 2024-08-30 06:35:00 | SPY | ETF | 560.35 | 560.51 | 560.35 | 560.46 | 2240.0 |
| 2024-08-30 06:40:00 | SPY | ETF | 560.5 | 560.65 | 560.5 | 560.65 | 700.0 |
| 2024-08-30 06:45:00 | SPY | ETF | 560.68 | 560.72 | 560.65 | 560.65 | 337.0 |
| 2024-08-30 06:50:00 | SPY | ETF | 560.86 | 561.0 | 560.86 | 560.99 | 1355.0 |
| 2024-08-30 06:55:00 | SPY | ETF | 561.08 | 561.31 | 561.03 | 561.31 | 2067.0 |
| 2024-08-30 07:00:00 | SPY | ETF | 561.28 | 561.34 | 560.94 | 561.14 | 76291.0 |
| 2024-08-30 07:05:00 | SPY | ETF | 561.19 | 561.19 | 561.01 | 561.09 | 5034.0 |
| 2024-08-30 07:10:00 | SPY | ETF | 561.1 | 561.16 | 561.04 | 561.08 | 1550.0 |
| 2024-08-30 07:15:00 | SPY | ETF | 561.09 | 561.27 | 561.09 | 561.15 | 800.0 |
| 2024-08-30 07:20:00 | SPY | ETF | 561.2 | 561.2 | 561.14 | 561.16 | 1000.0 |
| 2024-08-30 07:25:00 | SPY | ETF | 561.1 | 561.15 | 561.04 | 561.04 | 1808.0 |
| 2024-08-30 07:30:00 | SPY | ETF | 561.13 | 561.16 | 561.07 | 561.1 | 1300.0 |
| 2024-08-30 07:35:00 | SPY | ETF | 561.16 | 561.22 | 561.09 | 561.14 | 1600.0 |
| 2024-08-30 07:40:00 | SPY | ETF | 561.11 | 561.13 | 560.58 | 560.63 | 6925.0 |
| 2024-08-30 07:45:00 | SPY | ETF | 560.63 | 560.8 | 560.63 | 560.8 | 979.0 |
| 2024-08-30 07:50:00 | SPY | ETF | 560.82 | 561.02 | 560.82 | 560.95 | 6146.0 |
| 2024-08-30 07:55:00 | SPY | ETF | 560.91 | 560.96 | 560.9 | 560.95 | 3943.0 |
| 2024-08-30 08:00:00 | SPY | ETF | 561.3 | 561.3 | 559.39 | 561.27 | 32021.0 |
| 2024-08-30 08:05:00 | SPY | ETF | 561.22 | 561.37 | 561.18 | 561.26 | 17320.0 |
| 2024-08-30 08:10:00 | SPY | ETF | 561.23 | 561.3896 | 561.22 | 561.32 | 14144.0 |
| 2024-08-30 08:15:00 | SPY | ETF | 561.27 | 561.51 | 561.27 | 561.43 | 8768.0 |
| 2024-08-30 08:20:00 | SPY | ETF | 561.5 | 561.5 | 561.28 | 561.3 | 10383.0 |
| 2024-08-30 08:25:00 | SPY | ETF | 561.22 | 561.4 | 561.17 | 561.35 | 3151.0 |
| 2024-08-30 08:30:00 | SPY | ETF | 561.3 | 561.62 | 560.82 | 560.88 | 39748.0 |
> showing 50 of 107,689 rows — these rows as CSV