PREVIEW / etf_5min / 2024-01-08
file: by_date/etf_5min/2024/2024-01-08.parquet size: 2.3 MB rows: 110,057
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-01-08 04:00:00 | SPY | ETF | 467.7 | 467.7 | 467.25 | 467.25 | 2925.0 |
| 2024-01-08 04:05:00 | SPY | ETF | 467.13 | 467.35 | 467.13 | 467.35 | 1391.0 |
| 2024-01-08 04:10:00 | SPY | ETF | 467.43 | 467.43 | 467.25 | 467.25 | 1606.0 |
| 2024-01-08 04:15:00 | SPY | ETF | 467.44 | 467.44 | 467.17 | 467.18 | 1000.0 |
| 2024-01-08 04:20:00 | SPY | ETF | 467.13 | 467.15 | 467.0 | 467.0 | 2800.0 |
| 2024-01-08 04:25:00 | SPY | ETF | 466.91 | 466.94 | 466.73 | 466.73 | 3930.0 |
| 2024-01-08 04:30:00 | SPY | ETF | 466.66 | 466.66 | 466.18 | 466.19 | 4007.0 |
| 2024-01-08 04:35:00 | SPY | ETF | 466.15 | 466.31 | 466.13 | 466.31 | 3555.0 |
| 2024-01-08 04:40:00 | SPY | ETF | 466.35 | 466.56 | 466.35 | 466.56 | 2050.0 |
| 2024-01-08 04:45:00 | SPY | ETF | 466.86 | 466.89 | 466.86 | 466.89 | 1100.0 |
| 2024-01-08 04:50:00 | SPY | ETF | 466.83 | 467.04 | 466.83 | 467.04 | 300.0 |
| 2024-01-08 04:55:00 | SPY | ETF | 467.12 | 467.12 | 467.02 | 467.04 | 950.0 |
| 2024-01-08 05:00:00 | SPY | ETF | 467.18 | 467.19 | 467.14 | 467.14 | 400.0 |
| 2024-01-08 05:05:00 | SPY | ETF | 467.03 | 467.07 | 467.03 | 467.07 | 200.0 |
| 2024-01-08 05:10:00 | SPY | ETF | 466.91 | 466.91 | 466.91 | 466.91 | 100.0 |
| 2024-01-08 05:15:00 | SPY | ETF | 467.03 | 467.17 | 467.03 | 467.17 | 1911.0 |
| 2024-01-08 05:25:00 | SPY | ETF | 467.17 | 467.17 | 467.17 | 467.17 | 100.0 |
| 2024-01-08 05:30:00 | SPY | ETF | 467.38 | 467.44 | 467.37 | 467.44 | 314.0 |
| 2024-01-08 05:35:00 | SPY | ETF | 467.23 | 467.23 | 467.23 | 467.23 | 850.0 |
| 2024-01-08 05:40:00 | SPY | ETF | 467.32 | 467.32 | 467.23 | 467.23 | 554.0 |
| 2024-01-08 05:45:00 | SPY | ETF | 467.09 | 467.09 | 467.09 | 467.09 | 290.0 |
| 2024-01-08 05:50:00 | SPY | ETF | 467.1 | 467.1 | 467.03 | 467.03 | 600.0 |
| 2024-01-08 05:55:00 | SPY | ETF | 467.06 | 467.06 | 467.0 | 467.0 | 1749.0 |
| 2024-01-08 06:00:00 | SPY | ETF | 466.81 | 466.81 | 466.79 | 466.79 | 1450.0 |
| 2024-01-08 06:05:00 | SPY | ETF | 466.76 | 466.86 | 466.61 | 466.86 | 11114.0 |
| 2024-01-08 06:10:00 | SPY | ETF | 466.94 | 467.4 | 466.94 | 467.4 | 9360.0 |
| 2024-01-08 06:15:00 | SPY | ETF | 467.37 | 467.37 | 467.2 | 467.2 | 514.0 |
| 2024-01-08 06:20:00 | SPY | ETF | 467.13 | 467.13 | 467.1 | 467.1 | 1200.0 |
| 2024-01-08 06:25:00 | SPY | ETF | 467.17 | 467.28 | 467.17 | 467.28 | 2100.0 |
| 2024-01-08 06:30:00 | SPY | ETF | 467.38 | 467.41 | 467.36 | 467.41 | 1776.0 |
| 2024-01-08 06:35:00 | SPY | ETF | 467.31 | 467.37 | 467.31 | 467.36 | 8900.0 |
| 2024-01-08 06:40:00 | SPY | ETF | 467.5 | 467.77 | 467.5 | 467.67 | 3794.0 |
| 2024-01-08 06:45:00 | SPY | ETF | 467.74 | 467.79 | 467.66 | 467.66 | 5065.0 |
| 2024-01-08 06:50:00 | SPY | ETF | 467.67 | 467.71 | 467.57 | 467.57 | 9662.0 |
| 2024-01-08 06:55:00 | SPY | ETF | 467.59 | 467.59 | 467.59 | 467.59 | 100.0 |
| 2024-01-08 07:00:00 | SPY | ETF | 467.67 | 467.71 | 467.6 | 467.65 | 6074.0 |
| 2024-01-08 07:05:00 | SPY | ETF | 467.68 | 467.9 | 467.68 | 467.89 | 7805.0 |
| 2024-01-08 07:10:00 | SPY | ETF | 467.93 | 467.99 | 467.89 | 467.97 | 16632.0 |
| 2024-01-08 07:15:00 | SPY | ETF | 467.97 | 467.97 | 467.83 | 467.87 | 1399.0 |
| 2024-01-08 07:20:00 | SPY | ETF | 467.88 | 467.9 | 467.73 | 467.8 | 2452.0 |
| 2024-01-08 07:25:00 | SPY | ETF | 467.72 | 467.83 | 467.72 | 467.81 | 2269.0 |
| 2024-01-08 07:30:00 | SPY | ETF | 467.73 | 467.73 | 467.57 | 467.61 | 3341.0 |
| 2024-01-08 07:35:00 | SPY | ETF | 467.62 | 467.69 | 467.5 | 467.56 | 6916.0 |
| 2024-01-08 07:40:00 | SPY | ETF | 467.55 | 467.61 | 467.53 | 467.56 | 4576.0 |
| 2024-01-08 07:45:00 | SPY | ETF | 467.59 | 467.72 | 467.57 | 467.71 | 5300.0 |
| 2024-01-08 07:50:00 | SPY | ETF | 467.7 | 467.72 | 467.47 | 467.61 | 13402.0 |
| 2024-01-08 07:55:00 | SPY | ETF | 467.58 | 468.07 | 467.58 | 468.07 | 17292.0 |
| 2024-01-08 08:00:00 | SPY | ETF | 467.79 | 468.19 | 466.86 | 468.0999 | 56323.0 |
| 2024-01-08 08:05:00 | SPY | ETF | 468.06 | 468.06 | 467.83 | 467.84 | 6339.0 |
| 2024-01-08 08:10:00 | SPY | ETF | 467.84 | 468.0 | 467.8 | 467.9806 | 4920.0 |
> showing 50 of 110,057 rows — these rows as CSV