PREVIEW / stock_1min / 2004-06-30
file: by_date/stock_1min/2004/2004-06-30.parquet size: 6.1 MB rows: 508,204 symbols: 1,475
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-06-30 08:29:00 | AAPL | Stock | 0.5813 | 0.5813 | 0.5813 | 0.5813 | 11200.0 |
| 2004-06-30 08:50:00 | AAPL | Stock | 0.5821 | 0.5829 | 0.5821 | 0.5829 | 73080.0 |
| 2004-06-30 08:57:00 | AAPL | Stock | 0.583 | 0.583 | 0.583 | 0.583 | 56000.0 |
| 2004-06-30 09:29:00 | AAPL | Stock | 0.5814 | 0.5829 | 0.5809 | 0.5813 | 171136.0 |
| 2004-06-30 09:30:00 | AAPL | Stock | 0.5805 | 0.5814 | 0.5784 | 0.5784 | 3144064.0 |
| 2004-06-30 09:31:00 | AAPL | Stock | 0.5779 | 0.5782 | 0.5775 | 0.5777 | 836304.0 |
| 2004-06-30 09:32:00 | AAPL | Stock | 0.5777 | 0.5779 | 0.575 | 0.5764 | 1526392.0 |
| 2004-06-30 09:33:00 | AAPL | Stock | 0.577 | 0.5784 | 0.575 | 0.5777 | 1195544.0 |
| 2004-06-30 09:34:00 | AAPL | Stock | 0.5777 | 0.5782 | 0.5775 | 0.5779 | 533680.0 |
| 2004-06-30 09:35:00 | AAPL | Stock | 0.578 | 0.5804 | 0.5777 | 0.5798 | 950040.0 |
| 2004-06-30 09:36:00 | AAPL | Stock | 0.58 | 0.5802 | 0.5784 | 0.58 | 794304.0 |
| 2004-06-30 09:37:00 | AAPL | Stock | 0.5795 | 0.5804 | 0.5795 | 0.5802 | 938280.0 |
| 2004-06-30 09:38:00 | AAPL | Stock | 0.5804 | 0.5804 | 0.5796 | 0.5802 | 669200.0 |
| 2004-06-30 09:39:00 | AAPL | Stock | 0.5798 | 0.5802 | 0.5791 | 0.5802 | 835464.0 |
| 2004-06-30 09:40:00 | AAPL | Stock | 0.58 | 0.5802 | 0.5788 | 0.5789 | 470400.0 |
| 2004-06-30 09:41:00 | AAPL | Stock | 0.5789 | 0.5798 | 0.5786 | 0.5793 | 510104.0 |
| 2004-06-30 09:42:00 | AAPL | Stock | 0.5791 | 0.5793 | 0.5786 | 0.5793 | 89600.0 |
| 2004-06-30 09:43:00 | AAPL | Stock | 0.5789 | 0.58 | 0.5789 | 0.58 | 620536.0 |
| 2004-06-30 09:44:00 | AAPL | Stock | 0.5798 | 0.5804 | 0.5788 | 0.5804 | 997528.0 |
| 2004-06-30 09:45:00 | AAPL | Stock | 0.5802 | 0.5818 | 0.5796 | 0.5818 | 532168.0 |
| 2004-06-30 09:46:00 | AAPL | Stock | 0.5814 | 0.5827 | 0.581 | 0.5827 | 2279200.0 |
| 2004-06-30 09:47:00 | AAPL | Stock | 0.5829 | 0.5832 | 0.5827 | 0.5829 | 704592.0 |
| 2004-06-30 09:48:00 | AAPL | Stock | 0.5832 | 0.5838 | 0.5823 | 0.5834 | 1165640.0 |
| 2004-06-30 09:49:00 | AAPL | Stock | 0.5839 | 0.5855 | 0.5838 | 0.5855 | 927920.0 |
| 2004-06-30 09:50:00 | AAPL | Stock | 0.5855 | 0.5884 | 0.5854 | 0.5875 | 3456656.0 |
| 2004-06-30 09:51:00 | AAPL | Stock | 0.5879 | 0.5882 | 0.5859 | 0.5859 | 4647496.0 |
| 2004-06-30 09:52:00 | AAPL | Stock | 0.5861 | 0.5877 | 0.5855 | 0.5877 | 1513512.0 |
| 2004-06-30 09:53:00 | AAPL | Stock | 0.5877 | 0.5888 | 0.5873 | 0.5879 | 1835848.0 |
| 2004-06-30 09:54:00 | AAPL | Stock | 0.5877 | 0.5879 | 0.5875 | 0.5875 | 1091328.0 |
| 2004-06-30 09:55:00 | AAPL | Stock | 0.5875 | 0.5877 | 0.5868 | 0.587 | 768768.0 |
| 2004-06-30 09:56:00 | AAPL | Stock | 0.5868 | 0.5877 | 0.5866 | 0.5875 | 747488.0 |
| 2004-06-30 09:57:00 | AAPL | Stock | 0.5875 | 0.5879 | 0.5871 | 0.5873 | 988400.0 |
| 2004-06-30 09:58:00 | AAPL | Stock | 0.5873 | 0.5873 | 0.5859 | 0.5859 | 1659280.0 |
| 2004-06-30 09:59:00 | AAPL | Stock | 0.5861 | 0.5861 | 0.5855 | 0.5857 | 985096.0 |
| 2004-06-30 10:00:00 | AAPL | Stock | 0.5857 | 0.5859 | 0.585 | 0.585 | 1414392.0 |
| 2004-06-30 10:01:00 | AAPL | Stock | 0.585 | 0.5852 | 0.583 | 0.5834 | 1719200.0 |
| 2004-06-30 10:02:00 | AAPL | Stock | 0.5834 | 0.5834 | 0.5814 | 0.5816 | 678048.0 |
| 2004-06-30 10:03:00 | AAPL | Stock | 0.5814 | 0.5816 | 0.5795 | 0.5807 | 1360520.0 |
| 2004-06-30 10:04:00 | AAPL | Stock | 0.5809 | 0.5814 | 0.5804 | 0.5814 | 784280.0 |
| 2004-06-30 10:05:00 | AAPL | Stock | 0.5814 | 0.5818 | 0.5813 | 0.5818 | 715120.0 |
| 2004-06-30 10:06:00 | AAPL | Stock | 0.5818 | 0.5829 | 0.5814 | 0.5829 | 1428000.0 |
| 2004-06-30 10:07:00 | AAPL | Stock | 0.5832 | 0.5848 | 0.5827 | 0.5846 | 1843968.0 |
| 2004-06-30 10:08:00 | AAPL | Stock | 0.5846 | 0.5848 | 0.5834 | 0.5839 | 1290576.0 |
| 2004-06-30 10:09:00 | AAPL | Stock | 0.5841 | 0.5843 | 0.5818 | 0.5821 | 702184.0 |
| 2004-06-30 10:10:00 | AAPL | Stock | 0.5818 | 0.5818 | 0.5811 | 0.5811 | 236768.0 |
| 2004-06-30 10:11:00 | AAPL | Stock | 0.5811 | 0.5821 | 0.5811 | 0.5821 | 541072.0 |
| 2004-06-30 10:12:00 | AAPL | Stock | 0.5821 | 0.5821 | 0.5811 | 0.5816 | 127736.0 |
| 2004-06-30 10:13:00 | AAPL | Stock | 0.5816 | 0.5816 | 0.5814 | 0.5816 | 238000.0 |
| 2004-06-30 10:14:00 | AAPL | Stock | 0.5816 | 0.5818 | 0.5798 | 0.5798 | 394856.0 |
| 2004-06-30 10:15:00 | AAPL | Stock | 0.58 | 0.58 | 0.5796 | 0.5796 | 280280.0 |
> showing 50 of 508,204 rows — these rows as CSV