PREVIEW / stock_5min / 2011-01-24
file: by_date/stock_5min/2011/2011-01-24.parquet size: 4.9 MB rows: 333,974 symbols: 3,538
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-01-24 04:10:00 | AAPL | Stock | 11.7218 | 11.7229 | 11.7218 | 11.7229 | 5600.0 |
| 2011-01-24 04:30:00 | AAPL | Stock | 11.7136 | 11.7136 | 11.7136 | 11.7136 | 2800.0 |
| 2011-01-24 04:45:00 | AAPL | Stock | 11.7136 | 11.7136 | 11.7136 | 11.7136 | 2800.0 |
| 2011-01-24 05:50:00 | AAPL | Stock | 11.7214 | 11.7214 | 11.7214 | 11.7214 | 2800.0 |
| 2011-01-24 05:55:00 | AAPL | Stock | 11.6982 | 11.6982 | 11.6786 | 11.6786 | 27944.0 |
| 2011-01-24 06:05:00 | AAPL | Stock | 11.7179 | 11.7179 | 11.7179 | 11.7179 | 8400.0 |
| 2011-01-24 06:10:00 | AAPL | Stock | 11.725 | 11.7321 | 11.725 | 11.7321 | 14000.0 |
| 2011-01-24 06:15:00 | AAPL | Stock | 11.725 | 11.7282 | 11.725 | 11.7282 | 11200.0 |
| 2011-01-24 06:20:00 | AAPL | Stock | 11.7375 | 11.7393 | 11.7375 | 11.7393 | 14000.0 |
| 2011-01-24 06:25:00 | AAPL | Stock | 11.725 | 11.725 | 11.725 | 11.725 | 5600.0 |
| 2011-01-24 06:30:00 | AAPL | Stock | 11.725 | 11.725 | 11.725 | 11.725 | 5600.0 |
| 2011-01-24 07:00:00 | AAPL | Stock | 11.7321 | 11.7325 | 11.7021 | 11.7021 | 208600.0 |
| 2011-01-24 07:05:00 | AAPL | Stock | 11.7054 | 11.7143 | 11.7046 | 11.7143 | 48020.0 |
| 2011-01-24 07:10:00 | AAPL | Stock | 11.7121 | 11.7143 | 11.7121 | 11.7143 | 14980.0 |
| 2011-01-24 07:20:00 | AAPL | Stock | 11.7139 | 11.7139 | 11.7139 | 11.7139 | 5600.0 |
| 2011-01-24 07:25:00 | AAPL | Stock | 11.7046 | 11.7143 | 11.7 | 11.7 | 112420.0 |
| 2011-01-24 07:30:00 | AAPL | Stock | 11.7 | 11.7 | 11.7 | 11.7 | 2800.0 |
| 2011-01-24 07:35:00 | AAPL | Stock | 11.7089 | 11.7139 | 11.6964 | 11.7139 | 98980.0 |
| 2011-01-24 07:40:00 | AAPL | Stock | 11.705 | 11.7171 | 11.705 | 11.715 | 58800.0 |
| 2011-01-24 07:45:00 | AAPL | Stock | 11.7146 | 11.7146 | 11.7143 | 11.7143 | 16800.0 |
| 2011-01-24 07:50:00 | AAPL | Stock | 11.7057 | 11.7136 | 11.7054 | 11.7132 | 26040.0 |
| 2011-01-24 07:55:00 | AAPL | Stock | 11.7054 | 11.7157 | 11.7054 | 11.7157 | 5600.0 |
| 2011-01-24 08:00:00 | AAPL | Stock | 11.7143 | 11.7161 | 11.6893 | 11.6964 | 456904.0 |
| 2011-01-24 08:05:00 | AAPL | Stock | 11.6968 | 11.6968 | 11.6782 | 11.6875 | 333004.0 |
| 2011-01-24 08:10:00 | AAPL | Stock | 11.6925 | 11.6964 | 11.6868 | 11.6954 | 190736.0 |
| 2011-01-24 08:15:00 | AAPL | Stock | 11.6961 | 11.7043 | 11.6961 | 11.7036 | 44380.0 |
| 2011-01-24 08:20:00 | AAPL | Stock | 11.7018 | 11.7036 | 11.7 | 11.7 | 156520.0 |
| 2011-01-24 08:25:00 | AAPL | Stock | 11.7 | 11.7007 | 11.6964 | 11.7007 | 77140.0 |
| 2011-01-24 08:30:00 | AAPL | Stock | 11.7029 | 11.7104 | 11.6996 | 11.7104 | 198296.0 |
| 2011-01-24 08:35:00 | AAPL | Stock | 11.7089 | 11.7093 | 11.7018 | 11.7018 | 120400.0 |
| 2011-01-24 08:40:00 | AAPL | Stock | 11.7036 | 11.7071 | 11.7 | 11.7054 | 205380.0 |
| 2011-01-24 08:45:00 | AAPL | Stock | 11.7079 | 11.7104 | 11.7046 | 11.7079 | 328972.0 |
| 2011-01-24 08:50:00 | AAPL | Stock | 11.7064 | 11.7086 | 11.7018 | 11.7046 | 87780.0 |
| 2011-01-24 08:55:00 | AAPL | Stock | 11.7036 | 11.7046 | 11.7018 | 11.7036 | 109480.0 |
| 2011-01-24 09:00:00 | AAPL | Stock | 11.7036 | 11.7054 | 11.7018 | 11.7054 | 113120.0 |
| 2011-01-24 09:05:00 | AAPL | Stock | 11.7032 | 11.7054 | 11.7018 | 11.7018 | 272608.0 |
| 2011-01-24 09:10:00 | AAPL | Stock | 11.7018 | 11.7036 | 11.6982 | 11.6989 | 249592.0 |
| 2011-01-24 09:15:00 | AAPL | Stock | 11.6989 | 11.7025 | 11.6979 | 11.7025 | 116732.0 |
| 2011-01-24 09:20:00 | AAPL | Stock | 11.7021 | 11.7021 | 11.6964 | 11.6964 | 213780.0 |
| 2011-01-24 09:25:00 | AAPL | Stock | 11.6986 | 11.7089 | 11.6725 | 11.6739 | 771988.0 |
| 2011-01-24 09:30:00 | AAPL | Stock | 11.6729 | 11.775 | 11.6686 | 11.7686 | 23580480.0 |
| 2011-01-24 09:35:00 | AAPL | Stock | 11.7686 | 11.8529 | 11.7686 | 11.8215 | 29995672.0 |
| 2011-01-24 09:40:00 | AAPL | Stock | 11.8218 | 11.8286 | 11.8004 | 11.8007 | 19009396.0 |
| 2011-01-24 09:45:00 | AAPL | Stock | 11.8004 | 11.8471 | 11.7936 | 11.8332 | 16651600.0 |
| 2011-01-24 09:50:00 | AAPL | Stock | 11.8343 | 11.8482 | 11.8193 | 11.8227 | 11896640.0 |
| 2011-01-24 09:55:00 | AAPL | Stock | 11.825 | 11.8257 | 11.7893 | 11.7936 | 14658140.0 |
| 2011-01-24 10:00:00 | AAPL | Stock | 11.7954 | 11.8079 | 11.7625 | 11.7929 | 12745684.0 |
| 2011-01-24 10:05:00 | AAPL | Stock | 11.7929 | 11.8246 | 11.7904 | 11.8121 | 9926420.0 |
| 2011-01-24 10:10:00 | AAPL | Stock | 11.8114 | 11.836 | 11.8082 | 11.8139 | 7698852.0 |
| 2011-01-24 10:15:00 | AAPL | Stock | 11.8139 | 11.8175 | 11.795 | 11.8057 | 6882652.0 |
> showing 50 of 333,974 rows — these rows as CSV