PREVIEW / stock_5min / 2008-08-07
file: by_date/stock_5min/2008/2008-08-07.parquet size: 4.5 MB rows: 321,672 symbols: 3,309
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 |
|---|---|---|---|---|---|---|---|
| 2008-08-07 07:15:00 | AAPL | Stock | 5.8411 | 5.8411 | 5.8411 | 5.8411 | 13720.0 |
| 2008-08-07 07:20:00 | AAPL | Stock | 5.8271 | 5.8321 | 5.8268 | 5.8286 | 14000.0 |
| 2008-08-07 07:25:00 | AAPL | Stock | 5.8289 | 5.8289 | 5.8286 | 5.8286 | 8120.0 |
| 2008-08-07 07:30:00 | AAPL | Stock | 5.8321 | 5.8321 | 5.8321 | 5.8321 | 2800.0 |
| 2008-08-07 07:35:00 | AAPL | Stock | 5.8479 | 5.8479 | 5.8479 | 5.8479 | 2800.0 |
| 2008-08-07 07:55:00 | AAPL | Stock | 5.8307 | 5.8307 | 5.8207 | 5.8214 | 182000.0 |
| 2008-08-07 08:00:00 | AAPL | Stock | 5.8214 | 5.8286 | 5.8136 | 5.8161 | 155092.0 |
| 2008-08-07 08:05:00 | AAPL | Stock | 5.8182 | 5.8204 | 5.8143 | 5.8161 | 48972.0 |
| 2008-08-07 08:10:00 | AAPL | Stock | 5.8211 | 5.8214 | 5.8036 | 5.8107 | 235704.0 |
| 2008-08-07 08:15:00 | AAPL | Stock | 5.8107 | 5.8107 | 5.8054 | 5.8057 | 112000.0 |
| 2008-08-07 08:20:00 | AAPL | Stock | 5.8068 | 5.8196 | 5.8036 | 5.81 | 384804.0 |
| 2008-08-07 08:25:00 | AAPL | Stock | 5.8089 | 5.81 | 5.8039 | 5.8039 | 36680.0 |
| 2008-08-07 08:30:00 | AAPL | Stock | 5.8039 | 5.8071 | 5.7857 | 5.7971 | 198632.0 |
| 2008-08-07 08:35:00 | AAPL | Stock | 5.7943 | 5.8004 | 5.7907 | 5.7946 | 219800.0 |
| 2008-08-07 08:40:00 | AAPL | Stock | 5.7954 | 5.7982 | 5.7911 | 5.7932 | 111160.0 |
| 2008-08-07 08:45:00 | AAPL | Stock | 5.7996 | 5.8007 | 5.7911 | 5.8007 | 204708.0 |
| 2008-08-07 08:50:00 | AAPL | Stock | 5.7971 | 5.7971 | 5.7964 | 5.7964 | 96600.0 |
| 2008-08-07 08:55:00 | AAPL | Stock | 5.7968 | 5.7968 | 5.795 | 5.795 | 53200.0 |
| 2008-08-07 09:00:00 | AAPL | Stock | 5.7946 | 5.7946 | 5.7868 | 5.7893 | 286776.0 |
| 2008-08-07 09:05:00 | AAPL | Stock | 5.7864 | 5.7929 | 5.7861 | 5.7879 | 93716.0 |
| 2008-08-07 09:10:00 | AAPL | Stock | 5.7879 | 5.7907 | 5.7857 | 5.7893 | 239092.0 |
| 2008-08-07 09:15:00 | AAPL | Stock | 5.7882 | 5.7946 | 5.7882 | 5.7893 | 80640.0 |
| 2008-08-07 09:20:00 | AAPL | Stock | 5.7882 | 5.7932 | 5.7882 | 5.7911 | 297080.0 |
| 2008-08-07 09:25:00 | AAPL | Stock | 5.7996 | 5.8196 | 5.7996 | 5.8114 | 559272.0 |
| 2008-08-07 09:30:00 | AAPL | Stock | 5.8111 | 5.8229 | 5.7964 | 5.8014 | 20007624.0 |
| 2008-08-07 09:35:00 | AAPL | Stock | 5.8025 | 5.8071 | 5.7714 | 5.8057 | 21153636.0 |
| 2008-08-07 09:40:00 | AAPL | Stock | 5.8057 | 5.8304 | 5.7968 | 5.8261 | 14385924.0 |
| 2008-08-07 09:45:00 | AAPL | Stock | 5.8294 | 5.8521 | 5.8114 | 5.8464 | 17491292.0 |
| 2008-08-07 09:50:00 | AAPL | Stock | 5.8461 | 5.8768 | 5.7679 | 5.8689 | 21115948.0 |
| 2008-08-07 09:55:00 | AAPL | Stock | 5.8696 | 5.8718 | 5.8321 | 5.8443 | 12158608.0 |
| 2008-08-07 10:00:00 | AAPL | Stock | 5.8464 | 5.8836 | 5.8433 | 5.8818 | 16363368.0 |
| 2008-08-07 10:05:00 | AAPL | Stock | 5.8811 | 5.8871 | 5.8614 | 5.8643 | 13061636.0 |
| 2008-08-07 10:10:00 | AAPL | Stock | 5.8643 | 5.8771 | 5.8529 | 5.8718 | 12582892.0 |
| 2008-08-07 10:15:00 | AAPL | Stock | 5.8714 | 5.8914 | 5.86 | 5.8893 | 14494648.0 |
| 2008-08-07 10:20:00 | AAPL | Stock | 5.8893 | 5.8929 | 5.8746 | 5.882 | 10561768.0 |
| 2008-08-07 10:25:00 | AAPL | Stock | 5.8825 | 5.8871 | 5.8696 | 5.88 | 6946352.0 |
| 2008-08-07 10:30:00 | AAPL | Stock | 5.8793 | 5.8793 | 5.8589 | 5.8743 | 9798600.0 |
| 2008-08-07 10:35:00 | AAPL | Stock | 5.8743 | 5.8754 | 5.8532 | 5.8643 | 8542072.0 |
| 2008-08-07 10:40:00 | AAPL | Stock | 5.8636 | 5.8686 | 5.855 | 5.8618 | 6912416.0 |
| 2008-08-07 10:45:00 | AAPL | Stock | 5.8611 | 5.8643 | 5.8286 | 5.8429 | 10225572.0 |
| 2008-08-07 10:50:00 | AAPL | Stock | 5.8429 | 5.8482 | 5.8311 | 5.8421 | 5640712.0 |
| 2008-08-07 10:55:00 | AAPL | Stock | 5.8407 | 5.8671 | 5.8407 | 5.8671 | 5950420.0 |
| 2008-08-07 11:00:00 | AAPL | Stock | 5.8675 | 5.8886 | 5.8636 | 5.8693 | 10892084.0 |
| 2008-08-07 11:05:00 | AAPL | Stock | 5.8695 | 5.8796 | 5.865 | 5.8775 | 4997160.0 |
| 2008-08-07 11:10:00 | AAPL | Stock | 5.8757 | 5.8854 | 5.8668 | 5.8671 | 4936736.0 |
| 2008-08-07 11:15:00 | AAPL | Stock | 5.8679 | 5.8707 | 5.8571 | 5.864 | 5435360.0 |
| 2008-08-07 11:20:00 | AAPL | Stock | 5.8644 | 5.8689 | 5.8468 | 5.8471 | 4298588.0 |
| 2008-08-07 11:25:00 | AAPL | Stock | 5.8479 | 5.8664 | 5.8464 | 5.8614 | 4239452.0 |
| 2008-08-07 11:30:00 | AAPL | Stock | 5.8629 | 5.8629 | 5.8471 | 5.8568 | 3349612.0 |
| 2008-08-07 11:35:00 | AAPL | Stock | 5.8561 | 5.8757 | 5.8518 | 5.8693 | 4106144.0 |
> showing 50 of 321,672 rows — these rows as CSV