PREVIEW / stock_1min / 2007-10-01
file: by_date/stock_1min/2007/2007-10-01.parquet size: 12.3 MB rows: 1,000,661 symbols: 2,570
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 |
|---|---|---|---|---|---|---|---|
| 2007-10-01 07:12:00 | AAPL | Stock | 5.4643 | 5.4643 | 5.4536 | 5.4536 | 84000.0 |
| 2007-10-01 07:53:00 | AAPL | Stock | 5.4768 | 5.4768 | 5.4768 | 5.4768 | 28000.0 |
| 2007-10-01 07:56:00 | AAPL | Stock | 5.4664 | 5.4664 | 5.4664 | 5.4664 | 2800.0 |
| 2007-10-01 07:57:00 | AAPL | Stock | 5.4664 | 5.4664 | 5.4664 | 5.4664 | 2800.0 |
| 2007-10-01 07:59:00 | AAPL | Stock | 5.4746 | 5.475 | 5.4743 | 5.475 | 89040.0 |
| 2007-10-01 08:00:00 | AAPL | Stock | 5.4668 | 5.475 | 5.4668 | 5.4696 | 83300.0 |
| 2007-10-01 08:01:00 | AAPL | Stock | 5.4696 | 5.475 | 5.4696 | 5.475 | 8400.0 |
| 2007-10-01 08:02:00 | AAPL | Stock | 5.475 | 5.475 | 5.475 | 5.475 | 11760.0 |
| 2007-10-01 08:03:00 | AAPL | Stock | 5.4725 | 5.4725 | 5.4725 | 5.4725 | 42000.0 |
| 2007-10-01 08:04:00 | AAPL | Stock | 5.4714 | 5.4746 | 5.4696 | 5.4714 | 74900.0 |
| 2007-10-01 08:05:00 | AAPL | Stock | 5.4743 | 5.475 | 5.4743 | 5.475 | 40432.0 |
| 2007-10-01 08:07:00 | AAPL | Stock | 5.475 | 5.475 | 5.475 | 5.475 | 18172.0 |
| 2007-10-01 08:08:00 | AAPL | Stock | 5.4761 | 5.4782 | 5.4761 | 5.4782 | 64400.0 |
| 2007-10-01 08:09:00 | AAPL | Stock | 5.4771 | 5.4825 | 5.4768 | 5.4821 | 89600.0 |
| 2007-10-01 08:10:00 | AAPL | Stock | 5.4825 | 5.4829 | 5.4821 | 5.4821 | 77000.0 |
| 2007-10-01 08:11:00 | AAPL | Stock | 5.48 | 5.4814 | 5.48 | 5.4814 | 47600.0 |
| 2007-10-01 08:12:00 | AAPL | Stock | 5.48 | 5.4814 | 5.4796 | 5.4804 | 81200.0 |
| 2007-10-01 08:13:00 | AAPL | Stock | 5.48 | 5.4814 | 5.48 | 5.4814 | 14420.0 |
| 2007-10-01 08:14:00 | AAPL | Stock | 5.4811 | 5.4811 | 5.4786 | 5.4807 | 70112.0 |
| 2007-10-01 08:15:00 | AAPL | Stock | 5.4786 | 5.4786 | 5.4775 | 5.4779 | 20888.0 |
| 2007-10-01 08:16:00 | AAPL | Stock | 5.4764 | 5.4989 | 5.4764 | 5.4811 | 175812.0 |
| 2007-10-01 08:17:00 | AAPL | Stock | 5.4761 | 5.4761 | 5.4761 | 5.4761 | 2800.0 |
| 2007-10-01 08:19:00 | AAPL | Stock | 5.4764 | 5.4764 | 5.4754 | 5.4754 | 35476.0 |
| 2007-10-01 08:20:00 | AAPL | Stock | 5.4764 | 5.4764 | 5.4764 | 5.4764 | 5600.0 |
| 2007-10-01 08:21:00 | AAPL | Stock | 5.4786 | 5.4829 | 5.4761 | 5.4825 | 103040.0 |
| 2007-10-01 08:22:00 | AAPL | Stock | 5.4868 | 5.5136 | 5.4868 | 5.5129 | 212016.0 |
| 2007-10-01 08:23:00 | AAPL | Stock | 5.5125 | 5.5136 | 5.5 | 5.5057 | 58800.0 |
| 2007-10-01 08:24:00 | AAPL | Stock | 5.5057 | 5.5136 | 5.5057 | 5.5136 | 161364.0 |
| 2007-10-01 08:25:00 | AAPL | Stock | 5.5136 | 5.5143 | 5.5089 | 5.5089 | 71876.0 |
| 2007-10-01 08:26:00 | AAPL | Stock | 5.5089 | 5.5089 | 5.5025 | 5.5025 | 186284.0 |
| 2007-10-01 08:27:00 | AAPL | Stock | 5.5046 | 5.5071 | 5.5043 | 5.5054 | 343140.0 |
| 2007-10-01 08:28:00 | AAPL | Stock | 5.5054 | 5.5125 | 5.5054 | 5.5125 | 42140.0 |
| 2007-10-01 08:29:00 | AAPL | Stock | 5.5125 | 5.5125 | 5.5107 | 5.5107 | 33600.0 |
| 2007-10-01 08:30:00 | AAPL | Stock | 5.51 | 5.5132 | 5.51 | 5.5132 | 18900.0 |
| 2007-10-01 08:31:00 | AAPL | Stock | 5.5125 | 5.5139 | 5.5125 | 5.5139 | 39060.0 |
| 2007-10-01 08:32:00 | AAPL | Stock | 5.5129 | 5.5161 | 5.5129 | 5.5139 | 625688.0 |
| 2007-10-01 08:33:00 | AAPL | Stock | 5.5139 | 5.5164 | 5.5136 | 5.5164 | 83720.0 |
| 2007-10-01 08:34:00 | AAPL | Stock | 5.5143 | 5.5179 | 5.5143 | 5.5179 | 193480.0 |
| 2007-10-01 08:35:00 | AAPL | Stock | 5.5179 | 5.52 | 5.5179 | 5.52 | 29260.0 |
| 2007-10-01 08:36:00 | AAPL | Stock | 5.52 | 5.525 | 5.52 | 5.5232 | 151200.0 |
| 2007-10-01 08:37:00 | AAPL | Stock | 5.5218 | 5.5254 | 5.52 | 5.5204 | 152320.0 |
| 2007-10-01 08:38:00 | AAPL | Stock | 5.5204 | 5.5236 | 5.52 | 5.5207 | 71204.0 |
| 2007-10-01 08:39:00 | AAPL | Stock | 5.4836 | 5.5214 | 5.4836 | 5.5214 | 379400.0 |
| 2007-10-01 08:40:00 | AAPL | Stock | 5.5214 | 5.5214 | 5.5179 | 5.5179 | 45360.0 |
| 2007-10-01 08:41:00 | AAPL | Stock | 5.5186 | 5.52 | 5.5179 | 5.52 | 25200.0 |
| 2007-10-01 08:42:00 | AAPL | Stock | 5.52 | 5.52 | 5.5179 | 5.5179 | 92400.0 |
| 2007-10-01 08:44:00 | AAPL | Stock | 5.5161 | 5.5161 | 5.5121 | 5.5121 | 114240.0 |
| 2007-10-01 08:45:00 | AAPL | Stock | 5.5111 | 5.5121 | 5.5089 | 5.5096 | 82656.0 |
| 2007-10-01 08:46:00 | AAPL | Stock | 5.5071 | 5.5071 | 5.5054 | 5.5054 | 61600.0 |
| 2007-10-01 08:47:00 | AAPL | Stock | 5.5054 | 5.5086 | 5.5054 | 5.5086 | 56000.0 |
> showing 50 of 1,000,661 rows — these rows as CSV