PREVIEW / stock_5min / 2008-12-11
file: by_date/stock_5min/2008/2008-12-11.parquet size: 4.4 MB rows: 312,783 symbols: 3,342
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 |
|---|---|---|---|---|---|---|---|
| 2008-12-11 08:00:00 | AAPL | Stock | 3.5043 | 3.5054 | 3.5043 | 3.5054 | 20720.0 |
| 2008-12-11 08:05:00 | AAPL | Stock | 3.5 | 3.5054 | 3.4982 | 3.5054 | 52360.0 |
| 2008-12-11 08:10:00 | AAPL | Stock | 3.4964 | 3.4964 | 3.4893 | 3.4893 | 31024.0 |
| 2008-12-11 08:15:00 | AAPL | Stock | 3.4893 | 3.4893 | 3.4886 | 3.4886 | 30856.0 |
| 2008-12-11 08:25:00 | AAPL | Stock | 3.4821 | 3.4825 | 3.4793 | 3.4825 | 33600.0 |
| 2008-12-11 08:30:00 | AAPL | Stock | 3.4789 | 3.4961 | 3.4768 | 3.4896 | 155792.0 |
| 2008-12-11 08:35:00 | AAPL | Stock | 3.4854 | 3.4854 | 3.4768 | 3.4768 | 134008.0 |
| 2008-12-11 08:40:00 | AAPL | Stock | 3.4782 | 3.4782 | 3.4736 | 3.4736 | 50400.0 |
| 2008-12-11 08:45:00 | AAPL | Stock | 3.4736 | 3.4786 | 3.4718 | 3.4729 | 146608.0 |
| 2008-12-11 08:50:00 | AAPL | Stock | 3.4725 | 3.4725 | 3.4714 | 3.4714 | 40600.0 |
| 2008-12-11 08:55:00 | AAPL | Stock | 3.4714 | 3.475 | 3.4675 | 3.4686 | 130900.0 |
| 2008-12-11 09:00:00 | AAPL | Stock | 3.4679 | 3.4729 | 3.4679 | 3.47 | 102200.0 |
| 2008-12-11 09:05:00 | AAPL | Stock | 3.4718 | 3.4736 | 3.4696 | 3.4711 | 104496.0 |
| 2008-12-11 09:10:00 | AAPL | Stock | 3.4761 | 3.4761 | 3.4732 | 3.4732 | 28000.0 |
| 2008-12-11 09:15:00 | AAPL | Stock | 3.4739 | 3.4743 | 3.4679 | 3.4707 | 49616.0 |
| 2008-12-11 09:20:00 | AAPL | Stock | 3.4714 | 3.4782 | 3.47 | 3.4782 | 176456.0 |
| 2008-12-11 09:25:00 | AAPL | Stock | 3.4825 | 3.4825 | 3.4696 | 3.4696 | 361368.0 |
| 2008-12-11 09:30:00 | AAPL | Stock | 3.4704 | 3.4818 | 3.4207 | 3.4339 | 24626196.0 |
| 2008-12-11 09:35:00 | AAPL | Stock | 3.4332 | 3.4461 | 3.425 | 3.4411 | 17978268.0 |
| 2008-12-11 09:40:00 | AAPL | Stock | 3.4421 | 3.4564 | 3.4386 | 3.4507 | 14082040.0 |
| 2008-12-11 09:45:00 | AAPL | Stock | 3.4507 | 3.4646 | 3.4489 | 3.4571 | 14870016.0 |
| 2008-12-11 09:50:00 | AAPL | Stock | 3.4575 | 3.4821 | 3.4557 | 3.4721 | 13929496.0 |
| 2008-12-11 09:55:00 | AAPL | Stock | 3.4714 | 3.5082 | 3.4714 | 3.5029 | 15777188.0 |
| 2008-12-11 10:00:00 | AAPL | Stock | 3.5032 | 3.5357 | 3.5007 | 3.5296 | 19785976.0 |
| 2008-12-11 10:05:00 | AAPL | Stock | 3.5293 | 3.5421 | 3.5196 | 3.5211 | 20231568.0 |
| 2008-12-11 10:10:00 | AAPL | Stock | 3.5207 | 3.5411 | 3.5186 | 3.5393 | 18895996.0 |
| 2008-12-11 10:15:00 | AAPL | Stock | 3.5393 | 3.5518 | 3.5368 | 3.5425 | 16286312.0 |
| 2008-12-11 10:20:00 | AAPL | Stock | 3.5425 | 3.5664 | 3.5401 | 3.5575 | 20266596.0 |
| 2008-12-11 10:25:00 | AAPL | Stock | 3.5575 | 3.5696 | 3.5529 | 3.5639 | 19802692.0 |
| 2008-12-11 10:30:00 | AAPL | Stock | 3.5636 | 3.585 | 3.5579 | 3.5818 | 23298716.0 |
| 2008-12-11 10:35:00 | AAPL | Stock | 3.5818 | 3.5936 | 3.5696 | 3.5782 | 21057652.0 |
| 2008-12-11 10:40:00 | AAPL | Stock | 3.5786 | 3.58 | 3.56 | 3.5657 | 18399724.0 |
| 2008-12-11 10:45:00 | AAPL | Stock | 3.5654 | 3.5714 | 3.5586 | 3.5689 | 10735060.0 |
| 2008-12-11 10:50:00 | AAPL | Stock | 3.5686 | 3.57 | 3.5514 | 3.5529 | 10533880.0 |
| 2008-12-11 10:55:00 | AAPL | Stock | 3.5539 | 3.5682 | 3.5475 | 3.5668 | 10494428.0 |
| 2008-12-11 11:00:00 | AAPL | Stock | 3.5657 | 3.5696 | 3.5643 | 3.5668 | 5299140.0 |
| 2008-12-11 11:05:00 | AAPL | Stock | 3.5661 | 3.5886 | 3.5657 | 3.5786 | 10329284.0 |
| 2008-12-11 11:10:00 | AAPL | Stock | 3.5793 | 3.5946 | 3.5786 | 3.5929 | 13010760.0 |
| 2008-12-11 11:15:00 | AAPL | Stock | 3.5932 | 3.5939 | 3.5679 | 3.5714 | 11503492.0 |
| 2008-12-11 11:20:00 | AAPL | Stock | 3.5704 | 3.5729 | 3.55 | 3.5516 | 12168604.0 |
| 2008-12-11 11:25:00 | AAPL | Stock | 3.5521 | 3.5636 | 3.5517 | 3.5618 | 9309188.0 |
| 2008-12-11 11:30:00 | AAPL | Stock | 3.5614 | 3.5725 | 3.5596 | 3.5639 | 8925028.0 |
| 2008-12-11 11:35:00 | AAPL | Stock | 3.5639 | 3.5764 | 3.5614 | 3.5739 | 8877820.0 |
| 2008-12-11 11:40:00 | AAPL | Stock | 3.5746 | 3.5796 | 3.5686 | 3.5718 | 7892976.0 |
| 2008-12-11 11:45:00 | AAPL | Stock | 3.5718 | 3.5739 | 3.5661 | 3.5682 | 5370344.0 |
| 2008-12-11 11:50:00 | AAPL | Stock | 3.5682 | 3.5704 | 3.5614 | 3.5661 | 6601756.0 |
| 2008-12-11 11:55:00 | AAPL | Stock | 3.5661 | 3.5875 | 3.5657 | 3.5846 | 8117508.0 |
| 2008-12-11 12:00:00 | AAPL | Stock | 3.5854 | 3.6143 | 3.5793 | 3.6043 | 16807672.0 |
| 2008-12-11 12:05:00 | AAPL | Stock | 3.6036 | 3.6157 | 3.6018 | 3.6068 | 9280824.0 |
| 2008-12-11 12:10:00 | AAPL | Stock | 3.6064 | 3.6075 | 3.5914 | 3.5939 | 7589988.0 |
> showing 50 of 312,783 rows — these rows as CSV