PREVIEW / stock_5min / 2005-07-15
file: by_date/stock_5min/2005/2005-07-15.parquet size: 2.6 MB rows: 195,509 symbols: 2,018
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-07-15 04:55:00 | AAPL | Stock | 1.4607 | 1.4607 | 1.4607 | 1.4607 | 22400.0 |
| 2005-07-15 08:00:00 | AAPL | Stock | 1.45 | 1.4511 | 1.4446 | 1.45 | 362488.0 |
| 2005-07-15 08:05:00 | AAPL | Stock | 1.4514 | 1.4514 | 1.4471 | 1.4475 | 133560.0 |
| 2005-07-15 08:10:00 | AAPL | Stock | 1.4479 | 1.4479 | 1.4475 | 1.4479 | 79800.0 |
| 2005-07-15 08:15:00 | AAPL | Stock | 1.4475 | 1.4479 | 1.4471 | 1.4479 | 84000.0 |
| 2005-07-15 08:20:00 | AAPL | Stock | 1.4479 | 1.4482 | 1.4479 | 1.4479 | 25200.0 |
| 2005-07-15 08:25:00 | AAPL | Stock | 1.4493 | 1.4493 | 1.4464 | 1.4464 | 107800.0 |
| 2005-07-15 08:30:00 | AAPL | Stock | 1.4482 | 1.4489 | 1.4482 | 1.4489 | 22400.0 |
| 2005-07-15 08:35:00 | AAPL | Stock | 1.4482 | 1.4482 | 1.4482 | 1.4482 | 56000.0 |
| 2005-07-15 08:40:00 | AAPL | Stock | 1.4489 | 1.4489 | 1.4482 | 1.4489 | 11200.0 |
| 2005-07-15 08:45:00 | AAPL | Stock | 1.4475 | 1.4475 | 1.4461 | 1.4461 | 147140.0 |
| 2005-07-15 08:50:00 | AAPL | Stock | 1.4457 | 1.4479 | 1.445 | 1.4464 | 113260.0 |
| 2005-07-15 08:55:00 | AAPL | Stock | 1.4461 | 1.4461 | 1.4461 | 1.4461 | 22400.0 |
| 2005-07-15 09:00:00 | AAPL | Stock | 1.4461 | 1.4461 | 1.4454 | 1.4461 | 66360.0 |
| 2005-07-15 09:05:00 | AAPL | Stock | 1.4454 | 1.4464 | 1.445 | 1.4464 | 167468.0 |
| 2005-07-15 09:10:00 | AAPL | Stock | 1.4464 | 1.4464 | 1.4457 | 1.4464 | 90972.0 |
| 2005-07-15 09:15:00 | AAPL | Stock | 1.4468 | 1.4468 | 1.4468 | 1.4468 | 14000.0 |
| 2005-07-15 09:20:00 | AAPL | Stock | 1.4471 | 1.4479 | 1.4471 | 1.4479 | 98728.0 |
| 2005-07-15 09:25:00 | AAPL | Stock | 1.4479 | 1.4639 | 1.4479 | 1.4639 | 4335604.0 |
| 2005-07-15 09:30:00 | AAPL | Stock | 1.4632 | 1.4643 | 1.4561 | 1.4596 | 51846984.0 |
| 2005-07-15 09:35:00 | AAPL | Stock | 1.46 | 1.4604 | 1.455 | 1.4564 | 18979296.0 |
| 2005-07-15 09:40:00 | AAPL | Stock | 1.4564 | 1.4575 | 1.4482 | 1.4482 | 15622292.0 |
| 2005-07-15 09:45:00 | AAPL | Stock | 1.4482 | 1.4586 | 1.4479 | 1.4582 | 14739228.0 |
| 2005-07-15 09:50:00 | AAPL | Stock | 1.4579 | 1.4585 | 1.4496 | 1.4514 | 11117652.0 |
| 2005-07-15 09:55:00 | AAPL | Stock | 1.4514 | 1.4521 | 1.445 | 1.45 | 11572876.0 |
| 2005-07-15 10:00:00 | AAPL | Stock | 1.45 | 1.45 | 1.4461 | 1.4489 | 5994212.0 |
| 2005-07-15 10:05:00 | AAPL | Stock | 1.4493 | 1.455 | 1.4486 | 1.4546 | 13021008.0 |
| 2005-07-15 10:10:00 | AAPL | Stock | 1.4546 | 1.4546 | 1.4504 | 1.4521 | 10656128.0 |
| 2005-07-15 10:15:00 | AAPL | Stock | 1.4521 | 1.4579 | 1.4518 | 1.4568 | 8506092.0 |
| 2005-07-15 10:20:00 | AAPL | Stock | 1.4567 | 1.4582 | 1.4525 | 1.4536 | 9093168.0 |
| 2005-07-15 10:25:00 | AAPL | Stock | 1.4536 | 1.4546 | 1.45 | 1.4521 | 6150984.0 |
| 2005-07-15 10:30:00 | AAPL | Stock | 1.4525 | 1.4564 | 1.4507 | 1.4557 | 6170920.0 |
| 2005-07-15 10:35:00 | AAPL | Stock | 1.4557 | 1.4579 | 1.4536 | 1.4561 | 10171000.0 |
| 2005-07-15 10:40:00 | AAPL | Stock | 1.4561 | 1.4571 | 1.4546 | 1.4554 | 7523516.0 |
| 2005-07-15 10:45:00 | AAPL | Stock | 1.4554 | 1.4621 | 1.455 | 1.4621 | 12060664.0 |
| 2005-07-15 10:50:00 | AAPL | Stock | 1.4621 | 1.4643 | 1.4604 | 1.4614 | 9762620.0 |
| 2005-07-15 10:55:00 | AAPL | Stock | 1.4614 | 1.4617 | 1.4586 | 1.4611 | 4249644.0 |
| 2005-07-15 11:00:00 | AAPL | Stock | 1.4611 | 1.4693 | 1.4607 | 1.4675 | 19009340.0 |
| 2005-07-15 11:05:00 | AAPL | Stock | 1.4675 | 1.4725 | 1.4671 | 1.4721 | 12552120.0 |
| 2005-07-15 11:10:00 | AAPL | Stock | 1.4721 | 1.4736 | 1.4704 | 1.4714 | 27817356.0 |
| 2005-07-15 11:15:00 | AAPL | Stock | 1.4714 | 1.4771 | 1.4704 | 1.4761 | 13315232.0 |
| 2005-07-15 11:20:00 | AAPL | Stock | 1.4761 | 1.4764 | 1.4725 | 1.475 | 10821272.0 |
| 2005-07-15 11:25:00 | AAPL | Stock | 1.4754 | 1.4786 | 1.475 | 1.4775 | 10149440.0 |
| 2005-07-15 11:30:00 | AAPL | Stock | 1.4771 | 1.4779 | 1.4739 | 1.4761 | 9610776.0 |
| 2005-07-15 11:35:00 | AAPL | Stock | 1.476 | 1.4768 | 1.4746 | 1.4757 | 7262304.0 |
| 2005-07-15 11:40:00 | AAPL | Stock | 1.4761 | 1.4811 | 1.4754 | 1.4796 | 13171592.0 |
| 2005-07-15 11:45:00 | AAPL | Stock | 1.4796 | 1.4836 | 1.475 | 1.48 | 19654600.0 |
| 2005-07-15 11:50:00 | AAPL | Stock | 1.48 | 1.4825 | 1.4793 | 1.4818 | 7755048.0 |
| 2005-07-15 11:55:00 | AAPL | Stock | 1.4818 | 1.4818 | 1.4789 | 1.4814 | 6284012.0 |
| 2005-07-15 12:00:00 | AAPL | Stock | 1.4814 | 1.4814 | 1.4764 | 1.4771 | 7885024.0 |
> showing 50 of 195,509 rows — these rows as CSV