PREVIEW / stock_5min / 2024-02-14
file: by_date/stock_5min/2024/2024-02-14.parquet size: 6.8 MB rows: 408,808 symbols: 1,136
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-02-14 04:00:00 | AAPL | Stock | 185.43 | 185.6 | 185.42 | 185.42 | 3390.0 |
| 2024-02-14 04:05:00 | AAPL | Stock | 185.54 | 185.54 | 185.46 | 185.47 | 400.0 |
| 2024-02-14 04:10:00 | AAPL | Stock | 185.5 | 185.57 | 185.5 | 185.57 | 1523.0 |
| 2024-02-14 04:15:00 | AAPL | Stock | 185.59 | 185.59 | 185.59 | 185.59 | 139.0 |
| 2024-02-14 04:20:00 | AAPL | Stock | 185.6 | 185.65 | 185.59 | 185.65 | 1515.0 |
| 2024-02-14 04:25:00 | AAPL | Stock | 185.58 | 185.58 | 185.58 | 185.58 | 100.0 |
| 2024-02-14 04:35:00 | AAPL | Stock | 185.58 | 185.58 | 185.58 | 185.58 | 130.0 |
| 2024-02-14 04:40:00 | AAPL | Stock | 185.58 | 185.59 | 185.58 | 185.59 | 320.0 |
| 2024-02-14 04:45:00 | AAPL | Stock | 185.59 | 185.65 | 185.59 | 185.65 | 4071.0 |
| 2024-02-14 04:50:00 | AAPL | Stock | 185.64 | 185.64 | 185.61 | 185.61 | 206.0 |
| 2024-02-14 04:55:00 | AAPL | Stock | 185.61 | 185.61 | 185.61 | 185.61 | 100.0 |
| 2024-02-14 05:00:00 | AAPL | Stock | 185.61 | 185.61 | 185.6 | 185.6 | 453.0 |
| 2024-02-14 05:05:00 | AAPL | Stock | 185.55 | 185.58 | 185.55 | 185.58 | 302.0 |
| 2024-02-14 05:10:00 | AAPL | Stock | 185.5 | 185.5 | 185.41 | 185.41 | 774.0 |
| 2024-02-14 05:15:00 | AAPL | Stock | 185.47 | 185.47 | 185.41 | 185.42 | 2078.0 |
| 2024-02-14 05:25:00 | AAPL | Stock | 185.37 | 185.45 | 185.33 | 185.45 | 2684.0 |
| 2024-02-14 05:30:00 | AAPL | Stock | 185.46 | 185.48 | 185.46 | 185.48 | 1526.0 |
| 2024-02-14 05:35:00 | AAPL | Stock | 185.4 | 185.45 | 185.4 | 185.45 | 1097.0 |
| 2024-02-14 05:40:00 | AAPL | Stock | 185.47 | 185.5 | 185.47 | 185.5 | 763.0 |
| 2024-02-14 05:45:00 | AAPL | Stock | 185.54 | 185.54 | 185.5 | 185.5 | 426.0 |
| 2024-02-14 05:50:00 | AAPL | Stock | 185.55 | 185.55 | 185.55 | 185.55 | 152.0 |
| 2024-02-14 05:55:00 | AAPL | Stock | 185.62 | 185.65 | 185.54 | 185.54 | 895.0 |
| 2024-02-14 06:00:00 | AAPL | Stock | 185.5 | 185.5 | 185.5 | 185.5 | 754.0 |
| 2024-02-14 06:05:00 | AAPL | Stock | 185.35 | 185.4 | 185.35 | 185.4 | 386.0 |
| 2024-02-14 06:10:00 | AAPL | Stock | 185.38 | 185.38 | 185.38 | 185.38 | 250.0 |
| 2024-02-14 06:25:00 | AAPL | Stock | 185.48 | 185.48 | 185.38 | 185.38 | 1663.0 |
| 2024-02-14 06:30:00 | AAPL | Stock | 185.42 | 185.42 | 185.42 | 185.42 | 266.0 |
| 2024-02-14 06:45:00 | AAPL | Stock | 185.36 | 185.36 | 185.36 | 185.36 | 199.0 |
| 2024-02-14 06:50:00 | AAPL | Stock | 185.42 | 185.42 | 185.42 | 185.42 | 1793.0 |
| 2024-02-14 06:55:00 | AAPL | Stock | 185.5 | 185.5 | 185.46 | 185.5 | 943.0 |
| 2024-02-14 07:00:00 | AAPL | Stock | 185.5 | 185.9 | 185.5 | 185.81 | 7013.0 |
| 2024-02-14 07:05:00 | AAPL | Stock | 185.79 | 185.9 | 185.79 | 185.9 | 2149.0 |
| 2024-02-14 07:10:00 | AAPL | Stock | 185.9 | 185.9 | 185.77 | 185.77 | 1050.0 |
| 2024-02-14 07:15:00 | AAPL | Stock | 185.75 | 185.75 | 185.75 | 185.75 | 1050.0 |
| 2024-02-14 07:20:00 | AAPL | Stock | 185.73 | 185.74 | 185.72 | 185.73 | 478.0 |
| 2024-02-14 07:25:00 | AAPL | Stock | 185.75 | 185.76 | 185.75 | 185.75 | 839.0 |
| 2024-02-14 07:30:00 | AAPL | Stock | 185.75 | 185.75 | 185.73 | 185.75 | 1489.0 |
| 2024-02-14 07:35:00 | AAPL | Stock | 185.72 | 185.72 | 185.57 | 185.57 | 900.0 |
| 2024-02-14 07:40:00 | AAPL | Stock | 185.5 | 185.6 | 185.39 | 185.6 | 20461.0 |
| 2024-02-14 07:45:00 | AAPL | Stock | 185.63 | 185.7 | 185.63 | 185.7 | 2444.0 |
| 2024-02-14 07:50:00 | AAPL | Stock | 185.65 | 185.72 | 185.65 | 185.72 | 1090.0 |
| 2024-02-14 07:55:00 | AAPL | Stock | 185.65 | 185.65 | 185.51 | 185.51 | 973.0 |
| 2024-02-14 08:00:00 | AAPL | Stock | 185.79 | 185.94 | 185.24 | 185.7 | 37038.0 |
| 2024-02-14 08:05:00 | AAPL | Stock | 185.7438 | 185.7499 | 185.7 | 185.72 | 892.0 |
| 2024-02-14 08:10:00 | AAPL | Stock | 185.7 | 185.75 | 185.7 | 185.75 | 2600.0 |
| 2024-02-14 08:15:00 | AAPL | Stock | 185.72 | 185.74 | 185.62 | 185.62 | 5599.0 |
| 2024-02-14 08:20:00 | AAPL | Stock | 185.64 | 185.64 | 185.53 | 185.58 | 1952.0 |
| 2024-02-14 08:25:00 | AAPL | Stock | 185.55 | 185.55 | 185.38 | 185.39 | 5381.0 |
| 2024-02-14 08:30:00 | AAPL | Stock | 185.4 | 185.45 | 185.374 | 185.4 | 5802.0 |
| 2024-02-14 08:35:00 | AAPL | Stock | 185.39 | 185.43 | 185.31 | 185.4 | 9895.0 |
> showing 50 of 408,808 rows — these rows as CSV