PREVIEW / stock_5min / 2005-07-14
file: by_date/stock_5min/2005/2005-07-14.parquet size: 2.7 MB rows: 199,970 symbols: 2,026
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-14 07:10:00 | AAPL | Stock | 1.425 | 1.4268 | 1.425 | 1.4254 | 33600.0 |
| 2005-07-14 07:20:00 | AAPL | Stock | 1.4268 | 1.4268 | 1.4268 | 1.4268 | 5600.0 |
| 2005-07-14 07:25:00 | AAPL | Stock | 1.4268 | 1.4275 | 1.4264 | 1.4264 | 75600.0 |
| 2005-07-14 07:30:00 | AAPL | Stock | 1.4254 | 1.4286 | 1.4254 | 1.4286 | 627620.0 |
| 2005-07-14 07:35:00 | AAPL | Stock | 1.4321 | 1.4325 | 1.4286 | 1.4293 | 667800.0 |
| 2005-07-14 07:40:00 | AAPL | Stock | 1.4286 | 1.4393 | 1.4286 | 1.4393 | 856100.0 |
| 2005-07-14 07:45:00 | AAPL | Stock | 1.4393 | 1.4521 | 1.4393 | 1.4429 | 1661800.0 |
| 2005-07-14 07:50:00 | AAPL | Stock | 1.445 | 1.445 | 1.4446 | 1.4446 | 171724.0 |
| 2005-07-14 07:55:00 | AAPL | Stock | 1.4446 | 1.4464 | 1.4446 | 1.4446 | 294000.0 |
| 2005-07-14 08:00:00 | AAPL | Stock | 1.4429 | 1.4464 | 1.4393 | 1.4432 | 15705732.0 |
| 2005-07-14 08:05:00 | AAPL | Stock | 1.4446 | 1.4446 | 1.4375 | 1.4411 | 5599916.0 |
| 2005-07-14 08:10:00 | AAPL | Stock | 1.4425 | 1.4439 | 1.4411 | 1.4439 | 2702224.0 |
| 2005-07-14 08:15:00 | AAPL | Stock | 1.4446 | 1.4464 | 1.4421 | 1.4429 | 5469884.0 |
| 2005-07-14 08:20:00 | AAPL | Stock | 1.4429 | 1.4464 | 1.4425 | 1.4429 | 3717280.0 |
| 2005-07-14 08:25:00 | AAPL | Stock | 1.4429 | 1.4436 | 1.4414 | 1.4432 | 2292388.0 |
| 2005-07-14 08:30:00 | AAPL | Stock | 1.4436 | 1.4464 | 1.4436 | 1.4443 | 4771592.0 |
| 2005-07-14 08:35:00 | AAPL | Stock | 1.4436 | 1.4464 | 1.4429 | 1.4464 | 6026832.0 |
| 2005-07-14 08:40:00 | AAPL | Stock | 1.4457 | 1.4464 | 1.4429 | 1.445 | 6622672.0 |
| 2005-07-14 08:45:00 | AAPL | Stock | 1.4443 | 1.4554 | 1.4443 | 1.4554 | 9104396.0 |
| 2005-07-14 08:50:00 | AAPL | Stock | 1.4543 | 1.4586 | 1.4518 | 1.4554 | 7110684.0 |
| 2005-07-14 08:55:00 | AAPL | Stock | 1.4575 | 1.4593 | 1.4554 | 1.4554 | 5379248.0 |
| 2005-07-14 09:00:00 | AAPL | Stock | 1.4554 | 1.4589 | 1.4554 | 1.4586 | 3910844.0 |
| 2005-07-14 09:05:00 | AAPL | Stock | 1.4586 | 1.4593 | 1.4579 | 1.4579 | 7445844.0 |
| 2005-07-14 09:10:00 | AAPL | Stock | 1.4579 | 1.4586 | 1.4554 | 1.4579 | 5190556.0 |
| 2005-07-14 09:15:00 | AAPL | Stock | 1.4575 | 1.4589 | 1.4571 | 1.4571 | 3489836.0 |
| 2005-07-14 09:20:00 | AAPL | Stock | 1.4571 | 1.4643 | 1.4554 | 1.4614 | 11964120.0 |
| 2005-07-14 09:25:00 | AAPL | Stock | 1.4611 | 1.4629 | 1.4554 | 1.4564 | 13469036.0 |
| 2005-07-14 09:30:00 | AAPL | Stock | 1.4568 | 1.4711 | 1.4514 | 1.4589 | 134507128.0 |
| 2005-07-14 09:35:00 | AAPL | Stock | 1.4682 | 1.4814 | 1.4564 | 1.4786 | 100574656.0 |
| 2005-07-14 09:40:00 | AAPL | Stock | 1.4768 | 1.5004 | 1.4768 | 1.4954 | 130850720.0 |
| 2005-07-14 09:45:00 | AAPL | Stock | 1.495 | 1.5004 | 1.4914 | 1.4929 | 107159528.0 |
| 2005-07-14 09:50:00 | AAPL | Stock | 1.4929 | 1.4986 | 1.4839 | 1.4886 | 65069900.0 |
| 2005-07-14 09:55:00 | AAPL | Stock | 1.4886 | 1.4896 | 1.4796 | 1.48 | 53723572.0 |
| 2005-07-14 10:00:00 | AAPL | Stock | 1.48 | 1.4864 | 1.4764 | 1.4793 | 51911104.0 |
| 2005-07-14 10:05:00 | AAPL | Stock | 1.4796 | 1.4875 | 1.4661 | 1.4696 | 49061936.0 |
| 2005-07-14 10:10:00 | AAPL | Stock | 1.4693 | 1.4757 | 1.4661 | 1.4721 | 62795432.0 |
| 2005-07-14 10:15:00 | AAPL | Stock | 1.4718 | 1.4786 | 1.4707 | 1.4786 | 42058156.0 |
| 2005-07-14 10:20:00 | AAPL | Stock | 1.4786 | 1.4804 | 1.4771 | 1.4779 | 34359780.0 |
| 2005-07-14 10:25:00 | AAPL | Stock | 1.4779 | 1.4793 | 1.4714 | 1.4764 | 24277960.0 |
| 2005-07-14 10:30:00 | AAPL | Stock | 1.4764 | 1.4871 | 1.4757 | 1.4839 | 47112408.0 |
| 2005-07-14 10:35:00 | AAPL | Stock | 1.4836 | 1.4843 | 1.4757 | 1.4775 | 20646668.0 |
| 2005-07-14 10:40:00 | AAPL | Stock | 1.4771 | 1.4775 | 1.4721 | 1.4761 | 25886784.0 |
| 2005-07-14 10:45:00 | AAPL | Stock | 1.4761 | 1.4768 | 1.4736 | 1.4754 | 13889456.0 |
| 2005-07-14 10:50:00 | AAPL | Stock | 1.4754 | 1.4789 | 1.4739 | 1.4782 | 17437476.0 |
| 2005-07-14 10:55:00 | AAPL | Stock | 1.4782 | 1.4786 | 1.4736 | 1.4739 | 11697112.0 |
| 2005-07-14 11:00:00 | AAPL | Stock | 1.4739 | 1.4782 | 1.4679 | 1.4779 | 20021848.0 |
| 2005-07-14 11:05:00 | AAPL | Stock | 1.4779 | 1.4782 | 1.4739 | 1.4744 | 10334912.0 |
| 2005-07-14 11:10:00 | AAPL | Stock | 1.4743 | 1.4764 | 1.4732 | 1.4754 | 12234936.0 |
| 2005-07-14 11:15:00 | AAPL | Stock | 1.4754 | 1.4775 | 1.4679 | 1.4768 | 13174392.0 |
| 2005-07-14 11:20:00 | AAPL | Stock | 1.4771 | 1.4782 | 1.4739 | 1.4739 | 15223320.0 |
> showing 50 of 199,970 rows — these rows as CSV