PREVIEW / stock_5min / 2006-09-06
file: by_date/stock_5min/2006/2006-09-06.parquet size: 3.1 MB rows: 229,509 symbols: 2,358
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-09-06 07:45:00 | AAPL | Stock | 2.5536 | 2.5554 | 2.5429 | 2.5464 | 124600.0 |
| 2006-09-06 07:50:00 | AAPL | Stock | 2.5464 | 2.5464 | 2.5446 | 2.5446 | 84000.0 |
| 2006-09-06 07:55:00 | AAPL | Stock | 2.5429 | 2.5436 | 2.5411 | 2.5411 | 89600.0 |
| 2006-09-06 08:00:00 | AAPL | Stock | 2.5504 | 2.5518 | 2.5393 | 2.55 | 1322300.0 |
| 2006-09-06 08:05:00 | AAPL | Stock | 2.5518 | 2.5621 | 2.5482 | 2.5589 | 954632.0 |
| 2006-09-06 08:10:00 | AAPL | Stock | 2.56 | 2.5614 | 2.5529 | 2.5543 | 538524.0 |
| 2006-09-06 08:15:00 | AAPL | Stock | 2.5511 | 2.5514 | 2.5464 | 2.5464 | 388220.0 |
| 2006-09-06 08:20:00 | AAPL | Stock | 2.5464 | 2.5468 | 2.5457 | 2.5464 | 254100.0 |
| 2006-09-06 08:25:00 | AAPL | Stock | 2.5464 | 2.5471 | 2.5446 | 2.5464 | 181076.0 |
| 2006-09-06 08:30:00 | AAPL | Stock | 2.5454 | 2.5454 | 2.5393 | 2.5429 | 599872.0 |
| 2006-09-06 08:35:00 | AAPL | Stock | 2.5429 | 2.5446 | 2.5414 | 2.5446 | 587916.0 |
| 2006-09-06 08:40:00 | AAPL | Stock | 2.5446 | 2.5457 | 2.5436 | 2.5457 | 247660.0 |
| 2006-09-06 08:45:00 | AAPL | Stock | 2.5446 | 2.5464 | 2.5375 | 2.5393 | 530264.0 |
| 2006-09-06 08:50:00 | AAPL | Stock | 2.5393 | 2.5393 | 2.5375 | 2.5379 | 245700.0 |
| 2006-09-06 08:55:00 | AAPL | Stock | 2.5393 | 2.5411 | 2.5375 | 2.5407 | 354900.0 |
| 2006-09-06 09:00:00 | AAPL | Stock | 2.5407 | 2.5407 | 2.5361 | 2.5382 | 530600.0 |
| 2006-09-06 09:05:00 | AAPL | Stock | 2.5379 | 2.5411 | 2.5379 | 2.54 | 381752.0 |
| 2006-09-06 09:10:00 | AAPL | Stock | 2.5396 | 2.54 | 2.5346 | 2.5346 | 447888.0 |
| 2006-09-06 09:15:00 | AAPL | Stock | 2.5357 | 2.5389 | 2.5357 | 2.5371 | 428792.0 |
| 2006-09-06 09:20:00 | AAPL | Stock | 2.5371 | 2.5379 | 2.5357 | 2.5357 | 460544.0 |
| 2006-09-06 09:25:00 | AAPL | Stock | 2.5357 | 2.5432 | 2.5343 | 2.5386 | 1749524.0 |
| 2006-09-06 09:30:00 | AAPL | Stock | 2.5386 | 2.5464 | 2.5314 | 2.5396 | 34025880.0 |
| 2006-09-06 09:35:00 | AAPL | Stock | 2.5407 | 2.5511 | 2.5357 | 2.5357 | 26101432.0 |
| 2006-09-06 09:40:00 | AAPL | Stock | 2.5357 | 2.5364 | 2.5243 | 2.5296 | 29456252.0 |
| 2006-09-06 09:45:00 | AAPL | Stock | 2.53 | 2.5304 | 2.5196 | 2.5271 | 24974516.0 |
| 2006-09-06 09:50:00 | AAPL | Stock | 2.5271 | 2.5339 | 2.5261 | 2.5325 | 16458624.0 |
| 2006-09-06 09:55:00 | AAPL | Stock | 2.5325 | 2.5339 | 2.5232 | 2.5246 | 14587832.0 |
| 2006-09-06 10:00:00 | AAPL | Stock | 2.5246 | 2.5439 | 2.5232 | 2.5271 | 19124476.0 |
| 2006-09-06 10:05:00 | AAPL | Stock | 2.5268 | 2.5393 | 2.5264 | 2.5389 | 19789504.0 |
| 2006-09-06 10:10:00 | AAPL | Stock | 2.5389 | 2.5407 | 2.5318 | 2.5321 | 20432608.0 |
| 2006-09-06 10:15:00 | AAPL | Stock | 2.5321 | 2.5411 | 2.5286 | 2.5386 | 19516280.0 |
| 2006-09-06 10:20:00 | AAPL | Stock | 2.5389 | 2.5436 | 2.5368 | 2.5407 | 15732276.0 |
| 2006-09-06 10:25:00 | AAPL | Stock | 2.5407 | 2.5418 | 2.535 | 2.54 | 11908960.0 |
| 2006-09-06 10:30:00 | AAPL | Stock | 2.5404 | 2.5407 | 2.5311 | 2.5346 | 13699392.0 |
| 2006-09-06 10:35:00 | AAPL | Stock | 2.5346 | 2.5364 | 2.5329 | 2.5349 | 8453452.0 |
| 2006-09-06 10:40:00 | AAPL | Stock | 2.5343 | 2.5357 | 2.5332 | 2.5332 | 6737416.0 |
| 2006-09-06 10:45:00 | AAPL | Stock | 2.5332 | 2.5389 | 2.5332 | 2.5357 | 12248152.0 |
| 2006-09-06 10:50:00 | AAPL | Stock | 2.5361 | 2.5446 | 2.5346 | 2.5429 | 13122984.0 |
| 2006-09-06 10:55:00 | AAPL | Stock | 2.5432 | 2.5514 | 2.5429 | 2.5454 | 18307744.0 |
| 2006-09-06 11:00:00 | AAPL | Stock | 2.5454 | 2.5582 | 2.5429 | 2.5579 | 18847220.0 |
| 2006-09-06 11:05:00 | AAPL | Stock | 2.5579 | 2.5596 | 2.5525 | 2.5546 | 20903652.0 |
| 2006-09-06 11:10:00 | AAPL | Stock | 2.5546 | 2.5604 | 2.5521 | 2.5525 | 15572928.0 |
| 2006-09-06 11:15:00 | AAPL | Stock | 2.5529 | 2.5557 | 2.5489 | 2.55 | 10495548.0 |
| 2006-09-06 11:20:00 | AAPL | Stock | 2.5504 | 2.5521 | 2.5479 | 2.5479 | 7096572.0 |
| 2006-09-06 11:25:00 | AAPL | Stock | 2.5479 | 2.5489 | 2.5443 | 2.5468 | 9786868.0 |
| 2006-09-06 11:30:00 | AAPL | Stock | 2.5468 | 2.5475 | 2.5407 | 2.5425 | 8779372.0 |
| 2006-09-06 11:35:00 | AAPL | Stock | 2.5421 | 2.5454 | 2.5407 | 2.5443 | 8839964.0 |
| 2006-09-06 11:40:00 | AAPL | Stock | 2.5443 | 2.545 | 2.5382 | 2.5386 | 7020916.0 |
| 2006-09-06 11:45:00 | AAPL | Stock | 2.5386 | 2.5389 | 2.5293 | 2.5339 | 17892168.0 |
| 2006-09-06 11:50:00 | AAPL | Stock | 2.5343 | 2.5379 | 2.5336 | 2.5346 | 11678156.0 |
> showing 50 of 229,509 rows — these rows as CSV