PREVIEW / stock_1min / 2004-10-14
file: by_date/stock_1min/2004/2004-10-14.parquet size: 5.8 MB rows: 485,660 symbols: 1,509
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 |
|---|---|---|---|---|---|---|---|
| 2004-10-14 08:00:00 | AAPL | Stock | 0.7696 | 0.7738 | 0.768 | 0.7738 | 1387512.0 |
| 2004-10-14 08:01:00 | AAPL | Stock | 0.7723 | 0.7732 | 0.7705 | 0.7723 | 2702952.0 |
| 2004-10-14 08:02:00 | AAPL | Stock | 0.7714 | 0.7732 | 0.7661 | 0.7723 | 730800.0 |
| 2004-10-14 08:03:00 | AAPL | Stock | 0.773 | 0.7759 | 0.7716 | 0.7759 | 3236240.0 |
| 2004-10-14 08:04:00 | AAPL | Stock | 0.7729 | 0.7759 | 0.7723 | 0.775 | 3941896.0 |
| 2004-10-14 08:05:00 | AAPL | Stock | 0.775 | 0.775 | 0.7732 | 0.7732 | 1047200.0 |
| 2004-10-14 08:06:00 | AAPL | Stock | 0.7732 | 0.7732 | 0.7714 | 0.7716 | 1846768.0 |
| 2004-10-14 08:07:00 | AAPL | Stock | 0.7714 | 0.7716 | 0.7688 | 0.7698 | 1253000.0 |
| 2004-10-14 08:08:00 | AAPL | Stock | 0.7696 | 0.7709 | 0.7679 | 0.7689 | 1155784.0 |
| 2004-10-14 08:09:00 | AAPL | Stock | 0.7682 | 0.7696 | 0.7679 | 0.7688 | 862960.0 |
| 2004-10-14 08:10:00 | AAPL | Stock | 0.7695 | 0.7695 | 0.7661 | 0.7682 | 463568.0 |
| 2004-10-14 08:11:00 | AAPL | Stock | 0.768 | 0.7682 | 0.7679 | 0.7679 | 855120.0 |
| 2004-10-14 08:12:00 | AAPL | Stock | 0.7679 | 0.7688 | 0.7679 | 0.7682 | 476560.0 |
| 2004-10-14 08:13:00 | AAPL | Stock | 0.7682 | 0.7704 | 0.7682 | 0.7704 | 386400.0 |
| 2004-10-14 08:14:00 | AAPL | Stock | 0.7695 | 0.7696 | 0.7695 | 0.7696 | 86464.0 |
| 2004-10-14 08:15:00 | AAPL | Stock | 0.7696 | 0.7696 | 0.7696 | 0.7696 | 140000.0 |
| 2004-10-14 08:16:00 | AAPL | Stock | 0.7696 | 0.7723 | 0.7688 | 0.7705 | 3225600.0 |
| 2004-10-14 08:17:00 | AAPL | Stock | 0.7723 | 0.7732 | 0.7716 | 0.7732 | 1394680.0 |
| 2004-10-14 08:18:00 | AAPL | Stock | 0.7732 | 0.7768 | 0.7714 | 0.7759 | 2515856.0 |
| 2004-10-14 08:19:00 | AAPL | Stock | 0.7768 | 0.7773 | 0.7734 | 0.7755 | 1510544.0 |
| 2004-10-14 08:20:00 | AAPL | Stock | 0.7759 | 0.7759 | 0.7732 | 0.7741 | 700560.0 |
| 2004-10-14 08:21:00 | AAPL | Stock | 0.7741 | 0.7741 | 0.7736 | 0.7741 | 274680.0 |
| 2004-10-14 08:22:00 | AAPL | Stock | 0.7736 | 0.7741 | 0.7729 | 0.7739 | 5773600.0 |
| 2004-10-14 08:23:00 | AAPL | Stock | 0.7741 | 0.7741 | 0.7723 | 0.7741 | 554400.0 |
| 2004-10-14 08:24:00 | AAPL | Stock | 0.7741 | 0.7741 | 0.7732 | 0.7732 | 3956400.0 |
| 2004-10-14 08:25:00 | AAPL | Stock | 0.7739 | 0.7741 | 0.7729 | 0.7729 | 274400.0 |
| 2004-10-14 08:26:00 | AAPL | Stock | 0.7729 | 0.7741 | 0.7723 | 0.7741 | 1013600.0 |
| 2004-10-14 08:27:00 | AAPL | Stock | 0.7732 | 0.7745 | 0.7732 | 0.7745 | 1243200.0 |
| 2004-10-14 08:28:00 | AAPL | Stock | 0.7746 | 0.7746 | 0.7741 | 0.7741 | 2889600.0 |
| 2004-10-14 08:29:00 | AAPL | Stock | 0.7746 | 0.775 | 0.7746 | 0.775 | 953400.0 |
| 2004-10-14 08:30:00 | AAPL | Stock | 0.775 | 0.775 | 0.7741 | 0.7741 | 1461600.0 |
| 2004-10-14 08:31:00 | AAPL | Stock | 0.7748 | 0.7748 | 0.7743 | 0.7743 | 50400.0 |
| 2004-10-14 08:32:00 | AAPL | Stock | 0.7741 | 0.7746 | 0.7738 | 0.7739 | 716800.0 |
| 2004-10-14 08:33:00 | AAPL | Stock | 0.7741 | 0.7743 | 0.7741 | 0.7743 | 117600.0 |
| 2004-10-14 08:34:00 | AAPL | Stock | 0.7741 | 0.7741 | 0.7679 | 0.7679 | 2458400.0 |
| 2004-10-14 08:35:00 | AAPL | Stock | 0.7743 | 0.7743 | 0.7736 | 0.7738 | 1198400.0 |
| 2004-10-14 08:36:00 | AAPL | Stock | 0.7736 | 0.7739 | 0.7723 | 0.7729 | 3758160.0 |
| 2004-10-14 08:37:00 | AAPL | Stock | 0.7729 | 0.7736 | 0.7723 | 0.7734 | 817600.0 |
| 2004-10-14 08:38:00 | AAPL | Stock | 0.7734 | 0.7734 | 0.7725 | 0.7729 | 259280.0 |
| 2004-10-14 08:39:00 | AAPL | Stock | 0.7725 | 0.7729 | 0.7721 | 0.7729 | 352800.0 |
| 2004-10-14 08:40:00 | AAPL | Stock | 0.7732 | 0.7736 | 0.7729 | 0.7732 | 173600.0 |
| 2004-10-14 08:41:00 | AAPL | Stock | 0.7736 | 0.7736 | 0.7714 | 0.7723 | 2004800.0 |
| 2004-10-14 08:42:00 | AAPL | Stock | 0.7723 | 0.7723 | 0.772 | 0.7723 | 991200.0 |
| 2004-10-14 08:43:00 | AAPL | Stock | 0.772 | 0.7725 | 0.7714 | 0.7718 | 3299520.0 |
| 2004-10-14 08:44:00 | AAPL | Stock | 0.7716 | 0.7721 | 0.7714 | 0.7721 | 313600.0 |
| 2004-10-14 08:45:00 | AAPL | Stock | 0.7718 | 0.7727 | 0.7718 | 0.7723 | 548800.0 |
| 2004-10-14 08:46:00 | AAPL | Stock | 0.7723 | 0.7729 | 0.7721 | 0.7729 | 716800.0 |
| 2004-10-14 08:47:00 | AAPL | Stock | 0.7727 | 0.7727 | 0.7723 | 0.7725 | 67200.0 |
| 2004-10-14 08:48:00 | AAPL | Stock | 0.7723 | 0.7725 | 0.7723 | 0.7723 | 193200.0 |
| 2004-10-14 08:49:00 | AAPL | Stock | 0.772 | 0.7732 | 0.772 | 0.7732 | 1243368.0 |
> showing 50 of 485,660 rows — these rows as CSV