PREVIEW / stock_5min / 2004-08-17
file: by_date/stock_5min/2004/2004-08-17.parquet size: 2.4 MB rows: 174,595 symbols: 1,827
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-17 08:00:00 | AAPL | Stock | 0.5505 | 0.5505 | 0.5505 | 0.5505 | 11200.0 |
| 2004-08-17 08:05:00 | AAPL | Stock | 0.5505 | 0.5505 | 0.5505 | 0.5505 | 771400.0 |
| 2004-08-17 08:20:00 | AAPL | Stock | 0.55 | 0.5504 | 0.55 | 0.5504 | 56000.0 |
| 2004-08-17 08:25:00 | AAPL | Stock | 0.5505 | 0.5505 | 0.5504 | 0.5504 | 78400.0 |
| 2004-08-17 08:30:00 | AAPL | Stock | 0.5504 | 0.5505 | 0.5504 | 0.5505 | 511000.0 |
| 2004-08-17 08:35:00 | AAPL | Stock | 0.5511 | 0.5513 | 0.5511 | 0.5511 | 145600.0 |
| 2004-08-17 08:40:00 | AAPL | Stock | 0.55 | 0.5509 | 0.55 | 0.5507 | 383320.0 |
| 2004-08-17 08:45:00 | AAPL | Stock | 0.5507 | 0.5507 | 0.5505 | 0.5505 | 280000.0 |
| 2004-08-17 08:50:00 | AAPL | Stock | 0.5496 | 0.5496 | 0.5495 | 0.5495 | 22400.0 |
| 2004-08-17 08:55:00 | AAPL | Stock | 0.5498 | 0.5498 | 0.5498 | 0.5498 | 145600.0 |
| 2004-08-17 09:00:00 | AAPL | Stock | 0.5488 | 0.5488 | 0.5488 | 0.5488 | 61600.0 |
| 2004-08-17 09:05:00 | AAPL | Stock | 0.5482 | 0.5495 | 0.5482 | 0.5495 | 436800.0 |
| 2004-08-17 09:10:00 | AAPL | Stock | 0.5495 | 0.55 | 0.5489 | 0.5496 | 537600.0 |
| 2004-08-17 09:15:00 | AAPL | Stock | 0.5496 | 0.5504 | 0.5496 | 0.55 | 308000.0 |
| 2004-08-17 09:20:00 | AAPL | Stock | 0.5496 | 0.5496 | 0.5496 | 0.5496 | 187992.0 |
| 2004-08-17 09:25:00 | AAPL | Stock | 0.5496 | 0.5496 | 0.5464 | 0.5464 | 1120000.0 |
| 2004-08-17 09:30:00 | AAPL | Stock | 0.5464 | 0.5491 | 0.542 | 0.5429 | 14872312.0 |
| 2004-08-17 09:35:00 | AAPL | Stock | 0.543 | 0.5493 | 0.5425 | 0.5457 | 10197656.0 |
| 2004-08-17 09:40:00 | AAPL | Stock | 0.5452 | 0.5468 | 0.5429 | 0.543 | 7991424.0 |
| 2004-08-17 09:45:00 | AAPL | Stock | 0.543 | 0.5452 | 0.5429 | 0.5445 | 6748280.0 |
| 2004-08-17 09:50:00 | AAPL | Stock | 0.5443 | 0.5489 | 0.5441 | 0.5489 | 6544664.0 |
| 2004-08-17 09:55:00 | AAPL | Stock | 0.5489 | 0.5511 | 0.5482 | 0.5488 | 9861264.0 |
| 2004-08-17 10:00:00 | AAPL | Stock | 0.5486 | 0.5505 | 0.547 | 0.5504 | 7360472.0 |
| 2004-08-17 10:05:00 | AAPL | Stock | 0.5504 | 0.5527 | 0.55 | 0.5509 | 7084952.0 |
| 2004-08-17 10:10:00 | AAPL | Stock | 0.5513 | 0.5513 | 0.5473 | 0.5479 | 9760800.0 |
| 2004-08-17 10:15:00 | AAPL | Stock | 0.548 | 0.5496 | 0.5473 | 0.5484 | 2983176.0 |
| 2004-08-17 10:20:00 | AAPL | Stock | 0.5482 | 0.5482 | 0.5454 | 0.5459 | 5388208.0 |
| 2004-08-17 10:25:00 | AAPL | Stock | 0.5457 | 0.5477 | 0.5456 | 0.5468 | 2456384.0 |
| 2004-08-17 10:30:00 | AAPL | Stock | 0.5468 | 0.5468 | 0.5452 | 0.5461 | 3631264.0 |
| 2004-08-17 10:35:00 | AAPL | Stock | 0.5459 | 0.5466 | 0.5459 | 0.5463 | 5274136.0 |
| 2004-08-17 10:40:00 | AAPL | Stock | 0.5463 | 0.5482 | 0.5461 | 0.5482 | 3083640.0 |
| 2004-08-17 10:45:00 | AAPL | Stock | 0.5482 | 0.5496 | 0.5475 | 0.5477 | 4258352.0 |
| 2004-08-17 10:50:00 | AAPL | Stock | 0.5475 | 0.5488 | 0.5473 | 0.5484 | 1920800.0 |
| 2004-08-17 10:55:00 | AAPL | Stock | 0.5484 | 0.5489 | 0.5471 | 0.5471 | 2451904.0 |
| 2004-08-17 11:00:00 | AAPL | Stock | 0.547 | 0.5484 | 0.5466 | 0.5466 | 4019512.0 |
| 2004-08-17 11:05:00 | AAPL | Stock | 0.5466 | 0.5468 | 0.5457 | 0.5457 | 2094456.0 |
| 2004-08-17 11:10:00 | AAPL | Stock | 0.5455 | 0.5471 | 0.5455 | 0.547 | 1433096.0 |
| 2004-08-17 11:15:00 | AAPL | Stock | 0.5471 | 0.5473 | 0.5464 | 0.5471 | 1518888.0 |
| 2004-08-17 11:20:00 | AAPL | Stock | 0.547 | 0.5482 | 0.5466 | 0.548 | 3931760.0 |
| 2004-08-17 11:25:00 | AAPL | Stock | 0.5479 | 0.5505 | 0.5477 | 0.5504 | 6181784.0 |
| 2004-08-17 11:30:00 | AAPL | Stock | 0.5504 | 0.5521 | 0.5498 | 0.5514 | 8695400.0 |
| 2004-08-17 11:35:00 | AAPL | Stock | 0.5513 | 0.5536 | 0.5509 | 0.5529 | 5783680.0 |
| 2004-08-17 11:40:00 | AAPL | Stock | 0.5529 | 0.5539 | 0.5513 | 0.5518 | 5951456.0 |
| 2004-08-17 11:45:00 | AAPL | Stock | 0.552 | 0.553 | 0.5513 | 0.5523 | 2145640.0 |
| 2004-08-17 11:50:00 | AAPL | Stock | 0.5527 | 0.5534 | 0.5518 | 0.552 | 2784488.0 |
| 2004-08-17 11:55:00 | AAPL | Stock | 0.5521 | 0.5523 | 0.5509 | 0.5511 | 2928688.0 |
| 2004-08-17 12:00:00 | AAPL | Stock | 0.5511 | 0.5521 | 0.5511 | 0.552 | 1225280.0 |
| 2004-08-17 12:05:00 | AAPL | Stock | 0.5518 | 0.5527 | 0.5518 | 0.5525 | 2660560.0 |
| 2004-08-17 12:10:00 | AAPL | Stock | 0.5525 | 0.5527 | 0.5518 | 0.5525 | 1582952.0 |
| 2004-08-17 12:15:00 | AAPL | Stock | 0.5525 | 0.5548 | 0.5521 | 0.5546 | 3580920.0 |
> showing 50 of 174,595 rows — these rows as CSV