PREVIEW / stock_1min / 2009-05-11
file: by_date/stock_1min/2009/2009-05-11.parquet size: 12.9 MB rows: 993,352 symbols: 2,720
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-05-11 04:19:00 | AAPL | Stock | 4.67 | 4.67 | 4.67 | 4.67 | 2800.0 |
| 2009-05-11 07:32:00 | AAPL | Stock | 4.5714 | 4.5714 | 4.5714 | 4.5714 | 4200.0 |
| 2009-05-11 07:33:00 | AAPL | Stock | 4.5714 | 4.5714 | 4.5714 | 4.5714 | 14000.0 |
| 2009-05-11 07:37:00 | AAPL | Stock | 4.5714 | 4.5714 | 4.5714 | 4.5714 | 5600.0 |
| 2009-05-11 07:53:00 | AAPL | Stock | 4.5714 | 4.5714 | 4.5714 | 4.5714 | 2800.0 |
| 2009-05-11 07:54:00 | AAPL | Stock | 4.5554 | 4.5554 | 4.5554 | 4.5554 | 5516.0 |
| 2009-05-11 08:00:00 | AAPL | Stock | 4.5804 | 4.5804 | 4.5804 | 4.5804 | 16016.0 |
| 2009-05-11 08:03:00 | AAPL | Stock | 4.5796 | 4.5796 | 4.5796 | 4.5796 | 7000.0 |
| 2009-05-11 08:08:00 | AAPL | Stock | 4.5714 | 4.5732 | 4.5714 | 4.5714 | 50400.0 |
| 2009-05-11 08:09:00 | AAPL | Stock | 4.5629 | 4.5629 | 4.5571 | 4.5571 | 40320.0 |
| 2009-05-11 08:12:00 | AAPL | Stock | 4.5696 | 4.5714 | 4.5696 | 4.5714 | 8400.0 |
| 2009-05-11 08:13:00 | AAPL | Stock | 4.5625 | 4.5625 | 4.5625 | 4.5625 | 4760.0 |
| 2009-05-11 08:17:00 | AAPL | Stock | 4.5625 | 4.5625 | 4.5625 | 4.5625 | 2800.0 |
| 2009-05-11 08:18:00 | AAPL | Stock | 4.5625 | 4.5636 | 4.5625 | 4.5636 | 6440.0 |
| 2009-05-11 08:19:00 | AAPL | Stock | 4.5625 | 4.5625 | 4.5589 | 4.5589 | 21168.0 |
| 2009-05-11 08:20:00 | AAPL | Stock | 4.5579 | 4.5589 | 4.5579 | 4.5579 | 15400.0 |
| 2009-05-11 08:22:00 | AAPL | Stock | 4.5582 | 4.5589 | 4.5582 | 4.5589 | 12432.0 |
| 2009-05-11 08:27:00 | AAPL | Stock | 4.5643 | 4.5643 | 4.5643 | 4.5643 | 11200.0 |
| 2009-05-11 08:35:00 | AAPL | Stock | 4.5607 | 4.5607 | 4.5607 | 4.5607 | 16940.0 |
| 2009-05-11 08:36:00 | AAPL | Stock | 4.5639 | 4.5639 | 4.5639 | 4.5639 | 2800.0 |
| 2009-05-11 08:37:00 | AAPL | Stock | 4.5632 | 4.5632 | 4.5632 | 4.5632 | 11200.0 |
| 2009-05-11 08:39:00 | AAPL | Stock | 4.5696 | 4.57 | 4.5696 | 4.57 | 11200.0 |
| 2009-05-11 08:40:00 | AAPL | Stock | 4.5714 | 4.5714 | 4.57 | 4.57 | 61600.0 |
| 2009-05-11 08:41:00 | AAPL | Stock | 4.5711 | 4.5711 | 4.5711 | 4.5711 | 8400.0 |
| 2009-05-11 08:42:00 | AAPL | Stock | 4.5707 | 4.5711 | 4.5707 | 4.5711 | 5600.0 |
| 2009-05-11 08:44:00 | AAPL | Stock | 4.5711 | 4.5714 | 4.5711 | 4.5714 | 76664.0 |
| 2009-05-11 08:45:00 | AAPL | Stock | 4.5721 | 4.5721 | 4.5721 | 4.5721 | 5600.0 |
| 2009-05-11 08:47:00 | AAPL | Stock | 4.575 | 4.575 | 4.575 | 4.575 | 5600.0 |
| 2009-05-11 08:49:00 | AAPL | Stock | 4.5786 | 4.5786 | 4.5704 | 4.5704 | 72800.0 |
| 2009-05-11 08:50:00 | AAPL | Stock | 4.5696 | 4.5696 | 4.5696 | 4.5696 | 5600.0 |
| 2009-05-11 08:51:00 | AAPL | Stock | 4.5679 | 4.5714 | 4.5679 | 4.5714 | 22400.0 |
| 2009-05-11 08:55:00 | AAPL | Stock | 4.5693 | 4.5696 | 4.5693 | 4.5696 | 5600.0 |
| 2009-05-11 08:56:00 | AAPL | Stock | 4.5671 | 4.5679 | 4.5643 | 4.5643 | 11200.0 |
| 2009-05-11 08:58:00 | AAPL | Stock | 4.5696 | 4.5696 | 4.5696 | 4.5696 | 2800.0 |
| 2009-05-11 08:59:00 | AAPL | Stock | 4.5714 | 4.5714 | 4.5696 | 4.5696 | 11200.0 |
| 2009-05-11 09:00:00 | AAPL | Stock | 4.5679 | 4.5679 | 4.5679 | 4.5679 | 16800.0 |
| 2009-05-11 09:01:00 | AAPL | Stock | 4.5679 | 4.5679 | 4.5679 | 4.5679 | 2800.0 |
| 2009-05-11 09:02:00 | AAPL | Stock | 4.5679 | 4.5679 | 4.5679 | 4.5679 | 2800.0 |
| 2009-05-11 09:03:00 | AAPL | Stock | 4.5679 | 4.5679 | 4.5679 | 4.5679 | 19600.0 |
| 2009-05-11 09:05:00 | AAPL | Stock | 4.5643 | 4.5643 | 4.5643 | 4.5643 | 14000.0 |
| 2009-05-11 09:06:00 | AAPL | Stock | 4.5643 | 4.5714 | 4.5643 | 4.5671 | 49504.0 |
| 2009-05-11 09:11:00 | AAPL | Stock | 4.5643 | 4.5643 | 4.5643 | 4.5643 | 23296.0 |
| 2009-05-11 09:15:00 | AAPL | Stock | 4.5643 | 4.5643 | 4.5636 | 4.5636 | 5600.0 |
| 2009-05-11 09:16:00 | AAPL | Stock | 4.5643 | 4.5643 | 4.5621 | 4.5621 | 25480.0 |
| 2009-05-11 09:18:00 | AAPL | Stock | 4.5621 | 4.5621 | 4.5621 | 4.5621 | 2800.0 |
| 2009-05-11 09:19:00 | AAPL | Stock | 4.5643 | 4.5643 | 4.5643 | 4.5643 | 4620.0 |
| 2009-05-11 09:20:00 | AAPL | Stock | 4.5661 | 4.5661 | 4.5661 | 4.5661 | 7000.0 |
| 2009-05-11 09:21:00 | AAPL | Stock | 4.5671 | 4.5671 | 4.5671 | 4.5671 | 2800.0 |
| 2009-05-11 09:22:00 | AAPL | Stock | 4.5671 | 4.5671 | 4.5643 | 4.5643 | 17080.0 |
| 2009-05-11 09:23:00 | AAPL | Stock | 4.5621 | 4.5621 | 4.5621 | 4.5621 | 2800.0 |
> showing 50 of 993,352 rows — these rows as CSV