PREVIEW / stock_5min / 2008-09-24
file: by_date/stock_5min/2008/2008-09-24.parquet size: 4.3 MB rows: 308,178 symbols: 3,323
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 |
|---|---|---|---|---|---|---|---|
| 2008-09-24 05:45:00 | AAPL | Stock | 4.6071 | 4.6071 | 4.6071 | 4.6071 | 8400.0 |
| 2008-09-24 05:55:00 | AAPL | Stock | 4.6071 | 4.6071 | 4.5732 | 4.5732 | 7280.0 |
| 2008-09-24 06:05:00 | AAPL | Stock | 4.6071 | 4.6071 | 4.6071 | 4.6071 | 4480.0 |
| 2008-09-24 06:30:00 | AAPL | Stock | 4.5732 | 4.5732 | 4.5732 | 4.5732 | 5600.0 |
| 2008-09-24 06:40:00 | AAPL | Stock | 4.5732 | 4.5893 | 4.5732 | 4.5732 | 28000.0 |
| 2008-09-24 06:45:00 | AAPL | Stock | 4.5714 | 4.5714 | 4.5714 | 4.5714 | 2800.0 |
| 2008-09-24 06:50:00 | AAPL | Stock | 4.5893 | 4.5893 | 4.5893 | 4.5893 | 14000.0 |
| 2008-09-24 07:00:00 | AAPL | Stock | 4.5893 | 4.5893 | 4.5893 | 4.5893 | 70812.0 |
| 2008-09-24 07:05:00 | AAPL | Stock | 4.5893 | 4.6246 | 4.5893 | 4.6246 | 27888.0 |
| 2008-09-24 07:10:00 | AAPL | Stock | 4.6054 | 4.6054 | 4.605 | 4.605 | 9408.0 |
| 2008-09-24 07:15:00 | AAPL | Stock | 4.6036 | 4.6071 | 4.6032 | 4.6071 | 89600.0 |
| 2008-09-24 07:20:00 | AAPL | Stock | 4.5893 | 4.5893 | 4.5739 | 4.5739 | 62608.0 |
| 2008-09-24 07:30:00 | AAPL | Stock | 4.5664 | 4.5664 | 4.5643 | 4.5643 | 46564.0 |
| 2008-09-24 07:35:00 | AAPL | Stock | 4.555 | 4.5554 | 4.5521 | 4.5521 | 22820.0 |
| 2008-09-24 07:40:00 | AAPL | Stock | 4.5536 | 4.5536 | 4.5468 | 4.5468 | 30800.0 |
| 2008-09-24 07:45:00 | AAPL | Stock | 4.5536 | 4.5786 | 4.5475 | 4.5475 | 18088.0 |
| 2008-09-24 07:50:00 | AAPL | Stock | 4.55 | 4.55 | 4.5375 | 4.5396 | 44800.0 |
| 2008-09-24 07:55:00 | AAPL | Stock | 4.5446 | 4.5614 | 4.5446 | 4.5614 | 5600.0 |
| 2008-09-24 08:00:00 | AAPL | Stock | 4.5607 | 4.5714 | 4.5543 | 4.5668 | 536984.0 |
| 2008-09-24 08:05:00 | AAPL | Stock | 4.5571 | 4.5643 | 4.5464 | 4.5643 | 355292.0 |
| 2008-09-24 08:10:00 | AAPL | Stock | 4.5643 | 4.5804 | 4.5643 | 4.5714 | 530796.0 |
| 2008-09-24 08:15:00 | AAPL | Stock | 4.5714 | 4.5804 | 4.5696 | 4.5804 | 505904.0 |
| 2008-09-24 08:20:00 | AAPL | Stock | 4.575 | 4.5786 | 4.5696 | 4.5786 | 371896.0 |
| 2008-09-24 08:25:00 | AAPL | Stock | 4.5804 | 4.5889 | 4.5729 | 4.5821 | 359324.0 |
| 2008-09-24 08:30:00 | AAPL | Stock | 4.5786 | 4.5875 | 4.5771 | 4.5875 | 315840.0 |
| 2008-09-24 08:35:00 | AAPL | Stock | 4.5868 | 4.5871 | 4.5732 | 4.5768 | 308112.0 |
| 2008-09-24 08:40:00 | AAPL | Stock | 4.5764 | 4.5804 | 4.575 | 4.5804 | 133028.0 |
| 2008-09-24 08:45:00 | AAPL | Stock | 4.5786 | 4.5789 | 4.5714 | 4.5746 | 350840.0 |
| 2008-09-24 08:50:00 | AAPL | Stock | 4.575 | 4.5804 | 4.5732 | 4.5786 | 146720.0 |
| 2008-09-24 08:55:00 | AAPL | Stock | 4.5754 | 4.5857 | 4.5714 | 4.5857 | 457716.0 |
| 2008-09-24 09:00:00 | AAPL | Stock | 4.5857 | 4.5929 | 4.5804 | 4.5893 | 551768.0 |
| 2008-09-24 09:05:00 | AAPL | Stock | 4.5889 | 4.5889 | 4.5679 | 4.5714 | 808556.0 |
| 2008-09-24 09:10:00 | AAPL | Stock | 4.5682 | 4.5732 | 4.5586 | 4.5657 | 775600.0 |
| 2008-09-24 09:15:00 | AAPL | Stock | 4.5632 | 4.5632 | 4.5432 | 4.5482 | 1160684.0 |
| 2008-09-24 09:20:00 | AAPL | Stock | 4.5475 | 4.5571 | 4.5432 | 4.5539 | 663572.0 |
| 2008-09-24 09:25:00 | AAPL | Stock | 4.5529 | 4.5554 | 4.5393 | 4.5529 | 931560.0 |
| 2008-09-24 09:30:00 | AAPL | Stock | 4.5521 | 4.5775 | 4.5143 | 4.5332 | 33862248.0 |
| 2008-09-24 09:35:00 | AAPL | Stock | 4.5339 | 4.5639 | 4.5018 | 4.5639 | 28763196.0 |
| 2008-09-24 09:40:00 | AAPL | Stock | 4.5643 | 4.5646 | 4.495 | 4.5186 | 26993344.0 |
| 2008-09-24 09:45:00 | AAPL | Stock | 4.5182 | 4.5479 | 4.4696 | 4.5364 | 27076364.0 |
| 2008-09-24 09:50:00 | AAPL | Stock | 4.535 | 4.5539 | 4.5318 | 4.5421 | 18257036.0 |
| 2008-09-24 09:55:00 | AAPL | Stock | 4.5414 | 4.5757 | 4.5093 | 4.5614 | 24534636.0 |
| 2008-09-24 10:00:00 | AAPL | Stock | 4.5618 | 4.5871 | 4.5432 | 4.5607 | 21554512.0 |
| 2008-09-24 10:05:00 | AAPL | Stock | 4.5607 | 4.5661 | 4.5245 | 4.5393 | 14899668.0 |
| 2008-09-24 10:10:00 | AAPL | Stock | 4.5404 | 4.5564 | 4.5043 | 4.5179 | 18174520.0 |
| 2008-09-24 10:15:00 | AAPL | Stock | 4.5179 | 4.5429 | 4.5086 | 4.54 | 11742668.0 |
| 2008-09-24 10:20:00 | AAPL | Stock | 4.54 | 4.5554 | 4.5329 | 4.5432 | 14111776.0 |
| 2008-09-24 10:25:00 | AAPL | Stock | 4.5436 | 4.5779 | 4.5329 | 4.5693 | 15170820.0 |
| 2008-09-24 10:30:00 | AAPL | Stock | 4.5693 | 4.5982 | 4.5632 | 4.5793 | 17342080.0 |
| 2008-09-24 10:35:00 | AAPL | Stock | 4.5793 | 4.6107 | 4.5682 | 4.6004 | 19691616.0 |
> showing 50 of 308,178 rows — these rows as CSV