PREVIEW / stock_1min / 2004-09-24
file: by_date/stock_1min/2004/2004-09-24.parquet size: 5.4 MB rows: 456,272 symbols: 1,503
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 |
|---|---|---|---|---|---|---|---|
| 2004-09-24 08:02:00 | AAPL | Stock | 0.6656 | 0.6656 | 0.6656 | 0.6656 | 280000.0 |
| 2004-09-24 09:24:00 | AAPL | Stock | 0.6666 | 0.6666 | 0.6666 | 0.6666 | 5600.0 |
| 2004-09-24 09:29:00 | AAPL | Stock | 0.6679 | 0.6679 | 0.6679 | 0.6679 | 57904.0 |
| 2004-09-24 09:30:00 | AAPL | Stock | 0.6679 | 0.6688 | 0.6661 | 0.6677 | 3818304.0 |
| 2004-09-24 09:31:00 | AAPL | Stock | 0.6677 | 0.6679 | 0.6661 | 0.6661 | 1037400.0 |
| 2004-09-24 09:32:00 | AAPL | Stock | 0.6664 | 0.6677 | 0.6661 | 0.6675 | 641200.0 |
| 2004-09-24 09:33:00 | AAPL | Stock | 0.6673 | 0.6675 | 0.6663 | 0.6664 | 188776.0 |
| 2004-09-24 09:34:00 | AAPL | Stock | 0.6663 | 0.6668 | 0.6661 | 0.6664 | 437416.0 |
| 2004-09-24 09:35:00 | AAPL | Stock | 0.6663 | 0.6664 | 0.6661 | 0.6664 | 485016.0 |
| 2004-09-24 09:36:00 | AAPL | Stock | 0.6666 | 0.667 | 0.6661 | 0.6664 | 1075312.0 |
| 2004-09-24 09:37:00 | AAPL | Stock | 0.6666 | 0.668 | 0.6661 | 0.667 | 1229424.0 |
| 2004-09-24 09:38:00 | AAPL | Stock | 0.6673 | 0.6679 | 0.667 | 0.667 | 586040.0 |
| 2004-09-24 09:39:00 | AAPL | Stock | 0.6671 | 0.6677 | 0.667 | 0.6675 | 265104.0 |
| 2004-09-24 09:40:00 | AAPL | Stock | 0.6675 | 0.6677 | 0.6661 | 0.6664 | 812280.0 |
| 2004-09-24 09:41:00 | AAPL | Stock | 0.6663 | 0.667 | 0.6661 | 0.6664 | 270256.0 |
| 2004-09-24 09:42:00 | AAPL | Stock | 0.6664 | 0.6668 | 0.6652 | 0.6661 | 725592.0 |
| 2004-09-24 09:43:00 | AAPL | Stock | 0.6666 | 0.6666 | 0.6652 | 0.6654 | 418768.0 |
| 2004-09-24 09:44:00 | AAPL | Stock | 0.6655 | 0.6657 | 0.6652 | 0.6654 | 770224.0 |
| 2004-09-24 09:45:00 | AAPL | Stock | 0.6656 | 0.6661 | 0.6655 | 0.6659 | 543200.0 |
| 2004-09-24 09:46:00 | AAPL | Stock | 0.6659 | 0.6664 | 0.6659 | 0.6664 | 338184.0 |
| 2004-09-24 09:47:00 | AAPL | Stock | 0.6663 | 0.6664 | 0.6663 | 0.6664 | 408800.0 |
| 2004-09-24 09:48:00 | AAPL | Stock | 0.6664 | 0.6664 | 0.6659 | 0.6661 | 1058400.0 |
| 2004-09-24 09:49:00 | AAPL | Stock | 0.6664 | 0.6675 | 0.6661 | 0.6675 | 1237320.0 |
| 2004-09-24 09:50:00 | AAPL | Stock | 0.6675 | 0.6684 | 0.6671 | 0.6673 | 1157240.0 |
| 2004-09-24 09:51:00 | AAPL | Stock | 0.6675 | 0.6682 | 0.667 | 0.668 | 812000.0 |
| 2004-09-24 09:52:00 | AAPL | Stock | 0.668 | 0.6721 | 0.668 | 0.6718 | 3462592.0 |
| 2004-09-24 09:53:00 | AAPL | Stock | 0.6718 | 0.6741 | 0.6718 | 0.6736 | 1886976.0 |
| 2004-09-24 09:54:00 | AAPL | Stock | 0.6736 | 0.6743 | 0.6718 | 0.6723 | 2117584.0 |
| 2004-09-24 09:55:00 | AAPL | Stock | 0.6726 | 0.6735 | 0.6705 | 0.6711 | 3521504.0 |
| 2004-09-24 09:56:00 | AAPL | Stock | 0.6707 | 0.6711 | 0.6705 | 0.6709 | 918344.0 |
| 2004-09-24 09:57:00 | AAPL | Stock | 0.6709 | 0.6709 | 0.6698 | 0.67 | 309680.0 |
| 2004-09-24 09:58:00 | AAPL | Stock | 0.67 | 0.6705 | 0.67 | 0.6705 | 280000.0 |
| 2004-09-24 09:59:00 | AAPL | Stock | 0.6707 | 0.6716 | 0.6707 | 0.6716 | 676872.0 |
| 2004-09-24 10:00:00 | AAPL | Stock | 0.6716 | 0.672 | 0.6707 | 0.6718 | 2286704.0 |
| 2004-09-24 10:01:00 | AAPL | Stock | 0.6721 | 0.6721 | 0.6711 | 0.6711 | 1833832.0 |
| 2004-09-24 10:02:00 | AAPL | Stock | 0.6711 | 0.6716 | 0.6707 | 0.6707 | 1772400.0 |
| 2004-09-24 10:03:00 | AAPL | Stock | 0.6707 | 0.6713 | 0.6705 | 0.6711 | 742952.0 |
| 2004-09-24 10:04:00 | AAPL | Stock | 0.6711 | 0.6718 | 0.6711 | 0.6716 | 515368.0 |
| 2004-09-24 10:05:00 | AAPL | Stock | 0.6716 | 0.672 | 0.6713 | 0.6714 | 940688.0 |
| 2004-09-24 10:06:00 | AAPL | Stock | 0.6714 | 0.672 | 0.6711 | 0.672 | 2127608.0 |
| 2004-09-24 10:07:00 | AAPL | Stock | 0.6714 | 0.6721 | 0.6714 | 0.6721 | 740040.0 |
| 2004-09-24 10:08:00 | AAPL | Stock | 0.6723 | 0.6725 | 0.672 | 0.672 | 3453632.0 |
| 2004-09-24 10:09:00 | AAPL | Stock | 0.672 | 0.6725 | 0.672 | 0.6723 | 205688.0 |
| 2004-09-24 10:10:00 | AAPL | Stock | 0.6723 | 0.6725 | 0.6714 | 0.672 | 1041600.0 |
| 2004-09-24 10:11:00 | AAPL | Stock | 0.6718 | 0.6718 | 0.6713 | 0.6718 | 401688.0 |
| 2004-09-24 10:12:00 | AAPL | Stock | 0.6716 | 0.6716 | 0.6711 | 0.6716 | 672224.0 |
| 2004-09-24 10:13:00 | AAPL | Stock | 0.6714 | 0.6721 | 0.6707 | 0.6718 | 660800.0 |
| 2004-09-24 10:14:00 | AAPL | Stock | 0.6721 | 0.6727 | 0.6716 | 0.6727 | 990136.0 |
| 2004-09-24 10:15:00 | AAPL | Stock | 0.6727 | 0.6727 | 0.672 | 0.6723 | 291200.0 |
| 2004-09-24 10:16:00 | AAPL | Stock | 0.6721 | 0.6727 | 0.6721 | 0.6727 | 724416.0 |
> showing 50 of 456,272 rows — these rows as CSV