PREVIEW / stock_1min / 2005-07-29
file: by_date/stock_1min/2005/2005-07-29.parquet size: 7.0 MB rows: 584,128 symbols: 1,676
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 |
|---|---|---|---|---|---|---|---|
| 2005-07-29 08:15:00 | AAPL | Stock | 1.5611 | 1.5611 | 1.5611 | 1.5611 | 28000.0 |
| 2005-07-29 08:19:00 | AAPL | Stock | 1.5607 | 1.5607 | 1.5607 | 1.5607 | 5600.0 |
| 2005-07-29 08:31:00 | AAPL | Stock | 1.5536 | 1.5536 | 1.5536 | 1.5536 | 2800.0 |
| 2005-07-29 08:34:00 | AAPL | Stock | 1.5589 | 1.5589 | 1.5589 | 1.5589 | 53228.0 |
| 2005-07-29 08:37:00 | AAPL | Stock | 1.5589 | 1.5589 | 1.5589 | 1.5589 | 8428.0 |
| 2005-07-29 08:41:00 | AAPL | Stock | 1.5607 | 1.5607 | 1.5607 | 1.5607 | 28000.0 |
| 2005-07-29 08:43:00 | AAPL | Stock | 1.5607 | 1.5607 | 1.5607 | 1.5607 | 5600.0 |
| 2005-07-29 08:49:00 | AAPL | Stock | 1.5589 | 1.5589 | 1.5589 | 1.5589 | 9212.0 |
| 2005-07-29 08:58:00 | AAPL | Stock | 1.5589 | 1.5589 | 1.5589 | 1.5589 | 5600.0 |
| 2005-07-29 09:01:00 | AAPL | Stock | 1.5586 | 1.5586 | 1.5571 | 1.5571 | 58800.0 |
| 2005-07-29 09:04:00 | AAPL | Stock | 1.5554 | 1.5554 | 1.5554 | 1.5554 | 2800.0 |
| 2005-07-29 09:09:00 | AAPL | Stock | 1.5571 | 1.5571 | 1.5571 | 1.5571 | 2800.0 |
| 2005-07-29 09:10:00 | AAPL | Stock | 1.5557 | 1.5557 | 1.5557 | 1.5557 | 8400.0 |
| 2005-07-29 09:15:00 | AAPL | Stock | 1.5571 | 1.5589 | 1.5571 | 1.5589 | 14000.0 |
| 2005-07-29 09:24:00 | AAPL | Stock | 1.5589 | 1.5589 | 1.5589 | 1.5589 | 28000.0 |
| 2005-07-29 09:29:00 | AAPL | Stock | 1.5589 | 1.5589 | 1.5557 | 1.5557 | 112000.0 |
| 2005-07-29 09:30:00 | AAPL | Stock | 1.5557 | 1.5596 | 1.5518 | 1.5561 | 4695488.0 |
| 2005-07-29 09:31:00 | AAPL | Stock | 1.5564 | 1.5589 | 1.5554 | 1.5575 | 962304.0 |
| 2005-07-29 09:32:00 | AAPL | Stock | 1.5575 | 1.5586 | 1.5571 | 1.5579 | 374836.0 |
| 2005-07-29 09:33:00 | AAPL | Stock | 1.5582 | 1.5596 | 1.5571 | 1.5596 | 1188460.0 |
| 2005-07-29 09:34:00 | AAPL | Stock | 1.56 | 1.56 | 1.5561 | 1.5571 | 1637440.0 |
| 2005-07-29 09:35:00 | AAPL | Stock | 1.5575 | 1.5593 | 1.5571 | 1.5579 | 602000.0 |
| 2005-07-29 09:36:00 | AAPL | Stock | 1.5579 | 1.5596 | 1.5546 | 1.5546 | 1255184.0 |
| 2005-07-29 09:37:00 | AAPL | Stock | 1.555 | 1.5571 | 1.5543 | 1.5571 | 872340.0 |
| 2005-07-29 09:38:00 | AAPL | Stock | 1.5568 | 1.5571 | 1.5539 | 1.5554 | 1097264.0 |
| 2005-07-29 09:39:00 | AAPL | Stock | 1.555 | 1.5564 | 1.5543 | 1.5564 | 801808.0 |
| 2005-07-29 09:40:00 | AAPL | Stock | 1.5564 | 1.5575 | 1.5564 | 1.5575 | 954744.0 |
| 2005-07-29 09:41:00 | AAPL | Stock | 1.5575 | 1.56 | 1.5575 | 1.5596 | 880600.0 |
| 2005-07-29 09:42:00 | AAPL | Stock | 1.56 | 1.5618 | 1.5596 | 1.5614 | 837368.0 |
| 2005-07-29 09:43:00 | AAPL | Stock | 1.5614 | 1.5618 | 1.5611 | 1.5614 | 406000.0 |
| 2005-07-29 09:44:00 | AAPL | Stock | 1.5618 | 1.5629 | 1.5618 | 1.5629 | 795312.0 |
| 2005-07-29 09:45:00 | AAPL | Stock | 1.5632 | 1.5643 | 1.5629 | 1.5632 | 1019144.0 |
| 2005-07-29 09:46:00 | AAPL | Stock | 1.5629 | 1.5637 | 1.5629 | 1.5629 | 416864.0 |
| 2005-07-29 09:47:00 | AAPL | Stock | 1.5629 | 1.5668 | 1.5621 | 1.5668 | 1812888.0 |
| 2005-07-29 09:48:00 | AAPL | Stock | 1.5668 | 1.5707 | 1.5643 | 1.57 | 4170992.0 |
| 2005-07-29 09:49:00 | AAPL | Stock | 1.5696 | 1.5707 | 1.5686 | 1.5693 | 1260952.0 |
| 2005-07-29 09:50:00 | AAPL | Stock | 1.5693 | 1.5693 | 1.5679 | 1.5682 | 767144.0 |
| 2005-07-29 09:51:00 | AAPL | Stock | 1.5684 | 1.5693 | 1.5684 | 1.5689 | 819728.0 |
| 2005-07-29 09:52:00 | AAPL | Stock | 1.5693 | 1.5696 | 1.5668 | 1.5679 | 1312640.0 |
| 2005-07-29 09:53:00 | AAPL | Stock | 1.5679 | 1.5689 | 1.5668 | 1.5671 | 2571044.0 |
| 2005-07-29 09:54:00 | AAPL | Stock | 1.5668 | 1.5682 | 1.5664 | 1.5668 | 1280384.0 |
| 2005-07-29 09:55:00 | AAPL | Stock | 1.5668 | 1.5696 | 1.5668 | 1.5689 | 1138116.0 |
| 2005-07-29 09:56:00 | AAPL | Stock | 1.5693 | 1.57 | 1.5686 | 1.5696 | 1558396.0 |
| 2005-07-29 09:57:00 | AAPL | Stock | 1.5696 | 1.5729 | 1.5693 | 1.5714 | 8654716.0 |
| 2005-07-29 09:58:00 | AAPL | Stock | 1.5714 | 1.5779 | 1.5714 | 1.5757 | 6212080.0 |
| 2005-07-29 09:59:00 | AAPL | Stock | 1.5757 | 1.5807 | 1.5714 | 1.5807 | 5887308.0 |
| 2005-07-29 10:00:00 | AAPL | Stock | 1.5807 | 1.585 | 1.575 | 1.5843 | 8366540.0 |
| 2005-07-29 10:01:00 | AAPL | Stock | 1.5846 | 1.5846 | 1.5779 | 1.5782 | 6145776.0 |
| 2005-07-29 10:02:00 | AAPL | Stock | 1.5782 | 1.58 | 1.5768 | 1.5786 | 2655072.0 |
| 2005-07-29 10:03:00 | AAPL | Stock | 1.5796 | 1.5796 | 1.5771 | 1.5786 | 3483088.0 |
> showing 50 of 584,128 rows — these rows as CSV