PREVIEW / stock_1min / 2004-08-16
file: by_date/stock_1min/2004/2004-08-16.parquet size: 5.7 MB rows: 481,487 symbols: 1,491
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-16 08:55:00 | AAPL | Stock | 0.5509 | 0.5509 | 0.5509 | 0.5509 | 212800.0 |
| 2004-08-16 09:08:00 | AAPL | Stock | 0.5511 | 0.5511 | 0.5511 | 0.5511 | 11200.0 |
| 2004-08-16 09:24:00 | AAPL | Stock | 0.5509 | 0.5509 | 0.5509 | 0.5509 | 56000.0 |
| 2004-08-16 09:27:00 | AAPL | Stock | 0.5509 | 0.5509 | 0.5509 | 0.5509 | 56000.0 |
| 2004-08-16 09:29:00 | AAPL | Stock | 0.5511 | 0.5536 | 0.5511 | 0.5536 | 470400.0 |
| 2004-08-16 09:30:00 | AAPL | Stock | 0.5514 | 0.5536 | 0.5507 | 0.5518 | 2410576.0 |
| 2004-08-16 09:31:00 | AAPL | Stock | 0.5527 | 0.553 | 0.552 | 0.552 | 414792.0 |
| 2004-08-16 09:32:00 | AAPL | Stock | 0.5523 | 0.5527 | 0.5514 | 0.5527 | 294616.0 |
| 2004-08-16 09:33:00 | AAPL | Stock | 0.5527 | 0.5527 | 0.5523 | 0.5525 | 515200.0 |
| 2004-08-16 09:34:00 | AAPL | Stock | 0.5527 | 0.5527 | 0.5525 | 0.5527 | 259168.0 |
| 2004-08-16 09:35:00 | AAPL | Stock | 0.5525 | 0.5527 | 0.5511 | 0.5513 | 417032.0 |
| 2004-08-16 09:36:00 | AAPL | Stock | 0.5513 | 0.5523 | 0.5513 | 0.5522 | 560000.0 |
| 2004-08-16 09:37:00 | AAPL | Stock | 0.5523 | 0.5527 | 0.5521 | 0.5525 | 280952.0 |
| 2004-08-16 09:38:00 | AAPL | Stock | 0.5525 | 0.5538 | 0.5523 | 0.5538 | 1581664.0 |
| 2004-08-16 09:39:00 | AAPL | Stock | 0.5536 | 0.5538 | 0.5514 | 0.5514 | 1878800.0 |
| 2004-08-16 09:40:00 | AAPL | Stock | 0.5511 | 0.5548 | 0.5511 | 0.5543 | 990808.0 |
| 2004-08-16 09:41:00 | AAPL | Stock | 0.5548 | 0.5548 | 0.5538 | 0.5541 | 487536.0 |
| 2004-08-16 09:42:00 | AAPL | Stock | 0.5545 | 0.5554 | 0.5545 | 0.5552 | 247296.0 |
| 2004-08-16 09:43:00 | AAPL | Stock | 0.5552 | 0.5554 | 0.5546 | 0.5548 | 1911560.0 |
| 2004-08-16 09:44:00 | AAPL | Stock | 0.5552 | 0.5579 | 0.555 | 0.5571 | 2298296.0 |
| 2004-08-16 09:45:00 | AAPL | Stock | 0.5571 | 0.558 | 0.5571 | 0.5579 | 1451744.0 |
| 2004-08-16 09:46:00 | AAPL | Stock | 0.5577 | 0.5589 | 0.557 | 0.5588 | 928200.0 |
| 2004-08-16 09:47:00 | AAPL | Stock | 0.5588 | 0.5593 | 0.5586 | 0.5591 | 1061592.0 |
| 2004-08-16 09:48:00 | AAPL | Stock | 0.5588 | 0.5595 | 0.5588 | 0.5595 | 583632.0 |
| 2004-08-16 09:49:00 | AAPL | Stock | 0.5593 | 0.5604 | 0.5593 | 0.5604 | 1327200.0 |
| 2004-08-16 09:50:00 | AAPL | Stock | 0.5604 | 0.5611 | 0.5596 | 0.5604 | 1921248.0 |
| 2004-08-16 09:51:00 | AAPL | Stock | 0.5602 | 0.5605 | 0.5589 | 0.5591 | 2040304.0 |
| 2004-08-16 09:52:00 | AAPL | Stock | 0.5593 | 0.5596 | 0.5591 | 0.5591 | 906248.0 |
| 2004-08-16 09:53:00 | AAPL | Stock | 0.5593 | 0.5593 | 0.5589 | 0.5589 | 357168.0 |
| 2004-08-16 09:54:00 | AAPL | Stock | 0.5593 | 0.5602 | 0.5591 | 0.5599 | 733880.0 |
| 2004-08-16 09:55:00 | AAPL | Stock | 0.56 | 0.5604 | 0.56 | 0.5602 | 527408.0 |
| 2004-08-16 09:56:00 | AAPL | Stock | 0.5604 | 0.5604 | 0.5598 | 0.5598 | 392000.0 |
| 2004-08-16 09:57:00 | AAPL | Stock | 0.56 | 0.56 | 0.5586 | 0.5586 | 1374800.0 |
| 2004-08-16 09:58:00 | AAPL | Stock | 0.5584 | 0.5602 | 0.5584 | 0.5602 | 505568.0 |
| 2004-08-16 09:59:00 | AAPL | Stock | 0.5602 | 0.5602 | 0.5588 | 0.5589 | 520800.0 |
| 2004-08-16 10:00:00 | AAPL | Stock | 0.5589 | 0.5595 | 0.5586 | 0.5595 | 889280.0 |
| 2004-08-16 10:01:00 | AAPL | Stock | 0.5586 | 0.5598 | 0.5584 | 0.5584 | 802032.0 |
| 2004-08-16 10:02:00 | AAPL | Stock | 0.5584 | 0.5588 | 0.5573 | 0.5575 | 2133096.0 |
| 2004-08-16 10:03:00 | AAPL | Stock | 0.5575 | 0.558 | 0.5571 | 0.5577 | 3536456.0 |
| 2004-08-16 10:04:00 | AAPL | Stock | 0.5579 | 0.5595 | 0.5579 | 0.5595 | 3901800.0 |
| 2004-08-16 10:05:00 | AAPL | Stock | 0.5596 | 0.5596 | 0.5588 | 0.5588 | 1058400.0 |
| 2004-08-16 10:06:00 | AAPL | Stock | 0.5589 | 0.5595 | 0.5589 | 0.5591 | 1344000.0 |
| 2004-08-16 10:07:00 | AAPL | Stock | 0.5593 | 0.5593 | 0.5591 | 0.5591 | 101360.0 |
| 2004-08-16 10:08:00 | AAPL | Stock | 0.5591 | 0.5607 | 0.5591 | 0.5607 | 687960.0 |
| 2004-08-16 10:09:00 | AAPL | Stock | 0.5607 | 0.5616 | 0.5607 | 0.5616 | 1758848.0 |
| 2004-08-16 10:10:00 | AAPL | Stock | 0.5616 | 0.5616 | 0.5607 | 0.5613 | 666400.0 |
| 2004-08-16 10:11:00 | AAPL | Stock | 0.5611 | 0.5613 | 0.5607 | 0.5607 | 1628592.0 |
| 2004-08-16 10:12:00 | AAPL | Stock | 0.5609 | 0.5618 | 0.5609 | 0.5618 | 1317232.0 |
| 2004-08-16 10:13:00 | AAPL | Stock | 0.5614 | 0.5627 | 0.5614 | 0.5625 | 1304408.0 |
| 2004-08-16 10:14:00 | AAPL | Stock | 0.5625 | 0.563 | 0.5623 | 0.5629 | 611744.0 |
> showing 50 of 481,487 rows — these rows as CSV