PREVIEW / stock_5min / 2006-11-10
file: by_date/stock_5min/2006/2006-11-10.parquet size: 3.2 MB rows: 232,209 symbols: 2,442
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 |
|---|---|---|---|---|---|---|---|
| 2006-11-10 07:50:00 | AAPL | Stock | 2.9857 | 2.9857 | 2.9857 | 2.9857 | 2800.0 |
| 2006-11-10 08:00:00 | AAPL | Stock | 2.985 | 2.9907 | 2.985 | 2.9886 | 181104.0 |
| 2006-11-10 08:05:00 | AAPL | Stock | 2.9886 | 2.9886 | 2.9832 | 2.9832 | 50316.0 |
| 2006-11-10 08:10:00 | AAPL | Stock | 2.9821 | 2.9821 | 2.9821 | 2.9821 | 6160.0 |
| 2006-11-10 08:15:00 | AAPL | Stock | 2.9821 | 2.9821 | 2.9821 | 2.9821 | 25200.0 |
| 2006-11-10 08:20:00 | AAPL | Stock | 2.9821 | 2.9854 | 2.9786 | 2.9854 | 92400.0 |
| 2006-11-10 08:25:00 | AAPL | Stock | 2.985 | 2.985 | 2.9821 | 2.9832 | 21000.0 |
| 2006-11-10 08:30:00 | AAPL | Stock | 2.9832 | 2.9832 | 2.9821 | 2.9821 | 30800.0 |
| 2006-11-10 08:35:00 | AAPL | Stock | 2.9821 | 2.9839 | 2.9821 | 2.9839 | 40040.0 |
| 2006-11-10 08:40:00 | AAPL | Stock | 2.985 | 2.985 | 2.9821 | 2.9821 | 39200.0 |
| 2006-11-10 08:45:00 | AAPL | Stock | 2.985 | 2.9886 | 2.9836 | 2.985 | 323288.0 |
| 2006-11-10 08:50:00 | AAPL | Stock | 2.9854 | 2.9857 | 2.9854 | 2.9857 | 67200.0 |
| 2006-11-10 08:55:00 | AAPL | Stock | 2.9875 | 2.9893 | 2.9875 | 2.9875 | 123900.0 |
| 2006-11-10 09:00:00 | AAPL | Stock | 2.9857 | 2.9875 | 2.9811 | 2.9825 | 242480.0 |
| 2006-11-10 09:05:00 | AAPL | Stock | 2.9839 | 2.9864 | 2.9825 | 2.9825 | 101360.0 |
| 2006-11-10 09:10:00 | AAPL | Stock | 2.9839 | 2.9839 | 2.9825 | 2.9825 | 56000.0 |
| 2006-11-10 09:15:00 | AAPL | Stock | 2.9839 | 2.9839 | 2.9839 | 2.9839 | 12600.0 |
| 2006-11-10 09:20:00 | AAPL | Stock | 2.9825 | 2.9825 | 2.9732 | 2.9732 | 217000.0 |
| 2006-11-10 09:25:00 | AAPL | Stock | 2.9732 | 2.9879 | 2.9721 | 2.985 | 733096.0 |
| 2006-11-10 09:30:00 | AAPL | Stock | 2.9857 | 2.9857 | 2.9689 | 2.9804 | 19217184.0 |
| 2006-11-10 09:35:00 | AAPL | Stock | 2.98 | 2.9821 | 2.9714 | 2.975 | 13127240.0 |
| 2006-11-10 09:40:00 | AAPL | Stock | 2.9746 | 2.9754 | 2.9554 | 2.9607 | 18467400.0 |
| 2006-11-10 09:45:00 | AAPL | Stock | 2.9604 | 2.9668 | 2.9571 | 2.9604 | 11000136.0 |
| 2006-11-10 09:50:00 | AAPL | Stock | 2.9596 | 2.9718 | 2.955 | 2.9561 | 14412888.0 |
| 2006-11-10 09:55:00 | AAPL | Stock | 2.9561 | 2.9593 | 2.9464 | 2.9579 | 11521496.0 |
| 2006-11-10 10:00:00 | AAPL | Stock | 2.9579 | 2.9736 | 2.9568 | 2.9704 | 13967352.0 |
| 2006-11-10 10:05:00 | AAPL | Stock | 2.9707 | 2.9721 | 2.96 | 2.9661 | 6163416.0 |
| 2006-11-10 10:10:00 | AAPL | Stock | 2.9646 | 2.9696 | 2.96 | 2.9695 | 6064856.0 |
| 2006-11-10 10:15:00 | AAPL | Stock | 2.9693 | 2.9757 | 2.9682 | 2.975 | 7758604.0 |
| 2006-11-10 10:20:00 | AAPL | Stock | 2.975 | 2.9754 | 2.9589 | 2.9621 | 8543024.0 |
| 2006-11-10 10:25:00 | AAPL | Stock | 2.9625 | 2.9661 | 2.9536 | 2.9557 | 6167644.0 |
| 2006-11-10 10:30:00 | AAPL | Stock | 2.9558 | 2.9625 | 2.9511 | 2.9611 | 7125608.0 |
| 2006-11-10 10:35:00 | AAPL | Stock | 2.9611 | 2.9621 | 2.9546 | 2.9571 | 4604908.0 |
| 2006-11-10 10:40:00 | AAPL | Stock | 2.9564 | 2.9636 | 2.9561 | 2.9611 | 5267220.0 |
| 2006-11-10 10:45:00 | AAPL | Stock | 2.9614 | 2.9714 | 2.9611 | 2.9664 | 6319264.0 |
| 2006-11-10 10:50:00 | AAPL | Stock | 2.9662 | 2.97 | 2.965 | 2.9661 | 2611448.0 |
| 2006-11-10 10:55:00 | AAPL | Stock | 2.9668 | 2.9696 | 2.9625 | 2.9643 | 3729264.0 |
| 2006-11-10 11:00:00 | AAPL | Stock | 2.9643 | 2.965 | 2.9575 | 2.9593 | 3286864.0 |
| 2006-11-10 11:05:00 | AAPL | Stock | 2.9593 | 2.9618 | 2.9554 | 2.96 | 4720688.0 |
| 2006-11-10 11:10:00 | AAPL | Stock | 2.9602 | 2.9618 | 2.9561 | 2.9561 | 2758952.0 |
| 2006-11-10 11:15:00 | AAPL | Stock | 2.9557 | 2.9632 | 2.9536 | 2.9604 | 3472644.0 |
| 2006-11-10 11:20:00 | AAPL | Stock | 2.9607 | 2.9625 | 2.9536 | 2.9582 | 2690828.0 |
| 2006-11-10 11:25:00 | AAPL | Stock | 2.9582 | 2.96 | 2.9557 | 2.9582 | 2076004.0 |
| 2006-11-10 11:30:00 | AAPL | Stock | 2.9586 | 2.9643 | 2.9579 | 2.9596 | 4750144.0 |
| 2006-11-10 11:35:00 | AAPL | Stock | 2.9602 | 2.9643 | 2.9596 | 2.9643 | 3266396.0 |
| 2006-11-10 11:40:00 | AAPL | Stock | 2.9643 | 2.9661 | 2.9621 | 2.9621 | 2409316.0 |
| 2006-11-10 11:45:00 | AAPL | Stock | 2.9625 | 2.9643 | 2.9532 | 2.9557 | 3920952.0 |
| 2006-11-10 11:50:00 | AAPL | Stock | 2.955 | 2.9582 | 2.95 | 2.9546 | 5485620.0 |
| 2006-11-10 11:55:00 | AAPL | Stock | 2.9546 | 2.9557 | 2.9536 | 2.9539 | 1716596.0 |
| 2006-11-10 12:00:00 | AAPL | Stock | 2.9539 | 2.9589 | 2.9536 | 2.9568 | 2930172.0 |
> showing 50 of 232,209 rows — these rows as CSV