PREVIEW / stock_1min / 2008-02-14
file: by_date/stock_1min/2008/2008-02-14.parquet size: 12.5 MB rows: 1,017,763 symbols: 2,634
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 |
|---|---|---|---|---|---|---|---|
| 2008-02-14 04:24:00 | AAPL | Stock | 4.6621 | 4.6621 | 4.6621 | 4.6621 | 2800.0 |
| 2008-02-14 05:12:00 | AAPL | Stock | 4.6621 | 4.6621 | 4.6621 | 4.6621 | 2800.0 |
| 2008-02-14 05:35:00 | AAPL | Stock | 4.6607 | 4.6607 | 4.6607 | 4.6607 | 8400.0 |
| 2008-02-14 05:36:00 | AAPL | Stock | 4.6607 | 4.6607 | 4.6607 | 4.6607 | 5600.0 |
| 2008-02-14 05:41:00 | AAPL | Stock | 4.6607 | 4.6607 | 4.6607 | 4.6607 | 2800.0 |
| 2008-02-14 05:54:00 | AAPL | Stock | 4.6607 | 4.6607 | 4.6543 | 4.6543 | 11200.0 |
| 2008-02-14 06:00:00 | AAPL | Stock | 4.6432 | 4.6432 | 4.6432 | 4.6432 | 8400.0 |
| 2008-02-14 06:09:00 | AAPL | Stock | 4.6593 | 4.6593 | 4.6593 | 4.6593 | 2800.0 |
| 2008-02-14 06:11:00 | AAPL | Stock | 4.6464 | 4.6464 | 4.6443 | 4.6443 | 14000.0 |
| 2008-02-14 06:17:00 | AAPL | Stock | 4.6475 | 4.6475 | 4.6464 | 4.6464 | 11200.0 |
| 2008-02-14 06:39:00 | AAPL | Stock | 4.6464 | 4.6464 | 4.645 | 4.645 | 11676.0 |
| 2008-02-14 06:50:00 | AAPL | Stock | 4.6429 | 4.6429 | 4.6429 | 4.6429 | 5124.0 |
| 2008-02-14 07:04:00 | AAPL | Stock | 4.6436 | 4.6436 | 4.6436 | 4.6436 | 2800.0 |
| 2008-02-14 07:25:00 | AAPL | Stock | 4.66 | 4.66 | 4.66 | 4.66 | 5600.0 |
| 2008-02-14 07:27:00 | AAPL | Stock | 4.66 | 4.66 | 4.66 | 4.66 | 11200.0 |
| 2008-02-14 07:30:00 | AAPL | Stock | 4.6607 | 4.6607 | 4.6607 | 4.6607 | 2800.0 |
| 2008-02-14 07:32:00 | AAPL | Stock | 4.6571 | 4.6571 | 4.6571 | 4.6571 | 15680.0 |
| 2008-02-14 07:34:00 | AAPL | Stock | 4.6539 | 4.6539 | 4.6518 | 4.6536 | 45360.0 |
| 2008-02-14 07:36:00 | AAPL | Stock | 4.6489 | 4.6489 | 4.6489 | 4.6489 | 8400.0 |
| 2008-02-14 07:38:00 | AAPL | Stock | 4.6536 | 4.6536 | 4.6536 | 4.6536 | 2800.0 |
| 2008-02-14 07:44:00 | AAPL | Stock | 4.6525 | 4.6525 | 4.65 | 4.65 | 19600.0 |
| 2008-02-14 07:45:00 | AAPL | Stock | 4.6525 | 4.6525 | 4.6525 | 4.6525 | 5600.0 |
| 2008-02-14 07:47:00 | AAPL | Stock | 4.6504 | 4.6582 | 4.65 | 4.6582 | 16800.0 |
| 2008-02-14 07:52:00 | AAPL | Stock | 4.6464 | 4.6464 | 4.6454 | 4.6464 | 16800.0 |
| 2008-02-14 07:56:00 | AAPL | Stock | 4.6482 | 4.6482 | 4.6482 | 4.6482 | 14000.0 |
| 2008-02-14 07:57:00 | AAPL | Stock | 4.6482 | 4.6482 | 4.6482 | 4.6482 | 2800.0 |
| 2008-02-14 07:58:00 | AAPL | Stock | 4.6482 | 4.6482 | 4.6482 | 4.6482 | 11200.0 |
| 2008-02-14 08:00:00 | AAPL | Stock | 4.6464 | 4.6564 | 4.6432 | 4.6482 | 204372.0 |
| 2008-02-14 08:01:00 | AAPL | Stock | 4.6446 | 4.6482 | 4.6429 | 4.6429 | 33320.0 |
| 2008-02-14 08:02:00 | AAPL | Stock | 4.6471 | 4.6471 | 4.6393 | 4.6393 | 28000.0 |
| 2008-02-14 08:03:00 | AAPL | Stock | 4.6393 | 4.6429 | 4.6389 | 4.6429 | 45612.0 |
| 2008-02-14 08:05:00 | AAPL | Stock | 4.6425 | 4.6429 | 4.6425 | 4.6429 | 40684.0 |
| 2008-02-14 08:06:00 | AAPL | Stock | 4.6429 | 4.6432 | 4.6425 | 4.6425 | 19320.0 |
| 2008-02-14 08:07:00 | AAPL | Stock | 4.645 | 4.645 | 4.645 | 4.645 | 5600.0 |
| 2008-02-14 08:08:00 | AAPL | Stock | 4.6464 | 4.6482 | 4.6464 | 4.6482 | 41580.0 |
| 2008-02-14 08:09:00 | AAPL | Stock | 4.6489 | 4.6496 | 4.6461 | 4.6461 | 30800.0 |
| 2008-02-14 08:10:00 | AAPL | Stock | 4.6461 | 4.6461 | 4.6461 | 4.6461 | 2800.0 |
| 2008-02-14 08:11:00 | AAPL | Stock | 4.6454 | 4.6454 | 4.6429 | 4.6429 | 44072.0 |
| 2008-02-14 08:12:00 | AAPL | Stock | 4.6429 | 4.6429 | 4.6325 | 4.6325 | 64400.0 |
| 2008-02-14 08:13:00 | AAPL | Stock | 4.6354 | 4.6357 | 4.6339 | 4.6357 | 61600.0 |
| 2008-02-14 08:14:00 | AAPL | Stock | 4.6357 | 4.6386 | 4.6357 | 4.6386 | 16800.0 |
| 2008-02-14 08:15:00 | AAPL | Stock | 4.6386 | 4.6386 | 4.6386 | 4.6386 | 9800.0 |
| 2008-02-14 08:16:00 | AAPL | Stock | 4.6396 | 4.6436 | 4.6396 | 4.6429 | 134064.0 |
| 2008-02-14 08:17:00 | AAPL | Stock | 4.645 | 4.645 | 4.6429 | 4.6443 | 57400.0 |
| 2008-02-14 08:18:00 | AAPL | Stock | 4.6429 | 4.6443 | 4.6425 | 4.6429 | 140000.0 |
| 2008-02-14 08:19:00 | AAPL | Stock | 4.6429 | 4.6429 | 4.6411 | 4.6411 | 22960.0 |
| 2008-02-14 08:20:00 | AAPL | Stock | 4.6429 | 4.6432 | 4.6429 | 4.6432 | 33712.0 |
| 2008-02-14 08:21:00 | AAPL | Stock | 4.6429 | 4.6443 | 4.6429 | 4.6443 | 33600.0 |
| 2008-02-14 08:22:00 | AAPL | Stock | 4.6432 | 4.645 | 4.6432 | 4.645 | 22400.0 |
| 2008-02-14 08:23:00 | AAPL | Stock | 4.645 | 4.6479 | 4.6446 | 4.6475 | 11620.0 |
> showing 50 of 1,017,763 rows — these rows as CSV