PREVIEW / stock_1min / 2010-09-24
file: by_date/stock_1min/2010/2010-09-24.parquet size: 12.5 MB rows: 938,457 symbols: 2,824
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 |
|---|---|---|---|---|---|---|---|
| 2010-09-24 06:16:00 | AAPL | Stock | 10.3557 | 10.3557 | 10.3557 | 10.3557 | 2800.0 |
| 2010-09-24 06:17:00 | AAPL | Stock | 10.3554 | 10.3554 | 10.3554 | 10.3554 | 2800.0 |
| 2010-09-24 06:38:00 | AAPL | Stock | 10.3557 | 10.3557 | 10.3554 | 10.3557 | 11200.0 |
| 2010-09-24 06:49:00 | AAPL | Stock | 10.3554 | 10.3554 | 10.3554 | 10.3554 | 2800.0 |
| 2010-09-24 07:02:00 | AAPL | Stock | 10.3557 | 10.3557 | 10.3557 | 10.3557 | 11200.0 |
| 2010-09-24 07:04:00 | AAPL | Stock | 10.3661 | 10.3661 | 10.3661 | 10.3661 | 4256.0 |
| 2010-09-24 07:06:00 | AAPL | Stock | 10.3661 | 10.3661 | 10.3661 | 10.3661 | 2800.0 |
| 2010-09-24 07:11:00 | AAPL | Stock | 10.375 | 10.375 | 10.375 | 10.375 | 2800.0 |
| 2010-09-24 07:19:00 | AAPL | Stock | 10.3743 | 10.3743 | 10.3743 | 10.3743 | 5600.0 |
| 2010-09-24 07:24:00 | AAPL | Stock | 10.3743 | 10.3743 | 10.3743 | 10.3743 | 2800.0 |
| 2010-09-24 07:26:00 | AAPL | Stock | 10.3743 | 10.3743 | 10.3743 | 10.3743 | 5600.0 |
| 2010-09-24 07:29:00 | AAPL | Stock | 10.3743 | 10.375 | 10.3743 | 10.375 | 35000.0 |
| 2010-09-24 07:31:00 | AAPL | Stock | 10.375 | 10.375 | 10.375 | 10.375 | 5600.0 |
| 2010-09-24 07:32:00 | AAPL | Stock | 10.3746 | 10.3746 | 10.3746 | 10.3746 | 4480.0 |
| 2010-09-24 07:33:00 | AAPL | Stock | 10.375 | 10.375 | 10.375 | 10.375 | 5600.0 |
| 2010-09-24 07:34:00 | AAPL | Stock | 10.375 | 10.375 | 10.375 | 10.375 | 5600.0 |
| 2010-09-24 07:35:00 | AAPL | Stock | 10.3718 | 10.3718 | 10.3679 | 10.3679 | 17920.0 |
| 2010-09-24 07:37:00 | AAPL | Stock | 10.3775 | 10.3775 | 10.3775 | 10.3775 | 5600.0 |
| 2010-09-24 07:38:00 | AAPL | Stock | 10.3771 | 10.3775 | 10.3768 | 10.3775 | 28840.0 |
| 2010-09-24 07:39:00 | AAPL | Stock | 10.3889 | 10.3889 | 10.3786 | 10.3786 | 39200.0 |
| 2010-09-24 07:46:00 | AAPL | Stock | 10.3693 | 10.3693 | 10.3693 | 10.3693 | 2800.0 |
| 2010-09-24 07:52:00 | AAPL | Stock | 10.3871 | 10.3871 | 10.3868 | 10.3868 | 14000.0 |
| 2010-09-24 08:00:00 | AAPL | Stock | 10.375 | 10.3904 | 10.37 | 10.3904 | 293664.0 |
| 2010-09-24 08:01:00 | AAPL | Stock | 10.3893 | 10.4018 | 10.3893 | 10.3971 | 154840.0 |
| 2010-09-24 08:02:00 | AAPL | Stock | 10.3989 | 10.3993 | 10.3946 | 10.3964 | 35000.0 |
| 2010-09-24 08:03:00 | AAPL | Stock | 10.3979 | 10.4018 | 10.3971 | 10.4018 | 98560.0 |
| 2010-09-24 08:04:00 | AAPL | Stock | 10.4018 | 10.4061 | 10.4011 | 10.4061 | 66640.0 |
| 2010-09-24 08:05:00 | AAPL | Stock | 10.4018 | 10.4054 | 10.4 | 10.4 | 29960.0 |
| 2010-09-24 08:06:00 | AAPL | Stock | 10.4011 | 10.4043 | 10.3946 | 10.4043 | 45360.0 |
| 2010-09-24 08:07:00 | AAPL | Stock | 10.405 | 10.4057 | 10.4021 | 10.4021 | 62300.0 |
| 2010-09-24 08:08:00 | AAPL | Stock | 10.4046 | 10.4057 | 10.4036 | 10.4054 | 67844.0 |
| 2010-09-24 08:09:00 | AAPL | Stock | 10.4054 | 10.4061 | 10.4018 | 10.4018 | 131180.0 |
| 2010-09-24 08:10:00 | AAPL | Stock | 10.4029 | 10.4043 | 10.4 | 10.4043 | 75656.0 |
| 2010-09-24 08:11:00 | AAPL | Stock | 10.4032 | 10.4039 | 10.4032 | 10.4032 | 30800.0 |
| 2010-09-24 08:12:00 | AAPL | Stock | 10.4036 | 10.4068 | 10.4036 | 10.4068 | 33880.0 |
| 2010-09-24 08:13:00 | AAPL | Stock | 10.4068 | 10.4129 | 10.4064 | 10.4129 | 140700.0 |
| 2010-09-24 08:14:00 | AAPL | Stock | 10.4107 | 10.4168 | 10.4107 | 10.4129 | 88760.0 |
| 2010-09-24 08:15:00 | AAPL | Stock | 10.4129 | 10.4129 | 10.41 | 10.41 | 29540.0 |
| 2010-09-24 08:16:00 | AAPL | Stock | 10.4107 | 10.4161 | 10.4107 | 10.4161 | 82152.0 |
| 2010-09-24 08:17:00 | AAPL | Stock | 10.4136 | 10.4164 | 10.4136 | 10.4164 | 43120.0 |
| 2010-09-24 08:18:00 | AAPL | Stock | 10.4164 | 10.4164 | 10.4118 | 10.4146 | 160440.0 |
| 2010-09-24 08:19:00 | AAPL | Stock | 10.4129 | 10.4182 | 10.4111 | 10.4129 | 105336.0 |
| 2010-09-24 08:20:00 | AAPL | Stock | 10.4164 | 10.4193 | 10.4146 | 10.4161 | 181692.0 |
| 2010-09-24 08:21:00 | AAPL | Stock | 10.4168 | 10.4179 | 10.4168 | 10.4179 | 15792.0 |
| 2010-09-24 08:22:00 | AAPL | Stock | 10.4161 | 10.4175 | 10.4146 | 10.4146 | 11200.0 |
| 2010-09-24 08:23:00 | AAPL | Stock | 10.4146 | 10.4193 | 10.4143 | 10.4179 | 103292.0 |
| 2010-09-24 08:24:00 | AAPL | Stock | 10.4189 | 10.4221 | 10.4179 | 10.4221 | 66640.0 |
| 2010-09-24 08:25:00 | AAPL | Stock | 10.4232 | 10.4232 | 10.4179 | 10.4179 | 165760.0 |
| 2010-09-24 08:26:00 | AAPL | Stock | 10.4161 | 10.4179 | 10.4143 | 10.4143 | 92764.0 |
| 2010-09-24 08:27:00 | AAPL | Stock | 10.4179 | 10.4243 | 10.4179 | 10.4229 | 41916.0 |
> showing 50 of 938,457 rows — these rows as CSV