PREVIEW / etf_5min / 2023-03-29
file: by_date/etf_5min/2023/2023-03-29.parquet size: 1.9 MB rows: 94,884
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-03-29 04:00:00 | SPY | ETF | 398.81 | 398.93 | 397.86 | 398.6 | 27269.0 |
| 2023-03-29 04:05:00 | SPY | ETF | 398.58 | 398.74 | 398.51 | 398.67 | 5447.0 |
| 2023-03-29 04:10:00 | SPY | ETF | 398.68 | 398.74 | 398.68 | 398.7 | 652.0 |
| 2023-03-29 04:15:00 | SPY | ETF | 398.84 | 398.91 | 398.79 | 398.84 | 1195.0 |
| 2023-03-29 04:20:00 | SPY | ETF | 398.8 | 398.97 | 398.78 | 398.97 | 1502.0 |
| 2023-03-29 04:25:00 | SPY | ETF | 398.96 | 399.0 | 398.96 | 399.0 | 824.0 |
| 2023-03-29 04:30:00 | SPY | ETF | 399.0 | 399.24 | 399.0 | 399.16 | 9848.0 |
| 2023-03-29 04:35:00 | SPY | ETF | 399.21 | 399.29 | 399.15 | 399.21 | 2382.0 |
| 2023-03-29 04:40:00 | SPY | ETF | 399.2 | 399.2 | 398.88 | 398.88 | 5844.0 |
| 2023-03-29 04:45:00 | SPY | ETF | 398.98 | 398.98 | 398.95 | 398.95 | 500.0 |
| 2023-03-29 04:50:00 | SPY | ETF | 398.92 | 398.92 | 398.92 | 398.92 | 400.0 |
| 2023-03-29 04:55:00 | SPY | ETF | 398.95 | 398.95 | 398.95 | 398.95 | 100.0 |
| 2023-03-29 05:00:00 | SPY | ETF | 399.06 | 399.19 | 399.06 | 399.13 | 1729.0 |
| 2023-03-29 05:05:00 | SPY | ETF | 399.13 | 399.35 | 399.13 | 399.26 | 2855.0 |
| 2023-03-29 05:10:00 | SPY | ETF | 399.33 | 399.39 | 399.29 | 399.29 | 1513.0 |
| 2023-03-29 05:15:00 | SPY | ETF | 399.25 | 399.27 | 399.19 | 399.26 | 808.0 |
| 2023-03-29 05:20:00 | SPY | ETF | 399.15 | 399.21 | 399.15 | 399.15 | 660.0 |
| 2023-03-29 05:25:00 | SPY | ETF | 399.31 | 399.31 | 399.26 | 399.31 | 1600.0 |
| 2023-03-29 05:30:00 | SPY | ETF | 399.25 | 399.3 | 399.21 | 399.25 | 4099.0 |
| 2023-03-29 05:35:00 | SPY | ETF | 399.26 | 399.28 | 399.26 | 399.28 | 900.0 |
| 2023-03-29 05:40:00 | SPY | ETF | 399.32 | 399.32 | 399.28 | 399.3 | 400.0 |
| 2023-03-29 05:45:00 | SPY | ETF | 399.31 | 399.35 | 399.29 | 399.35 | 3132.0 |
| 2023-03-29 05:50:00 | SPY | ETF | 399.35 | 399.38 | 399.35 | 399.38 | 801.0 |
| 2023-03-29 05:55:00 | SPY | ETF | 399.39 | 399.5 | 399.38 | 399.5 | 13254.0 |
| 2023-03-29 06:00:00 | SPY | ETF | 399.48 | 399.48 | 399.34 | 399.41 | 5815.0 |
| 2023-03-29 06:05:00 | SPY | ETF | 399.27 | 399.27 | 399.22 | 399.22 | 7946.0 |
| 2023-03-29 06:10:00 | SPY | ETF | 399.22 | 399.22 | 399.16 | 399.2 | 1609.0 |
| 2023-03-29 06:15:00 | SPY | ETF | 399.21 | 399.21 | 399.09 | 399.12 | 3458.0 |
| 2023-03-29 06:20:00 | SPY | ETF | 399.14 | 399.2 | 399.03 | 399.05 | 14584.0 |
| 2023-03-29 06:25:00 | SPY | ETF | 399.15 | 399.29 | 398.87 | 399.23 | 18092.0 |
| 2023-03-29 06:30:00 | SPY | ETF | 399.22 | 399.22 | 399.11 | 399.11 | 1445.0 |
| 2023-03-29 06:35:00 | SPY | ETF | 399.1 | 399.18 | 399.09 | 399.18 | 2300.0 |
| 2023-03-29 06:40:00 | SPY | ETF | 399.12 | 399.2 | 399.12 | 399.15 | 751.0 |
| 2023-03-29 06:45:00 | SPY | ETF | 399.15 | 399.25 | 399.15 | 399.25 | 1078.0 |
| 2023-03-29 06:50:00 | SPY | ETF | 399.17 | 399.17 | 399.07 | 399.09 | 6307.0 |
| 2023-03-29 06:55:00 | SPY | ETF | 399.08 | 399.16 | 399.07 | 399.12 | 3025.0 |
| 2023-03-29 07:00:00 | SPY | ETF | 399.07 | 399.17 | 399.02 | 399.17 | 22404.0 |
| 2023-03-29 07:05:00 | SPY | ETF | 399.17 | 399.21 | 398.97 | 398.97 | 36969.0 |
| 2023-03-29 07:10:00 | SPY | ETF | 398.99 | 399.04 | 398.81 | 398.83 | 45794.0 |
| 2023-03-29 07:15:00 | SPY | ETF | 398.83 | 399.0 | 398.8 | 399.0 | 15287.0 |
| 2023-03-29 07:20:00 | SPY | ETF | 398.94 | 399.1 | 398.94 | 399.1 | 26422.0 |
| 2023-03-29 07:25:00 | SPY | ETF | 399.09 | 399.1 | 398.93 | 398.93 | 30432.0 |
| 2023-03-29 07:30:00 | SPY | ETF | 398.92 | 399.05 | 398.85 | 399.01 | 42008.0 |
| 2023-03-29 07:35:00 | SPY | ETF | 399.07 | 399.07 | 398.93 | 399.0 | 16556.0 |
| 2023-03-29 07:40:00 | SPY | ETF | 399.0 | 399.1 | 398.98 | 399.1 | 12336.0 |
| 2023-03-29 07:45:00 | SPY | ETF | 399.09 | 399.21 | 399.08 | 399.21 | 8899.0 |
| 2023-03-29 07:50:00 | SPY | ETF | 399.08 | 399.1 | 398.97 | 398.98 | 18106.0 |
| 2023-03-29 07:55:00 | SPY | ETF | 398.95 | 399.0 | 398.8 | 398.8 | 33716.0 |
| 2023-03-29 08:00:00 | SPY | ETF | 398.83 | 399.3804 | 397.54 | 398.97 | 92008.0 |
| 2023-03-29 08:05:00 | SPY | ETF | 398.98 | 399.03 | 398.82 | 398.84 | 15866.0 |
> showing 50 of 94,884 rows — these rows as CSV