PREVIEW / stock_5min / 2005-10-12
file: by_date/stock_5min/2005/2005-10-12.parquet size: 2.9 MB rows: 210,002 symbols: 2,094
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 |
|---|---|---|---|---|---|---|---|
| 2005-10-12 05:00:00 | AAPL | Stock | 1.6682 | 1.6682 | 1.6682 | 1.6682 | 28000.0 |
| 2005-10-12 05:05:00 | AAPL | Stock | 1.6682 | 1.6682 | 1.6682 | 1.6682 | 28000.0 |
| 2005-10-12 05:55:00 | AAPL | Stock | 1.6889 | 1.6889 | 1.6889 | 1.6889 | 2800.0 |
| 2005-10-12 06:00:00 | AAPL | Stock | 1.6875 | 1.6875 | 1.6875 | 1.6875 | 30800.0 |
| 2005-10-12 06:05:00 | AAPL | Stock | 1.6789 | 1.6789 | 1.6789 | 1.6789 | 2800.0 |
| 2005-10-12 06:10:00 | AAPL | Stock | 1.6921 | 1.6921 | 1.6921 | 1.6921 | 2800.0 |
| 2005-10-12 06:55:00 | AAPL | Stock | 1.6789 | 1.6821 | 1.6789 | 1.6821 | 44800.0 |
| 2005-10-12 07:00:00 | AAPL | Stock | 1.6839 | 1.6839 | 1.6779 | 1.6786 | 161840.0 |
| 2005-10-12 07:05:00 | AAPL | Stock | 1.6782 | 1.6789 | 1.6782 | 1.6789 | 112000.0 |
| 2005-10-12 07:15:00 | AAPL | Stock | 1.6929 | 1.6946 | 1.6925 | 1.6946 | 191632.0 |
| 2005-10-12 07:20:00 | AAPL | Stock | 1.6875 | 1.6875 | 1.6768 | 1.6821 | 194068.0 |
| 2005-10-12 07:25:00 | AAPL | Stock | 1.6821 | 1.6871 | 1.6821 | 1.6871 | 168000.0 |
| 2005-10-12 07:30:00 | AAPL | Stock | 1.6875 | 1.6907 | 1.6857 | 1.6907 | 403200.0 |
| 2005-10-12 07:35:00 | AAPL | Stock | 1.6879 | 1.6907 | 1.6879 | 1.6893 | 53200.0 |
| 2005-10-12 07:40:00 | AAPL | Stock | 1.6893 | 1.6904 | 1.6857 | 1.6857 | 217560.0 |
| 2005-10-12 07:45:00 | AAPL | Stock | 1.6889 | 1.6889 | 1.6861 | 1.6889 | 131600.0 |
| 2005-10-12 07:50:00 | AAPL | Stock | 1.6875 | 1.6911 | 1.6871 | 1.6875 | 212800.0 |
| 2005-10-12 07:55:00 | AAPL | Stock | 1.6929 | 1.6929 | 1.6875 | 1.6886 | 336420.0 |
| 2005-10-12 08:00:00 | AAPL | Stock | 1.6907 | 1.7036 | 1.6793 | 1.7036 | 12198200.0 |
| 2005-10-12 08:05:00 | AAPL | Stock | 1.7025 | 1.7157 | 1.7 | 1.7146 | 15674484.0 |
| 2005-10-12 08:10:00 | AAPL | Stock | 1.715 | 1.7239 | 1.7107 | 1.7179 | 9561188.0 |
| 2005-10-12 08:15:00 | AAPL | Stock | 1.7175 | 1.7204 | 1.7125 | 1.7164 | 5395908.0 |
| 2005-10-12 08:20:00 | AAPL | Stock | 1.7161 | 1.7236 | 1.7125 | 1.7229 | 10607744.0 |
| 2005-10-12 08:25:00 | AAPL | Stock | 1.7221 | 1.7268 | 1.7182 | 1.7193 | 7195972.0 |
| 2005-10-12 08:30:00 | AAPL | Stock | 1.7193 | 1.7232 | 1.7143 | 1.7182 | 6313076.0 |
| 2005-10-12 08:35:00 | AAPL | Stock | 1.7179 | 1.7182 | 1.7114 | 1.7157 | 4835656.0 |
| 2005-10-12 08:40:00 | AAPL | Stock | 1.715 | 1.7171 | 1.7071 | 1.7079 | 8685712.0 |
| 2005-10-12 08:45:00 | AAPL | Stock | 1.7082 | 1.7168 | 1.7075 | 1.7154 | 4028752.0 |
| 2005-10-12 08:50:00 | AAPL | Stock | 1.7161 | 1.7168 | 1.7111 | 1.7132 | 1799476.0 |
| 2005-10-12 08:55:00 | AAPL | Stock | 1.7132 | 1.7214 | 1.7132 | 1.7186 | 4519200.0 |
| 2005-10-12 09:00:00 | AAPL | Stock | 1.7182 | 1.7236 | 1.7168 | 1.7207 | 7330848.0 |
| 2005-10-12 09:05:00 | AAPL | Stock | 1.7204 | 1.7211 | 1.7136 | 1.715 | 6616064.0 |
| 2005-10-12 09:10:00 | AAPL | Stock | 1.7157 | 1.7161 | 1.7114 | 1.7136 | 5289004.0 |
| 2005-10-12 09:15:00 | AAPL | Stock | 1.7139 | 1.7279 | 1.7139 | 1.7275 | 7755328.0 |
| 2005-10-12 09:20:00 | AAPL | Stock | 1.7271 | 1.7304 | 1.7196 | 1.7271 | 11338544.0 |
| 2005-10-12 09:25:00 | AAPL | Stock | 1.7279 | 1.7404 | 1.7268 | 1.7375 | 16826740.0 |
| 2005-10-12 09:30:00 | AAPL | Stock | 1.7375 | 1.7389 | 1.7096 | 1.7243 | 156697688.0 |
| 2005-10-12 09:35:00 | AAPL | Stock | 1.7243 | 1.7375 | 1.7243 | 1.7346 | 94193904.0 |
| 2005-10-12 09:40:00 | AAPL | Stock | 1.735 | 1.7457 | 1.7286 | 1.7436 | 87099012.0 |
| 2005-10-12 09:45:00 | AAPL | Stock | 1.7436 | 1.7736 | 1.7411 | 1.7657 | 91955080.0 |
| 2005-10-12 09:50:00 | AAPL | Stock | 1.7657 | 1.7679 | 1.7493 | 1.7571 | 89337920.0 |
| 2005-10-12 09:55:00 | AAPL | Stock | 1.7571 | 1.7743 | 1.7536 | 1.7675 | 61219004.0 |
| 2005-10-12 10:00:00 | AAPL | Stock | 1.7675 | 1.7814 | 1.7668 | 1.7704 | 72134132.0 |
| 2005-10-12 10:05:00 | AAPL | Stock | 1.7707 | 1.7743 | 1.7554 | 1.7593 | 63923720.0 |
| 2005-10-12 10:10:00 | AAPL | Stock | 1.7589 | 1.7711 | 1.7582 | 1.7661 | 49062832.0 |
| 2005-10-12 10:15:00 | AAPL | Stock | 1.7657 | 1.77 | 1.7604 | 1.7636 | 29435644.0 |
| 2005-10-12 10:20:00 | AAPL | Stock | 1.7636 | 1.7664 | 1.7618 | 1.7636 | 24156804.0 |
| 2005-10-12 10:25:00 | AAPL | Stock | 1.7636 | 1.7854 | 1.7636 | 1.7839 | 45200204.0 |
| 2005-10-12 10:30:00 | AAPL | Stock | 1.7839 | 1.7846 | 1.7746 | 1.7829 | 32015872.0 |
| 2005-10-12 10:35:00 | AAPL | Stock | 1.7829 | 1.7929 | 1.7768 | 1.7832 | 55795964.0 |
> showing 50 of 210,002 rows — these rows as CSV