PREVIEW / stock_1min / 2009-02-18
file: by_date/stock_1min/2009/2009-02-18.parquet size: 12.4 MB rows: 960,603 symbols: 2,698
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-02-18 06:56:00 | AAPL | Stock | 3.3918 | 3.3918 | 3.3918 | 3.3918 | 2800.0 |
| 2009-02-18 07:41:00 | AAPL | Stock | 3.3893 | 3.3893 | 3.3893 | 3.3893 | 56000.0 |
| 2009-02-18 08:03:00 | AAPL | Stock | 3.3839 | 3.3839 | 3.3829 | 3.3829 | 19040.0 |
| 2009-02-18 08:05:00 | AAPL | Stock | 3.3829 | 3.3829 | 3.375 | 3.375 | 47600.0 |
| 2009-02-18 08:06:00 | AAPL | Stock | 3.375 | 3.375 | 3.375 | 3.375 | 36400.0 |
| 2009-02-18 08:13:00 | AAPL | Stock | 3.3875 | 3.3875 | 3.3875 | 3.3875 | 5600.0 |
| 2009-02-18 08:31:00 | AAPL | Stock | 3.3875 | 3.3886 | 3.3875 | 3.3886 | 15400.0 |
| 2009-02-18 08:32:00 | AAPL | Stock | 3.3889 | 3.3893 | 3.3889 | 3.3893 | 19600.0 |
| 2009-02-18 08:33:00 | AAPL | Stock | 3.3818 | 3.3818 | 3.3818 | 3.3818 | 2800.0 |
| 2009-02-18 08:35:00 | AAPL | Stock | 3.3871 | 3.3871 | 3.3871 | 3.3871 | 2800.0 |
| 2009-02-18 08:39:00 | AAPL | Stock | 3.3871 | 3.3871 | 3.3871 | 3.3871 | 5600.0 |
| 2009-02-18 08:41:00 | AAPL | Stock | 3.3871 | 3.3882 | 3.3871 | 3.3882 | 42000.0 |
| 2009-02-18 08:42:00 | AAPL | Stock | 3.3875 | 3.3929 | 3.3875 | 3.3929 | 87836.0 |
| 2009-02-18 08:43:00 | AAPL | Stock | 3.3982 | 3.3982 | 3.3893 | 3.395 | 35000.0 |
| 2009-02-18 08:44:00 | AAPL | Stock | 3.3964 | 3.3964 | 3.3964 | 3.3964 | 19600.0 |
| 2009-02-18 08:45:00 | AAPL | Stock | 3.3964 | 3.3964 | 3.3964 | 3.3964 | 7000.0 |
| 2009-02-18 08:46:00 | AAPL | Stock | 3.3936 | 3.3936 | 3.3932 | 3.3932 | 11200.0 |
| 2009-02-18 08:47:00 | AAPL | Stock | 3.3943 | 3.3982 | 3.3929 | 3.3982 | 32900.0 |
| 2009-02-18 08:49:00 | AAPL | Stock | 3.3982 | 3.3982 | 3.3982 | 3.3982 | 28000.0 |
| 2009-02-18 08:50:00 | AAPL | Stock | 3.4029 | 3.4032 | 3.4029 | 3.4032 | 16800.0 |
| 2009-02-18 08:51:00 | AAPL | Stock | 3.4036 | 3.4046 | 3.4032 | 3.4046 | 29400.0 |
| 2009-02-18 08:52:00 | AAPL | Stock | 3.4032 | 3.4032 | 3.4032 | 3.4032 | 26208.0 |
| 2009-02-18 08:53:00 | AAPL | Stock | 3.4029 | 3.4029 | 3.4029 | 3.4029 | 4592.0 |
| 2009-02-18 08:55:00 | AAPL | Stock | 3.3982 | 3.3982 | 3.3982 | 3.3982 | 2800.0 |
| 2009-02-18 08:56:00 | AAPL | Stock | 3.3982 | 3.3982 | 3.3982 | 3.3982 | 52080.0 |
| 2009-02-18 09:01:00 | AAPL | Stock | 3.4029 | 3.4029 | 3.4029 | 3.4029 | 8400.0 |
| 2009-02-18 09:03:00 | AAPL | Stock | 3.4054 | 3.4054 | 3.4054 | 3.4054 | 28000.0 |
| 2009-02-18 09:04:00 | AAPL | Stock | 3.4061 | 3.4061 | 3.4061 | 3.4061 | 13300.0 |
| 2009-02-18 09:05:00 | AAPL | Stock | 3.4061 | 3.4061 | 3.4061 | 3.4061 | 2800.0 |
| 2009-02-18 09:07:00 | AAPL | Stock | 3.4061 | 3.4068 | 3.4061 | 3.4064 | 41524.0 |
| 2009-02-18 09:08:00 | AAPL | Stock | 3.4057 | 3.4057 | 3.4054 | 3.4054 | 11200.0 |
| 2009-02-18 09:09:00 | AAPL | Stock | 3.4057 | 3.4079 | 3.4057 | 3.4079 | 77084.0 |
| 2009-02-18 09:10:00 | AAPL | Stock | 3.4093 | 3.4093 | 3.4071 | 3.4079 | 33600.0 |
| 2009-02-18 09:11:00 | AAPL | Stock | 3.4079 | 3.41 | 3.4079 | 3.41 | 58800.0 |
| 2009-02-18 09:12:00 | AAPL | Stock | 3.4086 | 3.4104 | 3.4086 | 3.4104 | 6916.0 |
| 2009-02-18 09:13:00 | AAPL | Stock | 3.4107 | 3.4114 | 3.4054 | 3.4054 | 275800.0 |
| 2009-02-18 09:14:00 | AAPL | Stock | 3.4054 | 3.4054 | 3.4021 | 3.4021 | 66472.0 |
| 2009-02-18 09:17:00 | AAPL | Stock | 3.4061 | 3.4061 | 3.4036 | 3.4054 | 25200.0 |
| 2009-02-18 09:18:00 | AAPL | Stock | 3.4057 | 3.4057 | 3.4057 | 3.4057 | 2800.0 |
| 2009-02-18 09:19:00 | AAPL | Stock | 3.4036 | 3.4036 | 3.4036 | 3.4036 | 7000.0 |
| 2009-02-18 09:20:00 | AAPL | Stock | 3.3968 | 3.3982 | 3.3946 | 3.3982 | 22428.0 |
| 2009-02-18 09:21:00 | AAPL | Stock | 3.3968 | 3.3968 | 3.3925 | 3.3925 | 146384.0 |
| 2009-02-18 09:22:00 | AAPL | Stock | 3.3929 | 3.3929 | 3.3925 | 3.3929 | 57008.0 |
| 2009-02-18 09:23:00 | AAPL | Stock | 3.3929 | 3.3982 | 3.3929 | 3.3929 | 14392.0 |
| 2009-02-18 09:24:00 | AAPL | Stock | 3.3929 | 3.3932 | 3.3929 | 3.3929 | 51604.0 |
| 2009-02-18 09:26:00 | AAPL | Stock | 3.3929 | 3.3929 | 3.3929 | 3.3929 | 5600.0 |
| 2009-02-18 09:27:00 | AAPL | Stock | 3.3982 | 3.3982 | 3.3982 | 3.3982 | 4200.0 |
| 2009-02-18 09:29:00 | AAPL | Stock | 3.3971 | 3.4011 | 3.3971 | 3.4011 | 5600.0 |
| 2009-02-18 09:30:00 | AAPL | Stock | 3.3946 | 3.4093 | 3.3786 | 3.3814 | 3192868.0 |
| 2009-02-18 09:31:00 | AAPL | Stock | 3.3814 | 3.3918 | 3.38 | 3.3882 | 2076788.0 |
> showing 50 of 960,603 rows — these rows as CSV