PREVIEW / stock_5min / 2010-09-28
file: by_date/stock_5min/2010/2010-09-28.parquet size: 4.8 MB rows: 327,003 symbols: 3,480
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-28 05:55:00 | AAPL | Stock | 10.4196 | 10.4196 | 10.4196 | 10.4196 | 14000.0 |
| 2010-09-28 06:20:00 | AAPL | Stock | 10.4393 | 10.4393 | 10.4393 | 10.4393 | 2800.0 |
| 2010-09-28 06:25:00 | AAPL | Stock | 10.4321 | 10.4321 | 10.4321 | 10.4321 | 2800.0 |
| 2010-09-28 06:35:00 | AAPL | Stock | 10.4211 | 10.4211 | 10.4211 | 10.4211 | 10500.0 |
| 2010-09-28 07:00:00 | AAPL | Stock | 10.4286 | 10.4321 | 10.4286 | 10.4286 | 59920.0 |
| 2010-09-28 07:05:00 | AAPL | Stock | 10.4321 | 10.4393 | 10.4321 | 10.4321 | 22400.0 |
| 2010-09-28 07:10:00 | AAPL | Stock | 10.4321 | 10.4321 | 10.4321 | 10.4321 | 4900.0 |
| 2010-09-28 07:20:00 | AAPL | Stock | 10.4286 | 10.4286 | 10.4286 | 10.4286 | 8400.0 |
| 2010-09-28 07:25:00 | AAPL | Stock | 10.4021 | 10.4021 | 10.4018 | 10.4018 | 8400.0 |
| 2010-09-28 07:30:00 | AAPL | Stock | 10.4054 | 10.4054 | 10.4054 | 10.4054 | 2800.0 |
| 2010-09-28 07:40:00 | AAPL | Stock | 10.4018 | 10.4093 | 10.3939 | 10.3982 | 36400.0 |
| 2010-09-28 07:45:00 | AAPL | Stock | 10.4014 | 10.4036 | 10.4014 | 10.4036 | 11200.0 |
| 2010-09-28 07:50:00 | AAPL | Stock | 10.4 | 10.4018 | 10.4 | 10.4018 | 14000.0 |
| 2010-09-28 07:55:00 | AAPL | Stock | 10.4096 | 10.4096 | 10.4018 | 10.4018 | 19600.0 |
| 2010-09-28 08:00:00 | AAPL | Stock | 10.4121 | 10.4286 | 10.4071 | 10.4179 | 352352.0 |
| 2010-09-28 08:05:00 | AAPL | Stock | 10.4214 | 10.4329 | 10.4214 | 10.4268 | 263284.0 |
| 2010-09-28 08:10:00 | AAPL | Stock | 10.4232 | 10.4321 | 10.4232 | 10.4282 | 161896.0 |
| 2010-09-28 08:15:00 | AAPL | Stock | 10.4254 | 10.4254 | 10.4089 | 10.4175 | 249648.0 |
| 2010-09-28 08:20:00 | AAPL | Stock | 10.4179 | 10.4264 | 10.4107 | 10.4196 | 528528.0 |
| 2010-09-28 08:25:00 | AAPL | Stock | 10.4154 | 10.4189 | 10.4107 | 10.4186 | 143500.0 |
| 2010-09-28 08:30:00 | AAPL | Stock | 10.4186 | 10.4196 | 10.4143 | 10.4196 | 68012.0 |
| 2010-09-28 08:35:00 | AAPL | Stock | 10.4179 | 10.4179 | 10.41 | 10.4107 | 156016.0 |
| 2010-09-28 08:40:00 | AAPL | Stock | 10.4107 | 10.4132 | 10.4057 | 10.4086 | 108024.0 |
| 2010-09-28 08:45:00 | AAPL | Stock | 10.4089 | 10.4271 | 10.4054 | 10.4271 | 184716.0 |
| 2010-09-28 08:50:00 | AAPL | Stock | 10.43 | 10.4332 | 10.4196 | 10.4332 | 248584.0 |
| 2010-09-28 08:55:00 | AAPL | Stock | 10.4314 | 10.4375 | 10.425 | 10.4268 | 314636.0 |
| 2010-09-28 09:00:00 | AAPL | Stock | 10.425 | 10.4268 | 10.4229 | 10.4243 | 116900.0 |
| 2010-09-28 09:05:00 | AAPL | Stock | 10.4264 | 10.4264 | 10.4225 | 10.4261 | 103600.0 |
| 2010-09-28 09:10:00 | AAPL | Stock | 10.4261 | 10.4264 | 10.4229 | 10.4236 | 105840.0 |
| 2010-09-28 09:15:00 | AAPL | Stock | 10.4254 | 10.4282 | 10.425 | 10.4254 | 139664.0 |
| 2010-09-28 09:20:00 | AAPL | Stock | 10.4236 | 10.4268 | 10.4236 | 10.4257 | 50400.0 |
| 2010-09-28 09:25:00 | AAPL | Stock | 10.425 | 10.4282 | 10.4179 | 10.4179 | 561708.0 |
| 2010-09-28 09:30:00 | AAPL | Stock | 10.4182 | 10.4204 | 9.8214 | 10.2164 | 141307600.0 |
| 2010-09-28 09:35:00 | AAPL | Stock | 10.2161 | 10.2421 | 10.1543 | 10.1889 | 46160408.0 |
| 2010-09-28 09:40:00 | AAPL | Stock | 10.1889 | 10.2425 | 10.1804 | 10.205 | 30721096.0 |
| 2010-09-28 09:45:00 | AAPL | Stock | 10.2021 | 10.2036 | 10.1221 | 10.1346 | 39432288.0 |
| 2010-09-28 09:50:00 | AAPL | Stock | 10.1336 | 10.2104 | 10.1321 | 10.1771 | 23908668.0 |
| 2010-09-28 09:55:00 | AAPL | Stock | 10.1786 | 10.2086 | 10.1579 | 10.1796 | 16293480.0 |
| 2010-09-28 10:00:00 | AAPL | Stock | 10.1782 | 10.1857 | 10.1064 | 10.1589 | 35883904.0 |
| 2010-09-28 10:05:00 | AAPL | Stock | 10.1564 | 10.1714 | 10.0875 | 10.1204 | 22931020.0 |
| 2010-09-28 10:10:00 | AAPL | Stock | 10.1189 | 10.1411 | 10.1064 | 10.1407 | 13490512.0 |
| 2010-09-28 10:15:00 | AAPL | Stock | 10.141 | 10.1429 | 10.1186 | 10.1282 | 12984020.0 |
| 2010-09-28 10:20:00 | AAPL | Stock | 10.1271 | 10.1625 | 10.1136 | 10.1571 | 17568292.0 |
| 2010-09-28 10:25:00 | AAPL | Stock | 10.1579 | 10.2021 | 10.1579 | 10.1891 | 20880692.0 |
| 2010-09-28 10:30:00 | AAPL | Stock | 10.1882 | 10.2293 | 10.1786 | 10.2143 | 21450492.0 |
| 2010-09-28 10:35:00 | AAPL | Stock | 10.2157 | 10.235 | 10.1989 | 10.2257 | 12191172.0 |
| 2010-09-28 10:40:00 | AAPL | Stock | 10.225 | 10.2479 | 10.2229 | 10.2411 | 13813548.0 |
| 2010-09-28 10:45:00 | AAPL | Stock | 10.2407 | 10.2757 | 10.2379 | 10.2418 | 19041680.0 |
| 2010-09-28 10:50:00 | AAPL | Stock | 10.2425 | 10.27 | 10.2421 | 10.2593 | 11271624.0 |
| 2010-09-28 10:55:00 | AAPL | Stock | 10.26 | 10.3157 | 10.2589 | 10.3154 | 18668552.0 |
> showing 50 of 327,003 rows — these rows as CSV