PREVIEW / stock_5min / 2006-02-27
file: by_date/stock_5min/2006/2006-02-27.parquet size: 3.0 MB rows: 217,352 symbols: 2,199
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-02-27 04:15:00 | AAPL | Stock | 2.5589 | 2.5589 | 2.5589 | 2.5589 | 2800.0 |
| 2006-02-27 06:05:00 | AAPL | Stock | 2.5696 | 2.5696 | 2.5696 | 2.5696 | 14000.0 |
| 2006-02-27 07:05:00 | AAPL | Stock | 2.5625 | 2.5625 | 2.5554 | 2.5554 | 67200.0 |
| 2006-02-27 07:10:00 | AAPL | Stock | 2.5554 | 2.5554 | 2.5554 | 2.5554 | 42000.0 |
| 2006-02-27 07:50:00 | AAPL | Stock | 2.5575 | 2.5625 | 2.5575 | 2.5625 | 84000.0 |
| 2006-02-27 07:55:00 | AAPL | Stock | 2.5625 | 2.5625 | 2.5625 | 2.5625 | 8400.0 |
| 2006-02-27 08:00:00 | AAPL | Stock | 2.5589 | 2.5786 | 2.5589 | 2.5768 | 763868.0 |
| 2006-02-27 08:05:00 | AAPL | Stock | 2.5768 | 2.5779 | 2.5732 | 2.5732 | 545860.0 |
| 2006-02-27 08:10:00 | AAPL | Stock | 2.5732 | 2.5736 | 2.5714 | 2.5732 | 405160.0 |
| 2006-02-27 08:15:00 | AAPL | Stock | 2.5729 | 2.5736 | 2.5718 | 2.5732 | 227080.0 |
| 2006-02-27 08:20:00 | AAPL | Stock | 2.5721 | 2.5732 | 2.5721 | 2.5732 | 29400.0 |
| 2006-02-27 08:25:00 | AAPL | Stock | 2.5729 | 2.5729 | 2.5718 | 2.5721 | 89600.0 |
| 2006-02-27 08:30:00 | AAPL | Stock | 2.5718 | 2.5736 | 2.5714 | 2.5732 | 228620.0 |
| 2006-02-27 08:35:00 | AAPL | Stock | 2.5732 | 2.5732 | 2.5714 | 2.5714 | 70588.0 |
| 2006-02-27 08:40:00 | AAPL | Stock | 2.5714 | 2.5732 | 2.5714 | 2.5729 | 39200.0 |
| 2006-02-27 08:45:00 | AAPL | Stock | 2.5732 | 2.5732 | 2.5718 | 2.5725 | 65800.0 |
| 2006-02-27 08:50:00 | AAPL | Stock | 2.5725 | 2.5732 | 2.5521 | 2.5732 | 792400.0 |
| 2006-02-27 08:55:00 | AAPL | Stock | 2.5725 | 2.5725 | 2.5714 | 2.5725 | 270200.0 |
| 2006-02-27 09:00:00 | AAPL | Stock | 2.5732 | 2.5732 | 2.5725 | 2.5732 | 524720.0 |
| 2006-02-27 09:05:00 | AAPL | Stock | 2.5729 | 2.5729 | 2.5714 | 2.5725 | 370160.0 |
| 2006-02-27 09:10:00 | AAPL | Stock | 2.5729 | 2.5732 | 2.57 | 2.5707 | 570332.0 |
| 2006-02-27 09:15:00 | AAPL | Stock | 2.5711 | 2.5714 | 2.5696 | 2.5704 | 226800.0 |
| 2006-02-27 09:20:00 | AAPL | Stock | 2.5704 | 2.575 | 2.5696 | 2.5732 | 656516.0 |
| 2006-02-27 09:25:00 | AAPL | Stock | 2.5725 | 2.5771 | 2.5643 | 2.5725 | 2696064.0 |
| 2006-02-27 09:30:00 | AAPL | Stock | 2.5711 | 2.5757 | 2.5618 | 2.5661 | 26690692.0 |
| 2006-02-27 09:35:00 | AAPL | Stock | 2.5661 | 2.5746 | 2.5543 | 2.5561 | 15152424.0 |
| 2006-02-27 09:40:00 | AAPL | Stock | 2.5564 | 2.5611 | 2.5357 | 2.54 | 30769172.0 |
| 2006-02-27 09:45:00 | AAPL | Stock | 2.5404 | 2.545 | 2.5311 | 2.5371 | 30071972.0 |
| 2006-02-27 09:50:00 | AAPL | Stock | 2.5371 | 2.5457 | 2.5304 | 2.5443 | 22892240.0 |
| 2006-02-27 09:55:00 | AAPL | Stock | 2.5443 | 2.5643 | 2.5432 | 2.5586 | 27343848.0 |
| 2006-02-27 10:00:00 | AAPL | Stock | 2.5589 | 2.5643 | 2.5464 | 2.5482 | 21768208.0 |
| 2006-02-27 10:05:00 | AAPL | Stock | 2.5482 | 2.5507 | 2.5393 | 2.5429 | 14112112.0 |
| 2006-02-27 10:10:00 | AAPL | Stock | 2.5429 | 2.5493 | 2.5357 | 2.5479 | 15988112.0 |
| 2006-02-27 10:15:00 | AAPL | Stock | 2.5479 | 2.5493 | 2.5336 | 2.5343 | 12910744.0 |
| 2006-02-27 10:20:00 | AAPL | Stock | 2.5343 | 2.5414 | 2.5232 | 2.5404 | 22304744.0 |
| 2006-02-27 10:25:00 | AAPL | Stock | 2.5404 | 2.5429 | 2.5336 | 2.5361 | 10229268.0 |
| 2006-02-27 10:30:00 | AAPL | Stock | 2.5361 | 2.5411 | 2.5318 | 2.5407 | 7273476.0 |
| 2006-02-27 10:35:00 | AAPL | Stock | 2.5407 | 2.5411 | 2.5339 | 2.5371 | 6637960.0 |
| 2006-02-27 10:40:00 | AAPL | Stock | 2.5371 | 2.5371 | 2.5271 | 2.5361 | 10747016.0 |
| 2006-02-27 10:45:00 | AAPL | Stock | 2.535 | 2.5382 | 2.5307 | 2.5357 | 6618024.0 |
| 2006-02-27 10:50:00 | AAPL | Stock | 2.5357 | 2.5393 | 2.5332 | 2.5386 | 4914952.0 |
| 2006-02-27 10:55:00 | AAPL | Stock | 2.5382 | 2.5382 | 2.5282 | 2.5282 | 7047600.0 |
| 2006-02-27 11:00:00 | AAPL | Stock | 2.5286 | 2.5393 | 2.5264 | 2.5386 | 8290156.0 |
| 2006-02-27 11:05:00 | AAPL | Stock | 2.5386 | 2.5464 | 2.5368 | 2.5461 | 11652648.0 |
| 2006-02-27 11:10:00 | AAPL | Stock | 2.5461 | 2.5586 | 2.5454 | 2.5564 | 16588376.0 |
| 2006-02-27 11:15:00 | AAPL | Stock | 2.5564 | 2.565 | 2.5514 | 2.5611 | 24501876.0 |
| 2006-02-27 11:20:00 | AAPL | Stock | 2.5614 | 2.565 | 2.5579 | 2.5593 | 13013952.0 |
| 2006-02-27 11:25:00 | AAPL | Stock | 2.5589 | 2.5707 | 2.5582 | 2.5679 | 13784568.0 |
| 2006-02-27 11:30:00 | AAPL | Stock | 2.5686 | 2.5707 | 2.565 | 2.5664 | 11780188.0 |
| 2006-02-27 11:35:00 | AAPL | Stock | 2.5664 | 2.5746 | 2.5661 | 2.5704 | 16374092.0 |
> showing 50 of 217,352 rows — these rows as CSV