PREVIEW / stock_1min / 2009-05-06
file: by_date/stock_1min/2009/2009-05-06.parquet size: 13.7 MB rows: 1,037,137 symbols: 2,726
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 |
|---|---|---|---|---|---|---|---|
| 2009-05-06 07:00:00 | AAPL | Stock | 4.7143 | 4.7143 | 4.7143 | 4.7143 | 2800.0 |
| 2009-05-06 07:06:00 | AAPL | Stock | 4.7129 | 4.7129 | 4.7086 | 4.7086 | 25200.0 |
| 2009-05-06 07:10:00 | AAPL | Stock | 4.7086 | 4.7086 | 4.7086 | 4.7086 | 3444.0 |
| 2009-05-06 07:12:00 | AAPL | Stock | 4.7068 | 4.7068 | 4.7068 | 4.7068 | 2800.0 |
| 2009-05-06 07:22:00 | AAPL | Stock | 4.7054 | 4.7054 | 4.7036 | 4.7036 | 5600.0 |
| 2009-05-06 07:31:00 | AAPL | Stock | 4.7061 | 4.7061 | 4.7061 | 4.7061 | 2800.0 |
| 2009-05-06 07:49:00 | AAPL | Stock | 4.7061 | 4.7061 | 4.7036 | 4.7036 | 17724.0 |
| 2009-05-06 07:51:00 | AAPL | Stock | 4.705 | 4.705 | 4.7043 | 4.705 | 50400.0 |
| 2009-05-06 07:52:00 | AAPL | Stock | 4.7043 | 4.7043 | 4.7043 | 4.7043 | 56000.0 |
| 2009-05-06 07:53:00 | AAPL | Stock | 4.7054 | 4.7054 | 4.7054 | 4.7054 | 7560.0 |
| 2009-05-06 07:58:00 | AAPL | Stock | 4.7193 | 4.7193 | 4.7193 | 4.7193 | 5600.0 |
| 2009-05-06 07:59:00 | AAPL | Stock | 4.7143 | 4.7143 | 4.7107 | 4.7107 | 22400.0 |
| 2009-05-06 08:00:00 | AAPL | Stock | 4.7207 | 4.7236 | 4.7143 | 4.7143 | 16800.0 |
| 2009-05-06 08:02:00 | AAPL | Stock | 4.7286 | 4.7286 | 4.7286 | 4.7286 | 10360.0 |
| 2009-05-06 08:07:00 | AAPL | Stock | 4.7232 | 4.7232 | 4.7214 | 4.7214 | 47600.0 |
| 2009-05-06 08:15:00 | AAPL | Stock | 4.7286 | 4.7329 | 4.725 | 4.7329 | 93884.0 |
| 2009-05-06 08:16:00 | AAPL | Stock | 4.7329 | 4.7429 | 4.7329 | 4.7429 | 73920.0 |
| 2009-05-06 08:17:00 | AAPL | Stock | 4.7429 | 4.7496 | 4.7418 | 4.7418 | 30800.0 |
| 2009-05-06 08:18:00 | AAPL | Stock | 4.7371 | 4.7411 | 4.7357 | 4.7357 | 14672.0 |
| 2009-05-06 08:19:00 | AAPL | Stock | 4.7375 | 4.7375 | 4.7357 | 4.7357 | 5600.0 |
| 2009-05-06 08:20:00 | AAPL | Stock | 4.7375 | 4.7375 | 4.7375 | 4.7375 | 2800.0 |
| 2009-05-06 08:21:00 | AAPL | Stock | 4.7321 | 4.7321 | 4.7321 | 4.7321 | 8400.0 |
| 2009-05-06 08:22:00 | AAPL | Stock | 4.7318 | 4.7421 | 4.7318 | 4.7411 | 32536.0 |
| 2009-05-06 08:23:00 | AAPL | Stock | 4.7446 | 4.7446 | 4.7446 | 4.7446 | 14000.0 |
| 2009-05-06 08:24:00 | AAPL | Stock | 4.7439 | 4.7439 | 4.7439 | 4.7439 | 2800.0 |
| 2009-05-06 08:25:00 | AAPL | Stock | 4.7411 | 4.7411 | 4.7411 | 4.7411 | 2800.0 |
| 2009-05-06 08:26:00 | AAPL | Stock | 4.7411 | 4.7411 | 4.7411 | 4.7411 | 2800.0 |
| 2009-05-06 08:27:00 | AAPL | Stock | 4.7411 | 4.7411 | 4.7411 | 4.7411 | 16800.0 |
| 2009-05-06 08:28:00 | AAPL | Stock | 4.7404 | 4.7411 | 4.7404 | 4.7411 | 26600.0 |
| 2009-05-06 08:29:00 | AAPL | Stock | 4.7421 | 4.7464 | 4.7421 | 4.7464 | 51520.0 |
| 2009-05-06 08:30:00 | AAPL | Stock | 4.7464 | 4.7464 | 4.7457 | 4.7464 | 39424.0 |
| 2009-05-06 08:31:00 | AAPL | Stock | 4.7479 | 4.75 | 4.7464 | 4.7464 | 76384.0 |
| 2009-05-06 08:33:00 | AAPL | Stock | 4.7475 | 4.7525 | 4.7468 | 4.7525 | 93576.0 |
| 2009-05-06 08:34:00 | AAPL | Stock | 4.7571 | 4.7607 | 4.7539 | 4.7607 | 29260.0 |
| 2009-05-06 08:35:00 | AAPL | Stock | 4.7557 | 4.7589 | 4.7557 | 4.7589 | 5600.0 |
| 2009-05-06 08:36:00 | AAPL | Stock | 4.7582 | 4.7582 | 4.7582 | 4.7582 | 8400.0 |
| 2009-05-06 08:37:00 | AAPL | Stock | 4.7571 | 4.7571 | 4.7564 | 4.7564 | 5600.0 |
| 2009-05-06 08:38:00 | AAPL | Stock | 4.7564 | 4.7596 | 4.7564 | 4.7589 | 61600.0 |
| 2009-05-06 08:40:00 | AAPL | Stock | 4.76 | 4.7618 | 4.7593 | 4.7607 | 32200.0 |
| 2009-05-06 08:41:00 | AAPL | Stock | 4.7607 | 4.7607 | 4.76 | 4.7607 | 28000.0 |
| 2009-05-06 08:42:00 | AAPL | Stock | 4.7621 | 4.7621 | 4.7621 | 4.7621 | 23492.0 |
| 2009-05-06 08:43:00 | AAPL | Stock | 4.7604 | 4.7604 | 4.76 | 4.76 | 57064.0 |
| 2009-05-06 08:44:00 | AAPL | Stock | 4.7625 | 4.7625 | 4.7589 | 4.7607 | 71400.0 |
| 2009-05-06 08:45:00 | AAPL | Stock | 4.7604 | 4.7625 | 4.7604 | 4.7607 | 112000.0 |
| 2009-05-06 08:46:00 | AAPL | Stock | 4.7625 | 4.7679 | 4.7625 | 4.7679 | 119000.0 |
| 2009-05-06 08:47:00 | AAPL | Stock | 4.7682 | 4.7682 | 4.7661 | 4.7679 | 33600.0 |
| 2009-05-06 08:49:00 | AAPL | Stock | 4.7661 | 4.7682 | 4.7661 | 4.7682 | 11200.0 |
| 2009-05-06 08:50:00 | AAPL | Stock | 4.7396 | 4.7679 | 4.7396 | 4.7661 | 869904.0 |
| 2009-05-06 08:51:00 | AAPL | Stock | 4.7661 | 4.7661 | 4.7661 | 4.7661 | 13300.0 |
| 2009-05-06 08:52:00 | AAPL | Stock | 4.7646 | 4.7646 | 4.7643 | 4.7643 | 25200.0 |
> showing 50 of 1,037,137 rows — these rows as CSV