PREVIEW / stock_5min / 2009-05-12
file: by_date/stock_5min/2009/2009-05-12.parquet size: 4.7 MB rows: 322,455 symbols: 3,343
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 |
|---|---|---|---|---|---|---|---|
| 2009-05-12 05:10:00 | AAPL | Stock | 4.6425 | 4.6425 | 4.6425 | 4.6425 | 14000.0 |
| 2009-05-12 07:00:00 | AAPL | Stock | 4.6429 | 4.6429 | 4.6429 | 4.6429 | 14000.0 |
| 2009-05-12 07:45:00 | AAPL | Stock | 4.6429 | 4.6429 | 4.6429 | 4.6429 | 25200.0 |
| 2009-05-12 07:50:00 | AAPL | Stock | 4.6429 | 4.6429 | 4.6429 | 4.6429 | 2800.0 |
| 2009-05-12 08:00:00 | AAPL | Stock | 4.6339 | 4.6357 | 4.6289 | 4.6357 | 41160.0 |
| 2009-05-12 08:05:00 | AAPL | Stock | 4.6357 | 4.6357 | 4.6346 | 4.6346 | 11200.0 |
| 2009-05-12 08:10:00 | AAPL | Stock | 4.6364 | 4.6411 | 4.6357 | 4.6411 | 22400.0 |
| 2009-05-12 08:15:00 | AAPL | Stock | 4.6429 | 4.6429 | 4.6429 | 4.6429 | 4620.0 |
| 2009-05-12 08:20:00 | AAPL | Stock | 4.6461 | 4.6464 | 4.6461 | 4.6461 | 53200.0 |
| 2009-05-12 08:25:00 | AAPL | Stock | 4.65 | 4.6504 | 4.6471 | 4.6471 | 25956.0 |
| 2009-05-12 08:30:00 | AAPL | Stock | 4.6482 | 4.6482 | 4.6432 | 4.6432 | 33600.0 |
| 2009-05-12 08:35:00 | AAPL | Stock | 4.6464 | 4.6464 | 4.6464 | 4.6464 | 14000.0 |
| 2009-05-12 08:40:00 | AAPL | Stock | 4.6464 | 4.6496 | 4.6464 | 4.6482 | 42000.0 |
| 2009-05-12 08:45:00 | AAPL | Stock | 4.6482 | 4.6529 | 4.6482 | 4.6529 | 81200.0 |
| 2009-05-12 08:50:00 | AAPL | Stock | 4.6539 | 4.655 | 4.6511 | 4.6511 | 11200.0 |
| 2009-05-12 09:00:00 | AAPL | Stock | 4.6457 | 4.6493 | 4.6429 | 4.6429 | 72744.0 |
| 2009-05-12 09:05:00 | AAPL | Stock | 4.6429 | 4.6429 | 4.6375 | 4.6375 | 91560.0 |
| 2009-05-12 09:10:00 | AAPL | Stock | 4.6386 | 4.6386 | 4.6386 | 4.6386 | 29400.0 |
| 2009-05-12 09:15:00 | AAPL | Stock | 4.6407 | 4.6429 | 4.6386 | 4.6429 | 47572.0 |
| 2009-05-12 09:20:00 | AAPL | Stock | 4.6436 | 4.6443 | 4.6436 | 4.6443 | 5600.0 |
| 2009-05-12 09:25:00 | AAPL | Stock | 4.6393 | 4.6393 | 4.6275 | 4.6314 | 270900.0 |
| 2009-05-12 09:30:00 | AAPL | Stock | 4.6279 | 4.6325 | 4.5746 | 4.5889 | 18326000.0 |
| 2009-05-12 09:35:00 | AAPL | Stock | 4.5893 | 4.5929 | 4.5604 | 4.5714 | 16655800.0 |
| 2009-05-12 09:40:00 | AAPL | Stock | 4.5711 | 4.5732 | 4.5554 | 4.5698 | 15644300.0 |
| 2009-05-12 09:45:00 | AAPL | Stock | 4.5682 | 4.5804 | 4.5475 | 4.5486 | 14447972.0 |
| 2009-05-12 09:50:00 | AAPL | Stock | 4.5489 | 4.5507 | 4.5246 | 4.5454 | 15028300.0 |
| 2009-05-12 09:55:00 | AAPL | Stock | 4.5457 | 4.5514 | 4.5357 | 4.5464 | 9819264.0 |
| 2009-05-12 10:00:00 | AAPL | Stock | 4.5464 | 4.5718 | 4.5457 | 4.5718 | 10841908.0 |
| 2009-05-12 10:05:00 | AAPL | Stock | 4.5718 | 4.5771 | 4.5629 | 4.565 | 10900036.0 |
| 2009-05-12 10:10:00 | AAPL | Stock | 4.5654 | 4.5664 | 4.5361 | 4.5404 | 9119964.0 |
| 2009-05-12 10:15:00 | AAPL | Stock | 4.54 | 4.5407 | 4.5286 | 4.5304 | 7139384.0 |
| 2009-05-12 10:20:00 | AAPL | Stock | 4.5304 | 4.5504 | 4.5282 | 4.5479 | 8034544.0 |
| 2009-05-12 10:25:00 | AAPL | Stock | 4.5482 | 4.5575 | 4.5432 | 4.5482 | 6109096.0 |
| 2009-05-12 10:30:00 | AAPL | Stock | 4.5486 | 4.5532 | 4.5204 | 4.5211 | 7939736.0 |
| 2009-05-12 10:35:00 | AAPL | Stock | 4.5211 | 4.5279 | 4.504 | 4.5121 | 12291440.0 |
| 2009-05-12 10:40:00 | AAPL | Stock | 4.5114 | 4.5236 | 4.5036 | 4.5193 | 12238548.0 |
| 2009-05-12 10:45:00 | AAPL | Stock | 4.5189 | 4.5232 | 4.5082 | 4.5204 | 6043996.0 |
| 2009-05-12 10:50:00 | AAPL | Stock | 4.5214 | 4.5214 | 4.4932 | 4.4971 | 12467896.0 |
| 2009-05-12 10:55:00 | AAPL | Stock | 4.4971 | 4.5082 | 4.4932 | 4.5073 | 7498316.0 |
| 2009-05-12 11:00:00 | AAPL | Stock | 4.5071 | 4.5175 | 4.5064 | 4.5175 | 5082784.0 |
| 2009-05-12 11:05:00 | AAPL | Stock | 4.5175 | 4.5214 | 4.4964 | 4.5004 | 8011248.0 |
| 2009-05-12 11:10:00 | AAPL | Stock | 4.5004 | 4.5057 | 4.4954 | 4.5011 | 5554220.0 |
| 2009-05-12 11:15:00 | AAPL | Stock | 4.5021 | 4.5129 | 4.5 | 4.5043 | 4758040.0 |
| 2009-05-12 11:20:00 | AAPL | Stock | 4.5054 | 4.5093 | 4.4968 | 4.5 | 6639080.0 |
| 2009-05-12 11:25:00 | AAPL | Stock | 4.5 | 4.5018 | 4.4911 | 4.4957 | 5570544.0 |
| 2009-05-12 11:30:00 | AAPL | Stock | 4.4954 | 4.5089 | 4.4896 | 4.5039 | 8025528.0 |
| 2009-05-12 11:35:00 | AAPL | Stock | 4.5036 | 4.5093 | 4.5021 | 4.5026 | 3901268.0 |
| 2009-05-12 11:40:00 | AAPL | Stock | 4.5021 | 4.5096 | 4.4929 | 4.4964 | 4176284.0 |
| 2009-05-12 11:45:00 | AAPL | Stock | 4.4971 | 4.4982 | 4.4911 | 4.4914 | 3011988.0 |
| 2009-05-12 11:50:00 | AAPL | Stock | 4.4911 | 4.4946 | 4.4739 | 4.4786 | 8691340.0 |
> showing 50 of 322,455 rows — these rows as CSV