PREVIEW / stock_1min / 2007-04-30
file: by_date/stock_1min/2007/2007-04-30.parquet size: 10.5 MB rows: 852,759 symbols: 2,170
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 |
|---|---|---|---|---|---|---|---|
| 2007-04-30 09:30:00 | AAPL | Stock | 3.5746 | 3.5764 | 3.5654 | 3.5686 | 12165076.0 |
| 2007-04-30 09:31:00 | AAPL | Stock | 3.5689 | 3.5739 | 3.5657 | 3.5668 | 8687840.0 |
| 2007-04-30 09:32:00 | AAPL | Stock | 3.5664 | 3.5719 | 3.5654 | 3.5682 | 2957892.0 |
| 2007-04-30 09:33:00 | AAPL | Stock | 3.5679 | 3.57 | 3.5679 | 3.5697 | 2461284.0 |
| 2007-04-30 09:34:00 | AAPL | Stock | 3.5704 | 3.5768 | 3.5693 | 3.5732 | 3705016.0 |
| 2007-04-30 09:35:00 | AAPL | Stock | 3.5732 | 3.5764 | 3.5714 | 3.5739 | 4470312.0 |
| 2007-04-30 09:36:00 | AAPL | Stock | 3.5739 | 3.5754 | 3.5721 | 3.5739 | 3523016.0 |
| 2007-04-30 09:37:00 | AAPL | Stock | 3.5739 | 3.5786 | 3.5732 | 3.5768 | 5071668.0 |
| 2007-04-30 09:38:00 | AAPL | Stock | 3.5771 | 3.5775 | 3.5729 | 3.5746 | 3669988.0 |
| 2007-04-30 09:39:00 | AAPL | Stock | 3.5746 | 3.5746 | 3.5679 | 3.5696 | 4675132.0 |
| 2007-04-30 09:40:00 | AAPL | Stock | 3.57 | 3.5725 | 3.5679 | 3.5707 | 4246984.0 |
| 2007-04-30 09:41:00 | AAPL | Stock | 3.5704 | 3.5707 | 3.5671 | 3.5671 | 3696924.0 |
| 2007-04-30 09:42:00 | AAPL | Stock | 3.5672 | 3.5721 | 3.5671 | 3.57 | 2339344.0 |
| 2007-04-30 09:43:00 | AAPL | Stock | 3.57 | 3.5721 | 3.5675 | 3.5718 | 2501352.0 |
| 2007-04-30 09:44:00 | AAPL | Stock | 3.5718 | 3.5732 | 3.5714 | 3.5732 | 2476124.0 |
| 2007-04-30 09:45:00 | AAPL | Stock | 3.5736 | 3.5743 | 3.5714 | 3.5725 | 3856888.0 |
| 2007-04-30 09:46:00 | AAPL | Stock | 3.5731 | 3.58 | 3.5721 | 3.5793 | 5596724.0 |
| 2007-04-30 09:47:00 | AAPL | Stock | 3.5793 | 3.5793 | 3.5746 | 3.5754 | 5522216.0 |
| 2007-04-30 09:48:00 | AAPL | Stock | 3.5754 | 3.5775 | 3.5739 | 3.5754 | 3738364.0 |
| 2007-04-30 09:49:00 | AAPL | Stock | 3.5754 | 3.5793 | 3.5746 | 3.5782 | 2855860.0 |
| 2007-04-30 09:50:00 | AAPL | Stock | 3.5782 | 3.5807 | 3.5764 | 3.5782 | 4738776.0 |
| 2007-04-30 09:51:00 | AAPL | Stock | 3.5789 | 3.58 | 3.5757 | 3.5757 | 2715888.0 |
| 2007-04-30 09:52:00 | AAPL | Stock | 3.5761 | 3.5775 | 3.5664 | 3.5671 | 5802216.0 |
| 2007-04-30 09:53:00 | AAPL | Stock | 3.5671 | 3.5757 | 3.5671 | 3.575 | 2934260.0 |
| 2007-04-30 09:54:00 | AAPL | Stock | 3.575 | 3.5771 | 3.5721 | 3.574 | 2511012.0 |
| 2007-04-30 09:55:00 | AAPL | Stock | 3.5743 | 3.5771 | 3.5736 | 3.5757 | 1824564.0 |
| 2007-04-30 09:56:00 | AAPL | Stock | 3.5754 | 3.5771 | 3.575 | 3.5764 | 1039416.0 |
| 2007-04-30 09:57:00 | AAPL | Stock | 3.5768 | 3.5807 | 3.5768 | 3.5768 | 2601844.0 |
| 2007-04-30 09:58:00 | AAPL | Stock | 3.5771 | 3.5796 | 3.5768 | 3.5771 | 1287692.0 |
| 2007-04-30 09:59:00 | AAPL | Stock | 3.5768 | 3.5771 | 3.5721 | 3.5725 | 2200016.0 |
| 2007-04-30 10:00:00 | AAPL | Stock | 3.5721 | 3.5757 | 3.5718 | 3.5754 | 1577268.0 |
| 2007-04-30 10:01:00 | AAPL | Stock | 3.5754 | 3.5764 | 3.5729 | 3.5746 | 1843912.0 |
| 2007-04-30 10:02:00 | AAPL | Stock | 3.5739 | 3.5766 | 3.5736 | 3.5754 | 1075060.0 |
| 2007-04-30 10:03:00 | AAPL | Stock | 3.5754 | 3.5786 | 3.575 | 3.5771 | 1140888.0 |
| 2007-04-30 10:04:00 | AAPL | Stock | 3.5771 | 3.5786 | 3.5771 | 3.5775 | 813904.0 |
| 2007-04-30 10:05:00 | AAPL | Stock | 3.5771 | 3.5786 | 3.5732 | 3.5736 | 1322860.0 |
| 2007-04-30 10:06:00 | AAPL | Stock | 3.5736 | 3.5761 | 3.5729 | 3.575 | 1874768.0 |
| 2007-04-30 10:07:00 | AAPL | Stock | 3.5754 | 3.5754 | 3.5732 | 3.5743 | 839720.0 |
| 2007-04-30 10:08:00 | AAPL | Stock | 3.5743 | 3.5768 | 3.5732 | 3.5754 | 1508304.0 |
| 2007-04-30 10:09:00 | AAPL | Stock | 3.575 | 3.5768 | 3.575 | 3.5768 | 1101212.0 |
| 2007-04-30 10:10:00 | AAPL | Stock | 3.5768 | 3.58 | 3.575 | 3.58 | 2007852.0 |
| 2007-04-30 10:11:00 | AAPL | Stock | 3.58 | 3.5839 | 3.5793 | 3.5839 | 6844432.0 |
| 2007-04-30 10:12:00 | AAPL | Stock | 3.5836 | 3.5846 | 3.5811 | 3.5818 | 3443776.0 |
| 2007-04-30 10:13:00 | AAPL | Stock | 3.5818 | 3.5886 | 3.5814 | 3.5875 | 3465224.0 |
| 2007-04-30 10:14:00 | AAPL | Stock | 3.5875 | 3.6004 | 3.5864 | 3.5957 | 6691272.0 |
| 2007-04-30 10:15:00 | AAPL | Stock | 3.5964 | 3.5982 | 3.5804 | 3.5964 | 4171328.0 |
| 2007-04-30 10:16:00 | AAPL | Stock | 3.5957 | 3.5996 | 3.5946 | 3.5964 | 5980492.0 |
| 2007-04-30 10:17:00 | AAPL | Stock | 3.5964 | 3.6004 | 3.595 | 3.6 | 2957556.0 |
| 2007-04-30 10:18:00 | AAPL | Stock | 3.6 | 3.6029 | 3.5982 | 3.5989 | 4307884.0 |
| 2007-04-30 10:19:00 | AAPL | Stock | 3.5989 | 3.6018 | 3.5979 | 3.6004 | 2809660.0 |
> showing 50 of 852,759 rows — these rows as CSV