PREVIEW / stock_5min / 2005-04-08
file: by_date/stock_5min/2005/2005-04-08.parquet size: 2.5 MB rows: 186,184 symbols: 1,942
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 |
|---|---|---|---|---|---|---|---|
| 2005-04-08 08:00:00 | AAPL | Stock | 1.5643 | 1.5714 | 1.5607 | 1.5646 | 153860.0 |
| 2005-04-08 08:05:00 | AAPL | Stock | 1.5589 | 1.5589 | 1.5571 | 1.5571 | 81200.0 |
| 2005-04-08 08:10:00 | AAPL | Stock | 1.5579 | 1.5579 | 1.5579 | 1.5579 | 28000.0 |
| 2005-04-08 08:15:00 | AAPL | Stock | 1.56 | 1.5614 | 1.56 | 1.5614 | 28000.0 |
| 2005-04-08 08:30:00 | AAPL | Stock | 1.5643 | 1.5654 | 1.5625 | 1.5643 | 204400.0 |
| 2005-04-08 08:35:00 | AAPL | Stock | 1.5643 | 1.5643 | 1.5632 | 1.5632 | 25200.0 |
| 2005-04-08 08:40:00 | AAPL | Stock | 1.5636 | 1.5636 | 1.5614 | 1.5614 | 47600.0 |
| 2005-04-08 08:45:00 | AAPL | Stock | 1.5607 | 1.5607 | 1.5579 | 1.5593 | 162400.0 |
| 2005-04-08 08:50:00 | AAPL | Stock | 1.5593 | 1.56 | 1.5593 | 1.5596 | 114800.0 |
| 2005-04-08 08:55:00 | AAPL | Stock | 1.5596 | 1.56 | 1.5596 | 1.56 | 33600.0 |
| 2005-04-08 09:00:00 | AAPL | Stock | 1.56 | 1.56 | 1.56 | 1.56 | 44800.0 |
| 2005-04-08 09:05:00 | AAPL | Stock | 1.5593 | 1.5593 | 1.5586 | 1.5593 | 28000.0 |
| 2005-04-08 09:10:00 | AAPL | Stock | 1.5589 | 1.5593 | 1.5575 | 1.5579 | 176400.0 |
| 2005-04-08 09:15:00 | AAPL | Stock | 1.5582 | 1.5586 | 1.5582 | 1.5586 | 5600.0 |
| 2005-04-08 09:20:00 | AAPL | Stock | 1.5579 | 1.5589 | 1.5579 | 1.5589 | 159600.0 |
| 2005-04-08 09:25:00 | AAPL | Stock | 1.5589 | 1.5621 | 1.5579 | 1.5607 | 772520.0 |
| 2005-04-08 09:30:00 | AAPL | Stock | 1.5607 | 1.5696 | 1.5579 | 1.5696 | 18155956.0 |
| 2005-04-08 09:35:00 | AAPL | Stock | 1.5689 | 1.5779 | 1.5675 | 1.5736 | 32588836.0 |
| 2005-04-08 09:40:00 | AAPL | Stock | 1.5732 | 1.5768 | 1.5657 | 1.5764 | 23070656.0 |
| 2005-04-08 09:45:00 | AAPL | Stock | 1.5767 | 1.5821 | 1.57 | 1.5811 | 17074792.0 |
| 2005-04-08 09:50:00 | AAPL | Stock | 1.5811 | 1.5875 | 1.5743 | 1.5768 | 26217072.0 |
| 2005-04-08 09:55:00 | AAPL | Stock | 1.5768 | 1.5779 | 1.5704 | 1.575 | 19243840.0 |
| 2005-04-08 10:00:00 | AAPL | Stock | 1.5754 | 1.5768 | 1.5704 | 1.5754 | 14181328.0 |
| 2005-04-08 10:05:00 | AAPL | Stock | 1.575 | 1.5754 | 1.5632 | 1.5668 | 13060292.0 |
| 2005-04-08 10:10:00 | AAPL | Stock | 1.5668 | 1.5714 | 1.5657 | 1.5689 | 7744128.0 |
| 2005-04-08 10:15:00 | AAPL | Stock | 1.5689 | 1.5736 | 1.5675 | 1.5714 | 10093132.0 |
| 2005-04-08 10:20:00 | AAPL | Stock | 1.5711 | 1.5732 | 1.5693 | 1.5714 | 10326008.0 |
| 2005-04-08 10:25:00 | AAPL | Stock | 1.5714 | 1.5728 | 1.5657 | 1.5711 | 12423880.0 |
| 2005-04-08 10:30:00 | AAPL | Stock | 1.5711 | 1.5729 | 1.5696 | 1.5718 | 9595824.0 |
| 2005-04-08 10:35:00 | AAPL | Stock | 1.5718 | 1.5718 | 1.5686 | 1.5704 | 10016132.0 |
| 2005-04-08 10:40:00 | AAPL | Stock | 1.5704 | 1.5714 | 1.5671 | 1.5675 | 4671856.0 |
| 2005-04-08 10:45:00 | AAPL | Stock | 1.5671 | 1.5711 | 1.5657 | 1.57 | 8482544.0 |
| 2005-04-08 10:50:00 | AAPL | Stock | 1.57 | 1.5714 | 1.5671 | 1.5696 | 6249320.0 |
| 2005-04-08 10:55:00 | AAPL | Stock | 1.5693 | 1.5707 | 1.5693 | 1.5704 | 3689840.0 |
| 2005-04-08 11:00:00 | AAPL | Stock | 1.5707 | 1.5732 | 1.5696 | 1.5696 | 7037156.0 |
| 2005-04-08 11:05:00 | AAPL | Stock | 1.5696 | 1.5714 | 1.5693 | 1.5711 | 6302100.0 |
| 2005-04-08 11:10:00 | AAPL | Stock | 1.5707 | 1.5714 | 1.5679 | 1.5689 | 6165348.0 |
| 2005-04-08 11:15:00 | AAPL | Stock | 1.5686 | 1.57 | 1.5682 | 1.5696 | 3115364.0 |
| 2005-04-08 11:20:00 | AAPL | Stock | 1.5696 | 1.5707 | 1.5689 | 1.57 | 3142608.0 |
| 2005-04-08 11:25:00 | AAPL | Stock | 1.57 | 1.5714 | 1.5689 | 1.5704 | 7484064.0 |
| 2005-04-08 11:30:00 | AAPL | Stock | 1.5704 | 1.5718 | 1.5693 | 1.5714 | 8694364.0 |
| 2005-04-08 11:35:00 | AAPL | Stock | 1.5714 | 1.5721 | 1.5711 | 1.5714 | 6040384.0 |
| 2005-04-08 11:40:00 | AAPL | Stock | 1.5714 | 1.5721 | 1.5671 | 1.5679 | 12821200.0 |
| 2005-04-08 11:45:00 | AAPL | Stock | 1.5679 | 1.5711 | 1.5668 | 1.5711 | 6023500.0 |
| 2005-04-08 11:50:00 | AAPL | Stock | 1.5707 | 1.5711 | 1.5682 | 1.5689 | 7492884.0 |
| 2005-04-08 11:55:00 | AAPL | Stock | 1.5689 | 1.5696 | 1.5679 | 1.5693 | 3892420.0 |
| 2005-04-08 12:00:00 | AAPL | Stock | 1.5689 | 1.57 | 1.5686 | 1.5689 | 3845800.0 |
| 2005-04-08 12:05:00 | AAPL | Stock | 1.5689 | 1.5696 | 1.5686 | 1.5689 | 2096612.0 |
| 2005-04-08 12:10:00 | AAPL | Stock | 1.5689 | 1.5714 | 1.5689 | 1.5711 | 6281912.0 |
| 2005-04-08 12:15:00 | AAPL | Stock | 1.5711 | 1.5711 | 1.5689 | 1.57 | 8501444.0 |
> showing 50 of 186,184 rows — these rows as CSV