PREVIEW / stock_5min / 2005-08-10
file: by_date/stock_5min/2005/2005-08-10.parquet size: 2.8 MB rows: 205,547 symbols: 2,057
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-08-10 08:00:00 | AAPL | Stock | 1.5661 | 1.5732 | 1.5661 | 1.5732 | 208600.0 |
| 2005-08-10 08:05:00 | AAPL | Stock | 1.5736 | 1.5746 | 1.5736 | 1.5739 | 11200.0 |
| 2005-08-10 08:10:00 | AAPL | Stock | 1.5732 | 1.5732 | 1.5732 | 1.5732 | 16800.0 |
| 2005-08-10 08:15:00 | AAPL | Stock | 1.5732 | 1.5739 | 1.5732 | 1.5732 | 95200.0 |
| 2005-08-10 08:20:00 | AAPL | Stock | 1.5725 | 1.575 | 1.5721 | 1.5725 | 114940.0 |
| 2005-08-10 08:30:00 | AAPL | Stock | 1.5729 | 1.5739 | 1.5725 | 1.5739 | 70000.0 |
| 2005-08-10 08:35:00 | AAPL | Stock | 1.5732 | 1.5739 | 1.5732 | 1.5739 | 28280.0 |
| 2005-08-10 08:40:00 | AAPL | Stock | 1.5732 | 1.5736 | 1.5725 | 1.5736 | 71400.0 |
| 2005-08-10 08:45:00 | AAPL | Stock | 1.5739 | 1.5739 | 1.5736 | 1.5739 | 67200.0 |
| 2005-08-10 08:50:00 | AAPL | Stock | 1.5739 | 1.5743 | 1.5721 | 1.5725 | 84000.0 |
| 2005-08-10 08:55:00 | AAPL | Stock | 1.5721 | 1.5725 | 1.5721 | 1.5725 | 80360.0 |
| 2005-08-10 09:00:00 | AAPL | Stock | 1.5725 | 1.5725 | 1.5714 | 1.5714 | 26600.0 |
| 2005-08-10 09:05:00 | AAPL | Stock | 1.5732 | 1.5732 | 1.5732 | 1.5732 | 8456.0 |
| 2005-08-10 09:10:00 | AAPL | Stock | 1.5729 | 1.5743 | 1.5714 | 1.5714 | 235032.0 |
| 2005-08-10 09:20:00 | AAPL | Stock | 1.5714 | 1.5732 | 1.5714 | 1.5721 | 50400.0 |
| 2005-08-10 09:25:00 | AAPL | Stock | 1.5704 | 1.5729 | 1.5704 | 1.5714 | 426048.0 |
| 2005-08-10 09:30:00 | AAPL | Stock | 1.5714 | 1.5721 | 1.57 | 1.5711 | 9878624.0 |
| 2005-08-10 09:35:00 | AAPL | Stock | 1.5707 | 1.5718 | 1.5707 | 1.5714 | 5780012.0 |
| 2005-08-10 09:40:00 | AAPL | Stock | 1.5711 | 1.5714 | 1.5646 | 1.5679 | 8860264.0 |
| 2005-08-10 09:45:00 | AAPL | Stock | 1.5679 | 1.5704 | 1.5671 | 1.57 | 5902204.0 |
| 2005-08-10 09:50:00 | AAPL | Stock | 1.57 | 1.5714 | 1.5686 | 1.5711 | 3317860.0 |
| 2005-08-10 09:55:00 | AAPL | Stock | 1.5711 | 1.5793 | 1.5711 | 1.5793 | 19592580.0 |
| 2005-08-10 10:00:00 | AAPL | Stock | 1.5793 | 1.5818 | 1.5714 | 1.5775 | 17190180.0 |
| 2005-08-10 10:05:00 | AAPL | Stock | 1.5768 | 1.5796 | 1.575 | 1.5768 | 9073232.0 |
| 2005-08-10 10:10:00 | AAPL | Stock | 1.5768 | 1.5775 | 1.5743 | 1.5761 | 6185032.0 |
| 2005-08-10 10:15:00 | AAPL | Stock | 1.5761 | 1.5782 | 1.5682 | 1.5689 | 10042116.0 |
| 2005-08-10 10:20:00 | AAPL | Stock | 1.5679 | 1.5718 | 1.5679 | 1.5704 | 5955740.0 |
| 2005-08-10 10:25:00 | AAPL | Stock | 1.5704 | 1.5711 | 1.5671 | 1.5707 | 2653280.0 |
| 2005-08-10 10:30:00 | AAPL | Stock | 1.5707 | 1.5854 | 1.5661 | 1.5696 | 13666492.0 |
| 2005-08-10 10:35:00 | AAPL | Stock | 1.57 | 1.5704 | 1.5675 | 1.5679 | 3006948.0 |
| 2005-08-10 10:40:00 | AAPL | Stock | 1.5679 | 1.5689 | 1.5618 | 1.5636 | 6561520.0 |
| 2005-08-10 10:45:00 | AAPL | Stock | 1.5618 | 1.5671 | 1.5614 | 1.5664 | 6651988.0 |
| 2005-08-10 10:50:00 | AAPL | Stock | 1.5667 | 1.5667 | 1.5604 | 1.5607 | 3454304.0 |
| 2005-08-10 10:55:00 | AAPL | Stock | 1.5607 | 1.5618 | 1.5593 | 1.5607 | 7370860.0 |
| 2005-08-10 11:00:00 | AAPL | Stock | 1.5607 | 1.5636 | 1.56 | 1.5621 | 3359356.0 |
| 2005-08-10 11:05:00 | AAPL | Stock | 1.5621 | 1.5664 | 1.56 | 1.5657 | 4213468.0 |
| 2005-08-10 11:10:00 | AAPL | Stock | 1.5661 | 1.5668 | 1.5634 | 1.5664 | 2345756.0 |
| 2005-08-10 11:15:00 | AAPL | Stock | 1.5661 | 1.5664 | 1.5636 | 1.5639 | 5059796.0 |
| 2005-08-10 11:20:00 | AAPL | Stock | 1.5639 | 1.5646 | 1.5636 | 1.5646 | 766808.0 |
| 2005-08-10 11:25:00 | AAPL | Stock | 1.5646 | 1.5661 | 1.5646 | 1.5657 | 1416744.0 |
| 2005-08-10 11:30:00 | AAPL | Stock | 1.5661 | 1.5693 | 1.5657 | 1.5686 | 3335584.0 |
| 2005-08-10 11:35:00 | AAPL | Stock | 1.5682 | 1.5686 | 1.5679 | 1.5686 | 991732.0 |
| 2005-08-10 11:40:00 | AAPL | Stock | 1.5686 | 1.5696 | 1.5679 | 1.5686 | 1010828.0 |
| 2005-08-10 11:45:00 | AAPL | Stock | 1.5686 | 1.5689 | 1.5676 | 1.5679 | 4530904.0 |
| 2005-08-10 11:50:00 | AAPL | Stock | 1.5682 | 1.5696 | 1.5679 | 1.5689 | 966056.0 |
| 2005-08-10 11:55:00 | AAPL | Stock | 1.5689 | 1.5696 | 1.5686 | 1.5689 | 997500.0 |
| 2005-08-10 12:00:00 | AAPL | Stock | 1.5689 | 1.5693 | 1.5686 | 1.5689 | 777448.0 |
| 2005-08-10 12:05:00 | AAPL | Stock | 1.5689 | 1.5696 | 1.5685 | 1.5689 | 1289372.0 |
| 2005-08-10 12:10:00 | AAPL | Stock | 1.5689 | 1.5697 | 1.5682 | 1.5696 | 1368976.0 |
| 2005-08-10 12:15:00 | AAPL | Stock | 1.57 | 1.5707 | 1.5689 | 1.5707 | 8446984.0 |
> showing 50 of 205,547 rows — these rows as CSV