PREVIEW / stock_1min / 2004-08-19
file: by_date/stock_1min/2004/2004-08-19.parquet size: 5.6 MB rows: 472,256 symbols: 1,500
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 |
|---|---|---|---|---|---|---|---|
| 2004-08-19 08:55:00 | AAPL | Stock | 0.567 | 0.567 | 0.567 | 0.567 | 336000.0 |
| 2004-08-19 08:57:00 | AAPL | Stock | 0.565 | 0.565 | 0.565 | 0.565 | 50400.0 |
| 2004-08-19 09:01:00 | AAPL | Stock | 0.565 | 0.565 | 0.565 | 0.565 | 5600.0 |
| 2004-08-19 09:29:00 | AAPL | Stock | 0.565 | 0.5664 | 0.5643 | 0.5645 | 158256.0 |
| 2004-08-19 09:30:00 | AAPL | Stock | 0.5627 | 0.5641 | 0.5625 | 0.563 | 2066792.0 |
| 2004-08-19 09:31:00 | AAPL | Stock | 0.563 | 0.5636 | 0.5625 | 0.5625 | 859992.0 |
| 2004-08-19 09:32:00 | AAPL | Stock | 0.5625 | 0.563 | 0.5625 | 0.563 | 313880.0 |
| 2004-08-19 09:33:00 | AAPL | Stock | 0.5625 | 0.5629 | 0.5625 | 0.5627 | 937888.0 |
| 2004-08-19 09:34:00 | AAPL | Stock | 0.5625 | 0.5634 | 0.5625 | 0.5627 | 1036952.0 |
| 2004-08-19 09:35:00 | AAPL | Stock | 0.5625 | 0.563 | 0.5616 | 0.5621 | 1032920.0 |
| 2004-08-19 09:36:00 | AAPL | Stock | 0.5627 | 0.5638 | 0.5614 | 0.5621 | 879536.0 |
| 2004-08-19 09:37:00 | AAPL | Stock | 0.5621 | 0.5623 | 0.5611 | 0.5611 | 1969296.0 |
| 2004-08-19 09:38:00 | AAPL | Stock | 0.5609 | 0.5611 | 0.5598 | 0.5604 | 1389304.0 |
| 2004-08-19 09:39:00 | AAPL | Stock | 0.5607 | 0.5625 | 0.5605 | 0.562 | 1304184.0 |
| 2004-08-19 09:40:00 | AAPL | Stock | 0.5623 | 0.5632 | 0.5618 | 0.5621 | 1194088.0 |
| 2004-08-19 09:41:00 | AAPL | Stock | 0.5621 | 0.5625 | 0.5616 | 0.5621 | 1563016.0 |
| 2004-08-19 09:42:00 | AAPL | Stock | 0.5621 | 0.5634 | 0.5621 | 0.5632 | 738472.0 |
| 2004-08-19 09:43:00 | AAPL | Stock | 0.5629 | 0.5632 | 0.5625 | 0.5632 | 616224.0 |
| 2004-08-19 09:44:00 | AAPL | Stock | 0.5634 | 0.5648 | 0.5632 | 0.5645 | 896728.0 |
| 2004-08-19 09:45:00 | AAPL | Stock | 0.5652 | 0.5657 | 0.5636 | 0.5646 | 803600.0 |
| 2004-08-19 09:46:00 | AAPL | Stock | 0.5643 | 0.5657 | 0.5643 | 0.5648 | 533624.0 |
| 2004-08-19 09:47:00 | AAPL | Stock | 0.5655 | 0.5659 | 0.5645 | 0.565 | 843920.0 |
| 2004-08-19 09:48:00 | AAPL | Stock | 0.565 | 0.5654 | 0.5648 | 0.5648 | 100800.0 |
| 2004-08-19 09:49:00 | AAPL | Stock | 0.5646 | 0.5648 | 0.5645 | 0.5646 | 252000.0 |
| 2004-08-19 09:50:00 | AAPL | Stock | 0.565 | 0.5679 | 0.5646 | 0.5673 | 1133328.0 |
| 2004-08-19 09:51:00 | AAPL | Stock | 0.5679 | 0.5682 | 0.5668 | 0.5675 | 1057952.0 |
| 2004-08-19 09:52:00 | AAPL | Stock | 0.5675 | 0.5675 | 0.5659 | 0.5663 | 753088.0 |
| 2004-08-19 09:53:00 | AAPL | Stock | 0.5664 | 0.5673 | 0.5663 | 0.567 | 324800.0 |
| 2004-08-19 09:54:00 | AAPL | Stock | 0.567 | 0.5675 | 0.567 | 0.567 | 179200.0 |
| 2004-08-19 09:55:00 | AAPL | Stock | 0.567 | 0.5689 | 0.567 | 0.568 | 714784.0 |
| 2004-08-19 09:56:00 | AAPL | Stock | 0.5684 | 0.5684 | 0.5673 | 0.5675 | 399728.0 |
| 2004-08-19 09:57:00 | AAPL | Stock | 0.5675 | 0.5677 | 0.5668 | 0.5668 | 282800.0 |
| 2004-08-19 09:58:00 | AAPL | Stock | 0.567 | 0.5671 | 0.567 | 0.567 | 61600.0 |
| 2004-08-19 09:59:00 | AAPL | Stock | 0.567 | 0.5671 | 0.5666 | 0.5668 | 1523200.0 |
| 2004-08-19 10:00:00 | AAPL | Stock | 0.5668 | 0.567 | 0.5668 | 0.567 | 1454432.0 |
| 2004-08-19 10:01:00 | AAPL | Stock | 0.567 | 0.567 | 0.5668 | 0.567 | 587328.0 |
| 2004-08-19 10:02:00 | AAPL | Stock | 0.567 | 0.567 | 0.5668 | 0.567 | 378000.0 |
| 2004-08-19 10:03:00 | AAPL | Stock | 0.567 | 0.567 | 0.5668 | 0.5668 | 280000.0 |
| 2004-08-19 10:04:00 | AAPL | Stock | 0.567 | 0.567 | 0.5668 | 0.5668 | 223888.0 |
| 2004-08-19 10:05:00 | AAPL | Stock | 0.5668 | 0.567 | 0.5654 | 0.5654 | 1528800.0 |
| 2004-08-19 10:06:00 | AAPL | Stock | 0.5654 | 0.5657 | 0.5648 | 0.565 | 1061200.0 |
| 2004-08-19 10:07:00 | AAPL | Stock | 0.5648 | 0.5648 | 0.563 | 0.5638 | 844256.0 |
| 2004-08-19 10:08:00 | AAPL | Stock | 0.5636 | 0.5638 | 0.563 | 0.563 | 509600.0 |
| 2004-08-19 10:09:00 | AAPL | Stock | 0.563 | 0.5632 | 0.5625 | 0.5632 | 726208.0 |
| 2004-08-19 10:10:00 | AAPL | Stock | 0.5632 | 0.5632 | 0.5623 | 0.5623 | 1390928.0 |
| 2004-08-19 10:11:00 | AAPL | Stock | 0.5623 | 0.5625 | 0.5621 | 0.5623 | 1559208.0 |
| 2004-08-19 10:12:00 | AAPL | Stock | 0.5621 | 0.5625 | 0.5616 | 0.562 | 3550400.0 |
| 2004-08-19 10:13:00 | AAPL | Stock | 0.5618 | 0.5621 | 0.5618 | 0.562 | 973896.0 |
| 2004-08-19 10:14:00 | AAPL | Stock | 0.562 | 0.5621 | 0.5618 | 0.5621 | 1131368.0 |
| 2004-08-19 10:15:00 | AAPL | Stock | 0.5621 | 0.5625 | 0.5621 | 0.5623 | 907312.0 |
> showing 50 of 472,256 rows — these rows as CSV