PREVIEW / stock_5min / 2005-03-09
file: by_date/stock_5min/2005/2005-03-09.parquet size: 2.7 MB rows: 196,769 symbols: 1,934
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 |
|---|---|---|---|---|---|---|---|
| 2005-03-09 08:00:00 | AAPL | Stock | 1.4521 | 1.4529 | 1.4461 | 1.4496 | 507192.0 |
| 2005-03-09 08:05:00 | AAPL | Stock | 1.4496 | 1.4525 | 1.4496 | 1.45 | 256788.0 |
| 2005-03-09 08:10:00 | AAPL | Stock | 1.4496 | 1.45 | 1.4329 | 1.4411 | 345688.0 |
| 2005-03-09 08:15:00 | AAPL | Stock | 1.4411 | 1.4414 | 1.4346 | 1.4368 | 392000.0 |
| 2005-03-09 08:20:00 | AAPL | Stock | 1.4364 | 1.4375 | 1.4325 | 1.4339 | 736876.0 |
| 2005-03-09 08:25:00 | AAPL | Stock | 1.4325 | 1.4336 | 1.4268 | 1.4268 | 1320900.0 |
| 2005-03-09 08:30:00 | AAPL | Stock | 1.4261 | 1.4264 | 1.4196 | 1.4196 | 933800.0 |
| 2005-03-09 08:35:00 | AAPL | Stock | 1.4196 | 1.4196 | 1.4114 | 1.4161 | 2263296.0 |
| 2005-03-09 08:40:00 | AAPL | Stock | 1.4139 | 1.4157 | 1.4071 | 1.4075 | 1744932.0 |
| 2005-03-09 08:45:00 | AAPL | Stock | 1.4071 | 1.4468 | 1.4 | 1.4018 | 2245208.0 |
| 2005-03-09 08:50:00 | AAPL | Stock | 1.4004 | 1.4157 | 1.4004 | 1.4143 | 2029020.0 |
| 2005-03-09 08:55:00 | AAPL | Stock | 1.4143 | 1.4143 | 1.4071 | 1.4086 | 883428.0 |
| 2005-03-09 09:00:00 | AAPL | Stock | 1.4086 | 1.4193 | 1.4086 | 1.4132 | 502376.0 |
| 2005-03-09 09:05:00 | AAPL | Stock | 1.4132 | 1.4207 | 1.4111 | 1.4175 | 933100.0 |
| 2005-03-09 09:10:00 | AAPL | Stock | 1.4154 | 1.4196 | 1.415 | 1.4154 | 722708.0 |
| 2005-03-09 09:15:00 | AAPL | Stock | 1.4157 | 1.4239 | 1.4157 | 1.4196 | 960736.0 |
| 2005-03-09 09:20:00 | AAPL | Stock | 1.4196 | 1.4279 | 1.4175 | 1.4196 | 1920800.0 |
| 2005-03-09 09:25:00 | AAPL | Stock | 1.4286 | 1.4464 | 1.4125 | 1.4146 | 5381320.0 |
| 2005-03-09 09:30:00 | AAPL | Stock | 1.4157 | 1.4386 | 1.3914 | 1.4093 | 107422056.0 |
| 2005-03-09 09:35:00 | AAPL | Stock | 1.4079 | 1.4211 | 1.4079 | 1.4211 | 48679232.0 |
| 2005-03-09 09:40:00 | AAPL | Stock | 1.4211 | 1.4211 | 1.4118 | 1.415 | 26400864.0 |
| 2005-03-09 09:45:00 | AAPL | Stock | 1.4154 | 1.4175 | 1.4086 | 1.4104 | 22301440.0 |
| 2005-03-09 09:50:00 | AAPL | Stock | 1.4104 | 1.4129 | 1.4075 | 1.4118 | 29210104.0 |
| 2005-03-09 09:55:00 | AAPL | Stock | 1.4121 | 1.4143 | 1.4036 | 1.4046 | 24225376.0 |
| 2005-03-09 10:00:00 | AAPL | Stock | 1.4039 | 1.4179 | 1.4018 | 1.4025 | 27862576.0 |
| 2005-03-09 10:05:00 | AAPL | Stock | 1.4021 | 1.4089 | 1.3921 | 1.3925 | 40961844.0 |
| 2005-03-09 10:10:00 | AAPL | Stock | 1.3925 | 1.3982 | 1.3868 | 1.3982 | 59366104.0 |
| 2005-03-09 10:15:00 | AAPL | Stock | 1.3982 | 1.4054 | 1.3929 | 1.4014 | 33098464.0 |
| 2005-03-09 10:20:00 | AAPL | Stock | 1.4018 | 1.4107 | 1.4011 | 1.4071 | 30401700.0 |
| 2005-03-09 10:25:00 | AAPL | Stock | 1.4079 | 1.4129 | 1.4064 | 1.4125 | 25893476.0 |
| 2005-03-09 10:30:00 | AAPL | Stock | 1.4132 | 1.42 | 1.4107 | 1.4125 | 30546712.0 |
| 2005-03-09 10:35:00 | AAPL | Stock | 1.4121 | 1.4175 | 1.41 | 1.4146 | 16367876.0 |
| 2005-03-09 10:40:00 | AAPL | Stock | 1.4143 | 1.4157 | 1.4093 | 1.4139 | 14739844.0 |
| 2005-03-09 10:45:00 | AAPL | Stock | 1.4132 | 1.4243 | 1.4125 | 1.4243 | 19145784.0 |
| 2005-03-09 10:50:00 | AAPL | Stock | 1.4243 | 1.4282 | 1.4214 | 1.4257 | 29824984.0 |
| 2005-03-09 10:55:00 | AAPL | Stock | 1.4257 | 1.4296 | 1.4196 | 1.4229 | 30323328.0 |
| 2005-03-09 11:00:00 | AAPL | Stock | 1.4232 | 1.4246 | 1.42 | 1.4239 | 10466624.0 |
| 2005-03-09 11:05:00 | AAPL | Stock | 1.4236 | 1.4246 | 1.4225 | 1.4229 | 10896228.0 |
| 2005-03-09 11:10:00 | AAPL | Stock | 1.4229 | 1.425 | 1.4179 | 1.4218 | 14287616.0 |
| 2005-03-09 11:15:00 | AAPL | Stock | 1.4211 | 1.4218 | 1.4161 | 1.4204 | 10284904.0 |
| 2005-03-09 11:20:00 | AAPL | Stock | 1.4207 | 1.4221 | 1.4171 | 1.4204 | 7838852.0 |
| 2005-03-09 11:25:00 | AAPL | Stock | 1.4207 | 1.4211 | 1.4146 | 1.4146 | 7138516.0 |
| 2005-03-09 11:30:00 | AAPL | Stock | 1.415 | 1.4161 | 1.4107 | 1.4146 | 11438644.0 |
| 2005-03-09 11:35:00 | AAPL | Stock | 1.4143 | 1.4154 | 1.4107 | 1.4121 | 8737316.0 |
| 2005-03-09 11:40:00 | AAPL | Stock | 1.4121 | 1.4125 | 1.4054 | 1.4064 | 12665044.0 |
| 2005-03-09 11:45:00 | AAPL | Stock | 1.4068 | 1.4139 | 1.4064 | 1.4111 | 11006464.0 |
| 2005-03-09 11:50:00 | AAPL | Stock | 1.4114 | 1.4118 | 1.4096 | 1.4111 | 5191396.0 |
| 2005-03-09 11:55:00 | AAPL | Stock | 1.4111 | 1.4121 | 1.4089 | 1.4089 | 6047132.0 |
| 2005-03-09 12:00:00 | AAPL | Stock | 1.4089 | 1.4093 | 1.4004 | 1.4004 | 17526740.0 |
| 2005-03-09 12:05:00 | AAPL | Stock | 1.4007 | 1.4064 | 1.3964 | 1.3968 | 17203004.0 |
> showing 50 of 196,769 rows — these rows as CSV