PREVIEW / etf_5min / 2024-07-23
file: by_date/etf_5min/2024/2024-07-23.parquet size: 2.3 MB rows: 113,210
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-07-23 04:00:00 | SPY | ETF | 553.02 | 553.08 | 552.85 | 552.9 | 2213.0 |
| 2024-07-23 04:05:00 | SPY | ETF | 552.7 | 553.08 | 552.7 | 553.08 | 1083.0 |
| 2024-07-23 04:10:00 | SPY | ETF | 553.03 | 553.34 | 553.03 | 553.34 | 1794.0 |
| 2024-07-23 04:15:00 | SPY | ETF | 553.4 | 553.45 | 553.2 | 553.2 | 1072.0 |
| 2024-07-23 04:20:00 | SPY | ETF | 553.23 | 553.23 | 553.08 | 553.08 | 300.0 |
| 2024-07-23 04:25:00 | SPY | ETF | 553.15 | 553.15 | 553.15 | 553.15 | 120.0 |
| 2024-07-23 04:30:00 | SPY | ETF | 553.26 | 553.32 | 553.26 | 553.32 | 421.0 |
| 2024-07-23 04:35:00 | SPY | ETF | 553.5 | 553.65 | 553.5 | 553.62 | 2856.0 |
| 2024-07-23 04:40:00 | SPY | ETF | 553.63 | 553.66 | 553.63 | 553.64 | 1395.0 |
| 2024-07-23 04:45:00 | SPY | ETF | 553.75 | 553.82 | 553.73 | 553.82 | 1405.0 |
| 2024-07-23 04:50:00 | SPY | ETF | 553.83 | 553.83 | 553.77 | 553.8 | 1825.0 |
| 2024-07-23 04:55:00 | SPY | ETF | 553.72 | 553.72 | 553.72 | 553.72 | 143.0 |
| 2024-07-23 05:00:00 | SPY | ETF | 553.68 | 553.84 | 553.68 | 553.84 | 1100.0 |
| 2024-07-23 05:05:00 | SPY | ETF | 553.9 | 554.07 | 553.86 | 554.07 | 17028.0 |
| 2024-07-23 05:10:00 | SPY | ETF | 554.06 | 554.06 | 553.84 | 553.89 | 805.0 |
| 2024-07-23 05:15:00 | SPY | ETF | 554.12 | 554.2 | 554.12 | 554.2 | 250.0 |
| 2024-07-23 05:20:00 | SPY | ETF | 554.23 | 554.59 | 554.23 | 554.57 | 3210.0 |
| 2024-07-23 05:25:00 | SPY | ETF | 554.62 | 554.63 | 554.46 | 554.55 | 1800.0 |
| 2024-07-23 05:30:00 | SPY | ETF | 554.56 | 554.6 | 554.56 | 554.6 | 458.0 |
| 2024-07-23 05:35:00 | SPY | ETF | 554.6 | 554.6 | 554.5 | 554.5 | 1274.0 |
| 2024-07-23 05:40:00 | SPY | ETF | 554.55 | 554.58 | 554.55 | 554.58 | 781.0 |
| 2024-07-23 05:45:00 | SPY | ETF | 554.53 | 554.58 | 554.51 | 554.55 | 500.0 |
| 2024-07-23 05:50:00 | SPY | ETF | 554.51 | 554.57 | 554.5 | 554.57 | 2798.0 |
| 2024-07-23 06:05:00 | SPY | ETF | 554.61 | 554.62 | 554.61 | 554.62 | 500.0 |
| 2024-07-23 06:10:00 | SPY | ETF | 554.48 | 554.6 | 554.45 | 554.6 | 950.0 |
| 2024-07-23 06:15:00 | SPY | ETF | 554.58 | 554.6 | 554.58 | 554.6 | 1100.0 |
| 2024-07-23 06:20:00 | SPY | ETF | 554.57 | 554.6 | 554.57 | 554.6 | 200.0 |
| 2024-07-23 06:25:00 | SPY | ETF | 554.73 | 554.99 | 554.7 | 554.99 | 1558.0 |
| 2024-07-23 06:30:00 | SPY | ETF | 554.99 | 555.18 | 554.99 | 555.16 | 3550.0 |
| 2024-07-23 06:35:00 | SPY | ETF | 555.11 | 555.11 | 555.11 | 555.11 | 100.0 |
| 2024-07-23 06:40:00 | SPY | ETF | 555.06 | 555.08 | 554.89 | 554.89 | 2025.0 |
| 2024-07-23 06:45:00 | SPY | ETF | 554.76 | 554.76 | 554.7 | 554.76 | 14500.0 |
| 2024-07-23 06:50:00 | SPY | ETF | 554.78 | 554.93 | 554.78 | 554.93 | 570.0 |
| 2024-07-23 06:55:00 | SPY | ETF | 555.19 | 555.19 | 554.98 | 554.98 | 2900.0 |
| 2024-07-23 07:00:00 | SPY | ETF | 554.92 | 555.24 | 554.92 | 555.21 | 26463.0 |
| 2024-07-23 07:05:00 | SPY | ETF | 555.19 | 555.24 | 555.13 | 555.17 | 31612.0 |
| 2024-07-23 07:10:00 | SPY | ETF | 555.091 | 555.21 | 555.091 | 555.2 | 37599.0 |
| 2024-07-23 07:15:00 | SPY | ETF | 555.21 | 555.3 | 555.21 | 555.3 | 12050.0 |
| 2024-07-23 07:20:00 | SPY | ETF | 555.3 | 555.35 | 555.15 | 555.26 | 2550.0 |
| 2024-07-23 07:25:00 | SPY | ETF | 555.26 | 555.37 | 555.24 | 555.37 | 3513.0 |
| 2024-07-23 07:30:00 | SPY | ETF | 555.4 | 555.55 | 555.34 | 555.52 | 38985.0 |
| 2024-07-23 07:35:00 | SPY | ETF | 555.55 | 555.57 | 555.23 | 555.29 | 9043.0 |
| 2024-07-23 07:40:00 | SPY | ETF | 555.4 | 555.4 | 555.29 | 555.29 | 11132.0 |
| 2024-07-23 07:45:00 | SPY | ETF | 555.15 | 555.23 | 555.15 | 555.15 | 1016.0 |
| 2024-07-23 07:50:00 | SPY | ETF | 555.22 | 555.22 | 555.19 | 555.19 | 600.0 |
| 2024-07-23 07:55:00 | SPY | ETF | 555.15 | 555.23 | 555.15 | 555.23 | 209.0 |
| 2024-07-23 08:00:00 | SPY | ETF | 555.21 | 555.5081 | 552.83 | 555.22 | 15112.0 |
| 2024-07-23 08:05:00 | SPY | ETF | 555.14 | 555.26 | 555.0129 | 555.06 | 13665.0 |
| 2024-07-23 08:10:00 | SPY | ETF | 555.1 | 555.17 | 554.92 | 554.94 | 5848.0 |
| 2024-07-23 08:15:00 | SPY | ETF | 554.95 | 555.01 | 554.93 | 554.98 | 1677.0 |
> showing 50 of 113,210 rows — these rows as CSV