PREVIEW / stock_1min / 2004-04-19
file: by_date/stock_1min/2004/2004-04-19.parquet size: 5.7 MB rows: 479,239 symbols: 1,449
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 |
|---|---|---|---|---|---|---|---|
| 2004-04-19 08:10:00 | AAPL | Stock | 0.5213 | 0.5213 | 0.5207 | 0.5207 | 56000.0 |
| 2004-04-19 08:37:00 | AAPL | Stock | 0.5207 | 0.5207 | 0.5207 | 0.5207 | 28000.0 |
| 2004-04-19 09:11:00 | AAPL | Stock | 0.5179 | 0.5179 | 0.5179 | 0.5179 | 50400.0 |
| 2004-04-19 09:13:00 | AAPL | Stock | 0.5161 | 0.5161 | 0.5161 | 0.5161 | 72800.0 |
| 2004-04-19 09:14:00 | AAPL | Stock | 0.5161 | 0.5161 | 0.5161 | 0.5161 | 190400.0 |
| 2004-04-19 09:21:00 | AAPL | Stock | 0.5161 | 0.5161 | 0.5102 | 0.5116 | 1036000.0 |
| 2004-04-19 09:22:00 | AAPL | Stock | 0.5116 | 0.5116 | 0.5109 | 0.5109 | 263200.0 |
| 2004-04-19 09:23:00 | AAPL | Stock | 0.5109 | 0.5109 | 0.5109 | 0.5109 | 77000.0 |
| 2004-04-19 09:24:00 | AAPL | Stock | 0.5109 | 0.5125 | 0.5109 | 0.5109 | 947800.0 |
| 2004-04-19 09:25:00 | AAPL | Stock | 0.5098 | 0.5125 | 0.5089 | 0.5098 | 2116800.0 |
| 2004-04-19 09:26:00 | AAPL | Stock | 0.5095 | 0.5095 | 0.508 | 0.5089 | 324800.0 |
| 2004-04-19 09:27:00 | AAPL | Stock | 0.5086 | 0.5089 | 0.5071 | 0.5071 | 565600.0 |
| 2004-04-19 09:28:00 | AAPL | Stock | 0.5071 | 0.5071 | 0.5071 | 0.5071 | 336000.0 |
| 2004-04-19 09:29:00 | AAPL | Stock | 0.5071 | 0.5114 | 0.5 | 0.5046 | 7345800.0 |
| 2004-04-19 09:30:00 | AAPL | Stock | 0.5021 | 0.5063 | 0.4998 | 0.5055 | 21713552.0 |
| 2004-04-19 09:31:00 | AAPL | Stock | 0.5055 | 0.5089 | 0.5 | 0.5088 | 30316832.0 |
| 2004-04-19 09:32:00 | AAPL | Stock | 0.5088 | 0.5093 | 0.5071 | 0.508 | 4944688.0 |
| 2004-04-19 09:33:00 | AAPL | Stock | 0.5073 | 0.5089 | 0.5 | 0.5089 | 3315480.0 |
| 2004-04-19 09:34:00 | AAPL | Stock | 0.5063 | 0.5071 | 0.5061 | 0.5068 | 3615192.0 |
| 2004-04-19 09:35:00 | AAPL | Stock | 0.5066 | 0.5086 | 0.5066 | 0.5082 | 4346832.0 |
| 2004-04-19 09:36:00 | AAPL | Stock | 0.5073 | 0.5084 | 0.5063 | 0.5084 | 7126336.0 |
| 2004-04-19 09:37:00 | AAPL | Stock | 0.5082 | 0.5088 | 0.5077 | 0.5086 | 4604544.0 |
| 2004-04-19 09:38:00 | AAPL | Stock | 0.5088 | 0.5088 | 0.5084 | 0.5084 | 1671824.0 |
| 2004-04-19 09:39:00 | AAPL | Stock | 0.5086 | 0.5088 | 0.508 | 0.5084 | 1700720.0 |
| 2004-04-19 09:40:00 | AAPL | Stock | 0.5084 | 0.5118 | 0.5084 | 0.5118 | 7007000.0 |
| 2004-04-19 09:41:00 | AAPL | Stock | 0.512 | 0.5132 | 0.5118 | 0.5132 | 4648112.0 |
| 2004-04-19 09:42:00 | AAPL | Stock | 0.5132 | 0.5134 | 0.5104 | 0.5121 | 3173408.0 |
| 2004-04-19 09:43:00 | AAPL | Stock | 0.5121 | 0.5125 | 0.5102 | 0.5102 | 2281552.0 |
| 2004-04-19 09:44:00 | AAPL | Stock | 0.5104 | 0.5116 | 0.5102 | 0.5113 | 1279320.0 |
| 2004-04-19 09:45:00 | AAPL | Stock | 0.5116 | 0.5123 | 0.5114 | 0.5118 | 1579312.0 |
| 2004-04-19 09:46:00 | AAPL | Stock | 0.5118 | 0.512 | 0.5105 | 0.5105 | 746928.0 |
| 2004-04-19 09:47:00 | AAPL | Stock | 0.5104 | 0.5105 | 0.5086 | 0.51 | 4791472.0 |
| 2004-04-19 09:48:00 | AAPL | Stock | 0.5095 | 0.5098 | 0.5091 | 0.5091 | 1432256.0 |
| 2004-04-19 09:49:00 | AAPL | Stock | 0.5093 | 0.5093 | 0.5082 | 0.5082 | 2689680.0 |
| 2004-04-19 09:50:00 | AAPL | Stock | 0.5082 | 0.5086 | 0.5082 | 0.5084 | 2263464.0 |
| 2004-04-19 09:51:00 | AAPL | Stock | 0.5084 | 0.5084 | 0.5064 | 0.5064 | 2379776.0 |
| 2004-04-19 09:52:00 | AAPL | Stock | 0.5066 | 0.5077 | 0.5064 | 0.5071 | 1125600.0 |
| 2004-04-19 09:53:00 | AAPL | Stock | 0.5071 | 0.5075 | 0.507 | 0.5073 | 1376088.0 |
| 2004-04-19 09:54:00 | AAPL | Stock | 0.5073 | 0.5073 | 0.5066 | 0.5068 | 827456.0 |
| 2004-04-19 09:55:00 | AAPL | Stock | 0.5068 | 0.5084 | 0.5066 | 0.5084 | 1745968.0 |
| 2004-04-19 09:56:00 | AAPL | Stock | 0.508 | 0.5084 | 0.508 | 0.5084 | 595896.0 |
| 2004-04-19 09:57:00 | AAPL | Stock | 0.5084 | 0.5088 | 0.5082 | 0.5086 | 1331120.0 |
| 2004-04-19 09:58:00 | AAPL | Stock | 0.5088 | 0.5088 | 0.5086 | 0.5088 | 1163456.0 |
| 2004-04-19 09:59:00 | AAPL | Stock | 0.5086 | 0.5089 | 0.5086 | 0.5089 | 1234744.0 |
| 2004-04-19 10:00:00 | AAPL | Stock | 0.5089 | 0.5089 | 0.5084 | 0.5084 | 1003912.0 |
| 2004-04-19 10:01:00 | AAPL | Stock | 0.5084 | 0.5086 | 0.5077 | 0.5077 | 1169840.0 |
| 2004-04-19 10:02:00 | AAPL | Stock | 0.5077 | 0.5077 | 0.5075 | 0.5077 | 1189608.0 |
| 2004-04-19 10:03:00 | AAPL | Stock | 0.5077 | 0.5082 | 0.5075 | 0.508 | 1735104.0 |
| 2004-04-19 10:04:00 | AAPL | Stock | 0.5079 | 0.5084 | 0.5079 | 0.5082 | 775936.0 |
| 2004-04-19 10:05:00 | AAPL | Stock | 0.5084 | 0.5084 | 0.508 | 0.5084 | 886928.0 |
> showing 50 of 479,239 rows — these rows as CSV