PREVIEW / stock_1min / 2004-04-20
file: by_date/stock_1min/2004/2004-04-20.parquet size: 5.9 MB rows: 491,326 symbols: 1,440
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-04-20 08:01:00 | AAPL | Stock | 0.5082 | 0.5082 | 0.5082 | 0.5082 | 11200.0 |
| 2004-04-20 08:12:00 | AAPL | Stock | 0.5082 | 0.5082 | 0.5082 | 0.5082 | 11200.0 |
| 2004-04-20 08:18:00 | AAPL | Stock | 0.5063 | 0.5063 | 0.5063 | 0.5063 | 25200.0 |
| 2004-04-20 08:34:00 | AAPL | Stock | 0.508 | 0.508 | 0.508 | 0.508 | 112000.0 |
| 2004-04-20 08:37:00 | AAPL | Stock | 0.5071 | 0.5071 | 0.5071 | 0.5071 | 56000.0 |
| 2004-04-20 08:38:00 | AAPL | Stock | 0.5064 | 0.5064 | 0.5064 | 0.5064 | 56000.0 |
| 2004-04-20 08:40:00 | AAPL | Stock | 0.5071 | 0.5071 | 0.5071 | 0.5071 | 56000.0 |
| 2004-04-20 08:46:00 | AAPL | Stock | 0.5073 | 0.5073 | 0.5073 | 0.5073 | 50400.0 |
| 2004-04-20 08:48:00 | AAPL | Stock | 0.5075 | 0.5075 | 0.5075 | 0.5075 | 10080.0 |
| 2004-04-20 09:01:00 | AAPL | Stock | 0.5063 | 0.5063 | 0.5063 | 0.5063 | 38248.0 |
| 2004-04-20 09:08:00 | AAPL | Stock | 0.5063 | 0.5063 | 0.5063 | 0.5063 | 106400.0 |
| 2004-04-20 09:09:00 | AAPL | Stock | 0.5046 | 0.5046 | 0.5046 | 0.5046 | 112000.0 |
| 2004-04-20 09:10:00 | AAPL | Stock | 0.5063 | 0.5063 | 0.5063 | 0.5063 | 28000.0 |
| 2004-04-20 09:14:00 | AAPL | Stock | 0.5088 | 0.5088 | 0.5088 | 0.5088 | 5600.0 |
| 2004-04-20 09:22:00 | AAPL | Stock | 0.5063 | 0.5063 | 0.5063 | 0.5063 | 13888.0 |
| 2004-04-20 09:23:00 | AAPL | Stock | 0.5036 | 0.5036 | 0.5032 | 0.5032 | 134400.0 |
| 2004-04-20 09:29:00 | AAPL | Stock | 0.5063 | 0.5063 | 0.5029 | 0.5038 | 200480.0 |
| 2004-04-20 09:30:00 | AAPL | Stock | 0.5055 | 0.5055 | 0.5038 | 0.5045 | 4802392.0 |
| 2004-04-20 09:31:00 | AAPL | Stock | 0.5045 | 0.505 | 0.5041 | 0.5045 | 975632.0 |
| 2004-04-20 09:32:00 | AAPL | Stock | 0.5046 | 0.5052 | 0.5046 | 0.5052 | 804496.0 |
| 2004-04-20 09:33:00 | AAPL | Stock | 0.5052 | 0.5055 | 0.505 | 0.5052 | 666400.0 |
| 2004-04-20 09:34:00 | AAPL | Stock | 0.5052 | 0.5055 | 0.505 | 0.5052 | 1656872.0 |
| 2004-04-20 09:35:00 | AAPL | Stock | 0.5052 | 0.5063 | 0.5052 | 0.5063 | 2463664.0 |
| 2004-04-20 09:36:00 | AAPL | Stock | 0.5063 | 0.5063 | 0.5061 | 0.5061 | 764680.0 |
| 2004-04-20 09:37:00 | AAPL | Stock | 0.5063 | 0.5063 | 0.5061 | 0.5063 | 1128400.0 |
| 2004-04-20 09:38:00 | AAPL | Stock | 0.5061 | 0.5063 | 0.5059 | 0.5063 | 1617616.0 |
| 2004-04-20 09:39:00 | AAPL | Stock | 0.5061 | 0.5073 | 0.5061 | 0.5066 | 5355392.0 |
| 2004-04-20 09:40:00 | AAPL | Stock | 0.5063 | 0.5068 | 0.5063 | 0.5064 | 431200.0 |
| 2004-04-20 09:41:00 | AAPL | Stock | 0.5063 | 0.5064 | 0.5059 | 0.5063 | 237720.0 |
| 2004-04-20 09:42:00 | AAPL | Stock | 0.5063 | 0.5063 | 0.505 | 0.5052 | 1273216.0 |
| 2004-04-20 09:43:00 | AAPL | Stock | 0.505 | 0.5052 | 0.505 | 0.505 | 889952.0 |
| 2004-04-20 09:44:00 | AAPL | Stock | 0.5052 | 0.5061 | 0.505 | 0.5052 | 1261400.0 |
| 2004-04-20 09:45:00 | AAPL | Stock | 0.5052 | 0.5052 | 0.505 | 0.5052 | 398440.0 |
| 2004-04-20 09:46:00 | AAPL | Stock | 0.5054 | 0.5055 | 0.505 | 0.5052 | 381640.0 |
| 2004-04-20 09:47:00 | AAPL | Stock | 0.5052 | 0.5055 | 0.5052 | 0.5054 | 680400.0 |
| 2004-04-20 09:48:00 | AAPL | Stock | 0.5054 | 0.5055 | 0.5054 | 0.5055 | 775600.0 |
| 2004-04-20 09:49:00 | AAPL | Stock | 0.5054 | 0.5059 | 0.5054 | 0.5058 | 799400.0 |
| 2004-04-20 09:50:00 | AAPL | Stock | 0.5059 | 0.5064 | 0.5057 | 0.5063 | 3032400.0 |
| 2004-04-20 09:51:00 | AAPL | Stock | 0.5063 | 0.5063 | 0.5061 | 0.5063 | 824880.0 |
| 2004-04-20 09:52:00 | AAPL | Stock | 0.5063 | 0.5063 | 0.5061 | 0.5061 | 688800.0 |
| 2004-04-20 09:53:00 | AAPL | Stock | 0.5063 | 0.5063 | 0.5061 | 0.5063 | 821856.0 |
| 2004-04-20 09:54:00 | AAPL | Stock | 0.5063 | 0.5063 | 0.5061 | 0.5063 | 1109976.0 |
| 2004-04-20 09:55:00 | AAPL | Stock | 0.5061 | 0.5063 | 0.5061 | 0.5063 | 3360392.0 |
| 2004-04-20 09:56:00 | AAPL | Stock | 0.5063 | 0.5063 | 0.5055 | 0.5059 | 1735720.0 |
| 2004-04-20 09:57:00 | AAPL | Stock | 0.5057 | 0.5061 | 0.5052 | 0.5055 | 1030400.0 |
| 2004-04-20 09:58:00 | AAPL | Stock | 0.5055 | 0.5063 | 0.5055 | 0.5061 | 687456.0 |
| 2004-04-20 09:59:00 | AAPL | Stock | 0.5061 | 0.5063 | 0.5061 | 0.5061 | 592256.0 |
| 2004-04-20 10:00:00 | AAPL | Stock | 0.5061 | 0.5063 | 0.5059 | 0.5059 | 2011240.0 |
| 2004-04-20 10:01:00 | AAPL | Stock | 0.5059 | 0.5061 | 0.5055 | 0.5055 | 1517600.0 |
| 2004-04-20 10:02:00 | AAPL | Stock | 0.5059 | 0.5059 | 0.505 | 0.5052 | 756000.0 |
> showing 50 of 491,326 rows — these rows as CSV