PREVIEW / stock_5min / 2024-02-09
file: by_date/stock_5min/2024/2024-02-09.parquet size: 6.7 MB rows: 399,955 symbols: 1,140
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-09 04:00:00 | AAPL | Stock | 188.5 | 188.5 | 188.5 | 188.5 | 125.0 |
| 2024-02-09 04:05:00 | AAPL | Stock | 188.5 | 188.5 | 188.35 | 188.35 | 352.0 |
| 2024-02-09 04:10:00 | AAPL | Stock | 188.35 | 188.35 | 188.3 | 188.3 | 213.0 |
| 2024-02-09 04:15:00 | AAPL | Stock | 188.3 | 188.3 | 188.3 | 188.3 | 500.0 |
| 2024-02-09 04:30:00 | AAPL | Stock | 188.35 | 188.35 | 188.33 | 188.33 | 400.0 |
| 2024-02-09 04:35:00 | AAPL | Stock | 188.4 | 188.4 | 188.4 | 188.4 | 415.0 |
| 2024-02-09 05:05:00 | AAPL | Stock | 188.4 | 188.4 | 188.4 | 188.4 | 237.0 |
| 2024-02-09 05:10:00 | AAPL | Stock | 188.4 | 188.4 | 188.4 | 188.4 | 1150.0 |
| 2024-02-09 05:15:00 | AAPL | Stock | 188.4 | 188.4 | 188.4 | 188.4 | 200.0 |
| 2024-02-09 05:20:00 | AAPL | Stock | 188.43 | 188.43 | 188.43 | 188.43 | 136.0 |
| 2024-02-09 05:40:00 | AAPL | Stock | 188.48 | 188.5 | 188.48 | 188.5 | 1171.0 |
| 2024-02-09 05:50:00 | AAPL | Stock | 188.5 | 188.52 | 188.46 | 188.46 | 726.0 |
| 2024-02-09 06:00:00 | AAPL | Stock | 188.46 | 188.49 | 188.46 | 188.49 | 355.0 |
| 2024-02-09 06:35:00 | AAPL | Stock | 188.45 | 188.48 | 188.45 | 188.48 | 1348.0 |
| 2024-02-09 06:40:00 | AAPL | Stock | 188.49 | 188.49 | 188.49 | 188.49 | 125.0 |
| 2024-02-09 06:45:00 | AAPL | Stock | 188.55 | 188.55 | 188.55 | 188.55 | 479.0 |
| 2024-02-09 06:55:00 | AAPL | Stock | 188.51 | 188.51 | 188.51 | 188.51 | 271.0 |
| 2024-02-09 07:00:00 | AAPL | Stock | 188.54 | 188.66 | 188.51 | 188.66 | 2593.0 |
| 2024-02-09 07:05:00 | AAPL | Stock | 188.55 | 188.55 | 188.5 | 188.5 | 2127.0 |
| 2024-02-09 07:10:00 | AAPL | Stock | 188.54 | 188.56 | 188.54 | 188.55 | 695.0 |
| 2024-02-09 07:15:00 | AAPL | Stock | 188.54 | 188.56 | 188.54 | 188.56 | 662.0 |
| 2024-02-09 07:20:00 | AAPL | Stock | 188.56 | 188.64 | 188.56 | 188.64 | 2827.0 |
| 2024-02-09 07:25:00 | AAPL | Stock | 188.67 | 188.68 | 188.55 | 188.55 | 1106.0 |
| 2024-02-09 07:30:00 | AAPL | Stock | 188.6 | 188.6 | 188.54 | 188.54 | 664.0 |
| 2024-02-09 07:35:00 | AAPL | Stock | 188.56 | 188.56 | 188.52 | 188.52 | 392.0 |
| 2024-02-09 07:40:00 | AAPL | Stock | 188.58 | 188.58 | 188.56 | 188.56 | 1700.0 |
| 2024-02-09 07:45:00 | AAPL | Stock | 188.51 | 188.51 | 188.48 | 188.48 | 1340.0 |
| 2024-02-09 07:50:00 | AAPL | Stock | 188.5 | 188.87 | 188.5 | 188.87 | 9551.0 |
| 2024-02-09 07:55:00 | AAPL | Stock | 188.8 | 188.88 | 188.76 | 188.76 | 1578.0 |
| 2024-02-09 08:00:00 | AAPL | Stock | 188.54 | 188.93 | 188.12 | 188.89 | 40123.0 |
| 2024-02-09 08:05:00 | AAPL | Stock | 188.8807 | 188.89 | 188.81 | 188.81 | 2519.0 |
| 2024-02-09 08:10:00 | AAPL | Stock | 188.81 | 188.81 | 188.75 | 188.76 | 2466.0 |
| 2024-02-09 08:15:00 | AAPL | Stock | 188.78 | 188.84 | 188.76 | 188.8 | 3692.0 |
| 2024-02-09 08:20:00 | AAPL | Stock | 188.8 | 188.81 | 188.75 | 188.75 | 4647.0 |
| 2024-02-09 08:25:00 | AAPL | Stock | 188.76 | 188.76 | 188.75 | 188.76 | 9028.0 |
| 2024-02-09 08:30:00 | AAPL | Stock | 188.75 | 189.33 | 188.75 | 189.16 | 42888.0 |
| 2024-02-09 08:35:00 | AAPL | Stock | 189.0 | 189.1 | 188.91 | 188.94 | 6503.0 |
| 2024-02-09 08:40:00 | AAPL | Stock | 188.92 | 188.97 | 188.67 | 188.93 | 5678.0 |
| 2024-02-09 08:45:00 | AAPL | Stock | 188.88 | 188.97 | 188.85 | 188.9 | 5595.0 |
| 2024-02-09 08:50:00 | AAPL | Stock | 188.88 | 188.9 | 188.6 | 188.6 | 8361.0 |
| 2024-02-09 08:55:00 | AAPL | Stock | 188.69 | 188.8 | 188.627 | 188.75 | 4646.0 |
| 2024-02-09 09:00:00 | AAPL | Stock | 188.76 | 188.76 | 188.62 | 188.7371 | 4313.0 |
| 2024-02-09 09:05:00 | AAPL | Stock | 188.71 | 188.74 | 188.6 | 188.72 | 2585.0 |
| 2024-02-09 09:10:00 | AAPL | Stock | 188.69 | 188.79 | 188.68 | 188.77 | 3916.0 |
| 2024-02-09 09:15:00 | AAPL | Stock | 188.76 | 188.76 | 188.65 | 188.72 | 4434.0 |
| 2024-02-09 09:20:00 | AAPL | Stock | 188.73 | 188.74 | 188.45 | 188.45 | 10546.0 |
| 2024-02-09 09:25:00 | AAPL | Stock | 188.52 | 188.89 | 188.45 | 188.73 | 36820.0 |
| 2024-02-09 09:30:00 | AAPL | Stock | 188.64 | 188.93 | 188.0 | 188.415 | 1266879.0 |
| 2024-02-09 09:35:00 | AAPL | Stock | 188.41 | 188.582 | 188.2442 | 188.46 | 482701.0 |
| 2024-02-09 09:40:00 | AAPL | Stock | 188.4764 | 188.58 | 188.33 | 188.4288 | 412284.0 |
> showing 50 of 399,955 rows — these rows as CSV