PREVIEW / etf_5min / 2022-01-27
file: by_date/etf_5min/2022/2022-01-27.parquet size: 2.1 MB rows: 102,623
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 |
|---|---|---|---|---|---|---|---|
| 2022-01-27 04:00:00 | SPY | ETF | 432.27 | 433.36 | 431.93 | 432.62 | 29764.0 |
| 2022-01-27 04:05:00 | SPY | ETF | 432.6 | 432.67 | 432.02 | 432.02 | 39563.0 |
| 2022-01-27 04:10:00 | SPY | ETF | 432.22 | 432.87 | 431.91 | 432.65 | 5300.0 |
| 2022-01-27 04:15:00 | SPY | ETF | 432.82 | 432.97 | 432.4 | 432.65 | 1800.0 |
| 2022-01-27 04:20:00 | SPY | ETF | 432.78 | 433.57 | 432.77 | 433.51 | 23658.0 |
| 2022-01-27 04:25:00 | SPY | ETF | 433.38 | 433.95 | 433.35 | 433.68 | 11190.0 |
| 2022-01-27 04:30:00 | SPY | ETF | 433.1 | 433.17 | 433.02 | 433.02 | 6000.0 |
| 2022-01-27 04:35:00 | SPY | ETF | 433.0 | 433.25 | 432.9 | 433.23 | 7849.0 |
| 2022-01-27 04:40:00 | SPY | ETF | 433.05 | 433.88 | 433.05 | 433.88 | 500.0 |
| 2022-01-27 04:45:00 | SPY | ETF | 433.69 | 434.29 | 433.68 | 434.1 | 10966.0 |
| 2022-01-27 04:50:00 | SPY | ETF | 434.3 | 434.47 | 434.27 | 434.3 | 10035.0 |
| 2022-01-27 04:55:00 | SPY | ETF | 434.36 | 434.41 | 434.08 | 434.27 | 5599.0 |
| 2022-01-27 05:00:00 | SPY | ETF | 434.06 | 434.71 | 434.03 | 434.71 | 4988.0 |
| 2022-01-27 05:05:00 | SPY | ETF | 434.71 | 434.79 | 434.5 | 434.52 | 5696.0 |
| 2022-01-27 05:10:00 | SPY | ETF | 434.49 | 434.49 | 433.56 | 433.73 | 12189.0 |
| 2022-01-27 05:15:00 | SPY | ETF | 433.79 | 433.86 | 433.78 | 433.84 | 4605.0 |
| 2022-01-27 05:20:00 | SPY | ETF | 433.38 | 433.94 | 433.38 | 433.94 | 1350.0 |
| 2022-01-27 05:25:00 | SPY | ETF | 433.81 | 434.22 | 433.81 | 434.05 | 1490.0 |
| 2022-01-27 05:30:00 | SPY | ETF | 433.99 | 434.04 | 433.76 | 433.76 | 2060.0 |
| 2022-01-27 05:35:00 | SPY | ETF | 433.89 | 434.11 | 433.89 | 434.08 | 2025.0 |
| 2022-01-27 05:40:00 | SPY | ETF | 434.18 | 434.18 | 433.45 | 433.45 | 5135.0 |
| 2022-01-27 05:45:00 | SPY | ETF | 433.54 | 433.89 | 433.14 | 433.14 | 3700.0 |
| 2022-01-27 05:50:00 | SPY | ETF | 433.0 | 433.0 | 432.2 | 432.47 | 14487.0 |
| 2022-01-27 05:55:00 | SPY | ETF | 432.03 | 432.03 | 431.6 | 431.89 | 38731.0 |
| 2022-01-27 06:00:00 | SPY | ETF | 431.99 | 432.91 | 431.99 | 432.91 | 15411.0 |
| 2022-01-27 06:05:00 | SPY | ETF | 432.85 | 433.13 | 432.81 | 432.81 | 4038.0 |
| 2022-01-27 06:10:00 | SPY | ETF | 433.04 | 433.38 | 433.04 | 433.38 | 2619.0 |
| 2022-01-27 06:15:00 | SPY | ETF | 433.4 | 433.74 | 433.2 | 433.2 | 5500.0 |
| 2022-01-27 06:20:00 | SPY | ETF | 433.2 | 433.29 | 433.0 | 433.29 | 550.0 |
| 2022-01-27 06:25:00 | SPY | ETF | 433.38 | 434.15 | 433.36 | 434.1 | 9470.0 |
| 2022-01-27 06:30:00 | SPY | ETF | 433.9 | 434.27 | 433.9 | 433.9 | 11109.0 |
| 2022-01-27 06:35:00 | SPY | ETF | 434.15 | 434.15 | 433.14 | 433.25 | 3233.0 |
| 2022-01-27 06:40:00 | SPY | ETF | 433.14 | 433.71 | 433.14 | 433.5 | 11080.0 |
| 2022-01-27 06:45:00 | SPY | ETF | 433.41 | 433.7 | 433.0 | 433.54 | 15919.0 |
| 2022-01-27 06:50:00 | SPY | ETF | 433.7 | 434.21 | 433.7 | 434.0 | 55740.0 |
| 2022-01-27 06:55:00 | SPY | ETF | 433.77 | 434.58 | 433.76 | 434.43 | 9937.0 |
| 2022-01-27 07:00:00 | SPY | ETF | 434.5 | 434.58 | 434.1 | 434.24 | 37946.0 |
| 2022-01-27 07:05:00 | SPY | ETF | 434.18 | 434.21 | 433.83 | 434.19 | 17625.0 |
| 2022-01-27 07:10:00 | SPY | ETF | 434.21 | 435.2 | 434.2 | 435.13 | 24117.0 |
| 2022-01-27 07:15:00 | SPY | ETF | 435.0 | 435.25 | 433.88 | 433.88 | 63087.0 |
| 2022-01-27 07:20:00 | SPY | ETF | 433.98 | 434.05 | 433.11 | 433.11 | 51490.0 |
| 2022-01-27 07:25:00 | SPY | ETF | 433.09 | 433.85 | 433.06 | 433.75 | 54813.0 |
| 2022-01-27 07:30:00 | SPY | ETF | 433.54 | 433.84 | 432.73 | 432.73 | 20128.0 |
| 2022-01-27 07:35:00 | SPY | ETF | 432.73 | 433.7 | 432.73 | 433.3 | 19643.0 |
| 2022-01-27 07:40:00 | SPY | ETF | 433.38 | 433.65 | 433.2 | 433.25 | 17480.0 |
| 2022-01-27 07:45:00 | SPY | ETF | 433.29 | 434.23 | 433.29 | 434.0 | 61533.0 |
| 2022-01-27 07:50:00 | SPY | ETF | 434.0 | 435.29 | 433.9 | 435.0 | 71907.0 |
| 2022-01-27 07:55:00 | SPY | ETF | 434.94 | 435.29 | 434.62 | 434.74 | 83540.0 |
| 2022-01-27 08:00:00 | SPY | ETF | 434.0499 | 435.42 | 426.85 | 434.77 | 106988.0 |
| 2022-01-27 08:05:00 | SPY | ETF | 434.77 | 435.87 | 430.69 | 435.87 | 63881.0 |
> showing 50 of 102,623 rows — these rows as CSV