PREVIEW / stock_1min / 2007-07-10
file: by_date/stock_1min/2007/2007-07-10.parquet size: 11.8 MB rows: 966,160 symbols: 2,516
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-10 09:30:00 | AAPL | Stock | 4.6029 | 4.6164 | 4.6004 | 4.6125 | 15951880.0 |
| 2007-07-10 09:31:00 | AAPL | Stock | 4.6132 | 4.6225 | 4.6004 | 4.6211 | 6351772.0 |
| 2007-07-10 09:32:00 | AAPL | Stock | 4.6211 | 4.6293 | 4.6204 | 4.6282 | 7459452.0 |
| 2007-07-10 09:33:00 | AAPL | Stock | 4.6289 | 4.6393 | 4.6279 | 4.6311 | 6960380.0 |
| 2007-07-10 09:34:00 | AAPL | Stock | 4.6318 | 4.6386 | 4.6281 | 4.6375 | 6443304.0 |
| 2007-07-10 09:35:00 | AAPL | Stock | 4.6375 | 4.6493 | 4.6321 | 4.6481 | 7424872.0 |
| 2007-07-10 09:36:00 | AAPL | Stock | 4.6482 | 4.6589 | 4.6479 | 4.6561 | 6918296.0 |
| 2007-07-10 09:37:00 | AAPL | Stock | 4.6557 | 4.6661 | 4.655 | 4.6618 | 8829940.0 |
| 2007-07-10 09:38:00 | AAPL | Stock | 4.6625 | 4.6782 | 4.6625 | 4.6767 | 8358756.0 |
| 2007-07-10 09:39:00 | AAPL | Stock | 4.6775 | 4.6879 | 4.6696 | 4.67 | 10000788.0 |
| 2007-07-10 09:40:00 | AAPL | Stock | 4.6696 | 4.67 | 4.6636 | 4.665 | 7077364.0 |
| 2007-07-10 09:41:00 | AAPL | Stock | 4.665 | 4.6786 | 4.6629 | 4.675 | 7145992.0 |
| 2007-07-10 09:42:00 | AAPL | Stock | 4.6746 | 4.6911 | 4.6739 | 4.6893 | 10949316.0 |
| 2007-07-10 09:43:00 | AAPL | Stock | 4.6893 | 4.695 | 4.6786 | 4.6818 | 11192216.0 |
| 2007-07-10 09:44:00 | AAPL | Stock | 4.6814 | 4.6904 | 4.6786 | 4.6895 | 6708072.0 |
| 2007-07-10 09:45:00 | AAPL | Stock | 4.6896 | 4.6961 | 4.6861 | 4.6925 | 7066276.0 |
| 2007-07-10 09:46:00 | AAPL | Stock | 4.6925 | 4.6993 | 4.6886 | 4.6939 | 6843424.0 |
| 2007-07-10 09:47:00 | AAPL | Stock | 4.6936 | 4.6986 | 4.6936 | 4.6964 | 6431628.0 |
| 2007-07-10 09:48:00 | AAPL | Stock | 4.6964 | 4.7036 | 4.6964 | 4.6979 | 7153580.0 |
| 2007-07-10 09:49:00 | AAPL | Stock | 4.6979 | 4.7054 | 4.6971 | 4.7043 | 6625892.0 |
| 2007-07-10 09:50:00 | AAPL | Stock | 4.7032 | 4.7125 | 4.7014 | 4.7125 | 9781044.0 |
| 2007-07-10 09:51:00 | AAPL | Stock | 4.7121 | 4.72 | 4.7054 | 4.7143 | 13950580.0 |
| 2007-07-10 09:52:00 | AAPL | Stock | 4.7143 | 4.73 | 4.7139 | 4.7282 | 13395144.0 |
| 2007-07-10 09:53:00 | AAPL | Stock | 4.7279 | 4.7282 | 4.7146 | 4.7225 | 10691296.0 |
| 2007-07-10 09:54:00 | AAPL | Stock | 4.7225 | 4.7318 | 4.7189 | 4.7193 | 11203528.0 |
| 2007-07-10 09:55:00 | AAPL | Stock | 4.7193 | 4.7286 | 4.7182 | 4.7286 | 7753340.0 |
| 2007-07-10 09:56:00 | AAPL | Stock | 4.7286 | 4.7429 | 4.7273 | 4.74 | 12687220.0 |
| 2007-07-10 09:57:00 | AAPL | Stock | 4.7402 | 4.7403 | 4.7282 | 4.7293 | 7470876.0 |
| 2007-07-10 09:58:00 | AAPL | Stock | 4.7296 | 4.7296 | 4.7264 | 4.7282 | 7761656.0 |
| 2007-07-10 09:59:00 | AAPL | Stock | 4.7282 | 4.735 | 4.7246 | 4.7336 | 7765492.0 |
| 2007-07-10 10:00:00 | AAPL | Stock | 4.7332 | 4.7404 | 4.73 | 4.7354 | 6371456.0 |
| 2007-07-10 10:01:00 | AAPL | Stock | 4.735 | 4.7387 | 4.7286 | 4.7304 | 6564908.0 |
| 2007-07-10 10:02:00 | AAPL | Stock | 4.7296 | 4.7375 | 4.7296 | 4.7343 | 6852272.0 |
| 2007-07-10 10:03:00 | AAPL | Stock | 4.7336 | 4.7457 | 4.7307 | 4.7439 | 8593480.0 |
| 2007-07-10 10:04:00 | AAPL | Stock | 4.7439 | 4.7493 | 4.7354 | 4.7471 | 7142772.0 |
| 2007-07-10 10:05:00 | AAPL | Stock | 4.7471 | 4.7482 | 4.7414 | 4.7439 | 7288568.0 |
| 2007-07-10 10:06:00 | AAPL | Stock | 4.7443 | 4.745 | 4.7375 | 4.7386 | 7641396.0 |
| 2007-07-10 10:07:00 | AAPL | Stock | 4.7386 | 4.7546 | 4.7357 | 4.7518 | 10938172.0 |
| 2007-07-10 10:08:00 | AAPL | Stock | 4.7511 | 4.77 | 4.7471 | 4.7657 | 15924132.0 |
| 2007-07-10 10:09:00 | AAPL | Stock | 4.7661 | 4.7911 | 4.7654 | 4.7846 | 20644008.0 |
| 2007-07-10 10:10:00 | AAPL | Stock | 4.7839 | 4.7943 | 4.7754 | 4.7932 | 14305004.0 |
| 2007-07-10 10:11:00 | AAPL | Stock | 4.7932 | 4.8036 | 4.7857 | 4.7932 | 14717752.0 |
| 2007-07-10 10:12:00 | AAPL | Stock | 4.7932 | 4.7961 | 4.7811 | 4.7921 | 10404296.0 |
| 2007-07-10 10:13:00 | AAPL | Stock | 4.7921 | 4.7996 | 4.7832 | 4.7865 | 8369872.0 |
| 2007-07-10 10:14:00 | AAPL | Stock | 4.7846 | 4.7868 | 4.775 | 4.7775 | 10324468.0 |
| 2007-07-10 10:15:00 | AAPL | Stock | 4.7775 | 4.7804 | 4.7682 | 4.7714 | 11547592.0 |
| 2007-07-10 10:16:00 | AAPL | Stock | 4.7714 | 4.775 | 4.7611 | 4.7632 | 9194724.0 |
| 2007-07-10 10:17:00 | AAPL | Stock | 4.7636 | 4.7725 | 4.7622 | 4.7725 | 8074416.0 |
| 2007-07-10 10:18:00 | AAPL | Stock | 4.7729 | 4.7764 | 4.7679 | 4.7714 | 5868828.0 |
| 2007-07-10 10:19:00 | AAPL | Stock | 4.7729 | 4.7732 | 4.7646 | 4.7664 | 4272184.0 |
> showing 50 of 966,160 rows — these rows as CSV