PREVIEW / stock_5min / 2005-04-01
file: by_date/stock_5min/2005/2005-04-01.parquet size: 2.8 MB rows: 201,578 symbols: 1,961
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-04-01 08:10:00 | AAPL | Stock | 1.4946 | 1.4946 | 1.4943 | 1.4943 | 70000.0 |
| 2005-04-01 08:20:00 | AAPL | Stock | 1.4946 | 1.5 | 1.4946 | 1.5 | 62524.0 |
| 2005-04-01 08:25:00 | AAPL | Stock | 1.4996 | 1.5025 | 1.4907 | 1.5014 | 243600.0 |
| 2005-04-01 08:30:00 | AAPL | Stock | 1.5014 | 1.505 | 1.4964 | 1.5036 | 899724.0 |
| 2005-04-01 08:35:00 | AAPL | Stock | 1.5046 | 1.5046 | 1.5 | 1.5 | 224000.0 |
| 2005-04-01 08:40:00 | AAPL | Stock | 1.5 | 1.5018 | 1.4882 | 1.5007 | 472360.0 |
| 2005-04-01 08:45:00 | AAPL | Stock | 1.5004 | 1.5021 | 1.5004 | 1.5021 | 280000.0 |
| 2005-04-01 08:50:00 | AAPL | Stock | 1.5018 | 1.5071 | 1.5018 | 1.5068 | 349048.0 |
| 2005-04-01 08:55:00 | AAPL | Stock | 1.5071 | 1.5086 | 1.5071 | 1.5082 | 344204.0 |
| 2005-04-01 09:00:00 | AAPL | Stock | 1.5082 | 1.5129 | 1.5082 | 1.5114 | 561400.0 |
| 2005-04-01 09:05:00 | AAPL | Stock | 1.5111 | 1.5121 | 1.5093 | 1.5096 | 372400.0 |
| 2005-04-01 09:10:00 | AAPL | Stock | 1.5089 | 1.5118 | 1.5089 | 1.51 | 444136.0 |
| 2005-04-01 09:15:00 | AAPL | Stock | 1.51 | 1.51 | 1.5057 | 1.5079 | 180040.0 |
| 2005-04-01 09:20:00 | AAPL | Stock | 1.5082 | 1.5082 | 1.5054 | 1.5054 | 108948.0 |
| 2005-04-01 09:25:00 | AAPL | Stock | 1.4989 | 1.5089 | 1.4989 | 1.5036 | 867132.0 |
| 2005-04-01 09:30:00 | AAPL | Stock | 1.5032 | 1.5064 | 1.4964 | 1.5007 | 19915056.0 |
| 2005-04-01 09:35:00 | AAPL | Stock | 1.5007 | 1.5043 | 1.4954 | 1.4957 | 11134648.0 |
| 2005-04-01 09:40:00 | AAPL | Stock | 1.495 | 1.4982 | 1.4911 | 1.4982 | 14252700.0 |
| 2005-04-01 09:45:00 | AAPL | Stock | 1.4982 | 1.5011 | 1.4946 | 1.4954 | 10993220.0 |
| 2005-04-01 09:50:00 | AAPL | Stock | 1.495 | 1.4964 | 1.4921 | 1.4943 | 10447052.0 |
| 2005-04-01 09:55:00 | AAPL | Stock | 1.4943 | 1.4982 | 1.4936 | 1.495 | 8159648.0 |
| 2005-04-01 10:00:00 | AAPL | Stock | 1.4946 | 1.4968 | 1.4914 | 1.4925 | 9160144.0 |
| 2005-04-01 10:05:00 | AAPL | Stock | 1.4925 | 1.4925 | 1.4829 | 1.4861 | 22940764.0 |
| 2005-04-01 10:10:00 | AAPL | Stock | 1.4861 | 1.4889 | 1.48 | 1.4864 | 17780952.0 |
| 2005-04-01 10:15:00 | AAPL | Stock | 1.4864 | 1.4864 | 1.4789 | 1.4814 | 11756472.0 |
| 2005-04-01 10:20:00 | AAPL | Stock | 1.4811 | 1.4875 | 1.48 | 1.4807 | 8379980.0 |
| 2005-04-01 10:25:00 | AAPL | Stock | 1.4807 | 1.4814 | 1.4489 | 1.4539 | 32328800.0 |
| 2005-04-01 10:30:00 | AAPL | Stock | 1.4546 | 1.4632 | 1.4536 | 1.4618 | 26205648.0 |
| 2005-04-01 10:35:00 | AAPL | Stock | 1.4618 | 1.5032 | 1.4614 | 1.4729 | 23411892.0 |
| 2005-04-01 10:40:00 | AAPL | Stock | 1.4725 | 1.475 | 1.4668 | 1.4686 | 15185492.0 |
| 2005-04-01 10:45:00 | AAPL | Stock | 1.4686 | 1.4711 | 1.4579 | 1.4589 | 14768040.0 |
| 2005-04-01 10:50:00 | AAPL | Stock | 1.4586 | 1.4625 | 1.4561 | 1.4604 | 15483916.0 |
| 2005-04-01 10:55:00 | AAPL | Stock | 1.4604 | 1.4607 | 1.4546 | 1.4596 | 10448060.0 |
| 2005-04-01 11:00:00 | AAPL | Stock | 1.4596 | 1.4625 | 1.4561 | 1.4618 | 10417960.0 |
| 2005-04-01 11:05:00 | AAPL | Stock | 1.4618 | 1.4714 | 1.46 | 1.4679 | 11365620.0 |
| 2005-04-01 11:10:00 | AAPL | Stock | 1.4679 | 1.4714 | 1.4661 | 1.4661 | 6958672.0 |
| 2005-04-01 11:15:00 | AAPL | Stock | 1.4661 | 1.4682 | 1.4621 | 1.4675 | 7978852.0 |
| 2005-04-01 11:20:00 | AAPL | Stock | 1.4675 | 1.4718 | 1.4671 | 1.4711 | 5049240.0 |
| 2005-04-01 11:25:00 | AAPL | Stock | 1.4711 | 1.4714 | 1.4682 | 1.4689 | 3440472.0 |
| 2005-04-01 11:30:00 | AAPL | Stock | 1.4686 | 1.471 | 1.4657 | 1.4657 | 4259976.0 |
| 2005-04-01 11:35:00 | AAPL | Stock | 1.4657 | 1.4668 | 1.4632 | 1.4654 | 4678296.0 |
| 2005-04-01 11:40:00 | AAPL | Stock | 1.465 | 1.465 | 1.4596 | 1.4596 | 9294796.0 |
| 2005-04-01 11:45:00 | AAPL | Stock | 1.4596 | 1.4629 | 1.4575 | 1.4607 | 7575680.0 |
| 2005-04-01 11:50:00 | AAPL | Stock | 1.4607 | 1.4636 | 1.4586 | 1.4611 | 5194056.0 |
| 2005-04-01 11:55:00 | AAPL | Stock | 1.4607 | 1.4625 | 1.4589 | 1.4596 | 4038748.0 |
| 2005-04-01 12:00:00 | AAPL | Stock | 1.46 | 1.4621 | 1.4593 | 1.4611 | 2766120.0 |
| 2005-04-01 12:05:00 | AAPL | Stock | 1.4614 | 1.4618 | 1.4579 | 1.4604 | 8824592.0 |
| 2005-04-01 12:10:00 | AAPL | Stock | 1.4604 | 1.4607 | 1.4575 | 1.4575 | 2519580.0 |
| 2005-04-01 12:15:00 | AAPL | Stock | 1.4575 | 1.4582 | 1.4554 | 1.4579 | 5021660.0 |
| 2005-04-01 12:20:00 | AAPL | Stock | 1.4582 | 1.4596 | 1.455 | 1.4582 | 5684924.0 |
> showing 50 of 201,578 rows — these rows as CSV