PREVIEW / etf_5min / 2023-08-10
file: by_date/etf_5min/2023/2023-08-10.parquet size: 2.0 MB rows: 97,185
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-08-10 04:00:00 | SPY | ETF | 448.51 | 448.52 | 448.25 | 448.25 | 5761.0 |
| 2023-08-10 04:05:00 | SPY | ETF | 448.26 | 448.35 | 448.2 | 448.2 | 6875.0 |
| 2023-08-10 04:10:00 | SPY | ETF | 448.16 | 448.24 | 448.15 | 448.24 | 3552.0 |
| 2023-08-10 04:15:00 | SPY | ETF | 448.15 | 448.2 | 448.13 | 448.2 | 1710.0 |
| 2023-08-10 04:20:00 | SPY | ETF | 448.2 | 448.23 | 448.2 | 448.23 | 400.0 |
| 2023-08-10 04:25:00 | SPY | ETF | 448.16 | 448.25 | 448.14 | 448.21 | 3090.0 |
| 2023-08-10 04:30:00 | SPY | ETF | 448.27 | 448.31 | 448.25 | 448.31 | 3465.0 |
| 2023-08-10 04:35:00 | SPY | ETF | 448.36 | 448.44 | 448.36 | 448.44 | 1300.0 |
| 2023-08-10 04:40:00 | SPY | ETF | 448.52 | 448.62 | 448.5 | 448.5 | 3400.0 |
| 2023-08-10 04:45:00 | SPY | ETF | 448.47 | 448.59 | 448.47 | 448.58 | 3100.0 |
| 2023-08-10 04:50:00 | SPY | ETF | 448.6 | 448.68 | 448.6 | 448.6 | 2623.0 |
| 2023-08-10 04:55:00 | SPY | ETF | 448.64 | 448.64 | 448.5 | 448.5 | 800.0 |
| 2023-08-10 05:00:00 | SPY | ETF | 448.4 | 448.42 | 448.29 | 448.32 | 4047.0 |
| 2023-08-10 05:05:00 | SPY | ETF | 448.33 | 448.44 | 448.33 | 448.44 | 2076.0 |
| 2023-08-10 05:10:00 | SPY | ETF | 448.48 | 448.52 | 448.46 | 448.48 | 1490.0 |
| 2023-08-10 05:15:00 | SPY | ETF | 448.51 | 448.65 | 448.51 | 448.54 | 1128.0 |
| 2023-08-10 05:20:00 | SPY | ETF | 448.53 | 448.53 | 448.38 | 448.39 | 950.0 |
| 2023-08-10 05:25:00 | SPY | ETF | 448.35 | 448.35 | 448.24 | 448.32 | 900.0 |
| 2023-08-10 05:30:00 | SPY | ETF | 448.29 | 448.29 | 448.25 | 448.25 | 900.0 |
| 2023-08-10 05:35:00 | SPY | ETF | 448.27 | 448.27 | 448.27 | 448.27 | 100.0 |
| 2023-08-10 05:40:00 | SPY | ETF | 448.31 | 448.4 | 448.31 | 448.4 | 350.0 |
| 2023-08-10 05:45:00 | SPY | ETF | 448.4 | 448.4 | 448.4 | 448.4 | 330.0 |
| 2023-08-10 05:50:00 | SPY | ETF | 448.34 | 448.38 | 448.34 | 448.38 | 300.0 |
| 2023-08-10 05:55:00 | SPY | ETF | 448.4 | 448.44 | 448.4 | 448.41 | 3050.0 |
| 2023-08-10 06:00:00 | SPY | ETF | 448.41 | 448.42 | 448.3 | 448.37 | 2592.0 |
| 2023-08-10 06:05:00 | SPY | ETF | 448.32 | 448.32 | 447.99 | 448.02 | 3961.0 |
| 2023-08-10 06:10:00 | SPY | ETF | 447.99 | 448.33 | 447.99 | 448.33 | 4287.0 |
| 2023-08-10 06:15:00 | SPY | ETF | 448.27 | 448.33 | 448.18 | 448.18 | 4079.0 |
| 2023-08-10 06:20:00 | SPY | ETF | 448.22 | 448.22 | 448.13 | 448.13 | 1349.0 |
| 2023-08-10 06:25:00 | SPY | ETF | 448.17 | 448.17 | 448.09 | 448.09 | 1011.0 |
| 2023-08-10 06:30:00 | SPY | ETF | 448.02 | 448.02 | 447.93 | 447.99 | 900.0 |
| 2023-08-10 06:35:00 | SPY | ETF | 447.99 | 447.99 | 447.95 | 447.98 | 900.0 |
| 2023-08-10 06:40:00 | SPY | ETF | 447.98 | 448.11 | 447.96 | 447.96 | 2724.0 |
| 2023-08-10 06:45:00 | SPY | ETF | 447.98 | 448.1 | 447.98 | 448.1 | 1500.0 |
| 2023-08-10 06:50:00 | SPY | ETF | 448.1 | 448.13 | 448.1 | 448.13 | 7589.0 |
| 2023-08-10 06:55:00 | SPY | ETF | 448.2 | 448.22 | 448.1 | 448.13 | 5295.0 |
| 2023-08-10 07:00:00 | SPY | ETF | 448.14 | 448.33 | 447.8 | 448.24 | 53418.0 |
| 2023-08-10 07:05:00 | SPY | ETF | 448.25 | 448.35 | 448.24 | 448.3 | 25461.0 |
| 2023-08-10 07:10:00 | SPY | ETF | 448.25 | 448.25 | 448.09 | 448.25 | 7788.0 |
| 2023-08-10 07:15:00 | SPY | ETF | 448.28 | 448.3 | 448.18 | 448.24 | 17301.0 |
| 2023-08-10 07:20:00 | SPY | ETF | 448.2 | 448.2 | 448.09 | 448.09 | 17627.0 |
| 2023-08-10 07:25:00 | SPY | ETF | 448.11 | 448.13 | 447.88 | 447.96 | 21592.0 |
| 2023-08-10 07:30:00 | SPY | ETF | 447.95 | 448.02 | 447.92 | 448.02 | 10920.0 |
| 2023-08-10 07:35:00 | SPY | ETF | 448.0 | 448.07 | 447.97 | 447.97 | 13686.0 |
| 2023-08-10 07:40:00 | SPY | ETF | 447.96 | 448.0 | 447.8 | 447.8 | 15353.0 |
| 2023-08-10 07:45:00 | SPY | ETF | 447.8 | 447.83 | 447.73 | 447.78 | 10933.0 |
| 2023-08-10 07:50:00 | SPY | ETF | 447.78 | 447.96 | 447.78 | 447.93 | 20431.0 |
| 2023-08-10 07:55:00 | SPY | ETF | 447.92 | 447.95 | 447.84 | 447.88 | 21723.0 |
| 2023-08-10 08:00:00 | SPY | ETF | 448.2797 | 448.84 | 447.28 | 447.97 | 51071.0 |
| 2023-08-10 08:05:00 | SPY | ETF | 448.0 | 448.07 | 447.95 | 448.0599 | 25749.0 |
> showing 50 of 97,185 rows — these rows as CSV