PREVIEW / stock_5min / 2009-06-17
file: by_date/stock_5min/2009/2009-06-17.parquet size: 4.6 MB rows: 318,223 symbols: 3,329
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 |
|---|---|---|---|---|---|---|---|
| 2009-06-17 05:55:00 | AAPL | Stock | 4.8636 | 4.8636 | 4.8636 | 4.8636 | 16800.0 |
| 2009-06-17 06:45:00 | AAPL | Stock | 4.8536 | 4.8536 | 4.8536 | 4.8536 | 5600.0 |
| 2009-06-17 07:00:00 | AAPL | Stock | 4.8571 | 4.8607 | 4.8571 | 4.8607 | 14000.0 |
| 2009-06-17 07:05:00 | AAPL | Stock | 4.8643 | 4.8643 | 4.8643 | 4.8643 | 5880.0 |
| 2009-06-17 07:15:00 | AAPL | Stock | 4.8768 | 4.8768 | 4.8768 | 4.8768 | 11200.0 |
| 2009-06-17 07:30:00 | AAPL | Stock | 4.8804 | 4.8804 | 4.8804 | 4.8804 | 4340.0 |
| 2009-06-17 07:35:00 | AAPL | Stock | 4.8818 | 4.8854 | 4.88 | 4.8832 | 70280.0 |
| 2009-06-17 07:45:00 | AAPL | Stock | 4.8696 | 4.8696 | 4.8696 | 4.8696 | 5348.0 |
| 2009-06-17 07:55:00 | AAPL | Stock | 4.8661 | 4.8661 | 4.8571 | 4.8571 | 72800.0 |
| 2009-06-17 08:00:00 | AAPL | Stock | 4.8679 | 4.8746 | 4.8607 | 4.8607 | 96348.0 |
| 2009-06-17 08:05:00 | AAPL | Stock | 4.8643 | 4.8679 | 4.8618 | 4.8679 | 31192.0 |
| 2009-06-17 08:15:00 | AAPL | Stock | 4.8643 | 4.8714 | 4.8643 | 4.8714 | 30800.0 |
| 2009-06-17 08:25:00 | AAPL | Stock | 4.8714 | 4.875 | 4.8714 | 4.875 | 39760.0 |
| 2009-06-17 08:30:00 | AAPL | Stock | 4.8768 | 4.8839 | 4.875 | 4.875 | 33600.0 |
| 2009-06-17 08:35:00 | AAPL | Stock | 4.8786 | 4.8821 | 4.8786 | 4.8821 | 28000.0 |
| 2009-06-17 08:40:00 | AAPL | Stock | 4.8821 | 4.8832 | 4.8821 | 4.8832 | 35028.0 |
| 2009-06-17 08:45:00 | AAPL | Stock | 4.8832 | 4.8854 | 4.8832 | 4.8843 | 90664.0 |
| 2009-06-17 08:50:00 | AAPL | Stock | 4.8857 | 4.8893 | 4.8857 | 4.8886 | 16800.0 |
| 2009-06-17 08:55:00 | AAPL | Stock | 4.8882 | 4.8968 | 4.8857 | 4.8968 | 129976.0 |
| 2009-06-17 09:00:00 | AAPL | Stock | 4.8929 | 4.8964 | 4.8875 | 4.8886 | 248052.0 |
| 2009-06-17 09:05:00 | AAPL | Stock | 4.8879 | 4.8879 | 4.8696 | 4.875 | 355852.0 |
| 2009-06-17 09:10:00 | AAPL | Stock | 4.8714 | 4.875 | 4.8704 | 4.875 | 185780.0 |
| 2009-06-17 09:15:00 | AAPL | Stock | 4.875 | 4.875 | 4.875 | 4.875 | 53200.0 |
| 2009-06-17 09:20:00 | AAPL | Stock | 4.875 | 4.875 | 4.8746 | 4.875 | 45360.0 |
| 2009-06-17 09:25:00 | AAPL | Stock | 4.875 | 4.8907 | 4.8746 | 4.8793 | 781760.0 |
| 2009-06-17 09:30:00 | AAPL | Stock | 4.8796 | 4.9089 | 4.8343 | 4.8454 | 30613296.0 |
| 2009-06-17 09:35:00 | AAPL | Stock | 4.8454 | 4.8679 | 4.8286 | 4.8371 | 20103608.0 |
| 2009-06-17 09:40:00 | AAPL | Stock | 4.8375 | 4.8386 | 4.8196 | 4.8336 | 17811836.0 |
| 2009-06-17 09:45:00 | AAPL | Stock | 4.8318 | 4.8554 | 4.825 | 4.8257 | 14050232.0 |
| 2009-06-17 09:50:00 | AAPL | Stock | 4.8254 | 4.8464 | 4.8254 | 4.8296 | 11913860.0 |
| 2009-06-17 09:55:00 | AAPL | Stock | 4.8296 | 4.8325 | 4.8046 | 4.8104 | 18811632.0 |
| 2009-06-17 10:00:00 | AAPL | Stock | 4.8104 | 4.8357 | 4.8075 | 4.835 | 9122736.0 |
| 2009-06-17 10:05:00 | AAPL | Stock | 4.8343 | 4.8639 | 4.8321 | 4.8507 | 12775028.0 |
| 2009-06-17 10:10:00 | AAPL | Stock | 4.8504 | 4.8611 | 4.8489 | 4.8575 | 10648120.0 |
| 2009-06-17 10:15:00 | AAPL | Stock | 4.8586 | 4.87 | 4.8521 | 4.8561 | 9711520.0 |
| 2009-06-17 10:20:00 | AAPL | Stock | 4.8568 | 4.8646 | 4.8418 | 4.8418 | 7841764.0 |
| 2009-06-17 10:25:00 | AAPL | Stock | 4.8414 | 4.85 | 4.835 | 4.8496 | 7765352.0 |
| 2009-06-17 10:30:00 | AAPL | Stock | 4.8489 | 4.8496 | 4.8336 | 4.8345 | 8118180.0 |
| 2009-06-17 10:35:00 | AAPL | Stock | 4.8346 | 4.8361 | 4.8214 | 4.8246 | 8135988.0 |
| 2009-06-17 10:40:00 | AAPL | Stock | 4.8246 | 4.8371 | 4.8075 | 4.8075 | 8641192.0 |
| 2009-06-17 10:45:00 | AAPL | Stock | 4.8082 | 4.8325 | 4.8079 | 4.8286 | 5843236.0 |
| 2009-06-17 10:50:00 | AAPL | Stock | 4.8289 | 4.8425 | 4.825 | 4.8414 | 4761400.0 |
| 2009-06-17 10:55:00 | AAPL | Stock | 4.8414 | 4.8443 | 4.8329 | 4.8368 | 6015212.0 |
| 2009-06-17 11:00:00 | AAPL | Stock | 4.8364 | 4.8529 | 4.8346 | 4.8468 | 7447776.0 |
| 2009-06-17 11:05:00 | AAPL | Stock | 4.8466 | 4.8568 | 4.8454 | 4.8511 | 5028436.0 |
| 2009-06-17 11:10:00 | AAPL | Stock | 4.8504 | 4.8596 | 4.8439 | 4.8457 | 7754460.0 |
| 2009-06-17 11:15:00 | AAPL | Stock | 4.8457 | 4.8782 | 4.8454 | 4.8771 | 9708776.0 |
| 2009-06-17 11:20:00 | AAPL | Stock | 4.8771 | 4.8892 | 4.8768 | 4.8793 | 10720416.0 |
| 2009-06-17 11:25:00 | AAPL | Stock | 4.88 | 4.8868 | 4.8764 | 4.8779 | 6300476.0 |
| 2009-06-17 11:30:00 | AAPL | Stock | 4.8793 | 4.8793 | 4.8593 | 4.8621 | 7387632.0 |
> showing 50 of 318,223 rows — these rows as CSV