PREVIEW / etf_5min / 2024-03-21
file: by_date/etf_5min/2024/2024-03-21.parquet size: 2.2 MB rows: 113,183
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-21 04:00:00 | SPY | ETF | 523.48 | 523.8 | 523.19 | 523.27 | 14083.0 |
| 2024-03-21 04:05:00 | SPY | ETF | 523.28 | 523.36 | 523.12 | 523.34 | 4783.0 |
| 2024-03-21 04:10:00 | SPY | ETF | 523.39 | 523.39 | 523.07 | 523.08 | 5062.0 |
| 2024-03-21 04:15:00 | SPY | ETF | 523.19 | 523.19 | 523.0 | 523.02 | 6612.0 |
| 2024-03-21 04:20:00 | SPY | ETF | 523.09 | 523.12 | 522.8 | 522.8 | 14839.0 |
| 2024-03-21 04:25:00 | SPY | ETF | 522.8 | 522.93 | 522.77 | 522.9 | 5174.0 |
| 2024-03-21 04:30:00 | SPY | ETF | 522.93 | 523.02 | 522.84 | 522.99 | 5975.0 |
| 2024-03-21 04:35:00 | SPY | ETF | 522.91 | 522.92 | 522.91 | 522.92 | 1212.0 |
| 2024-03-21 04:40:00 | SPY | ETF | 522.96 | 522.96 | 522.75 | 522.82 | 3682.0 |
| 2024-03-21 04:45:00 | SPY | ETF | 522.78 | 522.88 | 522.78 | 522.88 | 251.0 |
| 2024-03-21 04:50:00 | SPY | ETF | 522.83 | 522.97 | 522.83 | 522.91 | 3847.0 |
| 2024-03-21 04:55:00 | SPY | ETF | 522.85 | 522.86 | 522.79 | 522.79 | 1245.0 |
| 2024-03-21 05:00:00 | SPY | ETF | 522.77 | 522.77 | 522.54 | 522.54 | 1873.0 |
| 2024-03-21 05:05:00 | SPY | ETF | 522.53 | 522.53 | 522.21 | 522.21 | 9187.0 |
| 2024-03-21 05:10:00 | SPY | ETF | 522.31 | 522.31 | 522.31 | 522.31 | 500.0 |
| 2024-03-21 05:15:00 | SPY | ETF | 522.33 | 522.33 | 522.28 | 522.28 | 1425.0 |
| 2024-03-21 05:20:00 | SPY | ETF | 522.34 | 522.39 | 522.3 | 522.3 | 2150.0 |
| 2024-03-21 05:25:00 | SPY | ETF | 522.25 | 522.27 | 522.25 | 522.27 | 3550.0 |
| 2024-03-21 05:30:00 | SPY | ETF | 522.28 | 522.28 | 522.28 | 522.28 | 100.0 |
| 2024-03-21 05:35:00 | SPY | ETF | 522.26 | 522.46 | 522.26 | 522.42 | 1125.0 |
| 2024-03-21 05:40:00 | SPY | ETF | 522.5 | 522.6 | 522.5 | 522.55 | 1100.0 |
| 2024-03-21 05:45:00 | SPY | ETF | 522.59 | 522.66 | 522.58 | 522.63 | 800.0 |
| 2024-03-21 05:50:00 | SPY | ETF | 522.5 | 522.59 | 522.48 | 522.59 | 1802.0 |
| 2024-03-21 06:00:00 | SPY | ETF | 522.44 | 522.46 | 522.33 | 522.33 | 1897.0 |
| 2024-03-21 06:05:00 | SPY | ETF | 522.25 | 522.34 | 522.15 | 522.3 | 8649.0 |
| 2024-03-21 06:10:00 | SPY | ETF | 522.35 | 522.4 | 522.35 | 522.35 | 3128.0 |
| 2024-03-21 06:15:00 | SPY | ETF | 522.25 | 522.25 | 522.2 | 522.2 | 1784.0 |
| 2024-03-21 06:20:00 | SPY | ETF | 522.36 | 522.45 | 522.35 | 522.42 | 1475.0 |
| 2024-03-21 06:25:00 | SPY | ETF | 522.42 | 522.42 | 522.38 | 522.38 | 500.0 |
| 2024-03-21 06:30:00 | SPY | ETF | 522.45 | 522.45 | 522.38 | 522.44 | 600.0 |
| 2024-03-21 06:35:00 | SPY | ETF | 522.4 | 522.4 | 522.23 | 522.23 | 700.0 |
| 2024-03-21 06:40:00 | SPY | ETF | 522.26 | 522.26 | 522.14 | 522.16 | 1250.0 |
| 2024-03-21 06:45:00 | SPY | ETF | 522.27 | 522.27 | 522.19 | 522.19 | 1553.0 |
| 2024-03-21 06:50:00 | SPY | ETF | 522.19 | 522.26 | 522.19 | 522.23 | 742.0 |
| 2024-03-21 06:55:00 | SPY | ETF | 522.23 | 522.31 | 522.23 | 522.27 | 1900.0 |
| 2024-03-21 07:00:00 | SPY | ETF | 522.31 | 522.43 | 522.27 | 522.38 | 8096.0 |
| 2024-03-21 07:05:00 | SPY | ETF | 522.38 | 522.46 | 522.34 | 522.46 | 10105.0 |
| 2024-03-21 07:10:00 | SPY | ETF | 522.47 | 522.66 | 522.46 | 522.52 | 19127.0 |
| 2024-03-21 07:15:00 | SPY | ETF | 522.56 | 522.59 | 522.4 | 522.57 | 37438.0 |
| 2024-03-21 07:20:00 | SPY | ETF | 522.57 | 522.67 | 522.5 | 522.52 | 12384.0 |
| 2024-03-21 07:25:00 | SPY | ETF | 522.52 | 522.56 | 522.5 | 522.5 | 5518.0 |
| 2024-03-21 07:30:00 | SPY | ETF | 522.5 | 522.72 | 522.46 | 522.72 | 10731.0 |
| 2024-03-21 07:35:00 | SPY | ETF | 522.7 | 522.88 | 522.66 | 522.88 | 17155.0 |
| 2024-03-21 07:40:00 | SPY | ETF | 522.84 | 522.95 | 522.77 | 522.79 | 13536.0 |
| 2024-03-21 07:45:00 | SPY | ETF | 522.83 | 522.87 | 522.79 | 522.83 | 4378.0 |
| 2024-03-21 07:50:00 | SPY | ETF | 522.83 | 522.83 | 522.69 | 522.77 | 24153.0 |
| 2024-03-21 07:55:00 | SPY | ETF | 522.74 | 522.76 | 522.69 | 522.76 | 14528.0 |
| 2024-03-21 08:00:00 | SPY | ETF | 522.78 | 523.34 | 522.1204 | 523.09 | 84329.0 |
| 2024-03-21 08:05:00 | SPY | ETF | 523.09 | 523.15 | 522.93 | 522.93 | 13584.0 |
| 2024-03-21 08:10:00 | SPY | ETF | 522.94 | 522.97 | 522.85 | 522.93 | 14256.0 |
> showing 50 of 113,183 rows — these rows as CSV