PREVIEW / stock_5min / 2009-08-25
file: by_date/stock_5min/2009/2009-08-25.parquet size: 4.6 MB rows: 315,559 symbols: 3,364
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-08-25 06:35:00 | AAPL | Stock | 6.0182 | 6.0182 | 6.0182 | 6.0182 | 14000.0 |
| 2009-08-25 07:30:00 | AAPL | Stock | 6.0357 | 6.0357 | 6.0357 | 6.0357 | 6160.0 |
| 2009-08-25 07:40:00 | AAPL | Stock | 6.0357 | 6.0429 | 6.0357 | 6.0429 | 8400.0 |
| 2009-08-25 07:50:00 | AAPL | Stock | 6.0429 | 6.0429 | 6.0429 | 6.0429 | 2800.0 |
| 2009-08-25 07:55:00 | AAPL | Stock | 6.0429 | 6.0429 | 6.0429 | 6.0429 | 5600.0 |
| 2009-08-25 08:00:00 | AAPL | Stock | 6.0432 | 6.0464 | 6.0432 | 6.0432 | 67480.0 |
| 2009-08-25 08:05:00 | AAPL | Stock | 6.0432 | 6.0625 | 6.0432 | 6.0625 | 168616.0 |
| 2009-08-25 08:10:00 | AAPL | Stock | 6.0607 | 6.0654 | 6.0607 | 6.0654 | 58744.0 |
| 2009-08-25 08:15:00 | AAPL | Stock | 6.0671 | 6.0725 | 6.0668 | 6.0714 | 651672.0 |
| 2009-08-25 08:20:00 | AAPL | Stock | 6.0711 | 6.0718 | 6.0696 | 6.0714 | 151480.0 |
| 2009-08-25 08:25:00 | AAPL | Stock | 6.0714 | 6.0714 | 6.0646 | 6.0661 | 83300.0 |
| 2009-08-25 08:30:00 | AAPL | Stock | 6.0643 | 6.0675 | 6.0607 | 6.0607 | 95200.0 |
| 2009-08-25 08:35:00 | AAPL | Stock | 6.0632 | 6.0643 | 6.0632 | 6.0632 | 14000.0 |
| 2009-08-25 08:40:00 | AAPL | Stock | 6.0632 | 6.0679 | 6.0632 | 6.0661 | 92148.0 |
| 2009-08-25 08:45:00 | AAPL | Stock | 6.0661 | 6.0793 | 6.0661 | 6.0764 | 601076.0 |
| 2009-08-25 08:50:00 | AAPL | Stock | 6.0768 | 6.0786 | 6.0714 | 6.0714 | 26068.0 |
| 2009-08-25 08:55:00 | AAPL | Stock | 6.0786 | 6.0804 | 6.0754 | 6.0804 | 209664.0 |
| 2009-08-25 09:00:00 | AAPL | Stock | 6.0786 | 6.085 | 6.0786 | 6.0786 | 103320.0 |
| 2009-08-25 09:05:00 | AAPL | Stock | 6.0786 | 6.0789 | 6.0771 | 6.0771 | 25200.0 |
| 2009-08-25 09:10:00 | AAPL | Stock | 6.0775 | 6.0775 | 6.0754 | 6.0754 | 54348.0 |
| 2009-08-25 09:15:00 | AAPL | Stock | 6.0761 | 6.0761 | 6.0689 | 6.0689 | 97804.0 |
| 2009-08-25 09:20:00 | AAPL | Stock | 6.0679 | 6.07 | 6.0632 | 6.0679 | 197680.0 |
| 2009-08-25 09:25:00 | AAPL | Stock | 6.0696 | 6.0711 | 6.0464 | 6.0514 | 641760.0 |
| 2009-08-25 09:30:00 | AAPL | Stock | 6.0539 | 6.0804 | 6.0493 | 6.0661 | 11282432.0 |
| 2009-08-25 09:35:00 | AAPL | Stock | 6.0654 | 6.0682 | 6.0432 | 6.0589 | 10890124.0 |
| 2009-08-25 09:40:00 | AAPL | Stock | 6.0579 | 6.0714 | 6.0543 | 6.0696 | 7201656.0 |
| 2009-08-25 09:45:00 | AAPL | Stock | 6.0704 | 6.0804 | 6.0682 | 6.0804 | 7448896.0 |
| 2009-08-25 09:50:00 | AAPL | Stock | 6.0804 | 6.0861 | 6.075 | 6.0807 | 6338080.0 |
| 2009-08-25 09:55:00 | AAPL | Stock | 6.0804 | 6.0893 | 6.0786 | 6.0893 | 5185208.0 |
| 2009-08-25 10:00:00 | AAPL | Stock | 6.0893 | 6.105 | 6.0818 | 6.0832 | 16589244.0 |
| 2009-08-25 10:05:00 | AAPL | Stock | 6.0843 | 6.085 | 6.0739 | 6.0811 | 6374900.0 |
| 2009-08-25 10:10:00 | AAPL | Stock | 6.0807 | 6.0886 | 6.0718 | 6.0771 | 5278616.0 |
| 2009-08-25 10:15:00 | AAPL | Stock | 6.0771 | 6.0789 | 6.0539 | 6.0564 | 10492244.0 |
| 2009-08-25 10:20:00 | AAPL | Stock | 6.0566 | 6.0704 | 6.0536 | 6.0661 | 6694800.0 |
| 2009-08-25 10:25:00 | AAPL | Stock | 6.0664 | 6.0737 | 6.0571 | 6.0572 | 5252660.0 |
| 2009-08-25 10:30:00 | AAPL | Stock | 6.0571 | 6.0639 | 6.0543 | 6.0639 | 4070108.0 |
| 2009-08-25 10:35:00 | AAPL | Stock | 6.0643 | 6.0786 | 6.0629 | 6.0725 | 4441724.0 |
| 2009-08-25 10:40:00 | AAPL | Stock | 6.0732 | 6.0804 | 6.0732 | 6.0786 | 3044244.0 |
| 2009-08-25 10:45:00 | AAPL | Stock | 6.0786 | 6.0796 | 6.075 | 6.0757 | 1656984.0 |
| 2009-08-25 10:50:00 | AAPL | Stock | 6.0761 | 6.0804 | 6.0675 | 6.07 | 4348876.0 |
| 2009-08-25 10:55:00 | AAPL | Stock | 6.0696 | 6.0729 | 6.0654 | 6.0707 | 2074380.0 |
| 2009-08-25 11:00:00 | AAPL | Stock | 6.0704 | 6.0818 | 6.0691 | 6.0775 | 3066476.0 |
| 2009-08-25 11:05:00 | AAPL | Stock | 6.0779 | 6.08 | 6.0704 | 6.0721 | 2229444.0 |
| 2009-08-25 11:10:00 | AAPL | Stock | 6.0714 | 6.0768 | 6.0679 | 6.0757 | 1987496.0 |
| 2009-08-25 11:15:00 | AAPL | Stock | 6.0761 | 6.0771 | 6.0729 | 6.0732 | 1547084.0 |
| 2009-08-25 11:20:00 | AAPL | Stock | 6.0732 | 6.075 | 6.0696 | 6.0704 | 1648780.0 |
| 2009-08-25 11:25:00 | AAPL | Stock | 6.0705 | 6.0768 | 6.0664 | 6.0756 | 3267292.0 |
| 2009-08-25 11:30:00 | AAPL | Stock | 6.0768 | 6.0846 | 6.0743 | 6.0843 | 3004848.0 |
| 2009-08-25 11:35:00 | AAPL | Stock | 6.0843 | 6.0854 | 6.08 | 6.085 | 1649816.0 |
| 2009-08-25 11:40:00 | AAPL | Stock | 6.0843 | 6.0921 | 6.0829 | 6.0875 | 3790220.0 |
> showing 50 of 315,559 rows — these rows as CSV