PREVIEW / stock_5min / 2010-04-08
file: by_date/stock_5min/2010/2010-04-08.parquet size: 4.8 MB rows: 323,738 symbols: 3,476
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 |
|---|---|---|---|---|---|---|---|
| 2010-04-08 04:10:00 | AAPL | Stock | 8.5504 | 8.5504 | 8.5504 | 8.5504 | 14000.0 |
| 2010-04-08 04:15:00 | AAPL | Stock | 8.5732 | 8.5732 | 8.5679 | 8.5679 | 44800.0 |
| 2010-04-08 04:25:00 | AAPL | Stock | 8.5679 | 8.5679 | 8.5679 | 8.5679 | 6328.0 |
| 2010-04-08 04:45:00 | AAPL | Stock | 8.5714 | 8.5714 | 8.5714 | 8.5714 | 2800.0 |
| 2010-04-08 05:10:00 | AAPL | Stock | 8.5679 | 8.5679 | 8.5643 | 8.5643 | 20216.0 |
| 2010-04-08 05:15:00 | AAPL | Stock | 8.5643 | 8.5643 | 8.5643 | 8.5643 | 3388.0 |
| 2010-04-08 05:20:00 | AAPL | Stock | 8.5696 | 8.5696 | 8.5696 | 8.5696 | 14000.0 |
| 2010-04-08 05:50:00 | AAPL | Stock | 8.5732 | 8.5732 | 8.5732 | 8.5732 | 2800.0 |
| 2010-04-08 07:00:00 | AAPL | Stock | 8.5904 | 8.5904 | 8.5904 | 8.5904 | 5600.0 |
| 2010-04-08 07:30:00 | AAPL | Stock | 8.5804 | 8.5804 | 8.5804 | 8.5804 | 11200.0 |
| 2010-04-08 07:35:00 | AAPL | Stock | 8.5714 | 8.5714 | 8.5714 | 8.5714 | 2800.0 |
| 2010-04-08 07:45:00 | AAPL | Stock | 8.5732 | 8.5732 | 8.5732 | 8.5732 | 2800.0 |
| 2010-04-08 07:50:00 | AAPL | Stock | 8.5696 | 8.5696 | 8.5675 | 8.5675 | 5600.0 |
| 2010-04-08 07:55:00 | AAPL | Stock | 8.5696 | 8.5714 | 8.5696 | 8.5714 | 11200.0 |
| 2010-04-08 08:00:00 | AAPL | Stock | 8.5714 | 8.5714 | 8.5661 | 8.5714 | 300832.0 |
| 2010-04-08 08:05:00 | AAPL | Stock | 8.575 | 8.5804 | 8.5714 | 8.5714 | 157780.0 |
| 2010-04-08 08:10:00 | AAPL | Stock | 8.5682 | 8.5718 | 8.5682 | 8.5714 | 65240.0 |
| 2010-04-08 08:15:00 | AAPL | Stock | 8.5714 | 8.5929 | 8.5714 | 8.5714 | 286776.0 |
| 2010-04-08 08:20:00 | AAPL | Stock | 8.5739 | 8.575 | 8.5682 | 8.5704 | 123200.0 |
| 2010-04-08 08:25:00 | AAPL | Stock | 8.5707 | 8.5714 | 8.5696 | 8.5714 | 157612.0 |
| 2010-04-08 08:30:00 | AAPL | Stock | 8.5696 | 8.5696 | 8.54 | 8.5571 | 992180.0 |
| 2010-04-08 08:35:00 | AAPL | Stock | 8.5557 | 8.5654 | 8.5536 | 8.5625 | 497896.0 |
| 2010-04-08 08:40:00 | AAPL | Stock | 8.5629 | 8.5732 | 8.5629 | 8.5696 | 288820.0 |
| 2010-04-08 08:45:00 | AAPL | Stock | 8.5682 | 8.5696 | 8.5643 | 8.5664 | 148960.0 |
| 2010-04-08 08:50:00 | AAPL | Stock | 8.5664 | 8.5721 | 8.5664 | 8.5721 | 37660.0 |
| 2010-04-08 08:55:00 | AAPL | Stock | 8.57 | 8.5721 | 8.5679 | 8.5686 | 87164.0 |
| 2010-04-08 09:00:00 | AAPL | Stock | 8.5704 | 8.5714 | 8.5643 | 8.5646 | 140336.0 |
| 2010-04-08 09:05:00 | AAPL | Stock | 8.565 | 8.5689 | 8.5646 | 8.5686 | 64512.0 |
| 2010-04-08 09:10:00 | AAPL | Stock | 8.5679 | 8.5679 | 8.5643 | 8.5661 | 74984.0 |
| 2010-04-08 09:15:00 | AAPL | Stock | 8.5664 | 8.5779 | 8.5646 | 8.5736 | 170212.0 |
| 2010-04-08 09:20:00 | AAPL | Stock | 8.5768 | 8.5857 | 8.5736 | 8.5846 | 520184.0 |
| 2010-04-08 09:25:00 | AAPL | Stock | 8.5839 | 8.5868 | 8.5821 | 8.5857 | 117012.0 |
| 2010-04-08 09:30:00 | AAPL | Stock | 8.5871 | 8.5929 | 8.5596 | 8.5657 | 15762628.0 |
| 2010-04-08 09:35:00 | AAPL | Stock | 8.5664 | 8.5679 | 8.5475 | 8.5486 | 14020944.0 |
| 2010-04-08 09:40:00 | AAPL | Stock | 8.5489 | 8.5493 | 8.5179 | 8.5318 | 18387964.0 |
| 2010-04-08 09:45:00 | AAPL | Stock | 8.5286 | 8.5516 | 8.5286 | 8.5329 | 13191920.0 |
| 2010-04-08 09:50:00 | AAPL | Stock | 8.5332 | 8.5429 | 8.5282 | 8.5289 | 9513560.0 |
| 2010-04-08 09:55:00 | AAPL | Stock | 8.5282 | 8.5289 | 8.5036 | 8.5099 | 17336424.0 |
| 2010-04-08 10:00:00 | AAPL | Stock | 8.5106 | 8.5204 | 8.5064 | 8.5129 | 11618488.0 |
| 2010-04-08 10:05:00 | AAPL | Stock | 8.5136 | 8.5229 | 8.5093 | 8.5114 | 7920500.0 |
| 2010-04-08 10:10:00 | AAPL | Stock | 8.5111 | 8.5211 | 8.5054 | 8.5068 | 9066064.0 |
| 2010-04-08 10:15:00 | AAPL | Stock | 8.5071 | 8.5196 | 8.5014 | 8.5186 | 8959916.0 |
| 2010-04-08 10:20:00 | AAPL | Stock | 8.5182 | 8.5361 | 8.5164 | 8.5361 | 9978892.0 |
| 2010-04-08 10:25:00 | AAPL | Stock | 8.5361 | 8.5521 | 8.5304 | 8.5404 | 11375952.0 |
| 2010-04-08 10:30:00 | AAPL | Stock | 8.54 | 8.5607 | 8.54 | 8.5482 | 8537088.0 |
| 2010-04-08 10:35:00 | AAPL | Stock | 8.5479 | 8.5496 | 8.5325 | 8.535 | 6248340.0 |
| 2010-04-08 10:40:00 | AAPL | Stock | 8.535 | 8.5411 | 8.5304 | 8.5314 | 7244384.0 |
| 2010-04-08 10:45:00 | AAPL | Stock | 8.5314 | 8.5441 | 8.5289 | 8.5439 | 3549784.0 |
| 2010-04-08 10:50:00 | AAPL | Stock | 8.5432 | 8.5461 | 8.5357 | 8.5404 | 3402784.0 |
| 2010-04-08 10:55:00 | AAPL | Stock | 8.54 | 8.5482 | 8.5361 | 8.5382 | 3497536.0 |
> showing 50 of 323,738 rows — these rows as CSV