PREVIEW / stock_5min / 2011-06-09
file: by_date/stock_5min/2011/2011-06-09.parquet size: 4.8 MB rows: 330,001 symbols: 3,550
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 |
|---|---|---|---|---|---|---|---|
| 2011-06-09 04:05:00 | AAPL | Stock | 11.9054 | 11.9125 | 11.9054 | 11.9125 | 11200.0 |
| 2011-06-09 04:55:00 | AAPL | Stock | 11.91 | 11.91 | 11.91 | 11.91 | 2800.0 |
| 2011-06-09 06:40:00 | AAPL | Stock | 11.9054 | 11.9054 | 11.9054 | 11.9054 | 5600.0 |
| 2011-06-09 07:00:00 | AAPL | Stock | 11.8929 | 11.8929 | 11.8929 | 11.8929 | 2800.0 |
| 2011-06-09 07:40:00 | AAPL | Stock | 11.8896 | 11.8929 | 11.8896 | 11.8929 | 8400.0 |
| 2011-06-09 07:55:00 | AAPL | Stock | 11.8929 | 11.8929 | 11.8929 | 11.8929 | 19600.0 |
| 2011-06-09 08:00:00 | AAPL | Stock | 11.8911 | 11.8996 | 11.8911 | 11.8964 | 73500.0 |
| 2011-06-09 08:05:00 | AAPL | Stock | 11.8989 | 11.8993 | 11.8893 | 11.8893 | 37576.0 |
| 2011-06-09 08:10:00 | AAPL | Stock | 11.8893 | 11.8893 | 11.8893 | 11.8893 | 4200.0 |
| 2011-06-09 08:15:00 | AAPL | Stock | 11.8871 | 11.8871 | 11.875 | 11.875 | 49084.0 |
| 2011-06-09 08:20:00 | AAPL | Stock | 11.8761 | 11.8911 | 11.8761 | 11.8911 | 71960.0 |
| 2011-06-09 08:25:00 | AAPL | Stock | 11.8793 | 11.8807 | 11.8786 | 11.88 | 44800.0 |
| 2011-06-09 08:30:00 | AAPL | Stock | 11.8793 | 11.9054 | 11.8571 | 11.9011 | 275688.0 |
| 2011-06-09 08:35:00 | AAPL | Stock | 11.9011 | 11.9025 | 11.8832 | 11.8893 | 301924.0 |
| 2011-06-09 08:40:00 | AAPL | Stock | 11.8871 | 11.8929 | 11.875 | 11.8846 | 111916.0 |
| 2011-06-09 08:45:00 | AAPL | Stock | 11.8857 | 11.8889 | 11.8607 | 11.875 | 185052.0 |
| 2011-06-09 08:50:00 | AAPL | Stock | 11.8725 | 11.8825 | 11.8725 | 11.8757 | 174188.0 |
| 2011-06-09 08:55:00 | AAPL | Stock | 11.8814 | 11.8857 | 11.8814 | 11.8825 | 26600.0 |
| 2011-06-09 09:00:00 | AAPL | Stock | 11.8893 | 11.8929 | 11.8829 | 11.8929 | 46760.0 |
| 2011-06-09 09:05:00 | AAPL | Stock | 11.8932 | 11.8996 | 11.8818 | 11.8818 | 148456.0 |
| 2011-06-09 09:10:00 | AAPL | Stock | 11.8854 | 11.8929 | 11.8854 | 11.8921 | 36400.0 |
| 2011-06-09 09:15:00 | AAPL | Stock | 11.8918 | 11.8921 | 11.8911 | 11.8918 | 34048.0 |
| 2011-06-09 09:20:00 | AAPL | Stock | 11.885 | 11.8886 | 11.875 | 11.8857 | 74536.0 |
| 2011-06-09 09:25:00 | AAPL | Stock | 11.8821 | 11.9011 | 11.8821 | 11.8989 | 333788.0 |
| 2011-06-09 09:30:00 | AAPL | Stock | 11.9014 | 11.9025 | 11.8364 | 11.8489 | 10980648.0 |
| 2011-06-09 09:35:00 | AAPL | Stock | 11.8468 | 11.8718 | 11.84 | 11.8614 | 8854636.0 |
| 2011-06-09 09:40:00 | AAPL | Stock | 11.8607 | 11.8868 | 11.8279 | 11.8289 | 7442904.0 |
| 2011-06-09 09:45:00 | AAPL | Stock | 11.8289 | 11.8621 | 11.825 | 11.8486 | 6401808.0 |
| 2011-06-09 09:50:00 | AAPL | Stock | 11.8429 | 11.8571 | 11.8125 | 11.8561 | 10538108.0 |
| 2011-06-09 09:55:00 | AAPL | Stock | 11.8529 | 11.8821 | 11.8514 | 11.8774 | 8391964.0 |
| 2011-06-09 10:00:00 | AAPL | Stock | 11.8779 | 11.8779 | 11.8468 | 11.8521 | 5581632.0 |
| 2011-06-09 10:05:00 | AAPL | Stock | 11.8514 | 11.8546 | 11.8196 | 11.8379 | 7552636.0 |
| 2011-06-09 10:10:00 | AAPL | Stock | 11.8371 | 11.8732 | 11.8307 | 11.8521 | 6069028.0 |
| 2011-06-09 10:15:00 | AAPL | Stock | 11.8522 | 11.8639 | 11.8436 | 11.8446 | 3788288.0 |
| 2011-06-09 10:20:00 | AAPL | Stock | 11.8457 | 11.8457 | 11.8179 | 11.8182 | 6198864.0 |
| 2011-06-09 10:25:00 | AAPL | Stock | 11.8193 | 11.8421 | 11.8143 | 11.8382 | 4384212.0 |
| 2011-06-09 10:30:00 | AAPL | Stock | 11.838 | 11.8729 | 11.8368 | 11.8564 | 6903848.0 |
| 2011-06-09 10:35:00 | AAPL | Stock | 11.8568 | 11.8693 | 11.8429 | 11.854 | 3141096.0 |
| 2011-06-09 10:40:00 | AAPL | Stock | 11.8546 | 11.855 | 11.835 | 11.8357 | 3545780.0 |
| 2011-06-09 10:45:00 | AAPL | Stock | 11.835 | 11.8454 | 11.8289 | 11.8429 | 2587956.0 |
| 2011-06-09 10:50:00 | AAPL | Stock | 11.8443 | 11.8504 | 11.8214 | 11.8335 | 3790332.0 |
| 2011-06-09 10:55:00 | AAPL | Stock | 11.8339 | 11.8643 | 11.8294 | 11.8568 | 4905796.0 |
| 2011-06-09 11:00:00 | AAPL | Stock | 11.8561 | 11.8954 | 11.8521 | 11.8728 | 8606276.0 |
| 2011-06-09 11:05:00 | AAPL | Stock | 11.8725 | 11.8914 | 11.8536 | 11.8536 | 4390652.0 |
| 2011-06-09 11:10:00 | AAPL | Stock | 11.855 | 11.8639 | 11.85 | 11.8514 | 2340128.0 |
| 2011-06-09 11:15:00 | AAPL | Stock | 11.8543 | 11.8589 | 11.8454 | 11.8511 | 1787800.0 |
| 2011-06-09 11:20:00 | AAPL | Stock | 11.8483 | 11.8632 | 11.84 | 11.8421 | 2131192.0 |
| 2011-06-09 11:25:00 | AAPL | Stock | 11.84 | 11.8471 | 11.8304 | 11.843 | 2264444.0 |
| 2011-06-09 11:30:00 | AAPL | Stock | 11.8404 | 11.8591 | 11.8393 | 11.8486 | 1897952.0 |
| 2011-06-09 11:35:00 | AAPL | Stock | 11.8482 | 11.8571 | 11.8425 | 11.8443 | 1448916.0 |
> showing 50 of 330,001 rows — these rows as CSV