PREVIEW / stock_1min / 2010-06-11
file: by_date/stock_1min/2010/2010-06-11.parquet size: 12.4 MB rows: 953,966 symbols: 2,807
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-06-11 05:54:00 | AAPL | Stock | 8.9911 | 8.9911 | 8.9911 | 8.9911 | 2800.0 |
| 2010-06-11 06:08:00 | AAPL | Stock | 8.9821 | 8.9821 | 8.9821 | 8.9821 | 2800.0 |
| 2010-06-11 07:00:00 | AAPL | Stock | 8.9732 | 8.9732 | 8.9732 | 8.9732 | 2800.0 |
| 2010-06-11 07:08:00 | AAPL | Stock | 8.9611 | 8.9611 | 8.9611 | 8.9611 | 5600.0 |
| 2010-06-11 07:09:00 | AAPL | Stock | 8.9732 | 8.9732 | 8.9732 | 8.9732 | 2800.0 |
| 2010-06-11 07:23:00 | AAPL | Stock | 8.9482 | 8.9482 | 8.9429 | 8.9461 | 42140.0 |
| 2010-06-11 07:26:00 | AAPL | Stock | 8.94 | 8.94 | 8.94 | 8.94 | 5096.0 |
| 2010-06-11 07:30:00 | AAPL | Stock | 8.9525 | 8.9525 | 8.9525 | 8.9525 | 8400.0 |
| 2010-06-11 07:42:00 | AAPL | Stock | 8.9396 | 8.9396 | 8.9396 | 8.9396 | 2800.0 |
| 2010-06-11 07:50:00 | AAPL | Stock | 8.9464 | 8.9464 | 8.9464 | 8.9464 | 12600.0 |
| 2010-06-11 07:59:00 | AAPL | Stock | 8.9429 | 8.9429 | 8.9429 | 8.9429 | 28000.0 |
| 2010-06-11 08:00:00 | AAPL | Stock | 8.9504 | 8.9504 | 8.9432 | 8.9496 | 37464.0 |
| 2010-06-11 08:01:00 | AAPL | Stock | 8.9518 | 8.9607 | 8.9518 | 8.9607 | 39200.0 |
| 2010-06-11 08:02:00 | AAPL | Stock | 8.9607 | 8.9618 | 8.9589 | 8.9618 | 11200.0 |
| 2010-06-11 08:03:00 | AAPL | Stock | 8.9561 | 8.9561 | 8.9561 | 8.9561 | 13160.0 |
| 2010-06-11 08:04:00 | AAPL | Stock | 8.9582 | 8.9589 | 8.9518 | 8.9589 | 30800.0 |
| 2010-06-11 08:07:00 | AAPL | Stock | 8.9521 | 8.9521 | 8.9464 | 8.9464 | 36680.0 |
| 2010-06-11 08:08:00 | AAPL | Stock | 8.9464 | 8.9464 | 8.9464 | 8.9464 | 6300.0 |
| 2010-06-11 08:09:00 | AAPL | Stock | 8.9518 | 8.9518 | 8.9518 | 8.9518 | 2800.0 |
| 2010-06-11 08:10:00 | AAPL | Stock | 8.9464 | 8.9589 | 8.9464 | 8.9589 | 25200.0 |
| 2010-06-11 08:12:00 | AAPL | Stock | 8.9579 | 8.9589 | 8.9579 | 8.9582 | 25200.0 |
| 2010-06-11 08:13:00 | AAPL | Stock | 8.9582 | 8.9589 | 8.9582 | 8.9589 | 10556.0 |
| 2010-06-11 08:14:00 | AAPL | Stock | 8.9586 | 8.9589 | 8.9586 | 8.9589 | 27076.0 |
| 2010-06-11 08:15:00 | AAPL | Stock | 8.9589 | 8.9589 | 8.9589 | 8.9589 | 6720.0 |
| 2010-06-11 08:16:00 | AAPL | Stock | 8.9604 | 8.9604 | 8.96 | 8.9604 | 16800.0 |
| 2010-06-11 08:17:00 | AAPL | Stock | 8.9593 | 8.96 | 8.955 | 8.955 | 14000.0 |
| 2010-06-11 08:18:00 | AAPL | Stock | 8.9561 | 8.9561 | 8.9554 | 8.9554 | 19600.0 |
| 2010-06-11 08:19:00 | AAPL | Stock | 8.9554 | 8.9554 | 8.9539 | 8.9539 | 8400.0 |
| 2010-06-11 08:21:00 | AAPL | Stock | 8.9554 | 8.9564 | 8.9536 | 8.9564 | 29400.0 |
| 2010-06-11 08:22:00 | AAPL | Stock | 8.9552 | 8.9554 | 8.9552 | 8.9554 | 14000.0 |
| 2010-06-11 08:25:00 | AAPL | Stock | 8.9539 | 8.9539 | 8.9539 | 8.9539 | 2800.0 |
| 2010-06-11 08:26:00 | AAPL | Stock | 8.9525 | 8.9525 | 8.9525 | 8.9525 | 2800.0 |
| 2010-06-11 08:27:00 | AAPL | Stock | 8.9504 | 8.9504 | 8.9482 | 8.9482 | 16800.0 |
| 2010-06-11 08:28:00 | AAPL | Stock | 8.9521 | 8.9546 | 8.9521 | 8.9546 | 16800.0 |
| 2010-06-11 08:30:00 | AAPL | Stock | 8.9482 | 8.9482 | 8.8986 | 8.8986 | 811916.0 |
| 2010-06-11 08:31:00 | AAPL | Stock | 8.8975 | 8.8996 | 8.875 | 8.8929 | 327852.0 |
| 2010-06-11 08:32:00 | AAPL | Stock | 8.895 | 8.9043 | 8.8946 | 8.9043 | 98056.0 |
| 2010-06-11 08:33:00 | AAPL | Stock | 8.9018 | 8.9064 | 8.885 | 8.885 | 212800.0 |
| 2010-06-11 08:34:00 | AAPL | Stock | 8.8857 | 8.8891 | 8.87 | 8.8754 | 289128.0 |
| 2010-06-11 08:35:00 | AAPL | Stock | 8.8759 | 8.8911 | 8.8759 | 8.8857 | 78400.0 |
| 2010-06-11 08:36:00 | AAPL | Stock | 8.8825 | 8.8857 | 8.8786 | 8.8839 | 75600.0 |
| 2010-06-11 08:37:00 | AAPL | Stock | 8.8846 | 8.8846 | 8.8754 | 8.883 | 106400.0 |
| 2010-06-11 08:38:00 | AAPL | Stock | 8.8771 | 8.8771 | 8.8768 | 8.8771 | 59640.0 |
| 2010-06-11 08:39:00 | AAPL | Stock | 8.8821 | 8.8839 | 8.8791 | 8.8793 | 25200.0 |
| 2010-06-11 08:40:00 | AAPL | Stock | 8.8793 | 8.8846 | 8.8782 | 8.8821 | 132104.0 |
| 2010-06-11 08:41:00 | AAPL | Stock | 8.8832 | 8.8839 | 8.875 | 8.875 | 157640.0 |
| 2010-06-11 08:42:00 | AAPL | Stock | 8.8736 | 8.8846 | 8.8736 | 8.8786 | 197708.0 |
| 2010-06-11 08:43:00 | AAPL | Stock | 8.8768 | 8.8854 | 8.8757 | 8.8854 | 95900.0 |
| 2010-06-11 08:44:00 | AAPL | Stock | 8.8879 | 8.8943 | 8.8857 | 8.8929 | 122332.0 |
| 2010-06-11 08:45:00 | AAPL | Stock | 8.8918 | 8.8921 | 8.8818 | 8.8818 | 135100.0 |
> showing 50 of 953,966 rows — these rows as CSV