PREVIEW / stock_5min / 2007-01-08
file: by_date/stock_5min/2007/2007-01-08.parquet size: 3.3 MB rows: 238,990 symbols: 2,483
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 |
|---|---|---|---|---|---|---|---|
| 2007-01-08 05:40:00 | AAPL | Stock | 3.0421 | 3.0443 | 3.0421 | 3.0443 | 11200.0 |
| 2007-01-08 06:00:00 | AAPL | Stock | 3.0429 | 3.0429 | 3.0429 | 3.0429 | 33600.0 |
| 2007-01-08 06:50:00 | AAPL | Stock | 3.0582 | 3.0714 | 3.0582 | 3.0686 | 55720.0 |
| 2007-01-08 07:00:00 | AAPL | Stock | 3.0554 | 3.0661 | 3.055 | 3.0661 | 98000.0 |
| 2007-01-08 07:05:00 | AAPL | Stock | 3.0654 | 3.0657 | 3.0554 | 3.0554 | 106400.0 |
| 2007-01-08 07:10:00 | AAPL | Stock | 3.0671 | 3.0671 | 3.0671 | 3.0671 | 8400.0 |
| 2007-01-08 07:20:00 | AAPL | Stock | 3.0625 | 3.0625 | 3.0625 | 3.0625 | 2800.0 |
| 2007-01-08 07:25:00 | AAPL | Stock | 3.0643 | 3.0736 | 3.0643 | 3.0736 | 114800.0 |
| 2007-01-08 07:30:00 | AAPL | Stock | 3.0743 | 3.0779 | 3.0743 | 3.0779 | 53200.0 |
| 2007-01-08 07:35:00 | AAPL | Stock | 3.0754 | 3.0754 | 3.07 | 3.0725 | 89600.0 |
| 2007-01-08 07:40:00 | AAPL | Stock | 3.0721 | 3.0725 | 3.0714 | 3.0725 | 45920.0 |
| 2007-01-08 07:45:00 | AAPL | Stock | 3.0732 | 3.0732 | 3.0714 | 3.0714 | 72800.0 |
| 2007-01-08 07:50:00 | AAPL | Stock | 3.0718 | 3.075 | 3.0714 | 3.075 | 64400.0 |
| 2007-01-08 07:55:00 | AAPL | Stock | 3.0754 | 3.0754 | 3.0743 | 3.075 | 137200.0 |
| 2007-01-08 08:00:00 | AAPL | Stock | 3.0739 | 3.0764 | 3.0625 | 3.0661 | 653856.0 |
| 2007-01-08 08:05:00 | AAPL | Stock | 3.0686 | 3.0686 | 3.0607 | 3.0618 | 371868.0 |
| 2007-01-08 08:10:00 | AAPL | Stock | 3.0607 | 3.0643 | 3.0604 | 3.0607 | 174160.0 |
| 2007-01-08 08:15:00 | AAPL | Stock | 3.0604 | 3.0625 | 3.0568 | 3.0568 | 129976.0 |
| 2007-01-08 08:20:00 | AAPL | Stock | 3.0536 | 3.0611 | 3.0536 | 3.0593 | 1368976.0 |
| 2007-01-08 08:25:00 | AAPL | Stock | 3.0579 | 3.0579 | 3.0489 | 3.0518 | 875840.0 |
| 2007-01-08 08:30:00 | AAPL | Stock | 3.0518 | 3.0589 | 3.05 | 3.0571 | 304248.0 |
| 2007-01-08 08:35:00 | AAPL | Stock | 3.0575 | 3.0589 | 3.0571 | 3.0571 | 181608.0 |
| 2007-01-08 08:40:00 | AAPL | Stock | 3.0571 | 3.0589 | 3.0571 | 3.0589 | 145992.0 |
| 2007-01-08 08:45:00 | AAPL | Stock | 3.0589 | 3.0604 | 3.0589 | 3.0593 | 81928.0 |
| 2007-01-08 08:50:00 | AAPL | Stock | 3.0575 | 3.0589 | 3.0575 | 3.0589 | 12460.0 |
| 2007-01-08 08:55:00 | AAPL | Stock | 3.0586 | 3.0589 | 3.0571 | 3.0571 | 101360.0 |
| 2007-01-08 09:00:00 | AAPL | Stock | 3.0589 | 3.0589 | 3.0571 | 3.0586 | 163100.0 |
| 2007-01-08 09:05:00 | AAPL | Stock | 3.0586 | 3.0589 | 3.0561 | 3.0589 | 242928.0 |
| 2007-01-08 09:10:00 | AAPL | Stock | 3.0589 | 3.0589 | 3.0571 | 3.0571 | 192556.0 |
| 2007-01-08 09:15:00 | AAPL | Stock | 3.0571 | 3.0586 | 3.0554 | 3.0586 | 139132.0 |
| 2007-01-08 09:20:00 | AAPL | Stock | 3.0586 | 3.0593 | 3.0568 | 3.0593 | 174020.0 |
| 2007-01-08 09:25:00 | AAPL | Stock | 3.0593 | 3.0721 | 3.0564 | 3.0693 | 1417584.0 |
| 2007-01-08 09:30:00 | AAPL | Stock | 3.07 | 3.075 | 3.0504 | 3.0589 | 29050476.0 |
| 2007-01-08 09:35:00 | AAPL | Stock | 3.0596 | 3.0754 | 3.0539 | 3.0682 | 22608824.0 |
| 2007-01-08 09:40:00 | AAPL | Stock | 3.0686 | 3.0893 | 3.0646 | 3.0875 | 29054620.0 |
| 2007-01-08 09:45:00 | AAPL | Stock | 3.0868 | 3.0904 | 3.075 | 3.0875 | 33081076.0 |
| 2007-01-08 09:50:00 | AAPL | Stock | 3.0875 | 3.0875 | 3.0714 | 3.0736 | 24964044.0 |
| 2007-01-08 09:55:00 | AAPL | Stock | 3.0736 | 3.0757 | 3.0689 | 3.075 | 20347236.0 |
| 2007-01-08 10:00:00 | AAPL | Stock | 3.0746 | 3.0811 | 3.0679 | 3.0811 | 19168072.0 |
| 2007-01-08 10:05:00 | AAPL | Stock | 3.0807 | 3.0864 | 3.0729 | 3.075 | 15708336.0 |
| 2007-01-08 10:10:00 | AAPL | Stock | 3.0754 | 3.0779 | 3.0682 | 3.0704 | 13868092.0 |
| 2007-01-08 10:15:00 | AAPL | Stock | 3.0707 | 3.0732 | 3.0625 | 3.0657 | 14167888.0 |
| 2007-01-08 10:20:00 | AAPL | Stock | 3.066 | 3.0696 | 3.0636 | 3.0664 | 11805388.0 |
| 2007-01-08 10:25:00 | AAPL | Stock | 3.0668 | 3.0693 | 3.0664 | 3.0668 | 7624876.0 |
| 2007-01-08 10:30:00 | AAPL | Stock | 3.0664 | 3.0746 | 3.0625 | 3.0729 | 13147708.0 |
| 2007-01-08 10:35:00 | AAPL | Stock | 3.0729 | 3.075 | 3.0721 | 3.0736 | 8669332.0 |
| 2007-01-08 10:40:00 | AAPL | Stock | 3.0732 | 3.0768 | 3.0711 | 3.0729 | 13778380.0 |
| 2007-01-08 10:45:00 | AAPL | Stock | 3.0728 | 3.0739 | 3.0629 | 3.066 | 13109292.0 |
| 2007-01-08 10:50:00 | AAPL | Stock | 3.0661 | 3.0661 | 3.0584 | 3.0632 | 13979252.0 |
| 2007-01-08 10:55:00 | AAPL | Stock | 3.0629 | 3.0675 | 3.0568 | 3.0568 | 9905896.0 |
> showing 50 of 238,990 rows — these rows as CSV