PREVIEW / etf_5min / 2024-10-28
file: by_date/etf_5min/2024/2024-10-28.parquet size: 2.4 MB rows: 117,861
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-28 04:00:00 | SPY | ETF | 581.22 | 582.25 | 581.22 | 582.17 | 44317.0 |
| 2024-10-28 04:05:00 | SPY | ETF | 582.0 | 582.04 | 581.69 | 581.69 | 4991.0 |
| 2024-10-28 04:10:00 | SPY | ETF | 581.68 | 582.01 | 581.67 | 581.92 | 4380.0 |
| 2024-10-28 04:15:00 | SPY | ETF | 582.0 | 582.38 | 582.0 | 582.37 | 4353.0 |
| 2024-10-28 04:20:00 | SPY | ETF | 582.2 | 582.26 | 582.03 | 582.03 | 5303.0 |
| 2024-10-28 04:25:00 | SPY | ETF | 582.0 | 582.3 | 581.98 | 582.3 | 4497.0 |
| 2024-10-28 04:30:00 | SPY | ETF | 582.3 | 582.39 | 582.29 | 582.3 | 2469.0 |
| 2024-10-28 04:35:00 | SPY | ETF | 582.4 | 582.79 | 582.4 | 582.7 | 2900.0 |
| 2024-10-28 04:40:00 | SPY | ETF | 582.79 | 582.79 | 582.69 | 582.75 | 1015.0 |
| 2024-10-28 04:45:00 | SPY | ETF | 582.67 | 582.76 | 582.67 | 582.76 | 801.0 |
| 2024-10-28 04:50:00 | SPY | ETF | 582.68 | 582.79 | 582.52 | 582.52 | 5605.0 |
| 2024-10-28 04:55:00 | SPY | ETF | 582.64 | 582.65 | 582.64 | 582.65 | 980.0 |
| 2024-10-28 05:00:00 | SPY | ETF | 582.58 | 582.75 | 582.58 | 582.72 | 3388.0 |
| 2024-10-28 05:05:00 | SPY | ETF | 582.7 | 582.7 | 582.46 | 582.5 | 2089.0 |
| 2024-10-28 05:10:00 | SPY | ETF | 582.7 | 582.7 | 582.55 | 582.55 | 574.0 |
| 2024-10-28 05:15:00 | SPY | ETF | 582.62 | 582.7 | 582.62 | 582.65 | 1053.0 |
| 2024-10-28 05:20:00 | SPY | ETF | 582.55 | 582.55 | 582.35 | 582.39 | 3143.0 |
| 2024-10-28 05:30:00 | SPY | ETF | 582.4 | 582.5 | 582.4 | 582.5 | 550.0 |
| 2024-10-28 05:35:00 | SPY | ETF | 582.57 | 582.65 | 582.55 | 582.62 | 4382.0 |
| 2024-10-28 05:40:00 | SPY | ETF | 582.6 | 582.6 | 582.53 | 582.53 | 1791.0 |
| 2024-10-28 05:45:00 | SPY | ETF | 582.65 | 582.65 | 582.48 | 582.48 | 517.0 |
| 2024-10-28 05:50:00 | SPY | ETF | 582.63 | 582.63 | 582.49 | 582.49 | 387.0 |
| 2024-10-28 05:55:00 | SPY | ETF | 582.67 | 582.79 | 582.63 | 582.79 | 1842.0 |
| 2024-10-28 06:00:00 | SPY | ETF | 582.8 | 582.98 | 582.8 | 582.93 | 5358.0 |
| 2024-10-28 06:05:00 | SPY | ETF | 582.57 | 582.59 | 582.57 | 582.59 | 387.0 |
| 2024-10-28 06:10:00 | SPY | ETF | 582.71 | 582.71 | 582.71 | 582.71 | 100.0 |
| 2024-10-28 06:15:00 | SPY | ETF | 582.72 | 582.8 | 582.72 | 582.8 | 2540.0 |
| 2024-10-28 06:20:00 | SPY | ETF | 582.8 | 582.8 | 582.59 | 582.65 | 5801.0 |
| 2024-10-28 06:25:00 | SPY | ETF | 582.65 | 582.65 | 582.63 | 582.63 | 586.0 |
| 2024-10-28 06:30:00 | SPY | ETF | 582.68 | 582.68 | 582.59 | 582.59 | 404.0 |
| 2024-10-28 06:35:00 | SPY | ETF | 582.64 | 582.64 | 582.54 | 582.55 | 2694.0 |
| 2024-10-28 06:40:00 | SPY | ETF | 582.58 | 582.66 | 582.55 | 582.66 | 795.0 |
| 2024-10-28 06:45:00 | SPY | ETF | 582.5 | 582.5 | 582.5 | 582.5 | 1400.0 |
| 2024-10-28 06:50:00 | SPY | ETF | 582.71 | 582.71 | 582.56 | 582.56 | 6874.0 |
| 2024-10-28 06:55:00 | SPY | ETF | 582.5 | 582.5 | 582.19 | 582.2 | 3778.0 |
| 2024-10-28 07:00:00 | SPY | ETF | 582.2 | 582.2 | 581.43 | 581.88 | 244057.0 |
| 2024-10-28 07:05:00 | SPY | ETF | 581.92 | 582.18 | 581.92 | 582.15 | 21445.0 |
| 2024-10-28 07:10:00 | SPY | ETF | 582.16 | 582.24 | 582.1 | 582.2 | 6054.0 |
| 2024-10-28 07:15:00 | SPY | ETF | 582.25 | 582.25 | 582.14 | 582.14 | 7894.0 |
| 2024-10-28 07:20:00 | SPY | ETF | 582.26 | 582.26 | 581.97 | 581.98 | 8361.0 |
| 2024-10-28 07:25:00 | SPY | ETF | 582.1 | 582.16 | 581.98 | 581.99 | 3514.0 |
| 2024-10-28 07:30:00 | SPY | ETF | 581.95 | 581.95 | 581.74 | 581.78 | 13389.0 |
| 2024-10-28 07:35:00 | SPY | ETF | 581.78 | 581.96 | 581.72 | 581.88 | 15077.0 |
| 2024-10-28 07:40:00 | SPY | ETF | 581.83 | 581.98 | 581.83 | 581.86 | 9171.0 |
| 2024-10-28 07:45:00 | SPY | ETF | 581.86 | 582.0 | 581.86 | 581.94 | 12018.0 |
| 2024-10-28 07:50:00 | SPY | ETF | 581.93 | 581.94 | 581.77 | 581.92 | 10984.0 |
| 2024-10-28 07:55:00 | SPY | ETF | 581.8 | 581.88 | 581.65 | 581.67 | 9754.0 |
| 2024-10-28 08:00:00 | SPY | ETF | 581.91 | 582.35 | 581.09 | 581.15 | 41754.0 |
| 2024-10-28 08:05:00 | SPY | ETF | 581.1501 | 581.35 | 581.02 | 581.34 | 24248.0 |
| 2024-10-28 08:10:00 | SPY | ETF | 581.28 | 581.5 | 581.2 | 581.5 | 29708.0 |
> showing 50 of 117,861 rows — these rows as CSV