PREVIEW / stock_1min / 2005-03-29
file: by_date/stock_1min/2005/2005-03-29.parquet size: 7.0 MB rows: 571,838 symbols: 1,607
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 |
|---|---|---|---|---|---|---|---|
| 2005-03-29 08:00:00 | AAPL | Stock | 1.5125 | 1.5125 | 1.5125 | 1.5125 | 5600.0 |
| 2005-03-29 08:02:00 | AAPL | Stock | 1.5107 | 1.5107 | 1.5107 | 1.5107 | 5600.0 |
| 2005-03-29 08:04:00 | AAPL | Stock | 1.5125 | 1.5125 | 1.5125 | 1.5125 | 8400.0 |
| 2005-03-29 08:05:00 | AAPL | Stock | 1.5125 | 1.5125 | 1.5125 | 1.5125 | 5600.0 |
| 2005-03-29 08:06:00 | AAPL | Stock | 1.5125 | 1.5125 | 1.5125 | 1.5125 | 16800.0 |
| 2005-03-29 08:14:00 | AAPL | Stock | 1.5125 | 1.5125 | 1.5125 | 1.5125 | 8400.0 |
| 2005-03-29 08:23:00 | AAPL | Stock | 1.5125 | 1.5125 | 1.5125 | 1.5125 | 4200.0 |
| 2005-03-29 08:25:00 | AAPL | Stock | 1.5157 | 1.5161 | 1.5157 | 1.5161 | 28000.0 |
| 2005-03-29 08:33:00 | AAPL | Stock | 1.5157 | 1.5157 | 1.5157 | 1.5157 | 28000.0 |
| 2005-03-29 08:37:00 | AAPL | Stock | 1.5157 | 1.5161 | 1.5157 | 1.5161 | 28000.0 |
| 2005-03-29 08:40:00 | AAPL | Stock | 1.5143 | 1.5143 | 1.5143 | 1.5143 | 10556.0 |
| 2005-03-29 08:46:00 | AAPL | Stock | 1.5143 | 1.5143 | 1.5143 | 1.5143 | 4312.0 |
| 2005-03-29 08:48:00 | AAPL | Stock | 1.515 | 1.515 | 1.5125 | 1.5129 | 25200.0 |
| 2005-03-29 08:56:00 | AAPL | Stock | 1.5179 | 1.5179 | 1.5168 | 1.5168 | 28000.0 |
| 2005-03-29 08:59:00 | AAPL | Stock | 1.5164 | 1.5164 | 1.5164 | 1.5164 | 2800.0 |
| 2005-03-29 09:00:00 | AAPL | Stock | 1.5179 | 1.5179 | 1.5179 | 1.5179 | 30800.0 |
| 2005-03-29 09:02:00 | AAPL | Stock | 1.5179 | 1.5189 | 1.5179 | 1.5189 | 16016.0 |
| 2005-03-29 09:03:00 | AAPL | Stock | 1.5189 | 1.5189 | 1.5189 | 1.5189 | 2800.0 |
| 2005-03-29 09:11:00 | AAPL | Stock | 1.5189 | 1.5189 | 1.5189 | 1.5189 | 2800.0 |
| 2005-03-29 09:25:00 | AAPL | Stock | 1.5189 | 1.5189 | 1.5189 | 1.5189 | 22400.0 |
| 2005-03-29 09:26:00 | AAPL | Stock | 1.5189 | 1.5204 | 1.5189 | 1.5204 | 23800.0 |
| 2005-03-29 09:29:00 | AAPL | Stock | 1.5196 | 1.5204 | 1.5196 | 1.5204 | 43848.0 |
| 2005-03-29 09:30:00 | AAPL | Stock | 1.52 | 1.5204 | 1.5143 | 1.5179 | 3993668.0 |
| 2005-03-29 09:31:00 | AAPL | Stock | 1.5179 | 1.5232 | 1.5118 | 1.5204 | 3337208.0 |
| 2005-03-29 09:32:00 | AAPL | Stock | 1.52 | 1.5211 | 1.5132 | 1.5186 | 2017372.0 |
| 2005-03-29 09:33:00 | AAPL | Stock | 1.5179 | 1.5196 | 1.515 | 1.5175 | 677544.0 |
| 2005-03-29 09:34:00 | AAPL | Stock | 1.5175 | 1.5179 | 1.515 | 1.515 | 781592.0 |
| 2005-03-29 09:35:00 | AAPL | Stock | 1.5154 | 1.5182 | 1.5143 | 1.5175 | 1049412.0 |
| 2005-03-29 09:36:00 | AAPL | Stock | 1.5175 | 1.5186 | 1.5132 | 1.5132 | 1152704.0 |
| 2005-03-29 09:37:00 | AAPL | Stock | 1.5132 | 1.515 | 1.5093 | 1.5121 | 2861628.0 |
| 2005-03-29 09:38:00 | AAPL | Stock | 1.5121 | 1.5136 | 1.5107 | 1.5136 | 1109892.0 |
| 2005-03-29 09:39:00 | AAPL | Stock | 1.5129 | 1.5157 | 1.5129 | 1.5154 | 1619716.0 |
| 2005-03-29 09:40:00 | AAPL | Stock | 1.5154 | 1.5171 | 1.5129 | 1.5129 | 1205848.0 |
| 2005-03-29 09:41:00 | AAPL | Stock | 1.5125 | 1.5161 | 1.5118 | 1.5161 | 1449532.0 |
| 2005-03-29 09:42:00 | AAPL | Stock | 1.5164 | 1.5164 | 1.5139 | 1.5139 | 755384.0 |
| 2005-03-29 09:43:00 | AAPL | Stock | 1.5139 | 1.5164 | 1.5132 | 1.5139 | 794164.0 |
| 2005-03-29 09:44:00 | AAPL | Stock | 1.5143 | 1.5164 | 1.5143 | 1.5154 | 736064.0 |
| 2005-03-29 09:45:00 | AAPL | Stock | 1.5157 | 1.5161 | 1.5143 | 1.5143 | 868336.0 |
| 2005-03-29 09:46:00 | AAPL | Stock | 1.5143 | 1.5146 | 1.5139 | 1.5139 | 1475600.0 |
| 2005-03-29 09:47:00 | AAPL | Stock | 1.5139 | 1.5146 | 1.5118 | 1.5118 | 1890672.0 |
| 2005-03-29 09:48:00 | AAPL | Stock | 1.5118 | 1.5121 | 1.5114 | 1.5118 | 787388.0 |
| 2005-03-29 09:49:00 | AAPL | Stock | 1.5118 | 1.5136 | 1.5114 | 1.5118 | 1137332.0 |
| 2005-03-29 09:50:00 | AAPL | Stock | 1.5114 | 1.5118 | 1.5104 | 1.5111 | 2068976.0 |
| 2005-03-29 09:51:00 | AAPL | Stock | 1.5111 | 1.5143 | 1.5107 | 1.5143 | 1426432.0 |
| 2005-03-29 09:52:00 | AAPL | Stock | 1.5143 | 1.515 | 1.5121 | 1.5121 | 1479772.0 |
| 2005-03-29 09:53:00 | AAPL | Stock | 1.5118 | 1.5139 | 1.5111 | 1.5132 | 1378300.0 |
| 2005-03-29 09:54:00 | AAPL | Stock | 1.5136 | 1.5136 | 1.5093 | 1.5096 | 1678936.0 |
| 2005-03-29 09:55:00 | AAPL | Stock | 1.5096 | 1.5107 | 1.5075 | 1.5104 | 4262664.0 |
| 2005-03-29 09:56:00 | AAPL | Stock | 1.51 | 1.5104 | 1.5082 | 1.5086 | 1362200.0 |
| 2005-03-29 09:57:00 | AAPL | Stock | 1.5082 | 1.5086 | 1.5039 | 1.5043 | 3417120.0 |
> showing 50 of 571,838 rows — these rows as CSV