PREVIEW / stock_5min / 2005-09-08
file: by_date/stock_5min/2005/2005-09-08.parquet size: 2.7 MB rows: 199,946 symbols: 2,062
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 |
|---|---|---|---|---|---|---|---|
| 2005-09-08 07:00:00 | AAPL | Stock | 1.7768 | 1.7768 | 1.7768 | 1.7768 | 70000.0 |
| 2005-09-08 07:10:00 | AAPL | Stock | 1.7536 | 1.7571 | 1.7536 | 1.7571 | 112000.0 |
| 2005-09-08 07:20:00 | AAPL | Stock | 1.7589 | 1.7675 | 1.7589 | 1.7675 | 179200.0 |
| 2005-09-08 07:25:00 | AAPL | Stock | 1.7675 | 1.7675 | 1.7675 | 1.7675 | 144900.0 |
| 2005-09-08 07:45:00 | AAPL | Stock | 1.7643 | 1.7643 | 1.7643 | 1.7643 | 56280.0 |
| 2005-09-08 07:50:00 | AAPL | Stock | 1.7611 | 1.7639 | 1.7607 | 1.7639 | 92400.0 |
| 2005-09-08 07:55:00 | AAPL | Stock | 1.7643 | 1.7643 | 1.7643 | 1.7643 | 8400.0 |
| 2005-09-08 08:00:00 | AAPL | Stock | 1.7679 | 1.7679 | 1.7571 | 1.7607 | 1590596.0 |
| 2005-09-08 08:05:00 | AAPL | Stock | 1.7607 | 1.7657 | 1.76 | 1.7607 | 801360.0 |
| 2005-09-08 08:10:00 | AAPL | Stock | 1.7607 | 1.7625 | 1.7589 | 1.7589 | 665420.0 |
| 2005-09-08 08:15:00 | AAPL | Stock | 1.7582 | 1.7582 | 1.755 | 1.7557 | 573160.0 |
| 2005-09-08 08:20:00 | AAPL | Stock | 1.7554 | 1.7564 | 1.7532 | 1.7539 | 334880.0 |
| 2005-09-08 08:25:00 | AAPL | Stock | 1.7539 | 1.7568 | 1.7532 | 1.7554 | 229040.0 |
| 2005-09-08 08:30:00 | AAPL | Stock | 1.7561 | 1.7571 | 1.7554 | 1.7554 | 191100.0 |
| 2005-09-08 08:35:00 | AAPL | Stock | 1.7554 | 1.7554 | 1.7529 | 1.7539 | 113120.0 |
| 2005-09-08 08:40:00 | AAPL | Stock | 1.755 | 1.7571 | 1.7543 | 1.7554 | 309680.0 |
| 2005-09-08 08:45:00 | AAPL | Stock | 1.7557 | 1.76 | 1.7529 | 1.7561 | 642460.0 |
| 2005-09-08 08:50:00 | AAPL | Stock | 1.755 | 1.7579 | 1.7532 | 1.7564 | 181916.0 |
| 2005-09-08 08:55:00 | AAPL | Stock | 1.7568 | 1.7639 | 1.7564 | 1.7632 | 641900.0 |
| 2005-09-08 09:00:00 | AAPL | Stock | 1.7632 | 1.7657 | 1.7596 | 1.7657 | 925120.0 |
| 2005-09-08 09:05:00 | AAPL | Stock | 1.7636 | 1.7654 | 1.7618 | 1.7654 | 684880.0 |
| 2005-09-08 09:10:00 | AAPL | Stock | 1.7654 | 1.7693 | 1.7629 | 1.7675 | 2470188.0 |
| 2005-09-08 09:15:00 | AAPL | Stock | 1.7675 | 1.7686 | 1.765 | 1.765 | 604996.0 |
| 2005-09-08 09:20:00 | AAPL | Stock | 1.7664 | 1.7679 | 1.7621 | 1.7654 | 299376.0 |
| 2005-09-08 09:25:00 | AAPL | Stock | 1.7611 | 1.7657 | 1.7593 | 1.7625 | 625296.0 |
| 2005-09-08 09:30:00 | AAPL | Stock | 1.7625 | 1.7743 | 1.7621 | 1.7668 | 33025328.0 |
| 2005-09-08 09:35:00 | AAPL | Stock | 1.7668 | 1.7689 | 1.755 | 1.7586 | 24706332.0 |
| 2005-09-08 09:40:00 | AAPL | Stock | 1.7589 | 1.7771 | 1.7571 | 1.7771 | 24618272.0 |
| 2005-09-08 09:45:00 | AAPL | Stock | 1.7768 | 1.7846 | 1.7729 | 1.7836 | 34781152.0 |
| 2005-09-08 09:50:00 | AAPL | Stock | 1.7839 | 1.7857 | 1.7807 | 1.7846 | 32468996.0 |
| 2005-09-08 09:55:00 | AAPL | Stock | 1.7843 | 1.79 | 1.7789 | 1.7818 | 36693160.0 |
| 2005-09-08 10:00:00 | AAPL | Stock | 1.7818 | 1.7836 | 1.7682 | 1.7739 | 26318040.0 |
| 2005-09-08 10:05:00 | AAPL | Stock | 1.7743 | 1.7771 | 1.7693 | 1.7746 | 19507040.0 |
| 2005-09-08 10:10:00 | AAPL | Stock | 1.7746 | 1.7754 | 1.7696 | 1.7729 | 11853576.0 |
| 2005-09-08 10:15:00 | AAPL | Stock | 1.7729 | 1.7736 | 1.7689 | 1.7729 | 9527672.0 |
| 2005-09-08 10:20:00 | AAPL | Stock | 1.7729 | 1.7754 | 1.7718 | 1.7725 | 8549240.0 |
| 2005-09-08 10:25:00 | AAPL | Stock | 1.7729 | 1.7804 | 1.7725 | 1.7761 | 9709392.0 |
| 2005-09-08 10:30:00 | AAPL | Stock | 1.7757 | 1.7811 | 1.7754 | 1.7793 | 9760156.0 |
| 2005-09-08 10:35:00 | AAPL | Stock | 1.7793 | 1.7839 | 1.7775 | 1.7814 | 9651432.0 |
| 2005-09-08 10:40:00 | AAPL | Stock | 1.7814 | 1.7818 | 1.7757 | 1.7782 | 9974356.0 |
| 2005-09-08 10:45:00 | AAPL | Stock | 1.7779 | 1.7832 | 1.7761 | 1.7829 | 7427084.0 |
| 2005-09-08 10:50:00 | AAPL | Stock | 1.7829 | 1.7854 | 1.7796 | 1.7796 | 10114440.0 |
| 2005-09-08 10:55:00 | AAPL | Stock | 1.78 | 1.7814 | 1.7779 | 1.7814 | 6632920.0 |
| 2005-09-08 11:00:00 | AAPL | Stock | 1.7814 | 1.7818 | 1.7771 | 1.7782 | 5996396.0 |
| 2005-09-08 11:05:00 | AAPL | Stock | 1.7782 | 1.7796 | 1.775 | 1.7768 | 5688788.0 |
| 2005-09-08 11:10:00 | AAPL | Stock | 1.7768 | 1.7775 | 1.7721 | 1.7721 | 6398140.0 |
| 2005-09-08 11:15:00 | AAPL | Stock | 1.7722 | 1.7743 | 1.7696 | 1.7704 | 8774836.0 |
| 2005-09-08 11:20:00 | AAPL | Stock | 1.7704 | 1.7773 | 1.77 | 1.775 | 6172068.0 |
| 2005-09-08 11:25:00 | AAPL | Stock | 1.7743 | 1.7764 | 1.7743 | 1.7761 | 4220216.0 |
| 2005-09-08 11:30:00 | AAPL | Stock | 1.7761 | 1.7775 | 1.7739 | 1.7771 | 4009572.0 |
> showing 50 of 199,946 rows — these rows as CSV