PREVIEW / stock_5min / 2007-12-07
file: by_date/stock_5min/2007/2007-12-07.parquet size: 4.3 MB rows: 316,150 symbols: 3,235
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-12-07 04:15:00 | AAPL | Stock | 6.7643 | 6.7643 | 6.7643 | 6.7643 | 11200.0 |
| 2007-12-07 07:20:00 | AAPL | Stock | 6.7786 | 6.7786 | 6.7786 | 6.7786 | 28000.0 |
| 2007-12-07 07:40:00 | AAPL | Stock | 6.7679 | 6.7679 | 6.7607 | 6.7607 | 34608.0 |
| 2007-12-07 07:50:00 | AAPL | Stock | 6.7614 | 6.7625 | 6.7614 | 6.7625 | 43540.0 |
| 2007-12-07 08:00:00 | AAPL | Stock | 6.7675 | 6.7782 | 6.7607 | 6.7607 | 297164.0 |
| 2007-12-07 08:05:00 | AAPL | Stock | 6.7643 | 6.7786 | 6.7643 | 6.7775 | 253148.0 |
| 2007-12-07 08:10:00 | AAPL | Stock | 6.7782 | 6.7854 | 6.77 | 6.7732 | 201908.0 |
| 2007-12-07 08:15:00 | AAPL | Stock | 6.775 | 6.7775 | 6.7679 | 6.7679 | 282408.0 |
| 2007-12-07 08:20:00 | AAPL | Stock | 6.7743 | 6.775 | 6.7679 | 6.7689 | 288764.0 |
| 2007-12-07 08:25:00 | AAPL | Stock | 6.7686 | 6.7786 | 6.7679 | 6.775 | 309848.0 |
| 2007-12-07 08:30:00 | AAPL | Stock | 6.7775 | 6.825 | 6.7775 | 6.8214 | 2722608.0 |
| 2007-12-07 08:35:00 | AAPL | Stock | 6.8221 | 6.8382 | 6.7979 | 6.8193 | 3472728.0 |
| 2007-12-07 08:40:00 | AAPL | Stock | 6.8186 | 6.8214 | 6.7839 | 6.8179 | 1057672.0 |
| 2007-12-07 08:45:00 | AAPL | Stock | 6.8168 | 6.8211 | 6.8107 | 6.8161 | 633024.0 |
| 2007-12-07 08:50:00 | AAPL | Stock | 6.8161 | 6.8161 | 6.8 | 6.8029 | 691516.0 |
| 2007-12-07 08:55:00 | AAPL | Stock | 6.8046 | 6.8071 | 6.7968 | 6.7971 | 490028.0 |
| 2007-12-07 09:00:00 | AAPL | Stock | 6.7968 | 6.8018 | 6.7914 | 6.7932 | 662396.0 |
| 2007-12-07 09:05:00 | AAPL | Stock | 6.7904 | 6.7964 | 6.7857 | 6.7964 | 1141000.0 |
| 2007-12-07 09:10:00 | AAPL | Stock | 6.7975 | 6.8025 | 6.7929 | 6.8004 | 686140.0 |
| 2007-12-07 09:15:00 | AAPL | Stock | 6.8011 | 6.8086 | 6.7968 | 6.7968 | 238896.0 |
| 2007-12-07 09:20:00 | AAPL | Stock | 6.7964 | 6.8039 | 6.7807 | 6.8011 | 738556.0 |
| 2007-12-07 09:25:00 | AAPL | Stock | 6.8018 | 6.8125 | 6.7975 | 6.8004 | 1887424.0 |
| 2007-12-07 09:30:00 | AAPL | Stock | 6.8 | 6.8086 | 6.7714 | 6.7771 | 34730836.0 |
| 2007-12-07 09:35:00 | AAPL | Stock | 6.7771 | 6.7932 | 6.7468 | 6.76 | 26542376.0 |
| 2007-12-07 09:40:00 | AAPL | Stock | 6.7604 | 6.7821 | 6.7495 | 6.7596 | 24231592.0 |
| 2007-12-07 09:45:00 | AAPL | Stock | 6.76 | 6.7671 | 6.7261 | 6.7286 | 24064992.0 |
| 2007-12-07 09:50:00 | AAPL | Stock | 6.7275 | 6.7375 | 6.7157 | 6.7332 | 27450696.0 |
| 2007-12-07 09:55:00 | AAPL | Stock | 6.7346 | 6.7621 | 6.7318 | 6.7536 | 18250680.0 |
| 2007-12-07 10:00:00 | AAPL | Stock | 6.7539 | 6.7768 | 6.7439 | 6.7661 | 17916976.0 |
| 2007-12-07 10:05:00 | AAPL | Stock | 6.7668 | 6.7746 | 6.7389 | 6.74 | 15937432.0 |
| 2007-12-07 10:10:00 | AAPL | Stock | 6.74 | 6.7586 | 6.7329 | 6.7568 | 13740552.0 |
| 2007-12-07 10:15:00 | AAPL | Stock | 6.7564 | 6.7629 | 6.7432 | 6.7625 | 12288444.0 |
| 2007-12-07 10:20:00 | AAPL | Stock | 6.7629 | 6.7739 | 6.7518 | 6.7557 | 12050248.0 |
| 2007-12-07 10:25:00 | AAPL | Stock | 6.7554 | 6.7732 | 6.7554 | 6.7636 | 9200772.0 |
| 2007-12-07 10:30:00 | AAPL | Stock | 6.7632 | 6.7679 | 6.7557 | 6.7621 | 10404660.0 |
| 2007-12-07 10:35:00 | AAPL | Stock | 6.7629 | 6.7957 | 6.7604 | 6.7914 | 17048388.0 |
| 2007-12-07 10:40:00 | AAPL | Stock | 6.7921 | 6.8029 | 6.7829 | 6.7854 | 14531440.0 |
| 2007-12-07 10:45:00 | AAPL | Stock | 6.7854 | 6.8004 | 6.7829 | 6.7982 | 8902404.0 |
| 2007-12-07 10:50:00 | AAPL | Stock | 6.7979 | 6.8125 | 6.795 | 6.8021 | 14450268.0 |
| 2007-12-07 10:55:00 | AAPL | Stock | 6.8018 | 6.8139 | 6.7893 | 6.8125 | 11277420.0 |
| 2007-12-07 11:00:00 | AAPL | Stock | 6.8132 | 6.8214 | 6.8089 | 6.8195 | 18297412.0 |
| 2007-12-07 11:05:00 | AAPL | Stock | 6.8196 | 6.8207 | 6.8018 | 6.8054 | 9814196.0 |
| 2007-12-07 11:10:00 | AAPL | Stock | 6.805 | 6.8125 | 6.8 | 6.8036 | 8075676.0 |
| 2007-12-07 11:15:00 | AAPL | Stock | 6.8039 | 6.8071 | 6.7946 | 6.7946 | 6867700.0 |
| 2007-12-07 11:20:00 | AAPL | Stock | 6.7946 | 6.7968 | 6.7871 | 6.7918 | 6887468.0 |
| 2007-12-07 11:25:00 | AAPL | Stock | 6.7923 | 6.8014 | 6.7893 | 6.7979 | 6971720.0 |
| 2007-12-07 11:30:00 | AAPL | Stock | 6.7971 | 6.81 | 6.7961 | 6.8046 | 6363392.0 |
| 2007-12-07 11:35:00 | AAPL | Stock | 6.8064 | 6.82 | 6.8036 | 6.8107 | 11187708.0 |
| 2007-12-07 11:40:00 | AAPL | Stock | 6.8111 | 6.8196 | 6.8093 | 6.8175 | 9582552.0 |
| 2007-12-07 11:45:00 | AAPL | Stock | 6.8182 | 6.8332 | 6.8107 | 6.8325 | 15739024.0 |
> showing 50 of 316,150 rows — these rows as CSV