PREVIEW / stock_5min / 2007-06-21
file: by_date/stock_5min/2007/2007-06-21.parquet size: 4.0 MB rows: 296,363 symbols: 3,051
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 |
|---|---|---|---|---|---|---|---|
| 2007-06-21 09:30:00 | AAPL | Stock | 4.3464 | 4.3675 | 4.3436 | 4.3614 | 23888256.0 |
| 2007-06-21 09:35:00 | AAPL | Stock | 4.3636 | 4.3689 | 4.3314 | 4.3332 | 23899288.0 |
| 2007-06-21 09:40:00 | AAPL | Stock | 4.3336 | 4.3432 | 4.3114 | 4.3142 | 26608596.0 |
| 2007-06-21 09:45:00 | AAPL | Stock | 4.3139 | 4.3514 | 4.3139 | 4.3457 | 18833416.0 |
| 2007-06-21 09:50:00 | AAPL | Stock | 4.3457 | 4.3579 | 4.3418 | 4.3468 | 14225204.0 |
| 2007-06-21 09:55:00 | AAPL | Stock | 4.3461 | 4.3511 | 4.3218 | 4.3329 | 15315048.0 |
| 2007-06-21 10:00:00 | AAPL | Stock | 4.3324 | 4.3611 | 4.3324 | 4.3582 | 20065192.0 |
| 2007-06-21 10:05:00 | AAPL | Stock | 4.3579 | 4.3721 | 4.3504 | 4.3715 | 19337052.0 |
| 2007-06-21 10:10:00 | AAPL | Stock | 4.3721 | 4.3721 | 4.3536 | 4.3614 | 14839916.0 |
| 2007-06-21 10:15:00 | AAPL | Stock | 4.3614 | 4.3875 | 4.3607 | 4.3857 | 20938204.0 |
| 2007-06-21 10:20:00 | AAPL | Stock | 4.3857 | 4.39 | 4.3732 | 4.3811 | 15765344.0 |
| 2007-06-21 10:25:00 | AAPL | Stock | 4.3811 | 4.3929 | 4.3807 | 4.3889 | 16582356.0 |
| 2007-06-21 10:30:00 | AAPL | Stock | 4.3889 | 4.3946 | 4.3814 | 4.3879 | 15545964.0 |
| 2007-06-21 10:35:00 | AAPL | Stock | 4.3879 | 4.4018 | 4.3807 | 4.3996 | 17687376.0 |
| 2007-06-21 10:40:00 | AAPL | Stock | 4.3996 | 4.4107 | 4.3971 | 4.4009 | 19493656.0 |
| 2007-06-21 10:45:00 | AAPL | Stock | 4.4004 | 4.4143 | 4.3936 | 4.4143 | 15281364.0 |
| 2007-06-21 10:50:00 | AAPL | Stock | 4.4143 | 4.4286 | 4.4096 | 4.4257 | 27866300.0 |
| 2007-06-21 10:55:00 | AAPL | Stock | 4.4254 | 4.4325 | 4.4218 | 4.4257 | 18046924.0 |
| 2007-06-21 11:00:00 | AAPL | Stock | 4.4247 | 4.4389 | 4.4246 | 4.4332 | 19195596.0 |
| 2007-06-21 11:05:00 | AAPL | Stock | 4.4332 | 4.4364 | 4.4218 | 4.4243 | 17300640.0 |
| 2007-06-21 11:10:00 | AAPL | Stock | 4.425 | 4.4321 | 4.4161 | 4.4193 | 16573452.0 |
| 2007-06-21 11:15:00 | AAPL | Stock | 4.42 | 4.4229 | 4.4107 | 4.4229 | 13685840.0 |
| 2007-06-21 11:20:00 | AAPL | Stock | 4.4229 | 4.4257 | 4.4196 | 4.4225 | 12148556.0 |
| 2007-06-21 11:25:00 | AAPL | Stock | 4.4221 | 4.4257 | 4.4168 | 4.4257 | 7107996.0 |
| 2007-06-21 11:30:00 | AAPL | Stock | 4.4261 | 4.4261 | 4.4064 | 4.4111 | 9992332.0 |
| 2007-06-21 11:35:00 | AAPL | Stock | 4.4107 | 4.4118 | 4.4011 | 4.4089 | 10898272.0 |
| 2007-06-21 11:40:00 | AAPL | Stock | 4.4089 | 4.41 | 4.3964 | 4.4 | 8135428.0 |
| 2007-06-21 11:45:00 | AAPL | Stock | 4.4001 | 4.4096 | 4.3982 | 4.4068 | 9114084.0 |
| 2007-06-21 11:50:00 | AAPL | Stock | 4.4068 | 4.4071 | 4.3886 | 4.3921 | 11939648.0 |
| 2007-06-21 11:55:00 | AAPL | Stock | 4.3914 | 4.4043 | 4.3914 | 4.4039 | 9627576.0 |
| 2007-06-21 12:00:00 | AAPL | Stock | 4.4039 | 4.4182 | 4.4032 | 4.4153 | 14882756.0 |
| 2007-06-21 12:05:00 | AAPL | Stock | 4.4154 | 4.4179 | 4.4089 | 4.4114 | 7371140.0 |
| 2007-06-21 12:10:00 | AAPL | Stock | 4.4114 | 4.4146 | 4.4032 | 4.4032 | 6829340.0 |
| 2007-06-21 12:15:00 | AAPL | Stock | 4.4032 | 4.4082 | 4.3989 | 4.4 | 5652948.0 |
| 2007-06-21 12:20:00 | AAPL | Stock | 4.3989 | 4.4068 | 4.3961 | 4.4068 | 7764932.0 |
| 2007-06-21 12:25:00 | AAPL | Stock | 4.4064 | 4.4071 | 4.3989 | 4.4036 | 3520384.0 |
| 2007-06-21 12:30:00 | AAPL | Stock | 4.4036 | 4.4057 | 4.3964 | 4.3989 | 4921644.0 |
| 2007-06-21 12:35:00 | AAPL | Stock | 4.3989 | 4.4054 | 4.3961 | 4.405 | 6720924.0 |
| 2007-06-21 12:40:00 | AAPL | Stock | 4.4054 | 4.4104 | 4.4004 | 4.4075 | 7175504.0 |
| 2007-06-21 12:45:00 | AAPL | Stock | 4.4075 | 4.4121 | 4.4064 | 4.4104 | 6549480.0 |
| 2007-06-21 12:50:00 | AAPL | Stock | 4.4107 | 4.4154 | 4.4043 | 4.4054 | 6124300.0 |
| 2007-06-21 12:55:00 | AAPL | Stock | 4.4054 | 4.4086 | 4.4018 | 4.4046 | 4561172.0 |
| 2007-06-21 13:00:00 | AAPL | Stock | 4.4054 | 4.4121 | 4.4036 | 4.4107 | 3721760.0 |
| 2007-06-21 13:05:00 | AAPL | Stock | 4.4111 | 4.4232 | 4.4096 | 4.4189 | 9367176.0 |
| 2007-06-21 13:10:00 | AAPL | Stock | 4.4189 | 4.4196 | 4.4143 | 4.4154 | 4767224.0 |
| 2007-06-21 13:15:00 | AAPL | Stock | 4.4154 | 4.4175 | 4.4096 | 4.4141 | 7063560.0 |
| 2007-06-21 13:20:00 | AAPL | Stock | 4.4136 | 4.4171 | 4.4121 | 4.4157 | 6622420.0 |
| 2007-06-21 13:25:00 | AAPL | Stock | 4.4157 | 4.4196 | 4.4157 | 4.4179 | 6044024.0 |
| 2007-06-21 13:30:00 | AAPL | Stock | 4.4179 | 4.4232 | 4.4175 | 4.4207 | 8334228.0 |
| 2007-06-21 13:35:00 | AAPL | Stock | 4.4211 | 4.425 | 4.4161 | 4.4186 | 5986512.0 |
> showing 50 of 296,363 rows — these rows as CSV