PREVIEW / stock_5min / 2009-10-15
file: by_date/stock_5min/2009/2009-10-15.parquet size: 4.7 MB rows: 321,753 symbols: 3,384
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 |
|---|---|---|---|---|---|---|---|
| 2009-10-15 05:35:00 | AAPL | Stock | 6.8364 | 6.8364 | 6.8364 | 6.8364 | 4620.0 |
| 2009-10-15 07:00:00 | AAPL | Stock | 6.8036 | 6.8036 | 6.7871 | 6.7871 | 12600.0 |
| 2009-10-15 07:15:00 | AAPL | Stock | 6.8321 | 6.8321 | 6.8321 | 6.8321 | 5320.0 |
| 2009-10-15 07:20:00 | AAPL | Stock | 6.8079 | 6.8089 | 6.8079 | 6.8089 | 7000.0 |
| 2009-10-15 07:30:00 | AAPL | Stock | 6.8036 | 6.8036 | 6.8036 | 6.8036 | 11816.0 |
| 2009-10-15 07:50:00 | AAPL | Stock | 6.7925 | 6.7925 | 6.7925 | 6.7925 | 16800.0 |
| 2009-10-15 07:55:00 | AAPL | Stock | 6.8036 | 6.8036 | 6.7929 | 6.7929 | 27468.0 |
| 2009-10-15 08:00:00 | AAPL | Stock | 6.8036 | 6.8136 | 6.79 | 6.7968 | 169932.0 |
| 2009-10-15 08:05:00 | AAPL | Stock | 6.7968 | 6.8004 | 6.7843 | 6.7843 | 355320.0 |
| 2009-10-15 08:10:00 | AAPL | Stock | 6.7832 | 6.7943 | 6.7832 | 6.7939 | 114072.0 |
| 2009-10-15 08:15:00 | AAPL | Stock | 6.7939 | 6.7946 | 6.7857 | 6.7861 | 246540.0 |
| 2009-10-15 08:20:00 | AAPL | Stock | 6.7861 | 6.7886 | 6.7821 | 6.7821 | 182616.0 |
| 2009-10-15 08:25:00 | AAPL | Stock | 6.7821 | 6.7821 | 6.7814 | 6.7821 | 169484.0 |
| 2009-10-15 08:30:00 | AAPL | Stock | 6.7857 | 6.7896 | 6.7768 | 6.7804 | 283164.0 |
| 2009-10-15 08:35:00 | AAPL | Stock | 6.7804 | 6.7857 | 6.7793 | 6.7804 | 247856.0 |
| 2009-10-15 08:40:00 | AAPL | Stock | 6.785 | 6.7861 | 6.785 | 6.7857 | 104552.0 |
| 2009-10-15 08:45:00 | AAPL | Stock | 6.7854 | 6.7854 | 6.7818 | 6.7832 | 436604.0 |
| 2009-10-15 08:50:00 | AAPL | Stock | 6.7839 | 6.7839 | 6.7839 | 6.7839 | 81200.0 |
| 2009-10-15 08:55:00 | AAPL | Stock | 6.7839 | 6.7839 | 6.7825 | 6.7839 | 180600.0 |
| 2009-10-15 09:00:00 | AAPL | Stock | 6.7839 | 6.7839 | 6.7786 | 6.7786 | 116312.0 |
| 2009-10-15 09:05:00 | AAPL | Stock | 6.7796 | 6.7804 | 6.7782 | 6.7789 | 120820.0 |
| 2009-10-15 09:10:00 | AAPL | Stock | 6.7789 | 6.7793 | 6.7732 | 6.775 | 449064.0 |
| 2009-10-15 09:15:00 | AAPL | Stock | 6.775 | 6.775 | 6.7686 | 6.7696 | 301000.0 |
| 2009-10-15 09:20:00 | AAPL | Stock | 6.7682 | 6.7704 | 6.76 | 6.7682 | 140840.0 |
| 2009-10-15 09:25:00 | AAPL | Stock | 6.7682 | 6.7743 | 6.7664 | 6.7732 | 334376.0 |
| 2009-10-15 09:30:00 | AAPL | Stock | 6.7725 | 6.7918 | 6.7704 | 6.7829 | 9418948.0 |
| 2009-10-15 09:35:00 | AAPL | Stock | 6.7832 | 6.7907 | 6.7779 | 6.7882 | 6812512.0 |
| 2009-10-15 09:40:00 | AAPL | Stock | 6.7869 | 6.7893 | 6.7796 | 6.7796 | 5534844.0 |
| 2009-10-15 09:45:00 | AAPL | Stock | 6.7807 | 6.7857 | 6.7764 | 6.7829 | 7391916.0 |
| 2009-10-15 09:50:00 | AAPL | Stock | 6.7832 | 6.7889 | 6.7789 | 6.7864 | 5850824.0 |
| 2009-10-15 09:55:00 | AAPL | Stock | 6.7861 | 6.7914 | 6.7804 | 6.79 | 5036500.0 |
| 2009-10-15 10:00:00 | AAPL | Stock | 6.79 | 6.8096 | 6.7832 | 6.8096 | 13227396.0 |
| 2009-10-15 10:05:00 | AAPL | Stock | 6.8089 | 6.8161 | 6.8057 | 6.8143 | 6960940.0 |
| 2009-10-15 10:10:00 | AAPL | Stock | 6.8129 | 6.8186 | 6.8014 | 6.8136 | 11220524.0 |
| 2009-10-15 10:15:00 | AAPL | Stock | 6.8136 | 6.8143 | 6.8061 | 6.81 | 4080552.0 |
| 2009-10-15 10:20:00 | AAPL | Stock | 6.81 | 6.8143 | 6.8057 | 6.8079 | 4321436.0 |
| 2009-10-15 10:25:00 | AAPL | Stock | 6.8079 | 6.8096 | 6.8043 | 6.8061 | 3879008.0 |
| 2009-10-15 10:30:00 | AAPL | Stock | 6.8061 | 6.8143 | 6.805 | 6.8111 | 4238696.0 |
| 2009-10-15 10:35:00 | AAPL | Stock | 6.8114 | 6.8125 | 6.805 | 6.8064 | 5048820.0 |
| 2009-10-15 10:40:00 | AAPL | Stock | 6.8061 | 6.8064 | 6.7946 | 6.8007 | 7059528.0 |
| 2009-10-15 10:45:00 | AAPL | Stock | 6.8011 | 6.8036 | 6.7932 | 6.7932 | 3295012.0 |
| 2009-10-15 10:50:00 | AAPL | Stock | 6.7946 | 6.795 | 6.7875 | 6.7904 | 5921328.0 |
| 2009-10-15 10:55:00 | AAPL | Stock | 6.79 | 6.7907 | 6.7879 | 6.7893 | 4900196.0 |
| 2009-10-15 11:00:00 | AAPL | Stock | 6.7896 | 6.7932 | 6.7857 | 6.7925 | 6842976.0 |
| 2009-10-15 11:05:00 | AAPL | Stock | 6.7925 | 6.8 | 6.79 | 6.7907 | 3577532.0 |
| 2009-10-15 11:10:00 | AAPL | Stock | 6.7911 | 6.7979 | 6.7904 | 6.7954 | 3527328.0 |
| 2009-10-15 11:15:00 | AAPL | Stock | 6.7954 | 6.7954 | 6.7821 | 6.7854 | 5523252.0 |
| 2009-10-15 11:20:00 | AAPL | Stock | 6.785 | 6.7879 | 6.7807 | 6.7832 | 4093488.0 |
| 2009-10-15 11:25:00 | AAPL | Stock | 6.7832 | 6.7904 | 6.7814 | 6.7868 | 2477692.0 |
| 2009-10-15 11:30:00 | AAPL | Stock | 6.7864 | 6.7929 | 6.7843 | 6.7925 | 2783144.0 |
> showing 50 of 321,753 rows — these rows as CSV