PREVIEW / stock_5min / 2005-05-24
file: by_date/stock_5min/2005/2005-05-24.parquet size: 2.6 MB rows: 193,418 symbols: 1,985
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-05-24 08:00:00 | AAPL | Stock | 1.4143 | 1.4161 | 1.4107 | 1.4107 | 336700.0 |
| 2005-05-24 08:05:00 | AAPL | Stock | 1.4107 | 1.4125 | 1.4104 | 1.4104 | 162400.0 |
| 2005-05-24 08:10:00 | AAPL | Stock | 1.4107 | 1.4107 | 1.4071 | 1.4104 | 105000.0 |
| 2005-05-24 08:15:00 | AAPL | Stock | 1.4104 | 1.4107 | 1.4093 | 1.4107 | 21000.0 |
| 2005-05-24 08:20:00 | AAPL | Stock | 1.41 | 1.4107 | 1.4093 | 1.41 | 109200.0 |
| 2005-05-24 08:25:00 | AAPL | Stock | 1.41 | 1.41 | 1.4071 | 1.4093 | 120400.0 |
| 2005-05-24 08:30:00 | AAPL | Stock | 1.4075 | 1.4114 | 1.4071 | 1.4114 | 204428.0 |
| 2005-05-24 08:35:00 | AAPL | Stock | 1.4111 | 1.4132 | 1.4107 | 1.4107 | 61880.0 |
| 2005-05-24 08:40:00 | AAPL | Stock | 1.4111 | 1.4132 | 1.4107 | 1.4111 | 191800.0 |
| 2005-05-24 08:45:00 | AAPL | Stock | 1.4125 | 1.4125 | 1.4093 | 1.4107 | 190400.0 |
| 2005-05-24 08:50:00 | AAPL | Stock | 1.4107 | 1.4107 | 1.4064 | 1.4064 | 182000.0 |
| 2005-05-24 08:55:00 | AAPL | Stock | 1.4086 | 1.4104 | 1.4086 | 1.41 | 114800.0 |
| 2005-05-24 09:00:00 | AAPL | Stock | 1.4082 | 1.4089 | 1.4071 | 1.4071 | 146048.0 |
| 2005-05-24 09:05:00 | AAPL | Stock | 1.4082 | 1.4107 | 1.4082 | 1.4104 | 203000.0 |
| 2005-05-24 09:10:00 | AAPL | Stock | 1.41 | 1.4104 | 1.4075 | 1.4075 | 274400.0 |
| 2005-05-24 09:15:00 | AAPL | Stock | 1.4089 | 1.4107 | 1.4086 | 1.4107 | 436520.0 |
| 2005-05-24 09:20:00 | AAPL | Stock | 1.4093 | 1.4093 | 1.4079 | 1.4079 | 763000.0 |
| 2005-05-24 09:25:00 | AAPL | Stock | 1.4107 | 1.4107 | 1.4071 | 1.4086 | 808976.0 |
| 2005-05-24 09:30:00 | AAPL | Stock | 1.4089 | 1.4104 | 1.3982 | 1.4079 | 32417672.0 |
| 2005-05-24 09:35:00 | AAPL | Stock | 1.4075 | 1.4086 | 1.3989 | 1.4025 | 18164888.0 |
| 2005-05-24 09:40:00 | AAPL | Stock | 1.4025 | 1.4032 | 1.3993 | 1.4 | 15856904.0 |
| 2005-05-24 09:45:00 | AAPL | Stock | 1.4 | 1.4089 | 1.3939 | 1.3996 | 20324696.0 |
| 2005-05-24 09:50:00 | AAPL | Stock | 1.4 | 1.4054 | 1.3989 | 1.4054 | 14541856.0 |
| 2005-05-24 09:55:00 | AAPL | Stock | 1.4054 | 1.4154 | 1.4046 | 1.4107 | 32042108.0 |
| 2005-05-24 10:00:00 | AAPL | Stock | 1.4104 | 1.4139 | 1.4043 | 1.4054 | 13855268.0 |
| 2005-05-24 10:05:00 | AAPL | Stock | 1.405 | 1.4057 | 1.4004 | 1.4014 | 16316020.0 |
| 2005-05-24 10:10:00 | AAPL | Stock | 1.4014 | 1.4068 | 1.4011 | 1.4068 | 9881872.0 |
| 2005-05-24 10:15:00 | AAPL | Stock | 1.4068 | 1.4154 | 1.405 | 1.415 | 13011460.0 |
| 2005-05-24 10:20:00 | AAPL | Stock | 1.415 | 1.4161 | 1.4114 | 1.4157 | 9746184.0 |
| 2005-05-24 10:25:00 | AAPL | Stock | 1.4157 | 1.4214 | 1.4146 | 1.4168 | 15909712.0 |
| 2005-05-24 10:30:00 | AAPL | Stock | 1.4164 | 1.4246 | 1.4164 | 1.4221 | 15029504.0 |
| 2005-05-24 10:35:00 | AAPL | Stock | 1.4221 | 1.4243 | 1.4171 | 1.4189 | 13530636.0 |
| 2005-05-24 10:40:00 | AAPL | Stock | 1.4186 | 1.4204 | 1.4132 | 1.4143 | 8241576.0 |
| 2005-05-24 10:45:00 | AAPL | Stock | 1.4139 | 1.4175 | 1.4139 | 1.4146 | 7428484.0 |
| 2005-05-24 10:50:00 | AAPL | Stock | 1.4143 | 1.4189 | 1.4143 | 1.4146 | 5680248.0 |
| 2005-05-24 10:55:00 | AAPL | Stock | 1.4146 | 1.4189 | 1.4146 | 1.4179 | 3724196.0 |
| 2005-05-24 11:00:00 | AAPL | Stock | 1.4182 | 1.4189 | 1.4157 | 1.4161 | 3666012.0 |
| 2005-05-24 11:05:00 | AAPL | Stock | 1.4161 | 1.4214 | 1.4154 | 1.4211 | 9216676.0 |
| 2005-05-24 11:10:00 | AAPL | Stock | 1.4211 | 1.4243 | 1.4143 | 1.4214 | 12111680.0 |
| 2005-05-24 11:15:00 | AAPL | Stock | 1.4214 | 1.4268 | 1.4214 | 1.4246 | 9810640.0 |
| 2005-05-24 11:20:00 | AAPL | Stock | 1.4246 | 1.4246 | 1.4182 | 1.4193 | 10631040.0 |
| 2005-05-24 11:25:00 | AAPL | Stock | 1.4193 | 1.4207 | 1.4161 | 1.4171 | 6190240.0 |
| 2005-05-24 11:30:00 | AAPL | Stock | 1.4171 | 1.4186 | 1.4164 | 1.4171 | 5216036.0 |
| 2005-05-24 11:35:00 | AAPL | Stock | 1.4171 | 1.4171 | 1.415 | 1.4154 | 5880924.0 |
| 2005-05-24 11:40:00 | AAPL | Stock | 1.4154 | 1.4168 | 1.4136 | 1.4143 | 3772244.0 |
| 2005-05-24 11:45:00 | AAPL | Stock | 1.4143 | 1.4171 | 1.4136 | 1.4171 | 4352012.0 |
| 2005-05-24 11:50:00 | AAPL | Stock | 1.4171 | 1.4171 | 1.4096 | 1.4114 | 7571564.0 |
| 2005-05-24 11:55:00 | AAPL | Stock | 1.4114 | 1.4129 | 1.4086 | 1.4111 | 6834296.0 |
| 2005-05-24 12:00:00 | AAPL | Stock | 1.4111 | 1.4157 | 1.4111 | 1.4154 | 6238512.0 |
| 2005-05-24 12:05:00 | AAPL | Stock | 1.4154 | 1.4154 | 1.4125 | 1.4139 | 4271652.0 |
> showing 50 of 193,418 rows — these rows as CSV