PREVIEW / stock_5min / 2004-04-13
file: by_date/stock_5min/2004/2004-04-13.parquet size: 2.5 MB rows: 175,574 symbols: 1,758
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 |
|---|---|---|---|---|---|---|---|
| 2004-04-13 08:40:00 | AAPL | Stock | 0.5034 | 0.5034 | 0.5027 | 0.5027 | 11200.0 |
| 2004-04-13 09:05:00 | AAPL | Stock | 0.5016 | 0.5016 | 0.5016 | 0.5016 | 56000.0 |
| 2004-04-13 09:15:00 | AAPL | Stock | 0.5014 | 0.5014 | 0.5009 | 0.5009 | 89600.0 |
| 2004-04-13 09:25:00 | AAPL | Stock | 0.5004 | 0.5005 | 0.4988 | 0.4991 | 496160.0 |
| 2004-04-13 09:30:00 | AAPL | Stock | 0.5 | 0.5002 | 0.497 | 0.4986 | 5576536.0 |
| 2004-04-13 09:35:00 | AAPL | Stock | 0.4989 | 0.4995 | 0.4979 | 0.4982 | 2531704.0 |
| 2004-04-13 09:40:00 | AAPL | Stock | 0.4982 | 0.4991 | 0.4982 | 0.4988 | 2228128.0 |
| 2004-04-13 09:45:00 | AAPL | Stock | 0.4988 | 0.4988 | 0.497 | 0.497 | 4032336.0 |
| 2004-04-13 09:50:00 | AAPL | Stock | 0.497 | 0.4984 | 0.4968 | 0.4984 | 4655224.0 |
| 2004-04-13 09:55:00 | AAPL | Stock | 0.4988 | 0.4993 | 0.4975 | 0.4979 | 1799952.0 |
| 2004-04-13 10:00:00 | AAPL | Stock | 0.4975 | 0.4977 | 0.4952 | 0.4952 | 1950984.0 |
| 2004-04-13 10:05:00 | AAPL | Stock | 0.4952 | 0.4952 | 0.4925 | 0.4939 | 4259528.0 |
| 2004-04-13 10:10:00 | AAPL | Stock | 0.4939 | 0.4943 | 0.4932 | 0.4932 | 4332328.0 |
| 2004-04-13 10:15:00 | AAPL | Stock | 0.4932 | 0.4946 | 0.4925 | 0.4938 | 5066600.0 |
| 2004-04-13 10:20:00 | AAPL | Stock | 0.4939 | 0.4946 | 0.4938 | 0.4946 | 1545600.0 |
| 2004-04-13 10:25:00 | AAPL | Stock | 0.4945 | 0.495 | 0.4939 | 0.4939 | 9005248.0 |
| 2004-04-13 10:30:00 | AAPL | Stock | 0.4938 | 0.4941 | 0.492 | 0.493 | 4727968.0 |
| 2004-04-13 10:35:00 | AAPL | Stock | 0.4932 | 0.4943 | 0.493 | 0.4932 | 2866528.0 |
| 2004-04-13 10:40:00 | AAPL | Stock | 0.4932 | 0.4934 | 0.493 | 0.4932 | 14672000.0 |
| 2004-04-13 10:45:00 | AAPL | Stock | 0.4932 | 0.4934 | 0.4925 | 0.4929 | 1218560.0 |
| 2004-04-13 10:50:00 | AAPL | Stock | 0.4934 | 0.4934 | 0.4875 | 0.4902 | 10236016.0 |
| 2004-04-13 10:55:00 | AAPL | Stock | 0.4897 | 0.4909 | 0.4896 | 0.4898 | 3104416.0 |
| 2004-04-13 11:00:00 | AAPL | Stock | 0.49 | 0.4904 | 0.487 | 0.4873 | 3787168.0 |
| 2004-04-13 11:05:00 | AAPL | Stock | 0.4875 | 0.488 | 0.4863 | 0.4868 | 11945696.0 |
| 2004-04-13 11:10:00 | AAPL | Stock | 0.4868 | 0.4868 | 0.4848 | 0.485 | 9552648.0 |
| 2004-04-13 11:15:00 | AAPL | Stock | 0.4848 | 0.4854 | 0.4813 | 0.4821 | 6754608.0 |
| 2004-04-13 11:20:00 | AAPL | Stock | 0.4821 | 0.4825 | 0.4796 | 0.482 | 7815696.0 |
| 2004-04-13 11:25:00 | AAPL | Stock | 0.4821 | 0.4839 | 0.4818 | 0.4819 | 5055904.0 |
| 2004-04-13 11:30:00 | AAPL | Stock | 0.4816 | 0.4834 | 0.4816 | 0.4832 | 3204936.0 |
| 2004-04-13 11:35:00 | AAPL | Stock | 0.4832 | 0.4848 | 0.4832 | 0.4834 | 3742312.0 |
| 2004-04-13 11:40:00 | AAPL | Stock | 0.4834 | 0.4873 | 0.4834 | 0.4871 | 10573640.0 |
| 2004-04-13 11:45:00 | AAPL | Stock | 0.4871 | 0.4882 | 0.487 | 0.4875 | 4387992.0 |
| 2004-04-13 11:50:00 | AAPL | Stock | 0.4875 | 0.4875 | 0.4855 | 0.4861 | 1507968.0 |
| 2004-04-13 11:55:00 | AAPL | Stock | 0.4861 | 0.4866 | 0.4855 | 0.4857 | 2154096.0 |
| 2004-04-13 12:00:00 | AAPL | Stock | 0.4859 | 0.4863 | 0.4857 | 0.4857 | 1482320.0 |
| 2004-04-13 12:05:00 | AAPL | Stock | 0.4857 | 0.4866 | 0.4857 | 0.4863 | 2337272.0 |
| 2004-04-13 12:10:00 | AAPL | Stock | 0.4864 | 0.4864 | 0.485 | 0.4855 | 4518136.0 |
| 2004-04-13 12:15:00 | AAPL | Stock | 0.4854 | 0.4864 | 0.4854 | 0.4864 | 1328264.0 |
| 2004-04-13 12:20:00 | AAPL | Stock | 0.4864 | 0.4864 | 0.4861 | 0.4861 | 1258152.0 |
| 2004-04-13 12:25:00 | AAPL | Stock | 0.4859 | 0.4859 | 0.4839 | 0.4845 | 1721272.0 |
| 2004-04-13 12:30:00 | AAPL | Stock | 0.4845 | 0.4845 | 0.4832 | 0.4845 | 3154424.0 |
| 2004-04-13 12:35:00 | AAPL | Stock | 0.4845 | 0.4845 | 0.4834 | 0.4834 | 1785224.0 |
| 2004-04-13 12:40:00 | AAPL | Stock | 0.4836 | 0.4866 | 0.4832 | 0.4866 | 2811984.0 |
| 2004-04-13 12:45:00 | AAPL | Stock | 0.4866 | 0.4866 | 0.4834 | 0.4844 | 2847488.0 |
| 2004-04-13 12:50:00 | AAPL | Stock | 0.4841 | 0.4846 | 0.4836 | 0.4843 | 967680.0 |
| 2004-04-13 12:55:00 | AAPL | Stock | 0.4848 | 0.4861 | 0.4848 | 0.4852 | 795200.0 |
| 2004-04-13 13:00:00 | AAPL | Stock | 0.4852 | 0.4866 | 0.485 | 0.4863 | 1063832.0 |
| 2004-04-13 13:05:00 | AAPL | Stock | 0.4864 | 0.4866 | 0.4854 | 0.4854 | 1517600.0 |
| 2004-04-13 13:10:00 | AAPL | Stock | 0.4857 | 0.4857 | 0.4854 | 0.4857 | 701344.0 |
| 2004-04-13 13:15:00 | AAPL | Stock | 0.4855 | 0.4859 | 0.4845 | 0.4848 | 1712816.0 |
> showing 50 of 175,574 rows — these rows as CSV