PREVIEW / stock_1min / 2008-02-06
file: by_date/stock_1min/2008/2008-02-06.parquet size: 12.5 MB rows: 1,012,252 symbols: 2,653
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-06 05:34:00 | AAPL | Stock | 4.6357 | 4.6357 | 4.6357 | 4.6357 | 8400.0 |
| 2008-02-06 05:43:00 | AAPL | Stock | 4.6357 | 4.6357 | 4.6357 | 4.6357 | 2800.0 |
| 2008-02-06 06:08:00 | AAPL | Stock | 4.6396 | 4.6396 | 4.6396 | 4.6396 | 19600.0 |
| 2008-02-06 06:53:00 | AAPL | Stock | 4.6429 | 4.6429 | 4.6429 | 4.6429 | 8400.0 |
| 2008-02-06 07:21:00 | AAPL | Stock | 4.6518 | 4.6554 | 4.6518 | 4.6554 | 14000.0 |
| 2008-02-06 07:22:00 | AAPL | Stock | 4.6554 | 4.6554 | 4.6554 | 4.6554 | 11200.0 |
| 2008-02-06 07:23:00 | AAPL | Stock | 4.6554 | 4.6554 | 4.6554 | 4.6554 | 2800.0 |
| 2008-02-06 07:24:00 | AAPL | Stock | 4.6554 | 4.6771 | 4.6554 | 4.6771 | 77000.0 |
| 2008-02-06 07:26:00 | AAPL | Stock | 4.6696 | 4.6696 | 4.6696 | 4.6696 | 19600.0 |
| 2008-02-06 07:27:00 | AAPL | Stock | 4.6696 | 4.6696 | 4.6643 | 4.6643 | 35700.0 |
| 2008-02-06 07:28:00 | AAPL | Stock | 4.6643 | 4.6643 | 4.6643 | 4.6643 | 51800.0 |
| 2008-02-06 07:32:00 | AAPL | Stock | 4.6696 | 4.6721 | 4.6696 | 4.6721 | 16800.0 |
| 2008-02-06 07:34:00 | AAPL | Stock | 4.6646 | 4.6646 | 4.6643 | 4.6643 | 19600.0 |
| 2008-02-06 07:36:00 | AAPL | Stock | 4.6725 | 4.6786 | 4.6725 | 4.6764 | 55440.0 |
| 2008-02-06 07:43:00 | AAPL | Stock | 4.6621 | 4.6621 | 4.6621 | 4.6621 | 11200.0 |
| 2008-02-06 07:44:00 | AAPL | Stock | 4.6621 | 4.6621 | 4.6614 | 4.6614 | 7252.0 |
| 2008-02-06 07:46:00 | AAPL | Stock | 4.6621 | 4.6621 | 4.6621 | 4.6621 | 14000.0 |
| 2008-02-06 07:57:00 | AAPL | Stock | 4.6725 | 4.6743 | 4.6725 | 4.6743 | 16800.0 |
| 2008-02-06 08:00:00 | AAPL | Stock | 4.665 | 4.6729 | 4.6582 | 4.6611 | 318108.0 |
| 2008-02-06 08:01:00 | AAPL | Stock | 4.6625 | 4.67 | 4.6618 | 4.6625 | 64400.0 |
| 2008-02-06 08:02:00 | AAPL | Stock | 4.6721 | 4.6721 | 4.6607 | 4.6607 | 45500.0 |
| 2008-02-06 08:03:00 | AAPL | Stock | 4.6607 | 4.6643 | 4.6607 | 4.6607 | 29820.0 |
| 2008-02-06 08:04:00 | AAPL | Stock | 4.6643 | 4.6643 | 4.6643 | 4.6643 | 14000.0 |
| 2008-02-06 08:05:00 | AAPL | Stock | 4.6571 | 4.6607 | 4.6536 | 4.6607 | 29400.0 |
| 2008-02-06 08:06:00 | AAPL | Stock | 4.6539 | 4.6539 | 4.6536 | 4.6536 | 28000.0 |
| 2008-02-06 08:07:00 | AAPL | Stock | 4.6604 | 4.6607 | 4.6543 | 4.6543 | 25900.0 |
| 2008-02-06 08:08:00 | AAPL | Stock | 4.6543 | 4.6589 | 4.6504 | 4.6586 | 73360.0 |
| 2008-02-06 08:09:00 | AAPL | Stock | 4.6539 | 4.6539 | 4.6504 | 4.6504 | 22400.0 |
| 2008-02-06 08:10:00 | AAPL | Stock | 4.6464 | 4.65 | 4.6432 | 4.65 | 64820.0 |
| 2008-02-06 08:11:00 | AAPL | Stock | 4.6514 | 4.6514 | 4.6432 | 4.6432 | 194880.0 |
| 2008-02-06 08:12:00 | AAPL | Stock | 4.6493 | 4.65 | 4.6432 | 4.6432 | 43680.0 |
| 2008-02-06 08:13:00 | AAPL | Stock | 4.6464 | 4.6464 | 4.6461 | 4.6461 | 39200.0 |
| 2008-02-06 08:14:00 | AAPL | Stock | 4.6461 | 4.6461 | 4.6461 | 4.6461 | 8400.0 |
| 2008-02-06 08:16:00 | AAPL | Stock | 4.6482 | 4.65 | 4.6446 | 4.6446 | 24780.0 |
| 2008-02-06 08:19:00 | AAPL | Stock | 4.645 | 4.6464 | 4.6446 | 4.6446 | 40040.0 |
| 2008-02-06 08:20:00 | AAPL | Stock | 4.6496 | 4.65 | 4.6496 | 4.6496 | 48300.0 |
| 2008-02-06 08:23:00 | AAPL | Stock | 4.6468 | 4.6482 | 4.6446 | 4.6446 | 58016.0 |
| 2008-02-06 08:24:00 | AAPL | Stock | 4.6432 | 4.6432 | 4.6396 | 4.6429 | 196616.0 |
| 2008-02-06 08:25:00 | AAPL | Stock | 4.6393 | 4.6393 | 4.6339 | 4.6361 | 69608.0 |
| 2008-02-06 08:26:00 | AAPL | Stock | 4.6364 | 4.6446 | 4.6364 | 4.6446 | 58800.0 |
| 2008-02-06 08:27:00 | AAPL | Stock | 4.6461 | 4.6464 | 4.6461 | 4.6464 | 28000.0 |
| 2008-02-06 08:28:00 | AAPL | Stock | 4.6471 | 4.6471 | 4.6393 | 4.6393 | 127400.0 |
| 2008-02-06 08:29:00 | AAPL | Stock | 4.6418 | 4.6429 | 4.6418 | 4.6425 | 22400.0 |
| 2008-02-06 08:30:00 | AAPL | Stock | 4.6482 | 4.6518 | 4.6482 | 4.6518 | 144116.0 |
| 2008-02-06 08:31:00 | AAPL | Stock | 4.6514 | 4.6514 | 4.6471 | 4.6471 | 11200.0 |
| 2008-02-06 08:32:00 | AAPL | Stock | 4.6511 | 4.6557 | 4.6511 | 4.6536 | 170800.0 |
| 2008-02-06 08:33:00 | AAPL | Stock | 4.6532 | 4.6554 | 4.6532 | 4.6554 | 50400.0 |
| 2008-02-06 08:34:00 | AAPL | Stock | 4.6586 | 4.6586 | 4.655 | 4.6586 | 63700.0 |
| 2008-02-06 08:35:00 | AAPL | Stock | 4.6571 | 4.6571 | 4.6554 | 4.6571 | 53984.0 |
| 2008-02-06 08:37:00 | AAPL | Stock | 4.6564 | 4.6607 | 4.6564 | 4.6589 | 54544.0 |
> showing 50 of 1,012,252 rows — these rows as CSV