PREVIEW / stock_1min / 2005-04-11
file: by_date/stock_1min/2005/2005-04-11.parquet size: 6.4 MB rows: 535,646 symbols: 1,608
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-04-11 07:34:00 | AAPL | Stock | 1.5661 | 1.5661 | 1.5643 | 1.5643 | 84000.0 |
| 2005-04-11 07:55:00 | AAPL | Stock | 1.5661 | 1.5661 | 1.5661 | 1.5661 | 2800.0 |
| 2005-04-11 08:00:00 | AAPL | Stock | 1.5707 | 1.5729 | 1.5661 | 1.5729 | 12796.0 |
| 2005-04-11 08:01:00 | AAPL | Stock | 1.5729 | 1.5818 | 1.5714 | 1.5818 | 387100.0 |
| 2005-04-11 08:02:00 | AAPL | Stock | 1.5775 | 1.5871 | 1.5643 | 1.5782 | 366800.0 |
| 2005-04-11 08:03:00 | AAPL | Stock | 1.5782 | 1.5804 | 1.5782 | 1.5782 | 129080.0 |
| 2005-04-11 08:04:00 | AAPL | Stock | 1.5779 | 1.5782 | 1.5775 | 1.5775 | 71680.0 |
| 2005-04-11 08:05:00 | AAPL | Stock | 1.5786 | 1.5789 | 1.5761 | 1.5761 | 208600.0 |
| 2005-04-11 08:06:00 | AAPL | Stock | 1.5761 | 1.5804 | 1.5757 | 1.5757 | 91000.0 |
| 2005-04-11 08:07:00 | AAPL | Stock | 1.5757 | 1.5761 | 1.575 | 1.575 | 89600.0 |
| 2005-04-11 08:08:00 | AAPL | Stock | 1.5746 | 1.5768 | 1.5746 | 1.5768 | 72100.0 |
| 2005-04-11 08:09:00 | AAPL | Stock | 1.5768 | 1.5768 | 1.575 | 1.575 | 92820.0 |
| 2005-04-11 08:10:00 | AAPL | Stock | 1.5736 | 1.5736 | 1.5736 | 1.5736 | 11200.0 |
| 2005-04-11 08:11:00 | AAPL | Stock | 1.5746 | 1.575 | 1.5746 | 1.575 | 62300.0 |
| 2005-04-11 08:12:00 | AAPL | Stock | 1.5768 | 1.5804 | 1.5768 | 1.5804 | 262780.0 |
| 2005-04-11 08:13:00 | AAPL | Stock | 1.5807 | 1.5811 | 1.5796 | 1.5796 | 57400.0 |
| 2005-04-11 08:14:00 | AAPL | Stock | 1.5782 | 1.5796 | 1.5782 | 1.5796 | 33600.0 |
| 2005-04-11 08:15:00 | AAPL | Stock | 1.5782 | 1.5782 | 1.5771 | 1.5775 | 61600.0 |
| 2005-04-11 08:16:00 | AAPL | Stock | 1.5771 | 1.5775 | 1.5754 | 1.5775 | 58800.0 |
| 2005-04-11 08:17:00 | AAPL | Stock | 1.5775 | 1.5786 | 1.5775 | 1.5786 | 114380.0 |
| 2005-04-11 08:19:00 | AAPL | Stock | 1.5782 | 1.5782 | 1.5782 | 1.5782 | 3500.0 |
| 2005-04-11 08:20:00 | AAPL | Stock | 1.5775 | 1.5775 | 1.5736 | 1.5736 | 40852.0 |
| 2005-04-11 08:21:00 | AAPL | Stock | 1.5746 | 1.575 | 1.5736 | 1.5736 | 45388.0 |
| 2005-04-11 08:27:00 | AAPL | Stock | 1.5761 | 1.5779 | 1.5761 | 1.5779 | 19600.0 |
| 2005-04-11 08:28:00 | AAPL | Stock | 1.5786 | 1.5818 | 1.5786 | 1.5818 | 389648.0 |
| 2005-04-11 08:29:00 | AAPL | Stock | 1.5818 | 1.5839 | 1.5818 | 1.5821 | 172200.0 |
| 2005-04-11 08:30:00 | AAPL | Stock | 1.5821 | 1.5821 | 1.5814 | 1.5814 | 102760.0 |
| 2005-04-11 08:31:00 | AAPL | Stock | 1.5821 | 1.5821 | 1.5811 | 1.5821 | 489440.0 |
| 2005-04-11 08:32:00 | AAPL | Stock | 1.5821 | 1.5821 | 1.5821 | 1.5821 | 9800.0 |
| 2005-04-11 08:33:00 | AAPL | Stock | 1.5818 | 1.5818 | 1.5814 | 1.5814 | 100380.0 |
| 2005-04-11 08:34:00 | AAPL | Stock | 1.5814 | 1.5821 | 1.5814 | 1.5818 | 50820.0 |
| 2005-04-11 08:35:00 | AAPL | Stock | 1.5818 | 1.5818 | 1.5814 | 1.5818 | 282800.0 |
| 2005-04-11 08:36:00 | AAPL | Stock | 1.5814 | 1.5821 | 1.5814 | 1.5814 | 299600.0 |
| 2005-04-11 08:37:00 | AAPL | Stock | 1.5807 | 1.5814 | 1.5804 | 1.5804 | 168000.0 |
| 2005-04-11 08:38:00 | AAPL | Stock | 1.5804 | 1.5818 | 1.5804 | 1.5807 | 39200.0 |
| 2005-04-11 08:39:00 | AAPL | Stock | 1.5821 | 1.5821 | 1.5821 | 1.5821 | 113400.0 |
| 2005-04-11 08:40:00 | AAPL | Stock | 1.5821 | 1.5821 | 1.5804 | 1.5804 | 89600.0 |
| 2005-04-11 08:41:00 | AAPL | Stock | 1.58 | 1.5821 | 1.58 | 1.5821 | 132104.0 |
| 2005-04-11 08:43:00 | AAPL | Stock | 1.5814 | 1.5814 | 1.5804 | 1.5804 | 81200.0 |
| 2005-04-11 08:45:00 | AAPL | Stock | 1.5786 | 1.5793 | 1.5775 | 1.5775 | 50400.0 |
| 2005-04-11 08:46:00 | AAPL | Stock | 1.5771 | 1.5771 | 1.575 | 1.575 | 16800.0 |
| 2005-04-11 08:47:00 | AAPL | Stock | 1.575 | 1.5754 | 1.575 | 1.5754 | 10808.0 |
| 2005-04-11 08:48:00 | AAPL | Stock | 1.5754 | 1.5761 | 1.575 | 1.5754 | 85064.0 |
| 2005-04-11 08:49:00 | AAPL | Stock | 1.5761 | 1.5761 | 1.5761 | 1.5761 | 8400.0 |
| 2005-04-11 08:50:00 | AAPL | Stock | 1.5761 | 1.5761 | 1.5718 | 1.5746 | 268408.0 |
| 2005-04-11 08:51:00 | AAPL | Stock | 1.5746 | 1.575 | 1.5746 | 1.5746 | 109592.0 |
| 2005-04-11 08:52:00 | AAPL | Stock | 1.5746 | 1.5746 | 1.5746 | 1.5746 | 57400.0 |
| 2005-04-11 08:54:00 | AAPL | Stock | 1.5746 | 1.575 | 1.5746 | 1.5746 | 44408.0 |
| 2005-04-11 08:55:00 | AAPL | Stock | 1.5746 | 1.5761 | 1.5746 | 1.5761 | 23408.0 |
| 2005-04-11 08:56:00 | AAPL | Stock | 1.5764 | 1.5782 | 1.5764 | 1.5782 | 14000.0 |
> showing 50 of 535,646 rows — these rows as CSV