PREVIEW / stock_5min / 2009-02-11
file: by_date/stock_5min/2009/2009-02-11.parquet size: 4.2 MB rows: 293,836 symbols: 3,285
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-02-11 04:25:00 | AAPL | Stock | 3.5007 | 3.5007 | 3.5007 | 3.5007 | 14000.0 |
| 2009-02-11 04:30:00 | AAPL | Stock | 3.5036 | 3.5036 | 3.5036 | 3.5036 | 14000.0 |
| 2009-02-11 07:00:00 | AAPL | Stock | 3.5089 | 3.5089 | 3.4464 | 3.4464 | 342524.0 |
| 2009-02-11 07:05:00 | AAPL | Stock | 3.4464 | 3.4464 | 3.4464 | 3.4464 | 70000.0 |
| 2009-02-11 07:10:00 | AAPL | Stock | 3.4464 | 3.4464 | 3.4464 | 3.4464 | 8960.0 |
| 2009-02-11 07:15:00 | AAPL | Stock | 3.4643 | 3.4643 | 3.4446 | 3.4464 | 31612.0 |
| 2009-02-11 07:30:00 | AAPL | Stock | 3.4296 | 3.4296 | 3.4282 | 3.4293 | 90776.0 |
| 2009-02-11 07:35:00 | AAPL | Stock | 3.4289 | 3.4389 | 3.4289 | 3.4389 | 26824.0 |
| 2009-02-11 07:40:00 | AAPL | Stock | 3.4389 | 3.4443 | 3.4389 | 3.4393 | 201600.0 |
| 2009-02-11 07:45:00 | AAPL | Stock | 3.4411 | 3.4411 | 3.4393 | 3.4393 | 71960.0 |
| 2009-02-11 07:50:00 | AAPL | Stock | 3.4393 | 3.4393 | 3.4286 | 3.4286 | 124740.0 |
| 2009-02-11 07:55:00 | AAPL | Stock | 3.4286 | 3.4286 | 3.4218 | 3.4286 | 139944.0 |
| 2009-02-11 08:00:00 | AAPL | Stock | 3.4218 | 3.4286 | 3.4179 | 3.42 | 1041600.0 |
| 2009-02-11 08:05:00 | AAPL | Stock | 3.4196 | 3.4286 | 3.4196 | 3.4286 | 439992.0 |
| 2009-02-11 08:10:00 | AAPL | Stock | 3.425 | 3.4286 | 3.4196 | 3.425 | 207004.0 |
| 2009-02-11 08:15:00 | AAPL | Stock | 3.4268 | 3.4389 | 3.4261 | 3.4321 | 369936.0 |
| 2009-02-11 08:20:00 | AAPL | Stock | 3.4289 | 3.4346 | 3.425 | 3.4286 | 451780.0 |
| 2009-02-11 08:25:00 | AAPL | Stock | 3.4304 | 3.4304 | 3.4193 | 3.4193 | 252896.0 |
| 2009-02-11 08:30:00 | AAPL | Stock | 3.4196 | 3.4232 | 3.4107 | 3.4114 | 557200.0 |
| 2009-02-11 08:35:00 | AAPL | Stock | 3.4107 | 3.4196 | 3.4107 | 3.4114 | 638848.0 |
| 2009-02-11 08:40:00 | AAPL | Stock | 3.4107 | 3.4146 | 3.4036 | 3.4107 | 283220.0 |
| 2009-02-11 08:45:00 | AAPL | Stock | 3.4107 | 3.4111 | 3.4068 | 3.4075 | 464772.0 |
| 2009-02-11 08:50:00 | AAPL | Stock | 3.4107 | 3.4161 | 3.4046 | 3.4107 | 189252.0 |
| 2009-02-11 08:55:00 | AAPL | Stock | 3.4114 | 3.4179 | 3.4107 | 3.4179 | 186340.0 |
| 2009-02-11 09:00:00 | AAPL | Stock | 3.4161 | 3.4189 | 3.4143 | 3.4179 | 264600.0 |
| 2009-02-11 09:05:00 | AAPL | Stock | 3.4182 | 3.4286 | 3.4182 | 3.4268 | 462532.0 |
| 2009-02-11 09:10:00 | AAPL | Stock | 3.4254 | 3.4268 | 3.4236 | 3.425 | 239820.0 |
| 2009-02-11 09:15:00 | AAPL | Stock | 3.4261 | 3.4268 | 3.4214 | 3.4221 | 240660.0 |
| 2009-02-11 09:20:00 | AAPL | Stock | 3.4229 | 3.425 | 3.42 | 3.4221 | 286384.0 |
| 2009-02-11 09:25:00 | AAPL | Stock | 3.4218 | 3.4429 | 3.4196 | 3.4429 | 1521240.0 |
| 2009-02-11 09:30:00 | AAPL | Stock | 3.4425 | 3.4768 | 3.4389 | 3.4611 | 21358484.0 |
| 2009-02-11 09:35:00 | AAPL | Stock | 3.4607 | 3.4886 | 3.4568 | 3.4864 | 17207484.0 |
| 2009-02-11 09:40:00 | AAPL | Stock | 3.4861 | 3.4882 | 3.465 | 3.4718 | 17435908.0 |
| 2009-02-11 09:45:00 | AAPL | Stock | 3.4729 | 3.4832 | 3.4596 | 3.4821 | 15204924.0 |
| 2009-02-11 09:50:00 | AAPL | Stock | 3.4821 | 3.5018 | 3.48 | 3.5011 | 19858664.0 |
| 2009-02-11 09:55:00 | AAPL | Stock | 3.5008 | 3.5071 | 3.4864 | 3.4939 | 15088472.0 |
| 2009-02-11 10:00:00 | AAPL | Stock | 3.4939 | 3.5071 | 3.4879 | 3.4964 | 11834564.0 |
| 2009-02-11 10:05:00 | AAPL | Stock | 3.4957 | 3.4968 | 3.4761 | 3.4786 | 13909308.0 |
| 2009-02-11 10:10:00 | AAPL | Stock | 3.4779 | 3.4986 | 3.4775 | 3.4825 | 12670420.0 |
| 2009-02-11 10:15:00 | AAPL | Stock | 3.4821 | 3.4836 | 3.4725 | 3.4739 | 10541720.0 |
| 2009-02-11 10:20:00 | AAPL | Stock | 3.4739 | 3.4775 | 3.4614 | 3.4671 | 11842404.0 |
| 2009-02-11 10:25:00 | AAPL | Stock | 3.4668 | 3.4714 | 3.4507 | 3.4532 | 14317408.0 |
| 2009-02-11 10:30:00 | AAPL | Stock | 3.4536 | 3.4596 | 3.4439 | 3.4568 | 13911100.0 |
| 2009-02-11 10:35:00 | AAPL | Stock | 3.4571 | 3.4689 | 3.4561 | 3.46 | 9388400.0 |
| 2009-02-11 10:40:00 | AAPL | Stock | 3.4614 | 3.4643 | 3.4562 | 3.4585 | 5531792.0 |
| 2009-02-11 10:45:00 | AAPL | Stock | 3.4586 | 3.4725 | 3.4482 | 3.4693 | 7612892.0 |
| 2009-02-11 10:50:00 | AAPL | Stock | 3.4696 | 3.4779 | 3.4682 | 3.4693 | 6775832.0 |
| 2009-02-11 10:55:00 | AAPL | Stock | 3.4696 | 3.4768 | 3.4668 | 3.4673 | 5306756.0 |
| 2009-02-11 11:00:00 | AAPL | Stock | 3.4668 | 3.4775 | 3.4625 | 3.475 | 7722260.0 |
| 2009-02-11 11:05:00 | AAPL | Stock | 3.475 | 3.4804 | 3.4575 | 3.4596 | 7006412.0 |
> showing 50 of 293,836 rows — these rows as CSV