PREVIEW / stock_1min / 2004-06-22
file: by_date/stock_1min/2004/2004-06-22.parquet size: 6.0 MB rows: 503,622 symbols: 1,474
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-22 08:01:00 | AAPL | Stock | 0.5777 | 0.5777 | 0.5777 | 0.5777 | 11200.0 |
| 2004-06-22 08:12:00 | AAPL | Stock | 0.5773 | 0.5773 | 0.5773 | 0.5773 | 61600.0 |
| 2004-06-22 08:23:00 | AAPL | Stock | 0.5775 | 0.5775 | 0.5775 | 0.5775 | 16800.0 |
| 2004-06-22 08:36:00 | AAPL | Stock | 0.5786 | 0.5786 | 0.5786 | 0.5786 | 28000.0 |
| 2004-06-22 08:43:00 | AAPL | Stock | 0.5786 | 0.5786 | 0.5786 | 0.5786 | 25984.0 |
| 2004-06-22 08:47:00 | AAPL | Stock | 0.5786 | 0.5786 | 0.5786 | 0.5786 | 14000.0 |
| 2004-06-22 08:53:00 | AAPL | Stock | 0.5786 | 0.5786 | 0.5786 | 0.5786 | 16800.0 |
| 2004-06-22 08:55:00 | AAPL | Stock | 0.5775 | 0.5775 | 0.5775 | 0.5775 | 67200.0 |
| 2004-06-22 09:08:00 | AAPL | Stock | 0.5777 | 0.5777 | 0.5777 | 0.5777 | 16800.0 |
| 2004-06-22 09:12:00 | AAPL | Stock | 0.5777 | 0.5777 | 0.5777 | 0.5777 | 140000.0 |
| 2004-06-22 09:17:00 | AAPL | Stock | 0.5777 | 0.5777 | 0.5777 | 0.5777 | 33600.0 |
| 2004-06-22 09:24:00 | AAPL | Stock | 0.5773 | 0.5773 | 0.5773 | 0.5773 | 39200.0 |
| 2004-06-22 09:28:00 | AAPL | Stock | 0.5771 | 0.5773 | 0.5771 | 0.5773 | 56000.0 |
| 2004-06-22 09:29:00 | AAPL | Stock | 0.5773 | 0.5777 | 0.5771 | 0.5777 | 302400.0 |
| 2004-06-22 09:30:00 | AAPL | Stock | 0.5771 | 0.5779 | 0.5766 | 0.5771 | 3010168.0 |
| 2004-06-22 09:31:00 | AAPL | Stock | 0.5771 | 0.5782 | 0.5771 | 0.5777 | 1075256.0 |
| 2004-06-22 09:32:00 | AAPL | Stock | 0.5782 | 0.5798 | 0.5775 | 0.5798 | 880880.0 |
| 2004-06-22 09:33:00 | AAPL | Stock | 0.5796 | 0.5804 | 0.5786 | 0.5786 | 2387280.0 |
| 2004-06-22 09:34:00 | AAPL | Stock | 0.5786 | 0.58 | 0.5779 | 0.5788 | 2399264.0 |
| 2004-06-22 09:35:00 | AAPL | Stock | 0.5788 | 0.5788 | 0.578 | 0.5786 | 594496.0 |
| 2004-06-22 09:36:00 | AAPL | Stock | 0.5786 | 0.5804 | 0.5786 | 0.5804 | 2362248.0 |
| 2004-06-22 09:37:00 | AAPL | Stock | 0.5805 | 0.5805 | 0.5795 | 0.5798 | 1003296.0 |
| 2004-06-22 09:38:00 | AAPL | Stock | 0.5804 | 0.5805 | 0.5793 | 0.58 | 1593704.0 |
| 2004-06-22 09:39:00 | AAPL | Stock | 0.5802 | 0.5814 | 0.58 | 0.5811 | 1025640.0 |
| 2004-06-22 09:40:00 | AAPL | Stock | 0.5816 | 0.5823 | 0.5811 | 0.5811 | 1826384.0 |
| 2004-06-22 09:41:00 | AAPL | Stock | 0.5811 | 0.5829 | 0.5802 | 0.5829 | 2703288.0 |
| 2004-06-22 09:42:00 | AAPL | Stock | 0.5829 | 0.5832 | 0.5825 | 0.583 | 1311072.0 |
| 2004-06-22 09:43:00 | AAPL | Stock | 0.5834 | 0.5834 | 0.5823 | 0.5825 | 456400.0 |
| 2004-06-22 09:44:00 | AAPL | Stock | 0.5827 | 0.5827 | 0.5821 | 0.5823 | 837592.0 |
| 2004-06-22 09:45:00 | AAPL | Stock | 0.5823 | 0.5857 | 0.5823 | 0.5857 | 2321424.0 |
| 2004-06-22 09:46:00 | AAPL | Stock | 0.5857 | 0.587 | 0.583 | 0.5863 | 2639336.0 |
| 2004-06-22 09:47:00 | AAPL | Stock | 0.5861 | 0.5866 | 0.5859 | 0.5863 | 1250760.0 |
| 2004-06-22 09:48:00 | AAPL | Stock | 0.5859 | 0.5864 | 0.5846 | 0.5861 | 1097600.0 |
| 2004-06-22 09:49:00 | AAPL | Stock | 0.5864 | 0.5868 | 0.5857 | 0.5857 | 950712.0 |
| 2004-06-22 09:50:00 | AAPL | Stock | 0.5859 | 0.5859 | 0.5839 | 0.5839 | 823200.0 |
| 2004-06-22 09:51:00 | AAPL | Stock | 0.5838 | 0.5852 | 0.5827 | 0.5846 | 1672216.0 |
| 2004-06-22 09:52:00 | AAPL | Stock | 0.5846 | 0.5854 | 0.5845 | 0.5852 | 465752.0 |
| 2004-06-22 09:53:00 | AAPL | Stock | 0.5852 | 0.5852 | 0.5823 | 0.5834 | 1265600.0 |
| 2004-06-22 09:54:00 | AAPL | Stock | 0.5836 | 0.5847 | 0.5825 | 0.5832 | 867048.0 |
| 2004-06-22 09:55:00 | AAPL | Stock | 0.5832 | 0.5834 | 0.5829 | 0.583 | 345296.0 |
| 2004-06-22 09:56:00 | AAPL | Stock | 0.5832 | 0.5832 | 0.5825 | 0.5829 | 700616.0 |
| 2004-06-22 09:57:00 | AAPL | Stock | 0.5825 | 0.583 | 0.5823 | 0.5829 | 302400.0 |
| 2004-06-22 09:58:00 | AAPL | Stock | 0.5827 | 0.5843 | 0.5827 | 0.5843 | 606424.0 |
| 2004-06-22 09:59:00 | AAPL | Stock | 0.5843 | 0.5843 | 0.583 | 0.583 | 775600.0 |
| 2004-06-22 10:00:00 | AAPL | Stock | 0.583 | 0.5848 | 0.583 | 0.5848 | 3637200.0 |
| 2004-06-22 10:01:00 | AAPL | Stock | 0.5848 | 0.5848 | 0.5845 | 0.5846 | 1660624.0 |
| 2004-06-22 10:02:00 | AAPL | Stock | 0.5846 | 0.5857 | 0.5846 | 0.5854 | 2128056.0 |
| 2004-06-22 10:03:00 | AAPL | Stock | 0.5855 | 0.5855 | 0.5846 | 0.585 | 484064.0 |
| 2004-06-22 10:04:00 | AAPL | Stock | 0.5846 | 0.5848 | 0.5846 | 0.5848 | 534800.0 |
| 2004-06-22 10:05:00 | AAPL | Stock | 0.5848 | 0.5873 | 0.5848 | 0.5873 | 2889544.0 |
> showing 50 of 503,622 rows — these rows as CSV