PREVIEW / stock_5min / 2008-05-14
file: by_date/stock_5min/2008/2008-05-14.parquet size: 4.4 MB rows: 317,061 symbols: 3,324
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-14 04:40:00 | AAPL | Stock | 6.7975 | 6.7975 | 6.7975 | 6.7975 | 11200.0 |
| 2008-05-14 07:45:00 | AAPL | Stock | 6.7879 | 6.7879 | 6.7875 | 6.7875 | 9800.0 |
| 2008-05-14 07:55:00 | AAPL | Stock | 6.7943 | 6.7943 | 6.7943 | 6.7943 | 5600.0 |
| 2008-05-14 08:00:00 | AAPL | Stock | 6.7843 | 6.7904 | 6.7836 | 6.7882 | 129500.0 |
| 2008-05-14 08:05:00 | AAPL | Stock | 6.7857 | 6.7946 | 6.7857 | 6.7939 | 179312.0 |
| 2008-05-14 08:10:00 | AAPL | Stock | 6.795 | 6.81 | 6.795 | 6.8025 | 240128.0 |
| 2008-05-14 08:15:00 | AAPL | Stock | 6.8025 | 6.8146 | 6.8025 | 6.8125 | 277620.0 |
| 2008-05-14 08:20:00 | AAPL | Stock | 6.8118 | 6.8161 | 6.805 | 6.8075 | 420280.0 |
| 2008-05-14 08:25:00 | AAPL | Stock | 6.8079 | 6.8139 | 6.8032 | 6.8111 | 170156.0 |
| 2008-05-14 08:30:00 | AAPL | Stock | 6.8139 | 6.8393 | 6.8136 | 6.8325 | 1190588.0 |
| 2008-05-14 08:35:00 | AAPL | Stock | 6.8321 | 6.8464 | 6.8293 | 6.8393 | 808584.0 |
| 2008-05-14 08:40:00 | AAPL | Stock | 6.8375 | 6.8457 | 6.8375 | 6.8418 | 454496.0 |
| 2008-05-14 08:45:00 | AAPL | Stock | 6.8425 | 6.8429 | 6.8375 | 6.8375 | 616392.0 |
| 2008-05-14 08:50:00 | AAPL | Stock | 6.8361 | 6.8393 | 6.8339 | 6.835 | 410620.0 |
| 2008-05-14 08:55:00 | AAPL | Stock | 6.8343 | 6.8375 | 6.8307 | 6.8339 | 199780.0 |
| 2008-05-14 09:00:00 | AAPL | Stock | 6.8339 | 6.8389 | 6.8321 | 6.8375 | 391692.0 |
| 2008-05-14 09:05:00 | AAPL | Stock | 6.8357 | 6.8393 | 6.835 | 6.8375 | 248780.0 |
| 2008-05-14 09:10:00 | AAPL | Stock | 6.8375 | 6.8393 | 6.8321 | 6.835 | 390656.0 |
| 2008-05-14 09:15:00 | AAPL | Stock | 6.8332 | 6.8354 | 6.8304 | 6.8318 | 223272.0 |
| 2008-05-14 09:20:00 | AAPL | Stock | 6.8332 | 6.8336 | 6.825 | 6.8286 | 317240.0 |
| 2008-05-14 09:25:00 | AAPL | Stock | 6.8286 | 6.8343 | 6.8264 | 6.8293 | 446376.0 |
| 2008-05-14 09:30:00 | AAPL | Stock | 6.8296 | 6.8396 | 6.8214 | 6.8268 | 20444396.0 |
| 2008-05-14 09:35:00 | AAPL | Stock | 6.8271 | 6.8571 | 6.8261 | 6.8568 | 19147408.0 |
| 2008-05-14 09:40:00 | AAPL | Stock | 6.8568 | 6.8636 | 6.8484 | 6.8532 | 20459740.0 |
| 2008-05-14 09:45:00 | AAPL | Stock | 6.8539 | 6.8657 | 6.8482 | 6.8579 | 16606240.0 |
| 2008-05-14 09:50:00 | AAPL | Stock | 6.8575 | 6.8618 | 6.8271 | 6.8332 | 22940288.0 |
| 2008-05-14 09:55:00 | AAPL | Stock | 6.8332 | 6.846 | 6.8268 | 6.8343 | 14555464.0 |
| 2008-05-14 10:00:00 | AAPL | Stock | 6.835 | 6.8475 | 6.8286 | 6.84 | 11879784.0 |
| 2008-05-14 10:05:00 | AAPL | Stock | 6.84 | 6.84 | 6.8043 | 6.8232 | 24562636.0 |
| 2008-05-14 10:10:00 | AAPL | Stock | 6.8225 | 6.8307 | 6.8114 | 6.8157 | 12577264.0 |
| 2008-05-14 10:15:00 | AAPL | Stock | 6.8161 | 6.8354 | 6.8143 | 6.8268 | 9861432.0 |
| 2008-05-14 10:20:00 | AAPL | Stock | 6.8271 | 6.8279 | 6.8054 | 6.8229 | 11841536.0 |
| 2008-05-14 10:25:00 | AAPL | Stock | 6.8232 | 6.8261 | 6.8143 | 6.8161 | 8790012.0 |
| 2008-05-14 10:30:00 | AAPL | Stock | 6.8168 | 6.84 | 6.8107 | 6.8282 | 14523124.0 |
| 2008-05-14 10:35:00 | AAPL | Stock | 6.8282 | 6.8446 | 6.8264 | 6.8364 | 9916200.0 |
| 2008-05-14 10:40:00 | AAPL | Stock | 6.8355 | 6.8418 | 6.8221 | 6.8239 | 6915748.0 |
| 2008-05-14 10:45:00 | AAPL | Stock | 6.8239 | 6.8264 | 6.8139 | 6.8171 | 8331260.0 |
| 2008-05-14 10:50:00 | AAPL | Stock | 6.8179 | 6.8214 | 6.8054 | 6.8054 | 9189404.0 |
| 2008-05-14 10:55:00 | AAPL | Stock | 6.8054 | 6.8057 | 6.7768 | 6.7879 | 28536284.0 |
| 2008-05-14 11:00:00 | AAPL | Stock | 6.7879 | 6.7971 | 6.7839 | 6.7904 | 12431524.0 |
| 2008-05-14 11:05:00 | AAPL | Stock | 6.7896 | 6.8007 | 6.7861 | 6.7987 | 7296212.0 |
| 2008-05-14 11:10:00 | AAPL | Stock | 6.7975 | 6.8036 | 6.7889 | 6.796 | 7296940.0 |
| 2008-05-14 11:15:00 | AAPL | Stock | 6.7961 | 6.8018 | 6.7929 | 6.7982 | 4684736.0 |
| 2008-05-14 11:20:00 | AAPL | Stock | 6.7986 | 6.8029 | 6.7871 | 6.7871 | 7152488.0 |
| 2008-05-14 11:25:00 | AAPL | Stock | 6.7875 | 6.7918 | 6.7739 | 6.7868 | 15222004.0 |
| 2008-05-14 11:30:00 | AAPL | Stock | 6.7871 | 6.7907 | 6.7689 | 6.7714 | 10797696.0 |
| 2008-05-14 11:35:00 | AAPL | Stock | 6.7718 | 6.7843 | 6.77 | 6.7843 | 8157352.0 |
| 2008-05-14 11:40:00 | AAPL | Stock | 6.7846 | 6.8061 | 6.7839 | 6.8 | 11654104.0 |
| 2008-05-14 11:45:00 | AAPL | Stock | 6.8007 | 6.8029 | 6.7946 | 6.7982 | 4029228.0 |
| 2008-05-14 11:50:00 | AAPL | Stock | 6.7989 | 6.8036 | 6.7836 | 6.7868 | 9097704.0 |
> showing 50 of 317,061 rows — these rows as CSV