PREVIEW / stock_1min / 2009-06-25
file: by_date/stock_1min/2009/2009-06-25.parquet size: 13.1 MB rows: 1,003,259 symbols: 2,726
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-25 05:58:00 | AAPL | Stock | 4.8868 | 4.8868 | 4.8868 | 4.8868 | 14000.0 |
| 2009-06-25 06:16:00 | AAPL | Stock | 4.8943 | 4.8943 | 4.8943 | 4.8943 | 14000.0 |
| 2009-06-25 06:22:00 | AAPL | Stock | 4.9025 | 4.9025 | 4.9025 | 4.9025 | 14000.0 |
| 2009-06-25 07:01:00 | AAPL | Stock | 4.8857 | 4.8857 | 4.8857 | 4.8857 | 2800.0 |
| 2009-06-25 07:33:00 | AAPL | Stock | 4.8911 | 4.9 | 4.8911 | 4.9 | 11200.0 |
| 2009-06-25 07:34:00 | AAPL | Stock | 4.9054 | 4.9054 | 4.8929 | 4.9 | 11200.0 |
| 2009-06-25 07:37:00 | AAPL | Stock | 4.8893 | 4.8893 | 4.8893 | 4.8893 | 5600.0 |
| 2009-06-25 07:39:00 | AAPL | Stock | 4.9 | 4.9 | 4.8946 | 4.9 | 36400.0 |
| 2009-06-25 07:41:00 | AAPL | Stock | 4.9 | 4.9 | 4.9 | 4.9 | 2800.0 |
| 2009-06-25 07:47:00 | AAPL | Stock | 4.8996 | 4.8996 | 4.8996 | 4.8996 | 2800.0 |
| 2009-06-25 07:48:00 | AAPL | Stock | 4.8996 | 4.8996 | 4.8996 | 4.8996 | 2800.0 |
| 2009-06-25 07:49:00 | AAPL | Stock | 4.9032 | 4.9032 | 4.9032 | 4.9032 | 2800.0 |
| 2009-06-25 07:50:00 | AAPL | Stock | 4.9036 | 4.9036 | 4.9036 | 4.9036 | 2800.0 |
| 2009-06-25 07:52:00 | AAPL | Stock | 4.8964 | 4.8964 | 4.8964 | 4.8964 | 5600.0 |
| 2009-06-25 07:54:00 | AAPL | Stock | 4.8964 | 4.8964 | 4.8932 | 4.8932 | 5600.0 |
| 2009-06-25 07:55:00 | AAPL | Stock | 4.9021 | 4.9021 | 4.9021 | 4.9021 | 2800.0 |
| 2009-06-25 07:59:00 | AAPL | Stock | 4.8993 | 4.8993 | 4.8993 | 4.8993 | 28000.0 |
| 2009-06-25 08:00:00 | AAPL | Stock | 4.8936 | 4.8979 | 4.8929 | 4.8957 | 42000.0 |
| 2009-06-25 08:01:00 | AAPL | Stock | 4.8929 | 4.8929 | 4.8893 | 4.8896 | 70700.0 |
| 2009-06-25 08:03:00 | AAPL | Stock | 4.8896 | 4.8896 | 4.8857 | 4.8857 | 57680.0 |
| 2009-06-25 08:04:00 | AAPL | Stock | 4.8864 | 4.8864 | 4.8829 | 4.8829 | 33600.0 |
| 2009-06-25 08:05:00 | AAPL | Stock | 4.8854 | 4.8854 | 4.8811 | 4.8811 | 22400.0 |
| 2009-06-25 08:06:00 | AAPL | Stock | 4.8818 | 4.8818 | 4.8818 | 4.8818 | 2800.0 |
| 2009-06-25 08:07:00 | AAPL | Stock | 4.8814 | 4.8814 | 4.8796 | 4.8796 | 8680.0 |
| 2009-06-25 08:08:00 | AAPL | Stock | 4.8793 | 4.8821 | 4.8793 | 4.8811 | 37632.0 |
| 2009-06-25 08:09:00 | AAPL | Stock | 4.8807 | 4.8807 | 4.875 | 4.8768 | 46480.0 |
| 2009-06-25 08:10:00 | AAPL | Stock | 4.875 | 4.8757 | 4.875 | 4.8757 | 9492.0 |
| 2009-06-25 08:11:00 | AAPL | Stock | 4.875 | 4.8761 | 4.875 | 4.8761 | 5600.0 |
| 2009-06-25 08:12:00 | AAPL | Stock | 4.8768 | 4.8796 | 4.875 | 4.8796 | 98000.0 |
| 2009-06-25 08:13:00 | AAPL | Stock | 4.8804 | 4.8811 | 4.8804 | 4.8811 | 5600.0 |
| 2009-06-25 08:15:00 | AAPL | Stock | 4.8804 | 4.8829 | 4.8804 | 4.8829 | 30100.0 |
| 2009-06-25 08:16:00 | AAPL | Stock | 4.8832 | 4.8832 | 4.8821 | 4.8821 | 58800.0 |
| 2009-06-25 08:17:00 | AAPL | Stock | 4.8818 | 4.8832 | 4.8818 | 4.8832 | 8400.0 |
| 2009-06-25 08:19:00 | AAPL | Stock | 4.8846 | 4.8846 | 4.8839 | 4.8839 | 5600.0 |
| 2009-06-25 08:20:00 | AAPL | Stock | 4.8832 | 4.8832 | 4.8829 | 4.8829 | 5600.0 |
| 2009-06-25 08:21:00 | AAPL | Stock | 4.8825 | 4.8825 | 4.8818 | 4.8821 | 27300.0 |
| 2009-06-25 08:22:00 | AAPL | Stock | 4.8811 | 4.8811 | 4.8793 | 4.8793 | 46200.0 |
| 2009-06-25 08:25:00 | AAPL | Stock | 4.8811 | 4.8811 | 4.8811 | 4.8811 | 2800.0 |
| 2009-06-25 08:26:00 | AAPL | Stock | 4.8804 | 4.8804 | 4.8793 | 4.8793 | 12600.0 |
| 2009-06-25 08:27:00 | AAPL | Stock | 4.8768 | 4.8768 | 4.8768 | 4.8768 | 19600.0 |
| 2009-06-25 08:28:00 | AAPL | Stock | 4.8782 | 4.8782 | 4.8782 | 4.8782 | 7000.0 |
| 2009-06-25 08:29:00 | AAPL | Stock | 4.8786 | 4.8786 | 4.8768 | 4.8768 | 18900.0 |
| 2009-06-25 08:30:00 | AAPL | Stock | 4.8786 | 4.8786 | 4.8696 | 4.8696 | 25200.0 |
| 2009-06-25 08:31:00 | AAPL | Stock | 4.8689 | 4.8689 | 4.8686 | 4.8686 | 33600.0 |
| 2009-06-25 08:32:00 | AAPL | Stock | 4.865 | 4.865 | 4.8614 | 4.8614 | 11200.0 |
| 2009-06-25 08:33:00 | AAPL | Stock | 4.8639 | 4.8639 | 4.8571 | 4.8571 | 43260.0 |
| 2009-06-25 08:34:00 | AAPL | Stock | 4.8507 | 4.8571 | 4.8507 | 4.8568 | 39200.0 |
| 2009-06-25 08:35:00 | AAPL | Stock | 4.8546 | 4.8571 | 4.8536 | 4.8543 | 59444.0 |
| 2009-06-25 08:36:00 | AAPL | Stock | 4.8554 | 4.8554 | 4.8454 | 4.8454 | 23100.0 |
| 2009-06-25 08:37:00 | AAPL | Stock | 4.8471 | 4.85 | 4.8471 | 4.85 | 25200.0 |
> showing 50 of 1,003,259 rows — these rows as CSV