PREVIEW / stock_5min / 2010-03-05
file: by_date/stock_5min/2010/2010-03-05.parquet size: 4.8 MB rows: 331,285 symbols: 3,458
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 |
|---|---|---|---|---|---|---|---|
| 2010-03-05 05:25:00 | AAPL | Stock | 7.5871 | 7.5871 | 7.5871 | 7.5871 | 2800.0 |
| 2010-03-05 05:35:00 | AAPL | Stock | 7.59 | 7.5925 | 7.59 | 7.5925 | 16800.0 |
| 2010-03-05 05:55:00 | AAPL | Stock | 7.5993 | 7.6 | 7.5993 | 7.6 | 5600.0 |
| 2010-03-05 06:00:00 | AAPL | Stock | 7.5929 | 7.5932 | 7.5929 | 7.5932 | 16800.0 |
| 2010-03-05 07:00:00 | AAPL | Stock | 7.6061 | 7.6064 | 7.5975 | 7.5975 | 25200.0 |
| 2010-03-05 07:05:00 | AAPL | Stock | 7.5975 | 7.6061 | 7.5975 | 7.6061 | 8400.0 |
| 2010-03-05 07:10:00 | AAPL | Stock | 7.6193 | 7.6193 | 7.6189 | 7.6189 | 28840.0 |
| 2010-03-05 07:15:00 | AAPL | Stock | 7.6193 | 7.6232 | 7.6054 | 7.6071 | 92736.0 |
| 2010-03-05 07:20:00 | AAPL | Stock | 7.6161 | 7.6182 | 7.6079 | 7.6079 | 33600.0 |
| 2010-03-05 07:25:00 | AAPL | Stock | 7.6179 | 7.6179 | 7.6175 | 7.6179 | 11200.0 |
| 2010-03-05 07:30:00 | AAPL | Stock | 7.6214 | 7.6214 | 7.6214 | 7.6214 | 2800.0 |
| 2010-03-05 07:35:00 | AAPL | Stock | 7.6179 | 7.6214 | 7.6143 | 7.6161 | 65772.0 |
| 2010-03-05 07:40:00 | AAPL | Stock | 7.6146 | 7.6204 | 7.6146 | 7.6171 | 16716.0 |
| 2010-03-05 07:45:00 | AAPL | Stock | 7.6171 | 7.6196 | 7.6143 | 7.6143 | 73304.0 |
| 2010-03-05 07:55:00 | AAPL | Stock | 7.6107 | 7.6107 | 7.6029 | 7.6029 | 201572.0 |
| 2010-03-05 08:00:00 | AAPL | Stock | 7.6071 | 7.6211 | 7.6025 | 7.6107 | 434168.0 |
| 2010-03-05 08:05:00 | AAPL | Stock | 7.6107 | 7.615 | 7.6054 | 7.615 | 480760.0 |
| 2010-03-05 08:10:00 | AAPL | Stock | 7.615 | 7.6161 | 7.6082 | 7.6107 | 351288.0 |
| 2010-03-05 08:15:00 | AAPL | Stock | 7.6118 | 7.6143 | 7.6071 | 7.6071 | 428344.0 |
| 2010-03-05 08:20:00 | AAPL | Stock | 7.6061 | 7.6075 | 7.6054 | 7.6071 | 454496.0 |
| 2010-03-05 08:25:00 | AAPL | Stock | 7.6071 | 7.6089 | 7.5964 | 7.5964 | 499100.0 |
| 2010-03-05 08:30:00 | AAPL | Stock | 7.5996 | 7.6693 | 7.5996 | 7.6611 | 4819444.0 |
| 2010-03-05 08:35:00 | AAPL | Stock | 7.6611 | 7.6629 | 7.6396 | 7.6439 | 1405068.0 |
| 2010-03-05 08:40:00 | AAPL | Stock | 7.6436 | 7.6493 | 7.6425 | 7.6464 | 1355704.0 |
| 2010-03-05 08:45:00 | AAPL | Stock | 7.6457 | 7.6707 | 7.6432 | 7.6689 | 1416884.0 |
| 2010-03-05 08:50:00 | AAPL | Stock | 7.6693 | 7.6714 | 7.645 | 7.6714 | 1585164.0 |
| 2010-03-05 08:55:00 | AAPL | Stock | 7.6714 | 7.6975 | 7.6696 | 7.6929 | 3631096.0 |
| 2010-03-05 09:00:00 | AAPL | Stock | 7.6929 | 7.7018 | 7.6873 | 7.6911 | 2146816.0 |
| 2010-03-05 09:05:00 | AAPL | Stock | 7.6918 | 7.6971 | 7.6861 | 7.6861 | 1041796.0 |
| 2010-03-05 09:10:00 | AAPL | Stock | 7.6873 | 7.6896 | 7.6768 | 7.6814 | 1453368.0 |
| 2010-03-05 09:15:00 | AAPL | Stock | 7.6846 | 7.6886 | 7.6804 | 7.6821 | 1124452.0 |
| 2010-03-05 09:20:00 | AAPL | Stock | 7.6821 | 7.6839 | 7.6714 | 7.6757 | 634592.0 |
| 2010-03-05 09:25:00 | AAPL | Stock | 7.6768 | 7.6821 | 7.6732 | 7.6782 | 508172.0 |
| 2010-03-05 09:30:00 | AAPL | Stock | 7.6782 | 7.7293 | 7.6654 | 7.7193 | 66418772.0 |
| 2010-03-05 09:35:00 | AAPL | Stock | 7.7171 | 7.7446 | 7.7157 | 7.7261 | 38643192.0 |
| 2010-03-05 09:40:00 | AAPL | Stock | 7.7264 | 7.75 | 7.7107 | 7.7489 | 31191524.0 |
| 2010-03-05 09:45:00 | AAPL | Stock | 7.7489 | 7.7571 | 7.735 | 7.7443 | 25281648.0 |
| 2010-03-05 09:50:00 | AAPL | Stock | 7.7443 | 7.7518 | 7.7411 | 7.7518 | 17093076.0 |
| 2010-03-05 09:55:00 | AAPL | Stock | 7.7518 | 7.7661 | 7.7505 | 7.7611 | 24004484.0 |
| 2010-03-05 10:00:00 | AAPL | Stock | 7.7604 | 7.7636 | 7.7436 | 7.7568 | 18252192.0 |
| 2010-03-05 10:05:00 | AAPL | Stock | 7.7575 | 7.7607 | 7.7486 | 7.7496 | 12742072.0 |
| 2010-03-05 10:10:00 | AAPL | Stock | 7.7496 | 7.7607 | 7.7486 | 7.7571 | 12213208.0 |
| 2010-03-05 10:15:00 | AAPL | Stock | 7.7561 | 7.7586 | 7.7504 | 7.7534 | 10111164.0 |
| 2010-03-05 10:20:00 | AAPL | Stock | 7.7532 | 7.7632 | 7.7446 | 7.7479 | 16659188.0 |
| 2010-03-05 10:25:00 | AAPL | Stock | 7.7486 | 7.7671 | 7.7464 | 7.7607 | 16533692.0 |
| 2010-03-05 10:30:00 | AAPL | Stock | 7.7614 | 7.7743 | 7.7607 | 7.7668 | 17648204.0 |
| 2010-03-05 10:35:00 | AAPL | Stock | 7.7657 | 7.7732 | 7.7643 | 7.7707 | 8791020.0 |
| 2010-03-05 10:40:00 | AAPL | Stock | 7.7714 | 7.7729 | 7.7625 | 7.7668 | 7445088.0 |
| 2010-03-05 10:45:00 | AAPL | Stock | 7.7662 | 7.7693 | 7.7643 | 7.7675 | 4796792.0 |
| 2010-03-05 10:50:00 | AAPL | Stock | 7.7675 | 7.7818 | 7.7671 | 7.7793 | 12559540.0 |
> showing 50 of 331,285 rows — these rows as CSV