PREVIEW / etf_1min / 2024-10-29
file: by_date/etf_1min/2024/2024-10-29.parquet size: 5.5 MB rows: 308,994
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-29 04:00:00 | SPY | ETF | 581.19 | 581.19 | 581.09 | 581.15 | 2000.0 |
| 2024-10-29 04:02:00 | SPY | ETF | 581.0 | 581.1 | 581.0 | 581.1 | 300.0 |
| 2024-10-29 04:03:00 | SPY | ETF | 581.02 | 581.02 | 581.02 | 581.02 | 100.0 |
| 2024-10-29 04:04:00 | SPY | ETF | 580.99 | 580.99 | 580.95 | 580.95 | 3229.0 |
| 2024-10-29 04:05:00 | SPY | ETF | 580.91 | 580.91 | 580.9 | 580.9 | 1661.0 |
| 2024-10-29 04:06:00 | SPY | ETF | 580.85 | 580.95 | 580.85 | 580.94 | 1700.0 |
| 2024-10-29 04:07:00 | SPY | ETF | 580.92 | 580.92 | 580.89 | 580.89 | 200.0 |
| 2024-10-29 04:08:00 | SPY | ETF | 580.9 | 580.9 | 580.85 | 580.86 | 3600.0 |
| 2024-10-29 04:09:00 | SPY | ETF | 580.86 | 580.86 | 580.75 | 580.75 | 3297.0 |
| 2024-10-29 04:10:00 | SPY | ETF | 580.84 | 580.84 | 580.84 | 580.84 | 239.0 |
| 2024-10-29 04:11:00 | SPY | ETF | 581.01 | 581.01 | 581.01 | 581.01 | 187.0 |
| 2024-10-29 04:13:00 | SPY | ETF | 580.91 | 580.91 | 580.91 | 580.91 | 200.0 |
| 2024-10-29 04:14:00 | SPY | ETF | 580.97 | 580.97 | 580.97 | 580.97 | 100.0 |
| 2024-10-29 04:15:00 | SPY | ETF | 580.92 | 580.92 | 580.92 | 580.92 | 100.0 |
| 2024-10-29 04:16:00 | SPY | ETF | 580.8 | 580.8 | 580.6 | 580.6 | 3400.0 |
| 2024-10-29 04:17:00 | SPY | ETF | 580.68 | 580.7 | 580.68 | 580.7 | 600.0 |
| 2024-10-29 04:18:00 | SPY | ETF | 580.6 | 580.6 | 580.6 | 580.6 | 503.0 |
| 2024-10-29 04:19:00 | SPY | ETF | 580.41 | 580.43 | 580.41 | 580.41 | 300.0 |
| 2024-10-29 04:20:00 | SPY | ETF | 580.44 | 580.44 | 580.44 | 580.44 | 498.0 |
| 2024-10-29 04:21:00 | SPY | ETF | 580.27 | 580.27 | 580.26 | 580.26 | 270.0 |
| 2024-10-29 04:22:00 | SPY | ETF | 580.21 | 580.34 | 580.21 | 580.34 | 600.0 |
| 2024-10-29 04:23:00 | SPY | ETF | 580.44 | 580.45 | 580.44 | 580.44 | 872.0 |
| 2024-10-29 04:25:00 | SPY | ETF | 580.49 | 580.49 | 580.49 | 580.49 | 100.0 |
| 2024-10-29 04:27:00 | SPY | ETF | 580.68 | 580.68 | 580.68 | 580.68 | 216.0 |
| 2024-10-29 04:28:00 | SPY | ETF | 580.68 | 580.68 | 580.63 | 580.63 | 1478.0 |
| 2024-10-29 04:29:00 | SPY | ETF | 580.99 | 581.06 | 580.99 | 581.04 | 900.0 |
| 2024-10-29 04:30:00 | SPY | ETF | 581.13 | 581.15 | 581.13 | 581.15 | 474.0 |
| 2024-10-29 04:34:00 | SPY | ETF | 581.13 | 581.13 | 581.13 | 581.13 | 100.0 |
| 2024-10-29 04:36:00 | SPY | ETF | 581.14 | 581.2 | 581.14 | 581.2 | 236.0 |
| 2024-10-29 04:40:00 | SPY | ETF | 581.43 | 581.45 | 581.43 | 581.45 | 981.0 |
| 2024-10-29 04:44:00 | SPY | ETF | 581.43 | 581.43 | 581.43 | 581.43 | 300.0 |
| 2024-10-29 04:45:00 | SPY | ETF | 581.5 | 581.5 | 581.5 | 581.5 | 187.0 |
| 2024-10-29 04:49:00 | SPY | ETF | 581.47 | 581.47 | 581.47 | 581.47 | 324.0 |
| 2024-10-29 04:50:00 | SPY | ETF | 581.48 | 581.48 | 581.48 | 581.48 | 300.0 |
| 2024-10-29 04:52:00 | SPY | ETF | 581.53 | 581.56 | 581.53 | 581.56 | 600.0 |
| 2024-10-29 04:56:00 | SPY | ETF | 581.06 | 581.06 | 581.06 | 581.06 | 935.0 |
| 2024-10-29 04:57:00 | SPY | ETF | 580.97 | 580.97 | 580.97 | 580.97 | 300.0 |
| 2024-10-29 04:58:00 | SPY | ETF | 581.09 | 581.09 | 581.09 | 581.09 | 200.0 |
| 2024-10-29 04:59:00 | SPY | ETF | 581.2 | 581.2 | 581.2 | 581.2 | 400.0 |
| 2024-10-29 05:00:00 | SPY | ETF | 581.11 | 581.11 | 581.06 | 581.06 | 1496.0 |
| 2024-10-29 05:01:00 | SPY | ETF | 580.9 | 580.95 | 580.84 | 580.84 | 1374.0 |
| 2024-10-29 05:03:00 | SPY | ETF | 580.92 | 580.93 | 580.92 | 580.93 | 200.0 |
| 2024-10-29 05:07:00 | SPY | ETF | 580.99 | 580.99 | 580.97 | 580.97 | 400.0 |
| 2024-10-29 05:13:00 | SPY | ETF | 580.8 | 580.8 | 580.69 | 580.69 | 200.0 |
| 2024-10-29 05:14:00 | SPY | ETF | 580.7 | 580.7 | 580.7 | 580.7 | 100.0 |
| 2024-10-29 05:15:00 | SPY | ETF | 580.81 | 580.81 | 580.81 | 580.81 | 187.0 |
| 2024-10-29 05:18:00 | SPY | ETF | 580.76 | 580.76 | 580.76 | 580.76 | 187.0 |
| 2024-10-29 05:19:00 | SPY | ETF | 580.61 | 580.77 | 580.61 | 580.76 | 974.0 |
| 2024-10-29 05:20:00 | SPY | ETF | 580.75 | 580.75 | 580.75 | 580.75 | 100.0 |
| 2024-10-29 05:22:00 | SPY | ETF | 580.83 | 580.83 | 580.79 | 580.79 | 1287.0 |
> showing 50 of 308,994 rows — these rows as CSV