PREVIEW / etf_5min / 2024-09-24
file: by_date/etf_5min/2024/2024-09-24.parquet size: 2.4 MB rows: 117,078
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-09-24 04:00:00 | SPY | ETF | 570.22 | 570.9 | 570.22 | 570.9 | 2957.0 |
| 2024-09-24 04:05:00 | SPY | ETF | 570.99 | 571.04 | 570.96 | 571.04 | 959.0 |
| 2024-09-24 04:10:00 | SPY | ETF | 571.07 | 571.12 | 571.05 | 571.06 | 1212.0 |
| 2024-09-24 04:15:00 | SPY | ETF | 571.15 | 571.2 | 571.07 | 571.2 | 871.0 |
| 2024-09-24 04:20:00 | SPY | ETF | 571.21 | 571.41 | 571.21 | 571.33 | 1513.0 |
| 2024-09-24 04:25:00 | SPY | ETF | 571.36 | 571.38 | 571.34 | 571.38 | 430.0 |
| 2024-09-24 04:30:00 | SPY | ETF | 571.23 | 571.3 | 571.2 | 571.2 | 562.0 |
| 2024-09-24 04:35:00 | SPY | ETF | 571.25 | 571.25 | 571.23 | 571.23 | 241.0 |
| 2024-09-24 04:40:00 | SPY | ETF | 571.17 | 571.18 | 571.1 | 571.18 | 579.0 |
| 2024-09-24 04:45:00 | SPY | ETF | 571.01 | 571.14 | 571.01 | 571.14 | 500.0 |
| 2024-09-24 04:50:00 | SPY | ETF | 571.26 | 571.26 | 571.26 | 571.26 | 500.0 |
| 2024-09-24 04:55:00 | SPY | ETF | 571.34 | 571.34 | 571.34 | 571.34 | 100.0 |
| 2024-09-24 05:00:00 | SPY | ETF | 571.19 | 571.26 | 571.19 | 571.26 | 3032.0 |
| 2024-09-24 05:05:00 | SPY | ETF | 571.13 | 571.13 | 571.12 | 571.12 | 928.0 |
| 2024-09-24 05:10:00 | SPY | ETF | 571.25 | 571.25 | 571.07 | 571.07 | 890.0 |
| 2024-09-24 05:15:00 | SPY | ETF | 571.02 | 571.02 | 570.92 | 570.92 | 5150.0 |
| 2024-09-24 05:20:00 | SPY | ETF | 570.76 | 570.83 | 570.71 | 570.74 | 4042.0 |
| 2024-09-24 05:25:00 | SPY | ETF | 570.88 | 570.88 | 570.88 | 570.88 | 115.0 |
| 2024-09-24 05:35:00 | SPY | ETF | 570.85 | 570.87 | 570.8 | 570.82 | 724.0 |
| 2024-09-24 05:40:00 | SPY | ETF | 570.75 | 570.8 | 570.75 | 570.8 | 501.0 |
| 2024-09-24 05:45:00 | SPY | ETF | 570.68 | 570.68 | 570.68 | 570.68 | 848.0 |
| 2024-09-24 05:50:00 | SPY | ETF | 570.8 | 570.8 | 570.8 | 570.8 | 193.0 |
| 2024-09-24 05:55:00 | SPY | ETF | 570.61 | 570.74 | 570.59 | 570.74 | 1322.0 |
| 2024-09-24 06:00:00 | SPY | ETF | 570.67 | 570.71 | 570.67 | 570.71 | 574.0 |
| 2024-09-24 06:05:00 | SPY | ETF | 570.72 | 570.72 | 570.72 | 570.72 | 400.0 |
| 2024-09-24 06:10:00 | SPY | ETF | 570.77 | 570.86 | 570.77 | 570.86 | 892.0 |
| 2024-09-24 06:15:00 | SPY | ETF | 570.93 | 570.98 | 570.93 | 570.97 | 11890.0 |
| 2024-09-24 06:20:00 | SPY | ETF | 570.9 | 570.96 | 570.9 | 570.96 | 1685.0 |
| 2024-09-24 06:25:00 | SPY | ETF | 570.82 | 570.83 | 570.82 | 570.83 | 300.0 |
| 2024-09-24 06:30:00 | SPY | ETF | 570.95 | 570.95 | 570.95 | 570.95 | 1043.0 |
| 2024-09-24 06:40:00 | SPY | ETF | 571.06 | 571.09 | 571.02 | 571.02 | 992.0 |
| 2024-09-24 06:45:00 | SPY | ETF | 570.79 | 570.79 | 570.55 | 570.72 | 3487.0 |
| 2024-09-24 06:50:00 | SPY | ETF | 570.56 | 570.63 | 570.43 | 570.63 | 1489.0 |
| 2024-09-24 06:55:00 | SPY | ETF | 570.57 | 570.6 | 570.2 | 570.21 | 2136.0 |
| 2024-09-24 07:00:00 | SPY | ETF | 570.17 | 570.33 | 569.46 | 569.46 | 30670.0 |
| 2024-09-24 07:05:00 | SPY | ETF | 569.27 | 569.59 | 569.2 | 569.25 | 8165.0 |
| 2024-09-24 07:10:00 | SPY | ETF | 569.24 | 569.41 | 569.1 | 569.35 | 4871.0 |
| 2024-09-24 07:15:00 | SPY | ETF | 569.36 | 569.6 | 569.36 | 569.6 | 12145.0 |
| 2024-09-24 07:20:00 | SPY | ETF | 569.65 | 569.8 | 569.6 | 569.8 | 4233.0 |
| 2024-09-24 07:25:00 | SPY | ETF | 569.77 | 569.841 | 569.73 | 569.841 | 5046.0 |
| 2024-09-24 07:30:00 | SPY | ETF | 569.95 | 570.29 | 569.91 | 570.24 | 75690.0 |
| 2024-09-24 07:35:00 | SPY | ETF | 570.26 | 570.49 | 570.26 | 570.46 | 5715.0 |
| 2024-09-24 07:40:00 | SPY | ETF | 570.4 | 570.541 | 570.38 | 570.38 | 44172.0 |
| 2024-09-24 07:45:00 | SPY | ETF | 570.36 | 570.38 | 570.34 | 570.34 | 793.0 |
| 2024-09-24 07:50:00 | SPY | ETF | 570.28 | 570.28 | 570.23 | 570.23 | 2399.0 |
| 2024-09-24 07:55:00 | SPY | ETF | 570.1 | 570.13 | 570.04 | 570.08 | 7293.0 |
| 2024-09-24 08:00:00 | SPY | ETF | 570.1 | 571.38 | 568.91 | 570.2 | 154382.0 |
| 2024-09-24 08:05:00 | SPY | ETF | 570.23 | 570.26 | 570.12 | 570.22 | 3946.0 |
| 2024-09-24 08:10:00 | SPY | ETF | 570.18 | 570.22 | 569.96 | 570.21 | 12034.0 |
| 2024-09-24 08:15:00 | SPY | ETF | 570.2 | 570.39 | 570.12 | 570.38 | 2336.0 |
> showing 50 of 117,078 rows — these rows as CSV