PREVIEW / stock_5min / 2006-09-11
file: by_date/stock_5min/2006/2006-09-11.parquet size: 3.1 MB rows: 222,627 symbols: 2,353
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-09-11 06:35:00 | AAPL | Stock | 2.5875 | 2.5875 | 2.5861 | 2.5861 | 57400.0 |
| 2006-09-11 06:40:00 | AAPL | Stock | 2.5821 | 2.5821 | 2.5804 | 2.5804 | 23800.0 |
| 2006-09-11 07:00:00 | AAPL | Stock | 2.5807 | 2.5807 | 2.5807 | 2.5807 | 2800.0 |
| 2006-09-11 07:05:00 | AAPL | Stock | 2.585 | 2.585 | 2.5804 | 2.5807 | 32200.0 |
| 2006-09-11 07:25:00 | AAPL | Stock | 2.5854 | 2.5854 | 2.5854 | 2.5854 | 2800.0 |
| 2006-09-11 07:40:00 | AAPL | Stock | 2.59 | 2.59 | 2.59 | 2.59 | 2800.0 |
| 2006-09-11 07:45:00 | AAPL | Stock | 2.59 | 2.59 | 2.59 | 2.59 | 25200.0 |
| 2006-09-11 07:55:00 | AAPL | Stock | 2.5921 | 2.5939 | 2.5921 | 2.5939 | 44800.0 |
| 2006-09-11 08:00:00 | AAPL | Stock | 2.5896 | 2.595 | 2.5893 | 2.5921 | 852880.0 |
| 2006-09-11 08:05:00 | AAPL | Stock | 2.5886 | 2.5896 | 2.5839 | 2.5857 | 248248.0 |
| 2006-09-11 08:10:00 | AAPL | Stock | 2.5839 | 2.5839 | 2.5807 | 2.5836 | 181160.0 |
| 2006-09-11 08:15:00 | AAPL | Stock | 2.5893 | 2.5911 | 2.5843 | 2.5868 | 238112.0 |
| 2006-09-11 08:20:00 | AAPL | Stock | 2.5868 | 2.5882 | 2.5843 | 2.5846 | 43288.0 |
| 2006-09-11 08:25:00 | AAPL | Stock | 2.5839 | 2.585 | 2.5811 | 2.5811 | 78400.0 |
| 2006-09-11 08:30:00 | AAPL | Stock | 2.5807 | 2.5839 | 2.5804 | 2.5804 | 409360.0 |
| 2006-09-11 08:35:00 | AAPL | Stock | 2.5839 | 2.585 | 2.5821 | 2.5843 | 183204.0 |
| 2006-09-11 08:40:00 | AAPL | Stock | 2.5821 | 2.5857 | 2.5821 | 2.5821 | 188216.0 |
| 2006-09-11 08:45:00 | AAPL | Stock | 2.5829 | 2.5868 | 2.5829 | 2.5868 | 44632.0 |
| 2006-09-11 08:50:00 | AAPL | Stock | 2.5875 | 2.5918 | 2.5875 | 2.5893 | 101780.0 |
| 2006-09-11 08:55:00 | AAPL | Stock | 2.5911 | 2.5936 | 2.5911 | 2.5925 | 101640.0 |
| 2006-09-11 09:00:00 | AAPL | Stock | 2.5936 | 2.5989 | 2.5929 | 2.5929 | 927640.0 |
| 2006-09-11 09:05:00 | AAPL | Stock | 2.5971 | 2.605 | 2.5971 | 2.6007 | 685832.0 |
| 2006-09-11 09:10:00 | AAPL | Stock | 2.6007 | 2.6036 | 2.5996 | 2.6 | 466788.0 |
| 2006-09-11 09:15:00 | AAPL | Stock | 2.5996 | 2.5996 | 2.5964 | 2.5968 | 217000.0 |
| 2006-09-11 09:20:00 | AAPL | Stock | 2.5982 | 2.5986 | 2.5929 | 2.5929 | 81200.0 |
| 2006-09-11 09:25:00 | AAPL | Stock | 2.5921 | 2.5943 | 2.5864 | 2.5868 | 731164.0 |
| 2006-09-11 09:30:00 | AAPL | Stock | 2.5868 | 2.6025 | 2.5832 | 2.5925 | 25377912.0 |
| 2006-09-11 09:35:00 | AAPL | Stock | 2.5925 | 2.5943 | 2.5771 | 2.5803 | 27760292.0 |
| 2006-09-11 09:40:00 | AAPL | Stock | 2.5804 | 2.5889 | 2.5786 | 2.5821 | 16653000.0 |
| 2006-09-11 09:45:00 | AAPL | Stock | 2.5818 | 2.5825 | 2.5743 | 2.5786 | 14744072.0 |
| 2006-09-11 09:50:00 | AAPL | Stock | 2.5782 | 2.5793 | 2.5714 | 2.5764 | 15562764.0 |
| 2006-09-11 09:55:00 | AAPL | Stock | 2.5771 | 2.5818 | 2.5736 | 2.5811 | 13160028.0 |
| 2006-09-11 10:00:00 | AAPL | Stock | 2.5807 | 2.5832 | 2.5761 | 2.5825 | 10254496.0 |
| 2006-09-11 10:05:00 | AAPL | Stock | 2.5821 | 2.5861 | 2.5736 | 2.5739 | 15807008.0 |
| 2006-09-11 10:10:00 | AAPL | Stock | 2.5739 | 2.5779 | 2.5714 | 2.5754 | 11375896.0 |
| 2006-09-11 10:15:00 | AAPL | Stock | 2.5754 | 2.5757 | 2.5632 | 2.5654 | 21580244.0 |
| 2006-09-11 10:20:00 | AAPL | Stock | 2.5657 | 2.575 | 2.5643 | 2.5714 | 12003124.0 |
| 2006-09-11 10:25:00 | AAPL | Stock | 2.5714 | 2.5715 | 2.5589 | 2.5596 | 11680900.0 |
| 2006-09-11 10:30:00 | AAPL | Stock | 2.5593 | 2.5643 | 2.5554 | 2.5589 | 15110536.0 |
| 2006-09-11 10:35:00 | AAPL | Stock | 2.5589 | 2.5639 | 2.5564 | 2.5593 | 8057588.0 |
| 2006-09-11 10:40:00 | AAPL | Stock | 2.5593 | 2.5596 | 2.5554 | 2.5571 | 8739304.0 |
| 2006-09-11 10:45:00 | AAPL | Stock | 2.5568 | 2.56 | 2.5532 | 2.5557 | 10336256.0 |
| 2006-09-11 10:50:00 | AAPL | Stock | 2.555 | 2.5586 | 2.5507 | 2.5571 | 13773536.0 |
| 2006-09-11 10:55:00 | AAPL | Stock | 2.5571 | 2.5604 | 2.5557 | 2.5596 | 10171028.0 |
| 2006-09-11 11:00:00 | AAPL | Stock | 2.5593 | 2.5618 | 2.5575 | 2.5593 | 7565992.0 |
| 2006-09-11 11:05:00 | AAPL | Stock | 2.5589 | 2.5589 | 2.5554 | 2.5568 | 5795776.0 |
| 2006-09-11 11:10:00 | AAPL | Stock | 2.5568 | 2.5661 | 2.5557 | 2.5632 | 9988356.0 |
| 2006-09-11 11:15:00 | AAPL | Stock | 2.5636 | 2.5707 | 2.5629 | 2.5671 | 13617744.0 |
| 2006-09-11 11:20:00 | AAPL | Stock | 2.5675 | 2.5746 | 2.5668 | 2.5689 | 13836508.0 |
| 2006-09-11 11:25:00 | AAPL | Stock | 2.5689 | 2.5757 | 2.5671 | 2.5739 | 15779092.0 |
> showing 50 of 222,627 rows — these rows as CSV