PREVIEW / stock_1min / 2009-03-09
file: by_date/stock_1min/2009/2009-03-09.parquet size: 12.6 MB rows: 972,647 symbols: 2,720
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 |
|---|---|---|---|---|---|---|---|
| 2009-03-09 07:18:00 | AAPL | Stock | 2.995 | 2.9954 | 2.995 | 2.995 | 28000.0 |
| 2009-03-09 07:26:00 | AAPL | Stock | 3.0 | 3.0 | 3.0 | 3.0 | 28000.0 |
| 2009-03-09 07:46:00 | AAPL | Stock | 3.0146 | 3.0146 | 3.0146 | 3.0146 | 2800.0 |
| 2009-03-09 07:55:00 | AAPL | Stock | 3.0 | 3.0 | 3.0 | 3.0 | 14000.0 |
| 2009-03-09 08:00:00 | AAPL | Stock | 3.0 | 3.015 | 3.0 | 3.015 | 27944.0 |
| 2009-03-09 08:01:00 | AAPL | Stock | 3.0 | 3.0143 | 3.0 | 3.0143 | 14000.0 |
| 2009-03-09 08:02:00 | AAPL | Stock | 3.0143 | 3.0143 | 3.0018 | 3.0018 | 5600.0 |
| 2009-03-09 08:03:00 | AAPL | Stock | 3.0025 | 3.0025 | 3.0025 | 3.0025 | 14000.0 |
| 2009-03-09 08:05:00 | AAPL | Stock | 3.0143 | 3.0143 | 3.0143 | 3.0143 | 2800.0 |
| 2009-03-09 08:06:00 | AAPL | Stock | 3.0143 | 3.0143 | 3.01 | 3.01 | 11200.0 |
| 2009-03-09 08:08:00 | AAPL | Stock | 3.01 | 3.01 | 3.01 | 3.01 | 8400.0 |
| 2009-03-09 08:10:00 | AAPL | Stock | 3.0146 | 3.0146 | 3.0146 | 3.0146 | 5600.0 |
| 2009-03-09 08:12:00 | AAPL | Stock | 3.0121 | 3.0121 | 3.0107 | 3.0107 | 13160.0 |
| 2009-03-09 08:13:00 | AAPL | Stock | 3.01 | 3.01 | 3.0096 | 3.0096 | 7560.0 |
| 2009-03-09 08:14:00 | AAPL | Stock | 3.0096 | 3.0096 | 3.0096 | 3.0096 | 2800.0 |
| 2009-03-09 08:16:00 | AAPL | Stock | 3.0089 | 3.0089 | 3.0089 | 3.0089 | 14000.0 |
| 2009-03-09 08:21:00 | AAPL | Stock | 3.0107 | 3.0107 | 3.0107 | 3.0107 | 5600.0 |
| 2009-03-09 08:22:00 | AAPL | Stock | 3.0125 | 3.0125 | 3.0125 | 3.0125 | 5600.0 |
| 2009-03-09 08:24:00 | AAPL | Stock | 3.0125 | 3.0125 | 3.0125 | 3.0125 | 8540.0 |
| 2009-03-09 08:29:00 | AAPL | Stock | 3.0089 | 3.0089 | 3.0089 | 3.0089 | 2800.0 |
| 2009-03-09 08:30:00 | AAPL | Stock | 3.0054 | 3.0093 | 3.0054 | 3.0093 | 11200.0 |
| 2009-03-09 08:33:00 | AAPL | Stock | 3.0054 | 3.0054 | 3.0054 | 3.0054 | 2800.0 |
| 2009-03-09 08:38:00 | AAPL | Stock | 3.0054 | 3.0079 | 3.0054 | 3.0079 | 14000.0 |
| 2009-03-09 08:39:00 | AAPL | Stock | 3.0071 | 3.0071 | 3.0071 | 3.0071 | 9800.0 |
| 2009-03-09 08:41:00 | AAPL | Stock | 3.0082 | 3.0089 | 3.0082 | 3.0089 | 8400.0 |
| 2009-03-09 08:42:00 | AAPL | Stock | 3.0089 | 3.0136 | 3.0089 | 3.0129 | 11200.0 |
| 2009-03-09 08:43:00 | AAPL | Stock | 3.0143 | 3.0143 | 3.0143 | 3.0143 | 5600.0 |
| 2009-03-09 08:47:00 | AAPL | Stock | 3.0136 | 3.0136 | 3.0104 | 3.0107 | 22400.0 |
| 2009-03-09 08:51:00 | AAPL | Stock | 3.0118 | 3.0118 | 3.0118 | 3.0118 | 5600.0 |
| 2009-03-09 08:52:00 | AAPL | Stock | 3.0143 | 3.0143 | 3.0143 | 3.0143 | 6272.0 |
| 2009-03-09 08:53:00 | AAPL | Stock | 3.0111 | 3.0111 | 3.0111 | 3.0111 | 5600.0 |
| 2009-03-09 08:55:00 | AAPL | Stock | 3.0114 | 3.0114 | 3.0111 | 3.0111 | 8400.0 |
| 2009-03-09 08:58:00 | AAPL | Stock | 3.0118 | 3.0118 | 3.0118 | 3.0118 | 2800.0 |
| 2009-03-09 09:03:00 | AAPL | Stock | 3.0129 | 3.0129 | 3.0129 | 3.0129 | 2800.0 |
| 2009-03-09 09:07:00 | AAPL | Stock | 3.0157 | 3.0157 | 3.0157 | 3.0157 | 2800.0 |
| 2009-03-09 09:08:00 | AAPL | Stock | 3.0143 | 3.015 | 3.0143 | 3.015 | 14000.0 |
| 2009-03-09 09:09:00 | AAPL | Stock | 3.0171 | 3.0193 | 3.0171 | 3.0179 | 23800.0 |
| 2009-03-09 09:10:00 | AAPL | Stock | 3.0179 | 3.0182 | 3.0168 | 3.0168 | 39200.0 |
| 2009-03-09 09:11:00 | AAPL | Stock | 3.0168 | 3.0171 | 3.015 | 3.015 | 16800.0 |
| 2009-03-09 09:12:00 | AAPL | Stock | 3.0143 | 3.0161 | 3.0143 | 3.0161 | 25200.0 |
| 2009-03-09 09:13:00 | AAPL | Stock | 3.0161 | 3.0161 | 3.0143 | 3.0143 | 159404.0 |
| 2009-03-09 09:14:00 | AAPL | Stock | 3.0125 | 3.0125 | 3.0118 | 3.0118 | 19600.0 |
| 2009-03-09 09:15:00 | AAPL | Stock | 3.0118 | 3.0118 | 3.0114 | 3.0118 | 14000.0 |
| 2009-03-09 09:16:00 | AAPL | Stock | 3.0114 | 3.0118 | 3.0114 | 3.0118 | 8400.0 |
| 2009-03-09 09:17:00 | AAPL | Stock | 3.0132 | 3.0143 | 3.0129 | 3.0143 | 69916.0 |
| 2009-03-09 09:18:00 | AAPL | Stock | 3.0143 | 3.0143 | 3.0143 | 3.0143 | 5600.0 |
| 2009-03-09 09:21:00 | AAPL | Stock | 3.015 | 3.015 | 3.0143 | 3.015 | 14000.0 |
| 2009-03-09 09:22:00 | AAPL | Stock | 3.0143 | 3.015 | 3.0143 | 3.015 | 5600.0 |
| 2009-03-09 09:23:00 | AAPL | Stock | 3.0143 | 3.0143 | 3.0143 | 3.0143 | 30800.0 |
| 2009-03-09 09:24:00 | AAPL | Stock | 3.0143 | 3.0143 | 3.0143 | 3.0143 | 2800.0 |
> showing 50 of 972,647 rows — these rows as CSV