PREVIEW / stock_1min / 2011-05-23
file: by_date/stock_1min/2011/2011-05-23.parquet size: 13.3 MB rows: 1,006,971 symbols: 2,855
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 |
|---|---|---|---|---|---|---|---|
| 2011-05-23 04:07:00 | AAPL | Stock | 11.8736 | 11.875 | 11.8736 | 11.875 | 5600.0 |
| 2011-05-23 04:23:00 | AAPL | Stock | 11.8571 | 11.8571 | 11.8571 | 11.8571 | 2940.0 |
| 2011-05-23 04:37:00 | AAPL | Stock | 11.8575 | 11.8589 | 11.8575 | 11.8589 | 5600.0 |
| 2011-05-23 04:39:00 | AAPL | Stock | 11.85 | 11.85 | 11.85 | 11.85 | 2800.0 |
| 2011-05-23 04:43:00 | AAPL | Stock | 11.85 | 11.85 | 11.85 | 11.85 | 8400.0 |
| 2011-05-23 04:50:00 | AAPL | Stock | 11.85 | 11.85 | 11.85 | 11.85 | 2800.0 |
| 2011-05-23 05:02:00 | AAPL | Stock | 11.85 | 11.85 | 11.85 | 11.85 | 5600.0 |
| 2011-05-23 05:07:00 | AAPL | Stock | 11.85 | 11.85 | 11.85 | 11.85 | 2800.0 |
| 2011-05-23 05:11:00 | AAPL | Stock | 11.8536 | 11.8536 | 11.8536 | 11.8536 | 2800.0 |
| 2011-05-23 05:12:00 | AAPL | Stock | 11.85 | 11.85 | 11.85 | 11.85 | 2800.0 |
| 2011-05-23 05:15:00 | AAPL | Stock | 11.8393 | 11.8393 | 11.8393 | 11.8393 | 8400.0 |
| 2011-05-23 05:16:00 | AAPL | Stock | 11.8393 | 11.8393 | 11.8393 | 11.8393 | 5600.0 |
| 2011-05-23 05:17:00 | AAPL | Stock | 11.8393 | 11.8429 | 11.8393 | 11.8429 | 7000.0 |
| 2011-05-23 05:19:00 | AAPL | Stock | 11.8429 | 11.8429 | 11.8429 | 11.8429 | 5600.0 |
| 2011-05-23 05:25:00 | AAPL | Stock | 11.8429 | 11.8429 | 11.8429 | 11.8429 | 2800.0 |
| 2011-05-23 05:43:00 | AAPL | Stock | 11.85 | 11.85 | 11.85 | 11.85 | 11200.0 |
| 2011-05-23 05:45:00 | AAPL | Stock | 11.8536 | 11.8536 | 11.8536 | 11.8536 | 3360.0 |
| 2011-05-23 06:11:00 | AAPL | Stock | 11.8539 | 11.8539 | 11.8539 | 11.8539 | 4760.0 |
| 2011-05-23 06:47:00 | AAPL | Stock | 11.8679 | 11.8679 | 11.8679 | 11.8679 | 5600.0 |
| 2011-05-23 06:48:00 | AAPL | Stock | 11.8643 | 11.8643 | 11.8643 | 11.8643 | 14000.0 |
| 2011-05-23 06:52:00 | AAPL | Stock | 11.8607 | 11.8607 | 11.8607 | 11.8607 | 14000.0 |
| 2011-05-23 07:01:00 | AAPL | Stock | 11.8679 | 11.8679 | 11.8679 | 11.8679 | 5600.0 |
| 2011-05-23 07:02:00 | AAPL | Stock | 11.8682 | 11.8682 | 11.8682 | 11.8682 | 2800.0 |
| 2011-05-23 07:03:00 | AAPL | Stock | 11.8686 | 11.8686 | 11.8679 | 11.8679 | 30800.0 |
| 2011-05-23 07:05:00 | AAPL | Stock | 11.8621 | 11.8621 | 11.8589 | 11.8589 | 9800.0 |
| 2011-05-23 07:06:00 | AAPL | Stock | 11.8589 | 11.8743 | 11.8571 | 11.8743 | 23800.0 |
| 2011-05-23 07:07:00 | AAPL | Stock | 11.8571 | 11.8571 | 11.8571 | 11.8571 | 4900.0 |
| 2011-05-23 07:08:00 | AAPL | Stock | 11.875 | 11.875 | 11.8732 | 11.8732 | 5600.0 |
| 2011-05-23 07:10:00 | AAPL | Stock | 11.8661 | 11.8661 | 11.8661 | 11.8661 | 5600.0 |
| 2011-05-23 07:11:00 | AAPL | Stock | 11.865 | 11.865 | 11.865 | 11.865 | 2800.0 |
| 2011-05-23 07:12:00 | AAPL | Stock | 11.8571 | 11.8571 | 11.8571 | 11.8571 | 2800.0 |
| 2011-05-23 07:14:00 | AAPL | Stock | 11.8714 | 11.875 | 11.8714 | 11.875 | 14112.0 |
| 2011-05-23 07:19:00 | AAPL | Stock | 11.875 | 11.875 | 11.875 | 11.875 | 2800.0 |
| 2011-05-23 07:20:00 | AAPL | Stock | 11.875 | 11.875 | 11.875 | 11.875 | 2800.0 |
| 2011-05-23 07:22:00 | AAPL | Stock | 11.8661 | 11.8661 | 11.8661 | 11.8661 | 2800.0 |
| 2011-05-23 07:25:00 | AAPL | Stock | 11.8793 | 11.8793 | 11.8793 | 11.8793 | 2800.0 |
| 2011-05-23 07:31:00 | AAPL | Stock | 11.8643 | 11.8643 | 11.8643 | 11.8643 | 2800.0 |
| 2011-05-23 07:33:00 | AAPL | Stock | 11.8743 | 11.8743 | 11.8743 | 11.8743 | 5600.0 |
| 2011-05-23 07:38:00 | AAPL | Stock | 11.8679 | 11.8679 | 11.8571 | 11.8571 | 22400.0 |
| 2011-05-23 07:39:00 | AAPL | Stock | 11.8571 | 11.8575 | 11.8539 | 11.8539 | 19880.0 |
| 2011-05-23 07:43:00 | AAPL | Stock | 11.8582 | 11.8582 | 11.8539 | 11.8571 | 44800.0 |
| 2011-05-23 07:45:00 | AAPL | Stock | 11.8554 | 11.8554 | 11.8554 | 11.8554 | 5600.0 |
| 2011-05-23 07:46:00 | AAPL | Stock | 11.865 | 11.865 | 11.865 | 11.865 | 2800.0 |
| 2011-05-23 07:48:00 | AAPL | Stock | 11.8639 | 11.8643 | 11.8639 | 11.8643 | 5600.0 |
| 2011-05-23 07:49:00 | AAPL | Stock | 11.8661 | 11.8661 | 11.8607 | 11.8607 | 5600.0 |
| 2011-05-23 07:50:00 | AAPL | Stock | 11.8711 | 11.8714 | 11.8711 | 11.8711 | 16800.0 |
| 2011-05-23 07:51:00 | AAPL | Stock | 11.865 | 11.865 | 11.8643 | 11.8643 | 8400.0 |
| 2011-05-23 07:53:00 | AAPL | Stock | 11.8614 | 11.8614 | 11.8607 | 11.8607 | 26460.0 |
| 2011-05-23 07:54:00 | AAPL | Stock | 11.8571 | 11.8571 | 11.8539 | 11.8539 | 67200.0 |
| 2011-05-23 07:56:00 | AAPL | Stock | 11.865 | 11.865 | 11.865 | 11.865 | 5600.0 |
> showing 50 of 1,006,971 rows — these rows as CSV