PREVIEW / stock_1min / 2006-09-27
file: by_date/stock_1min/2006/2006-09-27.parquet size: 8.5 MB rows: 694,887 symbols: 1,931
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-09-27 04:15:00 | AAPL | Stock | 2.7661 | 2.7661 | 2.7661 | 2.7661 | 3920.0 |
| 2006-09-27 07:51:00 | AAPL | Stock | 2.7843 | 2.7843 | 2.7843 | 2.7843 | 5600.0 |
| 2006-09-27 07:56:00 | AAPL | Stock | 2.7829 | 2.7829 | 2.7829 | 2.7829 | 11200.0 |
| 2006-09-27 08:00:00 | AAPL | Stock | 2.7829 | 2.7839 | 2.7829 | 2.7839 | 21000.0 |
| 2006-09-27 08:01:00 | AAPL | Stock | 2.7839 | 2.7857 | 2.7821 | 2.7821 | 160440.0 |
| 2006-09-27 08:02:00 | AAPL | Stock | 2.7854 | 2.7857 | 2.7829 | 2.7857 | 65576.0 |
| 2006-09-27 08:03:00 | AAPL | Stock | 2.7857 | 2.7857 | 2.7857 | 2.7857 | 2800.0 |
| 2006-09-27 08:04:00 | AAPL | Stock | 2.7854 | 2.7857 | 2.7804 | 2.7854 | 29400.0 |
| 2006-09-27 08:05:00 | AAPL | Stock | 2.7857 | 2.7857 | 2.7854 | 2.7854 | 200760.0 |
| 2006-09-27 08:06:00 | AAPL | Stock | 2.7821 | 2.7821 | 2.7821 | 2.7821 | 14000.0 |
| 2006-09-27 08:07:00 | AAPL | Stock | 2.7821 | 2.7821 | 2.7821 | 2.7821 | 2800.0 |
| 2006-09-27 08:08:00 | AAPL | Stock | 2.7854 | 2.7854 | 2.7821 | 2.7821 | 28000.0 |
| 2006-09-27 08:09:00 | AAPL | Stock | 2.7857 | 2.7857 | 2.7857 | 2.7857 | 2800.0 |
| 2006-09-27 08:10:00 | AAPL | Stock | 2.7857 | 2.7857 | 2.7825 | 2.7825 | 23800.0 |
| 2006-09-27 08:12:00 | AAPL | Stock | 2.7857 | 2.7857 | 2.7821 | 2.7821 | 36400.0 |
| 2006-09-27 08:13:00 | AAPL | Stock | 2.7825 | 2.7825 | 2.7825 | 2.7825 | 33600.0 |
| 2006-09-27 08:14:00 | AAPL | Stock | 2.7857 | 2.7868 | 2.7857 | 2.7857 | 52500.0 |
| 2006-09-27 08:15:00 | AAPL | Stock | 2.7857 | 2.7857 | 2.7846 | 2.7857 | 95200.0 |
| 2006-09-27 08:16:00 | AAPL | Stock | 2.7857 | 2.7857 | 2.7857 | 2.7857 | 30800.0 |
| 2006-09-27 08:17:00 | AAPL | Stock | 2.7857 | 2.7857 | 2.7857 | 2.7857 | 53200.0 |
| 2006-09-27 08:18:00 | AAPL | Stock | 2.7843 | 2.7857 | 2.7843 | 2.7857 | 8400.0 |
| 2006-09-27 08:19:00 | AAPL | Stock | 2.7864 | 2.7889 | 2.7857 | 2.7879 | 188440.0 |
| 2006-09-27 08:20:00 | AAPL | Stock | 2.7879 | 2.7879 | 2.7879 | 2.7879 | 76160.0 |
| 2006-09-27 08:21:00 | AAPL | Stock | 2.7879 | 2.7879 | 2.7857 | 2.7857 | 20300.0 |
| 2006-09-27 08:22:00 | AAPL | Stock | 2.7857 | 2.7857 | 2.7839 | 2.7839 | 71400.0 |
| 2006-09-27 08:23:00 | AAPL | Stock | 2.7846 | 2.7846 | 2.7846 | 2.7846 | 14000.0 |
| 2006-09-27 08:24:00 | AAPL | Stock | 2.7843 | 2.7843 | 2.7832 | 2.7839 | 107800.0 |
| 2006-09-27 08:25:00 | AAPL | Stock | 2.7832 | 2.7854 | 2.7821 | 2.7854 | 114800.0 |
| 2006-09-27 08:26:00 | AAPL | Stock | 2.7821 | 2.7829 | 2.7821 | 2.7829 | 22400.0 |
| 2006-09-27 08:27:00 | AAPL | Stock | 2.7846 | 2.785 | 2.7832 | 2.7832 | 63000.0 |
| 2006-09-27 08:28:00 | AAPL | Stock | 2.7854 | 2.7854 | 2.7825 | 2.7832 | 70000.0 |
| 2006-09-27 08:29:00 | AAPL | Stock | 2.7825 | 2.785 | 2.7825 | 2.7832 | 25956.0 |
| 2006-09-27 08:30:00 | AAPL | Stock | 2.7839 | 2.7857 | 2.7804 | 2.7804 | 651756.0 |
| 2006-09-27 08:31:00 | AAPL | Stock | 2.7804 | 2.7804 | 2.7789 | 2.7793 | 448000.0 |
| 2006-09-27 08:32:00 | AAPL | Stock | 2.7793 | 2.7818 | 2.7793 | 2.78 | 56000.0 |
| 2006-09-27 08:33:00 | AAPL | Stock | 2.7804 | 2.7804 | 2.775 | 2.7779 | 458864.0 |
| 2006-09-27 08:34:00 | AAPL | Stock | 2.7768 | 2.7786 | 2.7754 | 2.7754 | 173880.0 |
| 2006-09-27 08:35:00 | AAPL | Stock | 2.7779 | 2.7782 | 2.7757 | 2.7768 | 106400.0 |
| 2006-09-27 08:36:00 | AAPL | Stock | 2.7782 | 2.7782 | 2.7732 | 2.7732 | 402836.0 |
| 2006-09-27 08:37:00 | AAPL | Stock | 2.7736 | 2.7736 | 2.7725 | 2.7725 | 235200.0 |
| 2006-09-27 08:38:00 | AAPL | Stock | 2.7721 | 2.7732 | 2.7714 | 2.7732 | 121520.0 |
| 2006-09-27 08:39:00 | AAPL | Stock | 2.7736 | 2.775 | 2.7721 | 2.7746 | 156800.0 |
| 2006-09-27 08:40:00 | AAPL | Stock | 2.7746 | 2.7746 | 2.7661 | 2.7686 | 575260.0 |
| 2006-09-27 08:41:00 | AAPL | Stock | 2.7664 | 2.7679 | 2.7632 | 2.7646 | 271600.0 |
| 2006-09-27 08:42:00 | AAPL | Stock | 2.7646 | 2.7646 | 2.7543 | 2.7579 | 784980.0 |
| 2006-09-27 08:43:00 | AAPL | Stock | 2.7571 | 2.7593 | 2.7543 | 2.7554 | 502600.0 |
| 2006-09-27 08:44:00 | AAPL | Stock | 2.7564 | 2.7564 | 2.7543 | 2.7554 | 156800.0 |
| 2006-09-27 08:45:00 | AAPL | Stock | 2.7554 | 2.7554 | 2.7525 | 2.7525 | 476616.0 |
| 2006-09-27 08:46:00 | AAPL | Stock | 2.7532 | 2.7536 | 2.7507 | 2.7525 | 459340.0 |
| 2006-09-27 08:47:00 | AAPL | Stock | 2.7525 | 2.7554 | 2.7525 | 2.755 | 393288.0 |
> showing 50 of 694,887 rows — these rows as CSV