PREVIEW / stock_1min / 2007-07-16
file: by_date/stock_1min/2007/2007-07-16.parquet size: 11.4 MB rows: 926,554 symbols: 2,519
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 |
|---|---|---|---|---|---|---|---|
| 2007-07-16 09:30:00 | AAPL | Stock | 4.9425 | 4.9529 | 4.9289 | 4.9307 | 12774972.0 |
| 2007-07-16 09:31:00 | AAPL | Stock | 4.9304 | 4.9546 | 4.9289 | 4.9536 | 6280372.0 |
| 2007-07-16 09:32:00 | AAPL | Stock | 4.9525 | 4.9593 | 4.9457 | 4.9486 | 7365652.0 |
| 2007-07-16 09:33:00 | AAPL | Stock | 4.9479 | 4.9593 | 4.9464 | 4.9575 | 5830832.0 |
| 2007-07-16 09:34:00 | AAPL | Stock | 4.9593 | 4.9786 | 4.9575 | 4.975 | 8914080.0 |
| 2007-07-16 09:35:00 | AAPL | Stock | 4.9746 | 4.9761 | 4.9643 | 4.9718 | 7594608.0 |
| 2007-07-16 09:36:00 | AAPL | Stock | 4.9704 | 4.9743 | 4.9643 | 4.9668 | 5116804.0 |
| 2007-07-16 09:37:00 | AAPL | Stock | 4.9673 | 4.9732 | 4.9643 | 4.9704 | 5640460.0 |
| 2007-07-16 09:38:00 | AAPL | Stock | 4.9707 | 4.975 | 4.9643 | 4.9721 | 6646752.0 |
| 2007-07-16 09:39:00 | AAPL | Stock | 4.9725 | 4.9739 | 4.9682 | 4.9704 | 5802664.0 |
| 2007-07-16 09:40:00 | AAPL | Stock | 4.97 | 4.9782 | 4.9679 | 4.9743 | 9504852.0 |
| 2007-07-16 09:41:00 | AAPL | Stock | 4.9746 | 4.9829 | 4.9718 | 4.9829 | 6672680.0 |
| 2007-07-16 09:42:00 | AAPL | Stock | 4.9832 | 4.9907 | 4.9771 | 4.9889 | 9327752.0 |
| 2007-07-16 09:43:00 | AAPL | Stock | 4.9889 | 4.9932 | 4.9868 | 4.9914 | 5842368.0 |
| 2007-07-16 09:44:00 | AAPL | Stock | 4.9911 | 4.9964 | 4.9893 | 4.9952 | 6583052.0 |
| 2007-07-16 09:45:00 | AAPL | Stock | 4.995 | 4.9993 | 4.99 | 4.9911 | 6986700.0 |
| 2007-07-16 09:46:00 | AAPL | Stock | 4.9905 | 4.9971 | 4.9843 | 4.9861 | 9782164.0 |
| 2007-07-16 09:47:00 | AAPL | Stock | 4.9861 | 4.9945 | 4.9829 | 4.9857 | 4893476.0 |
| 2007-07-16 09:48:00 | AAPL | Stock | 4.9857 | 4.9871 | 4.9768 | 4.9768 | 8351476.0 |
| 2007-07-16 09:49:00 | AAPL | Stock | 4.9775 | 4.9775 | 4.9654 | 4.9729 | 9941596.0 |
| 2007-07-16 09:50:00 | AAPL | Stock | 4.9729 | 4.9789 | 4.9725 | 4.9768 | 4801944.0 |
| 2007-07-16 09:51:00 | AAPL | Stock | 4.9764 | 4.9771 | 4.9721 | 4.9739 | 3988236.0 |
| 2007-07-16 09:52:00 | AAPL | Stock | 4.9732 | 4.975 | 4.9718 | 4.9729 | 3957604.0 |
| 2007-07-16 09:53:00 | AAPL | Stock | 4.9729 | 4.9732 | 4.9664 | 4.9675 | 5105352.0 |
| 2007-07-16 09:54:00 | AAPL | Stock | 4.9675 | 4.9679 | 4.9611 | 4.9614 | 9064160.0 |
| 2007-07-16 09:55:00 | AAPL | Stock | 4.9621 | 4.9711 | 4.9614 | 4.97 | 4960172.0 |
| 2007-07-16 09:56:00 | AAPL | Stock | 4.9696 | 4.97 | 4.9571 | 4.9596 | 6267604.0 |
| 2007-07-16 09:57:00 | AAPL | Stock | 4.96 | 4.9643 | 4.9529 | 4.9568 | 6220256.0 |
| 2007-07-16 09:58:00 | AAPL | Stock | 4.9568 | 4.9693 | 4.9443 | 4.9464 | 8613472.0 |
| 2007-07-16 09:59:00 | AAPL | Stock | 4.9468 | 4.9529 | 4.94 | 4.9493 | 6284152.0 |
| 2007-07-16 10:00:00 | AAPL | Stock | 4.9514 | 4.9546 | 4.9464 | 4.9514 | 6792044.0 |
| 2007-07-16 10:01:00 | AAPL | Stock | 4.9496 | 4.9639 | 4.9496 | 4.9564 | 5805604.0 |
| 2007-07-16 10:02:00 | AAPL | Stock | 4.9554 | 4.9554 | 4.9432 | 4.9486 | 7250404.0 |
| 2007-07-16 10:03:00 | AAPL | Stock | 4.9496 | 4.9554 | 4.9489 | 4.95 | 3566500.0 |
| 2007-07-16 10:04:00 | AAPL | Stock | 4.9507 | 4.9564 | 4.9464 | 4.955 | 3823512.0 |
| 2007-07-16 10:05:00 | AAPL | Stock | 4.9554 | 4.9554 | 4.9421 | 4.9443 | 6040804.0 |
| 2007-07-16 10:06:00 | AAPL | Stock | 4.9439 | 4.9521 | 4.9429 | 4.9496 | 3889956.0 |
| 2007-07-16 10:07:00 | AAPL | Stock | 4.9496 | 4.9496 | 4.9414 | 4.9468 | 4756360.0 |
| 2007-07-16 10:08:00 | AAPL | Stock | 4.9468 | 4.9529 | 4.9461 | 4.9496 | 3002104.0 |
| 2007-07-16 10:09:00 | AAPL | Stock | 4.9504 | 4.9586 | 4.95 | 4.9504 | 4952864.0 |
| 2007-07-16 10:10:00 | AAPL | Stock | 4.9504 | 4.9507 | 4.9457 | 4.9493 | 4111184.0 |
| 2007-07-16 10:11:00 | AAPL | Stock | 4.9493 | 4.9496 | 4.9454 | 4.9471 | 2769872.0 |
| 2007-07-16 10:12:00 | AAPL | Stock | 4.9471 | 4.9493 | 4.9382 | 4.9421 | 7399112.0 |
| 2007-07-16 10:13:00 | AAPL | Stock | 4.9418 | 4.9511 | 4.9414 | 4.9443 | 5525744.0 |
| 2007-07-16 10:14:00 | AAPL | Stock | 4.9439 | 4.9507 | 4.9418 | 4.9464 | 7028840.0 |
| 2007-07-16 10:15:00 | AAPL | Stock | 4.9464 | 4.9482 | 4.9425 | 4.945 | 4396616.0 |
| 2007-07-16 10:16:00 | AAPL | Stock | 4.945 | 4.9454 | 4.9368 | 4.9425 | 4913300.0 |
| 2007-07-16 10:17:00 | AAPL | Stock | 4.9421 | 4.9464 | 4.9418 | 4.9431 | 2375324.0 |
| 2007-07-16 10:18:00 | AAPL | Stock | 4.943 | 4.945 | 4.94 | 4.9411 | 3953292.0 |
| 2007-07-16 10:19:00 | AAPL | Stock | 4.9408 | 4.9496 | 4.94 | 4.9496 | 4163628.0 |
> showing 50 of 926,554 rows — these rows as CSV