PREVIEW / stock_5min / 2012-01-05
file: by_date/stock_5min/2012/2012-01-05.parquet size: 4.8 MB rows: 322,405 symbols: 3,515
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-01-05 04:50:00 | AAPL | Stock | 14.7504 | 14.7504 | 14.7504 | 14.7504 | 5600.0 |
| 2012-01-05 05:05:00 | AAPL | Stock | 14.7339 | 14.7339 | 14.7321 | 14.7321 | 31220.0 |
| 2012-01-05 05:20:00 | AAPL | Stock | 14.7321 | 14.7321 | 14.7321 | 14.7321 | 25200.0 |
| 2012-01-05 05:40:00 | AAPL | Stock | 14.7321 | 14.7321 | 14.7321 | 14.7321 | 2800.0 |
| 2012-01-05 05:55:00 | AAPL | Stock | 14.7143 | 14.7143 | 14.7143 | 14.7143 | 2800.0 |
| 2012-01-05 06:00:00 | AAPL | Stock | 14.7143 | 14.7143 | 14.7 | 14.7 | 18200.0 |
| 2012-01-05 06:15:00 | AAPL | Stock | 14.7143 | 14.7143 | 14.7143 | 14.7143 | 5600.0 |
| 2012-01-05 06:35:00 | AAPL | Stock | 14.6982 | 14.6982 | 14.6982 | 14.6982 | 2800.0 |
| 2012-01-05 06:40:00 | AAPL | Stock | 14.6964 | 14.6964 | 14.6786 | 14.6786 | 14000.0 |
| 2012-01-05 06:50:00 | AAPL | Stock | 14.6971 | 14.6971 | 14.6971 | 14.6971 | 5600.0 |
| 2012-01-05 07:00:00 | AAPL | Stock | 14.7054 | 14.725 | 14.7054 | 14.725 | 15680.0 |
| 2012-01-05 07:10:00 | AAPL | Stock | 14.7271 | 14.7286 | 14.7271 | 14.7279 | 16800.0 |
| 2012-01-05 07:15:00 | AAPL | Stock | 14.7325 | 14.7364 | 14.7193 | 14.7193 | 55636.0 |
| 2012-01-05 07:25:00 | AAPL | Stock | 14.7257 | 14.7257 | 14.7257 | 14.7257 | 2800.0 |
| 2012-01-05 07:30:00 | AAPL | Stock | 14.7432 | 14.7436 | 14.7432 | 14.7436 | 11340.0 |
| 2012-01-05 07:35:00 | AAPL | Stock | 14.7486 | 14.7582 | 14.7464 | 14.7582 | 11340.0 |
| 2012-01-05 07:40:00 | AAPL | Stock | 14.7546 | 14.7571 | 14.7546 | 14.7571 | 8400.0 |
| 2012-01-05 07:45:00 | AAPL | Stock | 14.7507 | 14.7654 | 14.75 | 14.7654 | 122752.0 |
| 2012-01-05 07:50:00 | AAPL | Stock | 14.7554 | 14.7761 | 14.7554 | 14.7761 | 47600.0 |
| 2012-01-05 07:55:00 | AAPL | Stock | 14.7721 | 14.775 | 14.7704 | 14.7704 | 131600.0 |
| 2012-01-05 08:00:00 | AAPL | Stock | 14.7743 | 14.7757 | 14.7429 | 14.7429 | 269276.0 |
| 2012-01-05 08:05:00 | AAPL | Stock | 14.7429 | 14.75 | 14.7429 | 14.75 | 81144.0 |
| 2012-01-05 08:10:00 | AAPL | Stock | 14.7468 | 14.7493 | 14.7411 | 14.7493 | 34860.0 |
| 2012-01-05 08:15:00 | AAPL | Stock | 14.7582 | 14.7929 | 14.7382 | 14.7768 | 555240.0 |
| 2012-01-05 08:20:00 | AAPL | Stock | 14.7804 | 14.7961 | 14.7768 | 14.7961 | 91336.0 |
| 2012-01-05 08:25:00 | AAPL | Stock | 14.7929 | 14.8143 | 14.7929 | 14.8139 | 527072.0 |
| 2012-01-05 08:30:00 | AAPL | Stock | 14.8104 | 14.8207 | 14.7982 | 14.8004 | 329224.0 |
| 2012-01-05 08:35:00 | AAPL | Stock | 14.8018 | 14.8204 | 14.8018 | 14.8189 | 183820.0 |
| 2012-01-05 08:40:00 | AAPL | Stock | 14.8193 | 14.8364 | 14.8193 | 14.8236 | 307720.0 |
| 2012-01-05 08:45:00 | AAPL | Stock | 14.8236 | 14.8311 | 14.8218 | 14.8239 | 278152.0 |
| 2012-01-05 08:50:00 | AAPL | Stock | 14.8239 | 14.8332 | 14.8171 | 14.8193 | 188720.0 |
| 2012-01-05 08:55:00 | AAPL | Stock | 14.8207 | 14.8207 | 14.8132 | 14.8204 | 73164.0 |
| 2012-01-05 09:00:00 | AAPL | Stock | 14.8129 | 14.8161 | 14.8093 | 14.8111 | 89852.0 |
| 2012-01-05 09:05:00 | AAPL | Stock | 14.8093 | 14.8114 | 14.8046 | 14.8082 | 108388.0 |
| 2012-01-05 09:10:00 | AAPL | Stock | 14.8057 | 14.8089 | 14.7986 | 14.8057 | 257488.0 |
| 2012-01-05 09:15:00 | AAPL | Stock | 14.8075 | 14.8175 | 14.8061 | 14.8171 | 93800.0 |
| 2012-01-05 09:20:00 | AAPL | Stock | 14.8164 | 14.8193 | 14.8125 | 14.8168 | 56420.0 |
| 2012-01-05 09:25:00 | AAPL | Stock | 14.8143 | 14.825 | 14.8071 | 14.815 | 368172.0 |
| 2012-01-05 09:30:00 | AAPL | Stock | 14.8193 | 14.8214 | 14.7786 | 14.8132 | 12417748.0 |
| 2012-01-05 09:35:00 | AAPL | Stock | 14.8139 | 14.8436 | 14.8046 | 14.8211 | 10646440.0 |
| 2012-01-05 09:40:00 | AAPL | Stock | 14.8204 | 14.8204 | 14.7607 | 14.7714 | 11094804.0 |
| 2012-01-05 09:45:00 | AAPL | Stock | 14.7729 | 14.7746 | 14.7382 | 14.7664 | 7481852.0 |
| 2012-01-05 09:50:00 | AAPL | Stock | 14.7661 | 14.8086 | 14.7646 | 14.7964 | 6788180.0 |
| 2012-01-05 09:55:00 | AAPL | Stock | 14.7964 | 14.8064 | 14.7811 | 14.8046 | 4062268.0 |
| 2012-01-05 10:00:00 | AAPL | Stock | 14.8036 | 14.8086 | 14.7857 | 14.795 | 5292504.0 |
| 2012-01-05 10:05:00 | AAPL | Stock | 14.7914 | 14.8086 | 14.7821 | 14.8022 | 3915940.0 |
| 2012-01-05 10:10:00 | AAPL | Stock | 14.8037 | 14.8057 | 14.7921 | 14.8004 | 2051812.0 |
| 2012-01-05 10:15:00 | AAPL | Stock | 14.7993 | 14.8321 | 14.7986 | 14.8121 | 5057892.0 |
| 2012-01-05 10:20:00 | AAPL | Stock | 14.8129 | 14.8171 | 14.8036 | 14.8128 | 3264716.0 |
| 2012-01-05 10:25:00 | AAPL | Stock | 14.8096 | 14.8346 | 14.8093 | 14.8132 | 4405716.0 |
> showing 50 of 322,405 rows — these rows as CSV