PREVIEW / stock_1min / 2013-11-05
file: by_date/stock_1min/2013/2013-11-05.parquet size: 13.8 MB rows: 1,012,516 symbols: 2,874
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-11-05 04:01:00 | AAPL | Stock | 18.7786 | 18.7786 | 18.7786 | 18.7786 | 2800.0 |
| 2013-11-05 04:43:00 | AAPL | Stock | 18.7143 | 18.7143 | 18.7143 | 18.7143 | 5600.0 |
| 2013-11-05 04:48:00 | AAPL | Stock | 18.7143 | 18.7143 | 18.7143 | 18.7143 | 14000.0 |
| 2013-11-05 04:52:00 | AAPL | Stock | 18.7264 | 18.7321 | 18.7264 | 18.7321 | 14000.0 |
| 2013-11-05 05:00:00 | AAPL | Stock | 18.7254 | 18.7329 | 18.7254 | 18.7329 | 14000.0 |
| 2013-11-05 05:17:00 | AAPL | Stock | 18.7321 | 18.7321 | 18.7321 | 18.7321 | 5320.0 |
| 2013-11-05 05:18:00 | AAPL | Stock | 18.7321 | 18.7321 | 18.7321 | 18.7321 | 5264.0 |
| 2013-11-05 05:54:00 | AAPL | Stock | 18.7339 | 18.7339 | 18.7339 | 18.7339 | 4200.0 |
| 2013-11-05 06:05:00 | AAPL | Stock | 18.7321 | 18.7321 | 18.7321 | 18.7321 | 5264.0 |
| 2013-11-05 06:07:00 | AAPL | Stock | 18.7321 | 18.7321 | 18.7321 | 18.7321 | 5264.0 |
| 2013-11-05 06:23:00 | AAPL | Stock | 18.7411 | 18.7411 | 18.7411 | 18.7411 | 2800.0 |
| 2013-11-05 06:42:00 | AAPL | Stock | 18.7357 | 18.7357 | 18.7357 | 18.7357 | 2800.0 |
| 2013-11-05 06:47:00 | AAPL | Stock | 18.7357 | 18.7357 | 18.7357 | 18.7357 | 2800.0 |
| 2013-11-05 06:54:00 | AAPL | Stock | 18.7518 | 18.7518 | 18.7518 | 18.7518 | 2800.0 |
| 2013-11-05 07:01:00 | AAPL | Stock | 18.7464 | 18.7464 | 18.7464 | 18.7464 | 4200.0 |
| 2013-11-05 07:03:00 | AAPL | Stock | 18.7532 | 18.7532 | 18.7532 | 18.7532 | 2800.0 |
| 2013-11-05 07:04:00 | AAPL | Stock | 18.7536 | 18.7536 | 18.7536 | 18.7536 | 5600.0 |
| 2013-11-05 07:05:00 | AAPL | Stock | 18.7607 | 18.7679 | 18.7607 | 18.7679 | 72464.0 |
| 2013-11-05 07:07:00 | AAPL | Stock | 18.78 | 18.78 | 18.78 | 18.78 | 10164.0 |
| 2013-11-05 07:08:00 | AAPL | Stock | 18.7804 | 18.7843 | 18.7804 | 18.7843 | 18368.0 |
| 2013-11-05 07:09:00 | AAPL | Stock | 18.7843 | 18.7843 | 18.7843 | 18.7843 | 5600.0 |
| 2013-11-05 07:11:00 | AAPL | Stock | 18.7786 | 18.7786 | 18.7786 | 18.7786 | 5600.0 |
| 2013-11-05 07:12:00 | AAPL | Stock | 18.7793 | 18.7793 | 18.7679 | 18.7679 | 11200.0 |
| 2013-11-05 07:15:00 | AAPL | Stock | 18.7536 | 18.7536 | 18.7536 | 18.7536 | 4760.0 |
| 2013-11-05 07:19:00 | AAPL | Stock | 18.7779 | 18.7779 | 18.7779 | 18.7779 | 2800.0 |
| 2013-11-05 07:22:00 | AAPL | Stock | 18.7786 | 18.7786 | 18.7786 | 18.7786 | 5600.0 |
| 2013-11-05 07:24:00 | AAPL | Stock | 18.7839 | 18.7839 | 18.7839 | 18.7839 | 7252.0 |
| 2013-11-05 07:27:00 | AAPL | Stock | 18.7739 | 18.7739 | 18.7739 | 18.7739 | 2800.0 |
| 2013-11-05 07:28:00 | AAPL | Stock | 18.7714 | 18.7714 | 18.7714 | 18.7714 | 4032.0 |
| 2013-11-05 07:37:00 | AAPL | Stock | 18.7804 | 18.7804 | 18.7804 | 18.7804 | 2800.0 |
| 2013-11-05 07:43:00 | AAPL | Stock | 18.7736 | 18.7736 | 18.7736 | 18.7736 | 5600.0 |
| 2013-11-05 07:46:00 | AAPL | Stock | 18.7736 | 18.7736 | 18.7736 | 18.7736 | 16800.0 |
| 2013-11-05 07:53:00 | AAPL | Stock | 18.7739 | 18.7739 | 18.7718 | 18.7718 | 16800.0 |
| 2013-11-05 07:58:00 | AAPL | Stock | 18.7643 | 18.7643 | 18.7589 | 18.7589 | 12880.0 |
| 2013-11-05 08:00:00 | AAPL | Stock | 18.7643 | 18.7839 | 18.7571 | 18.7639 | 67648.0 |
| 2013-11-05 08:01:00 | AAPL | Stock | 18.7632 | 18.8036 | 18.7561 | 18.8036 | 53200.0 |
| 2013-11-05 08:02:00 | AAPL | Stock | 18.7571 | 18.7571 | 18.75 | 18.75 | 21140.0 |
| 2013-11-05 08:03:00 | AAPL | Stock | 18.7639 | 18.7643 | 18.7639 | 18.7643 | 49056.0 |
| 2013-11-05 08:04:00 | AAPL | Stock | 18.7714 | 18.7714 | 18.7679 | 18.7679 | 8400.0 |
| 2013-11-05 08:05:00 | AAPL | Stock | 18.7696 | 18.7696 | 18.7696 | 18.7696 | 8400.0 |
| 2013-11-05 08:06:00 | AAPL | Stock | 18.7718 | 18.7718 | 18.7718 | 18.7718 | 4200.0 |
| 2013-11-05 08:07:00 | AAPL | Stock | 18.775 | 18.775 | 18.7732 | 18.7732 | 5600.0 |
| 2013-11-05 08:08:00 | AAPL | Stock | 18.7732 | 18.7732 | 18.7704 | 18.7704 | 9800.0 |
| 2013-11-05 08:09:00 | AAPL | Stock | 18.7696 | 18.7696 | 18.7696 | 18.7696 | 13636.0 |
| 2013-11-05 08:11:00 | AAPL | Stock | 18.775 | 18.775 | 18.7736 | 18.7736 | 5600.0 |
| 2013-11-05 08:12:00 | AAPL | Stock | 18.775 | 18.7768 | 18.775 | 18.7768 | 11200.0 |
| 2013-11-05 08:13:00 | AAPL | Stock | 18.7768 | 18.7768 | 18.7714 | 18.7714 | 30800.0 |
| 2013-11-05 08:14:00 | AAPL | Stock | 18.7768 | 18.7768 | 18.7768 | 18.7768 | 4312.0 |
| 2013-11-05 08:15:00 | AAPL | Stock | 18.7768 | 18.7768 | 18.7768 | 18.7768 | 2800.0 |
| 2013-11-05 08:18:00 | AAPL | Stock | 18.7768 | 18.7768 | 18.7768 | 18.7768 | 2800.0 |
> showing 50 of 1,012,516 rows — these rows as CSV