PREVIEW / stock_5min / 2005-11-29
file: by_date/stock_5min/2005/2005-11-29.parquet size: 2.8 MB rows: 208,085 symbols: 2,123
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-11-29 07:20:00 | AAPL | Stock | 2.4996 | 2.4996 | 2.4996 | 2.4996 | 2800.0 |
| 2005-11-29 07:25:00 | AAPL | Stock | 2.5014 | 2.5014 | 2.5014 | 2.5014 | 16800.0 |
| 2005-11-29 07:30:00 | AAPL | Stock | 2.4964 | 2.4982 | 2.4964 | 2.4982 | 5600.0 |
| 2005-11-29 07:35:00 | AAPL | Stock | 2.4996 | 2.5014 | 2.4982 | 2.4982 | 19600.0 |
| 2005-11-29 07:40:00 | AAPL | Stock | 2.4986 | 2.4986 | 2.4986 | 2.4986 | 2800.0 |
| 2005-11-29 08:00:00 | AAPL | Stock | 2.4986 | 2.505 | 2.4964 | 2.505 | 368732.0 |
| 2005-11-29 08:05:00 | AAPL | Stock | 2.5046 | 2.5071 | 2.5039 | 2.5064 | 194740.0 |
| 2005-11-29 08:10:00 | AAPL | Stock | 2.5064 | 2.5089 | 2.5061 | 2.5068 | 422828.0 |
| 2005-11-29 08:15:00 | AAPL | Stock | 2.5086 | 2.5157 | 2.5082 | 2.5121 | 578816.0 |
| 2005-11-29 08:20:00 | AAPL | Stock | 2.5121 | 2.5125 | 2.5071 | 2.5071 | 601608.0 |
| 2005-11-29 08:25:00 | AAPL | Stock | 2.5061 | 2.51 | 2.5039 | 2.5082 | 175056.0 |
| 2005-11-29 08:30:00 | AAPL | Stock | 2.5089 | 2.5107 | 2.5071 | 2.5096 | 213724.0 |
| 2005-11-29 08:35:00 | AAPL | Stock | 2.5096 | 2.5107 | 2.5043 | 2.5043 | 173600.0 |
| 2005-11-29 08:40:00 | AAPL | Stock | 2.505 | 2.5057 | 2.5036 | 2.5043 | 351680.0 |
| 2005-11-29 08:45:00 | AAPL | Stock | 2.5043 | 2.5043 | 2.5 | 2.5 | 186760.0 |
| 2005-11-29 08:50:00 | AAPL | Stock | 2.5039 | 2.5039 | 2.5 | 2.5018 | 286048.0 |
| 2005-11-29 08:55:00 | AAPL | Stock | 2.5029 | 2.5057 | 2.5021 | 2.5021 | 235536.0 |
| 2005-11-29 09:00:00 | AAPL | Stock | 2.5018 | 2.5018 | 2.4996 | 2.5 | 531356.0 |
| 2005-11-29 09:05:00 | AAPL | Stock | 2.5004 | 2.5018 | 2.4993 | 2.4996 | 514948.0 |
| 2005-11-29 09:10:00 | AAPL | Stock | 2.4993 | 2.5 | 2.4925 | 2.4943 | 1130164.0 |
| 2005-11-29 09:15:00 | AAPL | Stock | 2.4943 | 2.495 | 2.4836 | 2.4893 | 932848.0 |
| 2005-11-29 09:20:00 | AAPL | Stock | 2.49 | 2.4982 | 2.4886 | 2.4886 | 1177400.0 |
| 2005-11-29 09:25:00 | AAPL | Stock | 2.4886 | 2.4996 | 2.4886 | 2.4996 | 4202100.0 |
| 2005-11-29 09:30:00 | AAPL | Stock | 2.4996 | 2.5107 | 2.4857 | 2.4896 | 37919280.0 |
| 2005-11-29 09:35:00 | AAPL | Stock | 2.4893 | 2.4914 | 2.4732 | 2.4804 | 30292052.0 |
| 2005-11-29 09:40:00 | AAPL | Stock | 2.48 | 2.4918 | 2.4793 | 2.4896 | 14927864.0 |
| 2005-11-29 09:45:00 | AAPL | Stock | 2.4896 | 2.4975 | 2.4889 | 2.495 | 14810348.0 |
| 2005-11-29 09:50:00 | AAPL | Stock | 2.4946 | 2.4971 | 2.4868 | 2.4875 | 14037408.0 |
| 2005-11-29 09:55:00 | AAPL | Stock | 2.4871 | 2.4889 | 2.475 | 2.4814 | 13914012.0 |
| 2005-11-29 10:00:00 | AAPL | Stock | 2.4814 | 2.5032 | 2.4814 | 2.4964 | 26642140.0 |
| 2005-11-29 10:05:00 | AAPL | Stock | 2.4993 | 2.5018 | 2.4821 | 2.4825 | 15465632.0 |
| 2005-11-29 10:10:00 | AAPL | Stock | 2.4825 | 2.4886 | 2.4782 | 2.4821 | 13129368.0 |
| 2005-11-29 10:15:00 | AAPL | Stock | 2.4821 | 2.4825 | 2.4664 | 2.47 | 24126676.0 |
| 2005-11-29 10:20:00 | AAPL | Stock | 2.4707 | 2.4711 | 2.455 | 2.4564 | 24792152.0 |
| 2005-11-29 10:25:00 | AAPL | Stock | 2.4561 | 2.4643 | 2.45 | 2.4625 | 22929060.0 |
| 2005-11-29 10:30:00 | AAPL | Stock | 2.4625 | 2.5 | 2.4554 | 2.4586 | 14669592.0 |
| 2005-11-29 10:35:00 | AAPL | Stock | 2.4586 | 2.4725 | 2.4582 | 2.47 | 19486068.0 |
| 2005-11-29 10:40:00 | AAPL | Stock | 2.47 | 2.4729 | 2.4632 | 2.4643 | 13105232.0 |
| 2005-11-29 10:45:00 | AAPL | Stock | 2.4639 | 2.4646 | 2.4589 | 2.459 | 18956756.0 |
| 2005-11-29 10:50:00 | AAPL | Stock | 2.4593 | 2.4702 | 2.4536 | 2.4625 | 14267988.0 |
| 2005-11-29 10:55:00 | AAPL | Stock | 2.4646 | 2.4682 | 2.4571 | 2.465 | 6608840.0 |
| 2005-11-29 11:00:00 | AAPL | Stock | 2.465 | 2.4736 | 2.4632 | 2.4732 | 10198720.0 |
| 2005-11-29 11:05:00 | AAPL | Stock | 2.4732 | 2.5068 | 2.4629 | 2.4657 | 6802600.0 |
| 2005-11-29 11:10:00 | AAPL | Stock | 2.4654 | 2.4689 | 2.4596 | 2.4661 | 6008240.0 |
| 2005-11-29 11:15:00 | AAPL | Stock | 2.4654 | 2.4671 | 2.4596 | 2.4643 | 5154520.0 |
| 2005-11-29 11:20:00 | AAPL | Stock | 2.4636 | 2.4711 | 2.4632 | 2.4679 | 6623204.0 |
| 2005-11-29 11:25:00 | AAPL | Stock | 2.4671 | 2.4704 | 2.4646 | 2.4675 | 4031692.0 |
| 2005-11-29 11:30:00 | AAPL | Stock | 2.4675 | 2.4789 | 2.4675 | 2.4775 | 9424996.0 |
| 2005-11-29 11:35:00 | AAPL | Stock | 2.4775 | 2.48 | 2.4739 | 2.4786 | 9003568.0 |
| 2005-11-29 11:40:00 | AAPL | Stock | 2.4786 | 2.4796 | 2.4721 | 2.4721 | 4866372.0 |
> showing 50 of 208,085 rows — these rows as CSV