PREVIEW / stock_5min / 2013-11-11
file: by_date/stock_5min/2013/2013-11-11.parquet size: 5.0 MB rows: 333,404 symbols: 3,523
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-11 04:00:00 | AAPL | Stock | 18.6071 | 18.6071 | 18.6071 | 18.6071 | 4676.0 |
| 2013-11-11 04:05:00 | AAPL | Stock | 18.5918 | 18.5918 | 18.5918 | 18.5918 | 8400.0 |
| 2013-11-11 04:40:00 | AAPL | Stock | 18.5893 | 18.5893 | 18.5893 | 18.5893 | 2800.0 |
| 2013-11-11 04:45:00 | AAPL | Stock | 18.5714 | 18.5714 | 18.5714 | 18.5714 | 2800.0 |
| 2013-11-11 04:55:00 | AAPL | Stock | 18.5714 | 18.5714 | 18.5714 | 18.5714 | 2800.0 |
| 2013-11-11 05:05:00 | AAPL | Stock | 18.5843 | 18.5843 | 18.5843 | 18.5843 | 2800.0 |
| 2013-11-11 05:15:00 | AAPL | Stock | 18.5714 | 18.5714 | 18.5714 | 18.5714 | 28000.0 |
| 2013-11-11 05:40:00 | AAPL | Stock | 18.5714 | 18.5714 | 18.5714 | 18.5714 | 5600.0 |
| 2013-11-11 05:45:00 | AAPL | Stock | 18.5714 | 18.5714 | 18.5714 | 18.5714 | 11200.0 |
| 2013-11-11 06:00:00 | AAPL | Stock | 18.5714 | 18.5714 | 18.5714 | 18.5714 | 28000.0 |
| 2013-11-11 06:10:00 | AAPL | Stock | 18.5714 | 18.5714 | 18.5714 | 18.5714 | 2800.0 |
| 2013-11-11 06:20:00 | AAPL | Stock | 18.565 | 18.565 | 18.565 | 18.565 | 2800.0 |
| 2013-11-11 06:25:00 | AAPL | Stock | 18.5643 | 18.5643 | 18.5543 | 18.5543 | 44800.0 |
| 2013-11-11 06:40:00 | AAPL | Stock | 18.555 | 18.555 | 18.555 | 18.555 | 5600.0 |
| 2013-11-11 06:55:00 | AAPL | Stock | 18.55 | 18.5507 | 18.5393 | 18.5393 | 21000.0 |
| 2013-11-11 07:00:00 | AAPL | Stock | 18.5707 | 18.5707 | 18.5707 | 18.5707 | 2800.0 |
| 2013-11-11 07:05:00 | AAPL | Stock | 18.5696 | 18.5893 | 18.5696 | 18.5893 | 55636.0 |
| 2013-11-11 07:15:00 | AAPL | Stock | 18.5893 | 18.5893 | 18.575 | 18.575 | 13692.0 |
| 2013-11-11 07:25:00 | AAPL | Stock | 18.5893 | 18.6029 | 18.5893 | 18.6029 | 8400.0 |
| 2013-11-11 07:30:00 | AAPL | Stock | 18.6071 | 18.6071 | 18.5968 | 18.5968 | 33880.0 |
| 2013-11-11 07:35:00 | AAPL | Stock | 18.6071 | 18.6071 | 18.5825 | 18.5825 | 36288.0 |
| 2013-11-11 07:40:00 | AAPL | Stock | 18.6068 | 18.6068 | 18.6068 | 18.6068 | 5600.0 |
| 2013-11-11 07:45:00 | AAPL | Stock | 18.6193 | 18.6429 | 18.6193 | 18.6429 | 30800.0 |
| 2013-11-11 07:50:00 | AAPL | Stock | 18.6536 | 18.6625 | 18.6471 | 18.6625 | 38080.0 |
| 2013-11-11 07:55:00 | AAPL | Stock | 18.6629 | 18.6789 | 18.6629 | 18.6746 | 69440.0 |
| 2013-11-11 08:00:00 | AAPL | Stock | 18.6714 | 18.6746 | 18.5714 | 18.6432 | 709352.0 |
| 2013-11-11 08:05:00 | AAPL | Stock | 18.6564 | 18.6725 | 18.63 | 18.63 | 171584.0 |
| 2013-11-11 08:10:00 | AAPL | Stock | 18.6418 | 18.6546 | 18.6411 | 18.6546 | 30744.0 |
| 2013-11-11 08:15:00 | AAPL | Stock | 18.6518 | 18.6607 | 18.6518 | 18.6518 | 73808.0 |
| 2013-11-11 08:20:00 | AAPL | Stock | 18.6518 | 18.6568 | 18.6064 | 18.6071 | 477792.0 |
| 2013-11-11 08:25:00 | AAPL | Stock | 18.6075 | 18.6229 | 18.6071 | 18.6079 | 152600.0 |
| 2013-11-11 08:30:00 | AAPL | Stock | 18.6179 | 18.6179 | 18.5839 | 18.5839 | 253288.0 |
| 2013-11-11 08:35:00 | AAPL | Stock | 18.5889 | 18.6246 | 18.5864 | 18.6089 | 289044.0 |
| 2013-11-11 08:40:00 | AAPL | Stock | 18.6107 | 18.6107 | 18.5946 | 18.5946 | 22400.0 |
| 2013-11-11 08:45:00 | AAPL | Stock | 18.5932 | 18.6232 | 18.5932 | 18.6071 | 71960.0 |
| 2013-11-11 08:50:00 | AAPL | Stock | 18.6068 | 18.6075 | 18.5989 | 18.6057 | 28560.0 |
| 2013-11-11 08:55:00 | AAPL | Stock | 18.6046 | 18.6046 | 18.5786 | 18.5786 | 148624.0 |
| 2013-11-11 09:00:00 | AAPL | Stock | 18.5786 | 18.5896 | 18.5771 | 18.5893 | 119392.0 |
| 2013-11-11 09:05:00 | AAPL | Stock | 18.5932 | 18.5932 | 18.5714 | 18.5714 | 98000.0 |
| 2013-11-11 09:10:00 | AAPL | Stock | 18.5804 | 18.5804 | 18.5589 | 18.5714 | 147672.0 |
| 2013-11-11 09:15:00 | AAPL | Stock | 18.5714 | 18.5786 | 18.5707 | 18.5786 | 101836.0 |
| 2013-11-11 09:20:00 | AAPL | Stock | 18.5721 | 18.5821 | 18.5714 | 18.5714 | 125440.0 |
| 2013-11-11 09:25:00 | AAPL | Stock | 18.5786 | 18.5857 | 18.5575 | 18.5575 | 81004.0 |
| 2013-11-11 09:30:00 | AAPL | Stock | 18.5711 | 18.6311 | 18.5464 | 18.5707 | 12937036.0 |
| 2013-11-11 09:35:00 | AAPL | Stock | 18.5736 | 18.5893 | 18.5239 | 18.5477 | 5512584.0 |
| 2013-11-11 09:40:00 | AAPL | Stock | 18.5439 | 18.5489 | 18.4946 | 18.5059 | 5038208.0 |
| 2013-11-11 09:45:00 | AAPL | Stock | 18.5102 | 18.5286 | 18.5004 | 18.5207 | 3612420.0 |
| 2013-11-11 09:50:00 | AAPL | Stock | 18.5193 | 18.5582 | 18.5179 | 18.5518 | 4912152.0 |
| 2013-11-11 09:55:00 | AAPL | Stock | 18.5491 | 18.5561 | 18.4564 | 18.4786 | 8565004.0 |
| 2013-11-11 10:00:00 | AAPL | Stock | 18.4821 | 18.5 | 18.4712 | 18.4989 | 2492840.0 |
> showing 50 of 333,404 rows — these rows as CSV