PREVIEW / etf_5min / 2023-02-21
file: by_date/etf_5min/2023/2023-02-21.parquet size: 2.1 MB rows: 99,864
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 |
|---|---|---|---|---|---|---|---|
| 2023-02-21 04:00:00 | SPY | ETF | 403.67 | 405.49 | 403.55 | 403.59 | 8216.0 |
| 2023-02-21 04:05:00 | SPY | ETF | 403.55 | 403.76 | 403.36 | 403.69 | 13864.0 |
| 2023-02-21 04:10:00 | SPY | ETF | 403.68 | 404.07 | 403.68 | 403.99 | 10877.0 |
| 2023-02-21 04:15:00 | SPY | ETF | 404.08 | 404.19 | 403.85 | 403.85 | 2188.0 |
| 2023-02-21 04:20:00 | SPY | ETF | 403.68 | 403.68 | 403.39 | 403.61 | 8393.0 |
| 2023-02-21 04:25:00 | SPY | ETF | 403.83 | 404.18 | 403.8 | 404.15 | 5596.0 |
| 2023-02-21 04:30:00 | SPY | ETF | 404.07 | 404.47 | 404.05 | 404.47 | 5253.0 |
| 2023-02-21 04:35:00 | SPY | ETF | 404.48 | 404.49 | 404.35 | 404.48 | 1105.0 |
| 2023-02-21 04:40:00 | SPY | ETF | 404.47 | 404.71 | 404.47 | 404.48 | 6137.0 |
| 2023-02-21 04:45:00 | SPY | ETF | 404.54 | 404.75 | 404.44 | 404.75 | 3255.0 |
| 2023-02-21 04:50:00 | SPY | ETF | 404.69 | 405.42 | 404.69 | 405.36 | 27173.0 |
| 2023-02-21 04:55:00 | SPY | ETF | 405.43 | 405.43 | 404.96 | 405.0 | 5966.0 |
| 2023-02-21 05:00:00 | SPY | ETF | 405.07 | 405.07 | 404.67 | 404.67 | 8878.0 |
| 2023-02-21 05:05:00 | SPY | ETF | 404.7 | 404.71 | 404.66 | 404.69 | 2100.0 |
| 2023-02-21 05:10:00 | SPY | ETF | 404.74 | 404.86 | 404.58 | 404.59 | 6517.0 |
| 2023-02-21 05:15:00 | SPY | ETF | 404.46 | 404.46 | 404.35 | 404.4 | 1523.0 |
| 2023-02-21 05:20:00 | SPY | ETF | 404.39 | 404.45 | 404.31 | 404.31 | 2590.0 |
| 2023-02-21 05:25:00 | SPY | ETF | 404.2 | 404.37 | 404.05 | 404.37 | 1750.0 |
| 2023-02-21 05:30:00 | SPY | ETF | 404.37 | 404.37 | 404.3 | 404.3 | 200.0 |
| 2023-02-21 05:35:00 | SPY | ETF | 404.21 | 404.37 | 404.21 | 404.37 | 775.0 |
| 2023-02-21 05:40:00 | SPY | ETF | 404.34 | 404.34 | 404.31 | 404.31 | 500.0 |
| 2023-02-21 05:45:00 | SPY | ETF | 404.25 | 404.27 | 404.17 | 404.27 | 930.0 |
| 2023-02-21 05:50:00 | SPY | ETF | 404.27 | 404.31 | 404.19 | 404.19 | 510.0 |
| 2023-02-21 05:55:00 | SPY | ETF | 404.11 | 404.11 | 404.0 | 404.0 | 1900.0 |
| 2023-02-21 06:00:00 | SPY | ETF | 403.98 | 404.02 | 403.73 | 403.85 | 19446.0 |
| 2023-02-21 06:05:00 | SPY | ETF | 403.86 | 403.99 | 403.83 | 403.83 | 400.0 |
| 2023-02-21 06:10:00 | SPY | ETF | 404.0 | 404.0 | 403.89 | 403.89 | 1609.0 |
| 2023-02-21 06:15:00 | SPY | ETF | 404.11 | 404.17 | 404.11 | 404.16 | 2600.0 |
| 2023-02-21 06:20:00 | SPY | ETF | 404.21 | 404.33 | 404.16 | 404.16 | 4186.0 |
| 2023-02-21 06:25:00 | SPY | ETF | 404.33 | 404.34 | 404.33 | 404.34 | 1216.0 |
| 2023-02-21 06:30:00 | SPY | ETF | 404.24 | 404.3 | 404.22 | 404.22 | 4466.0 |
| 2023-02-21 06:35:00 | SPY | ETF | 404.3 | 404.52 | 404.3 | 404.44 | 3098.0 |
| 2023-02-21 06:40:00 | SPY | ETF | 404.51 | 404.51 | 404.45 | 404.45 | 900.0 |
| 2023-02-21 06:45:00 | SPY | ETF | 404.45 | 404.6 | 404.45 | 404.59 | 2285.0 |
| 2023-02-21 06:50:00 | SPY | ETF | 404.6 | 404.6 | 404.49 | 404.58 | 4703.0 |
| 2023-02-21 06:55:00 | SPY | ETF | 404.58 | 404.66 | 404.4 | 404.62 | 3020.0 |
| 2023-02-21 07:00:00 | SPY | ETF | 404.64 | 404.7 | 404.27 | 404.38 | 33716.0 |
| 2023-02-21 07:05:00 | SPY | ETF | 404.32 | 404.32 | 403.94 | 404.03 | 52338.0 |
| 2023-02-21 07:10:00 | SPY | ETF | 404.05 | 404.15 | 403.94 | 404.1 | 17477.0 |
| 2023-02-21 07:15:00 | SPY | ETF | 404.05 | 404.12 | 404.0 | 404.04 | 18201.0 |
| 2023-02-21 07:20:00 | SPY | ETF | 403.99 | 404.04 | 403.83 | 403.83 | 30106.0 |
| 2023-02-21 07:25:00 | SPY | ETF | 403.85 | 404.01 | 403.78 | 403.97 | 8811.0 |
| 2023-02-21 07:30:00 | SPY | ETF | 403.98 | 404.25 | 403.98 | 404.24 | 10219.0 |
| 2023-02-21 07:35:00 | SPY | ETF | 404.11 | 404.31 | 404.11 | 404.17 | 22773.0 |
| 2023-02-21 07:40:00 | SPY | ETF | 404.18 | 404.21 | 403.97 | 404.14 | 20675.0 |
| 2023-02-21 07:45:00 | SPY | ETF | 404.12 | 404.37 | 404.12 | 404.34 | 115212.0 |
| 2023-02-21 07:50:00 | SPY | ETF | 404.37 | 404.43 | 404.16 | 404.18 | 11541.0 |
| 2023-02-21 07:55:00 | SPY | ETF | 404.27 | 404.32 | 404.18 | 404.18 | 6442.0 |
| 2023-02-21 08:00:00 | SPY | ETF | 404.17 | 405.65 | 403.75 | 403.86 | 72093.0 |
| 2023-02-21 08:05:00 | SPY | ETF | 403.86 | 403.9 | 403.79 | 403.79 | 26593.0 |
> showing 50 of 99,864 rows — these rows as CSV