PREVIEW / stock_1min / 2007-07-12
file: by_date/stock_1min/2007/2007-07-12.parquet size: 11.1 MB rows: 906,097 symbols: 2,518
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.7821 | 4.7711 | 4.7754 | 9481752.0 |
| 2007-07-12 09:31:00 | AAPL | Stock | 4.7754 | 4.7943 | 4.7736 | 4.7825 | 14160244.0 |
| 2007-07-12 09:32:00 | AAPL | Stock | 4.7832 | 4.7918 | 4.7814 | 4.7846 | 6766144.0 |
| 2007-07-12 09:33:00 | AAPL | Stock | 4.7846 | 4.7854 | 4.7614 | 4.7811 | 9305744.0 |
| 2007-07-12 09:34:00 | AAPL | Stock | 4.7821 | 4.7875 | 4.7768 | 4.7811 | 6777400.0 |
| 2007-07-12 09:35:00 | AAPL | Stock | 4.7832 | 4.7871 | 4.7757 | 4.7804 | 5382300.0 |
| 2007-07-12 09:36:00 | AAPL | Stock | 4.7804 | 4.7821 | 4.7671 | 4.7682 | 3653468.0 |
| 2007-07-12 09:37:00 | AAPL | Stock | 4.7682 | 4.7779 | 4.7679 | 4.7754 | 6113912.0 |
| 2007-07-12 09:38:00 | AAPL | Stock | 4.7757 | 4.7775 | 4.7725 | 4.7732 | 4593568.0 |
| 2007-07-12 09:39:00 | AAPL | Stock | 4.7729 | 4.7804 | 4.7721 | 4.7743 | 4350556.0 |
| 2007-07-12 09:40:00 | AAPL | Stock | 4.7743 | 4.7779 | 4.7714 | 4.7743 | 4551288.0 |
| 2007-07-12 09:41:00 | AAPL | Stock | 4.7739 | 4.7832 | 4.7739 | 4.7832 | 6015688.0 |
| 2007-07-12 09:42:00 | AAPL | Stock | 4.7836 | 4.7839 | 4.7796 | 4.7807 | 5951988.0 |
| 2007-07-12 09:43:00 | AAPL | Stock | 4.7804 | 4.7825 | 4.7761 | 4.7796 | 4229064.0 |
| 2007-07-12 09:44:00 | AAPL | Stock | 4.7793 | 4.7829 | 4.7786 | 4.7804 | 2646084.0 |
| 2007-07-12 09:45:00 | AAPL | Stock | 4.7807 | 4.7811 | 4.7729 | 4.7782 | 5133296.0 |
| 2007-07-12 09:46:00 | AAPL | Stock | 4.7786 | 4.7857 | 4.7768 | 4.7843 | 6097952.0 |
| 2007-07-12 09:47:00 | AAPL | Stock | 4.7843 | 4.7929 | 4.7793 | 4.7829 | 9536856.0 |
| 2007-07-12 09:48:00 | AAPL | Stock | 4.7832 | 4.7839 | 4.7775 | 4.7836 | 2726892.0 |
| 2007-07-12 09:49:00 | AAPL | Stock | 4.7836 | 4.7843 | 4.7775 | 4.7782 | 3420648.0 |
| 2007-07-12 09:50:00 | AAPL | Stock | 4.7782 | 4.7786 | 4.7643 | 4.7693 | 9090340.0 |
| 2007-07-12 09:51:00 | AAPL | Stock | 4.7693 | 4.7729 | 4.7643 | 4.7643 | 5003684.0 |
| 2007-07-12 09:52:00 | AAPL | Stock | 4.7643 | 4.7671 | 4.7571 | 4.7586 | 7057540.0 |
| 2007-07-12 09:53:00 | AAPL | Stock | 4.7586 | 4.765 | 4.7575 | 4.7607 | 3278604.0 |
| 2007-07-12 09:54:00 | AAPL | Stock | 4.7607 | 4.7636 | 4.75 | 4.75 | 6047244.0 |
| 2007-07-12 09:55:00 | AAPL | Stock | 4.75 | 4.7671 | 4.75 | 4.7668 | 4301696.0 |
| 2007-07-12 09:56:00 | AAPL | Stock | 4.7668 | 4.7679 | 4.7629 | 4.7657 | 2473996.0 |
| 2007-07-12 09:57:00 | AAPL | Stock | 4.7664 | 4.7679 | 4.7604 | 4.7614 | 2899148.0 |
| 2007-07-12 09:58:00 | AAPL | Stock | 4.7625 | 4.7639 | 4.755 | 4.7579 | 3002048.0 |
| 2007-07-12 09:59:00 | AAPL | Stock | 4.7575 | 4.7589 | 4.7557 | 4.7589 | 1673756.0 |
| 2007-07-12 10:00:00 | AAPL | Stock | 4.7586 | 4.7654 | 4.7586 | 4.7646 | 2314564.0 |
| 2007-07-12 10:01:00 | AAPL | Stock | 4.7646 | 4.765 | 4.7607 | 4.7629 | 1140384.0 |
| 2007-07-12 10:02:00 | AAPL | Stock | 4.7625 | 4.7629 | 4.7571 | 4.7575 | 2883524.0 |
| 2007-07-12 10:03:00 | AAPL | Stock | 4.7582 | 4.7668 | 4.7575 | 4.7668 | 2261140.0 |
| 2007-07-12 10:04:00 | AAPL | Stock | 4.7667 | 4.7714 | 4.7661 | 4.77 | 2559200.0 |
| 2007-07-12 10:05:00 | AAPL | Stock | 4.7704 | 4.775 | 4.7679 | 4.7739 | 4200392.0 |
| 2007-07-12 10:06:00 | AAPL | Stock | 4.7743 | 4.7779 | 4.7736 | 4.7745 | 3498012.0 |
| 2007-07-12 10:07:00 | AAPL | Stock | 4.7743 | 4.775 | 4.7668 | 4.77 | 3438512.0 |
| 2007-07-12 10:08:00 | AAPL | Stock | 4.7696 | 4.7736 | 4.7696 | 4.7714 | 1050896.0 |
| 2007-07-12 10:09:00 | AAPL | Stock | 4.7711 | 4.7711 | 4.7582 | 4.7618 | 3045196.0 |
| 2007-07-12 10:10:00 | AAPL | Stock | 4.7618 | 4.7661 | 4.7582 | 4.7591 | 2504908.0 |
| 2007-07-12 10:11:00 | AAPL | Stock | 4.7589 | 4.7636 | 4.7586 | 4.7593 | 1775368.0 |
| 2007-07-12 10:12:00 | AAPL | Stock | 4.7596 | 4.765 | 4.7596 | 4.7636 | 945700.0 |
| 2007-07-12 10:13:00 | AAPL | Stock | 4.7636 | 4.7639 | 4.7614 | 4.7629 | 689836.0 |
| 2007-07-12 10:14:00 | AAPL | Stock | 4.7625 | 4.7636 | 4.7621 | 4.7625 | 639548.0 |
| 2007-07-12 10:15:00 | AAPL | Stock | 4.7629 | 4.7636 | 4.7607 | 4.7614 | 1053220.0 |
| 2007-07-12 10:16:00 | AAPL | Stock | 4.7618 | 4.7679 | 4.7618 | 4.766 | 1445108.0 |
| 2007-07-12 10:17:00 | AAPL | Stock | 4.7661 | 4.7668 | 4.7632 | 4.7632 | 835688.0 |
| 2007-07-12 10:18:00 | AAPL | Stock | 4.7657 | 4.7657 | 4.7632 | 4.7632 | 451080.0 |
| 2007-07-12 10:19:00 | AAPL | Stock | 4.7646 | 4.7661 | 4.7607 | 4.7657 | 1810200.0 |
> showing 50 of 906,097 rows — these rows as CSV