PREVIEW / stock_1min / 2013-08-14
file: by_date/stock_1min/2013/2013-08-14.parquet size: 13.2 MB rows: 967,616 symbols: 2,853
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-14 04:00:00 | AAPL | Stock | 17.6071 | 17.6857 | 17.6071 | 17.6821 | 32900.0 |
| 2013-08-14 04:01:00 | AAPL | Stock | 17.6821 | 17.7129 | 17.6821 | 17.6839 | 28000.0 |
| 2013-08-14 04:02:00 | AAPL | Stock | 17.6839 | 17.6839 | 17.6839 | 17.6839 | 6356.0 |
| 2013-08-14 04:05:00 | AAPL | Stock | 17.6464 | 17.6839 | 17.6464 | 17.6839 | 19152.0 |
| 2013-08-14 04:06:00 | AAPL | Stock | 17.6839 | 17.6839 | 17.6839 | 17.6839 | 2800.0 |
| 2013-08-14 04:07:00 | AAPL | Stock | 17.6832 | 17.6832 | 17.6832 | 17.6832 | 2800.0 |
| 2013-08-14 04:15:00 | AAPL | Stock | 17.6714 | 17.6714 | 17.6714 | 17.6714 | 5432.0 |
| 2013-08-14 04:21:00 | AAPL | Stock | 17.6696 | 17.6696 | 17.6696 | 17.6696 | 3276.0 |
| 2013-08-14 04:22:00 | AAPL | Stock | 17.6696 | 17.6696 | 17.6696 | 17.6696 | 3248.0 |
| 2013-08-14 04:25:00 | AAPL | Stock | 17.6696 | 17.6696 | 17.6696 | 17.6696 | 5600.0 |
| 2013-08-14 04:34:00 | AAPL | Stock | 17.6714 | 17.6714 | 17.6714 | 17.6714 | 2800.0 |
| 2013-08-14 04:35:00 | AAPL | Stock | 17.6689 | 17.6689 | 17.6689 | 17.6689 | 2800.0 |
| 2013-08-14 04:38:00 | AAPL | Stock | 17.6625 | 17.6625 | 17.6511 | 17.6511 | 17528.0 |
| 2013-08-14 04:39:00 | AAPL | Stock | 17.6464 | 17.6464 | 17.6464 | 17.6464 | 2800.0 |
| 2013-08-14 04:40:00 | AAPL | Stock | 17.65 | 17.65 | 17.65 | 17.65 | 2800.0 |
| 2013-08-14 04:43:00 | AAPL | Stock | 17.6482 | 17.6482 | 17.6429 | 17.6429 | 16800.0 |
| 2013-08-14 04:44:00 | AAPL | Stock | 17.6429 | 17.6429 | 17.6429 | 17.6429 | 2800.0 |
| 2013-08-14 05:05:00 | AAPL | Stock | 17.6321 | 17.6321 | 17.6282 | 17.6282 | 7392.0 |
| 2013-08-14 05:06:00 | AAPL | Stock | 17.6457 | 17.6457 | 17.6457 | 17.6457 | 2800.0 |
| 2013-08-14 05:19:00 | AAPL | Stock | 17.6304 | 17.6304 | 17.6304 | 17.6304 | 2800.0 |
| 2013-08-14 05:22:00 | AAPL | Stock | 17.6386 | 17.6386 | 17.6386 | 17.6386 | 2800.0 |
| 2013-08-14 05:26:00 | AAPL | Stock | 17.6304 | 17.6304 | 17.6304 | 17.6304 | 2800.0 |
| 2013-08-14 05:27:00 | AAPL | Stock | 17.6429 | 17.6429 | 17.6429 | 17.6429 | 2800.0 |
| 2013-08-14 05:36:00 | AAPL | Stock | 17.6457 | 17.6464 | 17.6457 | 17.6464 | 8204.0 |
| 2013-08-14 05:37:00 | AAPL | Stock | 17.6482 | 17.6486 | 17.6482 | 17.6486 | 5600.0 |
| 2013-08-14 05:38:00 | AAPL | Stock | 17.6607 | 17.6607 | 17.6607 | 17.6607 | 2800.0 |
| 2013-08-14 05:42:00 | AAPL | Stock | 17.6786 | 17.6786 | 17.6786 | 17.6786 | 5600.0 |
| 2013-08-14 05:46:00 | AAPL | Stock | 17.6786 | 17.6786 | 17.6761 | 17.6761 | 5600.0 |
| 2013-08-14 05:57:00 | AAPL | Stock | 17.6786 | 17.6982 | 17.6786 | 17.6982 | 19600.0 |
| 2013-08-14 06:02:00 | AAPL | Stock | 17.6982 | 17.6982 | 17.6982 | 17.6982 | 5600.0 |
| 2013-08-14 06:06:00 | AAPL | Stock | 17.7107 | 17.7143 | 17.7071 | 17.7143 | 39200.0 |
| 2013-08-14 06:07:00 | AAPL | Stock | 17.7336 | 17.7482 | 17.7336 | 17.7482 | 33600.0 |
| 2013-08-14 06:08:00 | AAPL | Stock | 17.7146 | 17.7146 | 17.7146 | 17.7146 | 2800.0 |
| 2013-08-14 06:09:00 | AAPL | Stock | 17.7111 | 17.7111 | 17.7111 | 17.7111 | 5600.0 |
| 2013-08-14 06:15:00 | AAPL | Stock | 17.7107 | 17.7107 | 17.7107 | 17.7107 | 3500.0 |
| 2013-08-14 06:16:00 | AAPL | Stock | 17.7411 | 17.7411 | 17.7411 | 17.7411 | 8400.0 |
| 2013-08-14 06:17:00 | AAPL | Stock | 17.7125 | 17.7125 | 17.7125 | 17.7125 | 2800.0 |
| 2013-08-14 06:18:00 | AAPL | Stock | 17.6982 | 17.6982 | 17.6982 | 17.6982 | 3892.0 |
| 2013-08-14 06:19:00 | AAPL | Stock | 17.6964 | 17.6964 | 17.6825 | 17.6825 | 24108.0 |
| 2013-08-14 06:20:00 | AAPL | Stock | 17.6796 | 17.6796 | 17.6789 | 17.6789 | 5600.0 |
| 2013-08-14 06:21:00 | AAPL | Stock | 17.6789 | 17.6789 | 17.6789 | 17.6789 | 13160.0 |
| 2013-08-14 06:23:00 | AAPL | Stock | 17.6986 | 17.6986 | 17.6986 | 17.6986 | 14000.0 |
| 2013-08-14 06:25:00 | AAPL | Stock | 17.7143 | 17.7425 | 17.7143 | 17.7425 | 24584.0 |
| 2013-08-14 06:27:00 | AAPL | Stock | 17.7354 | 17.7354 | 17.7125 | 17.7161 | 11200.0 |
| 2013-08-14 06:28:00 | AAPL | Stock | 17.7146 | 17.7146 | 17.7146 | 17.7146 | 8288.0 |
| 2013-08-14 06:29:00 | AAPL | Stock | 17.7143 | 17.7143 | 17.7143 | 17.7143 | 5600.0 |
| 2013-08-14 06:30:00 | AAPL | Stock | 17.7143 | 17.7143 | 17.7143 | 17.7143 | 5376.0 |
| 2013-08-14 06:31:00 | AAPL | Stock | 17.7036 | 17.7036 | 17.7 | 17.7 | 15120.0 |
| 2013-08-14 06:34:00 | AAPL | Stock | 17.7039 | 17.7039 | 17.6986 | 17.6986 | 12320.0 |
| 2013-08-14 06:35:00 | AAPL | Stock | 17.6914 | 17.6964 | 17.6911 | 17.6964 | 14000.0 |
> showing 50 of 967,616 rows — these rows as CSV