PREVIEW / stock_5min / 2005-12-19
file: by_date/stock_5min/2005/2005-12-19.parquet size: 3.0 MB rows: 216,168 symbols: 2,155
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 |
|---|---|---|---|---|---|---|---|
| 2005-12-19 05:30:00 | AAPL | Stock | 2.5482 | 2.5482 | 2.5482 | 2.5482 | 5600.0 |
| 2005-12-19 05:50:00 | AAPL | Stock | 2.5482 | 2.5482 | 2.5464 | 2.5482 | 36400.0 |
| 2005-12-19 06:35:00 | AAPL | Stock | 2.55 | 2.5518 | 2.55 | 2.5518 | 14000.0 |
| 2005-12-19 06:40:00 | AAPL | Stock | 2.5518 | 2.5518 | 2.5518 | 2.5518 | 47600.0 |
| 2005-12-19 08:00:00 | AAPL | Stock | 2.55 | 2.55 | 2.5457 | 2.5482 | 186788.0 |
| 2005-12-19 08:05:00 | AAPL | Stock | 2.5464 | 2.5482 | 2.5454 | 2.5454 | 105000.0 |
| 2005-12-19 08:10:00 | AAPL | Stock | 2.5446 | 2.5446 | 2.5393 | 2.5393 | 247044.0 |
| 2005-12-19 08:15:00 | AAPL | Stock | 2.5425 | 2.5482 | 2.5425 | 2.5482 | 244160.0 |
| 2005-12-19 08:20:00 | AAPL | Stock | 2.5486 | 2.5536 | 2.5486 | 2.5518 | 117516.0 |
| 2005-12-19 08:25:00 | AAPL | Stock | 2.5507 | 2.5529 | 2.55 | 2.55 | 98000.0 |
| 2005-12-19 08:30:00 | AAPL | Stock | 2.55 | 2.5518 | 2.55 | 2.55 | 11200.0 |
| 2005-12-19 08:35:00 | AAPL | Stock | 2.55 | 2.55 | 2.5482 | 2.5482 | 35000.0 |
| 2005-12-19 08:40:00 | AAPL | Stock | 2.5486 | 2.5486 | 2.5482 | 2.5482 | 57820.0 |
| 2005-12-19 08:45:00 | AAPL | Stock | 2.5475 | 2.5475 | 2.5443 | 2.5446 | 229040.0 |
| 2005-12-19 08:50:00 | AAPL | Stock | 2.5446 | 2.5446 | 2.5393 | 2.5393 | 324912.0 |
| 2005-12-19 08:55:00 | AAPL | Stock | 2.5411 | 2.5446 | 2.5386 | 2.5446 | 23800.0 |
| 2005-12-19 09:00:00 | AAPL | Stock | 2.5429 | 2.5429 | 2.5429 | 2.5429 | 2800.0 |
| 2005-12-19 09:05:00 | AAPL | Stock | 2.5432 | 2.5446 | 2.5432 | 2.5446 | 152852.0 |
| 2005-12-19 09:10:00 | AAPL | Stock | 2.5464 | 2.5464 | 2.5432 | 2.5432 | 33600.0 |
| 2005-12-19 09:15:00 | AAPL | Stock | 2.5464 | 2.5464 | 2.5464 | 2.5464 | 16800.0 |
| 2005-12-19 09:20:00 | AAPL | Stock | 2.5446 | 2.5446 | 2.5414 | 2.5414 | 30800.0 |
| 2005-12-19 09:25:00 | AAPL | Stock | 2.5443 | 2.5446 | 2.5371 | 2.5386 | 544796.0 |
| 2005-12-19 09:30:00 | AAPL | Stock | 2.5396 | 2.55 | 2.5371 | 2.5411 | 17700928.0 |
| 2005-12-19 09:35:00 | AAPL | Stock | 2.5407 | 2.565 | 2.5393 | 2.5621 | 16492112.0 |
| 2005-12-19 09:40:00 | AAPL | Stock | 2.5621 | 2.5643 | 2.5496 | 2.5529 | 11917220.0 |
| 2005-12-19 09:45:00 | AAPL | Stock | 2.5525 | 2.5536 | 2.5382 | 2.5425 | 14222068.0 |
| 2005-12-19 09:50:00 | AAPL | Stock | 2.5425 | 2.5511 | 2.5411 | 2.5489 | 5155304.0 |
| 2005-12-19 09:55:00 | AAPL | Stock | 2.5496 | 2.5518 | 2.545 | 2.5493 | 5517148.0 |
| 2005-12-19 10:00:00 | AAPL | Stock | 2.5496 | 2.5625 | 2.5475 | 2.56 | 9869412.0 |
| 2005-12-19 10:05:00 | AAPL | Stock | 2.5604 | 2.5625 | 2.5514 | 2.5564 | 7668024.0 |
| 2005-12-19 10:10:00 | AAPL | Stock | 2.5568 | 2.5643 | 2.5554 | 2.5643 | 8174180.0 |
| 2005-12-19 10:15:00 | AAPL | Stock | 2.5643 | 2.5804 | 2.5632 | 2.5804 | 19547892.0 |
| 2005-12-19 10:20:00 | AAPL | Stock | 2.5804 | 2.5811 | 2.5739 | 2.5771 | 13250972.0 |
| 2005-12-19 10:25:00 | AAPL | Stock | 2.5775 | 2.5814 | 2.5696 | 2.5725 | 9326632.0 |
| 2005-12-19 10:30:00 | AAPL | Stock | 2.5721 | 2.5786 | 2.565 | 2.5779 | 10975076.0 |
| 2005-12-19 10:35:00 | AAPL | Stock | 2.5779 | 2.5889 | 2.5779 | 2.5814 | 15300740.0 |
| 2005-12-19 10:40:00 | AAPL | Stock | 2.5811 | 2.585 | 2.5771 | 2.5789 | 9427516.0 |
| 2005-12-19 10:45:00 | AAPL | Stock | 2.5796 | 2.5804 | 2.5732 | 2.5743 | 6630456.0 |
| 2005-12-19 10:50:00 | AAPL | Stock | 2.5739 | 2.5804 | 2.5732 | 2.5775 | 7595224.0 |
| 2005-12-19 10:55:00 | AAPL | Stock | 2.5775 | 2.5807 | 2.5754 | 2.5804 | 5559288.0 |
| 2005-12-19 11:00:00 | AAPL | Stock | 2.58 | 2.5807 | 2.5775 | 2.5793 | 5310088.0 |
| 2005-12-19 11:05:00 | AAPL | Stock | 2.5789 | 2.5882 | 2.5789 | 2.5821 | 9314088.0 |
| 2005-12-19 11:10:00 | AAPL | Stock | 2.5821 | 2.585 | 2.5786 | 2.5793 | 5521236.0 |
| 2005-12-19 11:15:00 | AAPL | Stock | 2.5793 | 2.5807 | 2.575 | 2.58 | 6093248.0 |
| 2005-12-19 11:20:00 | AAPL | Stock | 2.58 | 2.5807 | 2.5768 | 2.5779 | 4926544.0 |
| 2005-12-19 11:25:00 | AAPL | Stock | 2.5775 | 2.5843 | 2.5771 | 2.5829 | 5420912.0 |
| 2005-12-19 11:30:00 | AAPL | Stock | 2.5829 | 2.5889 | 2.5825 | 2.5886 | 4784976.0 |
| 2005-12-19 11:35:00 | AAPL | Stock | 2.5882 | 2.5886 | 2.5818 | 2.585 | 4470900.0 |
| 2005-12-19 11:40:00 | AAPL | Stock | 2.585 | 2.5882 | 2.5843 | 2.5857 | 3564064.0 |
| 2005-12-19 11:45:00 | AAPL | Stock | 2.5854 | 2.5929 | 2.5854 | 2.5886 | 4713856.0 |
> showing 50 of 216,168 rows — these rows as CSV