PREVIEW / stock_1min / 2004-08-04
file: by_date/stock_1min/2004/2004-08-04.parquet size: 6.0 MB rows: 507,708 symbols: 1,486
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-04 08:01:00 | AAPL | Stock | 0.5589 | 0.5589 | 0.5564 | 0.5564 | 11200.0 |
| 2004-08-04 08:21:00 | AAPL | Stock | 0.5554 | 0.5571 | 0.5552 | 0.5571 | 50400.0 |
| 2004-08-04 08:24:00 | AAPL | Stock | 0.5571 | 0.5571 | 0.5571 | 0.5571 | 28000.0 |
| 2004-08-04 08:26:00 | AAPL | Stock | 0.5571 | 0.5571 | 0.5571 | 0.5571 | 22400.0 |
| 2004-08-04 08:28:00 | AAPL | Stock | 0.5571 | 0.5571 | 0.5571 | 0.5571 | 39200.0 |
| 2004-08-04 08:36:00 | AAPL | Stock | 0.5571 | 0.5571 | 0.5571 | 0.5571 | 28000.0 |
| 2004-08-04 08:40:00 | AAPL | Stock | 0.5571 | 0.5571 | 0.5571 | 0.5571 | 5600.0 |
| 2004-08-04 09:15:00 | AAPL | Stock | 0.5568 | 0.5568 | 0.5568 | 0.5568 | 39200.0 |
| 2004-08-04 09:19:00 | AAPL | Stock | 0.5563 | 0.5563 | 0.5563 | 0.5563 | 56000.0 |
| 2004-08-04 09:20:00 | AAPL | Stock | 0.5568 | 0.5568 | 0.5568 | 0.5568 | 33600.0 |
| 2004-08-04 09:21:00 | AAPL | Stock | 0.5568 | 0.5568 | 0.5568 | 0.5568 | 11200.0 |
| 2004-08-04 09:22:00 | AAPL | Stock | 0.5571 | 0.5571 | 0.5571 | 0.5571 | 5600.0 |
| 2004-08-04 09:27:00 | AAPL | Stock | 0.5586 | 0.5586 | 0.5586 | 0.5586 | 44800.0 |
| 2004-08-04 09:29:00 | AAPL | Stock | 0.5586 | 0.5593 | 0.5575 | 0.5577 | 218344.0 |
| 2004-08-04 09:30:00 | AAPL | Stock | 0.557 | 0.5621 | 0.557 | 0.562 | 2651656.0 |
| 2004-08-04 09:31:00 | AAPL | Stock | 0.5621 | 0.5625 | 0.5616 | 0.5625 | 843304.0 |
| 2004-08-04 09:32:00 | AAPL | Stock | 0.5621 | 0.5634 | 0.5621 | 0.5623 | 813344.0 |
| 2004-08-04 09:33:00 | AAPL | Stock | 0.5623 | 0.5623 | 0.5609 | 0.5611 | 809088.0 |
| 2004-08-04 09:34:00 | AAPL | Stock | 0.5613 | 0.5614 | 0.5611 | 0.5614 | 498400.0 |
| 2004-08-04 09:35:00 | AAPL | Stock | 0.5616 | 0.5623 | 0.5609 | 0.5614 | 879872.0 |
| 2004-08-04 09:36:00 | AAPL | Stock | 0.5614 | 0.5623 | 0.5613 | 0.5614 | 1264144.0 |
| 2004-08-04 09:37:00 | AAPL | Stock | 0.5609 | 0.5609 | 0.5588 | 0.5596 | 1438808.0 |
| 2004-08-04 09:38:00 | AAPL | Stock | 0.5598 | 0.5602 | 0.5588 | 0.5591 | 1174712.0 |
| 2004-08-04 09:39:00 | AAPL | Stock | 0.5589 | 0.5613 | 0.5589 | 0.5609 | 778400.0 |
| 2004-08-04 09:40:00 | AAPL | Stock | 0.5609 | 0.5616 | 0.5605 | 0.5614 | 655200.0 |
| 2004-08-04 09:41:00 | AAPL | Stock | 0.5611 | 0.5614 | 0.5598 | 0.5607 | 1635088.0 |
| 2004-08-04 09:42:00 | AAPL | Stock | 0.5604 | 0.5607 | 0.5604 | 0.5607 | 333200.0 |
| 2004-08-04 09:43:00 | AAPL | Stock | 0.5607 | 0.5607 | 0.5607 | 0.5607 | 106400.0 |
| 2004-08-04 09:44:00 | AAPL | Stock | 0.5607 | 0.5613 | 0.5607 | 0.5613 | 392280.0 |
| 2004-08-04 09:45:00 | AAPL | Stock | 0.5607 | 0.5614 | 0.5605 | 0.5607 | 1649592.0 |
| 2004-08-04 09:46:00 | AAPL | Stock | 0.5607 | 0.5609 | 0.56 | 0.5604 | 401744.0 |
| 2004-08-04 09:47:00 | AAPL | Stock | 0.5605 | 0.5609 | 0.56 | 0.5607 | 826224.0 |
| 2004-08-04 09:48:00 | AAPL | Stock | 0.5605 | 0.5607 | 0.5604 | 0.5604 | 656712.0 |
| 2004-08-04 09:49:00 | AAPL | Stock | 0.56 | 0.5604 | 0.5598 | 0.56 | 229880.0 |
| 2004-08-04 09:50:00 | AAPL | Stock | 0.5605 | 0.5607 | 0.5604 | 0.5604 | 136304.0 |
| 2004-08-04 09:51:00 | AAPL | Stock | 0.5604 | 0.5613 | 0.56 | 0.5613 | 877744.0 |
| 2004-08-04 09:52:00 | AAPL | Stock | 0.5614 | 0.5625 | 0.5614 | 0.5621 | 2763544.0 |
| 2004-08-04 09:53:00 | AAPL | Stock | 0.5614 | 0.5625 | 0.5609 | 0.562 | 1820000.0 |
| 2004-08-04 09:54:00 | AAPL | Stock | 0.562 | 0.5621 | 0.5616 | 0.5616 | 393512.0 |
| 2004-08-04 09:55:00 | AAPL | Stock | 0.5613 | 0.5613 | 0.5609 | 0.5611 | 173600.0 |
| 2004-08-04 09:56:00 | AAPL | Stock | 0.5609 | 0.5613 | 0.5609 | 0.5611 | 304976.0 |
| 2004-08-04 09:57:00 | AAPL | Stock | 0.5609 | 0.5609 | 0.5607 | 0.5607 | 42000.0 |
| 2004-08-04 09:58:00 | AAPL | Stock | 0.5609 | 0.5614 | 0.5609 | 0.5611 | 2960384.0 |
| 2004-08-04 09:59:00 | AAPL | Stock | 0.5611 | 0.5613 | 0.5604 | 0.5609 | 561288.0 |
| 2004-08-04 10:00:00 | AAPL | Stock | 0.5608 | 0.5616 | 0.5607 | 0.5613 | 965440.0 |
| 2004-08-04 10:01:00 | AAPL | Stock | 0.5613 | 0.5613 | 0.5605 | 0.5607 | 364224.0 |
| 2004-08-04 10:02:00 | AAPL | Stock | 0.5607 | 0.5607 | 0.5602 | 0.5602 | 520968.0 |
| 2004-08-04 10:03:00 | AAPL | Stock | 0.56 | 0.56 | 0.5598 | 0.56 | 336560.0 |
| 2004-08-04 10:04:00 | AAPL | Stock | 0.56 | 0.56 | 0.5598 | 0.56 | 209608.0 |
| 2004-08-04 10:05:00 | AAPL | Stock | 0.56 | 0.56 | 0.5598 | 0.56 | 293104.0 |
> showing 50 of 507,708 rows — these rows as CSV