PREVIEW / stock_5min / 2006-02-24
file: by_date/stock_5min/2006/2006-02-24.parquet size: 2.9 MB rows: 214,909 symbols: 2,187
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-02-24 04:15:00 | AAPL | Stock | 2.5457 | 2.5457 | 2.5457 | 2.5457 | 2800.0 |
| 2006-02-24 05:00:00 | AAPL | Stock | 2.5821 | 2.5821 | 2.5821 | 2.5821 | 8400.0 |
| 2006-02-24 06:35:00 | AAPL | Stock | 2.5893 | 2.5893 | 2.5893 | 2.5893 | 5600.0 |
| 2006-02-24 07:25:00 | AAPL | Stock | 2.5768 | 2.5768 | 2.5768 | 2.5768 | 2800.0 |
| 2006-02-24 07:30:00 | AAPL | Stock | 2.5804 | 2.5804 | 2.5804 | 2.5804 | 14000.0 |
| 2006-02-24 07:40:00 | AAPL | Stock | 2.5804 | 2.5804 | 2.5804 | 2.5804 | 39200.0 |
| 2006-02-24 07:45:00 | AAPL | Stock | 2.5825 | 2.5825 | 2.5825 | 2.5825 | 8400.0 |
| 2006-02-24 07:55:00 | AAPL | Stock | 2.5796 | 2.5796 | 2.5796 | 2.5796 | 2800.0 |
| 2006-02-24 08:00:00 | AAPL | Stock | 2.5829 | 2.5839 | 2.5804 | 2.5821 | 247156.0 |
| 2006-02-24 08:05:00 | AAPL | Stock | 2.5821 | 2.5839 | 2.5814 | 2.5814 | 162960.0 |
| 2006-02-24 08:10:00 | AAPL | Stock | 2.5814 | 2.5821 | 2.5814 | 2.5814 | 183400.0 |
| 2006-02-24 08:15:00 | AAPL | Stock | 2.5821 | 2.5829 | 2.5811 | 2.5811 | 352800.0 |
| 2006-02-24 08:20:00 | AAPL | Stock | 2.5814 | 2.5839 | 2.5814 | 2.5839 | 201740.0 |
| 2006-02-24 08:25:00 | AAPL | Stock | 2.5832 | 2.5843 | 2.5779 | 2.5843 | 405272.0 |
| 2006-02-24 08:30:00 | AAPL | Stock | 2.5771 | 2.5829 | 2.5771 | 2.5786 | 993580.0 |
| 2006-02-24 08:35:00 | AAPL | Stock | 2.5793 | 2.5804 | 2.575 | 2.575 | 135100.0 |
| 2006-02-24 08:40:00 | AAPL | Stock | 2.575 | 2.575 | 2.575 | 2.575 | 119084.0 |
| 2006-02-24 08:45:00 | AAPL | Stock | 2.5725 | 2.5732 | 2.57 | 2.57 | 311836.0 |
| 2006-02-24 08:50:00 | AAPL | Stock | 2.5696 | 2.5714 | 2.5661 | 2.5714 | 205408.0 |
| 2006-02-24 08:55:00 | AAPL | Stock | 2.5711 | 2.5714 | 2.5696 | 2.5696 | 86800.0 |
| 2006-02-24 09:00:00 | AAPL | Stock | 2.5693 | 2.5704 | 2.5632 | 2.5639 | 175700.0 |
| 2006-02-24 09:05:00 | AAPL | Stock | 2.5639 | 2.5664 | 2.5639 | 2.5664 | 159600.0 |
| 2006-02-24 09:10:00 | AAPL | Stock | 2.5664 | 2.5693 | 2.5661 | 2.5693 | 187096.0 |
| 2006-02-24 09:15:00 | AAPL | Stock | 2.5693 | 2.5704 | 2.5682 | 2.5686 | 95144.0 |
| 2006-02-24 09:20:00 | AAPL | Stock | 2.5689 | 2.5696 | 2.5689 | 2.5696 | 47600.0 |
| 2006-02-24 09:25:00 | AAPL | Stock | 2.5696 | 2.5789 | 2.5696 | 2.5771 | 882168.0 |
| 2006-02-24 09:30:00 | AAPL | Stock | 2.5764 | 2.5843 | 2.5696 | 2.5804 | 16186688.0 |
| 2006-02-24 09:35:00 | AAPL | Stock | 2.5804 | 2.5821 | 2.5707 | 2.5714 | 11461128.0 |
| 2006-02-24 09:40:00 | AAPL | Stock | 2.5711 | 2.5743 | 2.5643 | 2.5729 | 16496760.0 |
| 2006-02-24 09:45:00 | AAPL | Stock | 2.5729 | 2.5857 | 2.5727 | 2.5804 | 18529924.0 |
| 2006-02-24 09:50:00 | AAPL | Stock | 2.5804 | 2.5839 | 2.5754 | 2.5818 | 8114372.0 |
| 2006-02-24 09:55:00 | AAPL | Stock | 2.5818 | 2.5832 | 2.5754 | 2.5807 | 8701868.0 |
| 2006-02-24 10:00:00 | AAPL | Stock | 2.5804 | 2.5893 | 2.5804 | 2.5868 | 11248888.0 |
| 2006-02-24 10:05:00 | AAPL | Stock | 2.5868 | 2.6011 | 2.5843 | 2.6 | 20640816.0 |
| 2006-02-24 10:10:00 | AAPL | Stock | 2.6 | 2.6032 | 2.595 | 2.5961 | 15594012.0 |
| 2006-02-24 10:15:00 | AAPL | Stock | 2.5964 | 2.6011 | 2.5946 | 2.5964 | 10553956.0 |
| 2006-02-24 10:20:00 | AAPL | Stock | 2.5964 | 2.5964 | 2.5886 | 2.5904 | 12048428.0 |
| 2006-02-24 10:25:00 | AAPL | Stock | 2.5904 | 2.5936 | 2.585 | 2.585 | 7914648.0 |
| 2006-02-24 10:30:00 | AAPL | Stock | 2.5846 | 2.5904 | 2.5807 | 2.5868 | 8660624.0 |
| 2006-02-24 10:35:00 | AAPL | Stock | 2.5871 | 2.5911 | 2.5825 | 2.5839 | 7524356.0 |
| 2006-02-24 10:40:00 | AAPL | Stock | 2.5839 | 2.585 | 2.5793 | 2.5797 | 7082124.0 |
| 2006-02-24 10:45:00 | AAPL | Stock | 2.5796 | 2.5818 | 2.5732 | 2.5775 | 9279452.0 |
| 2006-02-24 10:50:00 | AAPL | Stock | 2.5771 | 2.5804 | 2.5732 | 2.58 | 8057812.0 |
| 2006-02-24 10:55:00 | AAPL | Stock | 2.5804 | 2.5804 | 2.5743 | 2.5764 | 5507516.0 |
| 2006-02-24 11:00:00 | AAPL | Stock | 2.5764 | 2.5857 | 2.5764 | 2.5854 | 8056720.0 |
| 2006-02-24 11:05:00 | AAPL | Stock | 2.5843 | 2.5875 | 2.5814 | 2.5857 | 6861456.0 |
| 2006-02-24 11:10:00 | AAPL | Stock | 2.5857 | 2.5918 | 2.5843 | 2.5881 | 6419700.0 |
| 2006-02-24 11:15:00 | AAPL | Stock | 2.5882 | 2.5893 | 2.5829 | 2.5846 | 3611468.0 |
| 2006-02-24 11:20:00 | AAPL | Stock | 2.5846 | 2.5893 | 2.5846 | 2.5889 | 2890496.0 |
| 2006-02-24 11:25:00 | AAPL | Stock | 2.5889 | 2.5893 | 2.5829 | 2.5829 | 3771432.0 |
> showing 50 of 214,909 rows — these rows as CSV