PREVIEW / stock_5min / 2005-07-26
file: by_date/stock_5min/2005/2005-07-26.parquet size: 2.7 MB rows: 198,215 symbols: 2,054
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 |
|---|---|---|---|---|---|---|---|
| 2005-07-26 08:15:00 | AAPL | Stock | 1.5671 | 1.5671 | 1.5671 | 1.5671 | 2800.0 |
| 2005-07-26 08:25:00 | AAPL | Stock | 1.5671 | 1.5671 | 1.5654 | 1.5654 | 28000.0 |
| 2005-07-26 08:30:00 | AAPL | Stock | 1.5671 | 1.5671 | 1.5671 | 1.5671 | 14000.0 |
| 2005-07-26 08:35:00 | AAPL | Stock | 1.5671 | 1.5671 | 1.5671 | 1.5671 | 28000.0 |
| 2005-07-26 08:40:00 | AAPL | Stock | 1.5664 | 1.5664 | 1.5664 | 1.5664 | 14000.0 |
| 2005-07-26 08:45:00 | AAPL | Stock | 1.5671 | 1.5743 | 1.5664 | 1.5711 | 72856.0 |
| 2005-07-26 08:50:00 | AAPL | Stock | 1.5671 | 1.5671 | 1.5671 | 1.5671 | 28000.0 |
| 2005-07-26 08:55:00 | AAPL | Stock | 1.5714 | 1.5714 | 1.5711 | 1.5711 | 60200.0 |
| 2005-07-26 09:00:00 | AAPL | Stock | 1.5704 | 1.5714 | 1.5696 | 1.5714 | 939540.0 |
| 2005-07-26 09:05:00 | AAPL | Stock | 1.5714 | 1.5746 | 1.5714 | 1.5746 | 86800.0 |
| 2005-07-26 09:10:00 | AAPL | Stock | 1.5746 | 1.5746 | 1.5714 | 1.5714 | 42000.0 |
| 2005-07-26 09:20:00 | AAPL | Stock | 1.5714 | 1.5714 | 1.5714 | 1.5714 | 20860.0 |
| 2005-07-26 09:25:00 | AAPL | Stock | 1.5714 | 1.5732 | 1.5707 | 1.5714 | 3405136.0 |
| 2005-07-26 09:30:00 | AAPL | Stock | 1.5718 | 1.5729 | 1.5671 | 1.5675 | 14476196.0 |
| 2005-07-26 09:35:00 | AAPL | Stock | 1.5675 | 1.5729 | 1.5671 | 1.5693 | 10713920.0 |
| 2005-07-26 09:40:00 | AAPL | Stock | 1.5693 | 1.5718 | 1.5686 | 1.5714 | 4602360.0 |
| 2005-07-26 09:45:00 | AAPL | Stock | 1.5714 | 1.5714 | 1.5654 | 1.5668 | 4337060.0 |
| 2005-07-26 09:50:00 | AAPL | Stock | 1.5668 | 1.5679 | 1.5639 | 1.5657 | 4558120.0 |
| 2005-07-26 09:55:00 | AAPL | Stock | 1.5661 | 1.5707 | 1.5657 | 1.57 | 5382860.0 |
| 2005-07-26 10:00:00 | AAPL | Stock | 1.5704 | 1.5707 | 1.5679 | 1.5693 | 8307740.0 |
| 2005-07-26 10:05:00 | AAPL | Stock | 1.5696 | 1.5707 | 1.5689 | 1.5693 | 3734640.0 |
| 2005-07-26 10:10:00 | AAPL | Stock | 1.5689 | 1.5754 | 1.5686 | 1.5707 | 8455272.0 |
| 2005-07-26 10:15:00 | AAPL | Stock | 1.5704 | 1.5732 | 1.5679 | 1.5721 | 5942048.0 |
| 2005-07-26 10:20:00 | AAPL | Stock | 1.5718 | 1.5736 | 1.5707 | 1.5711 | 5083176.0 |
| 2005-07-26 10:25:00 | AAPL | Stock | 1.5711 | 1.5729 | 1.5696 | 1.57 | 2574628.0 |
| 2005-07-26 10:30:00 | AAPL | Stock | 1.5707 | 1.5714 | 1.5679 | 1.5682 | 2240644.0 |
| 2005-07-26 10:35:00 | AAPL | Stock | 1.5682 | 1.5686 | 1.5654 | 1.5682 | 3505124.0 |
| 2005-07-26 10:40:00 | AAPL | Stock | 1.5679 | 1.5686 | 1.5654 | 1.5664 | 3956736.0 |
| 2005-07-26 10:45:00 | AAPL | Stock | 1.5664 | 1.5664 | 1.5511 | 1.5568 | 14637980.0 |
| 2005-07-26 10:50:00 | AAPL | Stock | 1.5571 | 1.5593 | 1.5543 | 1.5543 | 7823816.0 |
| 2005-07-26 10:55:00 | AAPL | Stock | 1.5546 | 1.5575 | 1.5507 | 1.5529 | 6422024.0 |
| 2005-07-26 11:00:00 | AAPL | Stock | 1.5532 | 1.5589 | 1.5529 | 1.5589 | 3342304.0 |
| 2005-07-26 11:05:00 | AAPL | Stock | 1.5589 | 1.5589 | 1.5564 | 1.5568 | 2074548.0 |
| 2005-07-26 11:10:00 | AAPL | Stock | 1.5564 | 1.5564 | 1.5518 | 1.5539 | 4055100.0 |
| 2005-07-26 11:15:00 | AAPL | Stock | 1.5539 | 1.5543 | 1.5514 | 1.5521 | 1688484.0 |
| 2005-07-26 11:20:00 | AAPL | Stock | 1.5521 | 1.5525 | 1.5486 | 1.5496 | 3926496.0 |
| 2005-07-26 11:25:00 | AAPL | Stock | 1.5493 | 1.5525 | 1.5489 | 1.5493 | 2872940.0 |
| 2005-07-26 11:30:00 | AAPL | Stock | 1.5489 | 1.5525 | 1.5489 | 1.55 | 3891832.0 |
| 2005-07-26 11:35:00 | AAPL | Stock | 1.55 | 1.5518 | 1.5496 | 1.5518 | 2298380.0 |
| 2005-07-26 11:40:00 | AAPL | Stock | 1.5514 | 1.5532 | 1.5493 | 1.55 | 2086560.0 |
| 2005-07-26 11:45:00 | AAPL | Stock | 1.5496 | 1.5521 | 1.5496 | 1.5514 | 2602544.0 |
| 2005-07-26 11:50:00 | AAPL | Stock | 1.5514 | 1.5521 | 1.5493 | 1.5511 | 1472184.0 |
| 2005-07-26 11:55:00 | AAPL | Stock | 1.5507 | 1.5568 | 1.5507 | 1.5564 | 5542768.0 |
| 2005-07-26 12:00:00 | AAPL | Stock | 1.5564 | 1.5564 | 1.5532 | 1.5539 | 2337720.0 |
| 2005-07-26 12:05:00 | AAPL | Stock | 1.5539 | 1.5539 | 1.5521 | 1.5532 | 1300040.0 |
| 2005-07-26 12:10:00 | AAPL | Stock | 1.5536 | 1.5543 | 1.5521 | 1.5532 | 1661856.0 |
| 2005-07-26 12:15:00 | AAPL | Stock | 1.5532 | 1.555 | 1.5493 | 1.5529 | 2567432.0 |
| 2005-07-26 12:20:00 | AAPL | Stock | 1.5529 | 1.5546 | 1.5518 | 1.5521 | 1441692.0 |
| 2005-07-26 12:25:00 | AAPL | Stock | 1.5521 | 1.5525 | 1.5486 | 1.5493 | 2404864.0 |
| 2005-07-26 12:30:00 | AAPL | Stock | 1.5496 | 1.5504 | 1.5486 | 1.5504 | 2043076.0 |
> showing 50 of 198,215 rows — these rows as CSV