PREVIEW / stock_5min / 2007-09-28
file: by_date/stock_5min/2007/2007-09-28.parquet size: 4.1 MB rows: 303,543 symbols: 3,128
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 |
|---|---|---|---|---|---|---|---|
| 2007-09-28 05:50:00 | AAPL | Stock | 5.4911 | 5.4911 | 5.4911 | 5.4911 | 2800.0 |
| 2007-09-28 06:05:00 | AAPL | Stock | 5.5107 | 5.5107 | 5.5107 | 5.5107 | 28000.0 |
| 2007-09-28 06:45:00 | AAPL | Stock | 5.5007 | 5.5007 | 5.5007 | 5.5007 | 14000.0 |
| 2007-09-28 06:55:00 | AAPL | Stock | 5.4893 | 5.4893 | 5.4893 | 5.4893 | 11200.0 |
| 2007-09-28 07:00:00 | AAPL | Stock | 5.4893 | 5.4893 | 5.4868 | 5.4868 | 42000.0 |
| 2007-09-28 07:05:00 | AAPL | Stock | 5.4821 | 5.4821 | 5.4821 | 5.4821 | 41664.0 |
| 2007-09-28 07:10:00 | AAPL | Stock | 5.4846 | 5.4846 | 5.4846 | 5.4846 | 2800.0 |
| 2007-09-28 07:20:00 | AAPL | Stock | 5.4821 | 5.4821 | 5.4821 | 5.4821 | 28000.0 |
| 2007-09-28 07:30:00 | AAPL | Stock | 5.4911 | 5.4929 | 5.4911 | 5.4929 | 44800.0 |
| 2007-09-28 07:35:00 | AAPL | Stock | 5.4929 | 5.4929 | 5.4929 | 5.4929 | 11200.0 |
| 2007-09-28 07:40:00 | AAPL | Stock | 5.4911 | 5.4929 | 5.4911 | 5.4929 | 35700.0 |
| 2007-09-28 07:45:00 | AAPL | Stock | 5.4943 | 5.4946 | 5.4943 | 5.4946 | 7700.0 |
| 2007-09-28 07:50:00 | AAPL | Stock | 5.4946 | 5.4946 | 5.4946 | 5.4946 | 28000.0 |
| 2007-09-28 07:55:00 | AAPL | Stock | 5.4907 | 5.495 | 5.4907 | 5.495 | 58100.0 |
| 2007-09-28 08:00:00 | AAPL | Stock | 5.4929 | 5.4929 | 5.4786 | 5.4839 | 990164.0 |
| 2007-09-28 08:05:00 | AAPL | Stock | 5.4861 | 5.4943 | 5.4857 | 5.4893 | 466564.0 |
| 2007-09-28 08:10:00 | AAPL | Stock | 5.4893 | 5.4893 | 5.4846 | 5.4846 | 442064.0 |
| 2007-09-28 08:15:00 | AAPL | Stock | 5.4854 | 5.4868 | 5.4804 | 5.4804 | 597100.0 |
| 2007-09-28 08:20:00 | AAPL | Stock | 5.4804 | 5.4804 | 5.4757 | 5.4796 | 328636.0 |
| 2007-09-28 08:25:00 | AAPL | Stock | 5.4786 | 5.4786 | 5.4729 | 5.4786 | 746900.0 |
| 2007-09-28 08:30:00 | AAPL | Stock | 5.4786 | 5.4857 | 5.4714 | 5.4857 | 801472.0 |
| 2007-09-28 08:35:00 | AAPL | Stock | 5.4843 | 5.4893 | 5.4807 | 5.4857 | 303604.0 |
| 2007-09-28 08:40:00 | AAPL | Stock | 5.4864 | 5.4868 | 5.4821 | 5.4821 | 92680.0 |
| 2007-09-28 08:45:00 | AAPL | Stock | 5.4825 | 5.4882 | 5.4825 | 5.4857 | 103880.0 |
| 2007-09-28 08:50:00 | AAPL | Stock | 5.4857 | 5.4857 | 5.4804 | 5.4804 | 174524.0 |
| 2007-09-28 08:55:00 | AAPL | Stock | 5.4804 | 5.4818 | 5.4768 | 5.4793 | 300776.0 |
| 2007-09-28 09:00:00 | AAPL | Stock | 5.4771 | 5.4793 | 5.475 | 5.4786 | 174300.0 |
| 2007-09-28 09:05:00 | AAPL | Stock | 5.4786 | 5.4811 | 5.4757 | 5.4796 | 217644.0 |
| 2007-09-28 09:10:00 | AAPL | Stock | 5.4814 | 5.4911 | 5.4807 | 5.4893 | 373744.0 |
| 2007-09-28 09:15:00 | AAPL | Stock | 5.4893 | 5.4896 | 5.4821 | 5.4857 | 114800.0 |
| 2007-09-28 09:20:00 | AAPL | Stock | 5.4882 | 5.4889 | 5.4857 | 5.4857 | 70784.0 |
| 2007-09-28 09:25:00 | AAPL | Stock | 5.4839 | 5.4857 | 5.475 | 5.4771 | 455392.0 |
| 2007-09-28 09:30:00 | AAPL | Stock | 5.4771 | 5.4868 | 5.4554 | 5.4757 | 27169016.0 |
| 2007-09-28 09:35:00 | AAPL | Stock | 5.4732 | 5.4921 | 5.4675 | 5.4796 | 21242004.0 |
| 2007-09-28 09:40:00 | AAPL | Stock | 5.4807 | 5.4929 | 5.4696 | 5.4911 | 15823416.0 |
| 2007-09-28 09:45:00 | AAPL | Stock | 5.4911 | 5.4968 | 5.4854 | 5.4864 | 12087264.0 |
| 2007-09-28 09:50:00 | AAPL | Stock | 5.4864 | 5.5125 | 5.4832 | 5.5089 | 16369808.0 |
| 2007-09-28 09:55:00 | AAPL | Stock | 5.5071 | 5.5082 | 5.4875 | 5.4896 | 12369308.0 |
| 2007-09-28 10:00:00 | AAPL | Stock | 5.4896 | 5.5021 | 5.4857 | 5.4914 | 11132996.0 |
| 2007-09-28 10:05:00 | AAPL | Stock | 5.4918 | 5.4943 | 5.4736 | 5.4746 | 10703336.0 |
| 2007-09-28 10:10:00 | AAPL | Stock | 5.4746 | 5.4911 | 5.4693 | 5.4862 | 9918412.0 |
| 2007-09-28 10:15:00 | AAPL | Stock | 5.4861 | 5.4875 | 5.4732 | 5.4736 | 10617432.0 |
| 2007-09-28 10:20:00 | AAPL | Stock | 5.4739 | 5.49 | 5.4725 | 5.4871 | 10123848.0 |
| 2007-09-28 10:25:00 | AAPL | Stock | 5.4875 | 5.4882 | 5.4793 | 5.4839 | 7831768.0 |
| 2007-09-28 10:30:00 | AAPL | Stock | 5.4839 | 5.4857 | 5.4732 | 5.4811 | 9241792.0 |
| 2007-09-28 10:35:00 | AAPL | Stock | 5.4811 | 5.4893 | 5.4793 | 5.4821 | 8669304.0 |
| 2007-09-28 10:40:00 | AAPL | Stock | 5.4825 | 5.4925 | 5.4789 | 5.4921 | 8753724.0 |
| 2007-09-28 10:45:00 | AAPL | Stock | 5.4921 | 5.4921 | 5.4821 | 5.4874 | 6063736.0 |
| 2007-09-28 10:50:00 | AAPL | Stock | 5.4868 | 5.4936 | 5.4868 | 5.4896 | 6398056.0 |
| 2007-09-28 10:55:00 | AAPL | Stock | 5.4893 | 5.4893 | 5.4825 | 5.4876 | 5471200.0 |
> showing 50 of 303,543 rows — these rows as CSV