PREVIEW / stock_5min / 2023-05-15
file: by_date/stock_5min/2023/2023-05-15.parquet size: 6.7 MB rows: 409,023 symbols: 1,669
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-15 04:00:00 | AAPL | Stock | 172.59 | 173.0 | 172.59 | 172.9 | 2033.0 |
| 2023-05-15 04:05:00 | AAPL | Stock | 172.91 | 172.91 | 172.9 | 172.9 | 1484.0 |
| 2023-05-15 04:10:00 | AAPL | Stock | 172.95 | 172.95 | 172.81 | 172.93 | 978.0 |
| 2023-05-15 04:15:00 | AAPL | Stock | 172.86 | 172.88 | 172.86 | 172.87 | 900.0 |
| 2023-05-15 04:20:00 | AAPL | Stock | 172.95 | 172.97 | 172.92 | 172.94 | 1600.0 |
| 2023-05-15 04:25:00 | AAPL | Stock | 172.95 | 172.99 | 172.95 | 172.99 | 1269.0 |
| 2023-05-15 04:30:00 | AAPL | Stock | 172.94 | 172.99 | 172.94 | 172.95 | 1901.0 |
| 2023-05-15 04:35:00 | AAPL | Stock | 172.95 | 172.98 | 172.95 | 172.95 | 921.0 |
| 2023-05-15 04:40:00 | AAPL | Stock | 172.95 | 172.98 | 172.95 | 172.97 | 509.0 |
| 2023-05-15 04:45:00 | AAPL | Stock | 172.97 | 172.98 | 172.9 | 172.9 | 1490.0 |
| 2023-05-15 04:50:00 | AAPL | Stock | 172.83 | 172.83 | 172.83 | 172.83 | 1149.0 |
| 2023-05-15 04:55:00 | AAPL | Stock | 172.83 | 172.83 | 172.75 | 172.75 | 1487.0 |
| 2023-05-15 05:00:00 | AAPL | Stock | 172.89 | 172.89 | 172.89 | 172.89 | 209.0 |
| 2023-05-15 05:15:00 | AAPL | Stock | 172.94 | 172.94 | 172.88 | 172.88 | 799.0 |
| 2023-05-15 05:20:00 | AAPL | Stock | 172.88 | 172.91 | 172.88 | 172.91 | 3288.0 |
| 2023-05-15 05:30:00 | AAPL | Stock | 172.85 | 172.91 | 172.85 | 172.9 | 6839.0 |
| 2023-05-15 05:35:00 | AAPL | Stock | 172.9 | 172.9 | 172.9 | 172.9 | 1263.0 |
| 2023-05-15 06:00:00 | AAPL | Stock | 172.89 | 172.89 | 172.89 | 172.89 | 478.0 |
| 2023-05-15 06:05:00 | AAPL | Stock | 172.84 | 172.84 | 172.84 | 172.84 | 300.0 |
| 2023-05-15 06:10:00 | AAPL | Stock | 172.8 | 172.82 | 172.8 | 172.82 | 220.0 |
| 2023-05-15 06:15:00 | AAPL | Stock | 172.81 | 172.81 | 172.78 | 172.78 | 739.0 |
| 2023-05-15 06:20:00 | AAPL | Stock | 172.89 | 172.9 | 172.89 | 172.9 | 388.0 |
| 2023-05-15 06:35:00 | AAPL | Stock | 172.94 | 172.95 | 172.94 | 172.94 | 923.0 |
| 2023-05-15 06:45:00 | AAPL | Stock | 172.92 | 172.92 | 172.9 | 172.9 | 419.0 |
| 2023-05-15 07:00:00 | AAPL | Stock | 172.9 | 173.0 | 172.86 | 172.94 | 13361.0 |
| 2023-05-15 07:05:00 | AAPL | Stock | 172.91 | 173.1 | 172.91 | 173.0 | 10999.0 |
| 2023-05-15 07:10:00 | AAPL | Stock | 173.0 | 173.1 | 173.0 | 173.09 | 5134.0 |
| 2023-05-15 07:15:00 | AAPL | Stock | 173.14 | 173.3 | 173.13 | 173.23 | 12420.0 |
| 2023-05-15 07:20:00 | AAPL | Stock | 173.23 | 173.32 | 173.23 | 173.32 | 7222.0 |
| 2023-05-15 07:25:00 | AAPL | Stock | 173.22 | 173.25 | 173.22 | 173.25 | 1736.0 |
| 2023-05-15 07:30:00 | AAPL | Stock | 173.26 | 173.26 | 173.01 | 173.23 | 10198.0 |
| 2023-05-15 07:35:00 | AAPL | Stock | 173.2 | 173.28 | 173.17 | 173.27 | 5158.0 |
| 2023-05-15 07:40:00 | AAPL | Stock | 173.17 | 173.18 | 173.17 | 173.17 | 1499.0 |
| 2023-05-15 07:45:00 | AAPL | Stock | 173.18 | 173.18 | 173.17 | 173.17 | 300.0 |
| 2023-05-15 07:50:00 | AAPL | Stock | 173.17 | 173.19 | 172.95 | 173.0 | 17269.0 |
| 2023-05-15 07:55:00 | AAPL | Stock | 173.01 | 173.09 | 172.97 | 173.0 | 7125.0 |
| 2023-05-15 08:00:00 | AAPL | Stock | 172.9219 | 173.3 | 172.16 | 173.1 | 56963.0 |
| 2023-05-15 08:05:00 | AAPL | Stock | 173.05 | 173.15 | 173.05 | 173.14 | 2534.0 |
| 2023-05-15 08:10:00 | AAPL | Stock | 173.14 | 173.15 | 173.08 | 173.13 | 2767.0 |
| 2023-05-15 08:15:00 | AAPL | Stock | 173.13 | 173.15 | 173.1 | 173.1 | 4912.0 |
| 2023-05-15 08:20:00 | AAPL | Stock | 173.09 | 173.15 | 172.95 | 172.96 | 7153.0 |
| 2023-05-15 08:25:00 | AAPL | Stock | 172.93 | 172.9694 | 172.89 | 172.94 | 13083.0 |
| 2023-05-15 08:30:00 | AAPL | Stock | 172.98 | 173.18 | 172.8 | 172.95 | 13801.0 |
| 2023-05-15 08:35:00 | AAPL | Stock | 172.96 | 173.0 | 172.89 | 172.9 | 10764.0 |
| 2023-05-15 08:40:00 | AAPL | Stock | 172.9001 | 172.9899 | 172.9 | 172.93 | 3407.0 |
| 2023-05-15 08:45:00 | AAPL | Stock | 172.95 | 173.15 | 172.95 | 173.07 | 12030.0 |
| 2023-05-15 08:50:00 | AAPL | Stock | 173.12 | 173.13 | 173.03 | 173.05 | 4316.0 |
| 2023-05-15 08:55:00 | AAPL | Stock | 173.07 | 173.12 | 173.0 | 173.09 | 8545.0 |
| 2023-05-15 09:00:00 | AAPL | Stock | 173.1 | 173.14 | 173.07 | 173.09 | 17141.0 |
| 2023-05-15 09:05:00 | AAPL | Stock | 173.1 | 173.2 | 173.1 | 173.1901 | 13700.0 |
> showing 50 of 409,023 rows — these rows as CSV