PREVIEW / stock_5min / 2006-11-20
file: by_date/stock_5min/2006/2006-11-20.parquet size: 3.2 MB rows: 234,284 symbols: 2,446
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-20 04:15:00 | AAPL | Stock | 3.0575 | 3.0575 | 3.0575 | 3.0575 | 14000.0 |
| 2006-11-20 07:15:00 | AAPL | Stock | 3.0454 | 3.0454 | 3.0404 | 3.0404 | 26600.0 |
| 2006-11-20 07:20:00 | AAPL | Stock | 3.0454 | 3.0521 | 3.0454 | 3.0521 | 12600.0 |
| 2006-11-20 07:30:00 | AAPL | Stock | 3.0521 | 3.0521 | 3.0521 | 3.0521 | 2800.0 |
| 2006-11-20 07:35:00 | AAPL | Stock | 3.0521 | 3.0521 | 3.0521 | 3.0521 | 4676.0 |
| 2006-11-20 07:40:00 | AAPL | Stock | 3.0529 | 3.0529 | 3.0529 | 3.0529 | 2800.0 |
| 2006-11-20 08:00:00 | AAPL | Stock | 3.0525 | 3.0636 | 3.0525 | 3.0636 | 100996.0 |
| 2006-11-20 08:05:00 | AAPL | Stock | 3.0636 | 3.0643 | 3.0625 | 3.0643 | 74900.0 |
| 2006-11-20 08:10:00 | AAPL | Stock | 3.0643 | 3.0643 | 3.0539 | 3.0571 | 26740.0 |
| 2006-11-20 08:20:00 | AAPL | Stock | 3.0625 | 3.0625 | 3.0625 | 3.0625 | 2800.0 |
| 2006-11-20 08:25:00 | AAPL | Stock | 3.0625 | 3.0625 | 3.0625 | 3.0625 | 42000.0 |
| 2006-11-20 08:30:00 | AAPL | Stock | 3.0625 | 3.0625 | 3.0593 | 3.0607 | 54600.0 |
| 2006-11-20 08:35:00 | AAPL | Stock | 3.0643 | 3.0657 | 3.0643 | 3.0657 | 60340.0 |
| 2006-11-20 08:40:00 | AAPL | Stock | 3.0607 | 3.0607 | 3.0607 | 3.0607 | 39004.0 |
| 2006-11-20 08:45:00 | AAPL | Stock | 3.0607 | 3.0625 | 3.06 | 3.0625 | 76916.0 |
| 2006-11-20 08:50:00 | AAPL | Stock | 3.0639 | 3.0639 | 3.0625 | 3.0636 | 56000.0 |
| 2006-11-20 09:00:00 | AAPL | Stock | 3.0607 | 3.0607 | 3.0607 | 3.0607 | 44380.0 |
| 2006-11-20 09:05:00 | AAPL | Stock | 3.0607 | 3.0607 | 3.0593 | 3.06 | 143220.0 |
| 2006-11-20 09:10:00 | AAPL | Stock | 3.0593 | 3.0643 | 3.0571 | 3.0643 | 72492.0 |
| 2006-11-20 09:15:00 | AAPL | Stock | 3.0607 | 3.0607 | 3.0607 | 3.0607 | 2800.0 |
| 2006-11-20 09:25:00 | AAPL | Stock | 3.0593 | 3.0593 | 3.0486 | 3.0511 | 704760.0 |
| 2006-11-20 09:30:00 | AAPL | Stock | 3.05 | 3.0639 | 3.0489 | 3.0607 | 11684708.0 |
| 2006-11-20 09:35:00 | AAPL | Stock | 3.0607 | 3.0664 | 3.0539 | 3.0632 | 12574576.0 |
| 2006-11-20 09:40:00 | AAPL | Stock | 3.0636 | 3.0639 | 3.0475 | 3.0489 | 11878944.0 |
| 2006-11-20 09:45:00 | AAPL | Stock | 3.0493 | 3.0571 | 3.0436 | 3.055 | 10876740.0 |
| 2006-11-20 09:50:00 | AAPL | Stock | 3.055 | 3.0554 | 3.0504 | 3.0511 | 6474580.0 |
| 2006-11-20 09:55:00 | AAPL | Stock | 3.0517 | 3.0536 | 3.0429 | 3.0529 | 11231584.0 |
| 2006-11-20 10:00:00 | AAPL | Stock | 3.0529 | 3.0625 | 3.0514 | 3.0557 | 11909436.0 |
| 2006-11-20 10:05:00 | AAPL | Stock | 3.0557 | 3.0582 | 3.0479 | 3.0532 | 6219584.0 |
| 2006-11-20 10:10:00 | AAPL | Stock | 3.0536 | 3.0536 | 3.0482 | 3.0496 | 4291028.0 |
| 2006-11-20 10:15:00 | AAPL | Stock | 3.05 | 3.0557 | 3.0482 | 3.055 | 5251064.0 |
| 2006-11-20 10:20:00 | AAPL | Stock | 3.0554 | 3.0561 | 3.0514 | 3.0539 | 4136720.0 |
| 2006-11-20 10:25:00 | AAPL | Stock | 3.0539 | 3.0564 | 3.0464 | 3.0546 | 4338768.0 |
| 2006-11-20 10:30:00 | AAPL | Stock | 3.0546 | 3.0625 | 3.0546 | 3.0621 | 7037324.0 |
| 2006-11-20 10:35:00 | AAPL | Stock | 3.0625 | 3.0771 | 3.0604 | 3.0757 | 10529344.0 |
| 2006-11-20 10:40:00 | AAPL | Stock | 3.0768 | 3.0796 | 3.0725 | 3.0736 | 13064156.0 |
| 2006-11-20 10:45:00 | AAPL | Stock | 3.0736 | 3.0796 | 3.0718 | 3.0768 | 7397516.0 |
| 2006-11-20 10:50:00 | AAPL | Stock | 3.0768 | 3.0907 | 3.075 | 3.0839 | 15935164.0 |
| 2006-11-20 10:55:00 | AAPL | Stock | 3.0843 | 3.1071 | 3.0807 | 3.0914 | 14940044.0 |
| 2006-11-20 11:00:00 | AAPL | Stock | 3.0911 | 3.0954 | 3.0875 | 3.0893 | 7502880.0 |
| 2006-11-20 11:05:00 | AAPL | Stock | 3.0889 | 3.0961 | 3.0857 | 3.0936 | 9485084.0 |
| 2006-11-20 11:10:00 | AAPL | Stock | 3.0932 | 3.0939 | 3.0839 | 3.0882 | 5955600.0 |
| 2006-11-20 11:15:00 | AAPL | Stock | 3.0889 | 3.0904 | 3.0839 | 3.0846 | 5264280.0 |
| 2006-11-20 11:20:00 | AAPL | Stock | 3.0846 | 3.0871 | 3.0789 | 3.0871 | 6911800.0 |
| 2006-11-20 11:25:00 | AAPL | Stock | 3.0875 | 3.0889 | 3.08 | 3.0843 | 5671372.0 |
| 2006-11-20 11:30:00 | AAPL | Stock | 3.0843 | 3.0875 | 3.0836 | 3.0857 | 2735656.0 |
| 2006-11-20 11:35:00 | AAPL | Stock | 3.0857 | 3.0879 | 3.0811 | 3.0821 | 5141248.0 |
| 2006-11-20 11:40:00 | AAPL | Stock | 3.0821 | 3.0893 | 3.0818 | 3.0832 | 2769592.0 |
| 2006-11-20 11:45:00 | AAPL | Stock | 3.0832 | 3.0921 | 3.0832 | 3.0914 | 5020176.0 |
| 2006-11-20 11:50:00 | AAPL | Stock | 3.0914 | 3.0989 | 3.0911 | 3.0971 | 9251284.0 |
> showing 50 of 234,284 rows — these rows as CSV