PREVIEW / stock_5min / 2006-05-10
file: by_date/stock_5min/2006/2006-05-10.parquet size: 3.1 MB rows: 226,053 symbols: 2,250
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 |
|---|---|---|---|---|---|---|---|
| 2006-05-10 04:20:00 | AAPL | Stock | 2.5386 | 2.5386 | 2.5386 | 2.5386 | 8400.0 |
| 2006-05-10 04:25:00 | AAPL | Stock | 2.5386 | 2.5386 | 2.5386 | 2.5386 | 5600.0 |
| 2006-05-10 04:30:00 | AAPL | Stock | 2.5386 | 2.5386 | 2.5386 | 2.5386 | 50400.0 |
| 2006-05-10 08:00:00 | AAPL | Stock | 2.5393 | 2.5443 | 2.5393 | 2.5443 | 72800.0 |
| 2006-05-10 08:05:00 | AAPL | Stock | 2.5389 | 2.5389 | 2.5357 | 2.5357 | 26572.0 |
| 2006-05-10 08:10:00 | AAPL | Stock | 2.5389 | 2.5429 | 2.5389 | 2.5429 | 71036.0 |
| 2006-05-10 08:15:00 | AAPL | Stock | 2.5429 | 2.5429 | 2.5429 | 2.5429 | 56000.0 |
| 2006-05-10 08:20:00 | AAPL | Stock | 2.5429 | 2.5429 | 2.5429 | 2.5429 | 2800.0 |
| 2006-05-10 08:25:00 | AAPL | Stock | 2.5429 | 2.5429 | 2.5429 | 2.5429 | 42000.0 |
| 2006-05-10 08:30:00 | AAPL | Stock | 2.5375 | 2.5375 | 2.5375 | 2.5375 | 14000.0 |
| 2006-05-10 08:45:00 | AAPL | Stock | 2.5425 | 2.5429 | 2.5411 | 2.5411 | 16800.0 |
| 2006-05-10 08:50:00 | AAPL | Stock | 2.5414 | 2.5414 | 2.5414 | 2.5414 | 16800.0 |
| 2006-05-10 08:55:00 | AAPL | Stock | 2.5411 | 2.5411 | 2.54 | 2.54 | 48860.0 |
| 2006-05-10 09:00:00 | AAPL | Stock | 2.5407 | 2.5411 | 2.5386 | 2.5389 | 69244.0 |
| 2006-05-10 09:05:00 | AAPL | Stock | 2.5404 | 2.5404 | 2.5389 | 2.5389 | 123200.0 |
| 2006-05-10 09:10:00 | AAPL | Stock | 2.5389 | 2.5389 | 2.5389 | 2.5389 | 44240.0 |
| 2006-05-10 09:15:00 | AAPL | Stock | 2.5382 | 2.5429 | 2.5382 | 2.5429 | 41832.0 |
| 2006-05-10 09:25:00 | AAPL | Stock | 2.5382 | 2.5464 | 2.5357 | 2.5464 | 306768.0 |
| 2006-05-10 09:30:00 | AAPL | Stock | 2.5461 | 2.5475 | 2.5229 | 2.5236 | 18048324.0 |
| 2006-05-10 09:35:00 | AAPL | Stock | 2.5243 | 2.5325 | 2.5221 | 2.5236 | 7710052.0 |
| 2006-05-10 09:40:00 | AAPL | Stock | 2.5221 | 2.5304 | 2.5179 | 2.5268 | 9563400.0 |
| 2006-05-10 09:45:00 | AAPL | Stock | 2.5275 | 2.53 | 2.5221 | 2.5221 | 7992068.0 |
| 2006-05-10 09:50:00 | AAPL | Stock | 2.525 | 2.5343 | 2.5221 | 2.5311 | 6898388.0 |
| 2006-05-10 09:55:00 | AAPL | Stock | 2.5311 | 2.5461 | 2.5307 | 2.5442 | 10355772.0 |
| 2006-05-10 10:00:00 | AAPL | Stock | 2.5444 | 2.5468 | 2.5404 | 2.5418 | 11636324.0 |
| 2006-05-10 10:05:00 | AAPL | Stock | 2.5418 | 2.5443 | 2.5343 | 2.5354 | 9115232.0 |
| 2006-05-10 10:10:00 | AAPL | Stock | 2.5354 | 2.545 | 2.535 | 2.5439 | 5947228.0 |
| 2006-05-10 10:15:00 | AAPL | Stock | 2.5436 | 2.5443 | 2.5404 | 2.5411 | 3126592.0 |
| 2006-05-10 10:20:00 | AAPL | Stock | 2.5407 | 2.5418 | 2.5314 | 2.5379 | 4615492.0 |
| 2006-05-10 10:25:00 | AAPL | Stock | 2.5375 | 2.5379 | 2.5304 | 2.5311 | 3985912.0 |
| 2006-05-10 10:30:00 | AAPL | Stock | 2.5311 | 2.5371 | 2.5311 | 2.5357 | 4497948.0 |
| 2006-05-10 10:35:00 | AAPL | Stock | 2.5361 | 2.5371 | 2.5354 | 2.5368 | 2428104.0 |
| 2006-05-10 10:40:00 | AAPL | Stock | 2.5364 | 2.5382 | 2.5329 | 2.5329 | 2996980.0 |
| 2006-05-10 10:45:00 | AAPL | Stock | 2.5336 | 2.5379 | 2.5332 | 2.5346 | 3064544.0 |
| 2006-05-10 10:50:00 | AAPL | Stock | 2.5346 | 2.5346 | 2.5304 | 2.5314 | 6000624.0 |
| 2006-05-10 10:55:00 | AAPL | Stock | 2.5314 | 2.5343 | 2.525 | 2.5286 | 7916188.0 |
| 2006-05-10 11:00:00 | AAPL | Stock | 2.5286 | 2.5314 | 2.5268 | 2.5286 | 2334892.0 |
| 2006-05-10 11:05:00 | AAPL | Stock | 2.5286 | 2.5289 | 2.5268 | 2.5275 | 1902208.0 |
| 2006-05-10 11:10:00 | AAPL | Stock | 2.5279 | 2.5307 | 2.5274 | 2.5282 | 2158716.0 |
| 2006-05-10 11:15:00 | AAPL | Stock | 2.5286 | 2.5314 | 2.5279 | 2.5307 | 1157128.0 |
| 2006-05-10 11:20:00 | AAPL | Stock | 2.5311 | 2.5375 | 2.5311 | 2.5346 | 3244528.0 |
| 2006-05-10 11:25:00 | AAPL | Stock | 2.5357 | 2.5368 | 2.5304 | 2.5321 | 3450188.0 |
| 2006-05-10 11:30:00 | AAPL | Stock | 2.5321 | 2.5371 | 2.5314 | 2.5354 | 2946104.0 |
| 2006-05-10 11:35:00 | AAPL | Stock | 2.5354 | 2.5368 | 2.5321 | 2.5339 | 1924776.0 |
| 2006-05-10 11:40:00 | AAPL | Stock | 2.5343 | 2.5357 | 2.5321 | 2.5336 | 1758708.0 |
| 2006-05-10 11:45:00 | AAPL | Stock | 2.5339 | 2.5361 | 2.5332 | 2.5354 | 1701364.0 |
| 2006-05-10 11:50:00 | AAPL | Stock | 2.5354 | 2.5364 | 2.5343 | 2.5346 | 1818656.0 |
| 2006-05-10 11:55:00 | AAPL | Stock | 2.535 | 2.5375 | 2.5329 | 2.5336 | 2532264.0 |
| 2006-05-10 12:00:00 | AAPL | Stock | 2.5332 | 2.535 | 2.5329 | 2.5346 | 1414028.0 |
| 2006-05-10 12:05:00 | AAPL | Stock | 2.5346 | 2.5346 | 2.5321 | 2.5328 | 1726200.0 |
> showing 50 of 226,053 rows — these rows as CSV