PREVIEW / stock_5min / 2011-06-17
file: by_date/stock_5min/2011/2011-06-17.parquet size: 5.0 MB rows: 341,848 symbols: 3,578
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-06-17 06:00:00 | AAPL | Stock | 11.65 | 11.65 | 11.65 | 11.65 | 2800.0 |
| 2011-06-17 06:30:00 | AAPL | Stock | 11.6982 | 11.7039 | 11.6982 | 11.7039 | 8400.0 |
| 2011-06-17 06:35:00 | AAPL | Stock | 11.6964 | 11.6964 | 11.6964 | 11.6964 | 5600.0 |
| 2011-06-17 06:40:00 | AAPL | Stock | 11.6914 | 11.6964 | 11.6914 | 11.6964 | 5600.0 |
| 2011-06-17 06:55:00 | AAPL | Stock | 11.6964 | 11.7057 | 11.685 | 11.695 | 81200.0 |
| 2011-06-17 07:00:00 | AAPL | Stock | 11.6946 | 11.7143 | 11.6946 | 11.7125 | 142800.0 |
| 2011-06-17 07:05:00 | AAPL | Stock | 11.7139 | 11.7143 | 11.7071 | 11.7071 | 16800.0 |
| 2011-06-17 07:10:00 | AAPL | Stock | 11.7089 | 11.7089 | 11.7089 | 11.7089 | 5600.0 |
| 2011-06-17 07:15:00 | AAPL | Stock | 11.7136 | 11.7136 | 11.7 | 11.7018 | 23688.0 |
| 2011-06-17 07:20:00 | AAPL | Stock | 11.7032 | 11.7032 | 11.7029 | 11.7032 | 16800.0 |
| 2011-06-17 07:25:00 | AAPL | Stock | 11.7104 | 11.7121 | 11.7025 | 11.7089 | 39200.0 |
| 2011-06-17 07:30:00 | AAPL | Stock | 11.7121 | 11.7254 | 11.7121 | 11.7146 | 60200.0 |
| 2011-06-17 07:35:00 | AAPL | Stock | 11.7179 | 11.7232 | 11.7129 | 11.7129 | 46760.0 |
| 2011-06-17 07:40:00 | AAPL | Stock | 11.7107 | 11.7143 | 11.7107 | 11.7143 | 11200.0 |
| 2011-06-17 07:45:00 | AAPL | Stock | 11.715 | 11.7154 | 11.7143 | 11.7143 | 41020.0 |
| 2011-06-17 07:50:00 | AAPL | Stock | 11.7107 | 11.725 | 11.7107 | 11.725 | 60592.0 |
| 2011-06-17 07:55:00 | AAPL | Stock | 11.7354 | 11.7379 | 11.7318 | 11.7321 | 44800.0 |
| 2011-06-17 08:00:00 | AAPL | Stock | 11.73 | 11.73 | 11.7171 | 11.7261 | 153776.0 |
| 2011-06-17 08:05:00 | AAPL | Stock | 11.7057 | 11.7286 | 11.7057 | 11.7236 | 190036.0 |
| 2011-06-17 08:10:00 | AAPL | Stock | 11.7229 | 11.7282 | 11.7168 | 11.7168 | 131040.0 |
| 2011-06-17 08:15:00 | AAPL | Stock | 11.7189 | 11.7207 | 11.7143 | 11.7204 | 157696.0 |
| 2011-06-17 08:20:00 | AAPL | Stock | 11.7186 | 11.7207 | 11.7107 | 11.7107 | 160608.0 |
| 2011-06-17 08:25:00 | AAPL | Stock | 11.7093 | 11.7093 | 11.7004 | 11.7054 | 211064.0 |
| 2011-06-17 08:30:00 | AAPL | Stock | 11.7071 | 11.7071 | 11.6879 | 11.7054 | 196728.0 |
| 2011-06-17 08:35:00 | AAPL | Stock | 11.7036 | 11.7054 | 11.6896 | 11.6929 | 70896.0 |
| 2011-06-17 08:40:00 | AAPL | Stock | 11.6929 | 11.7 | 11.6929 | 11.6929 | 44716.0 |
| 2011-06-17 08:45:00 | AAPL | Stock | 11.6904 | 11.7021 | 11.6904 | 11.6982 | 131348.0 |
| 2011-06-17 08:50:00 | AAPL | Stock | 11.6986 | 11.7071 | 11.6986 | 11.7071 | 52416.0 |
| 2011-06-17 08:55:00 | AAPL | Stock | 11.7089 | 11.7107 | 11.7043 | 11.7096 | 28000.0 |
| 2011-06-17 09:00:00 | AAPL | Stock | 11.7107 | 11.7107 | 11.7018 | 11.7018 | 44800.0 |
| 2011-06-17 09:05:00 | AAPL | Stock | 11.7021 | 11.7036 | 11.6971 | 11.7004 | 61600.0 |
| 2011-06-17 09:10:00 | AAPL | Stock | 11.7018 | 11.7068 | 11.6964 | 11.7007 | 296800.0 |
| 2011-06-17 09:15:00 | AAPL | Stock | 11.7007 | 11.7029 | 11.6975 | 11.7 | 94472.0 |
| 2011-06-17 09:20:00 | AAPL | Stock | 11.7025 | 11.7057 | 11.7025 | 11.7057 | 106680.0 |
| 2011-06-17 09:25:00 | AAPL | Stock | 11.7057 | 11.7582 | 11.7036 | 11.755 | 2033584.0 |
| 2011-06-17 09:30:00 | AAPL | Stock | 11.7496 | 11.7589 | 11.6611 | 11.6625 | 18764816.0 |
| 2011-06-17 09:35:00 | AAPL | Stock | 11.6611 | 11.6861 | 11.6536 | 11.6579 | 12925948.0 |
| 2011-06-17 09:40:00 | AAPL | Stock | 11.6571 | 11.6686 | 11.6296 | 11.6345 | 10531248.0 |
| 2011-06-17 09:45:00 | AAPL | Stock | 11.6357 | 11.6661 | 11.6014 | 11.6189 | 10109176.0 |
| 2011-06-17 09:50:00 | AAPL | Stock | 11.62 | 11.6514 | 11.6164 | 11.6196 | 6350316.0 |
| 2011-06-17 09:55:00 | AAPL | Stock | 11.6214 | 11.6346 | 11.577 | 11.5786 | 12454932.0 |
| 2011-06-17 10:00:00 | AAPL | Stock | 11.5791 | 11.6106 | 11.5457 | 11.581 | 16354268.0 |
| 2011-06-17 10:05:00 | AAPL | Stock | 11.5812 | 11.5864 | 11.5222 | 11.5346 | 13519268.0 |
| 2011-06-17 10:10:00 | AAPL | Stock | 11.5349 | 11.5832 | 11.5332 | 11.5646 | 10034164.0 |
| 2011-06-17 10:15:00 | AAPL | Stock | 11.5632 | 11.5655 | 11.4961 | 11.5271 | 13166412.0 |
| 2011-06-17 10:20:00 | AAPL | Stock | 11.5299 | 11.5348 | 11.4882 | 11.5 | 8010744.0 |
| 2011-06-17 10:25:00 | AAPL | Stock | 11.5004 | 11.5004 | 11.445 | 11.4821 | 16657704.0 |
| 2011-06-17 10:30:00 | AAPL | Stock | 11.4821 | 11.4979 | 11.4554 | 11.462 | 9775472.0 |
| 2011-06-17 10:35:00 | AAPL | Stock | 11.4636 | 11.5518 | 11.4468 | 11.5379 | 14426020.0 |
| 2011-06-17 10:40:00 | AAPL | Stock | 11.5379 | 11.5436 | 11.5101 | 11.5164 | 7457604.0 |
> showing 50 of 341,848 rows — these rows as CSV