PREVIEW / stock_5min / 2013-09-12
file: by_date/stock_5min/2013/2013-09-12.parquet size: 5.1 MB rows: 339,703 symbols: 3,517
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-12 04:00:00 | AAPL | Stock | 16.7768 | 16.7768 | 16.7768 | 16.7768 | 2800.0 |
| 2013-09-12 04:10:00 | AAPL | Stock | 16.7082 | 16.7082 | 16.6968 | 16.6968 | 11200.0 |
| 2013-09-12 04:15:00 | AAPL | Stock | 16.7229 | 16.7229 | 16.7229 | 16.7229 | 8400.0 |
| 2013-09-12 04:20:00 | AAPL | Stock | 16.7279 | 16.75 | 16.7279 | 16.7496 | 8400.0 |
| 2013-09-12 04:25:00 | AAPL | Stock | 16.75 | 16.75 | 16.75 | 16.75 | 4256.0 |
| 2013-09-12 04:35:00 | AAPL | Stock | 16.7414 | 16.75 | 16.7414 | 16.75 | 16968.0 |
| 2013-09-12 04:40:00 | AAPL | Stock | 16.7714 | 16.7714 | 16.75 | 16.75 | 22400.0 |
| 2013-09-12 04:45:00 | AAPL | Stock | 16.7489 | 16.7507 | 16.7489 | 16.7507 | 5600.0 |
| 2013-09-12 04:50:00 | AAPL | Stock | 16.7432 | 16.7432 | 16.7432 | 16.7432 | 4564.0 |
| 2013-09-12 04:55:00 | AAPL | Stock | 16.7482 | 16.7482 | 16.7482 | 16.7482 | 2800.0 |
| 2013-09-12 05:00:00 | AAPL | Stock | 16.7396 | 16.7396 | 16.7396 | 16.7396 | 2800.0 |
| 2013-09-12 05:10:00 | AAPL | Stock | 16.74 | 16.7471 | 16.74 | 16.7471 | 5600.0 |
| 2013-09-12 05:15:00 | AAPL | Stock | 16.7436 | 16.7475 | 16.7436 | 16.7475 | 10080.0 |
| 2013-09-12 05:20:00 | AAPL | Stock | 16.7457 | 16.7461 | 16.7296 | 16.7429 | 62888.0 |
| 2013-09-12 05:25:00 | AAPL | Stock | 16.7461 | 16.7461 | 16.7461 | 16.7461 | 2800.0 |
| 2013-09-12 05:30:00 | AAPL | Stock | 16.7461 | 16.7529 | 16.7461 | 16.7529 | 33404.0 |
| 2013-09-12 05:35:00 | AAPL | Stock | 16.7639 | 16.7661 | 16.7639 | 16.7661 | 14840.0 |
| 2013-09-12 05:40:00 | AAPL | Stock | 16.7732 | 16.7732 | 16.7732 | 16.7732 | 2800.0 |
| 2013-09-12 05:45:00 | AAPL | Stock | 16.7743 | 16.7821 | 16.7636 | 16.7821 | 19600.0 |
| 2013-09-12 06:00:00 | AAPL | Stock | 16.7939 | 16.81 | 16.7921 | 16.81 | 36400.0 |
| 2013-09-12 06:20:00 | AAPL | Stock | 16.7968 | 16.8129 | 16.7968 | 16.8129 | 19600.0 |
| 2013-09-12 06:25:00 | AAPL | Stock | 16.8129 | 16.8132 | 16.8021 | 16.8021 | 28560.0 |
| 2013-09-12 06:30:00 | AAPL | Stock | 16.8004 | 16.8036 | 16.7911 | 16.7911 | 33600.0 |
| 2013-09-12 06:35:00 | AAPL | Stock | 16.7932 | 16.7932 | 16.7911 | 16.7911 | 19600.0 |
| 2013-09-12 06:45:00 | AAPL | Stock | 16.7857 | 16.7893 | 16.7857 | 16.7893 | 14000.0 |
| 2013-09-12 06:50:00 | AAPL | Stock | 16.7786 | 16.7789 | 16.7786 | 16.7786 | 8400.0 |
| 2013-09-12 06:55:00 | AAPL | Stock | 16.7782 | 16.7782 | 16.7782 | 16.7782 | 2800.0 |
| 2013-09-12 07:00:00 | AAPL | Stock | 16.7714 | 16.7786 | 16.7714 | 16.7782 | 45920.0 |
| 2013-09-12 07:05:00 | AAPL | Stock | 16.7764 | 16.7768 | 16.7764 | 16.7768 | 11200.0 |
| 2013-09-12 07:15:00 | AAPL | Stock | 16.7789 | 16.8018 | 16.7786 | 16.7946 | 103264.0 |
| 2013-09-12 07:20:00 | AAPL | Stock | 16.8014 | 16.8036 | 16.7979 | 16.8036 | 36400.0 |
| 2013-09-12 07:25:00 | AAPL | Stock | 16.8004 | 16.8157 | 16.8004 | 16.8107 | 43008.0 |
| 2013-09-12 07:30:00 | AAPL | Stock | 16.8132 | 16.8139 | 16.7882 | 16.8107 | 57428.0 |
| 2013-09-12 07:35:00 | AAPL | Stock | 16.7968 | 16.8104 | 16.7929 | 16.7929 | 18620.0 |
| 2013-09-12 07:40:00 | AAPL | Stock | 16.7864 | 16.7868 | 16.7854 | 16.7854 | 27524.0 |
| 2013-09-12 07:45:00 | AAPL | Stock | 16.785 | 16.8 | 16.785 | 16.8 | 106764.0 |
| 2013-09-12 07:50:00 | AAPL | Stock | 16.8114 | 16.8129 | 16.7861 | 16.7879 | 54516.0 |
| 2013-09-12 07:55:00 | AAPL | Stock | 16.8025 | 16.8125 | 16.7975 | 16.7975 | 36372.0 |
| 2013-09-12 08:00:00 | AAPL | Stock | 16.8036 | 16.8954 | 16.7768 | 16.8675 | 1161888.0 |
| 2013-09-12 08:05:00 | AAPL | Stock | 16.8796 | 16.8911 | 16.8618 | 16.8757 | 542528.0 |
| 2013-09-12 08:10:00 | AAPL | Stock | 16.8761 | 16.8911 | 16.8639 | 16.8911 | 539000.0 |
| 2013-09-12 08:15:00 | AAPL | Stock | 16.8893 | 16.9018 | 16.8639 | 16.8736 | 449260.0 |
| 2013-09-12 08:20:00 | AAPL | Stock | 16.8743 | 16.8764 | 16.8414 | 16.85 | 258384.0 |
| 2013-09-12 08:25:00 | AAPL | Stock | 16.8439 | 16.8554 | 16.8411 | 16.8486 | 131320.0 |
| 2013-09-12 08:30:00 | AAPL | Stock | 16.8571 | 16.8586 | 16.8289 | 16.8429 | 228032.0 |
| 2013-09-12 08:35:00 | AAPL | Stock | 16.8411 | 16.8411 | 16.8232 | 16.8282 | 101836.0 |
| 2013-09-12 08:40:00 | AAPL | Stock | 16.8279 | 16.8346 | 16.81 | 16.8304 | 158200.0 |
| 2013-09-12 08:45:00 | AAPL | Stock | 16.8304 | 16.8389 | 16.8193 | 16.8214 | 311136.0 |
| 2013-09-12 08:50:00 | AAPL | Stock | 16.8214 | 16.8314 | 16.8139 | 16.8314 | 71400.0 |
| 2013-09-12 08:55:00 | AAPL | Stock | 16.8375 | 16.8375 | 16.8164 | 16.8275 | 179116.0 |
> showing 50 of 339,703 rows — these rows as CSV