PREVIEW / stock_1min / 2004-04-29
file: by_date/stock_1min/2004/2004-04-29.parquet size: 6.4 MB rows: 522,895 symbols: 1,452
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-04-29 08:45:00 | AAPL | Stock | 0.4723 | 0.4723 | 0.4723 | 0.4723 | 5600.0 |
| 2004-04-29 08:55:00 | AAPL | Stock | 0.4732 | 0.4732 | 0.4732 | 0.4732 | 22400.0 |
| 2004-04-29 08:56:00 | AAPL | Stock | 0.4732 | 0.4732 | 0.4732 | 0.4732 | 5600.0 |
| 2004-04-29 09:27:00 | AAPL | Stock | 0.4711 | 0.4711 | 0.4711 | 0.4711 | 38192.0 |
| 2004-04-29 09:28:00 | AAPL | Stock | 0.4714 | 0.4716 | 0.4714 | 0.4716 | 22344.0 |
| 2004-04-29 09:29:00 | AAPL | Stock | 0.4723 | 0.4723 | 0.4698 | 0.4698 | 502600.0 |
| 2004-04-29 09:30:00 | AAPL | Stock | 0.4723 | 0.4725 | 0.4698 | 0.4723 | 1243144.0 |
| 2004-04-29 09:31:00 | AAPL | Stock | 0.472 | 0.472 | 0.4695 | 0.4695 | 1315384.0 |
| 2004-04-29 09:32:00 | AAPL | Stock | 0.4691 | 0.4691 | 0.4648 | 0.465 | 2346960.0 |
| 2004-04-29 09:33:00 | AAPL | Stock | 0.4648 | 0.4691 | 0.4643 | 0.4666 | 2036720.0 |
| 2004-04-29 09:34:00 | AAPL | Stock | 0.4668 | 0.4671 | 0.4646 | 0.4652 | 1640408.0 |
| 2004-04-29 09:35:00 | AAPL | Stock | 0.4646 | 0.4675 | 0.4646 | 0.4673 | 3246264.0 |
| 2004-04-29 09:36:00 | AAPL | Stock | 0.4671 | 0.4677 | 0.4666 | 0.467 | 1355200.0 |
| 2004-04-29 09:37:00 | AAPL | Stock | 0.4666 | 0.4666 | 0.4657 | 0.4657 | 2285696.0 |
| 2004-04-29 09:38:00 | AAPL | Stock | 0.4657 | 0.4661 | 0.465 | 0.4657 | 1607704.0 |
| 2004-04-29 09:39:00 | AAPL | Stock | 0.4654 | 0.4661 | 0.4652 | 0.4652 | 908432.0 |
| 2004-04-29 09:40:00 | AAPL | Stock | 0.465 | 0.4657 | 0.4639 | 0.4657 | 4456480.0 |
| 2004-04-29 09:41:00 | AAPL | Stock | 0.4655 | 0.4657 | 0.4643 | 0.4654 | 718088.0 |
| 2004-04-29 09:42:00 | AAPL | Stock | 0.4654 | 0.4665 | 0.4648 | 0.4664 | 2274216.0 |
| 2004-04-29 09:43:00 | AAPL | Stock | 0.4666 | 0.4673 | 0.4661 | 0.4666 | 2202928.0 |
| 2004-04-29 09:44:00 | AAPL | Stock | 0.4666 | 0.4666 | 0.4657 | 0.4663 | 411600.0 |
| 2004-04-29 09:45:00 | AAPL | Stock | 0.4663 | 0.4663 | 0.4657 | 0.4662 | 728000.0 |
| 2004-04-29 09:46:00 | AAPL | Stock | 0.4661 | 0.4664 | 0.4654 | 0.4661 | 1220408.0 |
| 2004-04-29 09:47:00 | AAPL | Stock | 0.4661 | 0.4661 | 0.4654 | 0.4655 | 912800.0 |
| 2004-04-29 09:48:00 | AAPL | Stock | 0.4652 | 0.4655 | 0.4645 | 0.4652 | 808416.0 |
| 2004-04-29 09:49:00 | AAPL | Stock | 0.4652 | 0.4652 | 0.4645 | 0.4645 | 1312640.0 |
| 2004-04-29 09:50:00 | AAPL | Stock | 0.4645 | 0.4646 | 0.4645 | 0.4645 | 1450400.0 |
| 2004-04-29 09:51:00 | AAPL | Stock | 0.4646 | 0.4648 | 0.4645 | 0.4648 | 1601768.0 |
| 2004-04-29 09:52:00 | AAPL | Stock | 0.4645 | 0.465 | 0.4643 | 0.4648 | 890960.0 |
| 2004-04-29 09:53:00 | AAPL | Stock | 0.4648 | 0.465 | 0.4645 | 0.4648 | 2621248.0 |
| 2004-04-29 09:54:00 | AAPL | Stock | 0.4648 | 0.4648 | 0.4645 | 0.4646 | 1178128.0 |
| 2004-04-29 09:55:00 | AAPL | Stock | 0.4646 | 0.4648 | 0.4645 | 0.4648 | 1126384.0 |
| 2004-04-29 09:56:00 | AAPL | Stock | 0.4648 | 0.4648 | 0.4645 | 0.4645 | 1360800.0 |
| 2004-04-29 09:57:00 | AAPL | Stock | 0.4645 | 0.465 | 0.4645 | 0.4648 | 666400.0 |
| 2004-04-29 09:58:00 | AAPL | Stock | 0.4648 | 0.4661 | 0.4648 | 0.4657 | 1322720.0 |
| 2004-04-29 09:59:00 | AAPL | Stock | 0.4657 | 0.467 | 0.4654 | 0.467 | 6419896.0 |
| 2004-04-29 10:00:00 | AAPL | Stock | 0.467 | 0.4689 | 0.467 | 0.4689 | 1994160.0 |
| 2004-04-29 10:01:00 | AAPL | Stock | 0.4686 | 0.4691 | 0.4684 | 0.4686 | 994000.0 |
| 2004-04-29 10:02:00 | AAPL | Stock | 0.4686 | 0.4707 | 0.4686 | 0.4696 | 1483160.0 |
| 2004-04-29 10:03:00 | AAPL | Stock | 0.4693 | 0.4696 | 0.4688 | 0.4696 | 1677200.0 |
| 2004-04-29 10:04:00 | AAPL | Stock | 0.4693 | 0.4707 | 0.4693 | 0.4705 | 1590904.0 |
| 2004-04-29 10:05:00 | AAPL | Stock | 0.4705 | 0.4709 | 0.4702 | 0.4709 | 1197504.0 |
| 2004-04-29 10:06:00 | AAPL | Stock | 0.4709 | 0.4723 | 0.4707 | 0.4721 | 952000.0 |
| 2004-04-29 10:07:00 | AAPL | Stock | 0.4723 | 0.4759 | 0.4723 | 0.475 | 4349128.0 |
| 2004-04-29 10:08:00 | AAPL | Stock | 0.4749 | 0.4763 | 0.4748 | 0.4759 | 1847776.0 |
| 2004-04-29 10:09:00 | AAPL | Stock | 0.4759 | 0.4761 | 0.475 | 0.4755 | 1510544.0 |
| 2004-04-29 10:10:00 | AAPL | Stock | 0.4754 | 0.4759 | 0.475 | 0.4759 | 1961288.0 |
| 2004-04-29 10:11:00 | AAPL | Stock | 0.4757 | 0.4759 | 0.475 | 0.4757 | 1703576.0 |
| 2004-04-29 10:12:00 | AAPL | Stock | 0.4759 | 0.4789 | 0.4757 | 0.4779 | 4282880.0 |
| 2004-04-29 10:13:00 | AAPL | Stock | 0.4779 | 0.4804 | 0.4775 | 0.4804 | 2849280.0 |
> showing 50 of 522,895 rows — these rows as CSV