PREVIEW / stock_5min / 2005-07-22
file: by_date/stock_5min/2005/2005-07-22.parquet size: 2.7 MB rows: 198,242 symbols: 2,028
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-22 08:10:00 | AAPL | Stock | 1.5454 | 1.5454 | 1.5425 | 1.5425 | 36400.0 |
| 2005-07-22 08:15:00 | AAPL | Stock | 1.545 | 1.5454 | 1.545 | 1.5454 | 14000.0 |
| 2005-07-22 08:25:00 | AAPL | Stock | 1.5429 | 1.5429 | 1.5429 | 1.5429 | 2800.0 |
| 2005-07-22 08:30:00 | AAPL | Stock | 1.5429 | 1.5429 | 1.5429 | 1.5429 | 25200.0 |
| 2005-07-22 08:35:00 | AAPL | Stock | 1.5518 | 1.5536 | 1.5518 | 1.5536 | 51800.0 |
| 2005-07-22 08:40:00 | AAPL | Stock | 1.5536 | 1.5536 | 1.5536 | 1.5536 | 28000.0 |
| 2005-07-22 08:45:00 | AAPL | Stock | 1.5464 | 1.5536 | 1.5464 | 1.5489 | 33600.0 |
| 2005-07-22 08:55:00 | AAPL | Stock | 1.5536 | 1.5536 | 1.5536 | 1.5536 | 28000.0 |
| 2005-07-22 09:05:00 | AAPL | Stock | 1.5536 | 1.5543 | 1.5532 | 1.5536 | 60200.0 |
| 2005-07-22 09:10:00 | AAPL | Stock | 1.5543 | 1.5543 | 1.5543 | 1.5543 | 56000.0 |
| 2005-07-22 09:15:00 | AAPL | Stock | 1.5543 | 1.5543 | 1.5536 | 1.5536 | 58800.0 |
| 2005-07-22 09:20:00 | AAPL | Stock | 1.5536 | 1.5539 | 1.5536 | 1.5536 | 873600.0 |
| 2005-07-22 09:25:00 | AAPL | Stock | 1.55 | 1.5536 | 1.55 | 1.5518 | 61600.0 |
| 2005-07-22 09:30:00 | AAPL | Stock | 1.5514 | 1.5625 | 1.5507 | 1.56 | 13467048.0 |
| 2005-07-22 09:35:00 | AAPL | Stock | 1.56 | 1.56 | 1.5507 | 1.5507 | 7274568.0 |
| 2005-07-22 09:40:00 | AAPL | Stock | 1.5511 | 1.5604 | 1.5496 | 1.5582 | 5644856.0 |
| 2005-07-22 09:45:00 | AAPL | Stock | 1.5589 | 1.5629 | 1.5586 | 1.5629 | 5467448.0 |
| 2005-07-22 09:50:00 | AAPL | Stock | 1.5629 | 1.565 | 1.5607 | 1.5618 | 6642636.0 |
| 2005-07-22 09:55:00 | AAPL | Stock | 1.5618 | 1.5643 | 1.5593 | 1.5639 | 6014372.0 |
| 2005-07-22 10:00:00 | AAPL | Stock | 1.5636 | 1.5639 | 1.5607 | 1.5607 | 5592272.0 |
| 2005-07-22 10:05:00 | AAPL | Stock | 1.5614 | 1.5643 | 1.5614 | 1.5639 | 5142732.0 |
| 2005-07-22 10:10:00 | AAPL | Stock | 1.5636 | 1.5707 | 1.5636 | 1.5689 | 7310464.0 |
| 2005-07-22 10:15:00 | AAPL | Stock | 1.5689 | 1.5693 | 1.5668 | 1.5679 | 4419156.0 |
| 2005-07-22 10:20:00 | AAPL | Stock | 1.5679 | 1.5704 | 1.5671 | 1.57 | 5299700.0 |
| 2005-07-22 10:25:00 | AAPL | Stock | 1.57 | 1.5714 | 1.5675 | 1.5682 | 6899844.0 |
| 2005-07-22 10:30:00 | AAPL | Stock | 1.5686 | 1.5696 | 1.565 | 1.5664 | 5533416.0 |
| 2005-07-22 10:35:00 | AAPL | Stock | 1.5664 | 1.5675 | 1.5632 | 1.5654 | 6422500.0 |
| 2005-07-22 10:40:00 | AAPL | Stock | 1.5654 | 1.5654 | 1.5607 | 1.5618 | 5525660.0 |
| 2005-07-22 10:45:00 | AAPL | Stock | 1.5621 | 1.5629 | 1.5571 | 1.5586 | 8721608.0 |
| 2005-07-22 10:50:00 | AAPL | Stock | 1.5589 | 1.56 | 1.5571 | 1.56 | 5491780.0 |
| 2005-07-22 10:55:00 | AAPL | Stock | 1.56 | 1.5632 | 1.5596 | 1.5621 | 4168864.0 |
| 2005-07-22 11:00:00 | AAPL | Stock | 1.5621 | 1.5632 | 1.5596 | 1.5611 | 3633028.0 |
| 2005-07-22 11:05:00 | AAPL | Stock | 1.5611 | 1.5657 | 1.5607 | 1.5646 | 4693584.0 |
| 2005-07-22 11:10:00 | AAPL | Stock | 1.5646 | 1.565 | 1.5621 | 1.5639 | 3768184.0 |
| 2005-07-22 11:15:00 | AAPL | Stock | 1.5636 | 1.5657 | 1.5629 | 1.5654 | 3207652.0 |
| 2005-07-22 11:20:00 | AAPL | Stock | 1.565 | 1.565 | 1.5614 | 1.5618 | 2096108.0 |
| 2005-07-22 11:25:00 | AAPL | Stock | 1.5618 | 1.5636 | 1.5607 | 1.5614 | 2981664.0 |
| 2005-07-22 11:30:00 | AAPL | Stock | 1.5614 | 1.5625 | 1.5607 | 1.5611 | 2364740.0 |
| 2005-07-22 11:35:00 | AAPL | Stock | 1.5611 | 1.5621 | 1.5596 | 1.5607 | 1849008.0 |
| 2005-07-22 11:40:00 | AAPL | Stock | 1.5607 | 1.5636 | 1.5592 | 1.5636 | 2153648.0 |
| 2005-07-22 11:45:00 | AAPL | Stock | 1.5636 | 1.5636 | 1.5592 | 1.5632 | 2419340.0 |
| 2005-07-22 11:50:00 | AAPL | Stock | 1.5632 | 1.5639 | 1.5621 | 1.5636 | 1818656.0 |
| 2005-07-22 11:55:00 | AAPL | Stock | 1.5636 | 1.565 | 1.5636 | 1.5646 | 1460060.0 |
| 2005-07-22 12:00:00 | AAPL | Stock | 1.5643 | 1.565 | 1.5636 | 1.5643 | 1116360.0 |
| 2005-07-22 12:05:00 | AAPL | Stock | 1.5639 | 1.5679 | 1.5636 | 1.5636 | 3759364.0 |
| 2005-07-22 12:10:00 | AAPL | Stock | 1.5636 | 1.5675 | 1.5636 | 1.5657 | 2108428.0 |
| 2005-07-22 12:15:00 | AAPL | Stock | 1.5654 | 1.5657 | 1.5643 | 1.5646 | 2138836.0 |
| 2005-07-22 12:20:00 | AAPL | Stock | 1.5646 | 1.5646 | 1.5632 | 1.5636 | 888020.0 |
| 2005-07-22 12:25:00 | AAPL | Stock | 1.5636 | 1.5643 | 1.5621 | 1.5625 | 1450036.0 |
| 2005-07-22 12:30:00 | AAPL | Stock | 1.5629 | 1.5629 | 1.5614 | 1.5618 | 1348172.0 |
> showing 50 of 198,242 rows — these rows as CSV