PREVIEW / stock_1min / 2010-01-14
file: by_date/stock_1min/2010/2010-01-14.parquet size: 12.1 MB rows: 905,775 symbols: 2,797
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 |
|---|---|---|---|---|---|---|---|
| 2010-01-14 04:57:00 | AAPL | Stock | 7.5411 | 7.5411 | 7.5411 | 7.5411 | 2800.0 |
| 2010-01-14 06:17:00 | AAPL | Stock | 7.5439 | 7.5439 | 7.5439 | 7.5439 | 8400.0 |
| 2010-01-14 06:41:00 | AAPL | Stock | 7.5357 | 7.5357 | 7.5357 | 7.5357 | 2800.0 |
| 2010-01-14 07:20:00 | AAPL | Stock | 7.5529 | 7.5529 | 7.5529 | 7.5529 | 5600.0 |
| 2010-01-14 07:30:00 | AAPL | Stock | 7.5364 | 7.5364 | 7.5364 | 7.5364 | 14000.0 |
| 2010-01-14 07:32:00 | AAPL | Stock | 7.5361 | 7.5361 | 7.5361 | 7.5361 | 2800.0 |
| 2010-01-14 07:33:00 | AAPL | Stock | 7.5361 | 7.5361 | 7.5357 | 7.5357 | 9100.0 |
| 2010-01-14 07:35:00 | AAPL | Stock | 7.5357 | 7.5357 | 7.5357 | 7.5357 | 14448.0 |
| 2010-01-14 07:39:00 | AAPL | Stock | 7.5321 | 7.5321 | 7.5321 | 7.5321 | 14000.0 |
| 2010-01-14 07:41:00 | AAPL | Stock | 7.5307 | 7.5307 | 7.5304 | 7.5304 | 6300.0 |
| 2010-01-14 07:45:00 | AAPL | Stock | 7.5307 | 7.5321 | 7.5307 | 7.5321 | 25200.0 |
| 2010-01-14 07:50:00 | AAPL | Stock | 7.5289 | 7.5289 | 7.525 | 7.525 | 25200.0 |
| 2010-01-14 07:51:00 | AAPL | Stock | 7.525 | 7.525 | 7.5246 | 7.525 | 8400.0 |
| 2010-01-14 07:52:00 | AAPL | Stock | 7.5218 | 7.5218 | 7.5193 | 7.5214 | 33236.0 |
| 2010-01-14 07:54:00 | AAPL | Stock | 7.5232 | 7.5246 | 7.5232 | 7.5246 | 8400.0 |
| 2010-01-14 07:55:00 | AAPL | Stock | 7.525 | 7.525 | 7.525 | 7.525 | 11200.0 |
| 2010-01-14 07:59:00 | AAPL | Stock | 7.5321 | 7.5321 | 7.5321 | 7.5321 | 2800.0 |
| 2010-01-14 08:00:00 | AAPL | Stock | 7.5261 | 7.5268 | 7.5261 | 7.5268 | 5600.0 |
| 2010-01-14 08:01:00 | AAPL | Stock | 7.5364 | 7.5407 | 7.5307 | 7.5307 | 22400.0 |
| 2010-01-14 08:02:00 | AAPL | Stock | 7.5346 | 7.5357 | 7.5346 | 7.5357 | 53200.0 |
| 2010-01-14 08:03:00 | AAPL | Stock | 7.5393 | 7.5464 | 7.5393 | 7.5461 | 235200.0 |
| 2010-01-14 08:04:00 | AAPL | Stock | 7.5396 | 7.5396 | 7.5393 | 7.5393 | 54880.0 |
| 2010-01-14 08:05:00 | AAPL | Stock | 7.5355 | 7.5355 | 7.5343 | 7.5343 | 24640.0 |
| 2010-01-14 08:06:00 | AAPL | Stock | 7.5343 | 7.5357 | 7.5339 | 7.5357 | 25200.0 |
| 2010-01-14 08:07:00 | AAPL | Stock | 7.5379 | 7.5379 | 7.5379 | 7.5379 | 28000.0 |
| 2010-01-14 08:08:00 | AAPL | Stock | 7.5329 | 7.5382 | 7.5329 | 7.5382 | 35140.0 |
| 2010-01-14 08:12:00 | AAPL | Stock | 7.5357 | 7.5357 | 7.5357 | 7.5357 | 2800.0 |
| 2010-01-14 08:13:00 | AAPL | Stock | 7.5339 | 7.5339 | 7.5286 | 7.5286 | 43260.0 |
| 2010-01-14 08:15:00 | AAPL | Stock | 7.5282 | 7.5304 | 7.5282 | 7.5304 | 5600.0 |
| 2010-01-14 08:16:00 | AAPL | Stock | 7.5304 | 7.5304 | 7.5193 | 7.5214 | 81200.0 |
| 2010-01-14 08:17:00 | AAPL | Stock | 7.5214 | 7.5275 | 7.5214 | 7.5214 | 56112.0 |
| 2010-01-14 08:18:00 | AAPL | Stock | 7.5221 | 7.5221 | 7.5221 | 7.5221 | 2800.0 |
| 2010-01-14 08:19:00 | AAPL | Stock | 7.5279 | 7.5279 | 7.5232 | 7.5232 | 5600.0 |
| 2010-01-14 08:20:00 | AAPL | Stock | 7.525 | 7.525 | 7.5243 | 7.5243 | 16800.0 |
| 2010-01-14 08:21:00 | AAPL | Stock | 7.5246 | 7.5254 | 7.5239 | 7.5239 | 19600.0 |
| 2010-01-14 08:22:00 | AAPL | Stock | 7.5257 | 7.5261 | 7.5232 | 7.5232 | 86772.0 |
| 2010-01-14 08:23:00 | AAPL | Stock | 7.5232 | 7.5264 | 7.5196 | 7.5225 | 119056.0 |
| 2010-01-14 08:24:00 | AAPL | Stock | 7.525 | 7.5268 | 7.5229 | 7.5229 | 15680.0 |
| 2010-01-14 08:25:00 | AAPL | Stock | 7.5268 | 7.5268 | 7.5268 | 7.5268 | 2800.0 |
| 2010-01-14 08:26:00 | AAPL | Stock | 7.5286 | 7.5286 | 7.5268 | 7.5286 | 8400.0 |
| 2010-01-14 08:28:00 | AAPL | Stock | 7.5289 | 7.5289 | 7.525 | 7.525 | 36064.0 |
| 2010-01-14 08:29:00 | AAPL | Stock | 7.5268 | 7.5268 | 7.525 | 7.525 | 39200.0 |
| 2010-01-14 08:30:00 | AAPL | Stock | 7.5229 | 7.525 | 7.5125 | 7.5189 | 375592.0 |
| 2010-01-14 08:31:00 | AAPL | Stock | 7.5182 | 7.5275 | 7.5182 | 7.5275 | 26180.0 |
| 2010-01-14 08:32:00 | AAPL | Stock | 7.5271 | 7.5289 | 7.525 | 7.5268 | 64204.0 |
| 2010-01-14 08:33:00 | AAPL | Stock | 7.525 | 7.5286 | 7.525 | 7.5264 | 17416.0 |
| 2010-01-14 08:34:00 | AAPL | Stock | 7.525 | 7.525 | 7.5207 | 7.5207 | 14140.0 |
| 2010-01-14 08:36:00 | AAPL | Stock | 7.5218 | 7.5218 | 7.5164 | 7.5164 | 81536.0 |
| 2010-01-14 08:37:00 | AAPL | Stock | 7.5179 | 7.5186 | 7.5139 | 7.515 | 56000.0 |
| 2010-01-14 08:38:00 | AAPL | Stock | 7.5146 | 7.5146 | 7.5107 | 7.5107 | 20244.0 |
> showing 50 of 905,775 rows — these rows as CSV