PREVIEW / stock_5min / 2013-11-14
file: by_date/stock_5min/2013/2013-11-14.parquet size: 5.2 MB rows: 341,943 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 |
|---|---|---|---|---|---|---|---|
| 2013-11-14 06:20:00 | AAPL | Stock | 18.5657 | 18.5657 | 18.5657 | 18.5657 | 2800.0 |
| 2013-11-14 07:30:00 | AAPL | Stock | 18.5921 | 18.5964 | 18.5921 | 18.5964 | 11200.0 |
| 2013-11-14 07:40:00 | AAPL | Stock | 18.6093 | 18.6107 | 18.6071 | 18.6107 | 22400.0 |
| 2013-11-14 07:50:00 | AAPL | Stock | 18.6104 | 18.6232 | 18.6104 | 18.6232 | 55888.0 |
| 2013-11-14 08:00:00 | AAPL | Stock | 18.6196 | 18.625 | 18.5714 | 18.6246 | 72744.0 |
| 2013-11-14 08:05:00 | AAPL | Stock | 18.6232 | 18.6429 | 18.6232 | 18.6429 | 61376.0 |
| 2013-11-14 08:10:00 | AAPL | Stock | 18.6429 | 18.6532 | 18.6429 | 18.6532 | 89488.0 |
| 2013-11-14 08:15:00 | AAPL | Stock | 18.6532 | 18.6607 | 18.6518 | 18.6607 | 200116.0 |
| 2013-11-14 08:20:00 | AAPL | Stock | 18.6636 | 18.6732 | 18.6607 | 18.6607 | 194824.0 |
| 2013-11-14 08:25:00 | AAPL | Stock | 18.6689 | 18.6689 | 18.6571 | 18.6571 | 8400.0 |
| 2013-11-14 08:30:00 | AAPL | Stock | 18.6596 | 18.6625 | 18.6518 | 18.6561 | 164164.0 |
| 2013-11-14 08:35:00 | AAPL | Stock | 18.6536 | 18.6589 | 18.6518 | 18.6518 | 222740.0 |
| 2013-11-14 08:40:00 | AAPL | Stock | 18.6568 | 18.6607 | 18.6518 | 18.6607 | 111720.0 |
| 2013-11-14 08:45:00 | AAPL | Stock | 18.6607 | 18.6632 | 18.6518 | 18.6532 | 131600.0 |
| 2013-11-14 08:50:00 | AAPL | Stock | 18.6521 | 18.6568 | 18.6518 | 18.6568 | 48188.0 |
| 2013-11-14 08:55:00 | AAPL | Stock | 18.6518 | 18.6568 | 18.6518 | 18.6518 | 138488.0 |
| 2013-11-14 09:00:00 | AAPL | Stock | 18.6518 | 18.6521 | 18.6518 | 18.6518 | 65324.0 |
| 2013-11-14 09:05:00 | AAPL | Stock | 18.6518 | 18.6536 | 18.6518 | 18.6518 | 59724.0 |
| 2013-11-14 09:10:00 | AAPL | Stock | 18.6446 | 18.65 | 18.6429 | 18.65 | 44800.0 |
| 2013-11-14 09:15:00 | AAPL | Stock | 18.6454 | 18.6518 | 18.6454 | 18.65 | 41720.0 |
| 2013-11-14 09:20:00 | AAPL | Stock | 18.6543 | 18.6568 | 18.65 | 18.6514 | 66444.0 |
| 2013-11-14 09:25:00 | AAPL | Stock | 18.6429 | 18.6875 | 18.6429 | 18.6811 | 322280.0 |
| 2013-11-14 09:30:00 | AAPL | Stock | 18.6782 | 18.7054 | 18.6382 | 18.7004 | 13979196.0 |
| 2013-11-14 09:35:00 | AAPL | Stock | 18.7043 | 18.745 | 18.6875 | 18.7332 | 11576040.0 |
| 2013-11-14 09:40:00 | AAPL | Stock | 18.7364 | 18.7461 | 18.7164 | 18.7375 | 6653892.0 |
| 2013-11-14 09:45:00 | AAPL | Stock | 18.7371 | 18.7554 | 18.7014 | 18.7418 | 14722316.0 |
| 2013-11-14 09:50:00 | AAPL | Stock | 18.7457 | 18.7593 | 18.73 | 18.7475 | 6468672.0 |
| 2013-11-14 09:55:00 | AAPL | Stock | 18.7454 | 18.7457 | 18.7186 | 18.7321 | 4423020.0 |
| 2013-11-14 10:00:00 | AAPL | Stock | 18.7346 | 18.7589 | 18.7075 | 18.7397 | 5410104.0 |
| 2013-11-14 10:05:00 | AAPL | Stock | 18.7425 | 18.7589 | 18.7164 | 18.7443 | 6510504.0 |
| 2013-11-14 10:10:00 | AAPL | Stock | 18.7423 | 18.7846 | 18.74 | 18.7814 | 8988140.0 |
| 2013-11-14 10:15:00 | AAPL | Stock | 18.7807 | 18.8089 | 18.7768 | 18.7946 | 7967344.0 |
| 2013-11-14 10:20:00 | AAPL | Stock | 18.7943 | 18.8073 | 18.7832 | 18.795 | 6561380.0 |
| 2013-11-14 10:25:00 | AAPL | Stock | 18.7982 | 18.8068 | 18.7857 | 18.7911 | 4148788.0 |
| 2013-11-14 10:30:00 | AAPL | Stock | 18.7939 | 18.8414 | 18.7918 | 18.8411 | 7368480.0 |
| 2013-11-14 10:35:00 | AAPL | Stock | 18.8411 | 18.8429 | 18.8257 | 18.8407 | 4118100.0 |
| 2013-11-14 10:40:00 | AAPL | Stock | 18.8396 | 18.8429 | 18.8143 | 18.8407 | 3220112.0 |
| 2013-11-14 10:45:00 | AAPL | Stock | 18.8382 | 18.8525 | 18.8218 | 18.8343 | 3195976.0 |
| 2013-11-14 10:50:00 | AAPL | Stock | 18.8375 | 18.8382 | 18.8107 | 18.8175 | 3367056.0 |
| 2013-11-14 10:55:00 | AAPL | Stock | 18.8186 | 18.83 | 18.8107 | 18.8266 | 1982820.0 |
| 2013-11-14 11:00:00 | AAPL | Stock | 18.8279 | 18.8286 | 18.8129 | 18.8182 | 2169076.0 |
| 2013-11-14 11:05:00 | AAPL | Stock | 18.8211 | 18.8246 | 18.7971 | 18.805 | 4490500.0 |
| 2013-11-14 11:10:00 | AAPL | Stock | 18.8075 | 18.8296 | 18.8025 | 18.8218 | 4090212.0 |
| 2013-11-14 11:15:00 | AAPL | Stock | 18.8257 | 18.8564 | 18.8221 | 18.8546 | 5289844.0 |
| 2013-11-14 11:20:00 | AAPL | Stock | 18.8555 | 18.8607 | 18.8361 | 18.8557 | 5073404.0 |
| 2013-11-14 11:25:00 | AAPL | Stock | 18.8539 | 18.8632 | 18.8439 | 18.8443 | 2709392.0 |
| 2013-11-14 11:30:00 | AAPL | Stock | 18.8461 | 18.8561 | 18.8261 | 18.8461 | 2674084.0 |
| 2013-11-14 11:35:00 | AAPL | Stock | 18.8457 | 18.85 | 18.8329 | 18.8434 | 1792504.0 |
| 2013-11-14 11:40:00 | AAPL | Stock | 18.8449 | 18.8464 | 18.8157 | 18.8225 | 4480532.0 |
| 2013-11-14 11:45:00 | AAPL | Stock | 18.8225 | 18.8332 | 18.815 | 18.8179 | 3205972.0 |
> showing 50 of 341,943 rows — these rows as CSV