PREVIEW / stock_1min / 2005-07-22
file: by_date/stock_1min/2005/2005-07-22.parquet size: 6.9 MB rows: 563,054 symbols: 1,658
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.5454 | 1.5454 | 28000.0 |
| 2005-07-22 08:11:00 | AAPL | Stock | 1.5425 | 1.5425 | 1.5425 | 1.5425 | 8400.0 |
| 2005-07-22 08:16:00 | AAPL | Stock | 1.545 | 1.5454 | 1.545 | 1.5454 | 14000.0 |
| 2005-07-22 08:28:00 | AAPL | Stock | 1.5429 | 1.5429 | 1.5429 | 1.5429 | 2800.0 |
| 2005-07-22 08:31:00 | AAPL | Stock | 1.5429 | 1.5429 | 1.5429 | 1.5429 | 25200.0 |
| 2005-07-22 08:38:00 | AAPL | Stock | 1.5518 | 1.5532 | 1.5518 | 1.5532 | 14000.0 |
| 2005-07-22 08:39:00 | AAPL | Stock | 1.5532 | 1.5536 | 1.5532 | 1.5536 | 37800.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.5464 | 1.5464 | 1.5464 | 2800.0 |
| 2005-07-22 08:47:00 | AAPL | Stock | 1.5532 | 1.5536 | 1.5489 | 1.5489 | 30800.0 |
| 2005-07-22 08:56:00 | AAPL | Stock | 1.5536 | 1.5536 | 1.5536 | 1.5536 | 28000.0 |
| 2005-07-22 09:07:00 | AAPL | Stock | 1.5536 | 1.5536 | 1.5532 | 1.5536 | 29400.0 |
| 2005-07-22 09:08:00 | AAPL | Stock | 1.5536 | 1.5543 | 1.5536 | 1.5536 | 30800.0 |
| 2005-07-22 09:10:00 | AAPL | Stock | 1.5543 | 1.5543 | 1.5543 | 1.5543 | 28000.0 |
| 2005-07-22 09:11:00 | AAPL | Stock | 1.5543 | 1.5543 | 1.5543 | 1.5543 | 14000.0 |
| 2005-07-22 09:12:00 | AAPL | Stock | 1.5543 | 1.5543 | 1.5543 | 1.5543 | 8400.0 |
| 2005-07-22 09:13:00 | AAPL | Stock | 1.5543 | 1.5543 | 1.5543 | 1.5543 | 5600.0 |
| 2005-07-22 09:16:00 | AAPL | Stock | 1.5543 | 1.5543 | 1.5543 | 1.5543 | 2800.0 |
| 2005-07-22 09:17:00 | AAPL | Stock | 1.5536 | 1.5536 | 1.5536 | 1.5536 | 5600.0 |
| 2005-07-22 09:18:00 | AAPL | Stock | 1.5536 | 1.5536 | 1.5536 | 1.5536 | 50400.0 |
| 2005-07-22 09:20:00 | AAPL | Stock | 1.5536 | 1.5536 | 1.5536 | 1.5536 | 81200.0 |
| 2005-07-22 09:24:00 | AAPL | Stock | 1.5539 | 1.5539 | 1.5536 | 1.5536 | 792400.0 |
| 2005-07-22 09:25:00 | AAPL | Stock | 1.55 | 1.55 | 1.55 | 1.55 | 5600.0 |
| 2005-07-22 09:26:00 | AAPL | Stock | 1.5536 | 1.5536 | 1.5536 | 1.5536 | 2800.0 |
| 2005-07-22 09:29:00 | AAPL | Stock | 1.5525 | 1.5536 | 1.5511 | 1.5518 | 53200.0 |
| 2005-07-22 09:30:00 | AAPL | Stock | 1.5514 | 1.5564 | 1.5507 | 1.5532 | 4049528.0 |
| 2005-07-22 09:31:00 | AAPL | Stock | 1.5536 | 1.5571 | 1.5529 | 1.5571 | 3572660.0 |
| 2005-07-22 09:32:00 | AAPL | Stock | 1.5564 | 1.5621 | 1.5564 | 1.5589 | 2447872.0 |
| 2005-07-22 09:33:00 | AAPL | Stock | 1.5589 | 1.5625 | 1.5579 | 1.5621 | 2421916.0 |
| 2005-07-22 09:34:00 | AAPL | Stock | 1.5621 | 1.5621 | 1.5596 | 1.56 | 975072.0 |
| 2005-07-22 09:35:00 | AAPL | Stock | 1.56 | 1.56 | 1.5571 | 1.5582 | 1038604.0 |
| 2005-07-22 09:36:00 | AAPL | Stock | 1.5579 | 1.5579 | 1.5539 | 1.5546 | 1499064.0 |
| 2005-07-22 09:37:00 | AAPL | Stock | 1.5543 | 1.5571 | 1.5521 | 1.5536 | 1946952.0 |
| 2005-07-22 09:38:00 | AAPL | Stock | 1.5536 | 1.5586 | 1.5536 | 1.5586 | 1401456.0 |
| 2005-07-22 09:39:00 | AAPL | Stock | 1.5586 | 1.5589 | 1.5507 | 1.5507 | 1388492.0 |
| 2005-07-22 09:40:00 | AAPL | Stock | 1.5511 | 1.555 | 1.5496 | 1.5546 | 1311632.0 |
| 2005-07-22 09:41:00 | AAPL | Stock | 1.5546 | 1.5571 | 1.5521 | 1.5561 | 1003408.0 |
| 2005-07-22 09:42:00 | AAPL | Stock | 1.5561 | 1.5561 | 1.5529 | 1.555 | 820400.0 |
| 2005-07-22 09:43:00 | AAPL | Stock | 1.5546 | 1.5554 | 1.5543 | 1.5554 | 584388.0 |
| 2005-07-22 09:44:00 | AAPL | Stock | 1.5554 | 1.5604 | 1.5554 | 1.5582 | 1925028.0 |
| 2005-07-22 09:45:00 | AAPL | Stock | 1.5589 | 1.5618 | 1.5586 | 1.5596 | 1130696.0 |
| 2005-07-22 09:46:00 | AAPL | Stock | 1.56 | 1.5611 | 1.5596 | 1.5611 | 979160.0 |
| 2005-07-22 09:47:00 | AAPL | Stock | 1.5607 | 1.5621 | 1.5593 | 1.5618 | 1298836.0 |
| 2005-07-22 09:48:00 | AAPL | Stock | 1.5618 | 1.5621 | 1.56 | 1.5611 | 871416.0 |
| 2005-07-22 09:49:00 | AAPL | Stock | 1.5611 | 1.5629 | 1.5607 | 1.5629 | 1187340.0 |
| 2005-07-22 09:50:00 | AAPL | Stock | 1.5629 | 1.565 | 1.5607 | 1.5643 | 2999976.0 |
| 2005-07-22 09:51:00 | AAPL | Stock | 1.5636 | 1.565 | 1.5629 | 1.5632 | 1149120.0 |
| 2005-07-22 09:52:00 | AAPL | Stock | 1.5636 | 1.5643 | 1.5625 | 1.5625 | 970788.0 |
| 2005-07-22 09:53:00 | AAPL | Stock | 1.5632 | 1.5632 | 1.5614 | 1.5614 | 684936.0 |
| 2005-07-22 09:54:00 | AAPL | Stock | 1.5614 | 1.5632 | 1.5614 | 1.5618 | 837816.0 |
> showing 50 of 563,054 rows — these rows as CSV