PREVIEW / stock_5min / 2014-04-08
file: by_date/stock_5min/2014/2014-04-08.parquet size: 5.5 MB rows: 361,863 symbols: 3,555
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 |
|---|---|---|---|---|---|---|---|
| 2014-04-08 04:35:00 | AAPL | Stock | 18.7725 | 18.7725 | 18.7725 | 18.7725 | 5600.0 |
| 2014-04-08 04:50:00 | AAPL | Stock | 18.7786 | 18.7839 | 18.7786 | 18.7839 | 14000.0 |
| 2014-04-08 05:00:00 | AAPL | Stock | 18.7557 | 18.7557 | 18.7518 | 18.7518 | 5600.0 |
| 2014-04-08 05:10:00 | AAPL | Stock | 18.75 | 18.75 | 18.75 | 18.75 | 4116.0 |
| 2014-04-08 05:30:00 | AAPL | Stock | 18.7479 | 18.7479 | 18.7479 | 18.7479 | 2800.0 |
| 2014-04-08 05:35:00 | AAPL | Stock | 18.7457 | 18.7479 | 18.7457 | 18.7479 | 5600.0 |
| 2014-04-08 05:40:00 | AAPL | Stock | 18.7311 | 18.7311 | 18.7161 | 18.7161 | 8400.0 |
| 2014-04-08 05:55:00 | AAPL | Stock | 18.7161 | 18.7161 | 18.7161 | 18.7161 | 2800.0 |
| 2014-04-08 06:20:00 | AAPL | Stock | 18.71 | 18.71 | 18.71 | 18.71 | 2800.0 |
| 2014-04-08 06:50:00 | AAPL | Stock | 18.6964 | 18.6964 | 18.6964 | 18.6964 | 2800.0 |
| 2014-04-08 07:35:00 | AAPL | Stock | 18.6986 | 18.6986 | 18.6986 | 18.6986 | 2800.0 |
| 2014-04-08 07:40:00 | AAPL | Stock | 18.7021 | 18.7021 | 18.7 | 18.7 | 11200.0 |
| 2014-04-08 07:45:00 | AAPL | Stock | 18.6857 | 18.6857 | 18.6857 | 18.6857 | 5600.0 |
| 2014-04-08 07:55:00 | AAPL | Stock | 18.7025 | 18.7036 | 18.7025 | 18.7036 | 6692.0 |
| 2014-04-08 08:00:00 | AAPL | Stock | 18.6986 | 18.7214 | 18.6986 | 18.7143 | 65044.0 |
| 2014-04-08 08:05:00 | AAPL | Stock | 18.7232 | 18.7411 | 18.7232 | 18.7411 | 11200.0 |
| 2014-04-08 08:10:00 | AAPL | Stock | 18.7679 | 18.7732 | 18.7504 | 18.7607 | 26880.0 |
| 2014-04-08 08:15:00 | AAPL | Stock | 18.7679 | 18.7743 | 18.7589 | 18.7679 | 36484.0 |
| 2014-04-08 08:20:00 | AAPL | Stock | 18.7589 | 18.7589 | 18.7586 | 18.7586 | 8400.0 |
| 2014-04-08 08:25:00 | AAPL | Stock | 18.7454 | 18.8079 | 18.7454 | 18.7857 | 143528.0 |
| 2014-04-08 08:30:00 | AAPL | Stock | 18.7957 | 18.8075 | 18.7893 | 18.8036 | 148008.0 |
| 2014-04-08 08:35:00 | AAPL | Stock | 18.7929 | 18.815 | 18.7911 | 18.8068 | 191800.0 |
| 2014-04-08 08:40:00 | AAPL | Stock | 18.8068 | 18.8068 | 18.7936 | 18.8011 | 25200.0 |
| 2014-04-08 08:45:00 | AAPL | Stock | 18.7943 | 18.7975 | 18.7871 | 18.7893 | 57960.0 |
| 2014-04-08 08:50:00 | AAPL | Stock | 18.795 | 18.7964 | 18.7868 | 18.7964 | 75600.0 |
| 2014-04-08 08:55:00 | AAPL | Stock | 18.8036 | 18.8068 | 18.7971 | 18.8007 | 73220.0 |
| 2014-04-08 09:00:00 | AAPL | Stock | 18.7982 | 18.8029 | 18.7946 | 18.7946 | 32060.0 |
| 2014-04-08 09:05:00 | AAPL | Stock | 18.7971 | 18.8018 | 18.77 | 18.77 | 208012.0 |
| 2014-04-08 09:10:00 | AAPL | Stock | 18.7814 | 18.7857 | 18.7761 | 18.7768 | 70000.0 |
| 2014-04-08 09:15:00 | AAPL | Stock | 18.7832 | 18.7854 | 18.78 | 18.7854 | 30380.0 |
| 2014-04-08 09:20:00 | AAPL | Stock | 18.7786 | 18.7786 | 18.7721 | 18.7721 | 37772.0 |
| 2014-04-08 09:25:00 | AAPL | Stock | 18.7671 | 18.775 | 18.7432 | 18.7432 | 180404.0 |
| 2014-04-08 09:30:00 | AAPL | Stock | 18.7546 | 18.79 | 18.7243 | 18.7371 | 8371244.0 |
| 2014-04-08 09:35:00 | AAPL | Stock | 18.7257 | 18.7443 | 18.6818 | 18.6957 | 5505332.0 |
| 2014-04-08 09:40:00 | AAPL | Stock | 18.6971 | 18.7214 | 18.6832 | 18.6836 | 4496352.0 |
| 2014-04-08 09:45:00 | AAPL | Stock | 18.6836 | 18.685 | 18.5796 | 18.5843 | 8791972.0 |
| 2014-04-08 09:50:00 | AAPL | Stock | 18.5839 | 18.5853 | 18.525 | 18.5693 | 9722804.0 |
| 2014-04-08 09:55:00 | AAPL | Stock | 18.5689 | 18.6 | 18.5482 | 18.5646 | 4240824.0 |
| 2014-04-08 10:00:00 | AAPL | Stock | 18.5711 | 18.6336 | 18.565 | 18.6143 | 4444244.0 |
| 2014-04-08 10:05:00 | AAPL | Stock | 18.6125 | 18.68 | 18.6082 | 18.6736 | 4513992.0 |
| 2014-04-08 10:10:00 | AAPL | Stock | 18.6737 | 18.68 | 18.6321 | 18.6421 | 3550512.0 |
| 2014-04-08 10:15:00 | AAPL | Stock | 18.6446 | 18.6739 | 18.6361 | 18.6571 | 3039988.0 |
| 2014-04-08 10:20:00 | AAPL | Stock | 18.6571 | 18.6643 | 18.5875 | 18.6037 | 2976848.0 |
| 2014-04-08 10:25:00 | AAPL | Stock | 18.6032 | 18.6225 | 18.5929 | 18.5936 | 2944844.0 |
| 2014-04-08 10:30:00 | AAPL | Stock | 18.5936 | 18.6746 | 18.5936 | 18.6657 | 5353908.0 |
| 2014-04-08 10:35:00 | AAPL | Stock | 18.6693 | 18.7239 | 18.6568 | 18.7143 | 4921924.0 |
| 2014-04-08 10:40:00 | AAPL | Stock | 18.7154 | 18.729 | 18.6964 | 18.7282 | 4853296.0 |
| 2014-04-08 10:45:00 | AAPL | Stock | 18.7254 | 18.7436 | 18.7254 | 18.735 | 4057228.0 |
| 2014-04-08 10:50:00 | AAPL | Stock | 18.7354 | 18.7711 | 18.7321 | 18.7618 | 4458916.0 |
| 2014-04-08 10:55:00 | AAPL | Stock | 18.7631 | 18.7807 | 18.7404 | 18.7454 | 2898644.0 |
> showing 50 of 361,863 rows — these rows as CSV