PREVIEW / stock_5min / 2008-08-04
file: by_date/stock_5min/2008/2008-08-04.parquet size: 4.4 MB rows: 313,712 symbols: 3,299
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 |
|---|---|---|---|---|---|---|---|
| 2008-08-04 04:25:00 | AAPL | Stock | 5.6096 | 5.6096 | 5.6096 | 5.6096 | 8400.0 |
| 2008-08-04 07:05:00 | AAPL | Stock | 5.5893 | 5.5893 | 5.5893 | 5.5893 | 5600.0 |
| 2008-08-04 07:30:00 | AAPL | Stock | 5.5564 | 5.5564 | 5.5564 | 5.5564 | 2800.0 |
| 2008-08-04 08:00:00 | AAPL | Stock | 5.5714 | 5.5829 | 5.5714 | 5.5786 | 13720.0 |
| 2008-08-04 08:05:00 | AAPL | Stock | 5.5754 | 5.5796 | 5.575 | 5.5757 | 60060.0 |
| 2008-08-04 08:10:00 | AAPL | Stock | 5.5768 | 5.5832 | 5.5725 | 5.5725 | 175392.0 |
| 2008-08-04 08:15:00 | AAPL | Stock | 5.5725 | 5.5768 | 5.5675 | 5.5714 | 133980.0 |
| 2008-08-04 08:20:00 | AAPL | Stock | 5.5757 | 5.5757 | 5.5679 | 5.5736 | 43260.0 |
| 2008-08-04 08:25:00 | AAPL | Stock | 5.5718 | 5.5771 | 5.5679 | 5.5764 | 90776.0 |
| 2008-08-04 08:30:00 | AAPL | Stock | 5.5729 | 5.5729 | 5.5675 | 5.5686 | 14000.0 |
| 2008-08-04 08:35:00 | AAPL | Stock | 5.5696 | 5.5696 | 5.5679 | 5.5679 | 27468.0 |
| 2008-08-04 08:40:00 | AAPL | Stock | 5.5679 | 5.5679 | 5.5661 | 5.5661 | 27580.0 |
| 2008-08-04 08:45:00 | AAPL | Stock | 5.5754 | 5.5754 | 5.5696 | 5.5696 | 26684.0 |
| 2008-08-04 08:50:00 | AAPL | Stock | 5.5714 | 5.5764 | 5.5714 | 5.5764 | 12600.0 |
| 2008-08-04 08:55:00 | AAPL | Stock | 5.5768 | 5.5768 | 5.5725 | 5.5725 | 35000.0 |
| 2008-08-04 09:00:00 | AAPL | Stock | 5.575 | 5.5821 | 5.575 | 5.5821 | 26880.0 |
| 2008-08-04 09:05:00 | AAPL | Stock | 5.5836 | 5.5893 | 5.5821 | 5.5857 | 89740.0 |
| 2008-08-04 09:10:00 | AAPL | Stock | 5.5821 | 5.5864 | 5.5821 | 5.5857 | 156100.0 |
| 2008-08-04 09:15:00 | AAPL | Stock | 5.5821 | 5.5839 | 5.5821 | 5.5839 | 8400.0 |
| 2008-08-04 09:20:00 | AAPL | Stock | 5.5839 | 5.5893 | 5.5832 | 5.5889 | 98000.0 |
| 2008-08-04 09:25:00 | AAPL | Stock | 5.5889 | 5.59 | 5.5889 | 5.5893 | 17920.0 |
| 2008-08-04 09:30:00 | AAPL | Stock | 5.5929 | 5.6343 | 5.5539 | 5.6157 | 17028760.0 |
| 2008-08-04 09:35:00 | AAPL | Stock | 5.6311 | 5.6393 | 5.5714 | 5.61 | 13401500.0 |
| 2008-08-04 09:40:00 | AAPL | Stock | 5.6093 | 5.6293 | 5.5868 | 5.6222 | 15275540.0 |
| 2008-08-04 09:45:00 | AAPL | Stock | 5.6214 | 5.6379 | 5.6071 | 5.6157 | 11100348.0 |
| 2008-08-04 09:50:00 | AAPL | Stock | 5.6157 | 5.6375 | 5.6107 | 5.6312 | 9846620.0 |
| 2008-08-04 09:55:00 | AAPL | Stock | 5.6296 | 5.6379 | 5.5975 | 5.6111 | 9646168.0 |
| 2008-08-04 10:00:00 | AAPL | Stock | 5.6111 | 5.6186 | 5.5907 | 5.595 | 10349108.0 |
| 2008-08-04 10:05:00 | AAPL | Stock | 5.5954 | 5.6261 | 5.5946 | 5.6201 | 7431984.0 |
| 2008-08-04 10:10:00 | AAPL | Stock | 5.6189 | 5.6236 | 5.5839 | 5.5896 | 9788212.0 |
| 2008-08-04 10:15:00 | AAPL | Stock | 5.5896 | 5.5964 | 5.5818 | 5.5875 | 8365364.0 |
| 2008-08-04 10:20:00 | AAPL | Stock | 5.5875 | 5.5982 | 5.5746 | 5.5821 | 9720060.0 |
| 2008-08-04 10:25:00 | AAPL | Stock | 5.5818 | 5.6011 | 5.5771 | 5.5921 | 6424152.0 |
| 2008-08-04 10:30:00 | AAPL | Stock | 5.5929 | 5.6104 | 5.5886 | 5.5982 | 7879872.0 |
| 2008-08-04 10:35:00 | AAPL | Stock | 5.5993 | 5.6082 | 5.5829 | 5.5857 | 5111568.0 |
| 2008-08-04 10:40:00 | AAPL | Stock | 5.5857 | 5.6025 | 5.5714 | 5.5732 | 5905900.0 |
| 2008-08-04 10:45:00 | AAPL | Stock | 5.5729 | 5.5871 | 5.5671 | 5.58 | 8635004.0 |
| 2008-08-04 10:50:00 | AAPL | Stock | 5.5793 | 5.5904 | 5.5625 | 5.5729 | 6563704.0 |
| 2008-08-04 10:55:00 | AAPL | Stock | 5.5725 | 5.5821 | 5.57 | 5.58 | 4919544.0 |
| 2008-08-04 11:00:00 | AAPL | Stock | 5.5789 | 5.5925 | 5.5729 | 5.5914 | 6780144.0 |
| 2008-08-04 11:05:00 | AAPL | Stock | 5.5925 | 5.5971 | 5.5789 | 5.5896 | 4910752.0 |
| 2008-08-04 11:10:00 | AAPL | Stock | 5.5893 | 5.5893 | 5.5732 | 5.5779 | 3826956.0 |
| 2008-08-04 11:15:00 | AAPL | Stock | 5.5768 | 5.5886 | 5.5729 | 5.5811 | 3888080.0 |
| 2008-08-04 11:20:00 | AAPL | Stock | 5.5818 | 5.5825 | 5.5682 | 5.57 | 5191452.0 |
| 2008-08-04 11:25:00 | AAPL | Stock | 5.5696 | 5.5871 | 5.5693 | 5.5775 | 5519164.0 |
| 2008-08-04 11:30:00 | AAPL | Stock | 5.5775 | 5.6054 | 5.5757 | 5.6018 | 8166872.0 |
| 2008-08-04 11:35:00 | AAPL | Stock | 5.6025 | 5.6118 | 5.595 | 5.6096 | 9325456.0 |
| 2008-08-04 11:40:00 | AAPL | Stock | 5.6093 | 5.6268 | 5.6004 | 5.62 | 12276460.0 |
| 2008-08-04 11:45:00 | AAPL | Stock | 5.6204 | 5.6221 | 5.6011 | 5.6068 | 7684600.0 |
| 2008-08-04 11:50:00 | AAPL | Stock | 5.6057 | 5.6136 | 5.5993 | 5.605 | 4525416.0 |
> showing 50 of 313,712 rows — these rows as CSV