PREVIEW / stock_5min / 2010-12-13
file: by_date/stock_5min/2010/2010-12-13.parquet size: 5.0 MB rows: 340,237 symbols: 3,542
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 |
|---|---|---|---|---|---|---|---|
| 2010-12-13 04:00:00 | AAPL | Stock | 11.4939 | 11.5071 | 11.4846 | 11.5036 | 84560.0 |
| 2010-12-13 04:05:00 | AAPL | Stock | 11.5071 | 11.5071 | 11.5071 | 11.5071 | 14000.0 |
| 2010-12-13 04:15:00 | AAPL | Stock | 11.5268 | 11.5268 | 11.5268 | 11.5268 | 2800.0 |
| 2010-12-13 04:20:00 | AAPL | Stock | 11.5268 | 11.5289 | 11.5268 | 11.5289 | 16800.0 |
| 2010-12-13 04:25:00 | AAPL | Stock | 11.5389 | 11.55 | 11.5389 | 11.55 | 46144.0 |
| 2010-12-13 04:30:00 | AAPL | Stock | 11.5639 | 11.5639 | 11.5496 | 11.5529 | 33600.0 |
| 2010-12-13 04:40:00 | AAPL | Stock | 11.5286 | 11.5286 | 11.5286 | 11.5286 | 18060.0 |
| 2010-12-13 04:45:00 | AAPL | Stock | 11.5246 | 11.5357 | 11.5246 | 11.5357 | 28000.0 |
| 2010-12-13 04:50:00 | AAPL | Stock | 11.5357 | 11.5357 | 11.5357 | 11.5357 | 30800.0 |
| 2010-12-13 05:00:00 | AAPL | Stock | 11.5357 | 11.5357 | 11.5357 | 11.5357 | 2800.0 |
| 2010-12-13 05:35:00 | AAPL | Stock | 11.5536 | 11.5536 | 11.5536 | 11.5536 | 2800.0 |
| 2010-12-13 05:40:00 | AAPL | Stock | 11.5464 | 11.55 | 11.5464 | 11.55 | 33600.0 |
| 2010-12-13 05:45:00 | AAPL | Stock | 11.5536 | 11.5639 | 11.5536 | 11.5639 | 23800.0 |
| 2010-12-13 05:50:00 | AAPL | Stock | 11.5639 | 11.5639 | 11.5639 | 11.5639 | 2800.0 |
| 2010-12-13 05:55:00 | AAPL | Stock | 11.5668 | 11.5689 | 11.5668 | 11.5689 | 35504.0 |
| 2010-12-13 06:10:00 | AAPL | Stock | 11.5593 | 11.5593 | 11.5575 | 11.5575 | 5600.0 |
| 2010-12-13 06:15:00 | AAPL | Stock | 11.56 | 11.56 | 11.56 | 11.56 | 2800.0 |
| 2010-12-13 06:20:00 | AAPL | Stock | 11.5643 | 11.5643 | 11.5643 | 11.5643 | 2800.0 |
| 2010-12-13 06:30:00 | AAPL | Stock | 11.5643 | 11.5714 | 11.5643 | 11.5714 | 76160.0 |
| 2010-12-13 06:40:00 | AAPL | Stock | 11.5714 | 11.5714 | 11.5714 | 11.5714 | 2800.0 |
| 2010-12-13 06:45:00 | AAPL | Stock | 11.575 | 11.5754 | 11.575 | 11.5754 | 8400.0 |
| 2010-12-13 06:50:00 | AAPL | Stock | 11.5782 | 11.5846 | 11.5782 | 11.5846 | 8400.0 |
| 2010-12-13 06:55:00 | AAPL | Stock | 11.5868 | 11.5893 | 11.5846 | 11.5846 | 48160.0 |
| 2010-12-13 07:00:00 | AAPL | Stock | 11.5957 | 11.5968 | 11.5679 | 11.5682 | 212548.0 |
| 2010-12-13 07:05:00 | AAPL | Stock | 11.5696 | 11.5714 | 11.5682 | 11.5682 | 57148.0 |
| 2010-12-13 07:10:00 | AAPL | Stock | 11.5736 | 11.5736 | 11.5693 | 11.5714 | 91672.0 |
| 2010-12-13 07:15:00 | AAPL | Stock | 11.5632 | 11.5714 | 11.5632 | 11.5714 | 19600.0 |
| 2010-12-13 07:20:00 | AAPL | Stock | 11.5786 | 11.5786 | 11.5529 | 11.5704 | 73864.0 |
| 2010-12-13 07:25:00 | AAPL | Stock | 11.5632 | 11.58 | 11.5632 | 11.5764 | 209860.0 |
| 2010-12-13 07:30:00 | AAPL | Stock | 11.58 | 11.58 | 11.5539 | 11.5589 | 168392.0 |
| 2010-12-13 07:35:00 | AAPL | Stock | 11.5589 | 11.5632 | 11.5514 | 11.5571 | 58772.0 |
| 2010-12-13 07:40:00 | AAPL | Stock | 11.5639 | 11.5643 | 11.5579 | 11.5643 | 64680.0 |
| 2010-12-13 07:45:00 | AAPL | Stock | 11.5711 | 11.5757 | 11.5607 | 11.5757 | 138292.0 |
| 2010-12-13 07:50:00 | AAPL | Stock | 11.5718 | 11.5761 | 11.5661 | 11.5761 | 359548.0 |
| 2010-12-13 07:55:00 | AAPL | Stock | 11.5775 | 11.5839 | 11.5775 | 11.5829 | 262724.0 |
| 2010-12-13 08:00:00 | AAPL | Stock | 11.5793 | 11.58 | 11.5368 | 11.5607 | 1521296.0 |
| 2010-12-13 08:05:00 | AAPL | Stock | 11.5593 | 11.5607 | 11.5454 | 11.5571 | 529424.0 |
| 2010-12-13 08:10:00 | AAPL | Stock | 11.5571 | 11.5571 | 11.5482 | 11.55 | 513408.0 |
| 2010-12-13 08:15:00 | AAPL | Stock | 11.5507 | 11.5536 | 11.5464 | 11.5532 | 533232.0 |
| 2010-12-13 08:20:00 | AAPL | Stock | 11.5514 | 11.5586 | 11.55 | 11.5586 | 702604.0 |
| 2010-12-13 08:25:00 | AAPL | Stock | 11.5586 | 11.5607 | 11.5582 | 11.56 | 467572.0 |
| 2010-12-13 08:30:00 | AAPL | Stock | 11.5582 | 11.5646 | 11.5582 | 11.5636 | 683508.0 |
| 2010-12-13 08:35:00 | AAPL | Stock | 11.5625 | 11.5754 | 11.5607 | 11.5743 | 1298836.0 |
| 2010-12-13 08:40:00 | AAPL | Stock | 11.5757 | 11.5864 | 11.5714 | 11.5804 | 1122212.0 |
| 2010-12-13 08:45:00 | AAPL | Stock | 11.5811 | 11.5864 | 11.5779 | 11.5854 | 661052.0 |
| 2010-12-13 08:50:00 | AAPL | Stock | 11.5839 | 11.5946 | 11.5814 | 11.5946 | 810180.0 |
| 2010-12-13 08:55:00 | AAPL | Stock | 11.5946 | 11.5968 | 11.5893 | 11.5946 | 509600.0 |
| 2010-12-13 09:00:00 | AAPL | Stock | 11.5939 | 11.6161 | 11.5929 | 11.6161 | 2412172.0 |
| 2010-12-13 09:05:00 | AAPL | Stock | 11.6161 | 11.6254 | 11.6143 | 11.6168 | 1712844.0 |
| 2010-12-13 09:10:00 | AAPL | Stock | 11.6179 | 11.6268 | 11.6168 | 11.6196 | 1023932.0 |
> showing 50 of 340,237 rows — these rows as CSV