PREVIEW / stock_1min / 2005-08-19
file: by_date/stock_1min/2005/2005-08-19.parquet size: 6.3 MB rows: 530,950 symbols: 1,689
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-08-19 08:10:00 | AAPL | Stock | 1.6646 | 1.6646 | 1.6646 | 1.6646 | 2800.0 |
| 2005-08-19 08:17:00 | AAPL | Stock | 1.6643 | 1.6643 | 1.6643 | 1.6643 | 53200.0 |
| 2005-08-19 08:18:00 | AAPL | Stock | 1.6643 | 1.665 | 1.6643 | 1.665 | 28000.0 |
| 2005-08-19 08:23:00 | AAPL | Stock | 1.665 | 1.665 | 1.665 | 1.665 | 19600.0 |
| 2005-08-19 08:25:00 | AAPL | Stock | 1.665 | 1.665 | 1.665 | 1.665 | 5600.0 |
| 2005-08-19 08:34:00 | AAPL | Stock | 1.6639 | 1.6639 | 1.6639 | 1.6639 | 11200.0 |
| 2005-08-19 08:36:00 | AAPL | Stock | 1.6607 | 1.6636 | 1.6607 | 1.6636 | 9800.0 |
| 2005-08-19 08:37:00 | AAPL | Stock | 1.6636 | 1.6636 | 1.6636 | 1.6636 | 5600.0 |
| 2005-08-19 08:46:00 | AAPL | Stock | 1.6636 | 1.6636 | 1.6636 | 1.6636 | 2800.0 |
| 2005-08-19 08:47:00 | AAPL | Stock | 1.6618 | 1.6618 | 1.6618 | 1.6618 | 19600.0 |
| 2005-08-19 08:48:00 | AAPL | Stock | 1.6618 | 1.6625 | 1.6618 | 1.6625 | 56000.0 |
| 2005-08-19 08:49:00 | AAPL | Stock | 1.6614 | 1.6614 | 1.6614 | 1.6614 | 28000.0 |
| 2005-08-19 08:51:00 | AAPL | Stock | 1.6625 | 1.6625 | 1.6625 | 1.6625 | 28000.0 |
| 2005-08-19 08:54:00 | AAPL | Stock | 1.6625 | 1.6625 | 1.6625 | 1.6625 | 5600.0 |
| 2005-08-19 08:57:00 | AAPL | Stock | 1.6625 | 1.6625 | 1.6625 | 1.6625 | 7000.0 |
| 2005-08-19 08:58:00 | AAPL | Stock | 1.6625 | 1.6625 | 1.6625 | 1.6625 | 39200.0 |
| 2005-08-19 08:59:00 | AAPL | Stock | 1.6607 | 1.6607 | 1.6607 | 1.6607 | 5600.0 |
| 2005-08-19 09:01:00 | AAPL | Stock | 1.6621 | 1.6621 | 1.6621 | 1.6621 | 28000.0 |
| 2005-08-19 09:02:00 | AAPL | Stock | 1.6607 | 1.6607 | 1.6607 | 1.6607 | 28000.0 |
| 2005-08-19 09:03:00 | AAPL | Stock | 1.6593 | 1.6593 | 1.6593 | 1.6593 | 2800.0 |
| 2005-08-19 09:04:00 | AAPL | Stock | 1.6621 | 1.6621 | 1.6621 | 1.6621 | 86800.0 |
| 2005-08-19 09:08:00 | AAPL | Stock | 1.6621 | 1.6621 | 1.6607 | 1.6607 | 30800.0 |
| 2005-08-19 09:10:00 | AAPL | Stock | 1.6607 | 1.6607 | 1.6607 | 1.6607 | 28000.0 |
| 2005-08-19 09:12:00 | AAPL | Stock | 1.6607 | 1.6621 | 1.6607 | 1.6621 | 140000.0 |
| 2005-08-19 09:16:00 | AAPL | Stock | 1.6607 | 1.6639 | 1.6607 | 1.6614 | 186200.0 |
| 2005-08-19 09:17:00 | AAPL | Stock | 1.6607 | 1.6607 | 1.6607 | 1.6607 | 28000.0 |
| 2005-08-19 09:23:00 | AAPL | Stock | 1.6593 | 1.6593 | 1.6582 | 1.6582 | 16800.0 |
| 2005-08-19 09:24:00 | AAPL | Stock | 1.6607 | 1.6607 | 1.6607 | 1.6607 | 8400.0 |
| 2005-08-19 09:25:00 | AAPL | Stock | 1.6607 | 1.6607 | 1.6539 | 1.6554 | 616868.0 |
| 2005-08-19 09:26:00 | AAPL | Stock | 1.6557 | 1.66 | 1.6557 | 1.6589 | 380800.0 |
| 2005-08-19 09:27:00 | AAPL | Stock | 1.6571 | 1.66 | 1.6557 | 1.6561 | 221200.0 |
| 2005-08-19 09:28:00 | AAPL | Stock | 1.6561 | 1.6561 | 1.6521 | 1.6521 | 449680.0 |
| 2005-08-19 09:29:00 | AAPL | Stock | 1.6529 | 1.6561 | 1.6511 | 1.6543 | 731752.0 |
| 2005-08-19 09:30:00 | AAPL | Stock | 1.6529 | 1.6554 | 1.65 | 1.6546 | 20977208.0 |
| 2005-08-19 09:31:00 | AAPL | Stock | 1.6546 | 1.655 | 1.65 | 1.6511 | 1348536.0 |
| 2005-08-19 09:32:00 | AAPL | Stock | 1.6514 | 1.6554 | 1.6511 | 1.6536 | 1199772.0 |
| 2005-08-19 09:33:00 | AAPL | Stock | 1.6536 | 1.66 | 1.6529 | 1.6596 | 2040696.0 |
| 2005-08-19 09:34:00 | AAPL | Stock | 1.66 | 1.66 | 1.6579 | 1.6589 | 1439424.0 |
| 2005-08-19 09:35:00 | AAPL | Stock | 1.6589 | 1.6593 | 1.6561 | 1.6564 | 1956164.0 |
| 2005-08-19 09:36:00 | AAPL | Stock | 1.6568 | 1.6586 | 1.6554 | 1.6571 | 1530144.0 |
| 2005-08-19 09:37:00 | AAPL | Stock | 1.6571 | 1.6579 | 1.6539 | 1.6554 | 903588.0 |
| 2005-08-19 09:38:00 | AAPL | Stock | 1.6557 | 1.6571 | 1.6557 | 1.6561 | 1132768.0 |
| 2005-08-19 09:39:00 | AAPL | Stock | 1.6561 | 1.6561 | 1.6539 | 1.655 | 2133656.0 |
| 2005-08-19 09:40:00 | AAPL | Stock | 1.6557 | 1.6596 | 1.655 | 1.658 | 1549492.0 |
| 2005-08-19 09:41:00 | AAPL | Stock | 1.6579 | 1.6582 | 1.655 | 1.655 | 1748180.0 |
| 2005-08-19 09:42:00 | AAPL | Stock | 1.655 | 1.6589 | 1.6546 | 1.6582 | 2429000.0 |
| 2005-08-19 09:43:00 | AAPL | Stock | 1.6582 | 1.6596 | 1.6564 | 1.6586 | 1883532.0 |
| 2005-08-19 09:44:00 | AAPL | Stock | 1.6596 | 1.6607 | 1.6579 | 1.6593 | 1404984.0 |
| 2005-08-19 09:45:00 | AAPL | Stock | 1.6593 | 1.66 | 1.6586 | 1.6593 | 1022840.0 |
| 2005-08-19 09:46:00 | AAPL | Stock | 1.6593 | 1.6607 | 1.6586 | 1.66 | 3454332.0 |
> showing 50 of 530,950 rows — these rows as CSV