PREVIEW / stock_5min / 2009-03-09
file: by_date/stock_5min/2009/2009-03-09.parquet size: 4.4 MB rows: 311,530 symbols: 3,340
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:15:00 | AAPL | Stock | 2.995 | 2.9954 | 2.995 | 2.995 | 28000.0 |
| 2009-03-09 07:25:00 | AAPL | Stock | 3.0 | 3.0 | 3.0 | 3.0 | 28000.0 |
| 2009-03-09 07:45: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.0025 | 61544.0 |
| 2009-03-09 08:05:00 | AAPL | Stock | 3.0143 | 3.0143 | 3.01 | 3.01 | 22400.0 |
| 2009-03-09 08:10:00 | AAPL | Stock | 3.0146 | 3.0146 | 3.0096 | 3.0096 | 29120.0 |
| 2009-03-09 08:15:00 | AAPL | Stock | 3.0089 | 3.0089 | 3.0089 | 3.0089 | 14000.0 |
| 2009-03-09 08:20:00 | AAPL | Stock | 3.0107 | 3.0125 | 3.0107 | 3.0125 | 19740.0 |
| 2009-03-09 08:25: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.0054 | 14000.0 |
| 2009-03-09 08:35:00 | AAPL | Stock | 3.0054 | 3.0079 | 3.0054 | 3.0071 | 23800.0 |
| 2009-03-09 08:40:00 | AAPL | Stock | 3.0082 | 3.0143 | 3.0082 | 3.0143 | 25200.0 |
| 2009-03-09 08:45:00 | AAPL | Stock | 3.0136 | 3.0136 | 3.0104 | 3.0107 | 22400.0 |
| 2009-03-09 08:50:00 | AAPL | Stock | 3.0118 | 3.0143 | 3.0111 | 3.0111 | 17472.0 |
| 2009-03-09 08:55:00 | AAPL | Stock | 3.0114 | 3.0118 | 3.0111 | 3.0118 | 11200.0 |
| 2009-03-09 09:00:00 | AAPL | Stock | 3.0129 | 3.0129 | 3.0129 | 3.0129 | 2800.0 |
| 2009-03-09 09:05:00 | AAPL | Stock | 3.0157 | 3.0193 | 3.0143 | 3.0179 | 40600.0 |
| 2009-03-09 09:10:00 | AAPL | Stock | 3.0179 | 3.0182 | 3.0118 | 3.0118 | 260204.0 |
| 2009-03-09 09:15:00 | AAPL | Stock | 3.0118 | 3.0143 | 3.0114 | 3.0143 | 97916.0 |
| 2009-03-09 09:20:00 | AAPL | Stock | 3.015 | 3.015 | 3.0143 | 3.0143 | 53200.0 |
| 2009-03-09 09:25:00 | AAPL | Stock | 3.0161 | 3.0179 | 3.0036 | 3.0061 | 929040.0 |
| 2009-03-09 09:30:00 | AAPL | Stock | 3.0064 | 3.0518 | 3.0 | 3.0514 | 12594652.0 |
| 2009-03-09 09:35:00 | AAPL | Stock | 3.0504 | 3.1 | 3.0482 | 3.1 | 18111604.0 |
| 2009-03-09 09:40:00 | AAPL | Stock | 3.1 | 3.1064 | 3.0725 | 3.0771 | 19264672.0 |
| 2009-03-09 09:45:00 | AAPL | Stock | 3.0768 | 3.0982 | 3.0732 | 3.0961 | 13357820.0 |
| 2009-03-09 09:50:00 | AAPL | Stock | 3.0961 | 3.1071 | 3.0907 | 3.0957 | 14276640.0 |
| 2009-03-09 09:55:00 | AAPL | Stock | 3.0954 | 3.0986 | 3.0729 | 3.0793 | 8657768.0 |
| 2009-03-09 10:00:00 | AAPL | Stock | 3.079 | 3.1014 | 3.0779 | 3.0968 | 8235724.0 |
| 2009-03-09 10:05:00 | AAPL | Stock | 3.0975 | 3.1093 | 3.0821 | 3.0836 | 13272504.0 |
| 2009-03-09 10:10:00 | AAPL | Stock | 3.0843 | 3.125 | 3.08 | 3.1175 | 14954940.0 |
| 2009-03-09 10:15:00 | AAPL | Stock | 3.1179 | 3.1286 | 3.1111 | 3.1136 | 11611152.0 |
| 2009-03-09 10:20:00 | AAPL | Stock | 3.1132 | 3.1175 | 3.09 | 3.0946 | 8475796.0 |
| 2009-03-09 10:25:00 | AAPL | Stock | 3.0939 | 3.1 | 3.0779 | 3.0779 | 8924636.0 |
| 2009-03-09 10:30:00 | AAPL | Stock | 3.0782 | 3.0986 | 3.0714 | 3.0732 | 10735872.0 |
| 2009-03-09 10:35:00 | AAPL | Stock | 3.0732 | 3.0743 | 3.0557 | 3.0671 | 11821180.0 |
| 2009-03-09 10:40:00 | AAPL | Stock | 3.0664 | 3.0825 | 3.0546 | 3.0796 | 11812584.0 |
| 2009-03-09 10:45:00 | AAPL | Stock | 3.0796 | 3.0836 | 3.0429 | 3.0436 | 10557596.0 |
| 2009-03-09 10:50:00 | AAPL | Stock | 3.0436 | 3.0521 | 3.0339 | 3.0432 | 9782528.0 |
| 2009-03-09 10:55:00 | AAPL | Stock | 3.0432 | 3.0432 | 3.0121 | 3.0175 | 13885340.0 |
| 2009-03-09 11:00:00 | AAPL | Stock | 3.0179 | 3.0364 | 3.0171 | 3.0275 | 15152088.0 |
| 2009-03-09 11:05:00 | AAPL | Stock | 3.0279 | 3.0339 | 3.0089 | 3.0171 | 13189624.0 |
| 2009-03-09 11:10:00 | AAPL | Stock | 3.0165 | 3.0282 | 3.0125 | 3.0279 | 8090936.0 |
| 2009-03-09 11:15:00 | AAPL | Stock | 3.0282 | 3.0332 | 3.0214 | 3.025 | 4256588.0 |
| 2009-03-09 11:20:00 | AAPL | Stock | 3.0239 | 3.0357 | 3.0164 | 3.0321 | 8061844.0 |
| 2009-03-09 11:25:00 | AAPL | Stock | 3.0325 | 3.0457 | 3.0321 | 3.0361 | 6236412.0 |
| 2009-03-09 11:30:00 | AAPL | Stock | 3.0361 | 3.0443 | 3.0214 | 3.0289 | 8329524.0 |
| 2009-03-09 11:35:00 | AAPL | Stock | 3.0289 | 3.0411 | 3.0279 | 3.0321 | 4940180.0 |
| 2009-03-09 11:40:00 | AAPL | Stock | 3.0318 | 3.035 | 3.0246 | 3.0314 | 4214280.0 |
| 2009-03-09 11:45:00 | AAPL | Stock | 3.0307 | 3.0439 | 3.0304 | 3.0371 | 4985232.0 |
> showing 50 of 311,530 rows — these rows as CSV