PREVIEW / stock_1min / 2004-06-18
file: by_date/stock_1min/2004/2004-06-18.parquet size: 5.8 MB rows: 486,549 symbols: 1,466
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-18 08:02:00 | AAPL | Stock | 0.5839 | 0.5839 | 0.5839 | 0.5839 | 56000.0 |
| 2004-06-18 08:19:00 | AAPL | Stock | 0.5839 | 0.5839 | 0.5839 | 0.5839 | 39200.0 |
| 2004-06-18 08:31:00 | AAPL | Stock | 0.5813 | 0.5813 | 0.5813 | 0.5813 | 56000.0 |
| 2004-06-18 08:49:00 | AAPL | Stock | 0.5821 | 0.5821 | 0.5821 | 0.5821 | 112000.0 |
| 2004-06-18 08:51:00 | AAPL | Stock | 0.5821 | 0.5821 | 0.5821 | 0.5821 | 168000.0 |
| 2004-06-18 09:10:00 | AAPL | Stock | 0.5839 | 0.5839 | 0.5839 | 0.5839 | 56000.0 |
| 2004-06-18 09:19:00 | AAPL | Stock | 0.5856 | 0.5856 | 0.5856 | 0.5856 | 78400.0 |
| 2004-06-18 09:24:00 | AAPL | Stock | 0.5856 | 0.5856 | 0.5856 | 0.5856 | 78400.0 |
| 2004-06-18 09:29:00 | AAPL | Stock | 0.583 | 0.583 | 0.5809 | 0.5821 | 948640.0 |
| 2004-06-18 09:30:00 | AAPL | Stock | 0.5818 | 0.5839 | 0.5791 | 0.5821 | 9220344.0 |
| 2004-06-18 09:31:00 | AAPL | Stock | 0.582 | 0.582 | 0.5798 | 0.5813 | 3293080.0 |
| 2004-06-18 09:32:00 | AAPL | Stock | 0.5811 | 0.582 | 0.5804 | 0.5804 | 1461264.0 |
| 2004-06-18 09:33:00 | AAPL | Stock | 0.5805 | 0.583 | 0.5804 | 0.5818 | 1733144.0 |
| 2004-06-18 09:34:00 | AAPL | Stock | 0.5818 | 0.5821 | 0.5813 | 0.5813 | 1021608.0 |
| 2004-06-18 09:35:00 | AAPL | Stock | 0.5816 | 0.5827 | 0.5814 | 0.5821 | 1543080.0 |
| 2004-06-18 09:36:00 | AAPL | Stock | 0.5821 | 0.583 | 0.5821 | 0.5825 | 487592.0 |
| 2004-06-18 09:37:00 | AAPL | Stock | 0.5827 | 0.5836 | 0.582 | 0.5834 | 1039976.0 |
| 2004-06-18 09:38:00 | AAPL | Stock | 0.5836 | 0.5836 | 0.5829 | 0.5832 | 415632.0 |
| 2004-06-18 09:39:00 | AAPL | Stock | 0.5834 | 0.5834 | 0.5832 | 0.5832 | 543088.0 |
| 2004-06-18 09:40:00 | AAPL | Stock | 0.5832 | 0.5832 | 0.5818 | 0.582 | 498400.0 |
| 2004-06-18 09:41:00 | AAPL | Stock | 0.5818 | 0.5818 | 0.5814 | 0.5818 | 497056.0 |
| 2004-06-18 09:42:00 | AAPL | Stock | 0.582 | 0.5832 | 0.5818 | 0.5821 | 903504.0 |
| 2004-06-18 09:43:00 | AAPL | Stock | 0.5821 | 0.5823 | 0.5818 | 0.5823 | 461048.0 |
| 2004-06-18 09:44:00 | AAPL | Stock | 0.5825 | 0.5825 | 0.5821 | 0.5823 | 361088.0 |
| 2004-06-18 09:45:00 | AAPL | Stock | 0.5823 | 0.5823 | 0.5818 | 0.582 | 714336.0 |
| 2004-06-18 09:46:00 | AAPL | Stock | 0.582 | 0.5821 | 0.5813 | 0.5816 | 1097544.0 |
| 2004-06-18 09:47:00 | AAPL | Stock | 0.5814 | 0.5821 | 0.5814 | 0.5816 | 1609776.0 |
| 2004-06-18 09:48:00 | AAPL | Stock | 0.5818 | 0.582 | 0.5811 | 0.5814 | 943544.0 |
| 2004-06-18 09:49:00 | AAPL | Stock | 0.5814 | 0.5821 | 0.5814 | 0.582 | 1555288.0 |
| 2004-06-18 09:50:00 | AAPL | Stock | 0.582 | 0.5825 | 0.5816 | 0.5818 | 1159984.0 |
| 2004-06-18 09:51:00 | AAPL | Stock | 0.582 | 0.5832 | 0.5818 | 0.5827 | 872592.0 |
| 2004-06-18 09:52:00 | AAPL | Stock | 0.5827 | 0.583 | 0.5825 | 0.5825 | 625576.0 |
| 2004-06-18 09:53:00 | AAPL | Stock | 0.5827 | 0.5827 | 0.5825 | 0.5827 | 490840.0 |
| 2004-06-18 09:54:00 | AAPL | Stock | 0.5827 | 0.5827 | 0.5825 | 0.5827 | 336000.0 |
| 2004-06-18 09:55:00 | AAPL | Stock | 0.5825 | 0.5827 | 0.5818 | 0.5818 | 660016.0 |
| 2004-06-18 09:56:00 | AAPL | Stock | 0.5818 | 0.5818 | 0.5811 | 0.5814 | 907816.0 |
| 2004-06-18 09:57:00 | AAPL | Stock | 0.5814 | 0.5814 | 0.5805 | 0.5807 | 548464.0 |
| 2004-06-18 09:58:00 | AAPL | Stock | 0.5807 | 0.5816 | 0.5805 | 0.5814 | 465024.0 |
| 2004-06-18 09:59:00 | AAPL | Stock | 0.5809 | 0.5814 | 0.5805 | 0.5805 | 412160.0 |
| 2004-06-18 10:00:00 | AAPL | Stock | 0.5807 | 0.5818 | 0.5805 | 0.5809 | 1025696.0 |
| 2004-06-18 10:01:00 | AAPL | Stock | 0.5818 | 0.582 | 0.5816 | 0.5816 | 708008.0 |
| 2004-06-18 10:02:00 | AAPL | Stock | 0.5816 | 0.5821 | 0.5816 | 0.5818 | 344512.0 |
| 2004-06-18 10:03:00 | AAPL | Stock | 0.5819 | 0.5829 | 0.5819 | 0.5821 | 1162056.0 |
| 2004-06-18 10:04:00 | AAPL | Stock | 0.5823 | 0.583 | 0.5823 | 0.583 | 854224.0 |
| 2004-06-18 10:05:00 | AAPL | Stock | 0.5829 | 0.5846 | 0.5829 | 0.5846 | 1401624.0 |
| 2004-06-18 10:06:00 | AAPL | Stock | 0.5846 | 0.5888 | 0.5843 | 0.588 | 3975160.0 |
| 2004-06-18 10:07:00 | AAPL | Stock | 0.588 | 0.5886 | 0.5875 | 0.5882 | 1535352.0 |
| 2004-06-18 10:08:00 | AAPL | Stock | 0.5882 | 0.5882 | 0.5855 | 0.5855 | 1879528.0 |
| 2004-06-18 10:09:00 | AAPL | Stock | 0.5855 | 0.5882 | 0.5852 | 0.5861 | 1797544.0 |
| 2004-06-18 10:10:00 | AAPL | Stock | 0.5861 | 0.5861 | 0.5846 | 0.5846 | 1421840.0 |
> showing 50 of 486,549 rows — these rows as CSV