PREVIEW / etf_5min / 2021-04-27
file: by_date/etf_5min/2021/2021-04-27.parquet size: 1.7 MB rows: 80,042
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 |
|---|---|---|---|---|---|---|---|
| 2021-04-27 04:00:00 | SPY | ETF | 418.06 | 418.12 | 418.06 | 418.12 | 505.0 |
| 2021-04-27 04:05:00 | SPY | ETF | 418.18 | 418.27 | 418.0 | 418.0 | 1080.0 |
| 2021-04-27 04:10:00 | SPY | ETF | 417.86 | 417.86 | 417.81 | 417.82 | 2410.0 |
| 2021-04-27 04:15:00 | SPY | ETF | 417.95 | 417.95 | 417.95 | 417.95 | 100.0 |
| 2021-04-27 04:20:00 | SPY | ETF | 417.96 | 417.96 | 417.96 | 417.96 | 100.0 |
| 2021-04-27 04:25:00 | SPY | ETF | 417.92 | 418.04 | 417.92 | 418.04 | 700.0 |
| 2021-04-27 04:30:00 | SPY | ETF | 418.01 | 418.07 | 418.01 | 418.06 | 800.0 |
| 2021-04-27 04:35:00 | SPY | ETF | 418.05 | 418.05 | 418.05 | 418.05 | 100.0 |
| 2021-04-27 04:45:00 | SPY | ETF | 417.99 | 418.01 | 417.97 | 418.01 | 1300.0 |
| 2021-04-27 05:00:00 | SPY | ETF | 418.07 | 418.07 | 418.04 | 418.07 | 679.0 |
| 2021-04-27 05:05:00 | SPY | ETF | 418.07 | 418.09 | 418.03 | 418.05 | 5494.0 |
| 2021-04-27 05:10:00 | SPY | ETF | 418.05 | 418.05 | 418.02 | 418.05 | 2600.0 |
| 2021-04-27 05:15:00 | SPY | ETF | 417.99 | 417.99 | 417.99 | 417.99 | 495.0 |
| 2021-04-27 05:20:00 | SPY | ETF | 418.08 | 418.08 | 418.08 | 418.08 | 151.0 |
| 2021-04-27 05:25:00 | SPY | ETF | 417.99 | 417.99 | 417.98 | 417.99 | 571.0 |
| 2021-04-27 05:30:00 | SPY | ETF | 418.01 | 418.01 | 417.9 | 417.94 | 3700.0 |
| 2021-04-27 05:35:00 | SPY | ETF | 417.85 | 417.89 | 417.85 | 417.85 | 3100.0 |
| 2021-04-27 05:40:00 | SPY | ETF | 417.89 | 417.95 | 417.89 | 417.91 | 1764.0 |
| 2021-04-27 05:45:00 | SPY | ETF | 417.75 | 417.78 | 417.7 | 417.77 | 6169.0 |
| 2021-04-27 05:50:00 | SPY | ETF | 417.69 | 417.69 | 417.32 | 417.44 | 8688.0 |
| 2021-04-27 05:55:00 | SPY | ETF | 417.47 | 417.6 | 417.47 | 417.52 | 550.0 |
| 2021-04-27 06:00:00 | SPY | ETF | 417.47 | 417.54 | 417.43 | 417.52 | 7330.0 |
| 2021-04-27 06:05:00 | SPY | ETF | 417.53 | 417.55 | 417.52 | 417.55 | 1609.0 |
| 2021-04-27 06:10:00 | SPY | ETF | 417.64 | 417.72 | 417.64 | 417.72 | 480.0 |
| 2021-04-27 06:15:00 | SPY | ETF | 417.83 | 417.83 | 417.79 | 417.79 | 300.0 |
| 2021-04-27 06:20:00 | SPY | ETF | 417.82 | 417.87 | 417.82 | 417.82 | 493.0 |
| 2021-04-27 06:25:00 | SPY | ETF | 417.76 | 417.83 | 417.76 | 417.82 | 1409.0 |
| 2021-04-27 06:30:00 | SPY | ETF | 417.8 | 417.81 | 417.79 | 417.79 | 1500.0 |
| 2021-04-27 06:35:00 | SPY | ETF | 417.77 | 417.77 | 417.72 | 417.72 | 700.0 |
| 2021-04-27 06:45:00 | SPY | ETF | 417.84 | 417.85 | 417.81 | 417.85 | 701.0 |
| 2021-04-27 06:50:00 | SPY | ETF | 417.9 | 417.9 | 417.9 | 417.9 | 700.0 |
| 2021-04-27 06:55:00 | SPY | ETF | 417.9 | 418.05 | 417.9 | 417.99 | 35200.0 |
| 2021-04-27 07:00:00 | SPY | ETF | 418.0 | 418.11 | 418.0 | 418.08 | 6100.0 |
| 2021-04-27 07:05:00 | SPY | ETF | 418.07 | 418.08 | 418.04 | 418.06 | 2700.0 |
| 2021-04-27 07:10:00 | SPY | ETF | 418.03 | 418.06 | 418.0 | 418.03 | 1202.0 |
| 2021-04-27 07:15:00 | SPY | ETF | 418.02 | 418.09 | 418.02 | 418.08 | 4091.0 |
| 2021-04-27 07:20:00 | SPY | ETF | 418.05 | 418.06 | 417.92 | 417.92 | 2773.0 |
| 2021-04-27 07:25:00 | SPY | ETF | 417.92 | 417.98 | 417.88 | 417.98 | 4595.0 |
| 2021-04-27 07:30:00 | SPY | ETF | 417.98 | 418.1 | 417.96 | 418.09 | 10093.0 |
| 2021-04-27 07:35:00 | SPY | ETF | 418.06 | 418.07 | 417.99 | 418.0 | 5894.0 |
| 2021-04-27 07:40:00 | SPY | ETF | 418.0 | 418.02 | 417.89 | 417.92 | 17413.0 |
| 2021-04-27 07:45:00 | SPY | ETF | 417.9 | 417.95 | 417.8 | 417.95 | 8114.0 |
| 2021-04-27 07:50:00 | SPY | ETF | 417.99 | 417.99 | 417.84 | 417.88 | 5134.0 |
| 2021-04-27 07:55:00 | SPY | ETF | 417.9 | 417.96 | 417.9 | 417.94 | 3058.0 |
| 2021-04-27 08:00:00 | SPY | ETF | 418.0599 | 418.49 | 417.7496 | 417.9 | 14854.0 |
| 2021-04-27 08:05:00 | SPY | ETF | 417.92 | 418.09 | 417.92 | 418.09 | 5592.0 |
| 2021-04-27 08:10:00 | SPY | ETF | 418.09 | 418.12 | 417.42 | 418.11 | 32508.0 |
| 2021-04-27 08:15:00 | SPY | ETF | 418.12 | 418.13 | 418.05 | 418.1 | 13671.0 |
| 2021-04-27 08:20:00 | SPY | ETF | 418.1 | 418.17 | 418.1 | 418.13 | 17798.0 |
| 2021-04-27 08:25:00 | SPY | ETF | 418.14 | 418.15 | 418.0 | 418.0 | 8453.0 |
> showing 50 of 80,042 rows — these rows as CSV