PREVIEW / stock_1min / 2009-05-28
file: by_date/stock_1min/2009/2009-05-28.parquet size: 13.1 MB rows: 1,004,567 symbols: 2,731
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-28 04:29:00 | AAPL | Stock | 4.7157 | 4.7157 | 4.7157 | 4.7157 | 2800.0 |
| 2009-05-28 05:50:00 | AAPL | Stock | 4.7218 | 4.7218 | 4.7218 | 4.7218 | 2800.0 |
| 2009-05-28 05:52:00 | AAPL | Stock | 4.7321 | 4.7321 | 4.7321 | 4.7321 | 2800.0 |
| 2009-05-28 07:14:00 | AAPL | Stock | 4.7589 | 4.7589 | 4.7589 | 4.7589 | 2800.0 |
| 2009-05-28 07:20:00 | AAPL | Stock | 4.7671 | 4.7671 | 4.7671 | 4.7671 | 8400.0 |
| 2009-05-28 07:52:00 | AAPL | Stock | 4.7582 | 4.7582 | 4.7582 | 4.7582 | 2800.0 |
| 2009-05-28 07:55:00 | AAPL | Stock | 4.7532 | 4.7532 | 4.75 | 4.75 | 22400.0 |
| 2009-05-28 07:58:00 | AAPL | Stock | 4.7304 | 4.7304 | 4.7304 | 4.7304 | 5880.0 |
| 2009-05-28 08:00:00 | AAPL | Stock | 4.7464 | 4.7582 | 4.7464 | 4.75 | 73948.0 |
| 2009-05-28 08:02:00 | AAPL | Stock | 4.75 | 4.75 | 4.75 | 4.75 | 2800.0 |
| 2009-05-28 08:03:00 | AAPL | Stock | 4.7496 | 4.7496 | 4.7496 | 4.7496 | 2800.0 |
| 2009-05-28 08:09:00 | AAPL | Stock | 4.7446 | 4.7446 | 4.7446 | 4.7446 | 19600.0 |
| 2009-05-28 08:10:00 | AAPL | Stock | 4.7446 | 4.7446 | 4.7446 | 4.7446 | 23800.0 |
| 2009-05-28 08:15:00 | AAPL | Stock | 4.7446 | 4.7446 | 4.7446 | 4.7446 | 19600.0 |
| 2009-05-28 08:16:00 | AAPL | Stock | 4.7446 | 4.7493 | 4.7446 | 4.7493 | 26320.0 |
| 2009-05-28 08:18:00 | AAPL | Stock | 4.7464 | 4.7464 | 4.7464 | 4.7464 | 20188.0 |
| 2009-05-28 08:19:00 | AAPL | Stock | 4.7493 | 4.7493 | 4.7493 | 4.7493 | 15484.0 |
| 2009-05-28 08:20:00 | AAPL | Stock | 4.7493 | 4.7493 | 4.7493 | 4.7493 | 2800.0 |
| 2009-05-28 08:22:00 | AAPL | Stock | 4.7564 | 4.7564 | 4.7536 | 4.7536 | 5600.0 |
| 2009-05-28 08:23:00 | AAPL | Stock | 4.7536 | 4.7571 | 4.7536 | 4.7571 | 68600.0 |
| 2009-05-28 08:24:00 | AAPL | Stock | 4.7536 | 4.7536 | 4.7536 | 4.7536 | 5572.0 |
| 2009-05-28 08:25:00 | AAPL | Stock | 4.7539 | 4.7539 | 4.7521 | 4.7521 | 14000.0 |
| 2009-05-28 08:27:00 | AAPL | Stock | 4.7536 | 4.7536 | 4.7536 | 4.7536 | 6076.0 |
| 2009-05-28 08:30:00 | AAPL | Stock | 4.7582 | 4.7582 | 4.7582 | 4.7582 | 25424.0 |
| 2009-05-28 08:31:00 | AAPL | Stock | 4.7571 | 4.7679 | 4.7571 | 4.7611 | 96600.0 |
| 2009-05-28 08:32:00 | AAPL | Stock | 4.7664 | 4.7668 | 4.7664 | 4.7668 | 11200.0 |
| 2009-05-28 08:33:00 | AAPL | Stock | 4.7668 | 4.7675 | 4.7643 | 4.7664 | 67200.0 |
| 2009-05-28 08:34:00 | AAPL | Stock | 4.7661 | 4.7671 | 4.7625 | 4.7664 | 129640.0 |
| 2009-05-28 08:35:00 | AAPL | Stock | 4.7625 | 4.7646 | 4.7607 | 4.7646 | 32200.0 |
| 2009-05-28 08:36:00 | AAPL | Stock | 4.7668 | 4.7668 | 4.7668 | 4.7668 | 28000.0 |
| 2009-05-28 08:37:00 | AAPL | Stock | 4.7668 | 4.7668 | 4.7661 | 4.7661 | 28532.0 |
| 2009-05-28 08:38:00 | AAPL | Stock | 4.7664 | 4.7696 | 4.7664 | 4.7696 | 91700.0 |
| 2009-05-28 08:39:00 | AAPL | Stock | 4.7704 | 4.7704 | 4.7704 | 4.7704 | 60228.0 |
| 2009-05-28 08:40:00 | AAPL | Stock | 4.775 | 4.7754 | 4.775 | 4.7754 | 30800.0 |
| 2009-05-28 08:41:00 | AAPL | Stock | 4.7743 | 4.775 | 4.7732 | 4.775 | 25200.0 |
| 2009-05-28 08:42:00 | AAPL | Stock | 4.775 | 4.775 | 4.7732 | 4.7732 | 5600.0 |
| 2009-05-28 08:43:00 | AAPL | Stock | 4.775 | 4.775 | 4.775 | 4.775 | 16800.0 |
| 2009-05-28 08:44:00 | AAPL | Stock | 4.775 | 4.7768 | 4.7736 | 4.7768 | 21840.0 |
| 2009-05-28 08:45:00 | AAPL | Stock | 4.7768 | 4.7771 | 4.7768 | 4.7768 | 18760.0 |
| 2009-05-28 08:46:00 | AAPL | Stock | 4.775 | 4.775 | 4.775 | 4.775 | 8400.0 |
| 2009-05-28 08:47:00 | AAPL | Stock | 4.7771 | 4.7779 | 4.7757 | 4.7757 | 33880.0 |
| 2009-05-28 08:48:00 | AAPL | Stock | 4.7768 | 4.7814 | 4.7768 | 4.7814 | 15400.0 |
| 2009-05-28 08:49:00 | AAPL | Stock | 4.7786 | 4.7821 | 4.7782 | 4.7782 | 84700.0 |
| 2009-05-28 08:50:00 | AAPL | Stock | 4.7782 | 4.7786 | 4.7782 | 4.7786 | 28000.0 |
| 2009-05-28 08:51:00 | AAPL | Stock | 4.7804 | 4.7811 | 4.7804 | 4.7804 | 33600.0 |
| 2009-05-28 08:52:00 | AAPL | Stock | 4.78 | 4.78 | 4.78 | 4.78 | 2800.0 |
| 2009-05-28 08:53:00 | AAPL | Stock | 4.7786 | 4.7825 | 4.7786 | 4.7825 | 232260.0 |
| 2009-05-28 08:54:00 | AAPL | Stock | 4.7821 | 4.7857 | 4.7818 | 4.7818 | 105000.0 |
| 2009-05-28 08:55:00 | AAPL | Stock | 4.7839 | 4.7839 | 4.7793 | 4.7793 | 99540.0 |
| 2009-05-28 08:56:00 | AAPL | Stock | 4.7786 | 4.7804 | 4.7786 | 4.7804 | 20300.0 |
> showing 50 of 1,004,567 rows — these rows as CSV