PREVIEW / stock_5min / 2008-09-05
file: by_date/stock_5min/2008/2008-09-05.parquet size: 4.5 MB rows: 319,916 symbols: 3,304
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 |
|---|---|---|---|---|---|---|---|
| 2008-09-05 06:10:00 | AAPL | Stock | 5.7143 | 5.7143 | 5.7143 | 5.7143 | 5040.0 |
| 2008-09-05 07:10:00 | AAPL | Stock | 5.7143 | 5.7143 | 5.7143 | 5.7143 | 13720.0 |
| 2008-09-05 07:15:00 | AAPL | Stock | 5.735 | 5.7375 | 5.735 | 5.7375 | 30800.0 |
| 2008-09-05 07:20:00 | AAPL | Stock | 5.735 | 5.735 | 5.7321 | 5.7321 | 13720.0 |
| 2008-09-05 07:30:00 | AAPL | Stock | 5.7429 | 5.7443 | 5.7429 | 5.7443 | 39928.0 |
| 2008-09-05 07:50:00 | AAPL | Stock | 5.7607 | 5.7607 | 5.75 | 5.7507 | 25200.0 |
| 2008-09-05 08:00:00 | AAPL | Stock | 5.7536 | 5.7536 | 5.7196 | 5.7207 | 188692.0 |
| 2008-09-05 08:05:00 | AAPL | Stock | 5.7286 | 5.7321 | 5.7232 | 5.7232 | 119000.0 |
| 2008-09-05 08:10:00 | AAPL | Stock | 5.7246 | 5.7268 | 5.7207 | 5.7207 | 206920.0 |
| 2008-09-05 08:15:00 | AAPL | Stock | 5.725 | 5.725 | 5.7154 | 5.7154 | 48496.0 |
| 2008-09-05 08:20:00 | AAPL | Stock | 5.7207 | 5.7321 | 5.7207 | 5.7321 | 238924.0 |
| 2008-09-05 08:25:00 | AAPL | Stock | 5.7286 | 5.7321 | 5.7254 | 5.7286 | 63000.0 |
| 2008-09-05 08:30:00 | AAPL | Stock | 5.7286 | 5.7443 | 5.6429 | 5.6679 | 1359400.0 |
| 2008-09-05 08:35:00 | AAPL | Stock | 5.6654 | 5.6675 | 5.6168 | 5.6261 | 1282680.0 |
| 2008-09-05 08:40:00 | AAPL | Stock | 5.6286 | 5.6357 | 5.6211 | 5.6232 | 951888.0 |
| 2008-09-05 08:45:00 | AAPL | Stock | 5.6236 | 5.6518 | 5.6236 | 5.6461 | 740740.0 |
| 2008-09-05 08:50:00 | AAPL | Stock | 5.6461 | 5.6518 | 5.6429 | 5.6518 | 456372.0 |
| 2008-09-05 08:55:00 | AAPL | Stock | 5.6518 | 5.6786 | 5.6507 | 5.6604 | 469560.0 |
| 2008-09-05 09:00:00 | AAPL | Stock | 5.6593 | 5.6614 | 5.6536 | 5.6586 | 126868.0 |
| 2008-09-05 09:05:00 | AAPL | Stock | 5.6589 | 5.6589 | 5.6518 | 5.6554 | 182728.0 |
| 2008-09-05 09:10:00 | AAPL | Stock | 5.6589 | 5.7036 | 5.6586 | 5.6814 | 669340.0 |
| 2008-09-05 09:15:00 | AAPL | Stock | 5.6764 | 5.6943 | 5.675 | 5.6943 | 312340.0 |
| 2008-09-05 09:20:00 | AAPL | Stock | 5.6911 | 5.695 | 5.6843 | 5.6857 | 181972.0 |
| 2008-09-05 09:25:00 | AAPL | Stock | 5.6921 | 5.6929 | 5.6568 | 5.6646 | 1023400.0 |
| 2008-09-05 09:30:00 | AAPL | Stock | 5.6646 | 5.7214 | 5.6429 | 5.6936 | 25757256.0 |
| 2008-09-05 09:35:00 | AAPL | Stock | 5.6939 | 5.7407 | 5.6786 | 5.7275 | 21365064.0 |
| 2008-09-05 09:40:00 | AAPL | Stock | 5.7275 | 5.7654 | 5.7068 | 5.7282 | 19896688.0 |
| 2008-09-05 09:45:00 | AAPL | Stock | 5.7282 | 5.7732 | 5.7259 | 5.7522 | 18752636.0 |
| 2008-09-05 09:50:00 | AAPL | Stock | 5.7525 | 5.7689 | 5.7357 | 5.7686 | 13771156.0 |
| 2008-09-05 09:55:00 | AAPL | Stock | 5.7686 | 5.775 | 5.7429 | 5.7604 | 14329028.0 |
| 2008-09-05 10:00:00 | AAPL | Stock | 5.7614 | 5.7964 | 5.7414 | 5.7956 | 16986116.0 |
| 2008-09-05 10:05:00 | AAPL | Stock | 5.7957 | 5.8 | 5.7536 | 5.7643 | 18205992.0 |
| 2008-09-05 10:10:00 | AAPL | Stock | 5.7651 | 5.7651 | 5.7089 | 5.7143 | 17621128.0 |
| 2008-09-05 10:15:00 | AAPL | Stock | 5.7099 | 5.7257 | 5.6964 | 5.72 | 17327828.0 |
| 2008-09-05 10:20:00 | AAPL | Stock | 5.7207 | 5.7321 | 5.7054 | 5.7082 | 10591364.0 |
| 2008-09-05 10:25:00 | AAPL | Stock | 5.7071 | 5.7121 | 5.6786 | 5.6993 | 11027576.0 |
| 2008-09-05 10:30:00 | AAPL | Stock | 5.7012 | 5.7104 | 5.6786 | 5.6879 | 9488976.0 |
| 2008-09-05 10:35:00 | AAPL | Stock | 5.6893 | 5.7321 | 5.6871 | 5.7157 | 9967636.0 |
| 2008-09-05 10:40:00 | AAPL | Stock | 5.717 | 5.725 | 5.7107 | 5.7204 | 7060200.0 |
| 2008-09-05 10:45:00 | AAPL | Stock | 5.7204 | 5.7232 | 5.6857 | 5.6904 | 11770276.0 |
| 2008-09-05 10:50:00 | AAPL | Stock | 5.6904 | 5.6986 | 5.6725 | 5.69 | 9167340.0 |
| 2008-09-05 10:55:00 | AAPL | Stock | 5.6893 | 5.6964 | 5.6596 | 5.6768 | 10642828.0 |
| 2008-09-05 11:00:00 | AAPL | Stock | 5.6771 | 5.7004 | 5.6732 | 5.6904 | 8065876.0 |
| 2008-09-05 11:05:00 | AAPL | Stock | 5.69 | 5.7143 | 5.69 | 5.6921 | 6704432.0 |
| 2008-09-05 11:10:00 | AAPL | Stock | 5.6918 | 5.6946 | 5.6607 | 5.6664 | 8464540.0 |
| 2008-09-05 11:15:00 | AAPL | Stock | 5.6661 | 5.6682 | 5.6357 | 5.6357 | 14439992.0 |
| 2008-09-05 11:20:00 | AAPL | Stock | 5.6357 | 5.6714 | 5.6304 | 5.6711 | 11050956.0 |
| 2008-09-05 11:25:00 | AAPL | Stock | 5.6711 | 5.6971 | 5.6711 | 5.6882 | 10512012.0 |
| 2008-09-05 11:30:00 | AAPL | Stock | 5.6882 | 5.7018 | 5.68 | 5.6889 | 6023108.0 |
| 2008-09-05 11:35:00 | AAPL | Stock | 5.6879 | 5.6982 | 5.6707 | 5.6881 | 9169076.0 |
> showing 50 of 319,916 rows — these rows as CSV