PREVIEW / stock_1min / 2008-08-15
file: by_date/stock_1min/2008/2008-08-15.parquet size: 12.1 MB rows: 979,341 symbols: 2,704
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-08-15 06:35:00 | AAPL | Stock | 6.3914 | 6.3914 | 6.3914 | 6.3914 | 5600.0 |
| 2008-08-15 07:01:00 | AAPL | Stock | 6.3854 | 6.3914 | 6.3854 | 6.3914 | 30800.0 |
| 2008-08-15 07:02:00 | AAPL | Stock | 6.3971 | 6.3971 | 6.3768 | 6.3768 | 5600.0 |
| 2008-08-15 07:03:00 | AAPL | Stock | 6.3768 | 6.3846 | 6.3768 | 6.3846 | 8400.0 |
| 2008-08-15 07:04:00 | AAPL | Stock | 6.3921 | 6.3921 | 6.3921 | 6.3921 | 5600.0 |
| 2008-08-15 07:05:00 | AAPL | Stock | 6.3918 | 6.3921 | 6.3918 | 6.3921 | 11200.0 |
| 2008-08-15 07:08:00 | AAPL | Stock | 6.3643 | 6.3643 | 6.3643 | 6.3643 | 5600.0 |
| 2008-08-15 07:24:00 | AAPL | Stock | 6.3804 | 6.3804 | 6.3804 | 6.3804 | 11200.0 |
| 2008-08-15 07:30:00 | AAPL | Stock | 6.3821 | 6.3821 | 6.3821 | 6.3821 | 2800.0 |
| 2008-08-15 07:35:00 | AAPL | Stock | 6.375 | 6.375 | 6.375 | 6.375 | 28000.0 |
| 2008-08-15 07:36:00 | AAPL | Stock | 6.3821 | 6.3821 | 6.3821 | 6.3821 | 3220.0 |
| 2008-08-15 07:40:00 | AAPL | Stock | 6.3875 | 6.3875 | 6.3875 | 6.3875 | 2800.0 |
| 2008-08-15 07:41:00 | AAPL | Stock | 6.3857 | 6.3857 | 6.3857 | 6.3857 | 5600.0 |
| 2008-08-15 07:42:00 | AAPL | Stock | 6.3857 | 6.3857 | 6.3857 | 6.3857 | 2800.0 |
| 2008-08-15 07:43:00 | AAPL | Stock | 6.3857 | 6.3857 | 6.3857 | 6.3857 | 5600.0 |
| 2008-08-15 07:47:00 | AAPL | Stock | 6.3661 | 6.3661 | 6.3661 | 6.3661 | 14000.0 |
| 2008-08-15 08:00:00 | AAPL | Stock | 6.3839 | 6.3929 | 6.3821 | 6.3857 | 96684.0 |
| 2008-08-15 08:01:00 | AAPL | Stock | 6.3754 | 6.3843 | 6.3696 | 6.3696 | 31024.0 |
| 2008-08-15 08:02:00 | AAPL | Stock | 6.3786 | 6.3786 | 6.3786 | 6.3786 | 11200.0 |
| 2008-08-15 08:03:00 | AAPL | Stock | 6.37 | 6.3718 | 6.37 | 6.3718 | 8400.0 |
| 2008-08-15 08:05:00 | AAPL | Stock | 6.375 | 6.375 | 6.3732 | 6.3732 | 14700.0 |
| 2008-08-15 08:06:00 | AAPL | Stock | 6.3732 | 6.3786 | 6.3732 | 6.3786 | 19600.0 |
| 2008-08-15 08:08:00 | AAPL | Stock | 6.3875 | 6.3875 | 6.3875 | 6.3875 | 5600.0 |
| 2008-08-15 08:09:00 | AAPL | Stock | 6.3843 | 6.3875 | 6.3843 | 6.3857 | 42000.0 |
| 2008-08-15 08:10:00 | AAPL | Stock | 6.3811 | 6.3811 | 6.3811 | 6.3811 | 2800.0 |
| 2008-08-15 08:14:00 | AAPL | Stock | 6.3839 | 6.3839 | 6.3839 | 6.3839 | 2800.0 |
| 2008-08-15 08:15:00 | AAPL | Stock | 6.3839 | 6.3839 | 6.3839 | 6.3839 | 2800.0 |
| 2008-08-15 08:18:00 | AAPL | Stock | 6.3854 | 6.3857 | 6.3854 | 6.3857 | 8400.0 |
| 2008-08-15 08:19:00 | AAPL | Stock | 6.3875 | 6.3875 | 6.3875 | 6.3875 | 2800.0 |
| 2008-08-15 08:20:00 | AAPL | Stock | 6.3875 | 6.3886 | 6.3875 | 6.3886 | 5600.0 |
| 2008-08-15 08:21:00 | AAPL | Stock | 6.3889 | 6.3925 | 6.3886 | 6.3925 | 49392.0 |
| 2008-08-15 08:22:00 | AAPL | Stock | 6.3911 | 6.3925 | 6.3911 | 6.3925 | 17220.0 |
| 2008-08-15 08:23:00 | AAPL | Stock | 6.3921 | 6.3929 | 6.3921 | 6.3925 | 12600.0 |
| 2008-08-15 08:24:00 | AAPL | Stock | 6.3964 | 6.3964 | 6.3964 | 6.3964 | 11200.0 |
| 2008-08-15 08:25:00 | AAPL | Stock | 6.3982 | 6.3982 | 6.3982 | 6.3982 | 5600.0 |
| 2008-08-15 08:27:00 | AAPL | Stock | 6.395 | 6.395 | 6.395 | 6.395 | 4200.0 |
| 2008-08-15 08:28:00 | AAPL | Stock | 6.3989 | 6.4025 | 6.3982 | 6.4025 | 33600.0 |
| 2008-08-15 08:29:00 | AAPL | Stock | 6.4025 | 6.4036 | 6.4025 | 6.4025 | 30800.0 |
| 2008-08-15 08:30:00 | AAPL | Stock | 6.4043 | 6.4054 | 6.4043 | 6.4054 | 30800.0 |
| 2008-08-15 08:31:00 | AAPL | Stock | 6.4054 | 6.4054 | 6.4054 | 6.4054 | 2800.0 |
| 2008-08-15 08:32:00 | AAPL | Stock | 6.4064 | 6.4107 | 6.4064 | 6.4107 | 64680.0 |
| 2008-08-15 08:33:00 | AAPL | Stock | 6.4154 | 6.4154 | 6.4104 | 6.4104 | 25200.0 |
| 2008-08-15 08:34:00 | AAPL | Stock | 6.4125 | 6.4286 | 6.4125 | 6.4139 | 189140.0 |
| 2008-08-15 08:35:00 | AAPL | Stock | 6.4161 | 6.4243 | 6.4143 | 6.4243 | 107940.0 |
| 2008-08-15 08:36:00 | AAPL | Stock | 6.4236 | 6.4286 | 6.4236 | 6.4239 | 137956.0 |
| 2008-08-15 08:37:00 | AAPL | Stock | 6.4182 | 6.4182 | 6.4118 | 6.4118 | 28840.0 |
| 2008-08-15 08:38:00 | AAPL | Stock | 6.4168 | 6.4179 | 6.4168 | 6.4179 | 11200.0 |
| 2008-08-15 08:40:00 | AAPL | Stock | 6.4168 | 6.4204 | 6.4168 | 6.4204 | 28000.0 |
| 2008-08-15 08:41:00 | AAPL | Stock | 6.4214 | 6.4232 | 6.4204 | 6.4229 | 40880.0 |
| 2008-08-15 08:42:00 | AAPL | Stock | 6.4182 | 6.4196 | 6.4182 | 6.4196 | 5600.0 |
> showing 50 of 979,341 rows — these rows as CSV