PREVIEW / stock_5min / 2006-01-30
file: by_date/stock_5min/2006/2006-01-30.parquet size: 3.0 MB rows: 218,022 symbols: 2,186
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-01-30 04:25:00 | AAPL | Stock | 2.5732 | 2.5732 | 2.5732 | 2.5732 | 5600.0 |
| 2006-01-30 04:35:00 | AAPL | Stock | 2.5732 | 2.575 | 2.5732 | 2.575 | 11200.0 |
| 2006-01-30 04:50:00 | AAPL | Stock | 2.5768 | 2.5768 | 2.5768 | 2.5768 | 11200.0 |
| 2006-01-30 04:55:00 | AAPL | Stock | 2.575 | 2.575 | 2.575 | 2.575 | 5600.0 |
| 2006-01-30 05:00:00 | AAPL | Stock | 2.5768 | 2.5768 | 2.5768 | 2.5768 | 39200.0 |
| 2006-01-30 05:40:00 | AAPL | Stock | 2.5804 | 2.5804 | 2.5804 | 2.5804 | 2800.0 |
| 2006-01-30 05:45:00 | AAPL | Stock | 2.5768 | 2.5768 | 2.5732 | 2.5732 | 170800.0 |
| 2006-01-30 05:50:00 | AAPL | Stock | 2.5732 | 2.5732 | 2.5714 | 2.5714 | 61600.0 |
| 2006-01-30 06:35:00 | AAPL | Stock | 2.575 | 2.575 | 2.575 | 2.575 | 14000.0 |
| 2006-01-30 06:45:00 | AAPL | Stock | 2.575 | 2.5768 | 2.575 | 2.5768 | 5600.0 |
| 2006-01-30 06:50:00 | AAPL | Stock | 2.5768 | 2.5768 | 2.5768 | 2.5768 | 56000.0 |
| 2006-01-30 06:55:00 | AAPL | Stock | 2.575 | 2.5768 | 2.575 | 2.5768 | 64960.0 |
| 2006-01-30 07:00:00 | AAPL | Stock | 2.5768 | 2.5768 | 2.5714 | 2.5714 | 5600.0 |
| 2006-01-30 07:05:00 | AAPL | Stock | 2.5732 | 2.5732 | 2.5732 | 2.5732 | 8400.0 |
| 2006-01-30 07:15:00 | AAPL | Stock | 2.5714 | 2.5714 | 2.5714 | 2.5714 | 58800.0 |
| 2006-01-30 07:20:00 | AAPL | Stock | 2.5664 | 2.5664 | 2.5661 | 2.5661 | 25200.0 |
| 2006-01-30 07:25:00 | AAPL | Stock | 2.5646 | 2.5661 | 2.5571 | 2.5643 | 58800.0 |
| 2006-01-30 07:30:00 | AAPL | Stock | 2.5607 | 2.5607 | 2.5607 | 2.5607 | 18200.0 |
| 2006-01-30 07:35:00 | AAPL | Stock | 2.5607 | 2.5607 | 2.5571 | 2.5604 | 56000.0 |
| 2006-01-30 07:40:00 | AAPL | Stock | 2.5604 | 2.5607 | 2.56 | 2.5607 | 140000.0 |
| 2006-01-30 07:45:00 | AAPL | Stock | 2.5554 | 2.5554 | 2.5554 | 2.5554 | 16800.0 |
| 2006-01-30 08:00:00 | AAPL | Stock | 2.5661 | 2.5696 | 2.5607 | 2.5664 | 401100.0 |
| 2006-01-30 08:05:00 | AAPL | Stock | 2.5671 | 2.5671 | 2.5536 | 2.56 | 1111348.0 |
| 2006-01-30 08:10:00 | AAPL | Stock | 2.56 | 2.5618 | 2.5582 | 2.5589 | 167160.0 |
| 2006-01-30 08:15:00 | AAPL | Stock | 2.5582 | 2.5582 | 2.5518 | 2.5518 | 537936.0 |
| 2006-01-30 08:20:00 | AAPL | Stock | 2.5532 | 2.5536 | 2.5436 | 2.5507 | 1103424.0 |
| 2006-01-30 08:25:00 | AAPL | Stock | 2.5511 | 2.5571 | 2.5461 | 2.5518 | 536480.0 |
| 2006-01-30 08:30:00 | AAPL | Stock | 2.5518 | 2.5557 | 2.5518 | 2.5536 | 351064.0 |
| 2006-01-30 08:35:00 | AAPL | Stock | 2.5536 | 2.56 | 2.5536 | 2.5593 | 244300.0 |
| 2006-01-30 08:40:00 | AAPL | Stock | 2.5593 | 2.5593 | 2.5554 | 2.5571 | 173096.0 |
| 2006-01-30 08:45:00 | AAPL | Stock | 2.5557 | 2.5604 | 2.5554 | 2.5554 | 190372.0 |
| 2006-01-30 08:50:00 | AAPL | Stock | 2.5561 | 2.5575 | 2.5539 | 2.5543 | 361256.0 |
| 2006-01-30 08:55:00 | AAPL | Stock | 2.5539 | 2.5539 | 2.5518 | 2.5529 | 345436.0 |
| 2006-01-30 09:00:00 | AAPL | Stock | 2.5521 | 2.5521 | 2.5489 | 2.5504 | 447104.0 |
| 2006-01-30 09:05:00 | AAPL | Stock | 2.5514 | 2.5518 | 2.5471 | 2.5482 | 703920.0 |
| 2006-01-30 09:10:00 | AAPL | Stock | 2.5482 | 2.5482 | 2.5432 | 2.5446 | 1428784.0 |
| 2006-01-30 09:15:00 | AAPL | Stock | 2.5446 | 2.5461 | 2.5429 | 2.5429 | 1014132.0 |
| 2006-01-30 09:20:00 | AAPL | Stock | 2.5432 | 2.5432 | 2.5332 | 2.5361 | 2188732.0 |
| 2006-01-30 09:25:00 | AAPL | Stock | 2.5404 | 2.5468 | 2.5375 | 2.5461 | 3742340.0 |
| 2006-01-30 09:30:00 | AAPL | Stock | 2.5418 | 2.5607 | 2.5311 | 2.535 | 48329708.0 |
| 2006-01-30 09:35:00 | AAPL | Stock | 2.5343 | 2.5714 | 2.5318 | 2.5632 | 43052856.0 |
| 2006-01-30 09:40:00 | AAPL | Stock | 2.5639 | 2.5736 | 2.5554 | 2.5639 | 30649528.0 |
| 2006-01-30 09:45:00 | AAPL | Stock | 2.5632 | 2.5793 | 2.555 | 2.5793 | 23658852.0 |
| 2006-01-30 09:50:00 | AAPL | Stock | 2.5793 | 2.5875 | 2.5639 | 2.5746 | 25611208.0 |
| 2006-01-30 09:55:00 | AAPL | Stock | 2.5746 | 2.5768 | 2.5632 | 2.5686 | 14389928.0 |
| 2006-01-30 10:00:00 | AAPL | Stock | 2.5679 | 2.5718 | 2.5611 | 2.565 | 12014772.0 |
| 2006-01-30 10:05:00 | AAPL | Stock | 2.5646 | 2.5782 | 2.5546 | 2.5546 | 15947148.0 |
| 2006-01-30 10:10:00 | AAPL | Stock | 2.5546 | 2.5664 | 2.5546 | 2.5632 | 10948644.0 |
| 2006-01-30 10:15:00 | AAPL | Stock | 2.5636 | 2.5771 | 2.5636 | 2.5682 | 8295644.0 |
| 2006-01-30 10:20:00 | AAPL | Stock | 2.5682 | 2.575 | 2.5632 | 2.5721 | 8408148.0 |
> showing 50 of 218,022 rows — these rows as CSV