PREVIEW / stock_5min / 2009-02-09
file: by_date/stock_5min/2009/2009-02-09.parquet size: 4.3 MB rows: 299,150 symbols: 3,328
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 |
|---|---|---|---|---|---|---|---|
| 2009-02-09 06:35:00 | AAPL | Stock | 3.5446 | 3.5536 | 3.5446 | 3.5536 | 11200.0 |
| 2009-02-09 06:40:00 | AAPL | Stock | 3.5571 | 3.5571 | 3.5571 | 3.5571 | 3920.0 |
| 2009-02-09 07:10:00 | AAPL | Stock | 3.5536 | 3.5536 | 3.5536 | 3.5536 | 2800.0 |
| 2009-02-09 07:15:00 | AAPL | Stock | 3.5536 | 3.5536 | 3.5536 | 3.5536 | 5740.0 |
| 2009-02-09 07:20:00 | AAPL | Stock | 3.5536 | 3.5536 | 3.5536 | 3.5536 | 19460.0 |
| 2009-02-09 07:25:00 | AAPL | Stock | 3.5554 | 3.5554 | 3.5554 | 3.5554 | 5600.0 |
| 2009-02-09 07:30:00 | AAPL | Stock | 3.5571 | 3.5607 | 3.5571 | 3.5571 | 33600.0 |
| 2009-02-09 07:35:00 | AAPL | Stock | 3.5604 | 3.5604 | 3.5604 | 3.5604 | 2800.0 |
| 2009-02-09 07:50:00 | AAPL | Stock | 3.5571 | 3.5571 | 3.5571 | 3.5571 | 5600.0 |
| 2009-02-09 07:55:00 | AAPL | Stock | 3.555 | 3.5571 | 3.555 | 3.5571 | 8400.0 |
| 2009-02-09 08:00:00 | AAPL | Stock | 3.5536 | 3.5707 | 3.5536 | 3.5561 | 185444.0 |
| 2009-02-09 08:05:00 | AAPL | Stock | 3.5575 | 3.5589 | 3.5564 | 3.5586 | 66892.0 |
| 2009-02-09 08:10:00 | AAPL | Stock | 3.5614 | 3.5625 | 3.5571 | 3.5571 | 78904.0 |
| 2009-02-09 08:15:00 | AAPL | Stock | 3.5589 | 3.5607 | 3.5554 | 3.5607 | 56000.0 |
| 2009-02-09 08:20:00 | AAPL | Stock | 3.5607 | 3.5607 | 3.5579 | 3.56 | 58800.0 |
| 2009-02-09 08:25:00 | AAPL | Stock | 3.5607 | 3.5607 | 3.5607 | 3.5607 | 4480.0 |
| 2009-02-09 08:30:00 | AAPL | Stock | 3.5618 | 3.5629 | 3.5607 | 3.5607 | 38640.0 |
| 2009-02-09 08:35:00 | AAPL | Stock | 3.5589 | 3.5625 | 3.5561 | 3.5625 | 70280.0 |
| 2009-02-09 08:40:00 | AAPL | Stock | 3.5625 | 3.5643 | 3.5625 | 3.5643 | 72632.0 |
| 2009-02-09 08:45:00 | AAPL | Stock | 3.5679 | 3.5707 | 3.5679 | 3.5704 | 15400.0 |
| 2009-02-09 08:50:00 | AAPL | Stock | 3.5696 | 3.5707 | 3.5696 | 3.5704 | 15400.0 |
| 2009-02-09 09:00:00 | AAPL | Stock | 3.5679 | 3.5679 | 3.5679 | 3.5679 | 3640.0 |
| 2009-02-09 09:05:00 | AAPL | Stock | 3.5693 | 3.5693 | 3.5636 | 3.5679 | 70000.0 |
| 2009-02-09 09:10:00 | AAPL | Stock | 3.57 | 3.57 | 3.5661 | 3.5664 | 90944.0 |
| 2009-02-09 09:15:00 | AAPL | Stock | 3.5693 | 3.57 | 3.5664 | 3.5668 | 47600.0 |
| 2009-02-09 09:20:00 | AAPL | Stock | 3.5675 | 3.5771 | 3.5675 | 3.5771 | 329252.0 |
| 2009-02-09 09:25:00 | AAPL | Stock | 3.5771 | 3.5861 | 3.5696 | 3.5696 | 1134196.0 |
| 2009-02-09 09:30:00 | AAPL | Stock | 3.5679 | 3.5736 | 3.5536 | 3.5607 | 13008716.0 |
| 2009-02-09 09:35:00 | AAPL | Stock | 3.5614 | 3.57 | 3.5564 | 3.5694 | 14032424.0 |
| 2009-02-09 09:40:00 | AAPL | Stock | 3.5693 | 3.5932 | 3.5671 | 3.5868 | 28871472.0 |
| 2009-02-09 09:45:00 | AAPL | Stock | 3.5868 | 3.6064 | 3.5804 | 3.6043 | 18467876.0 |
| 2009-02-09 09:50:00 | AAPL | Stock | 3.6046 | 3.6336 | 3.6011 | 3.6293 | 22002316.0 |
| 2009-02-09 09:55:00 | AAPL | Stock | 3.6286 | 3.6368 | 3.6175 | 3.6336 | 17532088.0 |
| 2009-02-09 10:00:00 | AAPL | Stock | 3.6339 | 3.6339 | 3.6014 | 3.6046 | 17748192.0 |
| 2009-02-09 10:05:00 | AAPL | Stock | 3.6042 | 3.6161 | 3.6025 | 3.615 | 15309420.0 |
| 2009-02-09 10:10:00 | AAPL | Stock | 3.6154 | 3.6389 | 3.615 | 3.6318 | 14445816.0 |
| 2009-02-09 10:15:00 | AAPL | Stock | 3.6321 | 3.6407 | 3.6315 | 3.6393 | 12655104.0 |
| 2009-02-09 10:20:00 | AAPL | Stock | 3.6393 | 3.6571 | 3.6393 | 3.6507 | 24117688.0 |
| 2009-02-09 10:25:00 | AAPL | Stock | 3.6504 | 3.6532 | 3.6382 | 3.6418 | 10039876.0 |
| 2009-02-09 10:30:00 | AAPL | Stock | 3.6421 | 3.6421 | 3.6343 | 3.6354 | 8214696.0 |
| 2009-02-09 10:35:00 | AAPL | Stock | 3.6357 | 3.6514 | 3.6354 | 3.6475 | 11231752.0 |
| 2009-02-09 10:40:00 | AAPL | Stock | 3.6475 | 3.6546 | 3.6457 | 3.6521 | 12052992.0 |
| 2009-02-09 10:45:00 | AAPL | Stock | 3.6529 | 3.6725 | 3.6439 | 3.6682 | 18570160.0 |
| 2009-02-09 10:50:00 | AAPL | Stock | 3.6682 | 3.6686 | 3.6546 | 3.6575 | 11931724.0 |
| 2009-02-09 10:55:00 | AAPL | Stock | 3.6571 | 3.6714 | 3.6555 | 3.6689 | 9458092.0 |
| 2009-02-09 11:00:00 | AAPL | Stock | 3.6696 | 3.67 | 3.6554 | 3.6554 | 9288384.0 |
| 2009-02-09 11:05:00 | AAPL | Stock | 3.6554 | 3.6575 | 3.6454 | 3.6517 | 10860080.0 |
| 2009-02-09 11:10:00 | AAPL | Stock | 3.6518 | 3.6554 | 3.65 | 3.6521 | 5466916.0 |
| 2009-02-09 11:15:00 | AAPL | Stock | 3.6521 | 3.6561 | 3.6475 | 3.6521 | 6064100.0 |
| 2009-02-09 11:20:00 | AAPL | Stock | 3.6518 | 3.6607 | 3.65 | 3.6568 | 7970424.0 |
> showing 50 of 299,150 rows — these rows as CSV