PREVIEW / stock_5min / 2009-06-26
file: by_date/stock_5min/2009/2009-06-26.parquet size: 5.2 MB rows: 358,871 symbols: 3,328
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 |
|---|---|---|---|---|---|---|---|
| 2009-06-26 07:05:00 | AAPL | Stock | 4.9907 | 4.9907 | 4.9907 | 4.9907 | 14000.0 |
| 2009-06-26 07:15:00 | AAPL | Stock | 4.9789 | 4.9789 | 4.9789 | 4.9789 | 33180.0 |
| 2009-06-26 07:30:00 | AAPL | Stock | 4.9821 | 4.9821 | 4.9821 | 4.9821 | 5600.0 |
| 2009-06-26 07:45:00 | AAPL | Stock | 4.9821 | 4.9821 | 4.9821 | 4.9821 | 8400.0 |
| 2009-06-26 07:55:00 | AAPL | Stock | 4.9821 | 4.9821 | 4.9821 | 4.9821 | 18900.0 |
| 2009-06-26 08:00:00 | AAPL | Stock | 4.9861 | 4.9861 | 4.9857 | 4.9857 | 27440.0 |
| 2009-06-26 08:05:00 | AAPL | Stock | 4.9857 | 4.9857 | 4.9857 | 4.9857 | 3416.0 |
| 2009-06-26 08:10:00 | AAPL | Stock | 4.9893 | 4.9893 | 4.9821 | 4.9821 | 28336.0 |
| 2009-06-26 08:15:00 | AAPL | Stock | 4.9857 | 4.9857 | 4.9839 | 4.9839 | 14000.0 |
| 2009-06-26 08:20:00 | AAPL | Stock | 4.9821 | 4.9821 | 4.9821 | 4.9821 | 14000.0 |
| 2009-06-26 08:25:00 | AAPL | Stock | 4.9836 | 4.9893 | 4.9836 | 4.9893 | 51100.0 |
| 2009-06-26 08:30:00 | AAPL | Stock | 4.9893 | 5.0071 | 4.9893 | 5.0036 | 564564.0 |
| 2009-06-26 08:35:00 | AAPL | Stock | 5.0036 | 5.0068 | 5.0032 | 5.0032 | 254268.0 |
| 2009-06-26 08:40:00 | AAPL | Stock | 5.0021 | 5.0021 | 4.9982 | 4.9986 | 77280.0 |
| 2009-06-26 08:45:00 | AAPL | Stock | 4.9982 | 5.0 | 4.9964 | 4.9964 | 106344.0 |
| 2009-06-26 08:50:00 | AAPL | Stock | 4.9946 | 4.9982 | 4.9925 | 4.9982 | 28280.0 |
| 2009-06-26 08:55:00 | AAPL | Stock | 4.9986 | 4.9986 | 4.9932 | 4.9932 | 30800.0 |
| 2009-06-26 09:00:00 | AAPL | Stock | 4.9975 | 4.9975 | 4.9911 | 4.9929 | 33600.0 |
| 2009-06-26 09:05:00 | AAPL | Stock | 4.9961 | 4.9961 | 4.9921 | 4.9921 | 53536.0 |
| 2009-06-26 09:10:00 | AAPL | Stock | 4.9961 | 4.9993 | 4.9961 | 4.9993 | 21896.0 |
| 2009-06-26 09:20:00 | AAPL | Stock | 4.9946 | 4.9946 | 4.9946 | 4.9946 | 5600.0 |
| 2009-06-26 09:25:00 | AAPL | Stock | 4.9943 | 4.9964 | 4.9857 | 4.9857 | 185640.0 |
| 2009-06-26 09:30:00 | AAPL | Stock | 4.9925 | 5.025 | 4.9907 | 5.0193 | 17278464.0 |
| 2009-06-26 09:35:00 | AAPL | Stock | 5.0189 | 5.0446 | 5.0157 | 5.0271 | 18101888.0 |
| 2009-06-26 09:40:00 | AAPL | Stock | 5.0275 | 5.0704 | 5.0264 | 5.065 | 18238696.0 |
| 2009-06-26 09:45:00 | AAPL | Stock | 5.065 | 5.0696 | 5.0564 | 5.0615 | 15663788.0 |
| 2009-06-26 09:50:00 | AAPL | Stock | 5.0625 | 5.0782 | 5.0543 | 5.0725 | 15612268.0 |
| 2009-06-26 09:55:00 | AAPL | Stock | 5.0721 | 5.0736 | 5.0536 | 5.0604 | 11119864.0 |
| 2009-06-26 10:00:00 | AAPL | Stock | 5.0589 | 5.0704 | 5.0539 | 5.0643 | 7054712.0 |
| 2009-06-26 10:05:00 | AAPL | Stock | 5.0664 | 5.0689 | 5.0518 | 5.0558 | 7482804.0 |
| 2009-06-26 10:10:00 | AAPL | Stock | 5.0554 | 5.0661 | 5.0421 | 5.0507 | 7726404.0 |
| 2009-06-26 10:15:00 | AAPL | Stock | 5.0511 | 5.0621 | 5.0482 | 5.0582 | 5717824.0 |
| 2009-06-26 10:20:00 | AAPL | Stock | 5.0586 | 5.0732 | 5.0554 | 5.0711 | 7937048.0 |
| 2009-06-26 10:25:00 | AAPL | Stock | 5.0711 | 5.0714 | 5.0582 | 5.0621 | 5328904.0 |
| 2009-06-26 10:30:00 | AAPL | Stock | 5.0624 | 5.0654 | 5.055 | 5.0575 | 5406128.0 |
| 2009-06-26 10:35:00 | AAPL | Stock | 5.0575 | 5.0661 | 5.0554 | 5.0579 | 6053628.0 |
| 2009-06-26 10:40:00 | AAPL | Stock | 5.0579 | 5.0661 | 5.0536 | 5.0661 | 5159280.0 |
| 2009-06-26 10:45:00 | AAPL | Stock | 5.0657 | 5.0661 | 5.0594 | 5.0639 | 2813076.0 |
| 2009-06-26 10:50:00 | AAPL | Stock | 5.0632 | 5.0661 | 5.0539 | 5.055 | 3365208.0 |
| 2009-06-26 10:55:00 | AAPL | Stock | 5.0554 | 5.0606 | 5.0554 | 5.0596 | 1755320.0 |
| 2009-06-26 11:00:00 | AAPL | Stock | 5.0596 | 5.0625 | 5.0504 | 5.0546 | 4191012.0 |
| 2009-06-26 11:05:00 | AAPL | Stock | 5.0546 | 5.0618 | 5.0525 | 5.0579 | 3145716.0 |
| 2009-06-26 11:10:00 | AAPL | Stock | 5.0575 | 5.0639 | 5.0536 | 5.0618 | 3854732.0 |
| 2009-06-26 11:15:00 | AAPL | Stock | 5.0614 | 5.0629 | 5.0568 | 5.0611 | 1806028.0 |
| 2009-06-26 11:20:00 | AAPL | Stock | 5.0611 | 5.0621 | 5.0521 | 5.0573 | 3366076.0 |
| 2009-06-26 11:25:00 | AAPL | Stock | 5.0579 | 5.0607 | 5.0546 | 5.0604 | 1671992.0 |
| 2009-06-26 11:30:00 | AAPL | Stock | 5.06 | 5.065 | 5.06 | 5.0629 | 3028340.0 |
| 2009-06-26 11:35:00 | AAPL | Stock | 5.0625 | 5.0654 | 5.0621 | 5.0646 | 2777488.0 |
| 2009-06-26 11:40:00 | AAPL | Stock | 5.065 | 5.0661 | 5.0611 | 5.0625 | 2846452.0 |
| 2009-06-26 11:45:00 | AAPL | Stock | 5.0625 | 5.0661 | 5.0611 | 5.0648 | 2170056.0 |
> showing 50 of 358,871 rows — these rows as CSV