PREVIEW / stock_5min / 2005-12-16
file: by_date/stock_5min/2005/2005-12-16.parquet size: 3.0 MB rows: 216,389 symbols: 2,155
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-12-16 05:30:00 | AAPL | Stock | 2.575 | 2.575 | 2.575 | 2.575 | 10500.0 |
| 2005-12-16 08:00:00 | AAPL | Stock | 2.5929 | 2.5929 | 2.5793 | 2.5921 | 14980.0 |
| 2005-12-16 08:05:00 | AAPL | Stock | 2.5807 | 2.5832 | 2.5804 | 2.5832 | 47040.0 |
| 2005-12-16 08:10:00 | AAPL | Stock | 2.5832 | 2.5832 | 2.5807 | 2.5832 | 77560.0 |
| 2005-12-16 08:15:00 | AAPL | Stock | 2.5854 | 2.5854 | 2.5854 | 2.5854 | 2800.0 |
| 2005-12-16 08:20:00 | AAPL | Stock | 2.5832 | 2.5854 | 2.5832 | 2.5854 | 22400.0 |
| 2005-12-16 08:25:00 | AAPL | Stock | 2.5846 | 2.5846 | 2.5836 | 2.5846 | 27272.0 |
| 2005-12-16 08:30:00 | AAPL | Stock | 2.5875 | 2.5875 | 2.5875 | 2.5875 | 3780.0 |
| 2005-12-16 08:35:00 | AAPL | Stock | 2.5871 | 2.5875 | 2.5864 | 2.5864 | 27020.0 |
| 2005-12-16 08:40:00 | AAPL | Stock | 2.5861 | 2.5861 | 2.5854 | 2.5854 | 22400.0 |
| 2005-12-16 08:45:00 | AAPL | Stock | 2.5843 | 2.5843 | 2.5843 | 2.5843 | 92400.0 |
| 2005-12-16 08:50:00 | AAPL | Stock | 2.5854 | 2.5875 | 2.5854 | 2.5875 | 114800.0 |
| 2005-12-16 08:55:00 | AAPL | Stock | 2.5875 | 2.5875 | 2.5875 | 2.5875 | 16800.0 |
| 2005-12-16 09:00:00 | AAPL | Stock | 2.5875 | 2.5893 | 2.5875 | 2.5889 | 117600.0 |
| 2005-12-16 09:05:00 | AAPL | Stock | 2.5886 | 2.5914 | 2.5886 | 2.5914 | 289464.0 |
| 2005-12-16 09:10:00 | AAPL | Stock | 2.5914 | 2.5964 | 2.5914 | 2.5964 | 1035720.0 |
| 2005-12-16 09:15:00 | AAPL | Stock | 2.5964 | 2.5982 | 2.595 | 2.595 | 372400.0 |
| 2005-12-16 09:20:00 | AAPL | Stock | 2.595 | 2.595 | 2.5918 | 2.5918 | 162764.0 |
| 2005-12-16 09:25:00 | AAPL | Stock | 2.5914 | 2.5914 | 2.5739 | 2.5768 | 3721648.0 |
| 2005-12-16 09:30:00 | AAPL | Stock | 2.5764 | 2.5821 | 2.5625 | 2.5657 | 157508232.0 |
| 2005-12-16 09:35:00 | AAPL | Stock | 2.5661 | 2.5668 | 2.55 | 2.5564 | 19346208.0 |
| 2005-12-16 09:40:00 | AAPL | Stock | 2.5579 | 2.5764 | 2.5504 | 2.5568 | 15230544.0 |
| 2005-12-16 09:45:00 | AAPL | Stock | 2.5567 | 2.5571 | 2.5461 | 2.5471 | 15211280.0 |
| 2005-12-16 09:50:00 | AAPL | Stock | 2.5468 | 2.5571 | 2.5429 | 2.5514 | 14912772.0 |
| 2005-12-16 09:55:00 | AAPL | Stock | 2.5514 | 2.5589 | 2.5489 | 2.5575 | 9040444.0 |
| 2005-12-16 10:00:00 | AAPL | Stock | 2.5579 | 2.5629 | 2.5546 | 2.5579 | 8581020.0 |
| 2005-12-16 10:05:00 | AAPL | Stock | 2.5579 | 2.5589 | 2.5543 | 2.5568 | 4892860.0 |
| 2005-12-16 10:10:00 | AAPL | Stock | 2.5561 | 2.5614 | 2.5557 | 2.5582 | 4474596.0 |
| 2005-12-16 10:15:00 | AAPL | Stock | 2.5575 | 2.5593 | 2.5539 | 2.5579 | 4352852.0 |
| 2005-12-16 10:20:00 | AAPL | Stock | 2.5579 | 2.5604 | 2.5568 | 2.5579 | 2609012.0 |
| 2005-12-16 10:25:00 | AAPL | Stock | 2.5586 | 2.5654 | 2.5571 | 2.5618 | 6538448.0 |
| 2005-12-16 10:30:00 | AAPL | Stock | 2.5618 | 2.5636 | 2.5596 | 2.5607 | 2434712.0 |
| 2005-12-16 10:35:00 | AAPL | Stock | 2.5607 | 2.5632 | 2.5596 | 2.5621 | 2761192.0 |
| 2005-12-16 10:40:00 | AAPL | Stock | 2.5623 | 2.5654 | 2.5611 | 2.5639 | 2230088.0 |
| 2005-12-16 10:45:00 | AAPL | Stock | 2.5636 | 2.5671 | 2.5625 | 2.565 | 3474464.0 |
| 2005-12-16 10:50:00 | AAPL | Stock | 2.5654 | 2.5693 | 2.5643 | 2.5693 | 2882348.0 |
| 2005-12-16 10:55:00 | AAPL | Stock | 2.5679 | 2.5689 | 2.5607 | 2.5624 | 3748304.0 |
| 2005-12-16 11:00:00 | AAPL | Stock | 2.5625 | 2.5654 | 2.5625 | 2.565 | 5570516.0 |
| 2005-12-16 11:05:00 | AAPL | Stock | 2.5646 | 2.5682 | 2.5643 | 2.565 | 2978360.0 |
| 2005-12-16 11:10:00 | AAPL | Stock | 2.565 | 2.5743 | 2.5625 | 2.5743 | 7938560.0 |
| 2005-12-16 11:15:00 | AAPL | Stock | 2.5743 | 2.58 | 2.5739 | 2.5779 | 5852168.0 |
| 2005-12-16 11:20:00 | AAPL | Stock | 2.5771 | 2.5771 | 2.5746 | 2.5757 | 3003420.0 |
| 2005-12-16 11:25:00 | AAPL | Stock | 2.5764 | 2.5786 | 2.5739 | 2.5739 | 4512088.0 |
| 2005-12-16 11:30:00 | AAPL | Stock | 2.5739 | 2.5739 | 2.5682 | 2.5711 | 5374544.0 |
| 2005-12-16 11:35:00 | AAPL | Stock | 2.5711 | 2.575 | 2.5696 | 2.5714 | 2930452.0 |
| 2005-12-16 11:40:00 | AAPL | Stock | 2.5711 | 2.5725 | 2.5686 | 2.57 | 2368660.0 |
| 2005-12-16 11:45:00 | AAPL | Stock | 2.5696 | 2.5704 | 2.5621 | 2.5632 | 6609344.0 |
| 2005-12-16 11:50:00 | AAPL | Stock | 2.5636 | 2.5671 | 2.5621 | 2.5668 | 3788568.0 |
| 2005-12-16 11:55:00 | AAPL | Stock | 2.5668 | 2.5711 | 2.5646 | 2.5707 | 3608836.0 |
| 2005-12-16 12:00:00 | AAPL | Stock | 2.5696 | 2.5736 | 2.5689 | 2.5729 | 3034948.0 |
> showing 50 of 216,389 rows — these rows as CSV