PREVIEW / stock_5min / 2006-05-02
file: by_date/stock_5min/2006/2006-05-02.parquet size: 3.1 MB rows: 226,995 symbols: 2,255
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 |
|---|---|---|---|---|---|---|---|
| 2006-05-02 06:05:00 | AAPL | Stock | 2.5071 | 2.5071 | 2.5071 | 2.5071 | 2800.0 |
| 2006-05-02 06:25:00 | AAPL | Stock | 2.5157 | 2.5157 | 2.5157 | 2.5157 | 5600.0 |
| 2006-05-02 08:00:00 | AAPL | Stock | 2.5096 | 2.5179 | 2.5018 | 2.5175 | 716520.0 |
| 2006-05-02 08:05:00 | AAPL | Stock | 2.515 | 2.5175 | 2.5125 | 2.5139 | 306180.0 |
| 2006-05-02 08:10:00 | AAPL | Stock | 2.5139 | 2.5143 | 2.5089 | 2.5125 | 277620.0 |
| 2006-05-02 08:15:00 | AAPL | Stock | 2.5125 | 2.5125 | 2.5107 | 2.5107 | 145740.0 |
| 2006-05-02 08:20:00 | AAPL | Stock | 2.51 | 2.5132 | 2.51 | 2.5132 | 231000.0 |
| 2006-05-02 08:25:00 | AAPL | Stock | 2.5132 | 2.5139 | 2.5114 | 2.5139 | 85120.0 |
| 2006-05-02 08:30:00 | AAPL | Stock | 2.5132 | 2.5132 | 2.5114 | 2.5114 | 31640.0 |
| 2006-05-02 08:35:00 | AAPL | Stock | 2.5136 | 2.5161 | 2.5121 | 2.5161 | 810068.0 |
| 2006-05-02 08:40:00 | AAPL | Stock | 2.5161 | 2.5161 | 2.5139 | 2.5157 | 86800.0 |
| 2006-05-02 08:45:00 | AAPL | Stock | 2.5161 | 2.5164 | 2.5157 | 2.5157 | 148400.0 |
| 2006-05-02 08:50:00 | AAPL | Stock | 2.5143 | 2.5143 | 2.5125 | 2.5143 | 287336.0 |
| 2006-05-02 08:55:00 | AAPL | Stock | 2.5143 | 2.5143 | 2.5125 | 2.5136 | 21000.0 |
| 2006-05-02 09:00:00 | AAPL | Stock | 2.5136 | 2.5136 | 2.5089 | 2.5104 | 237132.0 |
| 2006-05-02 09:05:00 | AAPL | Stock | 2.5096 | 2.5107 | 2.4907 | 2.4907 | 82600.0 |
| 2006-05-02 09:10:00 | AAPL | Stock | 2.5107 | 2.5125 | 2.5089 | 2.5107 | 263200.0 |
| 2006-05-02 09:15:00 | AAPL | Stock | 2.5143 | 2.5161 | 2.5129 | 2.5161 | 148400.0 |
| 2006-05-02 09:20:00 | AAPL | Stock | 2.5161 | 2.5168 | 2.5157 | 2.5164 | 419636.0 |
| 2006-05-02 09:25:00 | AAPL | Stock | 2.5168 | 2.5175 | 2.5054 | 2.5054 | 2447564.0 |
| 2006-05-02 09:30:00 | AAPL | Stock | 2.5054 | 2.5239 | 2.5039 | 2.5229 | 27143340.0 |
| 2006-05-02 09:35:00 | AAPL | Stock | 2.5229 | 2.5282 | 2.5189 | 2.5196 | 17661896.0 |
| 2006-05-02 09:40:00 | AAPL | Stock | 2.52 | 2.5229 | 2.5129 | 2.5164 | 14780108.0 |
| 2006-05-02 09:45:00 | AAPL | Stock | 2.5164 | 2.5225 | 2.5154 | 2.5179 | 10257156.0 |
| 2006-05-02 09:50:00 | AAPL | Stock | 2.5175 | 2.5214 | 2.5143 | 2.5214 | 9740892.0 |
| 2006-05-02 09:55:00 | AAPL | Stock | 2.5211 | 2.5311 | 2.5189 | 2.5271 | 15229956.0 |
| 2006-05-02 10:00:00 | AAPL | Stock | 2.5268 | 2.5354 | 2.5257 | 2.535 | 20844460.0 |
| 2006-05-02 10:05:00 | AAPL | Stock | 2.5346 | 2.5443 | 2.5314 | 2.5432 | 22236452.0 |
| 2006-05-02 10:10:00 | AAPL | Stock | 2.5429 | 2.5525 | 2.5429 | 2.5475 | 29138536.0 |
| 2006-05-02 10:15:00 | AAPL | Stock | 2.5475 | 2.5482 | 2.5368 | 2.5407 | 22809528.0 |
| 2006-05-02 10:20:00 | AAPL | Stock | 2.5404 | 2.5504 | 2.5393 | 2.5464 | 13431516.0 |
| 2006-05-02 10:25:00 | AAPL | Stock | 2.5464 | 2.5646 | 2.5411 | 2.5614 | 31979556.0 |
| 2006-05-02 10:30:00 | AAPL | Stock | 2.5618 | 2.5707 | 2.5607 | 2.5621 | 24403176.0 |
| 2006-05-02 10:35:00 | AAPL | Stock | 2.5621 | 2.5625 | 2.5536 | 2.5569 | 13685448.0 |
| 2006-05-02 10:40:00 | AAPL | Stock | 2.5571 | 2.5639 | 2.5486 | 2.5493 | 16102688.0 |
| 2006-05-02 10:45:00 | AAPL | Stock | 2.5493 | 2.5604 | 2.5464 | 2.5604 | 14296492.0 |
| 2006-05-02 10:50:00 | AAPL | Stock | 2.5604 | 2.5636 | 2.5568 | 2.5618 | 8088892.0 |
| 2006-05-02 10:55:00 | AAPL | Stock | 2.5614 | 2.5629 | 2.5554 | 2.5607 | 10368596.0 |
| 2006-05-02 11:00:00 | AAPL | Stock | 2.5607 | 2.5625 | 2.5489 | 2.5525 | 11247740.0 |
| 2006-05-02 11:05:00 | AAPL | Stock | 2.5525 | 2.5529 | 2.5461 | 2.5479 | 8159732.0 |
| 2006-05-02 11:10:00 | AAPL | Stock | 2.5482 | 2.5486 | 2.5411 | 2.5414 | 13576388.0 |
| 2006-05-02 11:15:00 | AAPL | Stock | 2.5411 | 2.5482 | 2.5379 | 2.5453 | 12192040.0 |
| 2006-05-02 11:20:00 | AAPL | Stock | 2.5453 | 2.5514 | 2.545 | 2.5475 | 6648068.0 |
| 2006-05-02 11:25:00 | AAPL | Stock | 2.5475 | 2.5489 | 2.5296 | 2.5374 | 22890644.0 |
| 2006-05-02 11:30:00 | AAPL | Stock | 2.5371 | 2.5439 | 2.5357 | 2.5414 | 14354816.0 |
| 2006-05-02 11:35:00 | AAPL | Stock | 2.5411 | 2.5454 | 2.5389 | 2.5454 | 8449252.0 |
| 2006-05-02 11:40:00 | AAPL | Stock | 2.5454 | 2.5486 | 2.5414 | 2.5454 | 7890288.0 |
| 2006-05-02 11:45:00 | AAPL | Stock | 2.5454 | 2.5457 | 2.5393 | 2.5421 | 6368124.0 |
| 2006-05-02 11:50:00 | AAPL | Stock | 2.5421 | 2.5464 | 2.5418 | 2.5457 | 4165308.0 |
| 2006-05-02 11:55:00 | AAPL | Stock | 2.5457 | 2.5468 | 2.5429 | 2.5468 | 4674376.0 |
> showing 50 of 226,995 rows — these rows as CSV