PREVIEW / stock_1min / 2008-04-10
file: by_date/stock_1min/2008/2008-04-10.parquet size: 11.8 MB rows: 961,679 symbols: 2,676
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 |
|---|---|---|---|---|---|---|---|
| 2008-04-10 05:22:00 | AAPL | Stock | 5.4086 | 5.4086 | 5.4086 | 5.4086 | 11200.0 |
| 2008-04-10 05:30:00 | AAPL | Stock | 5.4104 | 5.4104 | 5.4104 | 5.4104 | 3220.0 |
| 2008-04-10 07:05:00 | AAPL | Stock | 5.4057 | 5.4057 | 5.4057 | 5.4057 | 8400.0 |
| 2008-04-10 07:10:00 | AAPL | Stock | 5.3939 | 5.3939 | 5.3939 | 5.3939 | 8400.0 |
| 2008-04-10 07:38:00 | AAPL | Stock | 5.4057 | 5.4104 | 5.4057 | 5.4104 | 28000.0 |
| 2008-04-10 07:39:00 | AAPL | Stock | 5.4104 | 5.4104 | 5.4104 | 5.4104 | 2800.0 |
| 2008-04-10 07:42:00 | AAPL | Stock | 5.4296 | 5.4296 | 5.4296 | 5.4296 | 5600.0 |
| 2008-04-10 07:43:00 | AAPL | Stock | 5.4193 | 5.4193 | 5.4193 | 5.4193 | 8400.0 |
| 2008-04-10 07:44:00 | AAPL | Stock | 5.4193 | 5.4264 | 5.4193 | 5.4264 | 30800.0 |
| 2008-04-10 08:00:00 | AAPL | Stock | 5.42 | 5.42 | 5.42 | 5.42 | 2800.0 |
| 2008-04-10 08:01:00 | AAPL | Stock | 5.4111 | 5.4111 | 5.4054 | 5.4054 | 31500.0 |
| 2008-04-10 08:02:00 | AAPL | Stock | 5.4082 | 5.4082 | 5.4082 | 5.4082 | 28000.0 |
| 2008-04-10 08:03:00 | AAPL | Stock | 5.4043 | 5.4043 | 5.3993 | 5.3993 | 11200.0 |
| 2008-04-10 08:04:00 | AAPL | Stock | 5.3989 | 5.3989 | 5.3989 | 5.3989 | 14000.0 |
| 2008-04-10 08:05:00 | AAPL | Stock | 5.4 | 5.4 | 5.3843 | 5.3843 | 156940.0 |
| 2008-04-10 08:06:00 | AAPL | Stock | 5.3839 | 5.3839 | 5.3811 | 5.3821 | 84000.0 |
| 2008-04-10 08:07:00 | AAPL | Stock | 5.3839 | 5.3839 | 5.3839 | 5.3839 | 2800.0 |
| 2008-04-10 08:08:00 | AAPL | Stock | 5.3857 | 5.3857 | 5.3793 | 5.3821 | 119280.0 |
| 2008-04-10 08:09:00 | AAPL | Stock | 5.3768 | 5.3789 | 5.3768 | 5.3789 | 28840.0 |
| 2008-04-10 08:10:00 | AAPL | Stock | 5.3818 | 5.3818 | 5.3818 | 5.3818 | 2800.0 |
| 2008-04-10 08:11:00 | AAPL | Stock | 5.3804 | 5.3825 | 5.3804 | 5.3821 | 84476.0 |
| 2008-04-10 08:12:00 | AAPL | Stock | 5.3854 | 5.3893 | 5.3854 | 5.3893 | 27524.0 |
| 2008-04-10 08:13:00 | AAPL | Stock | 5.3893 | 5.3893 | 5.3893 | 5.3893 | 14476.0 |
| 2008-04-10 08:15:00 | AAPL | Stock | 5.3864 | 5.3864 | 5.3839 | 5.3857 | 49000.0 |
| 2008-04-10 08:16:00 | AAPL | Stock | 5.3825 | 5.3879 | 5.3825 | 5.3864 | 22400.0 |
| 2008-04-10 08:17:00 | AAPL | Stock | 5.3911 | 5.3911 | 5.3875 | 5.3875 | 86800.0 |
| 2008-04-10 08:19:00 | AAPL | Stock | 5.3864 | 5.3868 | 5.3864 | 5.3868 | 8400.0 |
| 2008-04-10 08:20:00 | AAPL | Stock | 5.3886 | 5.3886 | 5.3886 | 5.3886 | 22400.0 |
| 2008-04-10 08:21:00 | AAPL | Stock | 5.3875 | 5.3911 | 5.3875 | 5.3911 | 100576.0 |
| 2008-04-10 08:22:00 | AAPL | Stock | 5.3936 | 5.3936 | 5.3932 | 5.3932 | 5600.0 |
| 2008-04-10 08:23:00 | AAPL | Stock | 5.3893 | 5.3893 | 5.3893 | 5.3893 | 5040.0 |
| 2008-04-10 08:24:00 | AAPL | Stock | 5.3893 | 5.3893 | 5.3879 | 5.3879 | 10640.0 |
| 2008-04-10 08:25:00 | AAPL | Stock | 5.3875 | 5.3875 | 5.3857 | 5.3857 | 25900.0 |
| 2008-04-10 08:26:00 | AAPL | Stock | 5.3857 | 5.3871 | 5.3839 | 5.3871 | 42000.0 |
| 2008-04-10 08:27:00 | AAPL | Stock | 5.3857 | 5.3857 | 5.3839 | 5.3857 | 30800.0 |
| 2008-04-10 08:28:00 | AAPL | Stock | 5.3807 | 5.3807 | 5.3771 | 5.38 | 53816.0 |
| 2008-04-10 08:29:00 | AAPL | Stock | 5.3871 | 5.3893 | 5.3871 | 5.3893 | 16996.0 |
| 2008-04-10 08:30:00 | AAPL | Stock | 5.3911 | 5.4071 | 5.3896 | 5.3896 | 405244.0 |
| 2008-04-10 08:31:00 | AAPL | Stock | 5.3893 | 5.3904 | 5.3861 | 5.3864 | 177324.0 |
| 2008-04-10 08:32:00 | AAPL | Stock | 5.3864 | 5.3896 | 5.3864 | 5.3871 | 35000.0 |
| 2008-04-10 08:33:00 | AAPL | Stock | 5.3879 | 5.3914 | 5.3861 | 5.3875 | 69748.0 |
| 2008-04-10 08:34:00 | AAPL | Stock | 5.3875 | 5.3925 | 5.3857 | 5.3857 | 106400.0 |
| 2008-04-10 08:38:00 | AAPL | Stock | 5.3871 | 5.3889 | 5.3871 | 5.3889 | 18536.0 |
| 2008-04-10 08:39:00 | AAPL | Stock | 5.3918 | 5.3918 | 5.3918 | 5.3918 | 14000.0 |
| 2008-04-10 08:40:00 | AAPL | Stock | 5.3921 | 5.3964 | 5.3921 | 5.3964 | 70000.0 |
| 2008-04-10 08:41:00 | AAPL | Stock | 5.3996 | 5.3996 | 5.3957 | 5.3964 | 36288.0 |
| 2008-04-10 08:42:00 | AAPL | Stock | 5.3964 | 5.4025 | 5.3964 | 5.4007 | 88032.0 |
| 2008-04-10 08:43:00 | AAPL | Stock | 5.4004 | 5.4036 | 5.3986 | 5.3986 | 28000.0 |
| 2008-04-10 08:44:00 | AAPL | Stock | 5.3982 | 5.3982 | 5.3982 | 5.3982 | 14000.0 |
| 2008-04-10 08:45:00 | AAPL | Stock | 5.3954 | 5.3954 | 5.3929 | 5.3929 | 42000.0 |
> showing 50 of 961,679 rows — these rows as CSV