PREVIEW / etf_5min / 2023-03-21
file: by_date/etf_5min/2023/2023-03-21.parquet size: 2.0 MB rows: 96,896
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-21 04:00:00 | SPY | ETF | 394.78 | 394.78 | 394.25 | 394.33 | 2195.0 |
| 2023-03-21 04:05:00 | SPY | ETF | 394.52 | 394.82 | 394.3 | 394.82 | 5759.0 |
| 2023-03-21 04:10:00 | SPY | ETF | 394.63 | 394.65 | 394.45 | 394.55 | 3566.0 |
| 2023-03-21 04:15:00 | SPY | ETF | 394.82 | 394.95 | 394.79 | 394.91 | 3454.0 |
| 2023-03-21 04:20:00 | SPY | ETF | 394.92 | 395.01 | 394.91 | 394.98 | 2887.0 |
| 2023-03-21 04:25:00 | SPY | ETF | 395.0 | 395.01 | 395.0 | 395.0 | 6400.0 |
| 2023-03-21 04:30:00 | SPY | ETF | 395.02 | 395.12 | 394.81 | 394.97 | 3986.0 |
| 2023-03-21 04:35:00 | SPY | ETF | 394.86 | 394.86 | 394.73 | 394.8 | 3553.0 |
| 2023-03-21 04:40:00 | SPY | ETF | 394.81 | 394.81 | 394.64 | 394.65 | 5799.0 |
| 2023-03-21 04:45:00 | SPY | ETF | 394.72 | 394.82 | 394.72 | 394.81 | 2164.0 |
| 2023-03-21 04:50:00 | SPY | ETF | 394.85 | 395.0 | 394.85 | 395.0 | 2859.0 |
| 2023-03-21 04:55:00 | SPY | ETF | 394.98 | 395.05 | 394.98 | 395.0 | 2920.0 |
| 2023-03-21 05:00:00 | SPY | ETF | 394.96 | 394.96 | 394.83 | 394.84 | 2600.0 |
| 2023-03-21 05:05:00 | SPY | ETF | 394.75 | 394.93 | 394.72 | 394.89 | 2675.0 |
| 2023-03-21 05:10:00 | SPY | ETF | 394.98 | 395.24 | 394.98 | 395.24 | 9306.0 |
| 2023-03-21 05:15:00 | SPY | ETF | 395.23 | 395.41 | 395.23 | 395.35 | 4062.0 |
| 2023-03-21 05:20:00 | SPY | ETF | 395.34 | 395.37 | 395.05 | 395.05 | 3027.0 |
| 2023-03-21 05:25:00 | SPY | ETF | 395.05 | 395.3 | 395.05 | 395.27 | 6024.0 |
| 2023-03-21 05:30:00 | SPY | ETF | 395.34 | 395.35 | 395.27 | 395.28 | 15286.0 |
| 2023-03-21 05:35:00 | SPY | ETF | 395.38 | 395.38 | 395.29 | 395.29 | 1400.0 |
| 2023-03-21 05:40:00 | SPY | ETF | 395.39 | 395.39 | 395.31 | 395.31 | 634.0 |
| 2023-03-21 05:45:00 | SPY | ETF | 395.49 | 395.5 | 395.28 | 395.28 | 1190.0 |
| 2023-03-21 05:50:00 | SPY | ETF | 395.26 | 395.54 | 395.26 | 395.54 | 951.0 |
| 2023-03-21 05:55:00 | SPY | ETF | 395.55 | 395.85 | 395.55 | 395.84 | 20721.0 |
| 2023-03-21 06:00:00 | SPY | ETF | 395.92 | 396.06 | 395.83 | 395.9 | 4517.0 |
| 2023-03-21 06:05:00 | SPY | ETF | 395.87 | 395.92 | 395.77 | 395.82 | 2796.0 |
| 2023-03-21 06:10:00 | SPY | ETF | 395.75 | 395.92 | 395.65 | 395.9 | 25392.0 |
| 2023-03-21 06:15:00 | SPY | ETF | 395.93 | 395.95 | 395.88 | 395.95 | 1420.0 |
| 2023-03-21 06:20:00 | SPY | ETF | 395.96 | 396.01 | 395.89 | 395.89 | 1643.0 |
| 2023-03-21 06:25:00 | SPY | ETF | 396.1 | 396.37 | 396.0 | 396.2 | 10866.0 |
| 2023-03-21 06:30:00 | SPY | ETF | 396.2 | 396.27 | 395.92 | 396.12 | 7190.0 |
| 2023-03-21 06:35:00 | SPY | ETF | 396.2 | 396.45 | 396.2 | 396.31 | 26666.0 |
| 2023-03-21 06:40:00 | SPY | ETF | 396.5 | 396.68 | 396.48 | 396.48 | 29302.0 |
| 2023-03-21 06:45:00 | SPY | ETF | 396.47 | 396.47 | 396.16 | 396.16 | 20163.0 |
| 2023-03-21 06:50:00 | SPY | ETF | 396.1 | 396.11 | 395.96 | 395.96 | 1796.0 |
| 2023-03-21 06:55:00 | SPY | ETF | 396.04 | 396.09 | 395.83 | 396.07 | 5426.0 |
| 2023-03-21 07:00:00 | SPY | ETF | 396.05 | 396.34 | 395.88 | 396.06 | 16325.0 |
| 2023-03-21 07:05:00 | SPY | ETF | 396.0 | 396.32 | 395.98 | 396.2 | 86855.0 |
| 2023-03-21 07:10:00 | SPY | ETF | 396.19 | 396.42 | 396.19 | 396.32 | 37423.0 |
| 2023-03-21 07:15:00 | SPY | ETF | 396.25 | 396.45 | 396.25 | 396.45 | 17277.0 |
| 2023-03-21 07:20:00 | SPY | ETF | 396.39 | 396.76 | 396.39 | 396.76 | 172252.0 |
| 2023-03-21 07:25:00 | SPY | ETF | 396.75 | 397.09 | 396.73 | 397.06 | 105431.0 |
| 2023-03-21 07:30:00 | SPY | ETF | 396.93 | 396.93 | 396.69 | 396.69 | 22835.0 |
| 2023-03-21 07:35:00 | SPY | ETF | 396.8 | 396.96 | 396.65 | 396.68 | 32470.0 |
| 2023-03-21 07:40:00 | SPY | ETF | 396.81 | 397.0 | 396.81 | 396.88 | 36075.0 |
| 2023-03-21 07:45:00 | SPY | ETF | 396.9 | 396.94 | 396.691 | 396.691 | 63293.0 |
| 2023-03-21 07:50:00 | SPY | ETF | 396.7 | 397.16 | 396.7 | 397.01 | 100950.0 |
| 2023-03-21 07:55:00 | SPY | ETF | 397.02 | 397.02 | 396.9 | 396.97 | 18438.0 |
| 2023-03-21 08:00:00 | SPY | ETF | 396.3001 | 397.17 | 393.99 | 397.09 | 81518.0 |
| 2023-03-21 08:05:00 | SPY | ETF | 397.09 | 397.15 | 396.91 | 397.031 | 44858.0 |
> showing 50 of 96,896 rows — these rows as CSV