PREVIEW / stock_1min / 2010-05-10
file: by_date/stock_1min/2010/2010-05-10.parquet size: 14.7 MB rows: 1,099,329 symbols: 2,851
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 |
|---|---|---|---|---|---|---|---|
| 2010-05-10 04:13:00 | AAPL | Stock | 9.1071 | 9.1071 | 9.1071 | 9.1071 | 2800.0 |
| 2010-05-10 04:15:00 | AAPL | Stock | 9.0 | 9.0 | 8.9696 | 8.9696 | 75460.0 |
| 2010-05-10 04:16:00 | AAPL | Stock | 9.0643 | 9.0643 | 9.0643 | 9.0643 | 2800.0 |
| 2010-05-10 04:18:00 | AAPL | Stock | 9.0832 | 9.0832 | 9.0832 | 9.0832 | 2800.0 |
| 2010-05-10 04:19:00 | AAPL | Stock | 9.1071 | 9.1071 | 9.1071 | 9.1071 | 11788.0 |
| 2010-05-10 04:20:00 | AAPL | Stock | 9.1071 | 9.1075 | 9.1071 | 9.1071 | 38500.0 |
| 2010-05-10 04:22:00 | AAPL | Stock | 9.1071 | 9.1071 | 9.1071 | 9.1071 | 18256.0 |
| 2010-05-10 04:23:00 | AAPL | Stock | 9.1429 | 9.1429 | 9.1429 | 9.1429 | 8008.0 |
| 2010-05-10 04:26:00 | AAPL | Stock | 9.0961 | 9.0961 | 9.0961 | 9.0961 | 2800.0 |
| 2010-05-10 04:27:00 | AAPL | Stock | 9.0889 | 9.0889 | 9.0889 | 9.0889 | 2800.0 |
| 2010-05-10 04:33:00 | AAPL | Stock | 9.125 | 9.125 | 9.125 | 9.125 | 2800.0 |
| 2010-05-10 04:38:00 | AAPL | Stock | 9.0786 | 9.0786 | 9.0586 | 9.0586 | 22736.0 |
| 2010-05-10 04:39:00 | AAPL | Stock | 9.0571 | 9.0571 | 9.0375 | 9.0375 | 5600.0 |
| 2010-05-10 04:40:00 | AAPL | Stock | 9.0571 | 9.0571 | 9.0357 | 9.0357 | 50400.0 |
| 2010-05-10 04:41:00 | AAPL | Stock | 9.0357 | 9.0357 | 9.0357 | 9.0357 | 2800.0 |
| 2010-05-10 04:42:00 | AAPL | Stock | 9.0536 | 9.0536 | 9.0357 | 9.0357 | 16800.0 |
| 2010-05-10 04:43:00 | AAPL | Stock | 9.0525 | 9.0525 | 9.0525 | 9.0525 | 5600.0 |
| 2010-05-10 04:44:00 | AAPL | Stock | 9.0036 | 9.0429 | 9.0036 | 9.0429 | 28000.0 |
| 2010-05-10 04:45:00 | AAPL | Stock | 9.0286 | 9.0286 | 9.0071 | 9.0071 | 8400.0 |
| 2010-05-10 04:47:00 | AAPL | Stock | 9.0286 | 9.0286 | 9.0286 | 9.0286 | 11200.0 |
| 2010-05-10 04:48:00 | AAPL | Stock | 9.05 | 9.0521 | 9.05 | 9.0521 | 12656.0 |
| 2010-05-10 04:49:00 | AAPL | Stock | 9.0521 | 9.0521 | 9.0521 | 9.0521 | 5600.0 |
| 2010-05-10 05:04:00 | AAPL | Stock | 9.0521 | 9.0521 | 9.0521 | 9.0521 | 8400.0 |
| 2010-05-10 05:05:00 | AAPL | Stock | 9.0196 | 9.0357 | 9.0196 | 9.0357 | 17500.0 |
| 2010-05-10 05:12:00 | AAPL | Stock | 9.0029 | 9.0029 | 9.0029 | 9.0029 | 93800.0 |
| 2010-05-10 05:13:00 | AAPL | Stock | 9.0 | 9.0 | 8.9893 | 8.9893 | 42000.0 |
| 2010-05-10 05:31:00 | AAPL | Stock | 9.0204 | 9.0268 | 9.0204 | 9.0268 | 8400.0 |
| 2010-05-10 05:37:00 | AAPL | Stock | 9.0279 | 9.0279 | 8.995 | 8.995 | 43652.0 |
| 2010-05-10 05:38:00 | AAPL | Stock | 9.0307 | 9.0307 | 9.0307 | 9.0307 | 8568.0 |
| 2010-05-10 05:43:00 | AAPL | Stock | 8.9954 | 8.9954 | 8.9857 | 8.9857 | 28000.0 |
| 2010-05-10 05:44:00 | AAPL | Stock | 8.9693 | 9.0 | 8.9643 | 8.9643 | 80276.0 |
| 2010-05-10 05:48:00 | AAPL | Stock | 8.9771 | 8.9771 | 8.9771 | 8.9771 | 12600.0 |
| 2010-05-10 05:52:00 | AAPL | Stock | 8.9475 | 8.9475 | 8.9475 | 8.9475 | 13300.0 |
| 2010-05-10 05:56:00 | AAPL | Stock | 8.9707 | 8.9707 | 8.9707 | 8.9707 | 4480.0 |
| 2010-05-10 05:57:00 | AAPL | Stock | 8.9643 | 8.9643 | 8.9643 | 8.9643 | 10640.0 |
| 2010-05-10 05:58:00 | AAPL | Stock | 9.0 | 9.0 | 9.0 | 9.0 | 14000.0 |
| 2010-05-10 06:00:00 | AAPL | Stock | 9.0 | 9.0 | 9.0 | 9.0 | 5796.0 |
| 2010-05-10 06:01:00 | AAPL | Stock | 8.9646 | 8.9646 | 8.9643 | 8.9643 | 6720.0 |
| 2010-05-10 06:04:00 | AAPL | Stock | 8.9929 | 8.9929 | 8.9929 | 8.9929 | 5600.0 |
| 2010-05-10 06:09:00 | AAPL | Stock | 8.9893 | 8.9893 | 8.9689 | 8.9689 | 26880.0 |
| 2010-05-10 06:10:00 | AAPL | Stock | 8.9686 | 9.0 | 8.9686 | 9.0 | 39200.0 |
| 2010-05-10 06:13:00 | AAPL | Stock | 9.0 | 9.0 | 8.9918 | 8.9918 | 17948.0 |
| 2010-05-10 06:19:00 | AAPL | Stock | 8.9957 | 8.9996 | 8.9957 | 8.9982 | 40768.0 |
| 2010-05-10 06:20:00 | AAPL | Stock | 8.9975 | 8.9979 | 8.9975 | 8.9979 | 16800.0 |
| 2010-05-10 06:24:00 | AAPL | Stock | 8.9789 | 8.9789 | 8.9789 | 8.9789 | 2800.0 |
| 2010-05-10 06:25:00 | AAPL | Stock | 8.9821 | 8.9821 | 8.9821 | 8.9821 | 6160.0 |
| 2010-05-10 06:28:00 | AAPL | Stock | 8.995 | 9.0029 | 8.995 | 9.0 | 21364.0 |
| 2010-05-10 06:29:00 | AAPL | Stock | 8.9911 | 8.9911 | 8.9911 | 8.9911 | 2800.0 |
| 2010-05-10 06:32:00 | AAPL | Stock | 8.9911 | 8.9911 | 8.9911 | 8.9911 | 9576.0 |
| 2010-05-10 06:34:00 | AAPL | Stock | 8.9911 | 8.9911 | 8.9911 | 8.9911 | 2800.0 |
> showing 50 of 1,099,329 rows — these rows as CSV