PREVIEW / stock_5min / 2011-09-07
file: by_date/stock_5min/2011/2011-09-07.parquet size: 4.9 MB rows: 333,084 symbols: 3,513
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-09-07 04:00:00 | AAPL | Stock | 13.6496 | 13.6496 | 13.6496 | 13.6496 | 2800.0 |
| 2011-09-07 04:05:00 | AAPL | Stock | 13.6429 | 13.6429 | 13.6429 | 13.6429 | 5600.0 |
| 2011-09-07 04:10:00 | AAPL | Stock | 13.6961 | 13.6964 | 13.6496 | 13.6964 | 28000.0 |
| 2011-09-07 04:15:00 | AAPL | Stock | 13.6854 | 13.6893 | 13.6714 | 13.6893 | 14280.0 |
| 2011-09-07 04:20:00 | AAPL | Stock | 13.65 | 13.6504 | 13.65 | 13.6504 | 5600.0 |
| 2011-09-07 04:25:00 | AAPL | Stock | 13.6429 | 13.6429 | 13.6429 | 13.6429 | 2800.0 |
| 2011-09-07 04:30:00 | AAPL | Stock | 13.6732 | 13.6732 | 13.6732 | 13.6732 | 2800.0 |
| 2011-09-07 04:50:00 | AAPL | Stock | 13.6607 | 13.6607 | 13.6607 | 13.6607 | 5600.0 |
| 2011-09-07 05:10:00 | AAPL | Stock | 13.6679 | 13.6679 | 13.6679 | 13.6679 | 2800.0 |
| 2011-09-07 05:15:00 | AAPL | Stock | 13.6607 | 13.6607 | 13.6607 | 13.6607 | 2800.0 |
| 2011-09-07 05:30:00 | AAPL | Stock | 13.6536 | 13.6536 | 13.6432 | 13.6432 | 25200.0 |
| 2011-09-07 05:35:00 | AAPL | Stock | 13.6436 | 13.6436 | 13.6436 | 13.6436 | 8400.0 |
| 2011-09-07 06:00:00 | AAPL | Stock | 13.6429 | 13.6429 | 13.6429 | 13.6429 | 2800.0 |
| 2011-09-07 06:20:00 | AAPL | Stock | 13.6446 | 13.6446 | 13.6446 | 13.6446 | 5600.0 |
| 2011-09-07 06:35:00 | AAPL | Stock | 13.6518 | 13.6518 | 13.6518 | 13.6518 | 7336.0 |
| 2011-09-07 06:40:00 | AAPL | Stock | 13.6482 | 13.6482 | 13.6482 | 13.6482 | 2800.0 |
| 2011-09-07 06:45:00 | AAPL | Stock | 13.6614 | 13.6614 | 13.6614 | 13.6614 | 11200.0 |
| 2011-09-07 06:50:00 | AAPL | Stock | 13.6607 | 13.6607 | 13.6607 | 13.6607 | 22400.0 |
| 2011-09-07 07:00:00 | AAPL | Stock | 13.675 | 13.71 | 13.675 | 13.7043 | 68180.0 |
| 2011-09-07 07:05:00 | AAPL | Stock | 13.7096 | 13.7096 | 13.6868 | 13.6868 | 32200.0 |
| 2011-09-07 07:10:00 | AAPL | Stock | 13.6843 | 13.695 | 13.6793 | 13.695 | 122584.0 |
| 2011-09-07 07:15:00 | AAPL | Stock | 13.6911 | 13.6946 | 13.6857 | 13.69 | 50400.0 |
| 2011-09-07 07:20:00 | AAPL | Stock | 13.6871 | 13.6964 | 13.6768 | 13.6768 | 96320.0 |
| 2011-09-07 07:25:00 | AAPL | Stock | 13.6739 | 13.6786 | 13.6739 | 13.6786 | 29876.0 |
| 2011-09-07 07:30:00 | AAPL | Stock | 13.6786 | 13.6893 | 13.6786 | 13.6893 | 94304.0 |
| 2011-09-07 07:35:00 | AAPL | Stock | 13.6893 | 13.7043 | 13.6875 | 13.6929 | 122780.0 |
| 2011-09-07 07:40:00 | AAPL | Stock | 13.6943 | 13.6975 | 13.6907 | 13.6975 | 28000.0 |
| 2011-09-07 07:45:00 | AAPL | Stock | 13.6964 | 13.6968 | 13.6929 | 13.6946 | 56000.0 |
| 2011-09-07 07:50:00 | AAPL | Stock | 13.6929 | 13.7 | 13.6875 | 13.6875 | 168700.0 |
| 2011-09-07 07:55:00 | AAPL | Stock | 13.6857 | 13.6896 | 13.6821 | 13.6825 | 54600.0 |
| 2011-09-07 08:00:00 | AAPL | Stock | 13.6868 | 13.705 | 13.6696 | 13.7046 | 684852.0 |
| 2011-09-07 08:05:00 | AAPL | Stock | 13.7011 | 13.7079 | 13.6875 | 13.6875 | 478268.0 |
| 2011-09-07 08:10:00 | AAPL | Stock | 13.6911 | 13.7064 | 13.6911 | 13.7025 | 158144.0 |
| 2011-09-07 08:15:00 | AAPL | Stock | 13.7018 | 13.7057 | 13.6961 | 13.7057 | 39620.0 |
| 2011-09-07 08:20:00 | AAPL | Stock | 13.6979 | 13.7036 | 13.6875 | 13.7036 | 177072.0 |
| 2011-09-07 08:25:00 | AAPL | Stock | 13.7 | 13.7054 | 13.6986 | 13.7032 | 135576.0 |
| 2011-09-07 08:30:00 | AAPL | Stock | 13.7046 | 13.7093 | 13.7011 | 13.7043 | 159432.0 |
| 2011-09-07 08:35:00 | AAPL | Stock | 13.7004 | 13.715 | 13.6996 | 13.715 | 244356.0 |
| 2011-09-07 08:40:00 | AAPL | Stock | 13.7179 | 13.7354 | 13.7146 | 13.7164 | 381500.0 |
| 2011-09-07 08:45:00 | AAPL | Stock | 13.7168 | 13.73 | 13.7168 | 13.73 | 395164.0 |
| 2011-09-07 08:50:00 | AAPL | Stock | 13.73 | 13.7407 | 13.7275 | 13.7336 | 533596.0 |
| 2011-09-07 08:55:00 | AAPL | Stock | 13.7332 | 13.7664 | 13.7321 | 13.7536 | 667632.0 |
| 2011-09-07 09:00:00 | AAPL | Stock | 13.7507 | 13.7611 | 13.7507 | 13.7579 | 423220.0 |
| 2011-09-07 09:05:00 | AAPL | Stock | 13.7571 | 13.7675 | 13.7521 | 13.7643 | 747628.0 |
| 2011-09-07 09:10:00 | AAPL | Stock | 13.7629 | 13.7679 | 13.7607 | 13.7607 | 469952.0 |
| 2011-09-07 09:15:00 | AAPL | Stock | 13.7607 | 13.7646 | 13.7546 | 13.7618 | 673540.0 |
| 2011-09-07 09:20:00 | AAPL | Stock | 13.76 | 13.7682 | 13.7589 | 13.7589 | 240996.0 |
| 2011-09-07 09:25:00 | AAPL | Stock | 13.7607 | 13.7768 | 13.7575 | 13.77 | 933884.0 |
| 2011-09-07 09:30:00 | AAPL | Stock | 13.7707 | 13.7714 | 13.7229 | 13.7371 | 17324160.0 |
| 2011-09-07 09:35:00 | AAPL | Stock | 13.735 | 13.7504 | 13.7286 | 13.7323 | 10843812.0 |
> showing 50 of 333,084 rows — these rows as CSV