PREVIEW / stock_1min / 2007-09-11
file: by_date/stock_1min/2007/2007-09-11.parquet size: 11.0 MB rows: 909,306 symbols: 2,561
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 |
|---|---|---|---|---|---|---|---|
| 2007-09-11 09:30:00 | AAPL | Stock | 4.925 | 4.9371 | 4.9225 | 4.9357 | 10686648.0 |
| 2007-09-11 09:31:00 | AAPL | Stock | 4.9361 | 4.9393 | 4.9179 | 4.9186 | 6311564.0 |
| 2007-09-11 09:32:00 | AAPL | Stock | 4.9186 | 4.9205 | 4.9071 | 4.9137 | 5135172.0 |
| 2007-09-11 09:33:00 | AAPL | Stock | 4.9118 | 4.9154 | 4.897 | 4.8996 | 3954188.0 |
| 2007-09-11 09:34:00 | AAPL | Stock | 4.8989 | 4.9054 | 4.89 | 4.89 | 5081356.0 |
| 2007-09-11 09:35:00 | AAPL | Stock | 4.89 | 4.8936 | 4.8796 | 4.8907 | 7455700.0 |
| 2007-09-11 09:36:00 | AAPL | Stock | 4.8907 | 4.8929 | 4.8686 | 4.8693 | 5917492.0 |
| 2007-09-11 09:37:00 | AAPL | Stock | 4.8693 | 4.8757 | 4.8436 | 4.8561 | 11007136.0 |
| 2007-09-11 09:38:00 | AAPL | Stock | 4.856 | 4.8661 | 4.8486 | 4.8621 | 6710060.0 |
| 2007-09-11 09:39:00 | AAPL | Stock | 4.8621 | 4.8718 | 4.8614 | 4.8668 | 5929728.0 |
| 2007-09-11 09:40:00 | AAPL | Stock | 4.8668 | 4.8764 | 4.8661 | 4.8743 | 5294800.0 |
| 2007-09-11 09:41:00 | AAPL | Stock | 4.8744 | 4.8821 | 4.8728 | 4.8754 | 4929904.0 |
| 2007-09-11 09:42:00 | AAPL | Stock | 4.875 | 4.8857 | 4.8718 | 4.885 | 4103400.0 |
| 2007-09-11 09:43:00 | AAPL | Stock | 4.8846 | 4.8996 | 4.8836 | 4.8974 | 5178796.0 |
| 2007-09-11 09:44:00 | AAPL | Stock | 4.8971 | 4.8982 | 4.8771 | 4.8779 | 5969908.0 |
| 2007-09-11 09:45:00 | AAPL | Stock | 4.8768 | 4.8804 | 4.8636 | 4.8682 | 7900340.0 |
| 2007-09-11 09:46:00 | AAPL | Stock | 4.8686 | 4.8789 | 4.8661 | 4.8675 | 5870564.0 |
| 2007-09-11 09:47:00 | AAPL | Stock | 4.8682 | 4.8686 | 4.8482 | 4.8561 | 8520260.0 |
| 2007-09-11 09:48:00 | AAPL | Stock | 4.8564 | 4.8629 | 4.8518 | 4.8614 | 4756444.0 |
| 2007-09-11 09:49:00 | AAPL | Stock | 4.8618 | 4.8668 | 4.8543 | 4.8571 | 3035396.0 |
| 2007-09-11 09:50:00 | AAPL | Stock | 4.8571 | 4.8639 | 4.8536 | 4.8611 | 2980068.0 |
| 2007-09-11 09:51:00 | AAPL | Stock | 4.8614 | 4.8661 | 4.8554 | 4.8621 | 2870476.0 |
| 2007-09-11 09:52:00 | AAPL | Stock | 4.8629 | 4.8693 | 4.8611 | 4.865 | 2670696.0 |
| 2007-09-11 09:53:00 | AAPL | Stock | 4.8626 | 4.8661 | 4.8507 | 4.8561 | 5261060.0 |
| 2007-09-11 09:54:00 | AAPL | Stock | 4.8561 | 4.8575 | 4.8421 | 4.8446 | 5338004.0 |
| 2007-09-11 09:55:00 | AAPL | Stock | 4.8446 | 4.8639 | 4.8446 | 4.8561 | 4375840.0 |
| 2007-09-11 09:56:00 | AAPL | Stock | 4.8571 | 4.8611 | 4.8529 | 4.8607 | 2993536.0 |
| 2007-09-11 09:57:00 | AAPL | Stock | 4.86 | 4.8614 | 4.8536 | 4.8589 | 2469404.0 |
| 2007-09-11 09:58:00 | AAPL | Stock | 4.8589 | 4.8646 | 4.8589 | 4.8639 | 2567600.0 |
| 2007-09-11 09:59:00 | AAPL | Stock | 4.8644 | 4.8714 | 4.855 | 4.8564 | 4535216.0 |
| 2007-09-11 10:00:00 | AAPL | Stock | 4.8568 | 4.8611 | 4.8504 | 4.8611 | 2745904.0 |
| 2007-09-11 10:01:00 | AAPL | Stock | 4.8611 | 4.8643 | 4.85 | 4.8511 | 3747380.0 |
| 2007-09-11 10:02:00 | AAPL | Stock | 4.8521 | 4.8571 | 4.8514 | 4.8543 | 2272928.0 |
| 2007-09-11 10:03:00 | AAPL | Stock | 4.8543 | 4.8557 | 4.8489 | 4.8525 | 2394672.0 |
| 2007-09-11 10:04:00 | AAPL | Stock | 4.8529 | 4.8554 | 4.8436 | 4.8486 | 3841264.0 |
| 2007-09-11 10:05:00 | AAPL | Stock | 4.8489 | 4.8493 | 4.8393 | 4.8461 | 6032124.0 |
| 2007-09-11 10:06:00 | AAPL | Stock | 4.8464 | 4.85 | 4.8393 | 4.8493 | 3712716.0 |
| 2007-09-11 10:07:00 | AAPL | Stock | 4.8493 | 4.8546 | 4.8468 | 4.8504 | 3950464.0 |
| 2007-09-11 10:08:00 | AAPL | Stock | 4.8507 | 4.8532 | 4.8429 | 4.8479 | 2723924.0 |
| 2007-09-11 10:09:00 | AAPL | Stock | 4.8479 | 4.8482 | 4.8368 | 4.8439 | 4170124.0 |
| 2007-09-11 10:10:00 | AAPL | Stock | 4.8439 | 4.845 | 4.8357 | 4.8386 | 4288648.0 |
| 2007-09-11 10:11:00 | AAPL | Stock | 4.8386 | 4.8454 | 4.8382 | 4.8425 | 3456488.0 |
| 2007-09-11 10:12:00 | AAPL | Stock | 4.8425 | 4.8496 | 4.8407 | 4.8446 | 3470124.0 |
| 2007-09-11 10:13:00 | AAPL | Stock | 4.8443 | 4.8518 | 4.8436 | 4.8454 | 2451120.0 |
| 2007-09-11 10:14:00 | AAPL | Stock | 4.8457 | 4.8596 | 4.8454 | 4.8579 | 5076428.0 |
| 2007-09-11 10:15:00 | AAPL | Stock | 4.8571 | 4.8625 | 4.8514 | 4.8596 | 3588788.0 |
| 2007-09-11 10:16:00 | AAPL | Stock | 4.86 | 4.8679 | 4.8593 | 4.8636 | 4039560.0 |
| 2007-09-11 10:17:00 | AAPL | Stock | 4.8639 | 4.8679 | 4.8593 | 4.8632 | 3338888.0 |
| 2007-09-11 10:18:00 | AAPL | Stock | 4.8636 | 4.8643 | 4.8607 | 4.8639 | 1671936.0 |
| 2007-09-11 10:19:00 | AAPL | Stock | 4.8639 | 4.8661 | 4.8604 | 4.8618 | 2479596.0 |
> showing 50 of 909,306 rows — these rows as CSV