PREVIEW / stock_5min / 2007-12-13
file: by_date/stock_5min/2007/2007-12-13.parquet size: 4.4 MB rows: 319,823 symbols: 3,218
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-12-13 05:05:00 | AAPL | Stock | 6.7746 | 6.7746 | 6.7746 | 6.7746 | 2800.0 |
| 2007-12-13 05:25:00 | AAPL | Stock | 6.7561 | 6.7561 | 6.75 | 6.75 | 6160.0 |
| 2007-12-13 07:10:00 | AAPL | Stock | 6.7589 | 6.7589 | 6.7589 | 6.7589 | 5600.0 |
| 2007-12-13 07:15:00 | AAPL | Stock | 6.7557 | 6.7557 | 6.75 | 6.7507 | 16240.0 |
| 2007-12-13 07:20:00 | AAPL | Stock | 6.7364 | 6.7364 | 6.7179 | 6.7179 | 22400.0 |
| 2007-12-13 07:25:00 | AAPL | Stock | 6.7214 | 6.7293 | 6.7214 | 6.7286 | 28000.0 |
| 2007-12-13 07:30:00 | AAPL | Stock | 6.7286 | 6.7286 | 6.7286 | 6.7286 | 10360.0 |
| 2007-12-13 07:35:00 | AAPL | Stock | 6.7286 | 6.7464 | 6.7232 | 6.7464 | 70420.0 |
| 2007-12-13 07:40:00 | AAPL | Stock | 6.7357 | 6.7361 | 6.7357 | 6.7361 | 86800.0 |
| 2007-12-13 07:45:00 | AAPL | Stock | 6.7332 | 6.7743 | 6.7332 | 6.7743 | 28000.0 |
| 2007-12-13 07:50:00 | AAPL | Stock | 6.7321 | 6.7321 | 6.7321 | 6.7321 | 25200.0 |
| 2007-12-13 07:55:00 | AAPL | Stock | 6.7464 | 6.75 | 6.7429 | 6.75 | 58800.0 |
| 2007-12-13 08:00:00 | AAPL | Stock | 6.75 | 6.7661 | 6.7304 | 6.7621 | 774116.0 |
| 2007-12-13 08:05:00 | AAPL | Stock | 6.7625 | 6.7625 | 6.745 | 6.7536 | 385644.0 |
| 2007-12-13 08:10:00 | AAPL | Stock | 6.7579 | 6.7579 | 6.7511 | 6.7539 | 230608.0 |
| 2007-12-13 08:15:00 | AAPL | Stock | 6.7539 | 6.7539 | 6.7482 | 6.7504 | 413924.0 |
| 2007-12-13 08:20:00 | AAPL | Stock | 6.7507 | 6.7589 | 6.75 | 6.7536 | 224532.0 |
| 2007-12-13 08:25:00 | AAPL | Stock | 6.7571 | 6.7657 | 6.7571 | 6.7593 | 182616.0 |
| 2007-12-13 08:30:00 | AAPL | Stock | 6.76 | 6.7614 | 6.7457 | 6.7518 | 870044.0 |
| 2007-12-13 08:35:00 | AAPL | Stock | 6.7486 | 6.7568 | 6.7443 | 6.7443 | 695380.0 |
| 2007-12-13 08:40:00 | AAPL | Stock | 6.7443 | 6.7646 | 6.7443 | 6.7621 | 803908.0 |
| 2007-12-13 08:45:00 | AAPL | Stock | 6.7621 | 6.7704 | 6.7607 | 6.7643 | 819588.0 |
| 2007-12-13 08:50:00 | AAPL | Stock | 6.7654 | 6.7714 | 6.7654 | 6.7696 | 584920.0 |
| 2007-12-13 08:55:00 | AAPL | Stock | 6.7714 | 6.7936 | 6.7696 | 6.7857 | 1216068.0 |
| 2007-12-13 09:00:00 | AAPL | Stock | 6.7857 | 6.7918 | 6.7821 | 6.7875 | 586208.0 |
| 2007-12-13 09:05:00 | AAPL | Stock | 6.7861 | 6.7875 | 6.78 | 6.7843 | 455252.0 |
| 2007-12-13 09:10:00 | AAPL | Stock | 6.785 | 6.7871 | 6.7832 | 6.7832 | 466536.0 |
| 2007-12-13 09:15:00 | AAPL | Stock | 6.7811 | 6.7875 | 6.7804 | 6.7875 | 143500.0 |
| 2007-12-13 09:20:00 | AAPL | Stock | 6.7875 | 6.7939 | 6.7875 | 6.7921 | 193620.0 |
| 2007-12-13 09:25:00 | AAPL | Stock | 6.7921 | 6.8004 | 6.7868 | 6.7925 | 416920.0 |
| 2007-12-13 09:30:00 | AAPL | Stock | 6.7943 | 6.8459 | 6.7825 | 6.8261 | 28549556.0 |
| 2007-12-13 09:35:00 | AAPL | Stock | 6.8257 | 6.8614 | 6.825 | 6.8346 | 22755628.0 |
| 2007-12-13 09:40:00 | AAPL | Stock | 6.8339 | 6.8416 | 6.7857 | 6.7921 | 23332400.0 |
| 2007-12-13 09:45:00 | AAPL | Stock | 6.7921 | 6.7936 | 6.7679 | 6.7875 | 24769584.0 |
| 2007-12-13 09:50:00 | AAPL | Stock | 6.7886 | 6.8029 | 6.7786 | 6.7936 | 15662108.0 |
| 2007-12-13 09:55:00 | AAPL | Stock | 6.7936 | 6.8079 | 6.7743 | 6.7843 | 15916236.0 |
| 2007-12-13 10:00:00 | AAPL | Stock | 6.7839 | 6.8089 | 6.7711 | 6.8017 | 18716852.0 |
| 2007-12-13 10:05:00 | AAPL | Stock | 6.8 | 6.8421 | 6.7964 | 6.8393 | 18632852.0 |
| 2007-12-13 10:10:00 | AAPL | Stock | 6.8393 | 6.8539 | 6.8282 | 6.8304 | 19408452.0 |
| 2007-12-13 10:15:00 | AAPL | Stock | 6.8307 | 6.8464 | 6.8268 | 6.8271 | 11441612.0 |
| 2007-12-13 10:20:00 | AAPL | Stock | 6.8286 | 6.8518 | 6.8118 | 6.8118 | 14749112.0 |
| 2007-12-13 10:25:00 | AAPL | Stock | 6.8114 | 6.8204 | 6.7986 | 6.8082 | 13477940.0 |
| 2007-12-13 10:30:00 | AAPL | Stock | 6.8082 | 6.8318 | 6.7993 | 6.8146 | 11103428.0 |
| 2007-12-13 10:35:00 | AAPL | Stock | 6.8146 | 6.8365 | 6.8061 | 6.8332 | 9516836.0 |
| 2007-12-13 10:40:00 | AAPL | Stock | 6.8343 | 6.8368 | 6.8075 | 6.8186 | 10734920.0 |
| 2007-12-13 10:45:00 | AAPL | Stock | 6.8182 | 6.82 | 6.8 | 6.8164 | 8691592.0 |
| 2007-12-13 10:50:00 | AAPL | Stock | 6.8164 | 6.8186 | 6.8054 | 6.8132 | 4895128.0 |
| 2007-12-13 10:55:00 | AAPL | Stock | 6.8143 | 6.8154 | 6.7586 | 6.78 | 16500120.0 |
| 2007-12-13 11:00:00 | AAPL | Stock | 6.78 | 6.7831 | 6.7611 | 6.7768 | 10311448.0 |
| 2007-12-13 11:05:00 | AAPL | Stock | 6.7768 | 6.7882 | 6.7525 | 6.7829 | 14315616.0 |
> showing 50 of 319,823 rows — these rows as CSV