PREVIEW / stock_1min / 2010-08-13
file: by_date/stock_1min/2010/2010-08-13.parquet size: 11.9 MB rows: 917,809 symbols: 2,801
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 |
|---|---|---|---|---|---|---|---|
| 2010-08-13 05:59:00 | AAPL | Stock | 8.9975 | 8.9975 | 8.9975 | 8.9975 | 5600.0 |
| 2010-08-13 06:06:00 | AAPL | Stock | 8.9725 | 8.9725 | 8.9725 | 8.9725 | 3808.0 |
| 2010-08-13 06:12:00 | AAPL | Stock | 8.9696 | 8.9696 | 8.9696 | 8.9696 | 5600.0 |
| 2010-08-13 07:12:00 | AAPL | Stock | 8.9714 | 8.9714 | 8.9439 | 8.9439 | 11200.0 |
| 2010-08-13 07:13:00 | AAPL | Stock | 8.975 | 8.975 | 8.975 | 8.975 | 5600.0 |
| 2010-08-13 07:15:00 | AAPL | Stock | 8.9757 | 8.9757 | 8.9757 | 8.9757 | 2800.0 |
| 2010-08-13 07:20:00 | AAPL | Stock | 8.9646 | 8.9646 | 8.9646 | 8.9646 | 2800.0 |
| 2010-08-13 07:23:00 | AAPL | Stock | 8.9579 | 8.9579 | 8.9579 | 8.9579 | 2800.0 |
| 2010-08-13 07:34:00 | AAPL | Stock | 8.95 | 8.95 | 8.95 | 8.95 | 2800.0 |
| 2010-08-13 07:51:00 | AAPL | Stock | 8.9575 | 8.9579 | 8.9575 | 8.9579 | 33040.0 |
| 2010-08-13 07:53:00 | AAPL | Stock | 8.9554 | 8.9596 | 8.9554 | 8.9596 | 26600.0 |
| 2010-08-13 08:00:00 | AAPL | Stock | 8.9636 | 8.975 | 8.9632 | 8.9643 | 42140.0 |
| 2010-08-13 08:01:00 | AAPL | Stock | 8.965 | 8.9654 | 8.9643 | 8.9643 | 36540.0 |
| 2010-08-13 08:02:00 | AAPL | Stock | 8.9643 | 8.9643 | 8.9643 | 8.9643 | 5600.0 |
| 2010-08-13 08:03:00 | AAPL | Stock | 8.9643 | 8.9643 | 8.9643 | 8.9643 | 11200.0 |
| 2010-08-13 08:04:00 | AAPL | Stock | 8.9646 | 8.9654 | 8.9646 | 8.9654 | 14252.0 |
| 2010-08-13 08:06:00 | AAPL | Stock | 8.9714 | 8.9821 | 8.9661 | 8.9661 | 122248.0 |
| 2010-08-13 08:07:00 | AAPL | Stock | 8.9725 | 8.9725 | 8.9721 | 8.9721 | 14000.0 |
| 2010-08-13 08:08:00 | AAPL | Stock | 8.975 | 8.975 | 8.975 | 8.975 | 2800.0 |
| 2010-08-13 08:10:00 | AAPL | Stock | 8.9746 | 8.975 | 8.9746 | 8.9746 | 60200.0 |
| 2010-08-13 08:11:00 | AAPL | Stock | 8.9725 | 8.9821 | 8.9721 | 8.9814 | 28000.0 |
| 2010-08-13 08:14:00 | AAPL | Stock | 8.9754 | 8.9754 | 8.9754 | 8.9754 | 3080.0 |
| 2010-08-13 08:15:00 | AAPL | Stock | 8.9775 | 8.9775 | 8.9721 | 8.9721 | 65800.0 |
| 2010-08-13 08:18:00 | AAPL | Stock | 8.9732 | 8.9732 | 8.9732 | 8.9732 | 28000.0 |
| 2010-08-13 08:19:00 | AAPL | Stock | 8.9679 | 8.9679 | 8.9629 | 8.9643 | 57316.0 |
| 2010-08-13 08:20:00 | AAPL | Stock | 8.9596 | 8.9596 | 8.9596 | 8.9596 | 8400.0 |
| 2010-08-13 08:21:00 | AAPL | Stock | 8.9596 | 8.9596 | 8.9596 | 8.9596 | 15260.0 |
| 2010-08-13 08:22:00 | AAPL | Stock | 8.9596 | 8.9643 | 8.9596 | 8.9643 | 8400.0 |
| 2010-08-13 08:23:00 | AAPL | Stock | 8.9621 | 8.9632 | 8.9621 | 8.9632 | 5600.0 |
| 2010-08-13 08:25:00 | AAPL | Stock | 8.9632 | 8.9643 | 8.9632 | 8.9643 | 9996.0 |
| 2010-08-13 08:26:00 | AAPL | Stock | 8.9721 | 8.9729 | 8.9721 | 8.9725 | 11200.0 |
| 2010-08-13 08:27:00 | AAPL | Stock | 8.9729 | 8.9729 | 8.9721 | 8.9725 | 23800.0 |
| 2010-08-13 08:28:00 | AAPL | Stock | 8.9729 | 8.9729 | 8.9729 | 8.9729 | 8400.0 |
| 2010-08-13 08:29:00 | AAPL | Stock | 8.9732 | 8.9732 | 8.9643 | 8.9643 | 36400.0 |
| 2010-08-13 08:30:00 | AAPL | Stock | 8.9675 | 8.9782 | 8.9643 | 8.965 | 196000.0 |
| 2010-08-13 08:31:00 | AAPL | Stock | 8.9682 | 8.9682 | 8.9654 | 8.9661 | 16828.0 |
| 2010-08-13 08:32:00 | AAPL | Stock | 8.9664 | 8.9679 | 8.9554 | 8.9554 | 275772.0 |
| 2010-08-13 08:33:00 | AAPL | Stock | 8.9614 | 8.9693 | 8.9589 | 8.9693 | 96404.0 |
| 2010-08-13 08:34:00 | AAPL | Stock | 8.9679 | 8.9796 | 8.9679 | 8.975 | 53144.0 |
| 2010-08-13 08:35:00 | AAPL | Stock | 8.9821 | 8.9854 | 8.9771 | 8.9811 | 78400.0 |
| 2010-08-13 08:36:00 | AAPL | Stock | 8.9793 | 8.9829 | 8.9786 | 8.9786 | 30800.0 |
| 2010-08-13 08:37:00 | AAPL | Stock | 8.9786 | 8.9968 | 8.9754 | 8.9957 | 258356.0 |
| 2010-08-13 08:38:00 | AAPL | Stock | 8.995 | 9.0 | 8.9843 | 8.9939 | 161980.0 |
| 2010-08-13 08:39:00 | AAPL | Stock | 8.9954 | 8.9961 | 8.9846 | 8.9857 | 83804.0 |
| 2010-08-13 08:40:00 | AAPL | Stock | 8.9914 | 8.9914 | 8.9857 | 8.9889 | 54796.0 |
| 2010-08-13 08:41:00 | AAPL | Stock | 8.9929 | 8.9986 | 8.9929 | 8.9961 | 123788.0 |
| 2010-08-13 08:42:00 | AAPL | Stock | 8.9954 | 9.0061 | 8.9954 | 9.0 | 190400.0 |
| 2010-08-13 08:43:00 | AAPL | Stock | 9.0 | 9.0 | 8.9932 | 8.9932 | 78400.0 |
| 2010-08-13 08:44:00 | AAPL | Stock | 8.9925 | 8.9932 | 8.9893 | 8.9918 | 81844.0 |
| 2010-08-13 08:45:00 | AAPL | Stock | 8.9946 | 8.9971 | 8.9946 | 8.9964 | 25200.0 |
> showing 50 of 917,809 rows — these rows as CSV