PREVIEW / stock_5min / 2013-09-05
file: by_date/stock_5min/2013/2013-09-05.parquet size: 5.0 MB rows: 335,215 symbols: 3,506
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-09-05 04:05:00 | AAPL | Stock | 17.9107 | 17.9107 | 17.9107 | 17.9107 | 2800.0 |
| 2013-09-05 04:10:00 | AAPL | Stock | 17.8986 | 17.8986 | 17.8607 | 17.8607 | 24220.0 |
| 2013-09-05 04:20:00 | AAPL | Stock | 17.8661 | 17.8661 | 17.8571 | 17.8571 | 25620.0 |
| 2013-09-05 04:30:00 | AAPL | Stock | 17.8757 | 17.8757 | 17.875 | 17.875 | 42000.0 |
| 2013-09-05 04:35:00 | AAPL | Stock | 17.875 | 17.875 | 17.875 | 17.875 | 27832.0 |
| 2013-09-05 04:40:00 | AAPL | Stock | 17.875 | 17.875 | 17.875 | 17.875 | 55664.0 |
| 2013-09-05 04:45:00 | AAPL | Stock | 17.875 | 17.875 | 17.875 | 17.875 | 18900.0 |
| 2013-09-05 05:10:00 | AAPL | Stock | 17.8929 | 17.8929 | 17.8929 | 17.8929 | 2800.0 |
| 2013-09-05 05:35:00 | AAPL | Stock | 17.8725 | 17.8725 | 17.8725 | 17.8725 | 2800.0 |
| 2013-09-05 05:45:00 | AAPL | Stock | 17.875 | 17.875 | 17.875 | 17.875 | 2800.0 |
| 2013-09-05 05:55:00 | AAPL | Stock | 17.8929 | 17.8929 | 17.8929 | 17.8929 | 5824.0 |
| 2013-09-05 06:00:00 | AAPL | Stock | 17.8607 | 17.8607 | 17.8607 | 17.8607 | 8400.0 |
| 2013-09-05 06:10:00 | AAPL | Stock | 17.8571 | 17.8571 | 17.8571 | 17.8571 | 2800.0 |
| 2013-09-05 06:40:00 | AAPL | Stock | 17.875 | 17.875 | 17.875 | 17.875 | 8428.0 |
| 2013-09-05 07:00:00 | AAPL | Stock | 17.875 | 17.9071 | 17.875 | 17.9071 | 96152.0 |
| 2013-09-05 07:05:00 | AAPL | Stock | 17.9054 | 17.9093 | 17.8929 | 17.8929 | 24864.0 |
| 2013-09-05 07:10:00 | AAPL | Stock | 17.8768 | 17.8768 | 17.8714 | 17.8714 | 8400.0 |
| 2013-09-05 07:15:00 | AAPL | Stock | 17.8629 | 17.8682 | 17.8607 | 17.8682 | 15512.0 |
| 2013-09-05 07:20:00 | AAPL | Stock | 17.8786 | 17.8929 | 17.875 | 17.875 | 61880.0 |
| 2013-09-05 07:25:00 | AAPL | Stock | 17.8918 | 17.8918 | 17.8857 | 17.8911 | 13384.0 |
| 2013-09-05 07:30:00 | AAPL | Stock | 17.8929 | 17.9018 | 17.8857 | 17.8857 | 74536.0 |
| 2013-09-05 07:35:00 | AAPL | Stock | 17.8929 | 17.8929 | 17.8929 | 17.8929 | 35000.0 |
| 2013-09-05 07:40:00 | AAPL | Stock | 17.8929 | 17.9093 | 17.8929 | 17.9093 | 29120.0 |
| 2013-09-05 07:45:00 | AAPL | Stock | 17.9107 | 17.9171 | 17.8954 | 17.9107 | 115360.0 |
| 2013-09-05 07:50:00 | AAPL | Stock | 17.9168 | 17.9204 | 17.9125 | 17.9125 | 15484.0 |
| 2013-09-05 07:55:00 | AAPL | Stock | 17.9161 | 17.9161 | 17.9 | 17.9 | 52304.0 |
| 2013-09-05 08:00:00 | AAPL | Stock | 17.9071 | 17.9204 | 17.8871 | 17.9057 | 422240.0 |
| 2013-09-05 08:05:00 | AAPL | Stock | 17.9061 | 17.9161 | 17.8946 | 17.8986 | 286944.0 |
| 2013-09-05 08:10:00 | AAPL | Stock | 17.9064 | 17.9064 | 17.8761 | 17.8786 | 282548.0 |
| 2013-09-05 08:15:00 | AAPL | Stock | 17.8911 | 17.9018 | 17.8814 | 17.8929 | 138880.0 |
| 2013-09-05 08:20:00 | AAPL | Stock | 17.8925 | 17.8929 | 17.8771 | 17.8879 | 42000.0 |
| 2013-09-05 08:25:00 | AAPL | Stock | 17.8889 | 17.9004 | 17.8857 | 17.8893 | 82712.0 |
| 2013-09-05 08:30:00 | AAPL | Stock | 17.8936 | 17.9057 | 17.8857 | 17.905 | 331212.0 |
| 2013-09-05 08:35:00 | AAPL | Stock | 17.9057 | 17.9057 | 17.8882 | 17.8943 | 128688.0 |
| 2013-09-05 08:40:00 | AAPL | Stock | 17.8979 | 17.8979 | 17.8861 | 17.8875 | 70000.0 |
| 2013-09-05 08:45:00 | AAPL | Stock | 17.8861 | 17.8861 | 17.8682 | 17.8829 | 166600.0 |
| 2013-09-05 08:50:00 | AAPL | Stock | 17.8804 | 17.8804 | 17.8682 | 17.8682 | 60788.0 |
| 2013-09-05 08:55:00 | AAPL | Stock | 17.8729 | 17.9096 | 17.8729 | 17.8929 | 196980.0 |
| 2013-09-05 09:00:00 | AAPL | Stock | 17.8939 | 17.9032 | 17.8757 | 17.8839 | 190120.0 |
| 2013-09-05 09:05:00 | AAPL | Stock | 17.8757 | 17.8814 | 17.8679 | 17.8711 | 73920.0 |
| 2013-09-05 09:10:00 | AAPL | Stock | 17.8668 | 17.8729 | 17.8646 | 17.8675 | 39340.0 |
| 2013-09-05 09:15:00 | AAPL | Stock | 17.8686 | 17.8704 | 17.8661 | 17.8664 | 42616.0 |
| 2013-09-05 09:20:00 | AAPL | Stock | 17.8704 | 17.8704 | 17.8586 | 17.8625 | 43456.0 |
| 2013-09-05 09:25:00 | AAPL | Stock | 17.8614 | 17.8796 | 17.8582 | 17.8796 | 136920.0 |
| 2013-09-05 09:30:00 | AAPL | Stock | 17.8671 | 17.8814 | 17.8107 | 17.8379 | 16058728.0 |
| 2013-09-05 09:35:00 | AAPL | Stock | 17.84 | 17.8457 | 17.7975 | 17.8071 | 11005148.0 |
| 2013-09-05 09:40:00 | AAPL | Stock | 17.8086 | 17.8171 | 17.7861 | 17.7957 | 4740064.0 |
| 2013-09-05 09:45:00 | AAPL | Stock | 17.7991 | 17.8246 | 17.7893 | 17.7957 | 6130768.0 |
| 2013-09-05 09:50:00 | AAPL | Stock | 17.7943 | 17.8014 | 17.7536 | 17.7568 | 8643460.0 |
| 2013-09-05 09:55:00 | AAPL | Stock | 17.7536 | 17.7729 | 17.7416 | 17.7679 | 9124136.0 |
> showing 50 of 335,215 rows — these rows as CSV