PREVIEW / stock_5min / 2022-09-09
file: by_date/stock_5min/2022/2022-09-09.parquet size: 6.8 MB rows: 421,583 symbols: 2,203
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-09-09 04:00:00 | AAPL | Stock | 155.3 | 155.77 | 155.3 | 155.3 | 10794.0 |
| 2022-09-09 04:05:00 | AAPL | Stock | 155.35 | 155.45 | 155.3 | 155.39 | 2814.0 |
| 2022-09-09 04:10:00 | AAPL | Stock | 155.39 | 155.45 | 155.32 | 155.37 | 14004.0 |
| 2022-09-09 04:15:00 | AAPL | Stock | 155.37 | 155.74 | 155.36 | 155.7 | 10723.0 |
| 2022-09-09 04:20:00 | AAPL | Stock | 155.76 | 155.76 | 155.72 | 155.75 | 2297.0 |
| 2022-09-09 04:25:00 | AAPL | Stock | 155.77 | 155.77 | 155.65 | 155.66 | 1069.0 |
| 2022-09-09 04:30:00 | AAPL | Stock | 155.69 | 155.7 | 155.6 | 155.6 | 3115.0 |
| 2022-09-09 04:35:00 | AAPL | Stock | 155.5 | 155.5 | 155.48 | 155.48 | 677.0 |
| 2022-09-09 04:40:00 | AAPL | Stock | 155.42 | 155.68 | 155.42 | 155.68 | 2893.0 |
| 2022-09-09 04:45:00 | AAPL | Stock | 155.64 | 155.75 | 155.64 | 155.74 | 4293.0 |
| 2022-09-09 04:50:00 | AAPL | Stock | 155.7 | 155.83 | 155.7 | 155.83 | 7550.0 |
| 2022-09-09 04:55:00 | AAPL | Stock | 155.83 | 155.88 | 155.8 | 155.86 | 2784.0 |
| 2022-09-09 05:00:00 | AAPL | Stock | 155.83 | 155.86 | 155.68 | 155.7 | 3718.0 |
| 2022-09-09 05:05:00 | AAPL | Stock | 155.69 | 155.7 | 155.69 | 155.7 | 565.0 |
| 2022-09-09 05:10:00 | AAPL | Stock | 155.86 | 155.87 | 155.86 | 155.87 | 562.0 |
| 2022-09-09 05:15:00 | AAPL | Stock | 155.84 | 155.9 | 155.84 | 155.88 | 1829.0 |
| 2022-09-09 05:20:00 | AAPL | Stock | 155.87 | 155.88 | 155.85 | 155.88 | 1005.0 |
| 2022-09-09 05:25:00 | AAPL | Stock | 155.9 | 155.92 | 155.83 | 155.83 | 2070.0 |
| 2022-09-09 05:35:00 | AAPL | Stock | 155.84 | 155.85 | 155.84 | 155.85 | 243.0 |
| 2022-09-09 05:40:00 | AAPL | Stock | 155.93 | 156.0 | 155.84 | 155.84 | 966.0 |
| 2022-09-09 05:45:00 | AAPL | Stock | 155.84 | 155.84 | 155.84 | 155.84 | 100.0 |
| 2022-09-09 05:50:00 | AAPL | Stock | 155.77 | 155.77 | 155.7 | 155.7 | 655.0 |
| 2022-09-09 05:55:00 | AAPL | Stock | 155.84 | 155.84 | 155.77 | 155.8 | 1037.0 |
| 2022-09-09 06:05:00 | AAPL | Stock | 155.75 | 155.84 | 155.75 | 155.84 | 1340.0 |
| 2022-09-09 06:10:00 | AAPL | Stock | 155.8 | 155.81 | 155.8 | 155.81 | 7211.0 |
| 2022-09-09 06:15:00 | AAPL | Stock | 155.82 | 155.98 | 155.81 | 155.85 | 5211.0 |
| 2022-09-09 06:20:00 | AAPL | Stock | 155.9 | 155.9 | 155.85 | 155.85 | 850.0 |
| 2022-09-09 06:25:00 | AAPL | Stock | 155.87 | 155.99 | 155.87 | 155.99 | 3656.0 |
| 2022-09-09 06:30:00 | AAPL | Stock | 155.99 | 156.0 | 155.97 | 155.98 | 4119.0 |
| 2022-09-09 06:35:00 | AAPL | Stock | 155.98 | 156.1 | 155.98 | 156.04 | 7941.0 |
| 2022-09-09 06:40:00 | AAPL | Stock | 156.02 | 156.21 | 155.98 | 156.21 | 12526.0 |
| 2022-09-09 06:45:00 | AAPL | Stock | 156.29 | 156.37 | 156.22 | 156.25 | 3697.0 |
| 2022-09-09 06:50:00 | AAPL | Stock | 156.2 | 156.21 | 156.09 | 156.09 | 11830.0 |
| 2022-09-09 07:00:00 | AAPL | Stock | 156.1 | 156.1 | 155.7 | 155.72 | 61432.0 |
| 2022-09-09 07:05:00 | AAPL | Stock | 155.79 | 155.84 | 155.79 | 155.8 | 3601.0 |
| 2022-09-09 07:10:00 | AAPL | Stock | 155.8 | 155.81 | 155.68 | 155.78 | 11942.0 |
| 2022-09-09 07:15:00 | AAPL | Stock | 155.8 | 155.84 | 155.78 | 155.78 | 6934.0 |
| 2022-09-09 07:20:00 | AAPL | Stock | 155.75 | 155.75 | 155.74 | 155.74 | 2392.0 |
| 2022-09-09 07:25:00 | AAPL | Stock | 155.73 | 155.77 | 155.7 | 155.7 | 3155.0 |
| 2022-09-09 07:30:00 | AAPL | Stock | 155.7 | 155.7 | 155.62 | 155.67 | 6058.0 |
| 2022-09-09 07:35:00 | AAPL | Stock | 155.68 | 155.76 | 155.68 | 155.75 | 11614.0 |
| 2022-09-09 07:40:00 | AAPL | Stock | 155.72 | 155.74 | 155.71 | 155.71 | 1017.0 |
| 2022-09-09 07:45:00 | AAPL | Stock | 155.69 | 155.7 | 155.62 | 155.62 | 3581.0 |
| 2022-09-09 07:50:00 | AAPL | Stock | 155.62 | 155.67 | 155.62 | 155.65 | 1929.0 |
| 2022-09-09 07:55:00 | AAPL | Stock | 155.65 | 155.65 | 155.53 | 155.63 | 9319.0 |
| 2022-09-09 08:00:00 | AAPL | Stock | 155.98 | 156.035 | 155.5401 | 155.6 | 82021.0 |
| 2022-09-09 08:05:00 | AAPL | Stock | 155.56 | 155.58 | 155.33 | 155.33 | 16465.0 |
| 2022-09-09 08:10:00 | AAPL | Stock | 155.38 | 155.51 | 155.32 | 155.44 | 24612.0 |
| 2022-09-09 08:15:00 | AAPL | Stock | 155.45 | 155.62 | 155.41 | 155.58 | 25996.0 |
| 2022-09-09 08:20:00 | AAPL | Stock | 155.6 | 155.65 | 155.57 | 155.64 | 11029.0 |
> showing 50 of 421,583 rows — these rows as CSV