PREVIEW / stock_5min / 2023-05-26
file: by_date/stock_5min/2023/2023-05-26.parquet size: 6.6 MB rows: 405,713 symbols: 1,652
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 |
|---|---|---|---|---|---|---|---|
| 2023-05-26 04:00:00 | AAPL | Stock | 172.7 | 172.7 | 172.7 | 172.7 | 668.0 |
| 2023-05-26 04:05:00 | AAPL | Stock | 172.8 | 172.8 | 172.8 | 172.8 | 115.0 |
| 2023-05-26 04:20:00 | AAPL | Stock | 172.98 | 173.09 | 172.98 | 173.09 | 477.0 |
| 2023-05-26 04:25:00 | AAPL | Stock | 173.03 | 173.03 | 173.0 | 173.0 | 300.0 |
| 2023-05-26 04:35:00 | AAPL | Stock | 172.98 | 173.02 | 172.98 | 173.02 | 3996.0 |
| 2023-05-26 04:40:00 | AAPL | Stock | 173.05 | 173.12 | 173.05 | 173.12 | 1833.0 |
| 2023-05-26 05:00:00 | AAPL | Stock | 173.31 | 173.31 | 173.31 | 173.31 | 339.0 |
| 2023-05-26 05:15:00 | AAPL | Stock | 173.09 | 173.1 | 173.09 | 173.1 | 202.0 |
| 2023-05-26 05:35:00 | AAPL | Stock | 173.08 | 173.08 | 173.0 | 173.0 | 985.0 |
| 2023-05-26 05:40:00 | AAPL | Stock | 173.0 | 173.01 | 173.0 | 173.01 | 638.0 |
| 2023-05-26 05:55:00 | AAPL | Stock | 173.0 | 173.0 | 173.0 | 173.0 | 239.0 |
| 2023-05-26 06:00:00 | AAPL | Stock | 173.02 | 173.02 | 173.0 | 173.0 | 851.0 |
| 2023-05-26 06:05:00 | AAPL | Stock | 172.92 | 172.92 | 172.92 | 172.92 | 600.0 |
| 2023-05-26 06:15:00 | AAPL | Stock | 173.03 | 173.03 | 173.03 | 173.03 | 200.0 |
| 2023-05-26 06:20:00 | AAPL | Stock | 173.03 | 173.03 | 173.03 | 173.03 | 700.0 |
| 2023-05-26 06:25:00 | AAPL | Stock | 173.02 | 173.14 | 173.01 | 173.01 | 546.0 |
| 2023-05-26 06:40:00 | AAPL | Stock | 173.3 | 173.3 | 173.3 | 173.3 | 291.0 |
| 2023-05-26 06:45:00 | AAPL | Stock | 173.34 | 173.38 | 173.31 | 173.38 | 913.0 |
| 2023-05-26 07:00:00 | AAPL | Stock | 173.3 | 173.39 | 173.3 | 173.39 | 1508.0 |
| 2023-05-26 07:05:00 | AAPL | Stock | 173.45 | 173.45 | 173.39 | 173.39 | 2036.0 |
| 2023-05-26 07:10:00 | AAPL | Stock | 173.35 | 173.35 | 173.34 | 173.34 | 600.0 |
| 2023-05-26 07:15:00 | AAPL | Stock | 173.42 | 173.42 | 173.35 | 173.35 | 2900.0 |
| 2023-05-26 07:20:00 | AAPL | Stock | 173.33 | 173.37 | 173.32 | 173.37 | 3029.0 |
| 2023-05-26 07:25:00 | AAPL | Stock | 173.43 | 173.45 | 173.43 | 173.43 | 437.0 |
| 2023-05-26 07:30:00 | AAPL | Stock | 173.45 | 173.47 | 173.37 | 173.4 | 2460.0 |
| 2023-05-26 07:35:00 | AAPL | Stock | 173.38 | 173.4 | 173.35 | 173.35 | 1354.0 |
| 2023-05-26 07:40:00 | AAPL | Stock | 173.35 | 173.48 | 173.32 | 173.33 | 5945.0 |
| 2023-05-26 07:45:00 | AAPL | Stock | 173.39 | 173.49 | 173.39 | 173.49 | 1191.0 |
| 2023-05-26 07:50:00 | AAPL | Stock | 173.45 | 173.5 | 173.45 | 173.45 | 2113.0 |
| 2023-05-26 07:55:00 | AAPL | Stock | 173.42 | 173.44 | 173.42 | 173.44 | 275.0 |
| 2023-05-26 08:00:00 | AAPL | Stock | 173.35 | 173.49 | 172.57 | 173.36 | 44201.0 |
| 2023-05-26 08:05:00 | AAPL | Stock | 173.31 | 173.4 | 173.31 | 173.3786 | 3308.0 |
| 2023-05-26 08:10:00 | AAPL | Stock | 173.36 | 173.39 | 173.35 | 173.37 | 5415.0 |
| 2023-05-26 08:15:00 | AAPL | Stock | 173.36 | 173.37 | 173.25 | 173.25 | 7834.0 |
| 2023-05-26 08:20:00 | AAPL | Stock | 173.32 | 173.33 | 173.23 | 173.33 | 3573.0 |
| 2023-05-26 08:25:00 | AAPL | Stock | 173.27 | 173.3 | 173.23 | 173.3 | 4652.0 |
| 2023-05-26 08:30:00 | AAPL | Stock | 173.4 | 173.4 | 173.06 | 173.1 | 28437.0 |
| 2023-05-26 08:35:00 | AAPL | Stock | 173.07 | 173.1 | 172.9 | 172.93 | 13430.0 |
| 2023-05-26 08:40:00 | AAPL | Stock | 172.99 | 173.14 | 172.97 | 173.1 | 4998.0 |
| 2023-05-26 08:45:00 | AAPL | Stock | 173.1 | 173.27 | 172.9647 | 173.25 | 8611.0 |
| 2023-05-26 08:50:00 | AAPL | Stock | 173.29 | 173.31 | 173.11 | 173.3 | 5000.0 |
| 2023-05-26 08:55:00 | AAPL | Stock | 173.37 | 173.39 | 173.25 | 173.2842 | 5121.0 |
| 2023-05-26 09:00:00 | AAPL | Stock | 173.39 | 173.44 | 173.33 | 173.3551 | 6365.0 |
| 2023-05-26 09:05:00 | AAPL | Stock | 173.33 | 173.4 | 173.33 | 173.4 | 10031.0 |
| 2023-05-26 09:10:00 | AAPL | Stock | 173.49 | 173.65 | 173.49 | 173.58 | 22410.0 |
| 2023-05-26 09:15:00 | AAPL | Stock | 173.61 | 173.62 | 173.51 | 173.62 | 8991.0 |
| 2023-05-26 09:20:00 | AAPL | Stock | 173.63 | 173.68 | 173.45 | 173.45 | 16823.0 |
| 2023-05-26 09:25:00 | AAPL | Stock | 173.41 | 173.63 | 173.2 | 173.31 | 32215.0 |
| 2023-05-26 09:30:00 | AAPL | Stock | 173.31 | 173.87 | 173.11 | 173.5 | 1408228.0 |
| 2023-05-26 09:35:00 | AAPL | Stock | 173.48 | 174.3 | 173.37 | 174.286 | 909840.0 |
> showing 50 of 405,713 rows — these rows as CSV