PREVIEW / stock_1min / 2014-01-17
file: by_date/stock_1min/2014/2014-01-17.parquet size: 14.3 MB rows: 1,034,981 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 |
|---|---|---|---|---|---|---|---|
| 2014-01-17 05:09:00 | AAPL | Stock | 19.8214 | 19.8214 | 19.8214 | 19.8214 | 2800.0 |
| 2014-01-17 05:14:00 | AAPL | Stock | 19.8214 | 19.8214 | 19.8214 | 19.8214 | 2800.0 |
| 2014-01-17 05:20:00 | AAPL | Stock | 19.8182 | 19.8182 | 19.8107 | 19.8107 | 5600.0 |
| 2014-01-17 05:32:00 | AAPL | Stock | 19.8111 | 19.8111 | 19.8107 | 19.8107 | 7420.0 |
| 2014-01-17 05:33:00 | AAPL | Stock | 19.8129 | 19.8129 | 19.8129 | 19.8129 | 2800.0 |
| 2014-01-17 05:36:00 | AAPL | Stock | 19.8129 | 19.8129 | 19.8129 | 19.8129 | 2800.0 |
| 2014-01-17 05:45:00 | AAPL | Stock | 19.8054 | 19.8054 | 19.8054 | 19.8054 | 2800.0 |
| 2014-01-17 05:49:00 | AAPL | Stock | 19.8154 | 19.8154 | 19.8154 | 19.8154 | 8400.0 |
| 2014-01-17 06:00:00 | AAPL | Stock | 19.7946 | 19.7946 | 19.7946 | 19.7946 | 2800.0 |
| 2014-01-17 06:02:00 | AAPL | Stock | 19.7875 | 19.7875 | 19.7875 | 19.7875 | 2800.0 |
| 2014-01-17 06:10:00 | AAPL | Stock | 19.7814 | 19.7821 | 19.7814 | 19.7821 | 8400.0 |
| 2014-01-17 06:13:00 | AAPL | Stock | 19.7857 | 19.7857 | 19.7857 | 19.7857 | 5320.0 |
| 2014-01-17 06:15:00 | AAPL | Stock | 19.7821 | 19.7821 | 19.7821 | 19.7821 | 2800.0 |
| 2014-01-17 06:19:00 | AAPL | Stock | 19.7789 | 19.7821 | 19.7789 | 19.7789 | 13104.0 |
| 2014-01-17 06:20:00 | AAPL | Stock | 19.7768 | 19.7768 | 19.7768 | 19.7768 | 2800.0 |
| 2014-01-17 06:28:00 | AAPL | Stock | 19.8111 | 19.8111 | 19.7821 | 19.7821 | 31640.0 |
| 2014-01-17 06:29:00 | AAPL | Stock | 19.7857 | 19.7857 | 19.7857 | 19.7857 | 5908.0 |
| 2014-01-17 06:33:00 | AAPL | Stock | 19.7821 | 19.7821 | 19.7821 | 19.7821 | 2800.0 |
| 2014-01-17 06:34:00 | AAPL | Stock | 19.7825 | 19.7825 | 19.7825 | 19.7825 | 7504.0 |
| 2014-01-17 06:39:00 | AAPL | Stock | 19.7754 | 19.7754 | 19.7525 | 19.7525 | 5600.0 |
| 2014-01-17 06:40:00 | AAPL | Stock | 19.7525 | 19.7607 | 19.7518 | 19.7607 | 27160.0 |
| 2014-01-17 06:46:00 | AAPL | Stock | 19.7357 | 19.7357 | 19.7254 | 19.7254 | 11200.0 |
| 2014-01-17 06:47:00 | AAPL | Stock | 19.7254 | 19.7254 | 19.7254 | 19.7254 | 2800.0 |
| 2014-01-17 06:49:00 | AAPL | Stock | 19.7354 | 19.7536 | 19.7354 | 19.7536 | 28000.0 |
| 2014-01-17 06:52:00 | AAPL | Stock | 19.75 | 19.75 | 19.75 | 19.75 | 8400.0 |
| 2014-01-17 06:57:00 | AAPL | Stock | 19.7411 | 19.7411 | 19.7407 | 19.7407 | 5600.0 |
| 2014-01-17 06:59:00 | AAPL | Stock | 19.7461 | 19.7464 | 19.7461 | 19.7464 | 28000.0 |
| 2014-01-17 07:01:00 | AAPL | Stock | 19.7325 | 19.7504 | 19.7311 | 19.7504 | 28000.0 |
| 2014-01-17 07:05:00 | AAPL | Stock | 19.7446 | 19.7446 | 19.7446 | 19.7446 | 14000.0 |
| 2014-01-17 07:06:00 | AAPL | Stock | 19.7496 | 19.75 | 19.7496 | 19.75 | 10864.0 |
| 2014-01-17 07:07:00 | AAPL | Stock | 19.75 | 19.75 | 19.75 | 19.75 | 2800.0 |
| 2014-01-17 07:09:00 | AAPL | Stock | 19.7607 | 19.7607 | 19.7607 | 19.7607 | 12600.0 |
| 2014-01-17 07:11:00 | AAPL | Stock | 19.7589 | 19.7589 | 19.7589 | 19.7589 | 8400.0 |
| 2014-01-17 07:12:00 | AAPL | Stock | 19.7464 | 19.7464 | 19.7464 | 19.7464 | 2800.0 |
| 2014-01-17 07:15:00 | AAPL | Stock | 19.7564 | 19.7568 | 19.7564 | 19.7568 | 5600.0 |
| 2014-01-17 07:17:00 | AAPL | Stock | 19.7464 | 19.7464 | 19.7464 | 19.7464 | 12600.0 |
| 2014-01-17 07:20:00 | AAPL | Stock | 19.7339 | 19.7339 | 19.7339 | 19.7339 | 7000.0 |
| 2014-01-17 07:21:00 | AAPL | Stock | 19.7214 | 19.7214 | 19.7039 | 19.7039 | 21812.0 |
| 2014-01-17 07:23:00 | AAPL | Stock | 19.7139 | 19.7139 | 19.7139 | 19.7139 | 5600.0 |
| 2014-01-17 07:24:00 | AAPL | Stock | 19.7143 | 19.7143 | 19.7143 | 19.7143 | 8400.0 |
| 2014-01-17 07:25:00 | AAPL | Stock | 19.7057 | 19.7057 | 19.7057 | 19.7057 | 2800.0 |
| 2014-01-17 07:26:00 | AAPL | Stock | 19.6896 | 19.6896 | 19.6786 | 19.6854 | 60648.0 |
| 2014-01-17 07:27:00 | AAPL | Stock | 19.6868 | 19.6868 | 19.6714 | 19.6714 | 8400.0 |
| 2014-01-17 07:29:00 | AAPL | Stock | 19.6661 | 19.67 | 19.6521 | 19.6536 | 84644.0 |
| 2014-01-17 07:30:00 | AAPL | Stock | 19.6521 | 19.6521 | 19.6464 | 19.6464 | 14000.0 |
| 2014-01-17 07:31:00 | AAPL | Stock | 19.6607 | 19.6607 | 19.6607 | 19.6607 | 14000.0 |
| 2014-01-17 07:32:00 | AAPL | Stock | 19.6596 | 19.6696 | 19.6596 | 19.6696 | 53312.0 |
| 2014-01-17 07:34:00 | AAPL | Stock | 19.6671 | 19.6679 | 19.6671 | 19.6679 | 14000.0 |
| 2014-01-17 07:35:00 | AAPL | Stock | 19.6775 | 19.6775 | 19.6775 | 19.6775 | 2800.0 |
| 2014-01-17 07:36:00 | AAPL | Stock | 19.6732 | 19.6771 | 19.6732 | 19.6771 | 5600.0 |
> showing 50 of 1,034,981 rows — these rows as CSV