PREVIEW / stock_5min / 2008-06-06
file: by_date/stock_5min/2008/2008-06-06.parquet size: 4.5 MB rows: 316,848 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-06-06 04:15:00 | AAPL | Stock | 6.7857 | 6.7857 | 6.7857 | 6.7857 | 2800.0 |
| 2008-06-06 04:25:00 | AAPL | Stock | 6.7857 | 6.7857 | 6.7857 | 6.7857 | 2800.0 |
| 2008-06-06 06:40:00 | AAPL | Stock | 6.7657 | 6.7657 | 6.7654 | 6.7654 | 5600.0 |
| 2008-06-06 07:10:00 | AAPL | Stock | 6.7857 | 6.7857 | 6.7857 | 6.7857 | 11200.0 |
| 2008-06-06 07:15:00 | AAPL | Stock | 6.7921 | 6.7921 | 6.7921 | 6.7921 | 2800.0 |
| 2008-06-06 07:20:00 | AAPL | Stock | 6.7929 | 6.7929 | 6.7929 | 6.7929 | 8400.0 |
| 2008-06-06 07:25:00 | AAPL | Stock | 6.7929 | 6.7929 | 6.7857 | 6.7857 | 27720.0 |
| 2008-06-06 07:30:00 | AAPL | Stock | 6.7857 | 6.7857 | 6.7786 | 6.7857 | 14000.0 |
| 2008-06-06 07:35:00 | AAPL | Stock | 6.7946 | 6.7957 | 6.7893 | 6.7914 | 25200.0 |
| 2008-06-06 07:40:00 | AAPL | Stock | 6.7857 | 6.7929 | 6.7857 | 6.7929 | 42000.0 |
| 2008-06-06 07:45:00 | AAPL | Stock | 6.7857 | 6.7857 | 6.7786 | 6.7854 | 44800.0 |
| 2008-06-06 07:50:00 | AAPL | Stock | 6.7718 | 6.7854 | 6.7664 | 6.775 | 40880.0 |
| 2008-06-06 07:55:00 | AAPL | Stock | 6.7718 | 6.7718 | 6.7718 | 6.7718 | 5600.0 |
| 2008-06-06 08:00:00 | AAPL | Stock | 6.7811 | 6.7964 | 6.7682 | 6.7857 | 834932.0 |
| 2008-06-06 08:05:00 | AAPL | Stock | 6.7857 | 6.7875 | 6.7857 | 6.7861 | 513548.0 |
| 2008-06-06 08:10:00 | AAPL | Stock | 6.7875 | 6.7907 | 6.7857 | 6.7893 | 539756.0 |
| 2008-06-06 08:15:00 | AAPL | Stock | 6.7879 | 6.7911 | 6.7857 | 6.7875 | 358792.0 |
| 2008-06-06 08:20:00 | AAPL | Stock | 6.7857 | 6.7857 | 6.7804 | 6.7857 | 186760.0 |
| 2008-06-06 08:25:00 | AAPL | Stock | 6.7861 | 6.7911 | 6.7843 | 6.7911 | 436688.0 |
| 2008-06-06 08:30:00 | AAPL | Stock | 6.7893 | 6.7929 | 6.7375 | 6.74 | 3154088.0 |
| 2008-06-06 08:35:00 | AAPL | Stock | 6.74 | 6.7421 | 6.725 | 6.7321 | 1489348.0 |
| 2008-06-06 08:40:00 | AAPL | Stock | 6.7321 | 6.7361 | 6.725 | 6.7325 | 1735188.0 |
| 2008-06-06 08:45:00 | AAPL | Stock | 6.7325 | 6.74 | 6.7311 | 6.7321 | 778932.0 |
| 2008-06-06 08:50:00 | AAPL | Stock | 6.7321 | 6.7321 | 6.7104 | 6.7175 | 1268960.0 |
| 2008-06-06 08:55:00 | AAPL | Stock | 6.7175 | 6.725 | 6.7168 | 6.7236 | 497756.0 |
| 2008-06-06 09:00:00 | AAPL | Stock | 6.7246 | 6.7254 | 6.7179 | 6.7239 | 740208.0 |
| 2008-06-06 09:05:00 | AAPL | Stock | 6.7229 | 6.7243 | 6.7182 | 6.7243 | 314580.0 |
| 2008-06-06 09:10:00 | AAPL | Stock | 6.7246 | 6.73 | 6.7232 | 6.7261 | 308756.0 |
| 2008-06-06 09:15:00 | AAPL | Stock | 6.7239 | 6.7239 | 6.7104 | 6.7107 | 533204.0 |
| 2008-06-06 09:20:00 | AAPL | Stock | 6.7107 | 6.7136 | 6.7 | 6.7039 | 733992.0 |
| 2008-06-06 09:25:00 | AAPL | Stock | 6.7061 | 6.7143 | 6.7 | 6.7129 | 1005928.0 |
| 2008-06-06 09:30:00 | AAPL | Stock | 6.7136 | 6.7254 | 6.6968 | 6.7157 | 23884952.0 |
| 2008-06-06 09:35:00 | AAPL | Stock | 6.7157 | 6.7482 | 6.7039 | 6.7418 | 20537048.0 |
| 2008-06-06 09:40:00 | AAPL | Stock | 6.7418 | 6.7593 | 6.7396 | 6.7504 | 20793108.0 |
| 2008-06-06 09:45:00 | AAPL | Stock | 6.75 | 6.7839 | 6.75 | 6.7621 | 30311652.0 |
| 2008-06-06 09:50:00 | AAPL | Stock | 6.7625 | 6.7683 | 6.7457 | 6.7639 | 16956436.0 |
| 2008-06-06 09:55:00 | AAPL | Stock | 6.7639 | 6.7839 | 6.7618 | 6.7771 | 19711972.0 |
| 2008-06-06 10:00:00 | AAPL | Stock | 6.7764 | 6.7768 | 6.7414 | 6.7432 | 23456776.0 |
| 2008-06-06 10:05:00 | AAPL | Stock | 6.7429 | 6.7561 | 6.7271 | 6.7289 | 16923284.0 |
| 2008-06-06 10:10:00 | AAPL | Stock | 6.7293 | 6.7571 | 6.7261 | 6.7486 | 12627188.0 |
| 2008-06-06 10:15:00 | AAPL | Stock | 6.7486 | 6.7621 | 6.7411 | 6.7561 | 10797248.0 |
| 2008-06-06 10:20:00 | AAPL | Stock | 6.7571 | 6.7589 | 6.7429 | 6.7529 | 7370300.0 |
| 2008-06-06 10:25:00 | AAPL | Stock | 6.7529 | 6.7579 | 6.7368 | 6.7443 | 8484532.0 |
| 2008-06-06 10:30:00 | AAPL | Stock | 6.7432 | 6.7434 | 6.7329 | 6.7375 | 10958416.0 |
| 2008-06-06 10:35:00 | AAPL | Stock | 6.7371 | 6.7379 | 6.7054 | 6.7071 | 18881716.0 |
| 2008-06-06 10:40:00 | AAPL | Stock | 6.7075 | 6.7143 | 6.7011 | 6.708 | 11549440.0 |
| 2008-06-06 10:45:00 | AAPL | Stock | 6.7071 | 6.7239 | 6.705 | 6.7239 | 10966844.0 |
| 2008-06-06 10:50:00 | AAPL | Stock | 6.7238 | 6.73 | 6.7136 | 6.7171 | 8618120.0 |
| 2008-06-06 10:55:00 | AAPL | Stock | 6.7171 | 6.73 | 6.7139 | 6.7236 | 7288932.0 |
| 2008-06-06 11:00:00 | AAPL | Stock | 6.7248 | 6.7288 | 6.7125 | 6.7211 | 7755244.0 |
> showing 50 of 316,848 rows — these rows as CSV