PREVIEW / stock_5min / 2013-05-24
file: by_date/stock_5min/2013/2013-05-24.parquet size: 4.8 MB rows: 322,957 symbols: 3,514
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-05-24 05:05:00 | AAPL | Stock | 15.8246 | 15.8246 | 15.8246 | 15.8246 | 3864.0 |
| 2013-05-24 06:05:00 | AAPL | Stock | 15.7907 | 15.7907 | 15.7907 | 15.7907 | 17864.0 |
| 2013-05-24 06:10:00 | AAPL | Stock | 15.7714 | 15.7714 | 15.7714 | 15.7714 | 2800.0 |
| 2013-05-24 06:55:00 | AAPL | Stock | 15.7714 | 15.7714 | 15.7714 | 15.7714 | 2800.0 |
| 2013-05-24 07:05:00 | AAPL | Stock | 15.7857 | 15.7857 | 15.7857 | 15.7857 | 4200.0 |
| 2013-05-24 07:10:00 | AAPL | Stock | 15.7804 | 15.7854 | 15.7714 | 15.7854 | 14616.0 |
| 2013-05-24 07:15:00 | AAPL | Stock | 15.7857 | 15.7857 | 15.75 | 15.75 | 11200.0 |
| 2013-05-24 07:25:00 | AAPL | Stock | 15.7857 | 15.7857 | 15.7857 | 15.7857 | 8400.0 |
| 2013-05-24 07:30:00 | AAPL | Stock | 15.7857 | 15.7857 | 15.7857 | 15.7857 | 6776.0 |
| 2013-05-24 07:35:00 | AAPL | Stock | 15.8071 | 15.825 | 15.8071 | 15.8204 | 69300.0 |
| 2013-05-24 07:40:00 | AAPL | Stock | 15.8193 | 15.8343 | 15.8193 | 15.8325 | 54880.0 |
| 2013-05-24 07:45:00 | AAPL | Stock | 15.8564 | 15.8564 | 15.8393 | 15.8393 | 8400.0 |
| 2013-05-24 07:50:00 | AAPL | Stock | 15.8393 | 15.8607 | 15.8393 | 15.8607 | 25200.0 |
| 2013-05-24 07:55:00 | AAPL | Stock | 15.8643 | 15.8929 | 15.8643 | 15.8929 | 42000.0 |
| 2013-05-24 08:00:00 | AAPL | Stock | 15.8593 | 15.8929 | 15.7857 | 15.8379 | 243628.0 |
| 2013-05-24 08:05:00 | AAPL | Stock | 15.7432 | 15.8529 | 15.7432 | 15.825 | 154980.0 |
| 2013-05-24 08:10:00 | AAPL | Stock | 15.8232 | 15.8232 | 15.7411 | 15.75 | 417872.0 |
| 2013-05-24 08:15:00 | AAPL | Stock | 15.7475 | 15.8107 | 15.7475 | 15.8107 | 136500.0 |
| 2013-05-24 08:20:00 | AAPL | Stock | 15.8086 | 15.8107 | 15.7857 | 15.7946 | 129696.0 |
| 2013-05-24 08:25:00 | AAPL | Stock | 15.8014 | 15.8132 | 15.7964 | 15.8132 | 58800.0 |
| 2013-05-24 08:30:00 | AAPL | Stock | 15.825 | 15.8536 | 15.8118 | 15.8125 | 404796.0 |
| 2013-05-24 08:35:00 | AAPL | Stock | 15.8114 | 15.8143 | 15.7954 | 15.8043 | 148652.0 |
| 2013-05-24 08:40:00 | AAPL | Stock | 15.8046 | 15.8086 | 15.7914 | 15.8086 | 66304.0 |
| 2013-05-24 08:45:00 | AAPL | Stock | 15.7979 | 15.8036 | 15.7857 | 15.7957 | 89096.0 |
| 2013-05-24 08:50:00 | AAPL | Stock | 15.7868 | 15.7975 | 15.7868 | 15.7893 | 132720.0 |
| 2013-05-24 08:55:00 | AAPL | Stock | 15.7932 | 15.7982 | 15.7879 | 15.7918 | 47880.0 |
| 2013-05-24 09:00:00 | AAPL | Stock | 15.7875 | 15.7875 | 15.7596 | 15.7771 | 222964.0 |
| 2013-05-24 09:05:00 | AAPL | Stock | 15.7761 | 15.7907 | 15.7725 | 15.7725 | 95704.0 |
| 2013-05-24 09:10:00 | AAPL | Stock | 15.7714 | 15.7839 | 15.7657 | 15.7696 | 155120.0 |
| 2013-05-24 09:15:00 | AAPL | Stock | 15.7721 | 15.7843 | 15.7696 | 15.7814 | 99092.0 |
| 2013-05-24 09:20:00 | AAPL | Stock | 15.7825 | 15.8071 | 15.7825 | 15.8071 | 117180.0 |
| 2013-05-24 09:25:00 | AAPL | Stock | 15.7982 | 15.8039 | 15.7421 | 15.75 | 279832.0 |
| 2013-05-24 09:30:00 | AAPL | Stock | 15.7446 | 15.8775 | 15.7271 | 15.865 | 16008020.0 |
| 2013-05-24 09:35:00 | AAPL | Stock | 15.865 | 15.9164 | 15.8318 | 15.8892 | 12398540.0 |
| 2013-05-24 09:40:00 | AAPL | Stock | 15.8843 | 15.8914 | 15.8321 | 15.8411 | 6393800.0 |
| 2013-05-24 09:45:00 | AAPL | Stock | 15.8379 | 15.8846 | 15.8314 | 15.8486 | 6012552.0 |
| 2013-05-24 09:50:00 | AAPL | Stock | 15.8464 | 15.8479 | 15.81 | 15.8336 | 8898876.0 |
| 2013-05-24 09:55:00 | AAPL | Stock | 15.8307 | 15.8589 | 15.8271 | 15.8414 | 4636324.0 |
| 2013-05-24 10:00:00 | AAPL | Stock | 15.8386 | 15.8391 | 15.8011 | 15.8246 | 6389824.0 |
| 2013-05-24 10:05:00 | AAPL | Stock | 15.8254 | 15.865 | 15.8054 | 15.8423 | 4879896.0 |
| 2013-05-24 10:10:00 | AAPL | Stock | 15.8429 | 15.8764 | 15.8404 | 15.8593 | 5638416.0 |
| 2013-05-24 10:15:00 | AAPL | Stock | 15.8586 | 15.9039 | 15.8525 | 15.8975 | 7023436.0 |
| 2013-05-24 10:20:00 | AAPL | Stock | 15.8979 | 15.8979 | 15.8582 | 15.8744 | 4781840.0 |
| 2013-05-24 10:25:00 | AAPL | Stock | 15.8704 | 15.8857 | 15.8575 | 15.882 | 3397660.0 |
| 2013-05-24 10:30:00 | AAPL | Stock | 15.8825 | 15.8843 | 15.8396 | 15.8607 | 3730132.0 |
| 2013-05-24 10:35:00 | AAPL | Stock | 15.8575 | 15.8843 | 15.8514 | 15.8821 | 3001264.0 |
| 2013-05-24 10:40:00 | AAPL | Stock | 15.8754 | 15.8861 | 15.8607 | 15.8718 | 5428360.0 |
| 2013-05-24 10:45:00 | AAPL | Stock | 15.8743 | 15.8893 | 15.8464 | 15.8554 | 6544356.0 |
| 2013-05-24 10:50:00 | AAPL | Stock | 15.8568 | 15.875 | 15.8521 | 15.8707 | 3242456.0 |
| 2013-05-24 10:55:00 | AAPL | Stock | 15.8682 | 15.8929 | 15.8668 | 15.8929 | 3616984.0 |
> showing 50 of 322,957 rows — these rows as CSV