PREVIEW / stock_5min / 2004-08-06
file: by_date/stock_5min/2004/2004-08-06.parquet size: 2.4 MB rows: 178,784 symbols: 1,804
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 |
|---|---|---|---|---|---|---|---|
| 2004-08-06 08:00:00 | AAPL | Stock | 0.5879 | 0.6152 | 0.5713 | 0.5713 | 48160.0 |
| 2004-08-06 08:30:00 | AAPL | Stock | 0.5571 | 0.5598 | 0.5536 | 0.5536 | 162400.0 |
| 2004-08-06 08:35:00 | AAPL | Stock | 0.5536 | 0.5536 | 0.5536 | 0.5536 | 11200.0 |
| 2004-08-06 08:45:00 | AAPL | Stock | 0.55 | 0.55 | 0.5488 | 0.5488 | 67200.0 |
| 2004-08-06 08:55:00 | AAPL | Stock | 0.5488 | 0.5488 | 0.5488 | 0.5488 | 5600.0 |
| 2004-08-06 09:05:00 | AAPL | Stock | 0.5527 | 0.5527 | 0.5527 | 0.5527 | 5600.0 |
| 2004-08-06 09:10:00 | AAPL | Stock | 0.5527 | 0.5527 | 0.5527 | 0.5527 | 22400.0 |
| 2004-08-06 09:15:00 | AAPL | Stock | 0.5527 | 0.5545 | 0.5527 | 0.5545 | 26600.0 |
| 2004-08-06 09:20:00 | AAPL | Stock | 0.5536 | 0.5536 | 0.5536 | 0.5536 | 133840.0 |
| 2004-08-06 09:25:00 | AAPL | Stock | 0.5536 | 0.5543 | 0.5518 | 0.5525 | 1207584.0 |
| 2004-08-06 09:30:00 | AAPL | Stock | 0.5518 | 0.5554 | 0.5514 | 0.553 | 13104560.0 |
| 2004-08-06 09:35:00 | AAPL | Stock | 0.5532 | 0.5536 | 0.5479 | 0.5498 | 12878544.0 |
| 2004-08-06 09:40:00 | AAPL | Stock | 0.5498 | 0.5498 | 0.5473 | 0.5498 | 6607104.0 |
| 2004-08-06 09:45:00 | AAPL | Stock | 0.55 | 0.5534 | 0.55 | 0.5521 | 5427352.0 |
| 2004-08-06 09:50:00 | AAPL | Stock | 0.5523 | 0.5536 | 0.5505 | 0.5505 | 4830504.0 |
| 2004-08-06 09:55:00 | AAPL | Stock | 0.5504 | 0.5513 | 0.5489 | 0.5493 | 4510296.0 |
| 2004-08-06 10:00:00 | AAPL | Stock | 0.5493 | 0.55 | 0.548 | 0.5493 | 2405480.0 |
| 2004-08-06 10:05:00 | AAPL | Stock | 0.5496 | 0.5496 | 0.5455 | 0.5455 | 8261064.0 |
| 2004-08-06 10:10:00 | AAPL | Stock | 0.5454 | 0.5464 | 0.5436 | 0.5464 | 20013952.0 |
| 2004-08-06 10:15:00 | AAPL | Stock | 0.5466 | 0.5473 | 0.5446 | 0.5473 | 9602600.0 |
| 2004-08-06 10:20:00 | AAPL | Stock | 0.547 | 0.5473 | 0.5446 | 0.5455 | 4786152.0 |
| 2004-08-06 10:25:00 | AAPL | Stock | 0.5454 | 0.5455 | 0.5402 | 0.5409 | 11976496.0 |
| 2004-08-06 10:30:00 | AAPL | Stock | 0.5411 | 0.5416 | 0.5393 | 0.5411 | 9658880.0 |
| 2004-08-06 10:35:00 | AAPL | Stock | 0.5411 | 0.5432 | 0.5411 | 0.5423 | 10494400.0 |
| 2004-08-06 10:40:00 | AAPL | Stock | 0.5421 | 0.5429 | 0.5411 | 0.5414 | 4642400.0 |
| 2004-08-06 10:45:00 | AAPL | Stock | 0.5414 | 0.5421 | 0.5411 | 0.5413 | 5045096.0 |
| 2004-08-06 10:50:00 | AAPL | Stock | 0.5414 | 0.5429 | 0.5409 | 0.542 | 2175936.0 |
| 2004-08-06 10:55:00 | AAPL | Stock | 0.5418 | 0.542 | 0.5397 | 0.54 | 5511968.0 |
| 2004-08-06 11:00:00 | AAPL | Stock | 0.5399 | 0.5411 | 0.5391 | 0.5391 | 4429992.0 |
| 2004-08-06 11:05:00 | AAPL | Stock | 0.5393 | 0.5411 | 0.5391 | 0.5405 | 5623800.0 |
| 2004-08-06 11:10:00 | AAPL | Stock | 0.5409 | 0.5423 | 0.5405 | 0.5414 | 4141816.0 |
| 2004-08-06 11:15:00 | AAPL | Stock | 0.5414 | 0.5416 | 0.5402 | 0.5412 | 2605064.0 |
| 2004-08-06 11:20:00 | AAPL | Stock | 0.5414 | 0.5432 | 0.5411 | 0.543 | 6706336.0 |
| 2004-08-06 11:25:00 | AAPL | Stock | 0.543 | 0.5452 | 0.543 | 0.5452 | 5718888.0 |
| 2004-08-06 11:30:00 | AAPL | Stock | 0.5454 | 0.5454 | 0.5441 | 0.5445 | 3271016.0 |
| 2004-08-06 11:35:00 | AAPL | Stock | 0.5446 | 0.545 | 0.5438 | 0.5439 | 3164840.0 |
| 2004-08-06 11:40:00 | AAPL | Stock | 0.5438 | 0.5455 | 0.5438 | 0.5446 | 2642416.0 |
| 2004-08-06 11:45:00 | AAPL | Stock | 0.545 | 0.5455 | 0.5443 | 0.5454 | 1840664.0 |
| 2004-08-06 11:50:00 | AAPL | Stock | 0.5452 | 0.5464 | 0.5446 | 0.5454 | 3211264.0 |
| 2004-08-06 11:55:00 | AAPL | Stock | 0.5452 | 0.5455 | 0.5446 | 0.5454 | 2169720.0 |
| 2004-08-06 12:00:00 | AAPL | Stock | 0.5454 | 0.5454 | 0.5448 | 0.545 | 1639512.0 |
| 2004-08-06 12:05:00 | AAPL | Stock | 0.545 | 0.5452 | 0.5446 | 0.545 | 2463104.0 |
| 2004-08-06 12:10:00 | AAPL | Stock | 0.5448 | 0.5455 | 0.5446 | 0.5455 | 1292088.0 |
| 2004-08-06 12:15:00 | AAPL | Stock | 0.5455 | 0.5491 | 0.5455 | 0.5491 | 7067816.0 |
| 2004-08-06 12:20:00 | AAPL | Stock | 0.5491 | 0.55 | 0.5489 | 0.5495 | 10000200.0 |
| 2004-08-06 12:25:00 | AAPL | Stock | 0.5495 | 0.55 | 0.5475 | 0.5482 | 6084736.0 |
| 2004-08-06 12:30:00 | AAPL | Stock | 0.5482 | 0.5486 | 0.5477 | 0.5486 | 2511152.0 |
| 2004-08-06 12:35:00 | AAPL | Stock | 0.5486 | 0.5491 | 0.5479 | 0.5488 | 1006656.0 |
| 2004-08-06 12:40:00 | AAPL | Stock | 0.5488 | 0.5507 | 0.5488 | 0.5504 | 3820040.0 |
| 2004-08-06 12:45:00 | AAPL | Stock | 0.5504 | 0.5511 | 0.5504 | 0.5505 | 3563280.0 |
> showing 50 of 178,784 rows — these rows as CSV