PREVIEW / stock_5min / 2007-05-01
file: by_date/stock_5min/2007/2007-05-01.parquet size: 3.8 MB rows: 273,646 symbols: 2,677
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 |
|---|---|---|---|---|---|---|---|
| 2007-05-01 09:30:00 | AAPL | Stock | 3.5568 | 3.5732 | 3.555 | 3.5732 | 16978052.0 |
| 2007-05-01 09:35:00 | AAPL | Stock | 3.5729 | 3.5764 | 3.5671 | 3.5693 | 10651536.0 |
| 2007-05-01 09:40:00 | AAPL | Stock | 3.5689 | 3.5768 | 3.5671 | 3.5743 | 12017124.0 |
| 2007-05-01 09:45:00 | AAPL | Stock | 3.5739 | 3.5839 | 3.5714 | 3.5818 | 10702356.0 |
| 2007-05-01 09:50:00 | AAPL | Stock | 3.5814 | 3.5829 | 3.5714 | 3.5714 | 6902336.0 |
| 2007-05-01 09:55:00 | AAPL | Stock | 3.5714 | 3.5718 | 3.5475 | 3.5579 | 16270016.0 |
| 2007-05-01 10:00:00 | AAPL | Stock | 3.5579 | 3.5607 | 3.55 | 3.5507 | 16170504.0 |
| 2007-05-01 10:05:00 | AAPL | Stock | 3.5511 | 3.5511 | 3.5429 | 3.545 | 12207692.0 |
| 2007-05-01 10:10:00 | AAPL | Stock | 3.545 | 3.555 | 3.5446 | 3.5504 | 9712836.0 |
| 2007-05-01 10:15:00 | AAPL | Stock | 3.55 | 3.5596 | 3.5461 | 3.555 | 10354036.0 |
| 2007-05-01 10:20:00 | AAPL | Stock | 3.5557 | 3.5568 | 3.5346 | 3.5357 | 9424044.0 |
| 2007-05-01 10:25:00 | AAPL | Stock | 3.5357 | 3.545 | 3.5196 | 3.5268 | 20036660.0 |
| 2007-05-01 10:30:00 | AAPL | Stock | 3.525 | 3.5336 | 3.5225 | 3.5268 | 11080244.0 |
| 2007-05-01 10:35:00 | AAPL | Stock | 3.5268 | 3.5357 | 3.5265 | 3.5311 | 15094324.0 |
| 2007-05-01 10:40:00 | AAPL | Stock | 3.5311 | 3.5318 | 3.525 | 3.5254 | 7126336.0 |
| 2007-05-01 10:45:00 | AAPL | Stock | 3.5254 | 3.5293 | 3.5232 | 3.5282 | 5848360.0 |
| 2007-05-01 10:50:00 | AAPL | Stock | 3.5286 | 3.5296 | 3.5232 | 3.5286 | 5444292.0 |
| 2007-05-01 10:55:00 | AAPL | Stock | 3.5286 | 3.5357 | 3.5257 | 3.5311 | 8956500.0 |
| 2007-05-01 11:00:00 | AAPL | Stock | 3.5304 | 3.5311 | 3.525 | 3.5293 | 5103420.0 |
| 2007-05-01 11:05:00 | AAPL | Stock | 3.5296 | 3.5836 | 3.5271 | 3.5293 | 4329808.0 |
| 2007-05-01 11:10:00 | AAPL | Stock | 3.5296 | 3.5346 | 3.5289 | 3.5336 | 5286260.0 |
| 2007-05-01 11:15:00 | AAPL | Stock | 3.5339 | 3.54 | 3.5339 | 3.5382 | 5697720.0 |
| 2007-05-01 11:20:00 | AAPL | Stock | 3.5389 | 3.5461 | 3.5371 | 3.5439 | 9441740.0 |
| 2007-05-01 11:25:00 | AAPL | Stock | 3.5436 | 3.5475 | 3.5411 | 3.5414 | 5773740.0 |
| 2007-05-01 11:30:00 | AAPL | Stock | 3.5418 | 3.5504 | 3.5411 | 3.5501 | 6430564.0 |
| 2007-05-01 11:35:00 | AAPL | Stock | 3.55 | 3.5529 | 3.5489 | 3.5514 | 5280436.0 |
| 2007-05-01 11:40:00 | AAPL | Stock | 3.5511 | 3.5514 | 3.5464 | 3.5496 | 5323500.0 |
| 2007-05-01 11:45:00 | AAPL | Stock | 3.5493 | 3.5504 | 3.545 | 3.5461 | 4980696.0 |
| 2007-05-01 11:50:00 | AAPL | Stock | 3.5464 | 3.5471 | 3.5361 | 3.5367 | 6883436.0 |
| 2007-05-01 11:55:00 | AAPL | Stock | 3.5368 | 3.5457 | 3.5361 | 3.5418 | 4458216.0 |
| 2007-05-01 12:00:00 | AAPL | Stock | 3.5414 | 3.5436 | 3.5396 | 3.5432 | 2750160.0 |
| 2007-05-01 12:05:00 | AAPL | Stock | 3.5432 | 3.5464 | 3.5407 | 3.5425 | 4590684.0 |
| 2007-05-01 12:10:00 | AAPL | Stock | 3.5429 | 3.5457 | 3.5411 | 3.5439 | 2233280.0 |
| 2007-05-01 12:15:00 | AAPL | Stock | 3.5436 | 3.5457 | 3.5404 | 3.5415 | 2777684.0 |
| 2007-05-01 12:20:00 | AAPL | Stock | 3.5418 | 3.5425 | 3.5371 | 3.5396 | 2725576.0 |
| 2007-05-01 12:25:00 | AAPL | Stock | 3.5396 | 3.5396 | 3.5293 | 3.5304 | 4583516.0 |
| 2007-05-01 12:30:00 | AAPL | Stock | 3.5307 | 3.5357 | 3.53 | 3.5357 | 3314192.0 |
| 2007-05-01 12:35:00 | AAPL | Stock | 3.5357 | 3.5393 | 3.5314 | 3.5321 | 2577596.0 |
| 2007-05-01 12:40:00 | AAPL | Stock | 3.5318 | 3.5393 | 3.5307 | 3.5343 | 3586492.0 |
| 2007-05-01 12:45:00 | AAPL | Stock | 3.5339 | 3.535 | 3.5314 | 3.5329 | 1754844.0 |
| 2007-05-01 12:50:00 | AAPL | Stock | 3.5336 | 3.5368 | 3.5272 | 3.5286 | 3706136.0 |
| 2007-05-01 12:55:00 | AAPL | Stock | 3.5282 | 3.5357 | 3.5279 | 3.5286 | 4087216.0 |
| 2007-05-01 13:00:00 | AAPL | Stock | 3.5286 | 3.5289 | 3.5232 | 3.5254 | 6390524.0 |
| 2007-05-01 13:05:00 | AAPL | Stock | 3.5254 | 3.5289 | 3.525 | 3.5271 | 2415336.0 |
| 2007-05-01 13:10:00 | AAPL | Stock | 3.5272 | 3.5321 | 3.525 | 3.5257 | 3859128.0 |
| 2007-05-01 13:15:00 | AAPL | Stock | 3.5257 | 3.5282 | 3.5214 | 3.5282 | 4631928.0 |
| 2007-05-01 13:20:00 | AAPL | Stock | 3.5279 | 3.5289 | 3.5214 | 3.5221 | 5115320.0 |
| 2007-05-01 13:25:00 | AAPL | Stock | 3.5221 | 3.5336 | 3.5218 | 3.5323 | 5971364.0 |
| 2007-05-01 13:30:00 | AAPL | Stock | 3.5325 | 3.5371 | 3.5307 | 3.5371 | 7292656.0 |
| 2007-05-01 13:35:00 | AAPL | Stock | 3.5368 | 3.5414 | 3.5346 | 3.5411 | 7669424.0 |
> showing 50 of 273,646 rows — these rows as CSV