PREVIEW / stock_5min / 2009-10-19
file: by_date/stock_5min/2009/2009-10-19.parquet size: 4.7 MB rows: 318,539 symbols: 3,406
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 |
|---|---|---|---|---|---|---|---|
| 2009-10-19 04:15:00 | AAPL | Stock | 6.7429 | 6.7607 | 6.7379 | 6.7379 | 39536.0 |
| 2009-10-19 04:20:00 | AAPL | Stock | 6.7393 | 6.7393 | 6.7254 | 6.7282 | 65436.0 |
| 2009-10-19 05:20:00 | AAPL | Stock | 6.7496 | 6.7496 | 6.7493 | 6.7493 | 5600.0 |
| 2009-10-19 05:25:00 | AAPL | Stock | 6.7379 | 6.7379 | 6.7379 | 6.7379 | 19600.0 |
| 2009-10-19 05:50:00 | AAPL | Stock | 6.7286 | 6.7286 | 6.7286 | 6.7286 | 5600.0 |
| 2009-10-19 06:05:00 | AAPL | Stock | 6.7279 | 6.7421 | 6.7279 | 6.7421 | 102144.0 |
| 2009-10-19 06:15:00 | AAPL | Stock | 6.725 | 6.725 | 6.725 | 6.725 | 19320.0 |
| 2009-10-19 06:25:00 | AAPL | Stock | 6.7414 | 6.7429 | 6.7414 | 6.7429 | 18200.0 |
| 2009-10-19 06:35:00 | AAPL | Stock | 6.7357 | 6.7357 | 6.7357 | 6.7357 | 5600.0 |
| 2009-10-19 06:40:00 | AAPL | Stock | 6.7357 | 6.7357 | 6.7357 | 6.7357 | 2800.0 |
| 2009-10-19 06:50:00 | AAPL | Stock | 6.7407 | 6.7411 | 6.7321 | 6.7321 | 36400.0 |
| 2009-10-19 07:00:00 | AAPL | Stock | 6.7329 | 6.7464 | 6.7329 | 6.7411 | 16100.0 |
| 2009-10-19 07:05:00 | AAPL | Stock | 6.7493 | 6.75 | 6.7429 | 6.7429 | 349580.0 |
| 2009-10-19 07:10:00 | AAPL | Stock | 6.7464 | 6.7464 | 6.7429 | 6.7446 | 47264.0 |
| 2009-10-19 07:15:00 | AAPL | Stock | 6.7429 | 6.7429 | 6.7361 | 6.7361 | 43484.0 |
| 2009-10-19 07:25:00 | AAPL | Stock | 6.7429 | 6.7429 | 6.7321 | 6.7321 | 88900.0 |
| 2009-10-19 07:30:00 | AAPL | Stock | 6.7411 | 6.7411 | 6.7307 | 6.7357 | 81480.0 |
| 2009-10-19 07:35:00 | AAPL | Stock | 6.7304 | 6.7357 | 6.7304 | 6.7357 | 21000.0 |
| 2009-10-19 07:40:00 | AAPL | Stock | 6.7357 | 6.7357 | 6.7279 | 6.7279 | 100800.0 |
| 2009-10-19 07:45:00 | AAPL | Stock | 6.725 | 6.7321 | 6.725 | 6.7321 | 78400.0 |
| 2009-10-19 07:50:00 | AAPL | Stock | 6.7321 | 6.7321 | 6.725 | 6.7321 | 44968.0 |
| 2009-10-19 07:55:00 | AAPL | Stock | 6.7314 | 6.7321 | 6.7179 | 6.7179 | 37968.0 |
| 2009-10-19 08:00:00 | AAPL | Stock | 6.7286 | 6.7321 | 6.7143 | 6.7146 | 584864.0 |
| 2009-10-19 08:05:00 | AAPL | Stock | 6.7161 | 6.7161 | 6.6861 | 6.6925 | 866460.0 |
| 2009-10-19 08:10:00 | AAPL | Stock | 6.6893 | 6.6964 | 6.6893 | 6.6954 | 237468.0 |
| 2009-10-19 08:15:00 | AAPL | Stock | 6.6832 | 6.6939 | 6.6821 | 6.6857 | 400932.0 |
| 2009-10-19 08:20:00 | AAPL | Stock | 6.6857 | 6.6943 | 6.6857 | 6.6943 | 42280.0 |
| 2009-10-19 08:25:00 | AAPL | Stock | 6.6943 | 6.7214 | 6.6921 | 6.7125 | 670376.0 |
| 2009-10-19 08:30:00 | AAPL | Stock | 6.7161 | 6.7161 | 6.7107 | 6.7143 | 108164.0 |
| 2009-10-19 08:35:00 | AAPL | Stock | 6.7179 | 6.7218 | 6.7154 | 6.7164 | 367696.0 |
| 2009-10-19 08:40:00 | AAPL | Stock | 6.7161 | 6.7186 | 6.7107 | 6.7107 | 232568.0 |
| 2009-10-19 08:45:00 | AAPL | Stock | 6.7118 | 6.7125 | 6.7057 | 6.7082 | 125636.0 |
| 2009-10-19 08:50:00 | AAPL | Stock | 6.7057 | 6.71 | 6.705 | 6.7096 | 248724.0 |
| 2009-10-19 08:55:00 | AAPL | Stock | 6.7089 | 6.7143 | 6.7089 | 6.7143 | 99064.0 |
| 2009-10-19 09:00:00 | AAPL | Stock | 6.7143 | 6.7143 | 6.7079 | 6.7143 | 267036.0 |
| 2009-10-19 09:05:00 | AAPL | Stock | 6.7143 | 6.7143 | 6.7061 | 6.7118 | 130816.0 |
| 2009-10-19 09:10:00 | AAPL | Stock | 6.7096 | 6.71 | 6.7004 | 6.7036 | 180068.0 |
| 2009-10-19 09:15:00 | AAPL | Stock | 6.7011 | 6.71 | 6.7 | 6.7054 | 169624.0 |
| 2009-10-19 09:20:00 | AAPL | Stock | 6.7054 | 6.7107 | 6.7018 | 6.7089 | 329392.0 |
| 2009-10-19 09:25:00 | AAPL | Stock | 6.7107 | 6.7107 | 6.7068 | 6.7089 | 226800.0 |
| 2009-10-19 09:30:00 | AAPL | Stock | 6.7089 | 6.71 | 6.6268 | 6.6639 | 39160688.0 |
| 2009-10-19 09:35:00 | AAPL | Stock | 6.6636 | 6.6929 | 6.6636 | 6.6914 | 16863392.0 |
| 2009-10-19 09:40:00 | AAPL | Stock | 6.6924 | 6.6964 | 6.6721 | 6.6746 | 14512176.0 |
| 2009-10-19 09:45:00 | AAPL | Stock | 6.675 | 6.6911 | 6.6714 | 6.6818 | 10257128.0 |
| 2009-10-19 09:50:00 | AAPL | Stock | 6.6807 | 6.6818 | 6.6607 | 6.6607 | 10130456.0 |
| 2009-10-19 09:55:00 | AAPL | Stock | 6.6611 | 6.6711 | 6.6575 | 6.6604 | 8629712.0 |
| 2009-10-19 10:00:00 | AAPL | Stock | 6.6596 | 6.6607 | 6.645 | 6.6571 | 10818388.0 |
| 2009-10-19 10:05:00 | AAPL | Stock | 6.6575 | 6.6736 | 6.6561 | 6.6718 | 8311380.0 |
| 2009-10-19 10:10:00 | AAPL | Stock | 6.6718 | 6.6786 | 6.6668 | 6.6707 | 6455316.0 |
| 2009-10-19 10:15:00 | AAPL | Stock | 6.6707 | 6.6768 | 6.6664 | 6.6664 | 5118260.0 |
> showing 50 of 318,539 rows — these rows as CSV