PREVIEW / stock_5min / 2008-10-28
file: by_date/stock_5min/2008/2008-10-28.parquet size: 4.6 MB rows: 325,027 symbols: 3,368
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-10-28 04:15:00 | AAPL | Stock | 3.3264 | 3.4221 | 3.3264 | 3.4221 | 11200.0 |
| 2008-10-28 04:20:00 | AAPL | Stock | 3.4107 | 3.4107 | 3.4107 | 3.4107 | 5600.0 |
| 2008-10-28 05:00:00 | AAPL | Stock | 3.3857 | 3.3857 | 3.3857 | 3.3857 | 8400.0 |
| 2008-10-28 05:30:00 | AAPL | Stock | 3.3929 | 3.3929 | 3.375 | 3.375 | 25200.0 |
| 2008-10-28 05:35:00 | AAPL | Stock | 3.3929 | 3.3929 | 3.3929 | 3.3929 | 2800.0 |
| 2008-10-28 05:40:00 | AAPL | Stock | 3.3929 | 3.3929 | 3.3929 | 3.3929 | 27916.0 |
| 2008-10-28 06:00:00 | AAPL | Stock | 3.4096 | 3.4096 | 3.4096 | 3.4096 | 14000.0 |
| 2008-10-28 06:10:00 | AAPL | Stock | 3.4096 | 3.4096 | 3.4096 | 3.4096 | 5600.0 |
| 2008-10-28 06:40:00 | AAPL | Stock | 3.3661 | 3.3661 | 3.3661 | 3.3661 | 28000.0 |
| 2008-10-28 07:00:00 | AAPL | Stock | 3.4014 | 3.4107 | 3.4014 | 3.4107 | 44100.0 |
| 2008-10-28 07:05:00 | AAPL | Stock | 3.4211 | 3.4211 | 3.4211 | 3.4211 | 16800.0 |
| 2008-10-28 07:10:00 | AAPL | Stock | 3.4211 | 3.4211 | 3.4211 | 3.4211 | 58968.0 |
| 2008-10-28 07:15:00 | AAPL | Stock | 3.4211 | 3.4211 | 3.4211 | 3.4211 | 56000.0 |
| 2008-10-28 07:20:00 | AAPL | Stock | 3.4268 | 3.4286 | 3.425 | 3.4286 | 67200.0 |
| 2008-10-28 07:25:00 | AAPL | Stock | 3.4321 | 3.4321 | 3.4286 | 3.4286 | 23800.0 |
| 2008-10-28 07:30:00 | AAPL | Stock | 3.4286 | 3.4286 | 3.4146 | 3.4196 | 107800.0 |
| 2008-10-28 07:35:00 | AAPL | Stock | 3.4279 | 3.4286 | 3.4279 | 3.4286 | 19600.0 |
| 2008-10-28 07:40:00 | AAPL | Stock | 3.4321 | 3.4339 | 3.4321 | 3.4339 | 47600.0 |
| 2008-10-28 07:45:00 | AAPL | Stock | 3.4357 | 3.4357 | 3.4214 | 3.4214 | 84000.0 |
| 2008-10-28 07:50:00 | AAPL | Stock | 3.4204 | 3.4204 | 3.4196 | 3.4196 | 16800.0 |
| 2008-10-28 07:55:00 | AAPL | Stock | 3.4196 | 3.4196 | 3.3964 | 3.41 | 121800.0 |
| 2008-10-28 08:00:00 | AAPL | Stock | 3.4018 | 3.4107 | 3.3786 | 3.3857 | 1502788.0 |
| 2008-10-28 08:05:00 | AAPL | Stock | 3.385 | 3.4036 | 3.3818 | 3.3982 | 1105216.0 |
| 2008-10-28 08:10:00 | AAPL | Stock | 3.4007 | 3.4064 | 3.4 | 3.4039 | 308812.0 |
| 2008-10-28 08:15:00 | AAPL | Stock | 3.4054 | 3.4054 | 3.3975 | 3.3982 | 267736.0 |
| 2008-10-28 08:20:00 | AAPL | Stock | 3.3986 | 3.4011 | 3.3893 | 3.3904 | 432740.0 |
| 2008-10-28 08:25:00 | AAPL | Stock | 3.3911 | 3.4004 | 3.3893 | 3.3946 | 493164.0 |
| 2008-10-28 08:30:00 | AAPL | Stock | 3.3943 | 3.4011 | 3.3929 | 3.3954 | 218624.0 |
| 2008-10-28 08:35:00 | AAPL | Stock | 3.3954 | 3.3982 | 3.3889 | 3.3914 | 288624.0 |
| 2008-10-28 08:40:00 | AAPL | Stock | 3.3879 | 3.3929 | 3.3875 | 3.3929 | 294420.0 |
| 2008-10-28 08:45:00 | AAPL | Stock | 3.3932 | 3.4025 | 3.3929 | 3.4004 | 280448.0 |
| 2008-10-28 08:50:00 | AAPL | Stock | 3.3946 | 3.3982 | 3.3911 | 3.3957 | 319312.0 |
| 2008-10-28 08:55:00 | AAPL | Stock | 3.3961 | 3.3975 | 3.3929 | 3.3975 | 393512.0 |
| 2008-10-28 09:00:00 | AAPL | Stock | 3.3971 | 3.3971 | 3.395 | 3.3964 | 282380.0 |
| 2008-10-28 09:05:00 | AAPL | Stock | 3.3964 | 3.3975 | 3.3907 | 3.3929 | 787920.0 |
| 2008-10-28 09:10:00 | AAPL | Stock | 3.3925 | 3.3925 | 3.3857 | 3.3918 | 291004.0 |
| 2008-10-28 09:15:00 | AAPL | Stock | 3.3914 | 3.3971 | 3.3911 | 3.3914 | 176932.0 |
| 2008-10-28 09:20:00 | AAPL | Stock | 3.3943 | 3.3964 | 3.3893 | 3.3929 | 234192.0 |
| 2008-10-28 09:25:00 | AAPL | Stock | 3.395 | 3.4175 | 3.3896 | 3.4093 | 1573936.0 |
| 2008-10-28 09:30:00 | AAPL | Stock | 3.4086 | 3.4221 | 3.3707 | 3.3818 | 33422004.0 |
| 2008-10-28 09:35:00 | AAPL | Stock | 3.3821 | 3.3957 | 3.3671 | 3.383 | 27795572.0 |
| 2008-10-28 09:40:00 | AAPL | Stock | 3.3718 | 3.4104 | 3.3686 | 3.3943 | 26765116.0 |
| 2008-10-28 09:45:00 | AAPL | Stock | 3.3939 | 3.4286 | 3.3914 | 3.4143 | 31152380.0 |
| 2008-10-28 09:50:00 | AAPL | Stock | 3.4154 | 3.4232 | 3.3946 | 3.4164 | 24853332.0 |
| 2008-10-28 09:55:00 | AAPL | Stock | 3.4161 | 3.425 | 3.3996 | 3.4025 | 27510392.0 |
| 2008-10-28 10:00:00 | AAPL | Stock | 3.4029 | 3.4064 | 3.3625 | 3.3736 | 29709456.0 |
| 2008-10-28 10:05:00 | AAPL | Stock | 3.375 | 3.4021 | 3.375 | 3.39 | 22365196.0 |
| 2008-10-28 10:10:00 | AAPL | Stock | 3.3911 | 3.4143 | 3.3846 | 3.4021 | 19972736.0 |
| 2008-10-28 10:15:00 | AAPL | Stock | 3.4021 | 3.4039 | 3.3661 | 3.3704 | 26809412.0 |
| 2008-10-28 10:20:00 | AAPL | Stock | 3.3707 | 3.3811 | 3.3507 | 3.3589 | 25416440.0 |
> showing 50 of 325,027 rows — these rows as CSV