PREVIEW / stock_5min / 2010-01-19
file: by_date/stock_5min/2010/2010-01-19.parquet size: 4.8 MB rows: 329,039 symbols: 3,467
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-01-19 04:20:00 | AAPL | Stock | 7.4446 | 7.4446 | 7.42 | 7.42 | 5600.0 |
| 2010-01-19 04:25:00 | AAPL | Stock | 7.4214 | 7.4214 | 7.4214 | 7.4214 | 2800.0 |
| 2010-01-19 04:30:00 | AAPL | Stock | 7.4286 | 7.4286 | 7.4286 | 7.4286 | 7420.0 |
| 2010-01-19 04:45:00 | AAPL | Stock | 7.4289 | 7.4289 | 7.4289 | 7.4289 | 2800.0 |
| 2010-01-19 05:00:00 | AAPL | Stock | 7.42 | 7.42 | 7.42 | 7.42 | 5600.0 |
| 2010-01-19 05:05:00 | AAPL | Stock | 7.42 | 7.42 | 7.3982 | 7.3982 | 7420.0 |
| 2010-01-19 05:20:00 | AAPL | Stock | 7.4107 | 7.4107 | 7.4107 | 7.4107 | 2800.0 |
| 2010-01-19 05:25:00 | AAPL | Stock | 7.4114 | 7.4114 | 7.4114 | 7.4114 | 2800.0 |
| 2010-01-19 05:35:00 | AAPL | Stock | 7.4057 | 7.4057 | 7.4057 | 7.4057 | 5600.0 |
| 2010-01-19 06:00:00 | AAPL | Stock | 7.4057 | 7.4057 | 7.4057 | 7.4057 | 5068.0 |
| 2010-01-19 06:05:00 | AAPL | Stock | 7.4057 | 7.4057 | 7.4057 | 7.4057 | 22400.0 |
| 2010-01-19 06:10:00 | AAPL | Stock | 7.4021 | 7.4021 | 7.4021 | 7.4021 | 2800.0 |
| 2010-01-19 06:15:00 | AAPL | Stock | 7.4107 | 7.4139 | 7.4107 | 7.4139 | 10360.0 |
| 2010-01-19 06:30:00 | AAPL | Stock | 7.4021 | 7.4021 | 7.4021 | 7.4021 | 8400.0 |
| 2010-01-19 07:00:00 | AAPL | Stock | 7.4154 | 7.4154 | 7.4107 | 7.4107 | 42000.0 |
| 2010-01-19 07:10:00 | AAPL | Stock | 7.4107 | 7.4107 | 7.4107 | 7.4107 | 5600.0 |
| 2010-01-19 07:20:00 | AAPL | Stock | 7.4071 | 7.4071 | 7.4068 | 7.4068 | 11200.0 |
| 2010-01-19 07:25:00 | AAPL | Stock | 7.4071 | 7.4071 | 7.4011 | 7.4057 | 15400.0 |
| 2010-01-19 07:30:00 | AAPL | Stock | 7.4007 | 7.4107 | 7.4007 | 7.4107 | 78764.0 |
| 2010-01-19 07:35:00 | AAPL | Stock | 7.4143 | 7.4196 | 7.4129 | 7.4196 | 39200.0 |
| 2010-01-19 07:40:00 | AAPL | Stock | 7.4189 | 7.4386 | 7.4189 | 7.4304 | 50960.0 |
| 2010-01-19 07:45:00 | AAPL | Stock | 7.4304 | 7.4304 | 7.4214 | 7.4214 | 133812.0 |
| 2010-01-19 07:50:00 | AAPL | Stock | 7.4143 | 7.4146 | 7.4143 | 7.4143 | 56000.0 |
| 2010-01-19 07:55:00 | AAPL | Stock | 7.4257 | 7.4261 | 7.4093 | 7.4093 | 89040.0 |
| 2010-01-19 08:00:00 | AAPL | Stock | 7.4107 | 7.4161 | 7.3546 | 7.3807 | 983612.0 |
| 2010-01-19 08:05:00 | AAPL | Stock | 7.3855 | 7.3968 | 7.3855 | 7.3968 | 204204.0 |
| 2010-01-19 08:10:00 | AAPL | Stock | 7.3971 | 7.4007 | 7.3964 | 7.3989 | 188412.0 |
| 2010-01-19 08:15:00 | AAPL | Stock | 7.4014 | 7.405 | 7.4 | 7.4036 | 121968.0 |
| 2010-01-19 08:20:00 | AAPL | Stock | 7.4036 | 7.4107 | 7.4018 | 7.4021 | 193536.0 |
| 2010-01-19 08:25:00 | AAPL | Stock | 7.4079 | 7.4079 | 7.3986 | 7.3989 | 138460.0 |
| 2010-01-19 08:30:00 | AAPL | Stock | 7.4 | 7.4079 | 7.3929 | 7.4043 | 326284.0 |
| 2010-01-19 08:35:00 | AAPL | Stock | 7.4046 | 7.4207 | 7.4036 | 7.415 | 520688.0 |
| 2010-01-19 08:40:00 | AAPL | Stock | 7.415 | 7.4214 | 7.4057 | 7.4179 | 202020.0 |
| 2010-01-19 08:45:00 | AAPL | Stock | 7.4207 | 7.4261 | 7.4164 | 7.425 | 366240.0 |
| 2010-01-19 08:50:00 | AAPL | Stock | 7.425 | 7.4286 | 7.4214 | 7.425 | 393932.0 |
| 2010-01-19 08:55:00 | AAPL | Stock | 7.425 | 7.425 | 7.4054 | 7.415 | 155596.0 |
| 2010-01-19 09:00:00 | AAPL | Stock | 7.4096 | 7.4196 | 7.4082 | 7.4161 | 117320.0 |
| 2010-01-19 09:05:00 | AAPL | Stock | 7.4189 | 7.4193 | 7.3957 | 7.4179 | 158956.0 |
| 2010-01-19 09:10:00 | AAPL | Stock | 7.4171 | 7.4246 | 7.4171 | 7.4246 | 206024.0 |
| 2010-01-19 09:15:00 | AAPL | Stock | 7.4264 | 7.4264 | 7.4193 | 7.4232 | 86240.0 |
| 2010-01-19 09:20:00 | AAPL | Stock | 7.4196 | 7.425 | 7.4196 | 7.4214 | 41412.0 |
| 2010-01-19 09:25:00 | AAPL | Stock | 7.4207 | 7.4429 | 7.4196 | 7.4404 | 964740.0 |
| 2010-01-19 09:30:00 | AAPL | Stock | 7.4418 | 7.4804 | 7.4014 | 7.4571 | 27172628.0 |
| 2010-01-19 09:35:00 | AAPL | Stock | 7.4593 | 7.4893 | 7.4525 | 7.4861 | 16027620.0 |
| 2010-01-19 09:40:00 | AAPL | Stock | 7.4857 | 7.4932 | 7.4675 | 7.47 | 12314708.0 |
| 2010-01-19 09:45:00 | AAPL | Stock | 7.4689 | 7.4982 | 7.4689 | 7.49 | 13537552.0 |
| 2010-01-19 09:50:00 | AAPL | Stock | 7.49 | 7.5193 | 7.4896 | 7.5179 | 17520328.0 |
| 2010-01-19 09:55:00 | AAPL | Stock | 7.5179 | 7.5368 | 7.5084 | 7.5268 | 15687252.0 |
| 2010-01-19 10:00:00 | AAPL | Stock | 7.5268 | 7.5561 | 7.5268 | 7.5536 | 16834132.0 |
| 2010-01-19 10:05:00 | AAPL | Stock | 7.555 | 7.5621 | 7.5412 | 7.5461 | 17537968.0 |
> showing 50 of 329,039 rows — these rows as CSV