PREVIEW / stock_5min / 2024-03-28
file: by_date/stock_5min/2024/2024-03-28.parquet size: 6.7 MB rows: 410,694 symbols: 1,064
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 |
|---|---|---|---|---|---|---|---|
| 2024-03-28 04:00:00 | AAPL | Stock | 173.17 | 173.38 | 173.06 | 173.06 | 1434.0 |
| 2024-03-28 04:05:00 | AAPL | Stock | 173.07 | 173.07 | 172.7 | 172.92 | 4774.0 |
| 2024-03-28 04:10:00 | AAPL | Stock | 172.82 | 172.83 | 172.8 | 172.8 | 450.0 |
| 2024-03-28 04:15:00 | AAPL | Stock | 172.92 | 173.04 | 172.92 | 173.04 | 500.0 |
| 2024-03-28 04:25:00 | AAPL | Stock | 172.96 | 172.96 | 172.96 | 172.96 | 439.0 |
| 2024-03-28 04:30:00 | AAPL | Stock | 172.99 | 172.99 | 172.99 | 172.99 | 100.0 |
| 2024-03-28 04:40:00 | AAPL | Stock | 173.0 | 173.0 | 173.0 | 173.0 | 100.0 |
| 2024-03-28 04:45:00 | AAPL | Stock | 173.0 | 173.0 | 173.0 | 173.0 | 216.0 |
| 2024-03-28 04:50:00 | AAPL | Stock | 172.97 | 172.97 | 172.97 | 172.97 | 142.0 |
| 2024-03-28 04:55:00 | AAPL | Stock | 172.89 | 172.89 | 172.77 | 172.77 | 1361.0 |
| 2024-03-28 05:00:00 | AAPL | Stock | 172.74 | 172.8 | 172.74 | 172.8 | 3113.0 |
| 2024-03-28 05:10:00 | AAPL | Stock | 172.74 | 172.74 | 172.74 | 172.74 | 365.0 |
| 2024-03-28 05:15:00 | AAPL | Stock | 172.75 | 172.75 | 172.52 | 172.52 | 1188.0 |
| 2024-03-28 05:20:00 | AAPL | Stock | 172.53 | 172.54 | 172.53 | 172.54 | 715.0 |
| 2024-03-28 05:30:00 | AAPL | Stock | 172.6 | 172.6 | 172.6 | 172.6 | 494.0 |
| 2024-03-28 05:35:00 | AAPL | Stock | 172.68 | 172.68 | 172.68 | 172.68 | 137.0 |
| 2024-03-28 05:45:00 | AAPL | Stock | 172.6 | 172.6 | 172.6 | 172.6 | 100.0 |
| 2024-03-28 05:50:00 | AAPL | Stock | 172.62 | 172.62 | 172.57 | 172.61 | 718.0 |
| 2024-03-28 05:55:00 | AAPL | Stock | 172.65 | 172.65 | 172.63 | 172.63 | 1045.0 |
| 2024-03-28 06:00:00 | AAPL | Stock | 172.72 | 172.72 | 172.72 | 172.72 | 100.0 |
| 2024-03-28 06:10:00 | AAPL | Stock | 172.74 | 172.77 | 172.74 | 172.77 | 984.0 |
| 2024-03-28 06:20:00 | AAPL | Stock | 172.74 | 172.74 | 172.74 | 172.74 | 100.0 |
| 2024-03-28 06:25:00 | AAPL | Stock | 172.77 | 172.77 | 172.77 | 172.77 | 185.0 |
| 2024-03-28 06:30:00 | AAPL | Stock | 172.89 | 172.89 | 172.89 | 172.89 | 228.0 |
| 2024-03-28 06:35:00 | AAPL | Stock | 172.88 | 172.88 | 172.83 | 172.85 | 583.0 |
| 2024-03-28 06:45:00 | AAPL | Stock | 172.73 | 172.73 | 172.65 | 172.65 | 1063.0 |
| 2024-03-28 06:50:00 | AAPL | Stock | 172.73 | 172.82 | 172.73 | 172.82 | 1048.0 |
| 2024-03-28 06:55:00 | AAPL | Stock | 172.75 | 172.75 | 172.75 | 172.75 | 612.0 |
| 2024-03-28 07:00:00 | AAPL | Stock | 172.69 | 172.75 | 172.69 | 172.75 | 1416.0 |
| 2024-03-28 07:05:00 | AAPL | Stock | 172.75 | 172.78 | 172.73 | 172.73 | 1166.0 |
| 2024-03-28 07:10:00 | AAPL | Stock | 172.67 | 172.67 | 172.58 | 172.58 | 2240.0 |
| 2024-03-28 07:15:00 | AAPL | Stock | 172.63 | 172.65 | 172.63 | 172.63 | 700.0 |
| 2024-03-28 07:20:00 | AAPL | Stock | 172.63 | 172.7 | 172.63 | 172.7 | 606.0 |
| 2024-03-28 07:30:00 | AAPL | Stock | 172.65 | 172.66 | 172.65 | 172.65 | 329.0 |
| 2024-03-28 07:35:00 | AAPL | Stock | 172.64 | 172.64 | 172.47 | 172.5 | 7061.0 |
| 2024-03-28 07:40:00 | AAPL | Stock | 172.47 | 172.47 | 172.4 | 172.42 | 4643.0 |
| 2024-03-28 07:45:00 | AAPL | Stock | 172.47 | 172.48 | 172.47 | 172.48 | 649.0 |
| 2024-03-28 07:50:00 | AAPL | Stock | 172.51 | 172.54 | 172.51 | 172.54 | 200.0 |
| 2024-03-28 07:55:00 | AAPL | Stock | 172.55 | 172.55 | 172.45 | 172.47 | 2538.0 |
| 2024-03-28 08:00:00 | AAPL | Stock | 172.6457 | 173.37 | 172.4001 | 173.28 | 53976.0 |
| 2024-03-28 08:05:00 | AAPL | Stock | 172.66 | 172.66 | 172.52 | 172.5313 | 4698.0 |
| 2024-03-28 08:10:00 | AAPL | Stock | 172.55 | 173.31 | 172.51 | 172.55 | 15938.0 |
| 2024-03-28 08:15:00 | AAPL | Stock | 172.6096 | 172.6096 | 172.5001 | 172.55 | 1170.0 |
| 2024-03-28 08:20:00 | AAPL | Stock | 172.5514 | 172.59 | 172.5514 | 172.59 | 1209.0 |
| 2024-03-28 08:25:00 | AAPL | Stock | 172.6 | 172.69 | 172.581 | 172.6 | 7972.0 |
| 2024-03-28 08:30:00 | AAPL | Stock | 172.64 | 172.75 | 172.5 | 172.5 | 5858.0 |
| 2024-03-28 08:35:00 | AAPL | Stock | 172.48 | 172.6 | 172.48 | 172.6 | 1212.0 |
| 2024-03-28 08:40:00 | AAPL | Stock | 172.6009 | 172.6009 | 172.34 | 172.34 | 8571.0 |
| 2024-03-28 08:45:00 | AAPL | Stock | 172.33 | 172.37 | 172.2 | 172.31 | 14923.0 |
| 2024-03-28 08:50:00 | AAPL | Stock | 172.4 | 172.47 | 172.32 | 172.4 | 4208.0 |
> showing 50 of 410,694 rows — these rows as CSV