PREVIEW / stock_5min / 2008-02-21
file: by_date/stock_5min/2008/2008-02-21.parquet size: 4.3 MB rows: 313,987 symbols: 3,245
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-02-21 05:35:00 | AAPL | Stock | 4.4464 | 4.4464 | 4.4457 | 4.4457 | 47600.0 |
| 2008-02-21 06:20:00 | AAPL | Stock | 4.4643 | 4.4643 | 4.4643 | 4.4643 | 47600.0 |
| 2008-02-21 06:50:00 | AAPL | Stock | 4.4857 | 4.4857 | 4.4857 | 4.4857 | 28000.0 |
| 2008-02-21 06:55:00 | AAPL | Stock | 4.4993 | 4.5 | 4.4993 | 4.5 | 33600.0 |
| 2008-02-21 07:00:00 | AAPL | Stock | 4.5 | 4.5 | 4.5 | 4.5 | 72800.0 |
| 2008-02-21 07:05:00 | AAPL | Stock | 4.5 | 4.5 | 4.4918 | 4.4918 | 25200.0 |
| 2008-02-21 07:10:00 | AAPL | Stock | 4.4914 | 4.4914 | 4.4911 | 4.4911 | 47600.0 |
| 2008-02-21 07:15:00 | AAPL | Stock | 4.4996 | 4.5054 | 4.4996 | 4.5018 | 86324.0 |
| 2008-02-21 07:20:00 | AAPL | Stock | 4.51 | 4.5179 | 4.5 | 4.5179 | 183512.0 |
| 2008-02-21 07:25:00 | AAPL | Stock | 4.5232 | 4.525 | 4.5196 | 4.525 | 159600.0 |
| 2008-02-21 07:30:00 | AAPL | Stock | 4.5271 | 4.5311 | 4.5268 | 4.5304 | 212912.0 |
| 2008-02-21 07:35:00 | AAPL | Stock | 4.5304 | 4.5318 | 4.5179 | 4.5179 | 112000.0 |
| 2008-02-21 07:40:00 | AAPL | Stock | 4.5179 | 4.5179 | 4.5111 | 4.5143 | 55300.0 |
| 2008-02-21 07:45:00 | AAPL | Stock | 4.5161 | 4.525 | 4.5161 | 4.525 | 8400.0 |
| 2008-02-21 07:50:00 | AAPL | Stock | 4.5282 | 4.5318 | 4.5179 | 4.5179 | 181468.0 |
| 2008-02-21 07:55:00 | AAPL | Stock | 4.5175 | 4.5229 | 4.5118 | 4.5121 | 28000.0 |
| 2008-02-21 08:00:00 | AAPL | Stock | 4.5179 | 4.525 | 4.5039 | 4.5246 | 1183168.0 |
| 2008-02-21 08:05:00 | AAPL | Stock | 4.5229 | 4.5229 | 4.5054 | 4.5086 | 673932.0 |
| 2008-02-21 08:10:00 | AAPL | Stock | 4.5079 | 4.5089 | 4.4996 | 4.4996 | 451080.0 |
| 2008-02-21 08:15:00 | AAPL | Stock | 4.4971 | 4.5011 | 4.4936 | 4.4968 | 390320.0 |
| 2008-02-21 08:20:00 | AAPL | Stock | 4.4968 | 4.4968 | 4.485 | 4.4875 | 127876.0 |
| 2008-02-21 08:25:00 | AAPL | Stock | 4.4889 | 4.4971 | 4.4832 | 4.4971 | 236992.0 |
| 2008-02-21 08:30:00 | AAPL | Stock | 4.4943 | 4.5 | 4.4925 | 4.4964 | 715456.0 |
| 2008-02-21 08:35:00 | AAPL | Stock | 4.4975 | 4.5 | 4.4911 | 4.5 | 723324.0 |
| 2008-02-21 08:40:00 | AAPL | Stock | 4.4982 | 4.5 | 4.4954 | 4.4954 | 246428.0 |
| 2008-02-21 08:45:00 | AAPL | Stock | 4.4993 | 4.5039 | 4.4993 | 4.5 | 515984.0 |
| 2008-02-21 08:50:00 | AAPL | Stock | 4.5 | 4.505 | 4.4996 | 4.5032 | 509152.0 |
| 2008-02-21 08:55:00 | AAPL | Stock | 4.5029 | 4.5054 | 4.5004 | 4.5036 | 210000.0 |
| 2008-02-21 09:00:00 | AAPL | Stock | 4.5043 | 4.5043 | 4.5 | 4.5 | 142072.0 |
| 2008-02-21 09:05:00 | AAPL | Stock | 4.5 | 4.5 | 4.4982 | 4.5 | 149184.0 |
| 2008-02-21 09:10:00 | AAPL | Stock | 4.5004 | 4.5004 | 4.4936 | 4.4957 | 467348.0 |
| 2008-02-21 09:15:00 | AAPL | Stock | 4.4957 | 4.4986 | 4.4914 | 4.4986 | 403480.0 |
| 2008-02-21 09:20:00 | AAPL | Stock | 4.4993 | 4.5086 | 4.4986 | 4.5079 | 361200.0 |
| 2008-02-21 09:25:00 | AAPL | Stock | 4.5068 | 4.5071 | 4.495 | 4.5018 | 474600.0 |
| 2008-02-21 09:30:00 | AAPL | Stock | 4.5021 | 4.5168 | 4.4836 | 4.4852 | 29866368.0 |
| 2008-02-21 09:35:00 | AAPL | Stock | 4.485 | 4.5107 | 4.4825 | 4.5046 | 22307180.0 |
| 2008-02-21 09:40:00 | AAPL | Stock | 4.5039 | 4.5071 | 4.4693 | 4.4761 | 24702720.0 |
| 2008-02-21 09:45:00 | AAPL | Stock | 4.4761 | 4.4821 | 4.46 | 4.4689 | 22382416.0 |
| 2008-02-21 09:50:00 | AAPL | Stock | 4.4689 | 4.4743 | 4.4564 | 4.4618 | 15862728.0 |
| 2008-02-21 09:55:00 | AAPL | Stock | 4.4614 | 4.4768 | 4.4607 | 4.4721 | 10976616.0 |
| 2008-02-21 10:00:00 | AAPL | Stock | 4.4732 | 4.4736 | 4.4354 | 4.4414 | 21042504.0 |
| 2008-02-21 10:05:00 | AAPL | Stock | 4.4411 | 4.4464 | 4.43 | 4.4382 | 14612276.0 |
| 2008-02-21 10:10:00 | AAPL | Stock | 4.4382 | 4.4486 | 4.4361 | 4.4454 | 11366712.0 |
| 2008-02-21 10:15:00 | AAPL | Stock | 4.4461 | 4.4711 | 4.445 | 4.4661 | 18344368.0 |
| 2008-02-21 10:20:00 | AAPL | Stock | 4.4661 | 4.4686 | 4.4557 | 4.4609 | 11263392.0 |
| 2008-02-21 10:25:00 | AAPL | Stock | 4.4614 | 4.4654 | 4.4482 | 4.4532 | 10027668.0 |
| 2008-02-21 10:30:00 | AAPL | Stock | 4.4539 | 4.4568 | 4.4343 | 4.4421 | 13516384.0 |
| 2008-02-21 10:35:00 | AAPL | Stock | 4.4421 | 4.4454 | 4.4214 | 4.4229 | 16156196.0 |
| 2008-02-21 10:40:00 | AAPL | Stock | 4.4225 | 4.4225 | 4.399 | 4.4011 | 17063816.0 |
| 2008-02-21 10:45:00 | AAPL | Stock | 4.4 | 4.4125 | 4.3861 | 4.4089 | 18926628.0 |
> showing 50 of 313,987 rows — these rows as CSV