PREVIEW / stock_5min / 2010-04-20
file: by_date/stock_5min/2010/2010-04-20.parquet size: 4.8 MB rows: 330,040 symbols: 3,485
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-20 04:10:00 | AAPL | Stock | 8.8821 | 8.8821 | 8.8821 | 8.8821 | 14000.0 |
| 2010-04-20 04:15:00 | AAPL | Stock | 8.8821 | 8.8821 | 8.8821 | 8.8821 | 11200.0 |
| 2010-04-20 04:20:00 | AAPL | Stock | 8.8893 | 8.8893 | 8.8893 | 8.8893 | 8400.0 |
| 2010-04-20 04:25:00 | AAPL | Stock | 8.8907 | 8.8907 | 8.89 | 8.89 | 25200.0 |
| 2010-04-20 05:05:00 | AAPL | Stock | 8.875 | 8.875 | 8.875 | 8.875 | 14000.0 |
| 2010-04-20 05:45:00 | AAPL | Stock | 8.875 | 8.875 | 8.875 | 8.875 | 22400.0 |
| 2010-04-20 06:45:00 | AAPL | Stock | 8.8732 | 8.8732 | 8.8732 | 8.8732 | 19040.0 |
| 2010-04-20 06:50:00 | AAPL | Stock | 8.8732 | 8.8925 | 8.8732 | 8.8925 | 80696.0 |
| 2010-04-20 06:55:00 | AAPL | Stock | 8.8929 | 8.8929 | 8.8929 | 8.8929 | 2800.0 |
| 2010-04-20 07:00:00 | AAPL | Stock | 8.8929 | 8.8929 | 8.8925 | 8.8925 | 61180.0 |
| 2010-04-20 07:05:00 | AAPL | Stock | 8.8921 | 8.8921 | 8.8921 | 8.8921 | 8064.0 |
| 2010-04-20 07:10:00 | AAPL | Stock | 8.8921 | 8.8921 | 8.8575 | 8.8575 | 42000.0 |
| 2010-04-20 07:15:00 | AAPL | Stock | 8.8736 | 8.8768 | 8.8736 | 8.8768 | 9800.0 |
| 2010-04-20 07:20:00 | AAPL | Stock | 8.8732 | 8.8732 | 8.8639 | 8.8639 | 30492.0 |
| 2010-04-20 07:45:00 | AAPL | Stock | 8.8679 | 8.8679 | 8.8679 | 8.8679 | 2800.0 |
| 2010-04-20 07:50:00 | AAPL | Stock | 8.8654 | 8.8654 | 8.8607 | 8.8607 | 36260.0 |
| 2010-04-20 08:00:00 | AAPL | Stock | 8.8643 | 8.8739 | 8.8575 | 8.8661 | 594664.0 |
| 2010-04-20 08:05:00 | AAPL | Stock | 8.8661 | 8.8679 | 8.8571 | 8.8618 | 196140.0 |
| 2010-04-20 08:10:00 | AAPL | Stock | 8.8618 | 8.8643 | 8.8571 | 8.8571 | 258832.0 |
| 2010-04-20 08:15:00 | AAPL | Stock | 8.86 | 8.8614 | 8.8575 | 8.8607 | 154224.0 |
| 2010-04-20 08:20:00 | AAPL | Stock | 8.8614 | 8.8704 | 8.8575 | 8.865 | 361648.0 |
| 2010-04-20 08:25:00 | AAPL | Stock | 8.8657 | 8.8732 | 8.8632 | 8.8704 | 220360.0 |
| 2010-04-20 08:30:00 | AAPL | Stock | 8.8711 | 8.8764 | 8.8696 | 8.8714 | 422856.0 |
| 2010-04-20 08:35:00 | AAPL | Stock | 8.8696 | 8.875 | 8.8689 | 8.8707 | 411768.0 |
| 2010-04-20 08:40:00 | AAPL | Stock | 8.8714 | 8.8732 | 8.8707 | 8.8711 | 126644.0 |
| 2010-04-20 08:45:00 | AAPL | Stock | 8.8711 | 8.8725 | 8.8711 | 8.8725 | 38192.0 |
| 2010-04-20 08:50:00 | AAPL | Stock | 8.8725 | 8.8732 | 8.8711 | 8.8714 | 59360.0 |
| 2010-04-20 08:55:00 | AAPL | Stock | 8.8718 | 8.8718 | 8.8657 | 8.8661 | 49252.0 |
| 2010-04-20 09:00:00 | AAPL | Stock | 8.8661 | 8.8664 | 8.8625 | 8.8629 | 125132.0 |
| 2010-04-20 09:05:00 | AAPL | Stock | 8.8643 | 8.8679 | 8.8586 | 8.8614 | 162400.0 |
| 2010-04-20 09:10:00 | AAPL | Stock | 8.8239 | 8.8696 | 8.8239 | 8.8695 | 246960.0 |
| 2010-04-20 09:15:00 | AAPL | Stock | 8.8698 | 8.8714 | 8.865 | 8.87 | 139720.0 |
| 2010-04-20 09:20:00 | AAPL | Stock | 8.8671 | 8.8686 | 8.8661 | 8.8675 | 116480.0 |
| 2010-04-20 09:25:00 | AAPL | Stock | 8.8657 | 8.875 | 8.8657 | 8.8729 | 615720.0 |
| 2010-04-20 09:30:00 | AAPL | Stock | 8.8732 | 8.9018 | 8.8321 | 8.8414 | 21277676.0 |
| 2010-04-20 09:35:00 | AAPL | Stock | 8.8407 | 8.8439 | 8.7786 | 8.7925 | 22486968.0 |
| 2010-04-20 09:40:00 | AAPL | Stock | 8.7914 | 8.8136 | 8.7857 | 8.8036 | 9616432.0 |
| 2010-04-20 09:45:00 | AAPL | Stock | 8.8046 | 8.8057 | 8.7854 | 8.8 | 11175080.0 |
| 2010-04-20 09:50:00 | AAPL | Stock | 8.8 | 8.8004 | 8.7893 | 8.79 | 9674336.0 |
| 2010-04-20 09:55:00 | AAPL | Stock | 8.7905 | 8.7982 | 8.7543 | 8.7614 | 19999364.0 |
| 2010-04-20 10:00:00 | AAPL | Stock | 8.7607 | 8.7686 | 8.7471 | 8.7582 | 13168736.0 |
| 2010-04-20 10:05:00 | AAPL | Stock | 8.7596 | 8.7714 | 8.75 | 8.7601 | 7959812.0 |
| 2010-04-20 10:10:00 | AAPL | Stock | 8.76 | 8.7604 | 8.7375 | 8.7393 | 10625412.0 |
| 2010-04-20 10:15:00 | AAPL | Stock | 8.7375 | 8.7459 | 8.7357 | 8.7371 | 6897604.0 |
| 2010-04-20 10:20:00 | AAPL | Stock | 8.7371 | 8.7432 | 8.7214 | 8.7414 | 11750032.0 |
| 2010-04-20 10:25:00 | AAPL | Stock | 8.7425 | 8.7489 | 8.7179 | 8.7189 | 9594732.0 |
| 2010-04-20 10:30:00 | AAPL | Stock | 8.7189 | 8.7196 | 8.6879 | 8.697 | 16766876.0 |
| 2010-04-20 10:35:00 | AAPL | Stock | 8.6978 | 8.7 | 8.677 | 8.6993 | 16644712.0 |
| 2010-04-20 10:40:00 | AAPL | Stock | 8.6992 | 8.7248 | 8.6946 | 8.7224 | 11742556.0 |
| 2010-04-20 10:45:00 | AAPL | Stock | 8.7229 | 8.7468 | 8.7161 | 8.7396 | 10889256.0 |
> showing 50 of 330,040 rows — these rows as CSV