PREVIEW / stock_5min / 2005-10-13
file: by_date/stock_5min/2005/2005-10-13.parquet size: 2.9 MB rows: 207,106 symbols: 2,087
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-13 07:55:00 | AAPL | Stock | 1.7589 | 1.7589 | 1.7589 | 1.7589 | 2800.0 |
| 2005-10-13 08:00:00 | AAPL | Stock | 1.7682 | 1.7775 | 1.7682 | 1.7714 | 306348.0 |
| 2005-10-13 08:05:00 | AAPL | Stock | 1.7682 | 1.7704 | 1.7679 | 1.7679 | 109200.0 |
| 2005-10-13 08:10:00 | AAPL | Stock | 1.7679 | 1.7696 | 1.7625 | 1.7625 | 106988.0 |
| 2005-10-13 08:15:00 | AAPL | Stock | 1.7636 | 1.7654 | 1.7636 | 1.7654 | 50400.0 |
| 2005-10-13 08:20:00 | AAPL | Stock | 1.7661 | 1.7661 | 1.7621 | 1.7625 | 282240.0 |
| 2005-10-13 08:25:00 | AAPL | Stock | 1.765 | 1.7675 | 1.765 | 1.7675 | 40880.0 |
| 2005-10-13 08:30:00 | AAPL | Stock | 1.765 | 1.7704 | 1.7643 | 1.7679 | 111720.0 |
| 2005-10-13 08:35:00 | AAPL | Stock | 1.7682 | 1.7682 | 1.7625 | 1.7643 | 229600.0 |
| 2005-10-13 08:40:00 | AAPL | Stock | 1.7639 | 1.7661 | 1.7639 | 1.7661 | 100072.0 |
| 2005-10-13 08:45:00 | AAPL | Stock | 1.7661 | 1.7679 | 1.7625 | 1.7643 | 198800.0 |
| 2005-10-13 08:50:00 | AAPL | Stock | 1.7657 | 1.7679 | 1.7657 | 1.7675 | 84000.0 |
| 2005-10-13 08:55:00 | AAPL | Stock | 1.7657 | 1.7679 | 1.7643 | 1.7664 | 468440.0 |
| 2005-10-13 09:00:00 | AAPL | Stock | 1.7632 | 1.7657 | 1.7632 | 1.7643 | 58800.0 |
| 2005-10-13 09:05:00 | AAPL | Stock | 1.7643 | 1.7654 | 1.7607 | 1.7607 | 354732.0 |
| 2005-10-13 09:10:00 | AAPL | Stock | 1.7607 | 1.7636 | 1.7593 | 1.7636 | 136724.0 |
| 2005-10-13 09:15:00 | AAPL | Stock | 1.7611 | 1.7636 | 1.7611 | 1.7625 | 61600.0 |
| 2005-10-13 09:20:00 | AAPL | Stock | 1.7618 | 1.7618 | 1.7586 | 1.7589 | 61768.0 |
| 2005-10-13 09:25:00 | AAPL | Stock | 1.7618 | 1.7721 | 1.7593 | 1.7689 | 2960244.0 |
| 2005-10-13 09:30:00 | AAPL | Stock | 1.7657 | 1.7896 | 1.7596 | 1.7836 | 37584596.0 |
| 2005-10-13 09:35:00 | AAPL | Stock | 1.7839 | 1.7893 | 1.7768 | 1.7821 | 28634928.0 |
| 2005-10-13 09:40:00 | AAPL | Stock | 1.7821 | 1.7857 | 1.7729 | 1.7771 | 25327596.0 |
| 2005-10-13 09:45:00 | AAPL | Stock | 1.7764 | 1.7782 | 1.7643 | 1.775 | 18070696.0 |
| 2005-10-13 09:50:00 | AAPL | Stock | 1.775 | 1.7757 | 1.7657 | 1.7664 | 11994052.0 |
| 2005-10-13 09:55:00 | AAPL | Stock | 1.7664 | 1.7786 | 1.765 | 1.775 | 16750916.0 |
| 2005-10-13 10:00:00 | AAPL | Stock | 1.7746 | 1.7796 | 1.7696 | 1.7786 | 13205612.0 |
| 2005-10-13 10:05:00 | AAPL | Stock | 1.7786 | 1.7818 | 1.7743 | 1.7807 | 20668872.0 |
| 2005-10-13 10:10:00 | AAPL | Stock | 1.7804 | 1.7839 | 1.7793 | 1.7814 | 15301496.0 |
| 2005-10-13 10:15:00 | AAPL | Stock | 1.7818 | 1.7854 | 1.7804 | 1.7843 | 16922416.0 |
| 2005-10-13 10:20:00 | AAPL | Stock | 1.7843 | 1.8004 | 1.7689 | 1.7939 | 36886360.0 |
| 2005-10-13 10:25:00 | AAPL | Stock | 1.7939 | 1.8046 | 1.7689 | 1.8018 | 23593920.0 |
| 2005-10-13 10:30:00 | AAPL | Stock | 1.8014 | 1.8107 | 1.8007 | 1.8104 | 28118720.0 |
| 2005-10-13 10:35:00 | AAPL | Stock | 1.8104 | 1.8279 | 1.8082 | 1.8271 | 38830792.0 |
| 2005-10-13 10:40:00 | AAPL | Stock | 1.8271 | 1.8325 | 1.8214 | 1.8268 | 45671164.0 |
| 2005-10-13 10:45:00 | AAPL | Stock | 1.8268 | 1.8336 | 1.7689 | 1.8301 | 28887432.0 |
| 2005-10-13 10:50:00 | AAPL | Stock | 1.83 | 1.8318 | 1.7657 | 1.8239 | 31082576.0 |
| 2005-10-13 10:55:00 | AAPL | Stock | 1.8239 | 1.8243 | 1.8193 | 1.8214 | 19735072.0 |
| 2005-10-13 11:00:00 | AAPL | Stock | 1.8214 | 1.8271 | 1.8204 | 1.8243 | 20804616.0 |
| 2005-10-13 11:05:00 | AAPL | Stock | 1.8236 | 1.8243 | 1.8196 | 1.8236 | 13738844.0 |
| 2005-10-13 11:10:00 | AAPL | Stock | 1.8236 | 1.8279 | 1.8221 | 1.8239 | 11128236.0 |
| 2005-10-13 11:15:00 | AAPL | Stock | 1.8243 | 1.8268 | 1.8207 | 1.8239 | 9683856.0 |
| 2005-10-13 11:20:00 | AAPL | Stock | 1.8239 | 1.8314 | 1.8239 | 1.8311 | 16334360.0 |
| 2005-10-13 11:25:00 | AAPL | Stock | 1.8311 | 1.8371 | 1.8311 | 1.8361 | 18854668.0 |
| 2005-10-13 11:30:00 | AAPL | Stock | 1.8364 | 1.8364 | 1.8268 | 1.8311 | 16130884.0 |
| 2005-10-13 11:35:00 | AAPL | Stock | 1.8296 | 1.8339 | 1.8293 | 1.8321 | 24258780.0 |
| 2005-10-13 11:40:00 | AAPL | Stock | 1.8329 | 1.8382 | 1.8325 | 1.8343 | 16313612.0 |
| 2005-10-13 11:45:00 | AAPL | Stock | 1.8343 | 1.8375 | 1.8325 | 1.8343 | 17020612.0 |
| 2005-10-13 11:50:00 | AAPL | Stock | 1.8339 | 1.84 | 1.8339 | 1.8364 | 19020344.0 |
| 2005-10-13 11:55:00 | AAPL | Stock | 1.8364 | 1.8396 | 1.8354 | 1.8375 | 25482324.0 |
| 2005-10-13 12:00:00 | AAPL | Stock | 1.8368 | 1.8493 | 1.8361 | 1.8471 | 27920620.0 |
> showing 50 of 207,106 rows — these rows as CSV