PREVIEW / stock_5min / 2006-05-04
file: by_date/stock_5min/2006/2006-05-04.parquet size: 3.1 MB rows: 224,418 symbols: 2,261
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 |
|---|---|---|---|---|---|---|---|
| 2006-05-04 08:00:00 | AAPL | Stock | 2.5393 | 2.55 | 2.5393 | 2.5464 | 70700.0 |
| 2006-05-04 08:05:00 | AAPL | Stock | 2.5464 | 2.5482 | 2.5446 | 2.5446 | 103600.0 |
| 2006-05-04 08:10:00 | AAPL | Stock | 2.5454 | 2.5482 | 2.545 | 2.5482 | 78400.0 |
| 2006-05-04 08:15:00 | AAPL | Stock | 2.545 | 2.5486 | 2.545 | 2.5486 | 182224.0 |
| 2006-05-04 08:20:00 | AAPL | Stock | 2.5486 | 2.5486 | 2.5443 | 2.5443 | 105616.0 |
| 2006-05-04 08:25:00 | AAPL | Stock | 2.5443 | 2.5479 | 2.5443 | 2.5468 | 36400.0 |
| 2006-05-04 08:30:00 | AAPL | Stock | 2.5468 | 2.5468 | 2.5446 | 2.5464 | 118692.0 |
| 2006-05-04 08:35:00 | AAPL | Stock | 2.5457 | 2.5464 | 2.5432 | 2.5464 | 204120.0 |
| 2006-05-04 08:40:00 | AAPL | Stock | 2.5446 | 2.5446 | 2.5432 | 2.5432 | 14700.0 |
| 2006-05-04 08:45:00 | AAPL | Stock | 2.5425 | 2.5429 | 2.5411 | 2.5411 | 30800.0 |
| 2006-05-04 08:50:00 | AAPL | Stock | 2.5411 | 2.5429 | 2.5411 | 2.5418 | 28000.0 |
| 2006-05-04 08:55:00 | AAPL | Stock | 2.5429 | 2.5443 | 2.5429 | 2.5443 | 107800.0 |
| 2006-05-04 09:00:00 | AAPL | Stock | 2.5446 | 2.5446 | 2.5443 | 2.5446 | 78680.0 |
| 2006-05-04 09:05:00 | AAPL | Stock | 2.545 | 2.545 | 2.5446 | 2.5446 | 30800.0 |
| 2006-05-04 09:10:00 | AAPL | Stock | 2.5446 | 2.5464 | 2.5432 | 2.5457 | 126000.0 |
| 2006-05-04 09:15:00 | AAPL | Stock | 2.5457 | 2.5457 | 2.5439 | 2.5439 | 23856.0 |
| 2006-05-04 09:20:00 | AAPL | Stock | 2.5461 | 2.5461 | 2.5461 | 2.5461 | 12600.0 |
| 2006-05-04 09:25:00 | AAPL | Stock | 2.5461 | 2.5461 | 2.5357 | 2.5411 | 814324.0 |
| 2006-05-04 09:30:00 | AAPL | Stock | 2.5436 | 2.5646 | 2.5375 | 2.5614 | 24406368.0 |
| 2006-05-04 09:35:00 | AAPL | Stock | 2.5614 | 2.5889 | 2.5596 | 2.5846 | 55234508.0 |
| 2006-05-04 09:40:00 | AAPL | Stock | 2.5846 | 2.5889 | 2.5782 | 2.5875 | 23177560.0 |
| 2006-05-04 09:45:00 | AAPL | Stock | 2.5875 | 2.5982 | 2.5875 | 2.5921 | 25408460.0 |
| 2006-05-04 09:50:00 | AAPL | Stock | 2.5925 | 2.5996 | 2.5846 | 2.5846 | 22581832.0 |
| 2006-05-04 09:55:00 | AAPL | Stock | 2.585 | 2.5979 | 2.5846 | 2.5979 | 18661412.0 |
| 2006-05-04 10:00:00 | AAPL | Stock | 2.5971 | 2.6 | 2.5914 | 2.5971 | 17663828.0 |
| 2006-05-04 10:05:00 | AAPL | Stock | 2.5971 | 2.6029 | 2.5864 | 2.5954 | 22467508.0 |
| 2006-05-04 10:10:00 | AAPL | Stock | 2.5954 | 2.6032 | 2.5929 | 2.5971 | 19559008.0 |
| 2006-05-04 10:15:00 | AAPL | Stock | 2.5971 | 2.5979 | 2.5846 | 2.5846 | 15635508.0 |
| 2006-05-04 10:20:00 | AAPL | Stock | 2.5846 | 2.5921 | 2.5775 | 2.5829 | 19034680.0 |
| 2006-05-04 10:25:00 | AAPL | Stock | 2.5832 | 2.5886 | 2.5771 | 2.5871 | 12286428.0 |
| 2006-05-04 10:30:00 | AAPL | Stock | 2.5871 | 2.5904 | 2.5843 | 2.5889 | 8941968.0 |
| 2006-05-04 10:35:00 | AAPL | Stock | 2.5889 | 2.5889 | 2.5814 | 2.5818 | 7408072.0 |
| 2006-05-04 10:40:00 | AAPL | Stock | 2.5821 | 2.585 | 2.5771 | 2.5789 | 9388540.0 |
| 2006-05-04 10:45:00 | AAPL | Stock | 2.5793 | 2.585 | 2.5779 | 2.5832 | 8938356.0 |
| 2006-05-04 10:50:00 | AAPL | Stock | 2.5836 | 2.5843 | 2.5789 | 2.5804 | 6509664.0 |
| 2006-05-04 10:55:00 | AAPL | Stock | 2.58 | 2.58 | 2.5646 | 2.5657 | 17623900.0 |
| 2006-05-04 11:00:00 | AAPL | Stock | 2.5657 | 2.5796 | 2.5654 | 2.5739 | 12393528.0 |
| 2006-05-04 11:05:00 | AAPL | Stock | 2.5736 | 2.5764 | 2.5686 | 2.5721 | 7495488.0 |
| 2006-05-04 11:10:00 | AAPL | Stock | 2.5722 | 2.5746 | 2.57 | 2.571 | 7952224.0 |
| 2006-05-04 11:15:00 | AAPL | Stock | 2.5711 | 2.5764 | 2.5711 | 2.5761 | 5414080.0 |
| 2006-05-04 11:20:00 | AAPL | Stock | 2.5761 | 2.5775 | 2.575 | 2.5757 | 3863440.0 |
| 2006-05-04 11:25:00 | AAPL | Stock | 2.5757 | 2.58 | 2.5754 | 2.5757 | 4995788.0 |
| 2006-05-04 11:30:00 | AAPL | Stock | 2.5757 | 2.5775 | 2.575 | 2.5757 | 4281284.0 |
| 2006-05-04 11:35:00 | AAPL | Stock | 2.5757 | 2.5829 | 2.5757 | 2.5821 | 6134828.0 |
| 2006-05-04 11:40:00 | AAPL | Stock | 2.5825 | 2.5854 | 2.5811 | 2.5832 | 6762560.0 |
| 2006-05-04 11:45:00 | AAPL | Stock | 2.5832 | 2.585 | 2.58 | 2.58 | 4306988.0 |
| 2006-05-04 11:50:00 | AAPL | Stock | 2.58 | 2.5832 | 2.5789 | 2.5789 | 3609928.0 |
| 2006-05-04 11:55:00 | AAPL | Stock | 2.5793 | 2.5793 | 2.5754 | 2.5775 | 3461584.0 |
| 2006-05-04 12:00:00 | AAPL | Stock | 2.5771 | 2.5789 | 2.5757 | 2.5757 | 3123204.0 |
| 2006-05-04 12:05:00 | AAPL | Stock | 2.5757 | 2.5782 | 2.575 | 2.5771 | 2950332.0 |
> showing 50 of 224,418 rows — these rows as CSV