PREVIEW / stock_5min / 2011-07-13
file: by_date/stock_5min/2011/2011-07-13.parquet size: 4.8 MB rows: 328,284 symbols: 3,534
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 |
|---|---|---|---|---|---|---|---|
| 2011-07-13 04:05:00 | AAPL | Stock | 12.7129 | 12.7132 | 12.6964 | 12.6964 | 14000.0 |
| 2011-07-13 04:35:00 | AAPL | Stock | 12.6964 | 12.6964 | 12.6964 | 12.6964 | 2800.0 |
| 2011-07-13 04:40:00 | AAPL | Stock | 12.6964 | 12.6964 | 12.6964 | 12.6964 | 11200.0 |
| 2011-07-13 04:50:00 | AAPL | Stock | 12.7018 | 12.7018 | 12.7018 | 12.7018 | 2800.0 |
| 2011-07-13 05:00:00 | AAPL | Stock | 12.7018 | 12.7018 | 12.7018 | 12.7018 | 2800.0 |
| 2011-07-13 05:35:00 | AAPL | Stock | 12.7125 | 12.7125 | 12.7125 | 12.7125 | 8400.0 |
| 2011-07-13 05:40:00 | AAPL | Stock | 12.7121 | 12.7129 | 12.7121 | 12.7129 | 5600.0 |
| 2011-07-13 05:45:00 | AAPL | Stock | 12.7225 | 12.7332 | 12.7225 | 12.7321 | 29400.0 |
| 2011-07-13 05:50:00 | AAPL | Stock | 12.7475 | 12.7475 | 12.7475 | 12.7475 | 2800.0 |
| 2011-07-13 06:10:00 | AAPL | Stock | 12.7179 | 12.7336 | 12.7179 | 12.7336 | 14560.0 |
| 2011-07-13 06:20:00 | AAPL | Stock | 12.7293 | 12.7293 | 12.7293 | 12.7293 | 2800.0 |
| 2011-07-13 06:35:00 | AAPL | Stock | 12.7257 | 12.7429 | 12.7257 | 12.7429 | 5600.0 |
| 2011-07-13 06:50:00 | AAPL | Stock | 12.7343 | 12.7357 | 12.7343 | 12.7357 | 5600.0 |
| 2011-07-13 06:55:00 | AAPL | Stock | 12.7214 | 12.725 | 12.7214 | 12.725 | 16800.0 |
| 2011-07-13 07:00:00 | AAPL | Stock | 12.7254 | 12.7321 | 12.725 | 12.7321 | 43680.0 |
| 2011-07-13 07:05:00 | AAPL | Stock | 12.7307 | 12.7379 | 12.7307 | 12.7379 | 38780.0 |
| 2011-07-13 07:10:00 | AAPL | Stock | 12.7289 | 12.7379 | 12.7268 | 12.7379 | 11200.0 |
| 2011-07-13 07:15:00 | AAPL | Stock | 12.7379 | 12.7643 | 12.7371 | 12.7607 | 84140.0 |
| 2011-07-13 07:20:00 | AAPL | Stock | 12.7621 | 12.7679 | 12.7571 | 12.7679 | 57484.0 |
| 2011-07-13 07:25:00 | AAPL | Stock | 12.7686 | 12.7686 | 12.7643 | 12.7646 | 22400.0 |
| 2011-07-13 07:30:00 | AAPL | Stock | 12.7707 | 12.7707 | 12.7679 | 12.7679 | 27944.0 |
| 2011-07-13 07:35:00 | AAPL | Stock | 12.7696 | 12.7696 | 12.7675 | 12.7675 | 14000.0 |
| 2011-07-13 07:40:00 | AAPL | Stock | 12.7679 | 12.77 | 12.7654 | 12.7675 | 57400.0 |
| 2011-07-13 07:45:00 | AAPL | Stock | 12.7711 | 12.8 | 12.7711 | 12.7839 | 89600.0 |
| 2011-07-13 07:50:00 | AAPL | Stock | 12.7821 | 12.7857 | 12.7679 | 12.7854 | 53480.0 |
| 2011-07-13 07:55:00 | AAPL | Stock | 12.7696 | 12.7768 | 12.7696 | 12.7768 | 20496.0 |
| 2011-07-13 08:00:00 | AAPL | Stock | 12.7707 | 12.7839 | 12.7504 | 12.7636 | 223048.0 |
| 2011-07-13 08:05:00 | AAPL | Stock | 12.755 | 12.7704 | 12.7546 | 12.7679 | 169568.0 |
| 2011-07-13 08:10:00 | AAPL | Stock | 12.7696 | 12.7804 | 12.7679 | 12.7725 | 263088.0 |
| 2011-07-13 08:15:00 | AAPL | Stock | 12.7725 | 12.7807 | 12.7679 | 12.7714 | 148540.0 |
| 2011-07-13 08:20:00 | AAPL | Stock | 12.7646 | 12.7711 | 12.7643 | 12.7657 | 136388.0 |
| 2011-07-13 08:25:00 | AAPL | Stock | 12.7657 | 12.7657 | 12.7536 | 12.7607 | 255976.0 |
| 2011-07-13 08:30:00 | AAPL | Stock | 12.7575 | 12.7661 | 12.75 | 12.7657 | 184016.0 |
| 2011-07-13 08:35:00 | AAPL | Stock | 12.7679 | 12.7714 | 12.75 | 12.75 | 132720.0 |
| 2011-07-13 08:40:00 | AAPL | Stock | 12.7504 | 12.7536 | 12.7443 | 12.7536 | 142128.0 |
| 2011-07-13 08:45:00 | AAPL | Stock | 12.7489 | 12.7768 | 12.7489 | 12.75 | 106960.0 |
| 2011-07-13 08:50:00 | AAPL | Stock | 12.7539 | 12.7593 | 12.7539 | 12.7539 | 14000.0 |
| 2011-07-13 08:55:00 | AAPL | Stock | 12.7543 | 12.7618 | 12.7464 | 12.7482 | 63196.0 |
| 2011-07-13 09:00:00 | AAPL | Stock | 12.75 | 12.75 | 12.7361 | 12.7425 | 114100.0 |
| 2011-07-13 09:05:00 | AAPL | Stock | 12.7471 | 12.7704 | 12.7471 | 12.7679 | 257460.0 |
| 2011-07-13 09:10:00 | AAPL | Stock | 12.7679 | 12.7786 | 12.7675 | 12.7679 | 245168.0 |
| 2011-07-13 09:15:00 | AAPL | Stock | 12.7696 | 12.7732 | 12.7661 | 12.7661 | 102844.0 |
| 2011-07-13 09:20:00 | AAPL | Stock | 12.7646 | 12.7646 | 12.7525 | 12.7525 | 151060.0 |
| 2011-07-13 09:25:00 | AAPL | Stock | 12.7554 | 12.7975 | 12.7507 | 12.7975 | 1025164.0 |
| 2011-07-13 09:30:00 | AAPL | Stock | 12.7975 | 12.8121 | 12.7582 | 12.8089 | 22386504.0 |
| 2011-07-13 09:35:00 | AAPL | Stock | 12.8093 | 12.8189 | 12.7729 | 12.7929 | 10822084.0 |
| 2011-07-13 09:40:00 | AAPL | Stock | 12.7907 | 12.8161 | 12.7907 | 12.8043 | 10542868.0 |
| 2011-07-13 09:45:00 | AAPL | Stock | 12.8054 | 12.8354 | 12.7961 | 12.8089 | 14513212.0 |
| 2011-07-13 09:50:00 | AAPL | Stock | 12.8057 | 12.8096 | 12.7779 | 12.7818 | 11547564.0 |
| 2011-07-13 09:55:00 | AAPL | Stock | 12.7814 | 12.7904 | 12.7596 | 12.7725 | 7105868.0 |
> showing 50 of 328,284 rows — these rows as CSV