PREVIEW / stock_5min / 2007-11-13
file: by_date/stock_5min/2007/2007-11-13.parquet size: 4.4 MB rows: 320,416 symbols: 3,197
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 |
|---|---|---|---|---|---|---|---|
| 2007-11-13 04:40:00 | AAPL | Stock | 5.5107 | 5.5107 | 5.5107 | 5.5107 | 14000.0 |
| 2007-11-13 05:10:00 | AAPL | Stock | 5.5143 | 5.525 | 5.5143 | 5.525 | 28000.0 |
| 2007-11-13 05:45:00 | AAPL | Stock | 5.5168 | 5.5168 | 5.5168 | 5.5168 | 5600.0 |
| 2007-11-13 05:50:00 | AAPL | Stock | 5.5275 | 5.5275 | 5.5275 | 5.5275 | 11200.0 |
| 2007-11-13 05:55:00 | AAPL | Stock | 5.5264 | 5.5264 | 5.5179 | 5.5179 | 11200.0 |
| 2007-11-13 06:00:00 | AAPL | Stock | 5.5179 | 5.5357 | 5.5179 | 5.5357 | 27272.0 |
| 2007-11-13 06:05:00 | AAPL | Stock | 5.5532 | 5.5536 | 5.5504 | 5.5504 | 73528.0 |
| 2007-11-13 06:10:00 | AAPL | Stock | 5.5493 | 5.5493 | 5.5357 | 5.5357 | 14000.0 |
| 2007-11-13 06:25:00 | AAPL | Stock | 5.5643 | 5.5643 | 5.55 | 5.55 | 8680.0 |
| 2007-11-13 06:30:00 | AAPL | Stock | 5.5714 | 5.5729 | 5.5714 | 5.5729 | 19600.0 |
| 2007-11-13 06:35:00 | AAPL | Stock | 5.5857 | 5.5857 | 5.5857 | 5.5857 | 5600.0 |
| 2007-11-13 06:40:00 | AAPL | Stock | 5.5893 | 5.5893 | 5.5893 | 5.5893 | 36400.0 |
| 2007-11-13 06:45:00 | AAPL | Stock | 5.5893 | 5.6039 | 5.5893 | 5.6039 | 23100.0 |
| 2007-11-13 06:50:00 | AAPL | Stock | 5.6071 | 5.6071 | 5.5764 | 5.5764 | 22092.0 |
| 2007-11-13 06:55:00 | AAPL | Stock | 5.5764 | 5.5986 | 5.5764 | 5.5986 | 8400.0 |
| 2007-11-13 07:00:00 | AAPL | Stock | 5.5714 | 5.5714 | 5.5679 | 5.5679 | 14700.0 |
| 2007-11-13 07:05:00 | AAPL | Stock | 5.5875 | 5.595 | 5.5804 | 5.595 | 46508.0 |
| 2007-11-13 07:10:00 | AAPL | Stock | 5.5868 | 5.5954 | 5.5868 | 5.5875 | 37800.0 |
| 2007-11-13 07:15:00 | AAPL | Stock | 5.5875 | 5.5982 | 5.5821 | 5.5982 | 74816.0 |
| 2007-11-13 07:20:00 | AAPL | Stock | 5.5979 | 5.6021 | 5.5979 | 5.6021 | 31948.0 |
| 2007-11-13 07:25:00 | AAPL | Stock | 5.6011 | 5.6011 | 5.5732 | 5.5939 | 200256.0 |
| 2007-11-13 07:30:00 | AAPL | Stock | 5.5861 | 5.6204 | 5.5839 | 5.6204 | 254520.0 |
| 2007-11-13 07:35:00 | AAPL | Stock | 5.6229 | 5.6507 | 5.6193 | 5.6429 | 1261960.0 |
| 2007-11-13 07:40:00 | AAPL | Stock | 5.6429 | 5.6518 | 5.6161 | 5.6339 | 350252.0 |
| 2007-11-13 07:45:00 | AAPL | Stock | 5.6339 | 5.6429 | 5.6179 | 5.6268 | 112476.0 |
| 2007-11-13 07:50:00 | AAPL | Stock | 5.6186 | 5.625 | 5.6179 | 5.6221 | 38724.0 |
| 2007-11-13 07:55:00 | AAPL | Stock | 5.6204 | 5.6429 | 5.6071 | 5.6429 | 599788.0 |
| 2007-11-13 08:00:00 | AAPL | Stock | 5.6429 | 5.6782 | 5.6214 | 5.6429 | 3682196.0 |
| 2007-11-13 08:05:00 | AAPL | Stock | 5.6375 | 5.6732 | 5.6361 | 5.6643 | 1913492.0 |
| 2007-11-13 08:10:00 | AAPL | Stock | 5.6646 | 5.6857 | 5.6575 | 5.6857 | 2245096.0 |
| 2007-11-13 08:15:00 | AAPL | Stock | 5.6786 | 5.7143 | 5.6696 | 5.7125 | 3378172.0 |
| 2007-11-13 08:20:00 | AAPL | Stock | 5.7125 | 5.7143 | 5.6875 | 5.69 | 2940112.0 |
| 2007-11-13 08:25:00 | AAPL | Stock | 5.6893 | 5.7029 | 5.6786 | 5.7025 | 3067484.0 |
| 2007-11-13 08:30:00 | AAPL | Stock | 5.7004 | 5.7143 | 5.6946 | 5.7075 | 2258032.0 |
| 2007-11-13 08:35:00 | AAPL | Stock | 5.7071 | 5.725 | 5.7032 | 5.7186 | 3093076.0 |
| 2007-11-13 08:40:00 | AAPL | Stock | 5.7164 | 5.7318 | 5.7129 | 5.7318 | 4086572.0 |
| 2007-11-13 08:45:00 | AAPL | Stock | 5.7318 | 5.7371 | 5.7143 | 5.7336 | 1758736.0 |
| 2007-11-13 08:50:00 | AAPL | Stock | 5.7336 | 5.735 | 5.7232 | 5.73 | 1201200.0 |
| 2007-11-13 08:55:00 | AAPL | Stock | 5.7314 | 5.75 | 5.7168 | 5.7454 | 2501548.0 |
| 2007-11-13 09:00:00 | AAPL | Stock | 5.7468 | 5.7529 | 5.7271 | 5.7529 | 1828764.0 |
| 2007-11-13 09:05:00 | AAPL | Stock | 5.7529 | 5.7639 | 5.7443 | 5.7529 | 3681020.0 |
| 2007-11-13 09:10:00 | AAPL | Stock | 5.7511 | 5.7586 | 5.7432 | 5.7536 | 2906204.0 |
| 2007-11-13 09:15:00 | AAPL | Stock | 5.7536 | 5.7564 | 5.7361 | 5.7464 | 1802976.0 |
| 2007-11-13 09:20:00 | AAPL | Stock | 5.7464 | 5.7564 | 5.7339 | 5.7339 | 1693776.0 |
| 2007-11-13 09:25:00 | AAPL | Stock | 5.7339 | 5.7454 | 5.7236 | 5.745 | 2384536.0 |
| 2007-11-13 09:30:00 | AAPL | Stock | 5.7454 | 5.7782 | 5.7193 | 5.7689 | 80488184.0 |
| 2007-11-13 09:35:00 | AAPL | Stock | 5.7689 | 5.8214 | 5.7643 | 5.8036 | 49713272.0 |
| 2007-11-13 09:40:00 | AAPL | Stock | 5.8025 | 5.8096 | 5.7739 | 5.7817 | 42986636.0 |
| 2007-11-13 09:45:00 | AAPL | Stock | 5.7829 | 5.7951 | 5.7657 | 5.7893 | 35659932.0 |
| 2007-11-13 09:50:00 | AAPL | Stock | 5.7893 | 5.8 | 5.7632 | 5.7893 | 34476176.0 |
> showing 50 of 320,416 rows — these rows as CSV