PREVIEW / stock_1min / 2006-06-28
file: by_date/stock_1min/2006/2006-06-28.parquet size: 8.2 MB rows: 682,753 symbols: 1,872
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 |
|---|---|---|---|---|---|---|---|
| 2006-06-28 07:38:00 | AAPL | Stock | 2.0482 | 2.0482 | 2.0482 | 2.0482 | 5600.0 |
| 2006-06-28 07:40:00 | AAPL | Stock | 2.0571 | 2.0571 | 2.0571 | 2.0571 | 7000.0 |
| 2006-06-28 07:57:00 | AAPL | Stock | 2.05 | 2.05 | 2.0482 | 2.0482 | 56000.0 |
| 2006-06-28 07:59:00 | AAPL | Stock | 2.0482 | 2.0482 | 2.0464 | 2.0464 | 28000.0 |
| 2006-06-28 08:00:00 | AAPL | Stock | 2.0589 | 2.0589 | 2.0482 | 2.0486 | 101500.0 |
| 2006-06-28 08:01:00 | AAPL | Stock | 2.0482 | 2.05 | 2.0482 | 2.05 | 61600.0 |
| 2006-06-28 08:02:00 | AAPL | Stock | 2.0536 | 2.0554 | 2.05 | 2.05 | 63000.0 |
| 2006-06-28 08:03:00 | AAPL | Stock | 2.0511 | 2.0557 | 2.0511 | 2.0557 | 19600.0 |
| 2006-06-28 08:04:00 | AAPL | Stock | 2.0543 | 2.0554 | 2.0543 | 2.0554 | 82684.0 |
| 2006-06-28 08:05:00 | AAPL | Stock | 2.0554 | 2.0554 | 2.0536 | 2.0536 | 19600.0 |
| 2006-06-28 08:06:00 | AAPL | Stock | 2.055 | 2.055 | 2.055 | 2.055 | 5600.0 |
| 2006-06-28 08:08:00 | AAPL | Stock | 2.0543 | 2.0543 | 2.0539 | 2.0539 | 15400.0 |
| 2006-06-28 08:10:00 | AAPL | Stock | 2.0539 | 2.0539 | 2.0536 | 2.0536 | 78400.0 |
| 2006-06-28 08:11:00 | AAPL | Stock | 2.0554 | 2.0554 | 2.0554 | 2.0554 | 11200.0 |
| 2006-06-28 08:14:00 | AAPL | Stock | 2.0554 | 2.0564 | 2.0554 | 2.0564 | 21000.0 |
| 2006-06-28 08:17:00 | AAPL | Stock | 2.0536 | 2.0536 | 2.0536 | 2.0536 | 8400.0 |
| 2006-06-28 08:18:00 | AAPL | Stock | 2.0557 | 2.0564 | 2.0557 | 2.0564 | 64960.0 |
| 2006-06-28 08:19:00 | AAPL | Stock | 2.0557 | 2.0557 | 2.0557 | 2.0557 | 16800.0 |
| 2006-06-28 08:20:00 | AAPL | Stock | 2.0564 | 2.0564 | 2.0564 | 2.0564 | 28000.0 |
| 2006-06-28 08:21:00 | AAPL | Stock | 2.0564 | 2.0564 | 2.0564 | 2.0564 | 19600.0 |
| 2006-06-28 08:22:00 | AAPL | Stock | 2.0564 | 2.0571 | 2.0557 | 2.0571 | 136360.0 |
| 2006-06-28 08:23:00 | AAPL | Stock | 2.0557 | 2.0557 | 2.0525 | 2.0525 | 193480.0 |
| 2006-06-28 08:27:00 | AAPL | Stock | 2.0511 | 2.0511 | 2.0486 | 2.05 | 166600.0 |
| 2006-06-28 08:28:00 | AAPL | Stock | 2.0482 | 2.0482 | 2.0482 | 2.0482 | 4900.0 |
| 2006-06-28 08:29:00 | AAPL | Stock | 2.0468 | 2.0468 | 2.0446 | 2.0464 | 290360.0 |
| 2006-06-28 08:30:00 | AAPL | Stock | 2.0482 | 2.0493 | 2.0436 | 2.0436 | 137900.0 |
| 2006-06-28 08:31:00 | AAPL | Stock | 2.0446 | 2.0464 | 2.0446 | 2.0464 | 43400.0 |
| 2006-06-28 08:32:00 | AAPL | Stock | 2.0464 | 2.0464 | 2.0464 | 2.0464 | 71540.0 |
| 2006-06-28 08:33:00 | AAPL | Stock | 2.0464 | 2.0464 | 2.0446 | 2.0464 | 74060.0 |
| 2006-06-28 08:34:00 | AAPL | Stock | 2.0446 | 2.0493 | 2.0446 | 2.0446 | 58800.0 |
| 2006-06-28 08:36:00 | AAPL | Stock | 2.0454 | 2.0454 | 2.045 | 2.045 | 26460.0 |
| 2006-06-28 08:38:00 | AAPL | Stock | 2.0454 | 2.0482 | 2.0454 | 2.0482 | 34300.0 |
| 2006-06-28 08:40:00 | AAPL | Stock | 2.0514 | 2.0514 | 2.0482 | 2.0482 | 16100.0 |
| 2006-06-28 08:41:00 | AAPL | Stock | 2.0464 | 2.0464 | 2.0464 | 2.0464 | 42700.0 |
| 2006-06-28 08:44:00 | AAPL | Stock | 2.0475 | 2.0475 | 2.0475 | 2.0475 | 2800.0 |
| 2006-06-28 08:45:00 | AAPL | Stock | 2.0475 | 2.0475 | 2.0475 | 2.0475 | 28000.0 |
| 2006-06-28 08:46:00 | AAPL | Stock | 2.0471 | 2.0471 | 2.0471 | 2.0471 | 53172.0 |
| 2006-06-28 08:47:00 | AAPL | Stock | 2.0471 | 2.0471 | 2.0471 | 2.0471 | 75600.0 |
| 2006-06-28 08:48:00 | AAPL | Stock | 2.0454 | 2.0454 | 2.045 | 2.0454 | 56000.0 |
| 2006-06-28 08:49:00 | AAPL | Stock | 2.045 | 2.045 | 2.0432 | 2.0432 | 102900.0 |
| 2006-06-28 08:50:00 | AAPL | Stock | 2.0432 | 2.0439 | 2.04 | 2.04 | 319592.0 |
| 2006-06-28 08:51:00 | AAPL | Stock | 2.0429 | 2.0429 | 2.0411 | 2.0425 | 66360.0 |
| 2006-06-28 08:52:00 | AAPL | Stock | 2.0425 | 2.0425 | 2.0411 | 2.0411 | 42000.0 |
| 2006-06-28 08:53:00 | AAPL | Stock | 2.0429 | 2.0446 | 2.0429 | 2.0429 | 163660.0 |
| 2006-06-28 08:54:00 | AAPL | Stock | 2.0429 | 2.0439 | 2.0429 | 2.0429 | 100016.0 |
| 2006-06-28 08:55:00 | AAPL | Stock | 2.0439 | 2.0457 | 2.0432 | 2.0432 | 154000.0 |
| 2006-06-28 08:56:00 | AAPL | Stock | 2.0446 | 2.045 | 2.0436 | 2.045 | 198800.0 |
| 2006-06-28 08:57:00 | AAPL | Stock | 2.045 | 2.0471 | 2.045 | 2.0464 | 334572.0 |
| 2006-06-28 08:58:00 | AAPL | Stock | 2.0468 | 2.0468 | 2.0464 | 2.0468 | 44800.0 |
| 2006-06-28 08:59:00 | AAPL | Stock | 2.0454 | 2.0464 | 2.045 | 2.0464 | 19040.0 |
> showing 50 of 682,753 rows — these rows as CSV