PREVIEW / stock_5min / 2021-09-09
file: by_date/stock_5min/2021/2021-09-09.parquet size: 7.4 MB rows: 451,165 symbols: 2,738
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 |
|---|---|---|---|---|---|---|---|
| 2021-09-09 04:00:00 | AAPL | Stock | 154.98 | 155.0 | 154.72 | 154.86 | 2645.0 |
| 2021-09-09 04:05:00 | AAPL | Stock | 154.87 | 154.87 | 154.7 | 154.74 | 2240.0 |
| 2021-09-09 04:10:00 | AAPL | Stock | 154.73 | 154.73 | 154.73 | 154.73 | 602.0 |
| 2021-09-09 04:15:00 | AAPL | Stock | 154.73 | 154.78 | 154.72 | 154.74 | 3554.0 |
| 2021-09-09 04:20:00 | AAPL | Stock | 154.75 | 154.75 | 154.72 | 154.72 | 900.0 |
| 2021-09-09 04:25:00 | AAPL | Stock | 154.7 | 154.7 | 154.62 | 154.62 | 1109.0 |
| 2021-09-09 04:30:00 | AAPL | Stock | 154.66 | 154.66 | 154.66 | 154.66 | 329.0 |
| 2021-09-09 04:40:00 | AAPL | Stock | 154.56 | 154.56 | 154.48 | 154.48 | 519.0 |
| 2021-09-09 04:45:00 | AAPL | Stock | 154.41 | 154.5 | 154.41 | 154.5 | 621.0 |
| 2021-09-09 04:55:00 | AAPL | Stock | 154.45 | 154.45 | 154.45 | 154.45 | 230.0 |
| 2021-09-09 05:00:00 | AAPL | Stock | 154.43 | 154.45 | 154.4 | 154.45 | 522.0 |
| 2021-09-09 05:05:00 | AAPL | Stock | 154.45 | 154.53 | 154.45 | 154.53 | 377.0 |
| 2021-09-09 05:10:00 | AAPL | Stock | 154.48 | 154.6 | 154.39 | 154.55 | 1950.0 |
| 2021-09-09 05:15:00 | AAPL | Stock | 154.53 | 154.53 | 154.53 | 154.53 | 200.0 |
| 2021-09-09 05:20:00 | AAPL | Stock | 154.68 | 154.68 | 154.6 | 154.6 | 1627.0 |
| 2021-09-09 05:25:00 | AAPL | Stock | 154.66 | 154.66 | 154.66 | 154.66 | 500.0 |
| 2021-09-09 05:30:00 | AAPL | Stock | 154.69 | 154.8 | 154.69 | 154.8 | 4390.0 |
| 2021-09-09 05:35:00 | AAPL | Stock | 154.8 | 154.8 | 154.8 | 154.8 | 1837.0 |
| 2021-09-09 05:40:00 | AAPL | Stock | 154.8 | 154.8 | 154.8 | 154.8 | 1420.0 |
| 2021-09-09 05:45:00 | AAPL | Stock | 154.75 | 154.75 | 154.75 | 154.75 | 382.0 |
| 2021-09-09 05:50:00 | AAPL | Stock | 154.77 | 154.84 | 154.77 | 154.84 | 997.0 |
| 2021-09-09 05:55:00 | AAPL | Stock | 154.79 | 154.79 | 154.79 | 154.79 | 241.0 |
| 2021-09-09 06:00:00 | AAPL | Stock | 154.8 | 154.8 | 154.8 | 154.8 | 2412.0 |
| 2021-09-09 06:05:00 | AAPL | Stock | 154.8 | 154.8 | 154.74 | 154.74 | 600.0 |
| 2021-09-09 06:10:00 | AAPL | Stock | 154.74 | 154.74 | 154.74 | 154.74 | 111.0 |
| 2021-09-09 06:15:00 | AAPL | Stock | 154.8 | 154.82 | 154.73 | 154.73 | 1042.0 |
| 2021-09-09 06:20:00 | AAPL | Stock | 154.74 | 154.74 | 154.74 | 154.74 | 180.0 |
| 2021-09-09 06:25:00 | AAPL | Stock | 154.76 | 154.76 | 154.7 | 154.71 | 1276.0 |
| 2021-09-09 06:30:00 | AAPL | Stock | 154.77 | 154.86 | 154.77 | 154.86 | 757.0 |
| 2021-09-09 06:40:00 | AAPL | Stock | 154.8 | 154.95 | 154.8 | 154.95 | 1170.0 |
| 2021-09-09 07:00:00 | AAPL | Stock | 154.81 | 154.92 | 154.8 | 154.9 | 5848.0 |
| 2021-09-09 07:05:00 | AAPL | Stock | 154.83 | 154.86 | 154.78 | 154.79 | 2955.0 |
| 2021-09-09 07:10:00 | AAPL | Stock | 154.76 | 154.78 | 154.76 | 154.77 | 3567.0 |
| 2021-09-09 07:15:00 | AAPL | Stock | 154.77 | 154.79 | 154.76 | 154.79 | 412.0 |
| 2021-09-09 07:20:00 | AAPL | Stock | 154.76 | 154.8 | 154.75 | 154.77 | 5313.0 |
| 2021-09-09 07:25:00 | AAPL | Stock | 154.75 | 154.75 | 154.72 | 154.75 | 2041.0 |
| 2021-09-09 07:30:00 | AAPL | Stock | 154.77 | 154.94 | 154.77 | 154.92 | 2625.0 |
| 2021-09-09 07:35:00 | AAPL | Stock | 154.95 | 155.0 | 154.9 | 154.9 | 9653.0 |
| 2021-09-09 07:40:00 | AAPL | Stock | 154.87 | 154.87 | 154.7 | 154.7 | 6293.0 |
| 2021-09-09 07:45:00 | AAPL | Stock | 154.68 | 155.0 | 154.68 | 155.0 | 18134.0 |
| 2021-09-09 07:50:00 | AAPL | Stock | 155.04 | 155.11 | 154.95 | 155.09 | 10096.0 |
| 2021-09-09 07:55:00 | AAPL | Stock | 155.09 | 155.16 | 155.09 | 155.13 | 12896.0 |
| 2021-09-09 08:00:00 | AAPL | Stock | 154.9885 | 155.1581 | 154.68 | 155.14 | 56227.0 |
| 2021-09-09 08:05:00 | AAPL | Stock | 155.14 | 155.14 | 155.05 | 155.0699 | 19316.0 |
| 2021-09-09 08:10:00 | AAPL | Stock | 155.05 | 155.05 | 154.97 | 154.97 | 19120.0 |
| 2021-09-09 08:15:00 | AAPL | Stock | 154.96 | 155.1 | 154.96 | 155.03 | 21318.0 |
| 2021-09-09 08:20:00 | AAPL | Stock | 155.01 | 155.08 | 155.0 | 155.04 | 30732.0 |
| 2021-09-09 08:25:00 | AAPL | Stock | 155.05 | 155.1 | 155.03 | 155.1 | 7441.0 |
| 2021-09-09 08:30:00 | AAPL | Stock | 155.09 | 155.17 | 155.0 | 155.16 | 15187.0 |
| 2021-09-09 08:35:00 | AAPL | Stock | 155.15 | 155.19 | 155.11 | 155.17 | 20691.0 |
> showing 50 of 451,165 rows — these rows as CSV