PREVIEW / stock_5min / 2008-05-05
file: by_date/stock_5min/2008/2008-05-05.parquet size: 4.4 MB rows: 314,891 symbols: 3,288
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-05-05 05:05:00 | AAPL | Stock | 6.4114 | 6.4114 | 6.4114 | 6.4114 | 13300.0 |
| 2008-05-05 06:55:00 | AAPL | Stock | 6.4586 | 6.4586 | 6.4586 | 6.4586 | 2800.0 |
| 2008-05-05 07:00:00 | AAPL | Stock | 6.4461 | 6.4461 | 6.4461 | 6.4461 | 8400.0 |
| 2008-05-05 07:15:00 | AAPL | Stock | 6.4364 | 6.4364 | 6.4364 | 6.4364 | 2800.0 |
| 2008-05-05 07:20:00 | AAPL | Stock | 6.4286 | 6.4286 | 6.4286 | 6.4286 | 5600.0 |
| 2008-05-05 07:25:00 | AAPL | Stock | 6.4214 | 6.4286 | 6.4214 | 6.4286 | 19600.0 |
| 2008-05-05 07:30:00 | AAPL | Stock | 6.4321 | 6.4339 | 6.4286 | 6.4339 | 22400.0 |
| 2008-05-05 07:35:00 | AAPL | Stock | 6.4339 | 6.4339 | 6.4286 | 6.4321 | 42000.0 |
| 2008-05-05 07:40:00 | AAPL | Stock | 6.4321 | 6.4364 | 6.4321 | 6.4364 | 32200.0 |
| 2008-05-05 07:45:00 | AAPL | Stock | 6.4393 | 6.4393 | 6.4393 | 6.4393 | 2940.0 |
| 2008-05-05 07:50:00 | AAPL | Stock | 6.4357 | 6.4393 | 6.4357 | 6.4393 | 18284.0 |
| 2008-05-05 07:55:00 | AAPL | Stock | 6.445 | 6.445 | 6.4421 | 6.4421 | 39200.0 |
| 2008-05-05 08:00:00 | AAPL | Stock | 6.4375 | 6.4586 | 6.4371 | 6.4518 | 502908.0 |
| 2008-05-05 08:05:00 | AAPL | Stock | 6.4518 | 6.4564 | 6.4518 | 6.4561 | 78484.0 |
| 2008-05-05 08:10:00 | AAPL | Stock | 6.4554 | 6.4564 | 6.4539 | 6.4539 | 40992.0 |
| 2008-05-05 08:15:00 | AAPL | Stock | 6.4539 | 6.4568 | 6.4536 | 6.4539 | 31248.0 |
| 2008-05-05 08:20:00 | AAPL | Stock | 6.4536 | 6.4621 | 6.4529 | 6.4621 | 192920.0 |
| 2008-05-05 08:25:00 | AAPL | Stock | 6.4643 | 6.4693 | 6.4611 | 6.4621 | 203056.0 |
| 2008-05-05 08:30:00 | AAPL | Stock | 6.4632 | 6.4693 | 6.4589 | 6.4679 | 226212.0 |
| 2008-05-05 08:35:00 | AAPL | Stock | 6.4679 | 6.4679 | 6.4643 | 6.4643 | 141680.0 |
| 2008-05-05 08:40:00 | AAPL | Stock | 6.4643 | 6.4643 | 6.4539 | 6.4554 | 277760.0 |
| 2008-05-05 08:45:00 | AAPL | Stock | 6.4539 | 6.4546 | 6.4536 | 6.4546 | 79520.0 |
| 2008-05-05 08:50:00 | AAPL | Stock | 6.4568 | 6.4707 | 6.4536 | 6.4707 | 160188.0 |
| 2008-05-05 08:55:00 | AAPL | Stock | 6.4661 | 6.4846 | 6.4661 | 6.4821 | 1023960.0 |
| 2008-05-05 09:00:00 | AAPL | Stock | 6.4807 | 6.49 | 6.4771 | 6.4896 | 653436.0 |
| 2008-05-05 09:05:00 | AAPL | Stock | 6.4896 | 6.4979 | 6.4893 | 6.4914 | 941332.0 |
| 2008-05-05 09:10:00 | AAPL | Stock | 6.4925 | 6.4925 | 6.4893 | 6.4925 | 396592.0 |
| 2008-05-05 09:15:00 | AAPL | Stock | 6.4925 | 6.5179 | 6.4925 | 6.5096 | 1537256.0 |
| 2008-05-05 09:20:00 | AAPL | Stock | 6.5093 | 6.5171 | 6.4621 | 6.5121 | 1233120.0 |
| 2008-05-05 09:25:00 | AAPL | Stock | 6.5111 | 6.5143 | 6.4943 | 6.4964 | 1245468.0 |
| 2008-05-05 09:30:00 | AAPL | Stock | 6.4979 | 6.5179 | 6.4836 | 6.5107 | 32555124.0 |
| 2008-05-05 09:35:00 | AAPL | Stock | 6.5111 | 6.5129 | 6.4661 | 6.4836 | 26692596.0 |
| 2008-05-05 09:40:00 | AAPL | Stock | 6.4839 | 6.5086 | 6.4793 | 6.5079 | 15713404.0 |
| 2008-05-05 09:45:00 | AAPL | Stock | 6.5075 | 6.55 | 6.5075 | 6.5479 | 26380452.0 |
| 2008-05-05 09:50:00 | AAPL | Stock | 6.5471 | 6.5754 | 6.5443 | 6.5679 | 29319892.0 |
| 2008-05-05 09:55:00 | AAPL | Stock | 6.5671 | 6.5818 | 6.555 | 6.5643 | 17836868.0 |
| 2008-05-05 10:00:00 | AAPL | Stock | 6.5639 | 6.5889 | 6.5629 | 6.5746 | 25767000.0 |
| 2008-05-05 10:05:00 | AAPL | Stock | 6.5739 | 6.6071 | 6.5736 | 6.6054 | 30313164.0 |
| 2008-05-05 10:10:00 | AAPL | Stock | 6.605 | 6.6182 | 6.5964 | 6.6004 | 22363488.0 |
| 2008-05-05 10:15:00 | AAPL | Stock | 6.6018 | 6.6071 | 6.5836 | 6.5936 | 18330480.0 |
| 2008-05-05 10:20:00 | AAPL | Stock | 6.5936 | 6.6161 | 6.5843 | 6.5964 | 16904552.0 |
| 2008-05-05 10:25:00 | AAPL | Stock | 6.5954 | 6.6011 | 6.5704 | 6.5736 | 17560816.0 |
| 2008-05-05 10:30:00 | AAPL | Stock | 6.5729 | 6.5786 | 6.5646 | 6.5764 | 15396892.0 |
| 2008-05-05 10:35:00 | AAPL | Stock | 6.5761 | 6.5982 | 6.5714 | 6.5918 | 11102532.0 |
| 2008-05-05 10:40:00 | AAPL | Stock | 6.5918 | 6.6021 | 6.5843 | 6.5982 | 10383800.0 |
| 2008-05-05 10:45:00 | AAPL | Stock | 6.5986 | 6.6086 | 6.5957 | 6.5975 | 13903428.0 |
| 2008-05-05 10:50:00 | AAPL | Stock | 6.5986 | 6.6068 | 6.5811 | 6.5832 | 9472652.0 |
| 2008-05-05 10:55:00 | AAPL | Stock | 6.5825 | 6.5861 | 6.5664 | 6.5836 | 13419112.0 |
| 2008-05-05 11:00:00 | AAPL | Stock | 6.5832 | 6.5893 | 6.5643 | 6.5711 | 11867352.0 |
| 2008-05-05 11:05:00 | AAPL | Stock | 6.5718 | 6.5793 | 6.5643 | 6.5654 | 7314832.0 |
> showing 50 of 314,891 rows — these rows as CSV