PREVIEW / stock_1min / 2005-04-07
file: by_date/stock_1min/2005/2005-04-07.parquet size: 6.4 MB rows: 529,322 symbols: 1,600
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-04-07 08:02:00 | AAPL | Stock | 1.5179 | 1.5179 | 1.5179 | 1.5179 | 408800.0 |
| 2005-04-07 08:04:00 | AAPL | Stock | 1.5179 | 1.5179 | 1.5161 | 1.5179 | 41300.0 |
| 2005-04-07 08:07:00 | AAPL | Stock | 1.5143 | 1.5143 | 1.5139 | 1.5139 | 56000.0 |
| 2005-04-07 08:18:00 | AAPL | Stock | 1.5143 | 1.5143 | 1.5143 | 1.5143 | 25200.0 |
| 2005-04-07 08:20:00 | AAPL | Stock | 1.5161 | 1.5161 | 1.5161 | 1.5161 | 18060.0 |
| 2005-04-07 08:22:00 | AAPL | Stock | 1.5171 | 1.5171 | 1.5161 | 1.5161 | 14000.0 |
| 2005-04-07 08:23:00 | AAPL | Stock | 1.5175 | 1.5175 | 1.5161 | 1.5161 | 19656.0 |
| 2005-04-07 08:24:00 | AAPL | Stock | 1.5161 | 1.5161 | 1.5161 | 1.5161 | 29484.0 |
| 2005-04-07 08:30:00 | AAPL | Stock | 1.5157 | 1.5157 | 1.5157 | 1.5157 | 4200.0 |
| 2005-04-07 08:31:00 | AAPL | Stock | 1.5157 | 1.5157 | 1.5157 | 1.5157 | 5600.0 |
| 2005-04-07 08:32:00 | AAPL | Stock | 1.5157 | 1.5157 | 1.5157 | 1.5157 | 11200.0 |
| 2005-04-07 08:34:00 | AAPL | Stock | 1.5143 | 1.5143 | 1.5143 | 1.5143 | 5600.0 |
| 2005-04-07 08:35:00 | AAPL | Stock | 1.5143 | 1.5143 | 1.5143 | 1.5143 | 7000.0 |
| 2005-04-07 08:36:00 | AAPL | Stock | 1.5143 | 1.5143 | 1.5143 | 1.5143 | 21000.0 |
| 2005-04-07 08:37:00 | AAPL | Stock | 1.5143 | 1.5143 | 1.5143 | 1.5143 | 13636.0 |
| 2005-04-07 08:38:00 | AAPL | Stock | 1.5143 | 1.5143 | 1.5143 | 1.5143 | 3164.0 |
| 2005-04-07 08:42:00 | AAPL | Stock | 1.5139 | 1.5139 | 1.5139 | 1.5139 | 14000.0 |
| 2005-04-07 08:45:00 | AAPL | Stock | 1.5136 | 1.5136 | 1.5136 | 1.5136 | 5600.0 |
| 2005-04-07 08:46:00 | AAPL | Stock | 1.5136 | 1.5136 | 1.5136 | 1.5136 | 22400.0 |
| 2005-04-07 08:48:00 | AAPL | Stock | 1.5136 | 1.5136 | 1.5136 | 1.5136 | 5600.0 |
| 2005-04-07 08:49:00 | AAPL | Stock | 1.5136 | 1.5136 | 1.5125 | 1.5125 | 52080.0 |
| 2005-04-07 08:50:00 | AAPL | Stock | 1.5125 | 1.5125 | 1.5107 | 1.5111 | 34300.0 |
| 2005-04-07 08:57:00 | AAPL | Stock | 1.5111 | 1.5111 | 1.5107 | 1.5107 | 33600.0 |
| 2005-04-07 09:02:00 | AAPL | Stock | 1.5118 | 1.5143 | 1.5118 | 1.5143 | 36400.0 |
| 2005-04-07 09:04:00 | AAPL | Stock | 1.5139 | 1.5139 | 1.5139 | 1.5139 | 8400.0 |
| 2005-04-07 09:05:00 | AAPL | Stock | 1.5136 | 1.5136 | 1.5136 | 1.5136 | 12600.0 |
| 2005-04-07 09:06:00 | AAPL | Stock | 1.5139 | 1.5139 | 1.5139 | 1.5139 | 30800.0 |
| 2005-04-07 09:07:00 | AAPL | Stock | 1.5139 | 1.5139 | 1.5139 | 1.5139 | 22400.0 |
| 2005-04-07 09:09:00 | AAPL | Stock | 1.5132 | 1.5132 | 1.5132 | 1.5132 | 8400.0 |
| 2005-04-07 09:10:00 | AAPL | Stock | 1.5132 | 1.5132 | 1.5132 | 1.5132 | 2800.0 |
| 2005-04-07 09:11:00 | AAPL | Stock | 1.5129 | 1.5129 | 1.5129 | 1.5129 | 5600.0 |
| 2005-04-07 09:14:00 | AAPL | Stock | 1.5129 | 1.5132 | 1.5125 | 1.5132 | 14000.0 |
| 2005-04-07 09:16:00 | AAPL | Stock | 1.5118 | 1.5118 | 1.5118 | 1.5118 | 19600.0 |
| 2005-04-07 09:17:00 | AAPL | Stock | 1.5104 | 1.5104 | 1.51 | 1.5104 | 29400.0 |
| 2005-04-07 09:18:00 | AAPL | Stock | 1.5104 | 1.5107 | 1.505 | 1.51 | 44800.0 |
| 2005-04-07 09:19:00 | AAPL | Stock | 1.5107 | 1.5107 | 1.51 | 1.51 | 36400.0 |
| 2005-04-07 09:20:00 | AAPL | Stock | 1.5107 | 1.5107 | 1.5096 | 1.51 | 204400.0 |
| 2005-04-07 09:21:00 | AAPL | Stock | 1.5104 | 1.5125 | 1.51 | 1.51 | 140000.0 |
| 2005-04-07 09:23:00 | AAPL | Stock | 1.5096 | 1.51 | 1.5096 | 1.51 | 44800.0 |
| 2005-04-07 09:24:00 | AAPL | Stock | 1.51 | 1.51 | 1.51 | 1.51 | 20832.0 |
| 2005-04-07 09:25:00 | AAPL | Stock | 1.5111 | 1.5111 | 1.5107 | 1.5107 | 21196.0 |
| 2005-04-07 09:26:00 | AAPL | Stock | 1.5114 | 1.5132 | 1.5107 | 1.5132 | 44800.0 |
| 2005-04-07 09:27:00 | AAPL | Stock | 1.5136 | 1.515 | 1.5136 | 1.515 | 49000.0 |
| 2005-04-07 09:28:00 | AAPL | Stock | 1.515 | 1.5164 | 1.5141 | 1.5161 | 493808.0 |
| 2005-04-07 09:29:00 | AAPL | Stock | 1.5161 | 1.5175 | 1.5125 | 1.5125 | 265496.0 |
| 2005-04-07 09:30:00 | AAPL | Stock | 1.5118 | 1.5161 | 1.5111 | 1.5143 | 4070612.0 |
| 2005-04-07 09:31:00 | AAPL | Stock | 1.5139 | 1.5139 | 1.5107 | 1.5119 | 555492.0 |
| 2005-04-07 09:32:00 | AAPL | Stock | 1.5142 | 1.5142 | 1.51 | 1.5107 | 1151136.0 |
| 2005-04-07 09:33:00 | AAPL | Stock | 1.5111 | 1.5129 | 1.5089 | 1.5107 | 2956016.0 |
| 2005-04-07 09:34:00 | AAPL | Stock | 1.51 | 1.5121 | 1.51 | 1.5104 | 2185764.0 |
> showing 50 of 529,322 rows — these rows as CSV