PREVIEW / stock_1min / 2007-05-02
file: by_date/stock_1min/2007/2007-05-02.parquet size: 10.9 MB rows: 893,199 symbols: 2,210
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-05-02 09:30:00 | AAPL | Stock | 3.5589 | 3.56 | 3.5571 | 3.5589 | 4113592.0 |
| 2007-05-02 09:31:00 | AAPL | Stock | 3.5589 | 3.56 | 3.5536 | 3.5556 | 1918588.0 |
| 2007-05-02 09:32:00 | AAPL | Stock | 3.5554 | 3.5568 | 3.5525 | 3.5525 | 1502480.0 |
| 2007-05-02 09:33:00 | AAPL | Stock | 3.5532 | 3.5571 | 3.5525 | 3.5571 | 1165752.0 |
| 2007-05-02 09:34:00 | AAPL | Stock | 3.5568 | 3.5625 | 3.5564 | 3.5621 | 2165436.0 |
| 2007-05-02 09:35:00 | AAPL | Stock | 3.5625 | 3.5657 | 3.5571 | 3.565 | 1949024.0 |
| 2007-05-02 09:36:00 | AAPL | Stock | 3.565 | 3.565 | 3.5625 | 3.5646 | 2457784.0 |
| 2007-05-02 09:37:00 | AAPL | Stock | 3.5643 | 3.57 | 3.5639 | 3.5682 | 3224928.0 |
| 2007-05-02 09:38:00 | AAPL | Stock | 3.5679 | 3.5743 | 3.5675 | 3.5743 | 4307016.0 |
| 2007-05-02 09:39:00 | AAPL | Stock | 3.5745 | 3.5782 | 3.5707 | 3.5779 | 4678716.0 |
| 2007-05-02 09:40:00 | AAPL | Stock | 3.5782 | 3.5796 | 3.5721 | 3.5761 | 3514980.0 |
| 2007-05-02 09:41:00 | AAPL | Stock | 3.5759 | 3.5786 | 3.5739 | 3.5746 | 1494052.0 |
| 2007-05-02 09:42:00 | AAPL | Stock | 3.5745 | 3.575 | 3.5725 | 3.5732 | 2371880.0 |
| 2007-05-02 09:43:00 | AAPL | Stock | 3.5732 | 3.5779 | 3.5732 | 3.5754 | 2488976.0 |
| 2007-05-02 09:44:00 | AAPL | Stock | 3.5754 | 3.5825 | 3.5754 | 3.5789 | 3869012.0 |
| 2007-05-02 09:45:00 | AAPL | Stock | 3.5793 | 3.5829 | 3.5789 | 3.5829 | 2407132.0 |
| 2007-05-02 09:46:00 | AAPL | Stock | 3.5825 | 3.5829 | 3.5804 | 3.5814 | 2938740.0 |
| 2007-05-02 09:47:00 | AAPL | Stock | 3.5814 | 3.5814 | 3.5768 | 3.5779 | 1875720.0 |
| 2007-05-02 09:48:00 | AAPL | Stock | 3.5782 | 3.5811 | 3.5736 | 3.5736 | 2582300.0 |
| 2007-05-02 09:49:00 | AAPL | Stock | 3.5732 | 3.5754 | 3.5711 | 3.5714 | 2769424.0 |
| 2007-05-02 09:50:00 | AAPL | Stock | 3.5721 | 3.5732 | 3.5707 | 3.5711 | 1960756.0 |
| 2007-05-02 09:51:00 | AAPL | Stock | 3.5711 | 3.5721 | 3.5696 | 3.5696 | 1604036.0 |
| 2007-05-02 09:52:00 | AAPL | Stock | 3.57 | 3.575 | 3.5696 | 3.5725 | 1480108.0 |
| 2007-05-02 09:53:00 | AAPL | Stock | 3.5725 | 3.5725 | 3.5696 | 3.5704 | 840644.0 |
| 2007-05-02 09:54:00 | AAPL | Stock | 3.5707 | 3.5714 | 3.5693 | 3.5693 | 1140860.0 |
| 2007-05-02 09:55:00 | AAPL | Stock | 3.5693 | 3.5725 | 3.5693 | 3.5725 | 1173816.0 |
| 2007-05-02 09:56:00 | AAPL | Stock | 3.5725 | 3.575 | 3.5711 | 3.5746 | 1899016.0 |
| 2007-05-02 09:57:00 | AAPL | Stock | 3.575 | 3.5771 | 3.5743 | 3.5754 | 3108000.0 |
| 2007-05-02 09:58:00 | AAPL | Stock | 3.5754 | 3.5757 | 3.575 | 3.575 | 992796.0 |
| 2007-05-02 09:59:00 | AAPL | Stock | 3.575 | 3.575 | 3.5732 | 3.5739 | 586292.0 |
| 2007-05-02 10:00:00 | AAPL | Stock | 3.5739 | 3.5757 | 3.5739 | 3.5739 | 1226260.0 |
| 2007-05-02 10:01:00 | AAPL | Stock | 3.5739 | 3.5768 | 3.5732 | 3.575 | 1195992.0 |
| 2007-05-02 10:02:00 | AAPL | Stock | 3.575 | 3.5779 | 3.5746 | 3.5779 | 1391684.0 |
| 2007-05-02 10:03:00 | AAPL | Stock | 3.5775 | 3.5782 | 3.5757 | 3.5761 | 1215144.0 |
| 2007-05-02 10:04:00 | AAPL | Stock | 3.5764 | 3.5786 | 3.575 | 3.5782 | 1691228.0 |
| 2007-05-02 10:05:00 | AAPL | Stock | 3.5786 | 3.5786 | 3.5736 | 3.5736 | 2422476.0 |
| 2007-05-02 10:06:00 | AAPL | Stock | 3.5736 | 3.5786 | 3.5725 | 3.5775 | 1935024.0 |
| 2007-05-02 10:07:00 | AAPL | Stock | 3.5779 | 3.5781 | 3.575 | 3.5768 | 929432.0 |
| 2007-05-02 10:08:00 | AAPL | Stock | 3.5764 | 3.5775 | 3.5743 | 3.5771 | 1140104.0 |
| 2007-05-02 10:09:00 | AAPL | Stock | 3.5764 | 3.5771 | 3.5757 | 3.5757 | 588280.0 |
| 2007-05-02 10:10:00 | AAPL | Stock | 3.5757 | 3.5764 | 3.5714 | 3.5718 | 1855840.0 |
| 2007-05-02 10:11:00 | AAPL | Stock | 3.5736 | 3.5754 | 3.5718 | 3.5718 | 1015756.0 |
| 2007-05-02 10:12:00 | AAPL | Stock | 3.5718 | 3.5746 | 3.5718 | 3.5746 | 915264.0 |
| 2007-05-02 10:13:00 | AAPL | Stock | 3.5744 | 3.5764 | 3.5744 | 3.5761 | 791672.0 |
| 2007-05-02 10:14:00 | AAPL | Stock | 3.5761 | 3.5786 | 3.576 | 3.5775 | 1665020.0 |
| 2007-05-02 10:15:00 | AAPL | Stock | 3.5775 | 3.58 | 3.5775 | 3.5786 | 2389688.0 |
| 2007-05-02 10:16:00 | AAPL | Stock | 3.5786 | 3.5789 | 3.575 | 3.5754 | 850024.0 |
| 2007-05-02 10:17:00 | AAPL | Stock | 3.5754 | 3.5779 | 3.5754 | 3.5761 | 739060.0 |
| 2007-05-02 10:18:00 | AAPL | Stock | 3.5757 | 3.5761 | 3.5732 | 3.5735 | 860804.0 |
| 2007-05-02 10:19:00 | AAPL | Stock | 3.5736 | 3.5771 | 3.5725 | 3.5771 | 1259048.0 |
> showing 50 of 893,199 rows — these rows as CSV