PREVIEW / stock_5min / 2008-05-16
file: by_date/stock_5min/2008/2008-05-16.parquet size: 4.4 MB rows: 317,522 symbols: 3,290
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-05-16 05:30:00 | AAPL | Stock | 6.7857 | 6.79 | 6.7857 | 6.79 | 28000.0 |
| 2008-05-16 07:05:00 | AAPL | Stock | 6.8089 | 6.8089 | 6.8 | 6.8 | 26600.0 |
| 2008-05-16 07:10:00 | AAPL | Stock | 6.8 | 6.8 | 6.7875 | 6.7875 | 12600.0 |
| 2008-05-16 07:20:00 | AAPL | Stock | 6.7893 | 6.7893 | 6.7857 | 6.7893 | 224000.0 |
| 2008-05-16 07:25:00 | AAPL | Stock | 6.7893 | 6.7893 | 6.7893 | 6.7893 | 2800.0 |
| 2008-05-16 07:30:00 | AAPL | Stock | 6.7893 | 6.7957 | 6.7857 | 6.7957 | 19600.0 |
| 2008-05-16 07:35:00 | AAPL | Stock | 6.7829 | 6.7946 | 6.7829 | 6.7946 | 14000.0 |
| 2008-05-16 07:40:00 | AAPL | Stock | 6.7929 | 6.7929 | 6.7857 | 6.7893 | 49280.0 |
| 2008-05-16 07:45:00 | AAPL | Stock | 6.7839 | 6.7839 | 6.7839 | 6.7839 | 5600.0 |
| 2008-05-16 07:50:00 | AAPL | Stock | 6.7821 | 6.7821 | 6.7811 | 6.7811 | 11200.0 |
| 2008-05-16 08:00:00 | AAPL | Stock | 6.7786 | 6.7929 | 6.7639 | 6.7643 | 462672.0 |
| 2008-05-16 08:05:00 | AAPL | Stock | 6.7643 | 6.7786 | 6.7625 | 6.7786 | 233436.0 |
| 2008-05-16 08:10:00 | AAPL | Stock | 6.7779 | 6.7804 | 6.7696 | 6.7696 | 220808.0 |
| 2008-05-16 08:15:00 | AAPL | Stock | 6.7714 | 6.7807 | 6.7679 | 6.775 | 279160.0 |
| 2008-05-16 08:20:00 | AAPL | Stock | 6.7754 | 6.7771 | 6.7754 | 6.7768 | 92540.0 |
| 2008-05-16 08:25:00 | AAPL | Stock | 6.7768 | 6.7804 | 6.7768 | 6.7786 | 95340.0 |
| 2008-05-16 08:30:00 | AAPL | Stock | 6.7786 | 6.7889 | 6.7786 | 6.7843 | 619220.0 |
| 2008-05-16 08:35:00 | AAPL | Stock | 6.785 | 6.7857 | 6.7821 | 6.785 | 226968.0 |
| 2008-05-16 08:40:00 | AAPL | Stock | 6.785 | 6.7854 | 6.7775 | 6.78 | 145852.0 |
| 2008-05-16 08:45:00 | AAPL | Stock | 6.7804 | 6.7854 | 6.7786 | 6.785 | 174804.0 |
| 2008-05-16 08:50:00 | AAPL | Stock | 6.7839 | 6.8018 | 6.7839 | 6.8018 | 444360.0 |
| 2008-05-16 08:55:00 | AAPL | Stock | 6.8018 | 6.8018 | 6.7936 | 6.7996 | 324884.0 |
| 2008-05-16 09:00:00 | AAPL | Stock | 6.7986 | 6.7986 | 6.7886 | 6.7907 | 306180.0 |
| 2008-05-16 09:05:00 | AAPL | Stock | 6.7907 | 6.7925 | 6.7875 | 6.7918 | 324660.0 |
| 2008-05-16 09:10:00 | AAPL | Stock | 6.7896 | 6.7896 | 6.7854 | 6.7889 | 379120.0 |
| 2008-05-16 09:15:00 | AAPL | Stock | 6.7886 | 6.7886 | 6.7786 | 6.7854 | 232092.0 |
| 2008-05-16 09:20:00 | AAPL | Stock | 6.7854 | 6.7932 | 6.7854 | 6.7879 | 285880.0 |
| 2008-05-16 09:25:00 | AAPL | Stock | 6.7864 | 6.7964 | 6.7714 | 6.7914 | 1382024.0 |
| 2008-05-16 09:30:00 | AAPL | Stock | 6.7918 | 6.7964 | 6.7679 | 6.7893 | 58807252.0 |
| 2008-05-16 09:35:00 | AAPL | Stock | 6.7893 | 6.7904 | 6.7543 | 6.7696 | 14082992.0 |
| 2008-05-16 09:40:00 | AAPL | Stock | 6.7686 | 6.7814 | 6.7525 | 6.76 | 20194496.0 |
| 2008-05-16 09:45:00 | AAPL | Stock | 6.76 | 6.7657 | 6.745 | 6.7654 | 13166664.0 |
| 2008-05-16 09:50:00 | AAPL | Stock | 6.7646 | 6.7936 | 6.7589 | 6.78 | 14175924.0 |
| 2008-05-16 09:55:00 | AAPL | Stock | 6.7806 | 6.7821 | 6.7632 | 6.7771 | 14505260.0 |
| 2008-05-16 10:00:00 | AAPL | Stock | 6.7771 | 6.7839 | 6.7607 | 6.7639 | 12987940.0 |
| 2008-05-16 10:05:00 | AAPL | Stock | 6.7637 | 6.7711 | 6.7468 | 6.7524 | 12764444.0 |
| 2008-05-16 10:10:00 | AAPL | Stock | 6.7529 | 6.7572 | 6.7279 | 6.7386 | 16061500.0 |
| 2008-05-16 10:15:00 | AAPL | Stock | 6.7386 | 6.7468 | 6.73 | 6.7343 | 11561620.0 |
| 2008-05-16 10:20:00 | AAPL | Stock | 6.7339 | 6.7355 | 6.6896 | 6.7073 | 25712792.0 |
| 2008-05-16 10:25:00 | AAPL | Stock | 6.7075 | 6.7171 | 6.7054 | 6.7146 | 10918572.0 |
| 2008-05-16 10:30:00 | AAPL | Stock | 6.7157 | 6.7414 | 6.7143 | 6.7396 | 12371744.0 |
| 2008-05-16 10:35:00 | AAPL | Stock | 6.7407 | 6.7418 | 6.7264 | 6.7382 | 11449872.0 |
| 2008-05-16 10:40:00 | AAPL | Stock | 6.7382 | 6.7464 | 6.7296 | 6.7382 | 9215864.0 |
| 2008-05-16 10:45:00 | AAPL | Stock | 6.7371 | 6.7382 | 6.7207 | 6.7236 | 7585032.0 |
| 2008-05-16 10:50:00 | AAPL | Stock | 6.7243 | 6.7271 | 6.7054 | 6.7093 | 8701448.0 |
| 2008-05-16 10:55:00 | AAPL | Stock | 6.7089 | 6.7186 | 6.7075 | 6.7129 | 7962080.0 |
| 2008-05-16 11:00:00 | AAPL | Stock | 6.7129 | 6.7136 | 6.6936 | 6.6939 | 11295760.0 |
| 2008-05-16 11:05:00 | AAPL | Stock | 6.6936 | 6.7107 | 6.6925 | 6.7079 | 9325848.0 |
| 2008-05-16 11:10:00 | AAPL | Stock | 6.7082 | 6.71 | 6.6837 | 6.6886 | 10230388.0 |
| 2008-05-16 11:15:00 | AAPL | Stock | 6.6879 | 6.7043 | 6.6786 | 6.6961 | 13989920.0 |
> showing 50 of 317,522 rows — these rows as CSV