PREVIEW / stock_5min / 2010-10-14
file: by_date/stock_5min/2010/2010-10-14.parquet size: 4.8 MB rows: 325,281 symbols: 3,479
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 |
|---|---|---|---|---|---|---|---|
| 2010-10-14 04:00:00 | AAPL | Stock | 10.7582 | 10.7582 | 10.7582 | 10.7582 | 14000.0 |
| 2010-10-14 05:10:00 | AAPL | Stock | 10.75 | 10.75 | 10.75 | 10.75 | 5600.0 |
| 2010-10-14 05:35:00 | AAPL | Stock | 10.7425 | 10.7425 | 10.7425 | 10.7425 | 2800.0 |
| 2010-10-14 06:45:00 | AAPL | Stock | 10.7286 | 10.7286 | 10.7286 | 10.7286 | 5600.0 |
| 2010-10-14 06:50:00 | AAPL | Stock | 10.7386 | 10.7386 | 10.7386 | 10.7386 | 2800.0 |
| 2010-10-14 07:00:00 | AAPL | Stock | 10.75 | 10.7571 | 10.75 | 10.7571 | 9800.0 |
| 2010-10-14 07:05:00 | AAPL | Stock | 10.7425 | 10.7493 | 10.7421 | 10.7493 | 13300.0 |
| 2010-10-14 07:15:00 | AAPL | Stock | 10.7421 | 10.7421 | 10.7421 | 10.7421 | 2800.0 |
| 2010-10-14 07:20:00 | AAPL | Stock | 10.7421 | 10.75 | 10.7421 | 10.75 | 19600.0 |
| 2010-10-14 07:25:00 | AAPL | Stock | 10.7514 | 10.7564 | 10.7514 | 10.7521 | 33936.0 |
| 2010-10-14 07:30:00 | AAPL | Stock | 10.7521 | 10.7571 | 10.7521 | 10.7571 | 11200.0 |
| 2010-10-14 07:35:00 | AAPL | Stock | 10.7586 | 10.7632 | 10.7571 | 10.7586 | 28000.0 |
| 2010-10-14 07:40:00 | AAPL | Stock | 10.7579 | 10.7586 | 10.7564 | 10.7564 | 36400.0 |
| 2010-10-14 07:45:00 | AAPL | Stock | 10.7586 | 10.7589 | 10.7586 | 10.7586 | 84000.0 |
| 2010-10-14 07:50:00 | AAPL | Stock | 10.7582 | 10.7586 | 10.7582 | 10.7586 | 15400.0 |
| 2010-10-14 07:55:00 | AAPL | Stock | 10.7582 | 10.7586 | 10.7582 | 10.7586 | 28000.0 |
| 2010-10-14 08:00:00 | AAPL | Stock | 10.7536 | 10.7582 | 10.7464 | 10.7493 | 365680.0 |
| 2010-10-14 08:05:00 | AAPL | Stock | 10.7529 | 10.7564 | 10.7454 | 10.7514 | 112000.0 |
| 2010-10-14 08:10:00 | AAPL | Stock | 10.7457 | 10.7457 | 10.7357 | 10.7361 | 195356.0 |
| 2010-10-14 08:15:00 | AAPL | Stock | 10.7393 | 10.75 | 10.7386 | 10.7493 | 183260.0 |
| 2010-10-14 08:20:00 | AAPL | Stock | 10.75 | 10.7536 | 10.7493 | 10.7493 | 164640.0 |
| 2010-10-14 08:25:00 | AAPL | Stock | 10.7496 | 10.7561 | 10.7496 | 10.7561 | 108556.0 |
| 2010-10-14 08:30:00 | AAPL | Stock | 10.7561 | 10.7646 | 10.735 | 10.7646 | 1265348.0 |
| 2010-10-14 08:35:00 | AAPL | Stock | 10.7654 | 10.8261 | 10.7639 | 10.8096 | 2997400.0 |
| 2010-10-14 08:40:00 | AAPL | Stock | 10.8096 | 10.8196 | 10.8 | 10.8004 | 2049936.0 |
| 2010-10-14 08:45:00 | AAPL | Stock | 10.7989 | 10.8 | 10.7857 | 10.7896 | 1399944.0 |
| 2010-10-14 08:50:00 | AAPL | Stock | 10.79 | 10.8025 | 10.7893 | 10.8018 | 1127084.0 |
| 2010-10-14 08:55:00 | AAPL | Stock | 10.8004 | 10.8011 | 10.7857 | 10.7968 | 1423240.0 |
| 2010-10-14 09:00:00 | AAPL | Stock | 10.7954 | 10.7968 | 10.7775 | 10.7861 | 770420.0 |
| 2010-10-14 09:05:00 | AAPL | Stock | 10.7875 | 10.7875 | 10.7625 | 10.7625 | 1058008.0 |
| 2010-10-14 09:10:00 | AAPL | Stock | 10.7625 | 10.7679 | 10.7571 | 10.7643 | 484064.0 |
| 2010-10-14 09:15:00 | AAPL | Stock | 10.7657 | 10.7721 | 10.7632 | 10.7696 | 131600.0 |
| 2010-10-14 09:20:00 | AAPL | Stock | 10.7693 | 10.7693 | 10.7504 | 10.7504 | 323736.0 |
| 2010-10-14 09:25:00 | AAPL | Stock | 10.7504 | 10.7743 | 10.75 | 10.7625 | 463960.0 |
| 2010-10-14 09:30:00 | AAPL | Stock | 10.7636 | 10.7832 | 10.7511 | 10.7618 | 20809572.0 |
| 2010-10-14 09:35:00 | AAPL | Stock | 10.7618 | 10.7757 | 10.7518 | 10.7736 | 15416296.0 |
| 2010-10-14 09:40:00 | AAPL | Stock | 10.7741 | 10.79 | 10.7646 | 10.7828 | 17880772.0 |
| 2010-10-14 09:45:00 | AAPL | Stock | 10.7828 | 10.7846 | 10.7561 | 10.7568 | 10573248.0 |
| 2010-10-14 09:50:00 | AAPL | Stock | 10.7571 | 10.7571 | 10.7286 | 10.7511 | 12958652.0 |
| 2010-10-14 09:55:00 | AAPL | Stock | 10.7514 | 10.7564 | 10.7321 | 10.74 | 7957684.0 |
| 2010-10-14 10:00:00 | AAPL | Stock | 10.74 | 10.7679 | 10.7357 | 10.7621 | 8705340.0 |
| 2010-10-14 10:05:00 | AAPL | Stock | 10.7618 | 10.77 | 10.7582 | 10.7596 | 6183296.0 |
| 2010-10-14 10:10:00 | AAPL | Stock | 10.7612 | 10.7775 | 10.755 | 10.7689 | 8335180.0 |
| 2010-10-14 10:15:00 | AAPL | Stock | 10.7714 | 10.7889 | 10.7689 | 10.7832 | 9335256.0 |
| 2010-10-14 10:20:00 | AAPL | Stock | 10.7834 | 10.7932 | 10.7768 | 10.7879 | 7895188.0 |
| 2010-10-14 10:25:00 | AAPL | Stock | 10.7875 | 10.7875 | 10.775 | 10.7806 | 4326476.0 |
| 2010-10-14 10:30:00 | AAPL | Stock | 10.7796 | 10.7893 | 10.775 | 10.7825 | 3946572.0 |
| 2010-10-14 10:35:00 | AAPL | Stock | 10.7836 | 10.7893 | 10.7804 | 10.7889 | 4372816.0 |
| 2010-10-14 10:40:00 | AAPL | Stock | 10.788 | 10.7889 | 10.7807 | 10.7846 | 4117680.0 |
| 2010-10-14 10:45:00 | AAPL | Stock | 10.7859 | 10.7979 | 10.7842 | 10.7957 | 6211380.0 |
> showing 50 of 325,281 rows — these rows as CSV