PREVIEW / stock_5min / 2004-03-05
file: by_date/stock_5min/2004/2004-03-05.parquet size: 2.4 MB rows: 167,585 symbols: 1,731
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 |
|---|---|---|---|---|---|---|---|
| 2004-03-05 08:00:00 | AAPL | Stock | 0.4493 | 0.4493 | 0.4479 | 0.4482 | 224000.0 |
| 2004-03-05 08:05:00 | AAPL | Stock | 0.4482 | 0.4491 | 0.4482 | 0.4491 | 16800.0 |
| 2004-03-05 08:15:00 | AAPL | Stock | 0.4486 | 0.4491 | 0.4486 | 0.4486 | 84000.0 |
| 2004-03-05 08:30:00 | AAPL | Stock | 0.4473 | 0.4473 | 0.4464 | 0.4473 | 224000.0 |
| 2004-03-05 08:35:00 | AAPL | Stock | 0.4473 | 0.4473 | 0.4473 | 0.4473 | 16800.0 |
| 2004-03-05 08:40:00 | AAPL | Stock | 0.4464 | 0.4464 | 0.4455 | 0.4459 | 319200.0 |
| 2004-03-05 08:45:00 | AAPL | Stock | 0.4457 | 0.4457 | 0.4446 | 0.4455 | 247296.0 |
| 2004-03-05 08:50:00 | AAPL | Stock | 0.4455 | 0.4463 | 0.4455 | 0.4463 | 240800.0 |
| 2004-03-05 08:55:00 | AAPL | Stock | 0.4464 | 0.4464 | 0.4464 | 0.4464 | 218400.0 |
| 2004-03-05 09:00:00 | AAPL | Stock | 0.4473 | 0.4482 | 0.4291 | 0.4482 | 134400.0 |
| 2004-03-05 09:05:00 | AAPL | Stock | 0.4468 | 0.4468 | 0.4459 | 0.4459 | 392000.0 |
| 2004-03-05 09:10:00 | AAPL | Stock | 0.4463 | 0.4466 | 0.4455 | 0.4455 | 134400.0 |
| 2004-03-05 09:15:00 | AAPL | Stock | 0.4457 | 0.4457 | 0.4457 | 0.4457 | 56000.0 |
| 2004-03-05 09:25:00 | AAPL | Stock | 0.4455 | 0.4457 | 0.4448 | 0.4455 | 1262184.0 |
| 2004-03-05 09:30:00 | AAPL | Stock | 0.4455 | 0.4489 | 0.4446 | 0.4466 | 20678392.0 |
| 2004-03-05 09:35:00 | AAPL | Stock | 0.447 | 0.4473 | 0.4461 | 0.447 | 9559816.0 |
| 2004-03-05 09:40:00 | AAPL | Stock | 0.447 | 0.4498 | 0.4464 | 0.4496 | 9452688.0 |
| 2004-03-05 09:45:00 | AAPL | Stock | 0.4498 | 0.4577 | 0.4497 | 0.4577 | 21266784.0 |
| 2004-03-05 09:50:00 | AAPL | Stock | 0.4577 | 0.4759 | 0.4577 | 0.4752 | 55987624.0 |
| 2004-03-05 09:55:00 | AAPL | Stock | 0.4759 | 0.4832 | 0.4688 | 0.4768 | 89449808.0 |
| 2004-03-05 10:00:00 | AAPL | Stock | 0.4771 | 0.4845 | 0.4734 | 0.4823 | 63197568.0 |
| 2004-03-05 10:05:00 | AAPL | Stock | 0.4825 | 0.4909 | 0.4807 | 0.4832 | 86180416.0 |
| 2004-03-05 10:10:00 | AAPL | Stock | 0.4834 | 0.4848 | 0.477 | 0.4802 | 50332408.0 |
| 2004-03-05 10:15:00 | AAPL | Stock | 0.4796 | 0.4814 | 0.4741 | 0.4784 | 32604040.0 |
| 2004-03-05 10:20:00 | AAPL | Stock | 0.4786 | 0.4813 | 0.4734 | 0.4811 | 17891496.0 |
| 2004-03-05 10:25:00 | AAPL | Stock | 0.4811 | 0.4814 | 0.4795 | 0.4804 | 24266032.0 |
| 2004-03-05 10:30:00 | AAPL | Stock | 0.4804 | 0.4857 | 0.4802 | 0.4836 | 35336448.0 |
| 2004-03-05 10:35:00 | AAPL | Stock | 0.4836 | 0.4846 | 0.4814 | 0.4821 | 21994448.0 |
| 2004-03-05 10:40:00 | AAPL | Stock | 0.4816 | 0.482 | 0.4782 | 0.4796 | 14233240.0 |
| 2004-03-05 10:45:00 | AAPL | Stock | 0.4798 | 0.4809 | 0.4711 | 0.4749 | 23178456.0 |
| 2004-03-05 10:50:00 | AAPL | Stock | 0.4741 | 0.4791 | 0.4731 | 0.4779 | 13756456.0 |
| 2004-03-05 10:55:00 | AAPL | Stock | 0.4775 | 0.4795 | 0.4768 | 0.4773 | 8153712.0 |
| 2004-03-05 11:00:00 | AAPL | Stock | 0.4773 | 0.4789 | 0.4755 | 0.4779 | 23262120.0 |
| 2004-03-05 11:05:00 | AAPL | Stock | 0.4775 | 0.4779 | 0.475 | 0.4754 | 12517120.0 |
| 2004-03-05 11:10:00 | AAPL | Stock | 0.475 | 0.4759 | 0.473 | 0.4759 | 12893944.0 |
| 2004-03-05 11:15:00 | AAPL | Stock | 0.4759 | 0.4766 | 0.473 | 0.473 | 10638096.0 |
| 2004-03-05 11:20:00 | AAPL | Stock | 0.4729 | 0.4748 | 0.4716 | 0.4718 | 11907952.0 |
| 2004-03-05 11:25:00 | AAPL | Stock | 0.4718 | 0.4732 | 0.4682 | 0.4723 | 21116648.0 |
| 2004-03-05 11:30:00 | AAPL | Stock | 0.4721 | 0.4748 | 0.4716 | 0.4739 | 8572200.0 |
| 2004-03-05 11:35:00 | AAPL | Stock | 0.4737 | 0.4757 | 0.4723 | 0.4753 | 10867472.0 |
| 2004-03-05 11:40:00 | AAPL | Stock | 0.4754 | 0.4764 | 0.4746 | 0.4757 | 9237648.0 |
| 2004-03-05 11:45:00 | AAPL | Stock | 0.4755 | 0.4768 | 0.475 | 0.475 | 10387384.0 |
| 2004-03-05 11:50:00 | AAPL | Stock | 0.4748 | 0.4763 | 0.4742 | 0.4755 | 4728360.0 |
| 2004-03-05 11:55:00 | AAPL | Stock | 0.4755 | 0.4777 | 0.4754 | 0.4768 | 9508632.0 |
| 2004-03-05 12:00:00 | AAPL | Stock | 0.4766 | 0.4775 | 0.4761 | 0.477 | 5422312.0 |
| 2004-03-05 12:05:00 | AAPL | Stock | 0.477 | 0.4798 | 0.477 | 0.4786 | 16623880.0 |
| 2004-03-05 12:10:00 | AAPL | Stock | 0.4784 | 0.48 | 0.4779 | 0.4795 | 6504176.0 |
| 2004-03-05 12:15:00 | AAPL | Stock | 0.4796 | 0.4811 | 0.4795 | 0.4804 | 10362744.0 |
| 2004-03-05 12:20:00 | AAPL | Stock | 0.4804 | 0.482 | 0.48 | 0.4816 | 9149952.0 |
| 2004-03-05 12:25:00 | AAPL | Stock | 0.4816 | 0.4821 | 0.4813 | 0.4818 | 8582840.0 |
> showing 50 of 167,585 rows — these rows as CSV