PREVIEW / stock_1min / 2013-09-23
file: by_date/stock_1min/2013/2013-09-23.parquet size: 14.0 MB rows: 1,022,339 symbols: 2,857
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-09-23 04:12:00 | AAPL | Stock | 16.7546 | 16.7546 | 16.7546 | 16.7546 | 2800.0 |
| 2013-09-23 04:36:00 | AAPL | Stock | 16.7893 | 16.7893 | 16.7893 | 16.7893 | 2800.0 |
| 2013-09-23 05:04:00 | AAPL | Stock | 16.8357 | 16.8357 | 16.8357 | 16.8357 | 3808.0 |
| 2013-09-23 05:20:00 | AAPL | Stock | 16.8039 | 16.8039 | 16.7893 | 16.7893 | 22400.0 |
| 2013-09-23 05:21:00 | AAPL | Stock | 16.79 | 16.79 | 16.7857 | 16.7857 | 14140.0 |
| 2013-09-23 05:31:00 | AAPL | Stock | 16.765 | 16.765 | 16.765 | 16.765 | 2800.0 |
| 2013-09-23 05:39:00 | AAPL | Stock | 16.7636 | 16.7636 | 16.7636 | 16.7636 | 2800.0 |
| 2013-09-23 05:40:00 | AAPL | Stock | 16.76 | 16.76 | 16.76 | 16.76 | 2800.0 |
| 2013-09-23 05:46:00 | AAPL | Stock | 16.7443 | 16.7443 | 16.7443 | 16.7443 | 2800.0 |
| 2013-09-23 05:50:00 | AAPL | Stock | 16.7639 | 16.7639 | 16.7639 | 16.7639 | 2800.0 |
| 2013-09-23 06:00:00 | AAPL | Stock | 16.7743 | 16.7743 | 16.7743 | 16.7743 | 4200.0 |
| 2013-09-23 06:04:00 | AAPL | Stock | 16.7732 | 16.7732 | 16.7732 | 16.7732 | 2800.0 |
| 2013-09-23 06:15:00 | AAPL | Stock | 16.7714 | 16.7714 | 16.7714 | 16.7714 | 25200.0 |
| 2013-09-23 06:17:00 | AAPL | Stock | 16.7768 | 16.7786 | 16.7768 | 16.7786 | 12320.0 |
| 2013-09-23 06:25:00 | AAPL | Stock | 16.7875 | 16.7875 | 16.7875 | 16.7875 | 2800.0 |
| 2013-09-23 06:26:00 | AAPL | Stock | 16.7818 | 16.7818 | 16.7732 | 16.7732 | 33600.0 |
| 2013-09-23 06:32:00 | AAPL | Stock | 16.7511 | 16.7511 | 16.7511 | 16.7511 | 2800.0 |
| 2013-09-23 06:35:00 | AAPL | Stock | 16.7511 | 16.7511 | 16.7511 | 16.7511 | 2800.0 |
| 2013-09-23 06:36:00 | AAPL | Stock | 16.755 | 16.755 | 16.755 | 16.755 | 2800.0 |
| 2013-09-23 06:38:00 | AAPL | Stock | 16.7511 | 16.7511 | 16.7511 | 16.7511 | 2800.0 |
| 2013-09-23 06:43:00 | AAPL | Stock | 16.7404 | 16.7511 | 16.7404 | 16.7404 | 14000.0 |
| 2013-09-23 06:47:00 | AAPL | Stock | 16.7571 | 16.7571 | 16.7571 | 16.7571 | 8400.0 |
| 2013-09-23 06:53:00 | AAPL | Stock | 16.75 | 16.75 | 16.75 | 16.75 | 2800.0 |
| 2013-09-23 06:54:00 | AAPL | Stock | 16.7429 | 16.7429 | 16.7429 | 16.7429 | 2800.0 |
| 2013-09-23 07:00:00 | AAPL | Stock | 16.7443 | 16.75 | 16.7286 | 16.7286 | 12264.0 |
| 2013-09-23 07:01:00 | AAPL | Stock | 16.7143 | 16.7143 | 16.7143 | 16.7143 | 28000.0 |
| 2013-09-23 07:02:00 | AAPL | Stock | 16.7154 | 16.7279 | 16.7143 | 16.7143 | 21000.0 |
| 2013-09-23 07:03:00 | AAPL | Stock | 16.7143 | 16.7143 | 16.7143 | 16.7143 | 2800.0 |
| 2013-09-23 07:06:00 | AAPL | Stock | 16.7139 | 16.7139 | 16.7139 | 16.7139 | 2800.0 |
| 2013-09-23 07:07:00 | AAPL | Stock | 16.6964 | 16.6964 | 16.6964 | 16.6964 | 2800.0 |
| 2013-09-23 07:08:00 | AAPL | Stock | 16.7143 | 16.7143 | 16.7143 | 16.7143 | 8540.0 |
| 2013-09-23 07:09:00 | AAPL | Stock | 16.7143 | 16.7143 | 16.7143 | 16.7143 | 6860.0 |
| 2013-09-23 07:11:00 | AAPL | Stock | 16.7143 | 16.7143 | 16.7143 | 16.7143 | 2800.0 |
| 2013-09-23 07:15:00 | AAPL | Stock | 16.7 | 16.7 | 16.6929 | 16.6929 | 25200.0 |
| 2013-09-23 07:17:00 | AAPL | Stock | 16.6982 | 16.6982 | 16.6982 | 16.6982 | 2800.0 |
| 2013-09-23 07:19:00 | AAPL | Stock | 16.6868 | 16.6868 | 16.6868 | 16.6868 | 5600.0 |
| 2013-09-23 07:21:00 | AAPL | Stock | 16.6786 | 16.6786 | 16.6786 | 16.6786 | 5600.0 |
| 2013-09-23 07:23:00 | AAPL | Stock | 16.6786 | 16.6786 | 16.6589 | 16.6589 | 5600.0 |
| 2013-09-23 07:26:00 | AAPL | Stock | 16.6446 | 16.6446 | 16.6429 | 16.6429 | 5740.0 |
| 2013-09-23 07:27:00 | AAPL | Stock | 16.6339 | 16.6339 | 16.6339 | 16.6339 | 5600.0 |
| 2013-09-23 07:28:00 | AAPL | Stock | 16.6318 | 16.6318 | 16.6046 | 16.6046 | 22400.0 |
| 2013-09-23 07:29:00 | AAPL | Stock | 16.6046 | 16.615 | 16.5718 | 16.6064 | 25200.0 |
| 2013-09-23 07:30:00 | AAPL | Stock | 16.5786 | 16.6014 | 16.5693 | 16.5693 | 72520.0 |
| 2013-09-23 07:31:00 | AAPL | Stock | 16.5793 | 16.5793 | 16.5375 | 16.5675 | 50400.0 |
| 2013-09-23 07:32:00 | AAPL | Stock | 16.5768 | 16.5996 | 16.5768 | 16.5996 | 14000.0 |
| 2013-09-23 07:33:00 | AAPL | Stock | 16.5554 | 16.5957 | 16.5429 | 16.5957 | 24808.0 |
| 2013-09-23 07:36:00 | AAPL | Stock | 16.5546 | 16.5546 | 16.5357 | 16.5396 | 32200.0 |
| 2013-09-23 07:37:00 | AAPL | Stock | 16.5389 | 16.5657 | 16.5389 | 16.5404 | 11200.0 |
| 2013-09-23 07:38:00 | AAPL | Stock | 16.5421 | 16.5714 | 16.5421 | 16.5614 | 79436.0 |
| 2013-09-23 07:39:00 | AAPL | Stock | 16.5554 | 16.5554 | 16.5468 | 16.5539 | 33936.0 |
> showing 50 of 1,022,339 rows — these rows as CSV