PREVIEW / stock_1min / 2004-08-17
file: by_date/stock_1min/2004/2004-08-17.parquet size: 5.7 MB rows: 482,808 symbols: 1,501
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 |
|---|---|---|---|---|---|---|---|
| 2004-08-17 08:01:00 | AAPL | Stock | 0.5505 | 0.5505 | 0.5505 | 0.5505 | 11200.0 |
| 2004-08-17 08:06:00 | AAPL | Stock | 0.5505 | 0.5505 | 0.5505 | 0.5505 | 296800.0 |
| 2004-08-17 08:07:00 | AAPL | Stock | 0.5505 | 0.5505 | 0.5505 | 0.5505 | 240800.0 |
| 2004-08-17 08:08:00 | AAPL | Stock | 0.5505 | 0.5505 | 0.5505 | 0.5505 | 233800.0 |
| 2004-08-17 08:21:00 | AAPL | Stock | 0.55 | 0.55 | 0.55 | 0.55 | 11200.0 |
| 2004-08-17 08:22:00 | AAPL | Stock | 0.5504 | 0.5504 | 0.5504 | 0.5504 | 44800.0 |
| 2004-08-17 08:26:00 | AAPL | Stock | 0.5505 | 0.5505 | 0.5504 | 0.5504 | 78400.0 |
| 2004-08-17 08:30:00 | AAPL | Stock | 0.5504 | 0.5505 | 0.5504 | 0.5505 | 280000.0 |
| 2004-08-17 08:31:00 | AAPL | Stock | 0.5505 | 0.5505 | 0.5505 | 0.5505 | 231000.0 |
| 2004-08-17 08:35:00 | AAPL | Stock | 0.5511 | 0.5513 | 0.5511 | 0.5513 | 140000.0 |
| 2004-08-17 08:38:00 | AAPL | Stock | 0.5511 | 0.5511 | 0.5511 | 0.5511 | 5600.0 |
| 2004-08-17 08:40:00 | AAPL | Stock | 0.55 | 0.55 | 0.55 | 0.55 | 69720.0 |
| 2004-08-17 08:42:00 | AAPL | Stock | 0.5509 | 0.5509 | 0.5509 | 0.5509 | 56000.0 |
| 2004-08-17 08:43:00 | AAPL | Stock | 0.5505 | 0.5507 | 0.5505 | 0.5507 | 145600.0 |
| 2004-08-17 08:44:00 | AAPL | Stock | 0.5507 | 0.5507 | 0.5507 | 0.5507 | 112000.0 |
| 2004-08-17 08:48:00 | AAPL | Stock | 0.5507 | 0.5507 | 0.5505 | 0.5505 | 280000.0 |
| 2004-08-17 08:52:00 | AAPL | Stock | 0.5496 | 0.5496 | 0.5495 | 0.5495 | 22400.0 |
| 2004-08-17 08:55:00 | AAPL | Stock | 0.5498 | 0.5498 | 0.5498 | 0.5498 | 145600.0 |
| 2004-08-17 09:01:00 | AAPL | Stock | 0.5488 | 0.5488 | 0.5488 | 0.5488 | 61600.0 |
| 2004-08-17 09:05:00 | AAPL | Stock | 0.5482 | 0.5488 | 0.5482 | 0.5488 | 319200.0 |
| 2004-08-17 09:06:00 | AAPL | Stock | 0.5495 | 0.5495 | 0.5495 | 0.5495 | 112000.0 |
| 2004-08-17 09:07:00 | AAPL | Stock | 0.5495 | 0.5495 | 0.5495 | 0.5495 | 5600.0 |
| 2004-08-17 09:10:00 | AAPL | Stock | 0.5495 | 0.5495 | 0.5495 | 0.5495 | 11200.0 |
| 2004-08-17 09:11:00 | AAPL | Stock | 0.5489 | 0.5489 | 0.5489 | 0.5489 | 72800.0 |
| 2004-08-17 09:12:00 | AAPL | Stock | 0.5496 | 0.5496 | 0.5496 | 0.5496 | 16800.0 |
| 2004-08-17 09:13:00 | AAPL | Stock | 0.55 | 0.55 | 0.55 | 0.55 | 280000.0 |
| 2004-08-17 09:14:00 | AAPL | Stock | 0.5496 | 0.5496 | 0.5496 | 0.5496 | 156800.0 |
| 2004-08-17 09:18:00 | AAPL | Stock | 0.5496 | 0.5496 | 0.5496 | 0.5496 | 22400.0 |
| 2004-08-17 09:19:00 | AAPL | Stock | 0.5504 | 0.5504 | 0.55 | 0.55 | 285600.0 |
| 2004-08-17 09:20:00 | AAPL | Stock | 0.5496 | 0.5496 | 0.5496 | 0.5496 | 22400.0 |
| 2004-08-17 09:22:00 | AAPL | Stock | 0.5496 | 0.5496 | 0.5496 | 0.5496 | 112000.0 |
| 2004-08-17 09:23:00 | AAPL | Stock | 0.5496 | 0.5496 | 0.5496 | 0.5496 | 53592.0 |
| 2004-08-17 09:26:00 | AAPL | Stock | 0.5496 | 0.5496 | 0.5496 | 0.5496 | 56000.0 |
| 2004-08-17 09:27:00 | AAPL | Stock | 0.5493 | 0.5493 | 0.5491 | 0.5491 | 599200.0 |
| 2004-08-17 09:28:00 | AAPL | Stock | 0.5491 | 0.5491 | 0.5491 | 0.5491 | 39200.0 |
| 2004-08-17 09:29:00 | AAPL | Stock | 0.548 | 0.5496 | 0.5464 | 0.5464 | 425600.0 |
| 2004-08-17 09:30:00 | AAPL | Stock | 0.5464 | 0.5491 | 0.545 | 0.5482 | 5014968.0 |
| 2004-08-17 09:31:00 | AAPL | Stock | 0.5477 | 0.548 | 0.5459 | 0.5464 | 1932000.0 |
| 2004-08-17 09:32:00 | AAPL | Stock | 0.5463 | 0.5464 | 0.5432 | 0.5432 | 2172912.0 |
| 2004-08-17 09:33:00 | AAPL | Stock | 0.5432 | 0.5445 | 0.5427 | 0.5438 | 2582720.0 |
| 2004-08-17 09:34:00 | AAPL | Stock | 0.5439 | 0.5439 | 0.542 | 0.5429 | 3169712.0 |
| 2004-08-17 09:35:00 | AAPL | Stock | 0.543 | 0.5436 | 0.5425 | 0.5436 | 3229520.0 |
| 2004-08-17 09:36:00 | AAPL | Stock | 0.5439 | 0.5486 | 0.5436 | 0.5486 | 2934288.0 |
| 2004-08-17 09:37:00 | AAPL | Stock | 0.5486 | 0.5493 | 0.5459 | 0.5459 | 1521632.0 |
| 2004-08-17 09:38:00 | AAPL | Stock | 0.5459 | 0.5488 | 0.5459 | 0.5475 | 1540000.0 |
| 2004-08-17 09:39:00 | AAPL | Stock | 0.5477 | 0.5477 | 0.5457 | 0.5457 | 972216.0 |
| 2004-08-17 09:40:00 | AAPL | Stock | 0.5452 | 0.5468 | 0.545 | 0.5466 | 957376.0 |
| 2004-08-17 09:41:00 | AAPL | Stock | 0.5463 | 0.5463 | 0.5448 | 0.5455 | 1304968.0 |
| 2004-08-17 09:42:00 | AAPL | Stock | 0.5454 | 0.5459 | 0.5438 | 0.5454 | 1754144.0 |
| 2004-08-17 09:43:00 | AAPL | Stock | 0.5452 | 0.5461 | 0.543 | 0.5436 | 2094232.0 |
> showing 50 of 482,808 rows — these rows as CSV