PREVIEW / stock_5min / 2009-05-07
file: by_date/stock_5min/2009/2009-05-07.parquet size: 4.9 MB rows: 331,540 symbols: 3,336
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-05-07 04:50:00 | AAPL | Stock | 4.7429 | 4.7429 | 4.7429 | 4.7429 | 2800.0 |
| 2009-05-07 06:15:00 | AAPL | Stock | 4.7607 | 4.7607 | 4.7607 | 4.7607 | 11200.0 |
| 2009-05-07 06:40:00 | AAPL | Stock | 4.7571 | 4.7571 | 4.7571 | 4.7571 | 5600.0 |
| 2009-05-07 07:00:00 | AAPL | Stock | 4.7586 | 4.7586 | 4.7586 | 4.7586 | 2800.0 |
| 2009-05-07 07:05:00 | AAPL | Stock | 4.765 | 4.765 | 4.7632 | 4.7632 | 28000.0 |
| 2009-05-07 07:50:00 | AAPL | Stock | 4.7611 | 4.7611 | 4.7611 | 4.7611 | 2800.0 |
| 2009-05-07 08:00:00 | AAPL | Stock | 4.7593 | 4.7607 | 4.7414 | 4.75 | 148232.0 |
| 2009-05-07 08:05:00 | AAPL | Stock | 4.7557 | 4.7586 | 4.7557 | 4.7579 | 55300.0 |
| 2009-05-07 08:10:00 | AAPL | Stock | 4.7586 | 4.7589 | 4.7586 | 4.7589 | 18620.0 |
| 2009-05-07 08:15:00 | AAPL | Stock | 4.7564 | 4.7564 | 4.7564 | 4.7564 | 15400.0 |
| 2009-05-07 08:20:00 | AAPL | Stock | 4.7589 | 4.7589 | 4.7564 | 4.7564 | 76328.0 |
| 2009-05-07 08:25:00 | AAPL | Stock | 4.7564 | 4.7564 | 4.7507 | 4.7546 | 47320.0 |
| 2009-05-07 08:30:00 | AAPL | Stock | 4.75 | 4.7536 | 4.75 | 4.75 | 125300.0 |
| 2009-05-07 08:35:00 | AAPL | Stock | 4.7457 | 4.75 | 4.7439 | 4.7464 | 188412.0 |
| 2009-05-07 08:40:00 | AAPL | Stock | 4.7464 | 4.7464 | 4.7414 | 4.7443 | 156324.0 |
| 2009-05-07 08:45:00 | AAPL | Stock | 4.7443 | 4.7464 | 4.7443 | 4.7464 | 48188.0 |
| 2009-05-07 08:50:00 | AAPL | Stock | 4.7461 | 4.7461 | 4.7461 | 4.7461 | 2800.0 |
| 2009-05-07 08:55:00 | AAPL | Stock | 4.7457 | 4.7457 | 4.7457 | 4.7457 | 29456.0 |
| 2009-05-07 09:00:00 | AAPL | Stock | 4.7457 | 4.7457 | 4.7429 | 4.7429 | 8400.0 |
| 2009-05-07 09:05:00 | AAPL | Stock | 4.7432 | 4.7454 | 4.7421 | 4.7432 | 132720.0 |
| 2009-05-07 09:10:00 | AAPL | Stock | 4.7439 | 4.7457 | 4.7439 | 4.7454 | 118972.0 |
| 2009-05-07 09:15:00 | AAPL | Stock | 4.7446 | 4.745 | 4.7414 | 4.7414 | 39200.0 |
| 2009-05-07 09:20:00 | AAPL | Stock | 4.7411 | 4.7429 | 4.7282 | 4.7357 | 182560.0 |
| 2009-05-07 09:25:00 | AAPL | Stock | 4.7357 | 4.7361 | 4.7146 | 4.7264 | 291340.0 |
| 2009-05-07 09:30:00 | AAPL | Stock | 4.7261 | 4.7282 | 4.7021 | 4.7071 | 14278740.0 |
| 2009-05-07 09:35:00 | AAPL | Stock | 4.7079 | 4.7086 | 4.6654 | 4.6814 | 14111720.0 |
| 2009-05-07 09:40:00 | AAPL | Stock | 4.6796 | 4.6846 | 4.6629 | 4.6746 | 9397668.0 |
| 2009-05-07 09:45:00 | AAPL | Stock | 4.6743 | 4.6804 | 4.6536 | 4.6561 | 15617868.0 |
| 2009-05-07 09:50:00 | AAPL | Stock | 4.6564 | 4.6624 | 4.6271 | 4.6293 | 17021620.0 |
| 2009-05-07 09:55:00 | AAPL | Stock | 4.6304 | 4.6429 | 4.6175 | 4.6264 | 13352612.0 |
| 2009-05-07 10:00:00 | AAPL | Stock | 4.6239 | 4.63 | 4.6079 | 4.6125 | 12353236.0 |
| 2009-05-07 10:05:00 | AAPL | Stock | 4.6125 | 4.62 | 4.5893 | 4.5907 | 21101332.0 |
| 2009-05-07 10:10:00 | AAPL | Stock | 4.59 | 4.6068 | 4.5893 | 4.6004 | 9356900.0 |
| 2009-05-07 10:15:00 | AAPL | Stock | 4.6005 | 4.615 | 4.5975 | 4.6116 | 8311912.0 |
| 2009-05-07 10:20:00 | AAPL | Stock | 4.6104 | 4.6161 | 4.5896 | 4.59 | 8146068.0 |
| 2009-05-07 10:25:00 | AAPL | Stock | 4.5904 | 4.5954 | 4.5804 | 4.5893 | 8139656.0 |
| 2009-05-07 10:30:00 | AAPL | Stock | 4.59 | 4.6071 | 4.5868 | 4.6039 | 7868392.0 |
| 2009-05-07 10:35:00 | AAPL | Stock | 4.6032 | 4.61 | 4.5971 | 4.6082 | 6110916.0 |
| 2009-05-07 10:40:00 | AAPL | Stock | 4.6061 | 4.6086 | 4.5946 | 4.6075 | 6254136.0 |
| 2009-05-07 10:45:00 | AAPL | Stock | 4.6071 | 4.615 | 4.605 | 4.6136 | 5662748.0 |
| 2009-05-07 10:50:00 | AAPL | Stock | 4.6143 | 4.6182 | 4.6071 | 4.6161 | 4504220.0 |
| 2009-05-07 10:55:00 | AAPL | Stock | 4.6161 | 4.6268 | 4.6129 | 4.6139 | 5516084.0 |
| 2009-05-07 11:00:00 | AAPL | Stock | 4.6157 | 4.6243 | 4.6096 | 4.6107 | 6305264.0 |
| 2009-05-07 11:05:00 | AAPL | Stock | 4.6107 | 4.6121 | 4.5879 | 4.5893 | 6135640.0 |
| 2009-05-07 11:10:00 | AAPL | Stock | 4.5904 | 4.6 | 4.5893 | 4.5911 | 3035816.0 |
| 2009-05-07 11:15:00 | AAPL | Stock | 4.5914 | 4.5946 | 4.5857 | 4.5921 | 3543820.0 |
| 2009-05-07 11:20:00 | AAPL | Stock | 4.5911 | 4.6029 | 4.5889 | 4.5954 | 4043900.0 |
| 2009-05-07 11:25:00 | AAPL | Stock | 4.5953 | 4.6032 | 4.5893 | 4.6021 | 3879372.0 |
| 2009-05-07 11:30:00 | AAPL | Stock | 4.6029 | 4.6096 | 4.6 | 4.6007 | 3701880.0 |
| 2009-05-07 11:35:00 | AAPL | Stock | 4.6 | 4.6139 | 4.5971 | 4.6107 | 3954412.0 |
> showing 50 of 331,540 rows — these rows as CSV