PREVIEW / stock_5min / 2012-06-11
file: by_date/stock_5min/2012/2012-06-11.parquet size: 4.8 MB rows: 330,799 symbols: 3,515
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 |
|---|---|---|---|---|---|---|---|
| 2012-06-11 04:00:00 | AAPL | Stock | 20.7839 | 21.0246 | 20.7839 | 21.0018 | 24696.0 |
| 2012-06-11 04:05:00 | AAPL | Stock | 21.0239 | 21.0246 | 21.0239 | 21.0246 | 5600.0 |
| 2012-06-11 04:10:00 | AAPL | Stock | 21.0246 | 21.0246 | 21.0 | 21.0246 | 58100.0 |
| 2012-06-11 04:15:00 | AAPL | Stock | 21.0554 | 21.0554 | 21.0475 | 21.0475 | 24248.0 |
| 2012-06-11 04:20:00 | AAPL | Stock | 21.0357 | 21.0357 | 21.0357 | 21.0357 | 19600.0 |
| 2012-06-11 04:30:00 | AAPL | Stock | 21.0304 | 21.0304 | 21.0304 | 21.0304 | 8400.0 |
| 2012-06-11 04:45:00 | AAPL | Stock | 20.9825 | 20.9825 | 20.9825 | 20.9825 | 5600.0 |
| 2012-06-11 04:55:00 | AAPL | Stock | 20.9757 | 20.9757 | 20.9757 | 20.9757 | 5600.0 |
| 2012-06-11 05:05:00 | AAPL | Stock | 20.9861 | 20.9861 | 20.9861 | 20.9861 | 16800.0 |
| 2012-06-11 05:10:00 | AAPL | Stock | 20.9796 | 20.9796 | 20.9646 | 20.9646 | 5600.0 |
| 2012-06-11 05:20:00 | AAPL | Stock | 20.965 | 20.965 | 20.965 | 20.965 | 5600.0 |
| 2012-06-11 05:25:00 | AAPL | Stock | 20.965 | 20.965 | 20.965 | 20.965 | 8400.0 |
| 2012-06-11 05:30:00 | AAPL | Stock | 20.965 | 20.965 | 20.965 | 20.965 | 2800.0 |
| 2012-06-11 05:55:00 | AAPL | Stock | 20.9611 | 20.9611 | 20.9607 | 20.9607 | 5600.0 |
| 2012-06-11 06:05:00 | AAPL | Stock | 20.9536 | 20.9536 | 20.9536 | 20.9536 | 2800.0 |
| 2012-06-11 06:10:00 | AAPL | Stock | 20.9536 | 20.9536 | 20.9536 | 20.9536 | 22400.0 |
| 2012-06-11 06:30:00 | AAPL | Stock | 20.9375 | 20.9375 | 20.9343 | 20.9375 | 54936.0 |
| 2012-06-11 06:35:00 | AAPL | Stock | 20.9379 | 20.9379 | 20.9336 | 20.9336 | 16800.0 |
| 2012-06-11 06:40:00 | AAPL | Stock | 20.9339 | 20.9339 | 20.9339 | 20.9339 | 5600.0 |
| 2012-06-11 06:45:00 | AAPL | Stock | 20.9289 | 20.9289 | 20.9289 | 20.9289 | 7000.0 |
| 2012-06-11 06:50:00 | AAPL | Stock | 20.9161 | 20.9161 | 20.8929 | 20.8929 | 30800.0 |
| 2012-06-11 06:55:00 | AAPL | Stock | 20.8929 | 20.8929 | 20.8929 | 20.8929 | 11200.0 |
| 2012-06-11 07:00:00 | AAPL | Stock | 20.9046 | 20.9046 | 20.8793 | 20.8929 | 98560.0 |
| 2012-06-11 07:05:00 | AAPL | Stock | 20.8857 | 20.8911 | 20.8732 | 20.8746 | 106148.0 |
| 2012-06-11 07:10:00 | AAPL | Stock | 20.8696 | 20.8925 | 20.8679 | 20.8896 | 254940.0 |
| 2012-06-11 07:15:00 | AAPL | Stock | 20.8886 | 20.8929 | 20.8886 | 20.8929 | 67228.0 |
| 2012-06-11 07:20:00 | AAPL | Stock | 20.895 | 20.9018 | 20.8839 | 20.8893 | 75600.0 |
| 2012-06-11 07:25:00 | AAPL | Stock | 20.8925 | 20.8929 | 20.8714 | 20.8714 | 185808.0 |
| 2012-06-11 07:30:00 | AAPL | Stock | 20.875 | 20.8929 | 20.8679 | 20.8857 | 210196.0 |
| 2012-06-11 07:35:00 | AAPL | Stock | 20.8861 | 20.8861 | 20.8507 | 20.8507 | 304248.0 |
| 2012-06-11 07:40:00 | AAPL | Stock | 20.8571 | 20.8582 | 20.84 | 20.8486 | 42000.0 |
| 2012-06-11 07:45:00 | AAPL | Stock | 20.8564 | 20.875 | 20.8564 | 20.8739 | 110264.0 |
| 2012-06-11 07:50:00 | AAPL | Stock | 20.8761 | 20.8814 | 20.8675 | 20.8714 | 141820.0 |
| 2012-06-11 07:55:00 | AAPL | Stock | 20.8821 | 20.8821 | 20.8714 | 20.8789 | 63084.0 |
| 2012-06-11 08:00:00 | AAPL | Stock | 20.8911 | 20.9486 | 20.8821 | 20.9457 | 875924.0 |
| 2012-06-11 08:05:00 | AAPL | Stock | 20.9439 | 20.9643 | 20.9379 | 20.9525 | 487536.0 |
| 2012-06-11 08:10:00 | AAPL | Stock | 20.9571 | 20.9732 | 20.9529 | 20.9696 | 373128.0 |
| 2012-06-11 08:15:00 | AAPL | Stock | 20.9707 | 20.9707 | 20.9493 | 20.9504 | 432852.0 |
| 2012-06-11 08:20:00 | AAPL | Stock | 20.9568 | 20.9671 | 20.95 | 20.955 | 241164.0 |
| 2012-06-11 08:25:00 | AAPL | Stock | 20.9554 | 20.9632 | 20.9511 | 20.9557 | 102900.0 |
| 2012-06-11 08:30:00 | AAPL | Stock | 20.9504 | 20.9714 | 20.9482 | 20.9671 | 434420.0 |
| 2012-06-11 08:35:00 | AAPL | Stock | 20.9686 | 20.9768 | 20.9489 | 20.9554 | 492996.0 |
| 2012-06-11 08:40:00 | AAPL | Stock | 20.9564 | 20.9661 | 20.95 | 20.9643 | 299320.0 |
| 2012-06-11 08:45:00 | AAPL | Stock | 20.965 | 20.9768 | 20.9643 | 20.9764 | 331240.0 |
| 2012-06-11 08:50:00 | AAPL | Stock | 20.9732 | 20.975 | 20.9643 | 20.9743 | 247352.0 |
| 2012-06-11 08:55:00 | AAPL | Stock | 20.975 | 20.9821 | 20.9536 | 20.9536 | 597268.0 |
| 2012-06-11 09:00:00 | AAPL | Stock | 20.9525 | 20.9654 | 20.9525 | 20.9589 | 432208.0 |
| 2012-06-11 09:05:00 | AAPL | Stock | 20.9571 | 20.9571 | 20.9371 | 20.9429 | 587160.0 |
| 2012-06-11 09:10:00 | AAPL | Stock | 20.9389 | 20.9518 | 20.9336 | 20.9375 | 474152.0 |
| 2012-06-11 09:15:00 | AAPL | Stock | 20.9375 | 20.9461 | 20.9339 | 20.9339 | 337064.0 |
> showing 50 of 330,799 rows — these rows as CSV