PREVIEW / stock_5min / 2010-04-14
file: by_date/stock_5min/2010/2010-04-14.parquet size: 5.0 MB rows: 341,486 symbols: 3,486
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 |
|---|---|---|---|---|---|---|---|
| 2010-04-14 04:15:00 | AAPL | Stock | 8.7054 | 8.7186 | 8.7054 | 8.7186 | 25200.0 |
| 2010-04-14 05:50:00 | AAPL | Stock | 8.7143 | 8.7143 | 8.7061 | 8.7061 | 16800.0 |
| 2010-04-14 06:00:00 | AAPL | Stock | 8.7071 | 8.7071 | 8.7071 | 8.7071 | 5600.0 |
| 2010-04-14 06:20:00 | AAPL | Stock | 8.7125 | 8.7125 | 8.7125 | 8.7125 | 5600.0 |
| 2010-04-14 06:40:00 | AAPL | Stock | 8.7071 | 8.7071 | 8.7071 | 8.7071 | 5600.0 |
| 2010-04-14 06:45:00 | AAPL | Stock | 8.7071 | 8.7071 | 8.7061 | 8.7061 | 14000.0 |
| 2010-04-14 06:55:00 | AAPL | Stock | 8.7104 | 8.7104 | 8.7104 | 8.7104 | 11200.0 |
| 2010-04-14 07:00:00 | AAPL | Stock | 8.7107 | 8.7107 | 8.7107 | 8.7107 | 11480.0 |
| 2010-04-14 07:05:00 | AAPL | Stock | 8.7107 | 8.7107 | 8.695 | 8.695 | 43400.0 |
| 2010-04-14 07:10:00 | AAPL | Stock | 8.695 | 8.695 | 8.695 | 8.695 | 2800.0 |
| 2010-04-14 07:25:00 | AAPL | Stock | 8.6964 | 8.6964 | 8.6879 | 8.6879 | 38276.0 |
| 2010-04-14 07:30:00 | AAPL | Stock | 8.6918 | 8.6961 | 8.6918 | 8.6929 | 33600.0 |
| 2010-04-14 07:35:00 | AAPL | Stock | 8.6921 | 8.6921 | 8.6921 | 8.6921 | 11200.0 |
| 2010-04-14 07:40:00 | AAPL | Stock | 8.6857 | 8.6857 | 8.6857 | 8.6857 | 11200.0 |
| 2010-04-14 07:45:00 | AAPL | Stock | 8.6921 | 8.6921 | 8.6904 | 8.6921 | 33600.0 |
| 2010-04-14 07:50:00 | AAPL | Stock | 8.6893 | 8.6893 | 8.6893 | 8.6893 | 2800.0 |
| 2010-04-14 07:55:00 | AAPL | Stock | 8.6893 | 8.6929 | 8.6893 | 8.6929 | 27972.0 |
| 2010-04-14 08:00:00 | AAPL | Stock | 8.6964 | 8.7018 | 8.6946 | 8.7018 | 244776.0 |
| 2010-04-14 08:05:00 | AAPL | Stock | 8.7011 | 8.71 | 8.6971 | 8.7068 | 356244.0 |
| 2010-04-14 08:10:00 | AAPL | Stock | 8.7089 | 8.71 | 8.6964 | 8.7036 | 197288.0 |
| 2010-04-14 08:15:00 | AAPL | Stock | 8.7036 | 8.7036 | 8.6971 | 8.6986 | 402780.0 |
| 2010-04-14 08:20:00 | AAPL | Stock | 8.6996 | 8.7054 | 8.6993 | 8.7018 | 521052.0 |
| 2010-04-14 08:25:00 | AAPL | Stock | 8.6989 | 8.7004 | 8.6979 | 8.6993 | 145740.0 |
| 2010-04-14 08:30:00 | AAPL | Stock | 8.7 | 8.7696 | 8.6971 | 8.7679 | 6934340.0 |
| 2010-04-14 08:35:00 | AAPL | Stock | 8.7696 | 8.8014 | 8.7643 | 8.7768 | 4322360.0 |
| 2010-04-14 08:40:00 | AAPL | Stock | 8.7768 | 8.7768 | 8.7554 | 8.7593 | 1369648.0 |
| 2010-04-14 08:45:00 | AAPL | Stock | 8.7596 | 8.7668 | 8.7429 | 8.755 | 1816444.0 |
| 2010-04-14 08:50:00 | AAPL | Stock | 8.755 | 8.7718 | 8.75 | 8.7707 | 1431304.0 |
| 2010-04-14 08:55:00 | AAPL | Stock | 8.7707 | 8.7836 | 8.7646 | 8.7814 | 1495564.0 |
| 2010-04-14 09:00:00 | AAPL | Stock | 8.7811 | 8.7854 | 8.7675 | 8.7746 | 631596.0 |
| 2010-04-14 09:05:00 | AAPL | Stock | 8.7721 | 8.7746 | 8.7618 | 8.7636 | 814492.0 |
| 2010-04-14 09:10:00 | AAPL | Stock | 8.7625 | 8.7696 | 8.7618 | 8.7646 | 683928.0 |
| 2010-04-14 09:15:00 | AAPL | Stock | 8.7646 | 8.7732 | 8.7632 | 8.7725 | 767032.0 |
| 2010-04-14 09:20:00 | AAPL | Stock | 8.7729 | 8.7771 | 8.7714 | 8.7725 | 562548.0 |
| 2010-04-14 09:25:00 | AAPL | Stock | 8.7721 | 8.7736 | 8.7543 | 8.7586 | 1626548.0 |
| 2010-04-14 09:30:00 | AAPL | Stock | 8.76 | 8.7682 | 8.7321 | 8.7407 | 26904976.0 |
| 2010-04-14 09:35:00 | AAPL | Stock | 8.7425 | 8.7564 | 8.7371 | 8.7521 | 14040964.0 |
| 2010-04-14 09:40:00 | AAPL | Stock | 8.7525 | 8.7554 | 8.735 | 8.735 | 10428292.0 |
| 2010-04-14 09:45:00 | AAPL | Stock | 8.735 | 8.7561 | 8.7259 | 8.7482 | 15473696.0 |
| 2010-04-14 09:50:00 | AAPL | Stock | 8.7489 | 8.75 | 8.7396 | 8.7446 | 6600132.0 |
| 2010-04-14 09:55:00 | AAPL | Stock | 8.7439 | 8.7461 | 8.7357 | 8.74 | 6778632.0 |
| 2010-04-14 10:00:00 | AAPL | Stock | 8.74 | 8.7446 | 8.7168 | 8.7411 | 14690984.0 |
| 2010-04-14 10:05:00 | AAPL | Stock | 8.7414 | 8.7564 | 8.7414 | 8.7554 | 12595576.0 |
| 2010-04-14 10:10:00 | AAPL | Stock | 8.7554 | 8.7621 | 8.7429 | 8.75 | 11145036.0 |
| 2010-04-14 10:15:00 | AAPL | Stock | 8.7496 | 8.7768 | 8.7471 | 8.7743 | 14665252.0 |
| 2010-04-14 10:20:00 | AAPL | Stock | 8.7757 | 8.7757 | 8.7614 | 8.7668 | 7624624.0 |
| 2010-04-14 10:25:00 | AAPL | Stock | 8.7643 | 8.7746 | 8.7625 | 8.7686 | 5878124.0 |
| 2010-04-14 10:30:00 | AAPL | Stock | 8.7696 | 8.775 | 8.7521 | 8.753 | 9527560.0 |
| 2010-04-14 10:35:00 | AAPL | Stock | 8.7539 | 8.7568 | 8.7475 | 8.75 | 8076068.0 |
| 2010-04-14 10:40:00 | AAPL | Stock | 8.75 | 8.7593 | 8.7489 | 8.7561 | 4346972.0 |
> showing 50 of 341,486 rows — these rows as CSV