PREVIEW / stock_1min / 2005-02-16
file: by_date/stock_1min/2005/2005-02-16.parquet size: 6.6 MB rows: 545,050 symbols: 1,595
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-02-16 08:00:00 | AAPL | Stock | 1.5882 | 1.5882 | 1.5839 | 1.5839 | 226800.0 |
| 2005-02-16 08:01:00 | AAPL | Stock | 1.5848 | 1.588 | 1.583 | 1.5855 | 725480.0 |
| 2005-02-16 08:02:00 | AAPL | Stock | 1.5839 | 1.5855 | 1.5839 | 1.5848 | 95200.0 |
| 2005-02-16 08:03:00 | AAPL | Stock | 1.5848 | 1.5866 | 1.5848 | 1.5866 | 140000.0 |
| 2005-02-16 08:04:00 | AAPL | Stock | 1.5866 | 1.5866 | 1.5857 | 1.5866 | 90160.0 |
| 2005-02-16 08:05:00 | AAPL | Stock | 1.5864 | 1.5884 | 1.5857 | 1.5866 | 207256.0 |
| 2005-02-16 08:06:00 | AAPL | Stock | 1.5893 | 1.5893 | 1.5866 | 1.5866 | 144144.0 |
| 2005-02-16 08:07:00 | AAPL | Stock | 1.5875 | 1.5893 | 1.5875 | 1.5884 | 471800.0 |
| 2005-02-16 08:08:00 | AAPL | Stock | 1.5893 | 1.5911 | 1.5893 | 1.5911 | 223664.0 |
| 2005-02-16 08:09:00 | AAPL | Stock | 1.5911 | 1.5921 | 1.5893 | 1.5916 | 546336.0 |
| 2005-02-16 08:10:00 | AAPL | Stock | 1.5916 | 1.5916 | 1.5895 | 1.5909 | 103600.0 |
| 2005-02-16 08:11:00 | AAPL | Stock | 1.5905 | 1.5911 | 1.5884 | 1.5888 | 306824.0 |
| 2005-02-16 08:12:00 | AAPL | Stock | 1.5888 | 1.5893 | 1.5884 | 1.5884 | 187320.0 |
| 2005-02-16 08:13:00 | AAPL | Stock | 1.5875 | 1.5875 | 1.585 | 1.5857 | 196560.0 |
| 2005-02-16 08:14:00 | AAPL | Stock | 1.5859 | 1.5859 | 1.5857 | 1.5857 | 39200.0 |
| 2005-02-16 08:15:00 | AAPL | Stock | 1.5857 | 1.5866 | 1.5848 | 1.5848 | 66584.0 |
| 2005-02-16 08:16:00 | AAPL | Stock | 1.5848 | 1.5848 | 1.5848 | 1.5848 | 27608.0 |
| 2005-02-16 08:17:00 | AAPL | Stock | 1.5839 | 1.5841 | 1.5832 | 1.5836 | 273840.0 |
| 2005-02-16 08:18:00 | AAPL | Stock | 1.5836 | 1.5836 | 1.583 | 1.583 | 179200.0 |
| 2005-02-16 08:19:00 | AAPL | Stock | 1.5825 | 1.5825 | 1.5804 | 1.5813 | 257600.0 |
| 2005-02-16 08:20:00 | AAPL | Stock | 1.5813 | 1.5838 | 1.5784 | 1.5804 | 711200.0 |
| 2005-02-16 08:21:00 | AAPL | Stock | 1.5788 | 1.5788 | 1.5739 | 1.575 | 200480.0 |
| 2005-02-16 08:22:00 | AAPL | Stock | 1.575 | 1.5761 | 1.5741 | 1.5759 | 239736.0 |
| 2005-02-16 08:23:00 | AAPL | Stock | 1.5766 | 1.577 | 1.5757 | 1.5766 | 154000.0 |
| 2005-02-16 08:24:00 | AAPL | Stock | 1.5764 | 1.5768 | 1.5759 | 1.5768 | 213864.0 |
| 2005-02-16 08:25:00 | AAPL | Stock | 1.5768 | 1.5771 | 1.5768 | 1.5771 | 173600.0 |
| 2005-02-16 08:26:00 | AAPL | Stock | 1.5777 | 1.5777 | 1.5748 | 1.575 | 222600.0 |
| 2005-02-16 08:27:00 | AAPL | Stock | 1.5741 | 1.5779 | 1.5741 | 1.5743 | 269920.0 |
| 2005-02-16 08:28:00 | AAPL | Stock | 1.5741 | 1.5746 | 1.5714 | 1.5714 | 268800.0 |
| 2005-02-16 08:29:00 | AAPL | Stock | 1.572 | 1.5723 | 1.5686 | 1.5689 | 298760.0 |
| 2005-02-16 08:30:00 | AAPL | Stock | 1.5693 | 1.5729 | 1.5689 | 1.5729 | 368760.0 |
| 2005-02-16 08:31:00 | AAPL | Stock | 1.5721 | 1.5721 | 1.5696 | 1.5696 | 246400.0 |
| 2005-02-16 08:32:00 | AAPL | Stock | 1.5688 | 1.5707 | 1.5688 | 1.5696 | 218400.0 |
| 2005-02-16 08:33:00 | AAPL | Stock | 1.5705 | 1.5714 | 1.5625 | 1.5673 | 868000.0 |
| 2005-02-16 08:34:00 | AAPL | Stock | 1.5673 | 1.5707 | 1.5673 | 1.5696 | 383600.0 |
| 2005-02-16 08:35:00 | AAPL | Stock | 1.5695 | 1.5696 | 1.5686 | 1.5688 | 151200.0 |
| 2005-02-16 08:36:00 | AAPL | Stock | 1.5686 | 1.5788 | 1.5663 | 1.5663 | 231112.0 |
| 2005-02-16 08:37:00 | AAPL | Stock | 1.5673 | 1.5679 | 1.5661 | 1.5666 | 312480.0 |
| 2005-02-16 08:38:00 | AAPL | Stock | 1.567 | 1.5679 | 1.5661 | 1.567 | 138880.0 |
| 2005-02-16 08:39:00 | AAPL | Stock | 1.5663 | 1.5679 | 1.5636 | 1.5654 | 350000.0 |
| 2005-02-16 08:40:00 | AAPL | Stock | 1.5654 | 1.5684 | 1.5623 | 1.5641 | 511840.0 |
| 2005-02-16 08:41:00 | AAPL | Stock | 1.5638 | 1.5643 | 1.5623 | 1.5643 | 406280.0 |
| 2005-02-16 08:42:00 | AAPL | Stock | 1.5641 | 1.5643 | 1.5632 | 1.5632 | 308000.0 |
| 2005-02-16 08:43:00 | AAPL | Stock | 1.563 | 1.5705 | 1.5625 | 1.5643 | 442008.0 |
| 2005-02-16 08:44:00 | AAPL | Stock | 1.5654 | 1.5654 | 1.5604 | 1.5616 | 392448.0 |
| 2005-02-16 08:45:00 | AAPL | Stock | 1.5604 | 1.5618 | 1.5593 | 1.5616 | 271600.0 |
| 2005-02-16 08:46:00 | AAPL | Stock | 1.5618 | 1.5618 | 1.5605 | 1.5618 | 359632.0 |
| 2005-02-16 08:47:00 | AAPL | Stock | 1.5607 | 1.5621 | 1.5607 | 1.5621 | 121800.0 |
| 2005-02-16 08:48:00 | AAPL | Stock | 1.5609 | 1.5654 | 1.5607 | 1.5652 | 557480.0 |
| 2005-02-16 08:49:00 | AAPL | Stock | 1.5654 | 1.5657 | 1.5654 | 1.5654 | 163800.0 |
> showing 50 of 545,050 rows — these rows as CSV