PREVIEW / stock_5min / 2007-07-12
file: by_date/stock_5min/2007/2007-07-12.parquet size: 4.0 MB rows: 295,690 symbols: 3,066
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-07-12 09:30:00 | AAPL | Stock | 4.7804 | 4.7943 | 4.7614 | 4.7811 | 46491284.0 |
| 2007-07-12 09:35:00 | AAPL | Stock | 4.7832 | 4.7871 | 4.7671 | 4.7743 | 24093804.0 |
| 2007-07-12 09:40:00 | AAPL | Stock | 4.7743 | 4.7839 | 4.7714 | 4.7804 | 23394112.0 |
| 2007-07-12 09:45:00 | AAPL | Stock | 4.7807 | 4.7929 | 4.7729 | 4.7782 | 26915644.0 |
| 2007-07-12 09:50:00 | AAPL | Stock | 4.7782 | 4.7786 | 4.75 | 4.75 | 30477412.0 |
| 2007-07-12 09:55:00 | AAPL | Stock | 4.75 | 4.7679 | 4.75 | 4.7589 | 14350644.0 |
| 2007-07-12 10:00:00 | AAPL | Stock | 4.7586 | 4.7714 | 4.7571 | 4.77 | 11158812.0 |
| 2007-07-12 10:05:00 | AAPL | Stock | 4.7704 | 4.7779 | 4.7582 | 4.7618 | 15233008.0 |
| 2007-07-12 10:10:00 | AAPL | Stock | 4.7618 | 4.7661 | 4.7582 | 4.7625 | 6555360.0 |
| 2007-07-12 10:15:00 | AAPL | Stock | 4.7629 | 4.7679 | 4.7607 | 4.7657 | 5595296.0 |
| 2007-07-12 10:20:00 | AAPL | Stock | 4.7654 | 4.7704 | 4.7593 | 4.7632 | 8997548.0 |
| 2007-07-12 10:25:00 | AAPL | Stock | 4.7632 | 4.7643 | 4.7521 | 4.7543 | 10312008.0 |
| 2007-07-12 10:30:00 | AAPL | Stock | 4.7536 | 4.7632 | 4.7454 | 4.7482 | 15792000.0 |
| 2007-07-12 10:35:00 | AAPL | Stock | 4.7482 | 4.7536 | 4.7429 | 4.7511 | 13881476.0 |
| 2007-07-12 10:40:00 | AAPL | Stock | 4.7511 | 4.753 | 4.745 | 4.7468 | 6358016.0 |
| 2007-07-12 10:45:00 | AAPL | Stock | 4.7471 | 4.7593 | 4.7468 | 4.7543 | 8091020.0 |
| 2007-07-12 10:50:00 | AAPL | Stock | 4.7543 | 4.7643 | 4.7539 | 4.7632 | 8479884.0 |
| 2007-07-12 10:55:00 | AAPL | Stock | 4.7636 | 4.7654 | 4.7554 | 4.7579 | 5858356.0 |
| 2007-07-12 11:00:00 | AAPL | Stock | 4.7575 | 4.7625 | 4.7518 | 4.7557 | 4556692.0 |
| 2007-07-12 11:05:00 | AAPL | Stock | 4.7554 | 4.7607 | 4.75 | 4.7593 | 4451104.0 |
| 2007-07-12 11:10:00 | AAPL | Stock | 4.7596 | 4.7629 | 4.7561 | 4.7604 | 4095336.0 |
| 2007-07-12 11:15:00 | AAPL | Stock | 4.7607 | 4.7661 | 4.7582 | 4.7593 | 6788796.0 |
| 2007-07-12 11:20:00 | AAPL | Stock | 4.7593 | 4.7607 | 4.7536 | 4.7568 | 4196276.0 |
| 2007-07-12 11:25:00 | AAPL | Stock | 4.7571 | 4.7582 | 4.7526 | 4.7557 | 3903788.0 |
| 2007-07-12 11:30:00 | AAPL | Stock | 4.7554 | 4.7586 | 4.7282 | 4.7546 | 5501608.0 |
| 2007-07-12 11:35:00 | AAPL | Stock | 4.755 | 4.7639 | 4.7536 | 4.7639 | 6352528.0 |
| 2007-07-12 11:40:00 | AAPL | Stock | 4.7639 | 4.7675 | 4.7625 | 4.7664 | 8988812.0 |
| 2007-07-12 11:45:00 | AAPL | Stock | 4.7664 | 4.7671 | 4.7596 | 4.7611 | 4899860.0 |
| 2007-07-12 11:50:00 | AAPL | Stock | 4.7607 | 4.7618 | 4.7518 | 4.7525 | 5973772.0 |
| 2007-07-12 11:55:00 | AAPL | Stock | 4.7521 | 4.7539 | 4.75 | 4.7523 | 4841060.0 |
| 2007-07-12 12:00:00 | AAPL | Stock | 4.7521 | 4.7607 | 4.7518 | 4.7607 | 4687424.0 |
| 2007-07-12 12:05:00 | AAPL | Stock | 4.7607 | 4.7646 | 4.7546 | 4.7639 | 7594104.0 |
| 2007-07-12 12:10:00 | AAPL | Stock | 4.7643 | 4.7711 | 4.7614 | 4.7686 | 12003992.0 |
| 2007-07-12 12:15:00 | AAPL | Stock | 4.7686 | 4.7704 | 4.7618 | 4.7636 | 6007792.0 |
| 2007-07-12 12:20:00 | AAPL | Stock | 4.7629 | 4.7636 | 4.7589 | 4.7596 | 4212852.0 |
| 2007-07-12 12:25:00 | AAPL | Stock | 4.7596 | 4.7607 | 4.7582 | 4.7602 | 2869972.0 |
| 2007-07-12 12:30:00 | AAPL | Stock | 4.76 | 4.7607 | 4.7521 | 4.7525 | 5762708.0 |
| 2007-07-12 12:35:00 | AAPL | Stock | 4.7522 | 4.7643 | 4.7504 | 4.7518 | 7735868.0 |
| 2007-07-12 12:40:00 | AAPL | Stock | 4.7521 | 4.7561 | 4.7486 | 4.7525 | 8493380.0 |
| 2007-07-12 12:45:00 | AAPL | Stock | 4.7525 | 4.7564 | 4.7511 | 4.7516 | 3696364.0 |
| 2007-07-12 12:50:00 | AAPL | Stock | 4.7514 | 4.7564 | 4.7464 | 4.7489 | 7523040.0 |
| 2007-07-12 12:55:00 | AAPL | Stock | 4.7489 | 4.755 | 4.7489 | 4.7521 | 3919300.0 |
| 2007-07-12 13:00:00 | AAPL | Stock | 4.7525 | 4.7614 | 4.7518 | 4.7536 | 3031924.0 |
| 2007-07-12 13:05:00 | AAPL | Stock | 4.7539 | 4.7557 | 4.7514 | 4.7543 | 3148628.0 |
| 2007-07-12 13:10:00 | AAPL | Stock | 4.7543 | 4.7593 | 4.7539 | 4.7586 | 3247804.0 |
| 2007-07-12 13:15:00 | AAPL | Stock | 4.7586 | 4.7639 | 4.7543 | 4.7557 | 6158852.0 |
| 2007-07-12 13:20:00 | AAPL | Stock | 4.7554 | 4.7596 | 4.7532 | 4.7546 | 2801624.0 |
| 2007-07-12 13:25:00 | AAPL | Stock | 4.755 | 4.7571 | 4.7532 | 4.7554 | 1746528.0 |
| 2007-07-12 13:30:00 | AAPL | Stock | 4.7554 | 4.7586 | 4.7518 | 4.7586 | 2557240.0 |
| 2007-07-12 13:35:00 | AAPL | Stock | 4.7586 | 4.7618 | 4.7546 | 4.7614 | 3224368.0 |
> showing 50 of 295,690 rows — these rows as CSV