PREVIEW / stock_1min / 2013-08-13
file: by_date/stock_1min/2013/2013-08-13.parquet size: 13.5 MB rows: 982,239 symbols: 2,844
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 |
|---|---|---|---|---|---|---|---|
| 2013-08-13 04:46:00 | AAPL | Stock | 16.76 | 16.76 | 16.76 | 16.76 | 5600.0 |
| 2013-08-13 04:49:00 | AAPL | Stock | 16.7579 | 16.7579 | 16.7579 | 16.7579 | 2800.0 |
| 2013-08-13 05:00:00 | AAPL | Stock | 16.7571 | 16.7571 | 16.7571 | 16.7571 | 5600.0 |
| 2013-08-13 05:12:00 | AAPL | Stock | 16.75 | 16.75 | 16.75 | 16.75 | 2800.0 |
| 2013-08-13 05:15:00 | AAPL | Stock | 16.7661 | 16.7661 | 16.7661 | 16.7661 | 2800.0 |
| 2013-08-13 05:18:00 | AAPL | Stock | 16.7643 | 16.7857 | 16.7643 | 16.7857 | 58800.0 |
| 2013-08-13 05:33:00 | AAPL | Stock | 16.7664 | 16.7664 | 16.7643 | 16.7643 | 14000.0 |
| 2013-08-13 05:46:00 | AAPL | Stock | 16.7679 | 16.7679 | 16.7679 | 16.7679 | 3668.0 |
| 2013-08-13 05:47:00 | AAPL | Stock | 16.7679 | 16.7679 | 16.7679 | 16.7679 | 2800.0 |
| 2013-08-13 05:48:00 | AAPL | Stock | 16.7679 | 16.7679 | 16.7679 | 16.7679 | 3892.0 |
| 2013-08-13 05:58:00 | AAPL | Stock | 16.7571 | 16.7571 | 16.7571 | 16.7571 | 7644.0 |
| 2013-08-13 05:59:00 | AAPL | Stock | 16.7571 | 16.7571 | 16.7571 | 16.7571 | 6356.0 |
| 2013-08-13 06:14:00 | AAPL | Stock | 16.7571 | 16.7571 | 16.7571 | 16.7571 | 11200.0 |
| 2013-08-13 06:15:00 | AAPL | Stock | 16.7571 | 16.7571 | 16.7571 | 16.7571 | 2800.0 |
| 2013-08-13 06:18:00 | AAPL | Stock | 16.7536 | 16.7536 | 16.7536 | 16.7536 | 2800.0 |
| 2013-08-13 06:20:00 | AAPL | Stock | 16.7536 | 16.7536 | 16.7536 | 16.7536 | 2800.0 |
| 2013-08-13 06:27:00 | AAPL | Stock | 16.7571 | 16.7571 | 16.7571 | 16.7571 | 5600.0 |
| 2013-08-13 06:41:00 | AAPL | Stock | 16.7661 | 16.7661 | 16.7661 | 16.7661 | 2800.0 |
| 2013-08-13 06:47:00 | AAPL | Stock | 16.7654 | 16.7654 | 16.7654 | 16.7654 | 2800.0 |
| 2013-08-13 06:51:00 | AAPL | Stock | 16.7661 | 16.7679 | 16.7661 | 16.7679 | 8624.0 |
| 2013-08-13 06:52:00 | AAPL | Stock | 16.7575 | 16.7575 | 16.7575 | 16.7575 | 2800.0 |
| 2013-08-13 06:53:00 | AAPL | Stock | 16.7575 | 16.7575 | 16.7575 | 16.7575 | 9520.0 |
| 2013-08-13 06:55:00 | AAPL | Stock | 16.7557 | 16.7557 | 16.7557 | 16.7557 | 2800.0 |
| 2013-08-13 07:00:00 | AAPL | Stock | 16.7643 | 16.7643 | 16.7643 | 16.7643 | 2800.0 |
| 2013-08-13 07:01:00 | AAPL | Stock | 16.7661 | 16.7768 | 16.7661 | 16.7768 | 12236.0 |
| 2013-08-13 07:02:00 | AAPL | Stock | 16.7643 | 16.7643 | 16.7643 | 16.7643 | 11200.0 |
| 2013-08-13 07:03:00 | AAPL | Stock | 16.7639 | 16.7639 | 16.7639 | 16.7639 | 2800.0 |
| 2013-08-13 07:04:00 | AAPL | Stock | 16.7643 | 16.7643 | 16.7643 | 16.7643 | 2800.0 |
| 2013-08-13 07:05:00 | AAPL | Stock | 16.7679 | 16.7686 | 16.7661 | 16.7661 | 16800.0 |
| 2013-08-13 07:06:00 | AAPL | Stock | 16.7643 | 16.7643 | 16.7643 | 16.7643 | 2800.0 |
| 2013-08-13 07:07:00 | AAPL | Stock | 16.7643 | 16.7643 | 16.7643 | 16.7643 | 2800.0 |
| 2013-08-13 07:08:00 | AAPL | Stock | 16.7625 | 16.7625 | 16.7589 | 16.7589 | 36176.0 |
| 2013-08-13 07:09:00 | AAPL | Stock | 16.7589 | 16.7589 | 16.7589 | 16.7589 | 2800.0 |
| 2013-08-13 07:10:00 | AAPL | Stock | 16.7679 | 16.7804 | 16.7679 | 16.7804 | 49840.0 |
| 2013-08-13 07:11:00 | AAPL | Stock | 16.7768 | 16.7825 | 16.7768 | 16.7825 | 5600.0 |
| 2013-08-13 07:14:00 | AAPL | Stock | 16.7775 | 16.7825 | 16.7775 | 16.7825 | 19600.0 |
| 2013-08-13 07:15:00 | AAPL | Stock | 16.7825 | 16.7825 | 16.7825 | 16.7825 | 11200.0 |
| 2013-08-13 07:16:00 | AAPL | Stock | 16.7821 | 16.7893 | 16.7729 | 16.7786 | 25900.0 |
| 2013-08-13 07:17:00 | AAPL | Stock | 16.7854 | 16.7882 | 16.7854 | 16.7857 | 14000.0 |
| 2013-08-13 07:19:00 | AAPL | Stock | 16.7964 | 16.7964 | 16.785 | 16.7854 | 33600.0 |
| 2013-08-13 07:20:00 | AAPL | Stock | 16.785 | 16.785 | 16.785 | 16.785 | 2800.0 |
| 2013-08-13 07:27:00 | AAPL | Stock | 16.7768 | 16.7768 | 16.7711 | 16.7711 | 16800.0 |
| 2013-08-13 07:30:00 | AAPL | Stock | 16.7714 | 16.7714 | 16.7679 | 16.7679 | 90104.0 |
| 2013-08-13 07:33:00 | AAPL | Stock | 16.7743 | 16.7743 | 16.7679 | 16.7679 | 41860.0 |
| 2013-08-13 07:37:00 | AAPL | Stock | 16.7714 | 16.7732 | 16.7714 | 16.7732 | 25088.0 |
| 2013-08-13 07:38:00 | AAPL | Stock | 16.7736 | 16.7736 | 16.7736 | 16.7736 | 5600.0 |
| 2013-08-13 07:40:00 | AAPL | Stock | 16.7761 | 16.7814 | 16.7761 | 16.7814 | 30800.0 |
| 2013-08-13 07:41:00 | AAPL | Stock | 16.7775 | 16.7782 | 16.7775 | 16.7782 | 8400.0 |
| 2013-08-13 07:42:00 | AAPL | Stock | 16.7786 | 16.7786 | 16.7786 | 16.7786 | 2800.0 |
| 2013-08-13 07:43:00 | AAPL | Stock | 16.7779 | 16.7857 | 16.7779 | 16.7821 | 52500.0 |
> showing 50 of 982,239 rows — these rows as CSV