PREVIEW / stock_1min / 2007-08-01
file: by_date/stock_1min/2007/2007-08-01.parquet size: 13.0 MB rows: 1,047,758 symbols: 2,534
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-08-01 09:30:00 | AAPL | Stock | 4.7729 | 4.7732 | 4.7571 | 4.7611 | 12073656.0 |
| 2007-08-01 09:31:00 | AAPL | Stock | 4.7607 | 4.7707 | 4.7468 | 4.7479 | 10032624.0 |
| 2007-08-01 09:32:00 | AAPL | Stock | 4.7471 | 4.7614 | 4.7429 | 4.75 | 9813384.0 |
| 2007-08-01 09:33:00 | AAPL | Stock | 4.75 | 4.7564 | 4.7336 | 4.7346 | 11597348.0 |
| 2007-08-01 09:34:00 | AAPL | Stock | 4.7346 | 4.7457 | 4.6982 | 4.6993 | 18607260.0 |
| 2007-08-01 09:35:00 | AAPL | Stock | 4.6989 | 4.7539 | 4.6982 | 4.7211 | 12421892.0 |
| 2007-08-01 09:36:00 | AAPL | Stock | 4.7207 | 4.7321 | 4.7139 | 4.7321 | 8255492.0 |
| 2007-08-01 09:37:00 | AAPL | Stock | 4.7318 | 4.7411 | 4.7229 | 4.7411 | 6601140.0 |
| 2007-08-01 09:38:00 | AAPL | Stock | 4.7393 | 4.75 | 4.7318 | 4.7329 | 10100048.0 |
| 2007-08-01 09:39:00 | AAPL | Stock | 4.7321 | 4.7325 | 4.7068 | 4.7086 | 8305640.0 |
| 2007-08-01 09:40:00 | AAPL | Stock | 4.7093 | 4.7129 | 4.6896 | 4.6925 | 9644600.0 |
| 2007-08-01 09:41:00 | AAPL | Stock | 4.6929 | 4.6986 | 4.6625 | 4.6696 | 14761124.0 |
| 2007-08-01 09:42:00 | AAPL | Stock | 4.67 | 4.6729 | 4.6471 | 4.6482 | 12397224.0 |
| 2007-08-01 09:43:00 | AAPL | Stock | 4.6479 | 4.6518 | 4.5632 | 4.5871 | 38843924.0 |
| 2007-08-01 09:44:00 | AAPL | Stock | 4.5871 | 4.6179 | 4.5639 | 4.6161 | 21510804.0 |
| 2007-08-01 09:45:00 | AAPL | Stock | 4.6164 | 4.6307 | 4.5714 | 4.6293 | 9959404.0 |
| 2007-08-01 09:46:00 | AAPL | Stock | 4.6246 | 4.6375 | 4.6125 | 4.6161 | 10187044.0 |
| 2007-08-01 09:47:00 | AAPL | Stock | 4.6161 | 4.6232 | 4.6029 | 4.6164 | 7117236.0 |
| 2007-08-01 09:48:00 | AAPL | Stock | 4.615 | 4.6161 | 4.5964 | 4.5982 | 9836596.0 |
| 2007-08-01 09:49:00 | AAPL | Stock | 4.5982 | 4.6018 | 4.5821 | 4.5875 | 8321264.0 |
| 2007-08-01 09:50:00 | AAPL | Stock | 4.5875 | 4.6179 | 4.5821 | 4.6175 | 12717292.0 |
| 2007-08-01 09:51:00 | AAPL | Stock | 4.6179 | 4.6429 | 4.6129 | 4.6339 | 11581248.0 |
| 2007-08-01 09:52:00 | AAPL | Stock | 4.6371 | 4.6371 | 4.6186 | 4.6321 | 4935896.0 |
| 2007-08-01 09:53:00 | AAPL | Stock | 4.6321 | 4.6321 | 4.6268 | 4.6268 | 1483524.0 |
| 2007-08-01 09:54:00 | AAPL | Stock | 4.6286 | 4.6429 | 4.6136 | 4.6413 | 4850664.0 |
| 2007-08-01 09:55:00 | AAPL | Stock | 4.6407 | 4.6429 | 4.615 | 4.6329 | 8995168.0 |
| 2007-08-01 09:56:00 | AAPL | Stock | 4.6329 | 4.6429 | 4.6089 | 4.6232 | 6076672.0 |
| 2007-08-01 09:57:00 | AAPL | Stock | 4.6232 | 4.6418 | 4.6121 | 4.6246 | 4470200.0 |
| 2007-08-01 09:58:00 | AAPL | Stock | 4.6243 | 4.6329 | 4.6168 | 4.6307 | 5408788.0 |
| 2007-08-01 09:59:00 | AAPL | Stock | 4.6296 | 4.6454 | 4.6161 | 4.6161 | 7165172.0 |
| 2007-08-01 10:00:00 | AAPL | Stock | 4.6168 | 4.6411 | 4.6125 | 4.6404 | 5935608.0 |
| 2007-08-01 10:01:00 | AAPL | Stock | 4.6411 | 4.6568 | 4.6409 | 4.6554 | 9004212.0 |
| 2007-08-01 10:02:00 | AAPL | Stock | 4.6557 | 4.6561 | 4.6243 | 4.6275 | 7736036.0 |
| 2007-08-01 10:03:00 | AAPL | Stock | 4.6275 | 4.6364 | 4.6236 | 4.6329 | 5627216.0 |
| 2007-08-01 10:04:00 | AAPL | Stock | 4.6325 | 4.6429 | 4.615 | 4.6207 | 7175896.0 |
| 2007-08-01 10:05:00 | AAPL | Stock | 4.6218 | 4.6518 | 4.5979 | 4.6011 | 7342776.0 |
| 2007-08-01 10:06:00 | AAPL | Stock | 4.6 | 4.6271 | 4.5982 | 4.6125 | 7042980.0 |
| 2007-08-01 10:07:00 | AAPL | Stock | 4.6121 | 4.6411 | 4.6075 | 4.6404 | 5674760.0 |
| 2007-08-01 10:08:00 | AAPL | Stock | 4.6404 | 4.6539 | 4.6179 | 4.6432 | 10209500.0 |
| 2007-08-01 10:09:00 | AAPL | Stock | 4.6443 | 4.6443 | 4.5989 | 4.6335 | 4422152.0 |
| 2007-08-01 10:10:00 | AAPL | Stock | 4.6321 | 4.6607 | 4.6086 | 4.6564 | 6313692.0 |
| 2007-08-01 10:11:00 | AAPL | Stock | 4.6554 | 4.6625 | 4.6471 | 4.6561 | 5538876.0 |
| 2007-08-01 10:12:00 | AAPL | Stock | 4.6564 | 4.6871 | 4.6354 | 4.6836 | 5120108.0 |
| 2007-08-01 10:13:00 | AAPL | Stock | 4.6843 | 4.7143 | 4.6807 | 4.7107 | 10988852.0 |
| 2007-08-01 10:14:00 | AAPL | Stock | 4.7107 | 4.7143 | 4.655 | 4.6893 | 9815736.0 |
| 2007-08-01 10:15:00 | AAPL | Stock | 4.6893 | 4.6904 | 4.6754 | 4.6754 | 6403460.0 |
| 2007-08-01 10:16:00 | AAPL | Stock | 4.675 | 4.7104 | 4.6732 | 4.6964 | 5692736.0 |
| 2007-08-01 10:17:00 | AAPL | Stock | 4.6964 | 4.7125 | 4.6843 | 4.6843 | 5415340.0 |
| 2007-08-01 10:18:00 | AAPL | Stock | 4.6875 | 4.6875 | 4.6732 | 4.6796 | 6044024.0 |
| 2007-08-01 10:19:00 | AAPL | Stock | 4.6796 | 4.7036 | 4.6643 | 4.7021 | 5273072.0 |
> showing 50 of 1,047,758 rows — these rows as CSV