PREVIEW / stock_5min / 2008-04-10
file: by_date/stock_5min/2008/2008-04-10.parquet size: 4.2 MB rows: 307,414 symbols: 3,282
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:20: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:35:00 | AAPL | Stock | 5.4057 | 5.4104 | 5.4057 | 5.4104 | 30800.0 |
| 2008-04-10 07:40:00 | AAPL | Stock | 5.4296 | 5.4296 | 5.4193 | 5.4264 | 44800.0 |
| 2008-04-10 08:00:00 | AAPL | Stock | 5.42 | 5.42 | 5.3989 | 5.3989 | 87500.0 |
| 2008-04-10 08:05:00 | AAPL | Stock | 5.4 | 5.4 | 5.3768 | 5.3789 | 391860.0 |
| 2008-04-10 08:10:00 | AAPL | Stock | 5.3818 | 5.3893 | 5.3804 | 5.3893 | 129276.0 |
| 2008-04-10 08:15:00 | AAPL | Stock | 5.3864 | 5.3911 | 5.3825 | 5.3868 | 166600.0 |
| 2008-04-10 08:20:00 | AAPL | Stock | 5.3886 | 5.3936 | 5.3875 | 5.3879 | 144256.0 |
| 2008-04-10 08:25:00 | AAPL | Stock | 5.3875 | 5.3893 | 5.3771 | 5.3893 | 169512.0 |
| 2008-04-10 08:30:00 | AAPL | Stock | 5.3911 | 5.4071 | 5.3857 | 5.3857 | 793716.0 |
| 2008-04-10 08:35:00 | AAPL | Stock | 5.3871 | 5.3918 | 5.3871 | 5.3918 | 32536.0 |
| 2008-04-10 08:40:00 | AAPL | Stock | 5.3921 | 5.4036 | 5.3921 | 5.3982 | 236320.0 |
| 2008-04-10 08:45:00 | AAPL | Stock | 5.3954 | 5.4007 | 5.3929 | 5.4007 | 110712.0 |
| 2008-04-10 08:50:00 | AAPL | Stock | 5.4 | 5.4004 | 5.3929 | 5.3982 | 392000.0 |
| 2008-04-10 08:55:00 | AAPL | Stock | 5.3964 | 5.3986 | 5.395 | 5.3979 | 52276.0 |
| 2008-04-10 09:00:00 | AAPL | Stock | 5.3989 | 5.4139 | 5.3982 | 5.4107 | 209608.0 |
| 2008-04-10 09:05:00 | AAPL | Stock | 5.4071 | 5.4225 | 5.4057 | 5.4161 | 861868.0 |
| 2008-04-10 09:10:00 | AAPL | Stock | 5.4143 | 5.4204 | 5.4129 | 5.4204 | 175504.0 |
| 2008-04-10 09:15:00 | AAPL | Stock | 5.4204 | 5.4214 | 5.4157 | 5.4196 | 259252.0 |
| 2008-04-10 09:20:00 | AAPL | Stock | 5.4189 | 5.4196 | 5.4089 | 5.4089 | 674100.0 |
| 2008-04-10 09:25:00 | AAPL | Stock | 5.4064 | 5.4107 | 5.3964 | 5.3979 | 506940.0 |
| 2008-04-10 09:30:00 | AAPL | Stock | 5.3975 | 5.4379 | 5.3786 | 5.4325 | 31152912.0 |
| 2008-04-10 09:35:00 | AAPL | Stock | 5.4336 | 5.445 | 5.4193 | 5.4256 | 21582232.0 |
| 2008-04-10 09:40:00 | AAPL | Stock | 5.4255 | 5.4346 | 5.4068 | 5.4107 | 17182340.0 |
| 2008-04-10 09:45:00 | AAPL | Stock | 5.4104 | 5.4314 | 5.4054 | 5.4211 | 14070756.0 |
| 2008-04-10 09:50:00 | AAPL | Stock | 5.4214 | 5.4393 | 5.4139 | 5.4332 | 15573348.0 |
| 2008-04-10 09:55:00 | AAPL | Stock | 5.4332 | 5.4518 | 5.4246 | 5.4436 | 18178384.0 |
| 2008-04-10 10:00:00 | AAPL | Stock | 5.4436 | 5.4436 | 5.4164 | 5.4361 | 17687432.0 |
| 2008-04-10 10:05:00 | AAPL | Stock | 5.4361 | 5.4582 | 5.4325 | 5.4564 | 19887084.0 |
| 2008-04-10 10:10:00 | AAPL | Stock | 5.4561 | 5.4689 | 5.4539 | 5.465 | 20765584.0 |
| 2008-04-10 10:15:00 | AAPL | Stock | 5.465 | 5.475 | 5.4579 | 5.475 | 15776264.0 |
| 2008-04-10 10:20:00 | AAPL | Stock | 5.475 | 5.5 | 5.4682 | 5.5 | 28422716.0 |
| 2008-04-10 10:25:00 | AAPL | Stock | 5.5 | 5.5032 | 5.4857 | 5.4957 | 16721040.0 |
| 2008-04-10 10:30:00 | AAPL | Stock | 5.4957 | 5.5057 | 5.4889 | 5.4937 | 13079108.0 |
| 2008-04-10 10:35:00 | AAPL | Stock | 5.4936 | 5.4971 | 5.4779 | 5.4829 | 12135704.0 |
| 2008-04-10 10:40:00 | AAPL | Stock | 5.4839 | 5.5111 | 5.4829 | 5.5071 | 17160752.0 |
| 2008-04-10 10:45:00 | AAPL | Stock | 5.5073 | 5.5164 | 5.5014 | 5.5082 | 16001076.0 |
| 2008-04-10 10:50:00 | AAPL | Stock | 5.5075 | 5.5125 | 5.4996 | 5.5018 | 10541580.0 |
| 2008-04-10 10:55:00 | AAPL | Stock | 5.5021 | 5.5161 | 5.5014 | 5.505 | 12246024.0 |
| 2008-04-10 11:00:00 | AAPL | Stock | 5.5046 | 5.5129 | 5.4968 | 5.505 | 13024200.0 |
| 2008-04-10 11:05:00 | AAPL | Stock | 5.505 | 5.5139 | 5.5 | 5.5121 | 9538928.0 |
| 2008-04-10 11:10:00 | AAPL | Stock | 5.5121 | 5.5271 | 5.5089 | 5.5257 | 17448844.0 |
| 2008-04-10 11:15:00 | AAPL | Stock | 5.5243 | 5.5304 | 5.5168 | 5.5304 | 11006156.0 |
| 2008-04-10 11:20:00 | AAPL | Stock | 5.5304 | 5.5354 | 5.5229 | 5.5232 | 12600252.0 |
| 2008-04-10 11:25:00 | AAPL | Stock | 5.5232 | 5.5296 | 5.5161 | 5.5168 | 10764544.0 |
| 2008-04-10 11:30:00 | AAPL | Stock | 5.5168 | 5.5268 | 5.5036 | 5.5243 | 8335236.0 |
| 2008-04-10 11:35:00 | AAPL | Stock | 5.5246 | 5.5275 | 5.5168 | 5.5171 | 6706952.0 |
> showing 50 of 307,414 rows — these rows as CSV