PREVIEW / stock_5min / 2012-03-13
file: by_date/stock_5min/2012/2012-03-13.parquet size: 5.0 MB rows: 333,090 symbols: 3,532
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-03-13 04:00:00 | AAPL | Stock | 19.7357 | 19.7357 | 19.7357 | 19.7357 | 2800.0 |
| 2012-03-13 04:10:00 | AAPL | Stock | 19.8236 | 19.8236 | 19.8107 | 19.8107 | 22400.0 |
| 2012-03-13 04:15:00 | AAPL | Stock | 19.8221 | 19.8232 | 19.8221 | 19.8229 | 24920.0 |
| 2012-03-13 04:20:00 | AAPL | Stock | 19.8339 | 19.8339 | 19.8339 | 19.8339 | 2800.0 |
| 2012-03-13 04:30:00 | AAPL | Stock | 19.8321 | 19.8329 | 19.8321 | 19.8329 | 28000.0 |
| 2012-03-13 04:45:00 | AAPL | Stock | 19.8329 | 19.8329 | 19.8329 | 19.8329 | 8400.0 |
| 2012-03-13 04:50:00 | AAPL | Stock | 19.8393 | 19.8393 | 19.8393 | 19.8393 | 5600.0 |
| 2012-03-13 04:55:00 | AAPL | Stock | 19.8393 | 19.8393 | 19.8393 | 19.8393 | 8400.0 |
| 2012-03-13 05:05:00 | AAPL | Stock | 19.85 | 19.85 | 19.85 | 19.85 | 2800.0 |
| 2012-03-13 05:10:00 | AAPL | Stock | 19.8393 | 19.8393 | 19.8393 | 19.8393 | 2800.0 |
| 2012-03-13 05:15:00 | AAPL | Stock | 19.8393 | 19.8393 | 19.8393 | 19.8393 | 5600.0 |
| 2012-03-13 05:35:00 | AAPL | Stock | 19.85 | 19.85 | 19.85 | 19.85 | 8652.0 |
| 2012-03-13 05:40:00 | AAPL | Stock | 19.85 | 19.85 | 19.85 | 19.85 | 2800.0 |
| 2012-03-13 06:00:00 | AAPL | Stock | 19.8571 | 19.8571 | 19.8571 | 19.8571 | 14000.0 |
| 2012-03-13 06:05:00 | AAPL | Stock | 19.8679 | 19.8679 | 19.8679 | 19.8679 | 2800.0 |
| 2012-03-13 06:10:00 | AAPL | Stock | 19.8679 | 19.8679 | 19.8679 | 19.8679 | 2800.0 |
| 2012-03-13 06:20:00 | AAPL | Stock | 19.8571 | 19.8571 | 19.8571 | 19.8571 | 28000.0 |
| 2012-03-13 06:25:00 | AAPL | Stock | 19.8571 | 19.8571 | 19.8571 | 19.8571 | 11200.0 |
| 2012-03-13 06:45:00 | AAPL | Stock | 19.8679 | 19.8682 | 19.8679 | 19.8682 | 7420.0 |
| 2012-03-13 06:50:00 | AAPL | Stock | 19.8682 | 19.8682 | 19.8682 | 19.8682 | 12460.0 |
| 2012-03-13 06:55:00 | AAPL | Stock | 19.8571 | 19.8571 | 19.8571 | 19.8571 | 30800.0 |
| 2012-03-13 07:00:00 | AAPL | Stock | 19.8436 | 19.8643 | 19.8393 | 19.8643 | 201824.0 |
| 2012-03-13 07:05:00 | AAPL | Stock | 19.8575 | 19.8732 | 19.8571 | 19.8657 | 95704.0 |
| 2012-03-13 07:10:00 | AAPL | Stock | 19.8736 | 19.8754 | 19.8736 | 19.875 | 27972.0 |
| 2012-03-13 07:15:00 | AAPL | Stock | 19.8746 | 19.875 | 19.8661 | 19.8661 | 50400.0 |
| 2012-03-13 07:20:00 | AAPL | Stock | 19.8661 | 19.8661 | 19.8589 | 19.8661 | 36400.0 |
| 2012-03-13 07:25:00 | AAPL | Stock | 19.8643 | 19.875 | 19.8618 | 19.8732 | 30800.0 |
| 2012-03-13 07:30:00 | AAPL | Stock | 19.8739 | 19.8943 | 19.8739 | 19.8829 | 234444.0 |
| 2012-03-13 07:35:00 | AAPL | Stock | 19.8921 | 19.8939 | 19.8921 | 19.8939 | 53284.0 |
| 2012-03-13 07:40:00 | AAPL | Stock | 19.8929 | 19.8979 | 19.8857 | 19.8929 | 174384.0 |
| 2012-03-13 07:45:00 | AAPL | Stock | 19.8893 | 19.9036 | 19.8796 | 19.8929 | 186368.0 |
| 2012-03-13 07:50:00 | AAPL | Stock | 19.8996 | 19.9007 | 19.8921 | 19.8925 | 84000.0 |
| 2012-03-13 07:55:00 | AAPL | Stock | 19.8975 | 19.8975 | 19.8864 | 19.8893 | 58996.0 |
| 2012-03-13 08:00:00 | AAPL | Stock | 19.8868 | 19.9196 | 19.8743 | 19.9089 | 1070776.0 |
| 2012-03-13 08:05:00 | AAPL | Stock | 19.91 | 19.9136 | 19.8929 | 19.9 | 619136.0 |
| 2012-03-13 08:10:00 | AAPL | Stock | 19.8961 | 19.9054 | 19.8896 | 19.9018 | 144200.0 |
| 2012-03-13 08:15:00 | AAPL | Stock | 19.8982 | 19.9004 | 19.8857 | 19.8964 | 191240.0 |
| 2012-03-13 08:20:00 | AAPL | Stock | 19.8964 | 19.8993 | 19.8918 | 19.8932 | 57680.0 |
| 2012-03-13 08:25:00 | AAPL | Stock | 19.8954 | 19.8954 | 19.8821 | 19.8929 | 188888.0 |
| 2012-03-13 08:30:00 | AAPL | Stock | 19.8961 | 19.8982 | 19.8879 | 19.8982 | 177884.0 |
| 2012-03-13 08:35:00 | AAPL | Stock | 19.8964 | 19.9021 | 19.8875 | 19.8893 | 217728.0 |
| 2012-03-13 08:40:00 | AAPL | Stock | 19.8893 | 19.8964 | 19.8857 | 19.895 | 190652.0 |
| 2012-03-13 08:45:00 | AAPL | Stock | 19.8939 | 19.8975 | 19.8875 | 19.8875 | 256900.0 |
| 2012-03-13 08:50:00 | AAPL | Stock | 19.8875 | 19.8918 | 19.8832 | 19.8843 | 352044.0 |
| 2012-03-13 08:55:00 | AAPL | Stock | 19.8846 | 19.8857 | 19.8757 | 19.8829 | 225288.0 |
| 2012-03-13 09:00:00 | AAPL | Stock | 19.88 | 19.8882 | 19.875 | 19.8821 | 383964.0 |
| 2012-03-13 09:05:00 | AAPL | Stock | 19.8821 | 19.9 | 19.8821 | 19.895 | 644420.0 |
| 2012-03-13 09:10:00 | AAPL | Stock | 19.8986 | 19.9089 | 19.8936 | 19.9029 | 383796.0 |
| 2012-03-13 09:15:00 | AAPL | Stock | 19.9029 | 19.9029 | 19.8846 | 19.8907 | 461160.0 |
| 2012-03-13 09:20:00 | AAPL | Stock | 19.8914 | 19.9071 | 19.8914 | 19.9025 | 361760.0 |
> showing 50 of 333,090 rows — these rows as CSV