PREVIEW / stock_1min / 2010-03-30
file: by_date/stock_1min/2010/2010-03-30.parquet size: 12.6 MB rows: 954,465 symbols: 2,836
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 |
|---|---|---|---|---|---|---|---|
| 2010-03-30 04:19:00 | AAPL | Stock | 8.4625 | 8.4625 | 8.4625 | 8.4625 | 2800.0 |
| 2010-03-30 04:20:00 | AAPL | Stock | 8.4579 | 8.4579 | 8.4579 | 8.4579 | 2800.0 |
| 2010-03-30 04:47:00 | AAPL | Stock | 8.4643 | 8.4643 | 8.4643 | 8.4643 | 5600.0 |
| 2010-03-30 04:53:00 | AAPL | Stock | 8.4611 | 8.4611 | 8.4611 | 8.4611 | 2800.0 |
| 2010-03-30 05:42:00 | AAPL | Stock | 8.4721 | 8.4721 | 8.4721 | 8.4721 | 14000.0 |
| 2010-03-30 06:03:00 | AAPL | Stock | 8.4643 | 8.4643 | 8.4643 | 8.4643 | 2800.0 |
| 2010-03-30 06:10:00 | AAPL | Stock | 8.4643 | 8.4643 | 8.4643 | 8.4643 | 9800.0 |
| 2010-03-30 06:22:00 | AAPL | Stock | 8.4646 | 8.4646 | 8.4646 | 8.4646 | 2800.0 |
| 2010-03-30 06:24:00 | AAPL | Stock | 8.4725 | 8.4725 | 8.4725 | 8.4725 | 2800.0 |
| 2010-03-30 06:27:00 | AAPL | Stock | 8.4743 | 8.4743 | 8.4743 | 8.4743 | 2800.0 |
| 2010-03-30 06:35:00 | AAPL | Stock | 8.4707 | 8.4707 | 8.4707 | 8.4707 | 11200.0 |
| 2010-03-30 06:37:00 | AAPL | Stock | 8.4707 | 8.4707 | 8.4707 | 8.4707 | 2800.0 |
| 2010-03-30 06:57:00 | AAPL | Stock | 8.4682 | 8.4682 | 8.4682 | 8.4682 | 5600.0 |
| 2010-03-30 07:00:00 | AAPL | Stock | 8.4679 | 8.4682 | 8.4679 | 8.4682 | 9800.0 |
| 2010-03-30 07:01:00 | AAPL | Stock | 8.465 | 8.4704 | 8.4614 | 8.4643 | 47992.0 |
| 2010-03-30 07:02:00 | AAPL | Stock | 8.4614 | 8.4614 | 8.4614 | 8.4614 | 19600.0 |
| 2010-03-30 07:03:00 | AAPL | Stock | 8.4614 | 8.4643 | 8.4614 | 8.4643 | 54740.0 |
| 2010-03-30 07:04:00 | AAPL | Stock | 8.4643 | 8.4646 | 8.4643 | 8.4643 | 87248.0 |
| 2010-03-30 07:05:00 | AAPL | Stock | 8.4611 | 8.4611 | 8.4611 | 8.4611 | 2800.0 |
| 2010-03-30 07:07:00 | AAPL | Stock | 8.4607 | 8.4607 | 8.4554 | 8.4607 | 14000.0 |
| 2010-03-30 07:08:00 | AAPL | Stock | 8.4607 | 8.4607 | 8.4607 | 8.4607 | 2800.0 |
| 2010-03-30 07:14:00 | AAPL | Stock | 8.4604 | 8.4604 | 8.4604 | 8.4604 | 2800.0 |
| 2010-03-30 07:16:00 | AAPL | Stock | 8.4607 | 8.4607 | 8.4607 | 8.4607 | 11536.0 |
| 2010-03-30 07:20:00 | AAPL | Stock | 8.4643 | 8.4643 | 8.4643 | 8.4643 | 9772.0 |
| 2010-03-30 07:21:00 | AAPL | Stock | 8.4643 | 8.4643 | 8.4643 | 8.4643 | 4228.0 |
| 2010-03-30 07:25:00 | AAPL | Stock | 8.4754 | 8.4754 | 8.4754 | 8.4754 | 2800.0 |
| 2010-03-30 07:26:00 | AAPL | Stock | 8.4754 | 8.4757 | 8.4754 | 8.4757 | 13048.0 |
| 2010-03-30 07:27:00 | AAPL | Stock | 8.4782 | 8.4782 | 8.4782 | 8.4782 | 5600.0 |
| 2010-03-30 07:29:00 | AAPL | Stock | 8.4782 | 8.4893 | 8.4782 | 8.4893 | 18200.0 |
| 2010-03-30 07:30:00 | AAPL | Stock | 8.4893 | 8.4893 | 8.4893 | 8.4893 | 5600.0 |
| 2010-03-30 07:31:00 | AAPL | Stock | 8.4893 | 8.4893 | 8.4754 | 8.4786 | 37800.0 |
| 2010-03-30 07:36:00 | AAPL | Stock | 8.4786 | 8.4786 | 8.4786 | 8.4786 | 2940.0 |
| 2010-03-30 07:37:00 | AAPL | Stock | 8.4804 | 8.4871 | 8.4804 | 8.4871 | 36064.0 |
| 2010-03-30 07:43:00 | AAPL | Stock | 8.4718 | 8.4718 | 8.4714 | 8.4714 | 19600.0 |
| 2010-03-30 07:44:00 | AAPL | Stock | 8.4714 | 8.4746 | 8.4643 | 8.4643 | 57372.0 |
| 2010-03-30 07:45:00 | AAPL | Stock | 8.4639 | 8.4639 | 8.4639 | 8.4639 | 5600.0 |
| 2010-03-30 07:46:00 | AAPL | Stock | 8.4554 | 8.4604 | 8.4554 | 8.4604 | 29456.0 |
| 2010-03-30 07:47:00 | AAPL | Stock | 8.4554 | 8.4554 | 8.4507 | 8.4507 | 25816.0 |
| 2010-03-30 07:48:00 | AAPL | Stock | 8.4554 | 8.4554 | 8.45 | 8.45 | 67480.0 |
| 2010-03-30 07:49:00 | AAPL | Stock | 8.45 | 8.4554 | 8.4482 | 8.4536 | 258356.0 |
| 2010-03-30 07:50:00 | AAPL | Stock | 8.4539 | 8.4607 | 8.4536 | 8.4571 | 126000.0 |
| 2010-03-30 07:51:00 | AAPL | Stock | 8.4589 | 8.4589 | 8.4393 | 8.4393 | 110516.0 |
| 2010-03-30 07:52:00 | AAPL | Stock | 8.4393 | 8.4607 | 8.4361 | 8.4468 | 121884.0 |
| 2010-03-30 07:53:00 | AAPL | Stock | 8.4436 | 8.4554 | 8.4436 | 8.4554 | 30800.0 |
| 2010-03-30 07:54:00 | AAPL | Stock | 8.445 | 8.4571 | 8.445 | 8.4571 | 30912.0 |
| 2010-03-30 07:55:00 | AAPL | Stock | 8.4482 | 8.4571 | 8.4482 | 8.4571 | 11200.0 |
| 2010-03-30 07:56:00 | AAPL | Stock | 8.4571 | 8.4571 | 8.4543 | 8.4546 | 27804.0 |
| 2010-03-30 07:57:00 | AAPL | Stock | 8.4625 | 8.4629 | 8.4571 | 8.4571 | 40068.0 |
| 2010-03-30 07:58:00 | AAPL | Stock | 8.4486 | 8.4489 | 8.4486 | 8.4489 | 5600.0 |
| 2010-03-30 07:59:00 | AAPL | Stock | 8.4489 | 8.4518 | 8.4489 | 8.4518 | 22400.0 |
> showing 50 of 954,465 rows — these rows as CSV