PREVIEW / stock_5min / 2009-05-18
file: by_date/stock_5min/2009/2009-05-18.parquet size: 4.5 MB rows: 314,260 symbols: 3,330
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 |
|---|---|---|---|---|---|---|---|
| 2009-05-18 08:00:00 | AAPL | Stock | 4.3929 | 4.3929 | 4.39 | 4.3929 | 116620.0 |
| 2009-05-18 08:05:00 | AAPL | Stock | 4.3946 | 4.41 | 4.3946 | 4.41 | 44492.0 |
| 2009-05-18 08:10:00 | AAPL | Stock | 4.41 | 4.4111 | 4.41 | 4.4107 | 108248.0 |
| 2009-05-18 08:15:00 | AAPL | Stock | 4.4107 | 4.4143 | 4.4107 | 4.4139 | 92400.0 |
| 2009-05-18 08:20:00 | AAPL | Stock | 4.4139 | 4.4232 | 4.4125 | 4.4232 | 79800.0 |
| 2009-05-18 08:25:00 | AAPL | Stock | 4.4193 | 4.4214 | 4.4136 | 4.4207 | 229012.0 |
| 2009-05-18 08:30:00 | AAPL | Stock | 4.4121 | 4.4143 | 4.4107 | 4.4143 | 71652.0 |
| 2009-05-18 08:35:00 | AAPL | Stock | 4.4207 | 4.4214 | 4.4207 | 4.4214 | 59808.0 |
| 2009-05-18 08:40:00 | AAPL | Stock | 4.4179 | 4.4196 | 4.4179 | 4.4196 | 22400.0 |
| 2009-05-18 08:45:00 | AAPL | Stock | 4.4196 | 4.4196 | 4.4146 | 4.4154 | 42980.0 |
| 2009-05-18 08:50:00 | AAPL | Stock | 4.4193 | 4.4196 | 4.4193 | 4.4193 | 11200.0 |
| 2009-05-18 08:55:00 | AAPL | Stock | 4.4196 | 4.4196 | 4.4189 | 4.4189 | 16800.0 |
| 2009-05-18 09:00:00 | AAPL | Stock | 4.4186 | 4.4196 | 4.4186 | 4.4196 | 32200.0 |
| 2009-05-18 09:05:00 | AAPL | Stock | 4.4211 | 4.4268 | 4.4211 | 4.4268 | 88200.0 |
| 2009-05-18 09:10:00 | AAPL | Stock | 4.4271 | 4.4282 | 4.425 | 4.4268 | 110796.0 |
| 2009-05-18 09:15:00 | AAPL | Stock | 4.4261 | 4.4271 | 4.4246 | 4.4271 | 40320.0 |
| 2009-05-18 09:20:00 | AAPL | Stock | 4.4257 | 4.4271 | 4.4232 | 4.4271 | 50596.0 |
| 2009-05-18 09:25:00 | AAPL | Stock | 4.4232 | 4.4268 | 4.4196 | 4.4264 | 220220.0 |
| 2009-05-18 09:30:00 | AAPL | Stock | 4.4196 | 4.4286 | 4.3632 | 4.3736 | 16782248.0 |
| 2009-05-18 09:35:00 | AAPL | Stock | 4.3736 | 4.3736 | 4.3418 | 4.3679 | 12805184.0 |
| 2009-05-18 09:40:00 | AAPL | Stock | 4.3686 | 4.3757 | 4.3429 | 4.3757 | 8522052.0 |
| 2009-05-18 09:45:00 | AAPL | Stock | 4.3764 | 4.3846 | 4.3682 | 4.3839 | 10335220.0 |
| 2009-05-18 09:50:00 | AAPL | Stock | 4.3836 | 4.3989 | 4.3693 | 4.3771 | 8656032.0 |
| 2009-05-18 09:55:00 | AAPL | Stock | 4.3757 | 4.3802 | 4.3582 | 4.3714 | 7216580.0 |
| 2009-05-18 10:00:00 | AAPL | Stock | 4.3714 | 4.3793 | 4.3564 | 4.3611 | 6358184.0 |
| 2009-05-18 10:05:00 | AAPL | Stock | 4.3604 | 4.3741 | 4.3543 | 4.3621 | 6416648.0 |
| 2009-05-18 10:10:00 | AAPL | Stock | 4.3632 | 4.3814 | 4.3575 | 4.3771 | 6154204.0 |
| 2009-05-18 10:15:00 | AAPL | Stock | 4.3764 | 4.3904 | 4.3707 | 4.3787 | 5452048.0 |
| 2009-05-18 10:20:00 | AAPL | Stock | 4.38 | 4.3925 | 4.3786 | 4.3793 | 4477844.0 |
| 2009-05-18 10:25:00 | AAPL | Stock | 4.3807 | 4.3871 | 4.3739 | 4.3807 | 3464328.0 |
| 2009-05-18 10:30:00 | AAPL | Stock | 4.38 | 4.3929 | 4.375 | 4.3921 | 5255908.0 |
| 2009-05-18 10:35:00 | AAPL | Stock | 4.3925 | 4.4021 | 4.3886 | 4.3989 | 6527808.0 |
| 2009-05-18 10:40:00 | AAPL | Stock | 4.3993 | 4.4096 | 4.3929 | 4.4096 | 5336324.0 |
| 2009-05-18 10:45:00 | AAPL | Stock | 4.4096 | 4.4168 | 4.405 | 4.4107 | 5289844.0 |
| 2009-05-18 10:50:00 | AAPL | Stock | 4.4107 | 4.4196 | 4.41 | 4.4132 | 4010384.0 |
| 2009-05-18 10:55:00 | AAPL | Stock | 4.4132 | 4.4246 | 4.4107 | 4.4218 | 4267172.0 |
| 2009-05-18 11:00:00 | AAPL | Stock | 4.4229 | 4.4254 | 4.4168 | 4.4232 | 3813012.0 |
| 2009-05-18 11:05:00 | AAPL | Stock | 4.4236 | 4.4264 | 4.4169 | 4.4189 | 3981208.0 |
| 2009-05-18 11:10:00 | AAPL | Stock | 4.4182 | 4.4221 | 4.4157 | 4.4171 | 1954064.0 |
| 2009-05-18 11:15:00 | AAPL | Stock | 4.4171 | 4.4171 | 4.41 | 4.4154 | 3749648.0 |
| 2009-05-18 11:20:00 | AAPL | Stock | 4.4157 | 4.4196 | 4.4068 | 4.4139 | 2642192.0 |
| 2009-05-18 11:25:00 | AAPL | Stock | 4.4143 | 4.4186 | 4.4107 | 4.4143 | 1464848.0 |
| 2009-05-18 11:30:00 | AAPL | Stock | 4.4146 | 4.4254 | 4.4132 | 4.4204 | 2261420.0 |
| 2009-05-18 11:35:00 | AAPL | Stock | 4.4204 | 4.4229 | 4.4114 | 4.4114 | 1522892.0 |
| 2009-05-18 11:40:00 | AAPL | Stock | 4.4121 | 4.4254 | 4.4111 | 4.4207 | 2022748.0 |
| 2009-05-18 11:45:00 | AAPL | Stock | 4.4217 | 4.4268 | 4.4147 | 4.4182 | 3099460.0 |
| 2009-05-18 11:50:00 | AAPL | Stock | 4.4182 | 4.4271 | 4.4182 | 4.4207 | 1894704.0 |
| 2009-05-18 11:55:00 | AAPL | Stock | 4.4211 | 4.4243 | 4.4104 | 4.4157 | 2501492.0 |
| 2009-05-18 12:00:00 | AAPL | Stock | 4.4157 | 4.4188 | 4.4129 | 4.4182 | 1463056.0 |
| 2009-05-18 12:05:00 | AAPL | Stock | 4.4182 | 4.4214 | 4.4179 | 4.4204 | 1744988.0 |
> showing 50 of 314,260 rows — these rows as CSV