PREVIEW / stock_5min / 2013-08-13
file: by_date/stock_5min/2013/2013-08-13.parquet size: 5.1 MB rows: 339,416 symbols: 3,512
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-08-13 04:45:00 | AAPL | Stock | 16.76 | 16.76 | 16.7579 | 16.7579 | 8400.0 |
| 2013-08-13 05:00:00 | AAPL | Stock | 16.7571 | 16.7571 | 16.7571 | 16.7571 | 5600.0 |
| 2013-08-13 05:10:00 | AAPL | Stock | 16.75 | 16.75 | 16.75 | 16.75 | 2800.0 |
| 2013-08-13 05:15:00 | AAPL | Stock | 16.7661 | 16.7857 | 16.7643 | 16.7857 | 61600.0 |
| 2013-08-13 05:30:00 | AAPL | Stock | 16.7664 | 16.7664 | 16.7643 | 16.7643 | 14000.0 |
| 2013-08-13 05:45:00 | AAPL | Stock | 16.7679 | 16.7679 | 16.7679 | 16.7679 | 10360.0 |
| 2013-08-13 05:55:00 | AAPL | Stock | 16.7571 | 16.7571 | 16.7571 | 16.7571 | 14000.0 |
| 2013-08-13 06:10:00 | AAPL | Stock | 16.7571 | 16.7571 | 16.7571 | 16.7571 | 11200.0 |
| 2013-08-13 06:15:00 | AAPL | Stock | 16.7571 | 16.7571 | 16.7536 | 16.7536 | 5600.0 |
| 2013-08-13 06:20:00 | AAPL | Stock | 16.7536 | 16.7536 | 16.7536 | 16.7536 | 2800.0 |
| 2013-08-13 06:25:00 | AAPL | Stock | 16.7571 | 16.7571 | 16.7571 | 16.7571 | 5600.0 |
| 2013-08-13 06:40:00 | AAPL | Stock | 16.7661 | 16.7661 | 16.7661 | 16.7661 | 2800.0 |
| 2013-08-13 06:45:00 | AAPL | Stock | 16.7654 | 16.7654 | 16.7654 | 16.7654 | 2800.0 |
| 2013-08-13 06:50:00 | AAPL | Stock | 16.7661 | 16.7679 | 16.7575 | 16.7575 | 20944.0 |
| 2013-08-13 06:55:00 | AAPL | Stock | 16.7557 | 16.7557 | 16.7557 | 16.7557 | 2800.0 |
| 2013-08-13 07:00:00 | AAPL | Stock | 16.7643 | 16.7768 | 16.7639 | 16.7643 | 31836.0 |
| 2013-08-13 07:05:00 | AAPL | Stock | 16.7679 | 16.7686 | 16.7589 | 16.7589 | 61376.0 |
| 2013-08-13 07:10:00 | AAPL | Stock | 16.7679 | 16.7825 | 16.7679 | 16.7825 | 75040.0 |
| 2013-08-13 07:15:00 | AAPL | Stock | 16.7825 | 16.7964 | 16.7729 | 16.7854 | 84700.0 |
| 2013-08-13 07:20:00 | AAPL | Stock | 16.785 | 16.785 | 16.785 | 16.785 | 2800.0 |
| 2013-08-13 07:25:00 | AAPL | Stock | 16.7768 | 16.7768 | 16.7711 | 16.7711 | 16800.0 |
| 2013-08-13 07:30:00 | AAPL | Stock | 16.7714 | 16.7743 | 16.7679 | 16.7679 | 131964.0 |
| 2013-08-13 07:35:00 | AAPL | Stock | 16.7714 | 16.7736 | 16.7714 | 16.7736 | 30688.0 |
| 2013-08-13 07:40:00 | AAPL | Stock | 16.7761 | 16.7857 | 16.7761 | 16.7821 | 94500.0 |
| 2013-08-13 07:45:00 | AAPL | Stock | 16.7754 | 16.7754 | 16.7754 | 16.7754 | 2800.0 |
| 2013-08-13 07:50:00 | AAPL | Stock | 16.7732 | 16.7771 | 16.7679 | 16.7771 | 40628.0 |
| 2013-08-13 07:55:00 | AAPL | Stock | 16.775 | 16.7804 | 16.7736 | 16.7736 | 49728.0 |
| 2013-08-13 08:00:00 | AAPL | Stock | 16.7736 | 16.7857 | 16.7593 | 16.7821 | 379904.0 |
| 2013-08-13 08:05:00 | AAPL | Stock | 16.7793 | 16.7964 | 16.7789 | 16.7964 | 487788.0 |
| 2013-08-13 08:10:00 | AAPL | Stock | 16.7929 | 16.8143 | 16.7929 | 16.8121 | 388388.0 |
| 2013-08-13 08:15:00 | AAPL | Stock | 16.8071 | 16.8157 | 16.8036 | 16.8107 | 239288.0 |
| 2013-08-13 08:20:00 | AAPL | Stock | 16.8111 | 16.8161 | 16.8 | 16.8 | 353444.0 |
| 2013-08-13 08:25:00 | AAPL | Stock | 16.8036 | 16.8036 | 16.7968 | 16.8 | 166040.0 |
| 2013-08-13 08:30:00 | AAPL | Stock | 16.7971 | 16.8 | 16.7893 | 16.7904 | 140560.0 |
| 2013-08-13 08:35:00 | AAPL | Stock | 16.7921 | 16.8071 | 16.7893 | 16.8071 | 196084.0 |
| 2013-08-13 08:40:00 | AAPL | Stock | 16.8071 | 16.8157 | 16.8 | 16.8104 | 341824.0 |
| 2013-08-13 08:45:00 | AAPL | Stock | 16.8082 | 16.8136 | 16.8025 | 16.8068 | 106260.0 |
| 2013-08-13 08:50:00 | AAPL | Stock | 16.8071 | 16.8143 | 16.8071 | 16.8143 | 91280.0 |
| 2013-08-13 08:55:00 | AAPL | Stock | 16.8089 | 16.8125 | 16.8079 | 16.8107 | 98280.0 |
| 2013-08-13 09:00:00 | AAPL | Stock | 16.8121 | 16.8318 | 16.8121 | 16.83 | 681940.0 |
| 2013-08-13 09:05:00 | AAPL | Stock | 16.8221 | 16.83 | 16.8204 | 16.8204 | 189672.0 |
| 2013-08-13 09:10:00 | AAPL | Stock | 16.8164 | 16.8211 | 16.8161 | 16.8211 | 85400.0 |
| 2013-08-13 09:15:00 | AAPL | Stock | 16.8214 | 16.8214 | 16.8082 | 16.8089 | 228228.0 |
| 2013-08-13 09:20:00 | AAPL | Stock | 16.8093 | 16.8214 | 16.8086 | 16.8146 | 183764.0 |
| 2013-08-13 09:25:00 | AAPL | Stock | 16.8179 | 16.8286 | 16.8125 | 16.82 | 294532.0 |
| 2013-08-13 09:30:00 | AAPL | Stock | 16.82 | 16.9139 | 16.8129 | 16.8875 | 27970320.0 |
| 2013-08-13 09:35:00 | AAPL | Stock | 16.8889 | 16.9389 | 16.8846 | 16.8982 | 15940848.0 |
| 2013-08-13 09:40:00 | AAPL | Stock | 16.8964 | 16.915 | 16.8511 | 16.8543 | 9901080.0 |
| 2013-08-13 09:45:00 | AAPL | Stock | 16.8593 | 16.905 | 16.8564 | 16.8764 | 7385280.0 |
| 2013-08-13 09:50:00 | AAPL | Stock | 16.875 | 16.8814 | 16.8436 | 16.8546 | 8328208.0 |
> showing 50 of 339,416 rows — these rows as CSV