PREVIEW / stock_5min / 2002-09-06
file: by_date/stock_5min/2002/2002-09-06.parquet size: 1.8 MB rows: 128,161 symbols: 1,471
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 |
|---|---|---|---|---|---|---|---|
| 2002-09-06 08:30:00 | AAPL | Stock | 0.2563 | 0.2563 | 0.2563 | 0.2563 | 56000.0 |
| 2002-09-06 08:35:00 | AAPL | Stock | 0.258 | 0.2589 | 0.258 | 0.2589 | 33600.0 |
| 2002-09-06 08:45:00 | AAPL | Stock | 0.2591 | 0.2591 | 0.2591 | 0.2591 | 44800.0 |
| 2002-09-06 08:50:00 | AAPL | Stock | 0.2591 | 0.2591 | 0.2591 | 0.2591 | 112000.0 |
| 2002-09-06 09:00:00 | AAPL | Stock | 0.2593 | 0.2593 | 0.2593 | 0.2593 | 61600.0 |
| 2002-09-06 09:05:00 | AAPL | Stock | 0.2591 | 0.2591 | 0.2591 | 0.2591 | 16800.0 |
| 2002-09-06 09:10:00 | AAPL | Stock | 0.2591 | 0.2591 | 0.2591 | 0.2591 | 11200.0 |
| 2002-09-06 09:20:00 | AAPL | Stock | 0.2598 | 0.2598 | 0.2598 | 0.2598 | 33600.0 |
| 2002-09-06 09:25:00 | AAPL | Stock | 0.258 | 0.2598 | 0.258 | 0.2598 | 347200.0 |
| 2002-09-06 09:30:00 | AAPL | Stock | 0.2591 | 0.2616 | 0.258 | 0.2581 | 5972736.0 |
| 2002-09-06 09:35:00 | AAPL | Stock | 0.258 | 0.2611 | 0.2564 | 0.2591 | 8198120.0 |
| 2002-09-06 09:40:00 | AAPL | Stock | 0.2591 | 0.2591 | 0.2573 | 0.258 | 4144280.0 |
| 2002-09-06 09:45:00 | AAPL | Stock | 0.258 | 0.2588 | 0.2577 | 0.2579 | 2514400.0 |
| 2002-09-06 09:50:00 | AAPL | Stock | 0.2579 | 0.2579 | 0.257 | 0.2571 | 2982168.0 |
| 2002-09-06 09:55:00 | AAPL | Stock | 0.2571 | 0.2573 | 0.2564 | 0.257 | 4244800.0 |
| 2002-09-06 10:00:00 | AAPL | Stock | 0.257 | 0.2586 | 0.2566 | 0.2582 | 5458824.0 |
| 2002-09-06 10:05:00 | AAPL | Stock | 0.2582 | 0.2584 | 0.2566 | 0.2573 | 2680496.0 |
| 2002-09-06 10:10:00 | AAPL | Stock | 0.2573 | 0.2575 | 0.2559 | 0.2563 | 4858000.0 |
| 2002-09-06 10:15:00 | AAPL | Stock | 0.2564 | 0.2568 | 0.2563 | 0.2568 | 2697576.0 |
| 2002-09-06 10:20:00 | AAPL | Stock | 0.2566 | 0.2573 | 0.2566 | 0.257 | 3371256.0 |
| 2002-09-06 10:25:00 | AAPL | Stock | 0.2568 | 0.2571 | 0.2563 | 0.2564 | 1683136.0 |
| 2002-09-06 10:30:00 | AAPL | Stock | 0.2564 | 0.2571 | 0.2564 | 0.2564 | 1512000.0 |
| 2002-09-06 10:35:00 | AAPL | Stock | 0.2564 | 0.2571 | 0.2564 | 0.257 | 1858248.0 |
| 2002-09-06 10:40:00 | AAPL | Stock | 0.2568 | 0.2571 | 0.2564 | 0.2571 | 2105600.0 |
| 2002-09-06 10:45:00 | AAPL | Stock | 0.2571 | 0.2571 | 0.2564 | 0.257 | 4346048.0 |
| 2002-09-06 10:50:00 | AAPL | Stock | 0.2571 | 0.2586 | 0.2564 | 0.2575 | 4513600.0 |
| 2002-09-06 10:55:00 | AAPL | Stock | 0.2577 | 0.2598 | 0.2573 | 0.2588 | 6838104.0 |
| 2002-09-06 11:00:00 | AAPL | Stock | 0.2588 | 0.2591 | 0.2571 | 0.2573 | 3313128.0 |
| 2002-09-06 11:05:00 | AAPL | Stock | 0.2575 | 0.2588 | 0.2575 | 0.2584 | 1966496.0 |
| 2002-09-06 11:10:00 | AAPL | Stock | 0.2584 | 0.2584 | 0.2577 | 0.2579 | 655200.0 |
| 2002-09-06 11:15:00 | AAPL | Stock | 0.2577 | 0.2589 | 0.2577 | 0.258 | 1747648.0 |
| 2002-09-06 11:20:00 | AAPL | Stock | 0.2579 | 0.258 | 0.2579 | 0.2579 | 520800.0 |
| 2002-09-06 11:25:00 | AAPL | Stock | 0.2577 | 0.258 | 0.2577 | 0.2577 | 2178400.0 |
| 2002-09-06 11:30:00 | AAPL | Stock | 0.2579 | 0.2579 | 0.2571 | 0.2575 | 1904000.0 |
| 2002-09-06 11:35:00 | AAPL | Stock | 0.2579 | 0.258 | 0.2575 | 0.258 | 927472.0 |
| 2002-09-06 11:40:00 | AAPL | Stock | 0.2579 | 0.258 | 0.2571 | 0.2575 | 1999200.0 |
| 2002-09-06 11:45:00 | AAPL | Stock | 0.2575 | 0.2577 | 0.2571 | 0.2572 | 3606960.0 |
| 2002-09-06 11:50:00 | AAPL | Stock | 0.2571 | 0.2573 | 0.2564 | 0.2564 | 3404800.0 |
| 2002-09-06 11:55:00 | AAPL | Stock | 0.2566 | 0.257 | 0.2563 | 0.2566 | 1467760.0 |
| 2002-09-06 12:00:00 | AAPL | Stock | 0.2566 | 0.257 | 0.2564 | 0.2566 | 375200.0 |
| 2002-09-06 12:05:00 | AAPL | Stock | 0.2566 | 0.2568 | 0.2563 | 0.2568 | 375200.0 |
| 2002-09-06 12:10:00 | AAPL | Stock | 0.2568 | 0.2573 | 0.2568 | 0.2571 | 2094400.0 |
| 2002-09-06 12:15:00 | AAPL | Stock | 0.2571 | 0.2573 | 0.2566 | 0.2571 | 1243200.0 |
| 2002-09-06 12:20:00 | AAPL | Stock | 0.2568 | 0.2571 | 0.2564 | 0.2564 | 1092000.0 |
| 2002-09-06 12:25:00 | AAPL | Stock | 0.257 | 0.257 | 0.2566 | 0.257 | 414400.0 |
| 2002-09-06 12:30:00 | AAPL | Stock | 0.257 | 0.2571 | 0.2564 | 0.2571 | 868000.0 |
| 2002-09-06 12:35:00 | AAPL | Stock | 0.257 | 0.2571 | 0.257 | 0.257 | 862400.0 |
| 2002-09-06 12:40:00 | AAPL | Stock | 0.257 | 0.2571 | 0.257 | 0.2571 | 1649648.0 |
| 2002-09-06 12:45:00 | AAPL | Stock | 0.2571 | 0.2571 | 0.2566 | 0.257 | 364000.0 |
| 2002-09-06 12:50:00 | AAPL | Stock | 0.257 | 0.257 | 0.2566 | 0.2568 | 252000.0 |
> showing 50 of 128,161 rows — these rows as CSV