PREVIEW / etf_5min / 2024-03-13
file: by_date/etf_5min/2024/2024-03-13.parquet size: 2.2 MB rows: 110,451
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-03-13 04:00:00 | SPY | ETF | 517.36 | 517.44 | 517.18 | 517.18 | 13531.0 |
| 2024-03-13 04:05:00 | SPY | ETF | 517.21 | 517.21 | 517.08 | 517.08 | 915.0 |
| 2024-03-13 04:10:00 | SPY | ETF | 517.15 | 517.15 | 517.05 | 517.05 | 1200.0 |
| 2024-03-13 04:15:00 | SPY | ETF | 517.13 | 517.26 | 517.05 | 517.26 | 2699.0 |
| 2024-03-13 04:20:00 | SPY | ETF | 517.26 | 517.27 | 517.01 | 517.01 | 2010.0 |
| 2024-03-13 04:25:00 | SPY | ETF | 516.93 | 516.94 | 516.9 | 516.94 | 600.0 |
| 2024-03-13 04:30:00 | SPY | ETF | 516.77 | 516.81 | 516.71 | 516.81 | 1923.0 |
| 2024-03-13 04:35:00 | SPY | ETF | 516.81 | 516.81 | 516.74 | 516.74 | 886.0 |
| 2024-03-13 04:40:00 | SPY | ETF | 516.72 | 516.72 | 516.7 | 516.7 | 300.0 |
| 2024-03-13 04:45:00 | SPY | ETF | 516.69 | 516.69 | 516.6 | 516.61 | 2398.0 |
| 2024-03-13 04:50:00 | SPY | ETF | 516.64 | 516.71 | 516.63 | 516.71 | 385.0 |
| 2024-03-13 04:55:00 | SPY | ETF | 516.86 | 516.89 | 516.86 | 516.89 | 700.0 |
| 2024-03-13 05:00:00 | SPY | ETF | 516.69 | 516.69 | 516.69 | 516.69 | 100.0 |
| 2024-03-13 05:05:00 | SPY | ETF | 516.73 | 516.77 | 516.72 | 516.74 | 1057.0 |
| 2024-03-13 05:10:00 | SPY | ETF | 516.79 | 516.86 | 516.79 | 516.86 | 391.0 |
| 2024-03-13 05:15:00 | SPY | ETF | 516.99 | 516.99 | 516.6 | 516.68 | 3270.0 |
| 2024-03-13 05:20:00 | SPY | ETF | 516.71 | 516.8 | 516.71 | 516.8 | 911.0 |
| 2024-03-13 05:25:00 | SPY | ETF | 516.9 | 516.94 | 516.9 | 516.94 | 300.0 |
| 2024-03-13 05:30:00 | SPY | ETF | 516.82 | 516.82 | 516.7 | 516.7 | 500.0 |
| 2024-03-13 05:35:00 | SPY | ETF | 516.85 | 516.9 | 516.85 | 516.9 | 200.0 |
| 2024-03-13 05:45:00 | SPY | ETF | 516.82 | 516.9 | 516.77 | 516.84 | 3100.0 |
| 2024-03-13 05:50:00 | SPY | ETF | 516.87 | 516.87 | 516.75 | 516.75 | 490.0 |
| 2024-03-13 05:55:00 | SPY | ETF | 516.79 | 516.88 | 516.79 | 516.88 | 300.0 |
| 2024-03-13 06:00:00 | SPY | ETF | 516.9 | 517.01 | 516.9 | 516.9 | 5252.0 |
| 2024-03-13 06:05:00 | SPY | ETF | 516.71 | 516.71 | 516.71 | 516.71 | 2878.0 |
| 2024-03-13 06:10:00 | SPY | ETF | 516.72 | 516.9 | 516.72 | 516.85 | 25480.0 |
| 2024-03-13 06:15:00 | SPY | ETF | 516.77 | 516.77 | 516.75 | 516.75 | 24900.0 |
| 2024-03-13 06:20:00 | SPY | ETF | 516.88 | 516.98 | 516.88 | 516.92 | 5040.0 |
| 2024-03-13 06:25:00 | SPY | ETF | 517.0 | 517.0 | 517.0 | 517.0 | 695.0 |
| 2024-03-13 06:35:00 | SPY | ETF | 516.99 | 516.99 | 516.99 | 516.99 | 100.0 |
| 2024-03-13 06:40:00 | SPY | ETF | 517.06 | 517.06 | 517.06 | 517.06 | 100.0 |
| 2024-03-13 06:45:00 | SPY | ETF | 517.14 | 517.2 | 517.14 | 517.2 | 700.0 |
| 2024-03-13 06:55:00 | SPY | ETF | 517.25 | 517.25 | 517.25 | 517.25 | 207.0 |
| 2024-03-13 07:00:00 | SPY | ETF | 517.2 | 517.29 | 517.15 | 517.26 | 2171.0 |
| 2024-03-13 07:05:00 | SPY | ETF | 517.23 | 517.3 | 517.14 | 517.3 | 8100.0 |
| 2024-03-13 07:10:00 | SPY | ETF | 517.29 | 517.35 | 517.2 | 517.21 | 37620.0 |
| 2024-03-13 07:15:00 | SPY | ETF | 517.21 | 517.22 | 517.21 | 517.21 | 2500.0 |
| 2024-03-13 07:20:00 | SPY | ETF | 517.35 | 517.4 | 517.3 | 517.3 | 27868.0 |
| 2024-03-13 07:25:00 | SPY | ETF | 517.3 | 517.37 | 517.25 | 517.36 | 17180.0 |
| 2024-03-13 07:30:00 | SPY | ETF | 517.39 | 517.45 | 517.33 | 517.4 | 7025.0 |
| 2024-03-13 07:35:00 | SPY | ETF | 517.42 | 517.45 | 517.4 | 517.45 | 8908.0 |
| 2024-03-13 07:40:00 | SPY | ETF | 517.39 | 517.41 | 517.33 | 517.41 | 7100.0 |
| 2024-03-13 07:45:00 | SPY | ETF | 517.46 | 517.49 | 517.41 | 517.48 | 11055.0 |
| 2024-03-13 07:50:00 | SPY | ETF | 517.47 | 517.47 | 517.2 | 517.28 | 58684.0 |
| 2024-03-13 07:55:00 | SPY | ETF | 517.28 | 517.28 | 517.07 | 517.1 | 29740.0 |
| 2024-03-13 08:00:00 | SPY | ETF | 517.34 | 517.4797 | 516.6096 | 516.96 | 104372.0 |
| 2024-03-13 08:05:00 | SPY | ETF | 516.8 | 517.03 | 516.8 | 516.94 | 34960.0 |
| 2024-03-13 08:10:00 | SPY | ETF | 516.95 | 517.09 | 516.85 | 516.98 | 23512.0 |
| 2024-03-13 08:15:00 | SPY | ETF | 517.01 | 517.01 | 516.74 | 516.85 | 75428.0 |
| 2024-03-13 08:20:00 | SPY | ETF | 516.82 | 516.82 | 516.69 | 516.69 | 17352.0 |
> showing 50 of 110,451 rows — these rows as CSV