PREVIEW / stock_5min / 2007-07-26
file: by_date/stock_5min/2007/2007-07-26.parquet size: 4.5 MB rows: 315,052 symbols: 3,110
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-07-26 09:30:00 | AAPL | Stock | 5.2111 | 5.2679 | 5.1764 | 5.1868 | 79300844.0 |
| 2007-07-26 09:35:00 | AAPL | Stock | 5.1868 | 5.19 | 5.0732 | 5.1504 | 72427208.0 |
| 2007-07-26 09:40:00 | AAPL | Stock | 5.15 | 5.1875 | 5.1071 | 5.1857 | 46693080.0 |
| 2007-07-26 09:45:00 | AAPL | Stock | 5.1857 | 5.2143 | 5.1543 | 5.2143 | 50950032.0 |
| 2007-07-26 09:50:00 | AAPL | Stock | 5.2143 | 5.2321 | 5.1739 | 5.1811 | 54062792.0 |
| 2007-07-26 09:55:00 | AAPL | Stock | 5.1802 | 5.2404 | 5.1762 | 5.22 | 51114532.0 |
| 2007-07-26 10:00:00 | AAPL | Stock | 5.2204 | 5.2296 | 5.1921 | 5.2143 | 45253236.0 |
| 2007-07-26 10:05:00 | AAPL | Stock | 5.2143 | 5.2229 | 5.1943 | 5.2164 | 28684712.0 |
| 2007-07-26 10:10:00 | AAPL | Stock | 5.2157 | 5.2486 | 5.2028 | 5.2425 | 48111000.0 |
| 2007-07-26 10:15:00 | AAPL | Stock | 5.2418 | 5.2511 | 5.2028 | 5.2282 | 34707232.0 |
| 2007-07-26 10:20:00 | AAPL | Stock | 5.2275 | 5.2507 | 5.2218 | 5.2296 | 25273500.0 |
| 2007-07-26 10:25:00 | AAPL | Stock | 5.2304 | 5.2311 | 5.2054 | 5.2271 | 24023300.0 |
| 2007-07-26 10:30:00 | AAPL | Stock | 5.2271 | 5.2446 | 5.2268 | 5.2386 | 27988800.0 |
| 2007-07-26 10:35:00 | AAPL | Stock | 5.2389 | 5.2757 | 5.2196 | 5.2386 | 30923564.0 |
| 2007-07-26 10:40:00 | AAPL | Stock | 5.2371 | 5.2782 | 5.2336 | 5.2554 | 41178956.0 |
| 2007-07-26 10:45:00 | AAPL | Stock | 5.2564 | 5.2921 | 5.2282 | 5.2786 | 40536636.0 |
| 2007-07-26 10:50:00 | AAPL | Stock | 5.2779 | 5.2907 | 5.2529 | 5.2746 | 29497356.0 |
| 2007-07-26 10:55:00 | AAPL | Stock | 5.2746 | 5.3036 | 5.2746 | 5.2929 | 34021092.0 |
| 2007-07-26 11:00:00 | AAPL | Stock | 5.2929 | 5.2957 | 5.2739 | 5.2772 | 27456800.0 |
| 2007-07-26 11:05:00 | AAPL | Stock | 5.2775 | 5.2779 | 5.2346 | 5.2564 | 37512664.0 |
| 2007-07-26 11:10:00 | AAPL | Stock | 5.2564 | 5.2768 | 5.2482 | 5.275 | 21842912.0 |
| 2007-07-26 11:15:00 | AAPL | Stock | 5.2746 | 5.2764 | 5.2275 | 5.245 | 35353192.0 |
| 2007-07-26 11:20:00 | AAPL | Stock | 5.245 | 5.2589 | 5.2371 | 5.2425 | 20258728.0 |
| 2007-07-26 11:25:00 | AAPL | Stock | 5.2421 | 5.2529 | 5.2375 | 5.2436 | 12937372.0 |
| 2007-07-26 11:30:00 | AAPL | Stock | 5.2439 | 5.25 | 5.2179 | 5.24 | 30288356.0 |
| 2007-07-26 11:35:00 | AAPL | Stock | 5.24 | 5.2589 | 5.2357 | 5.2571 | 23701692.0 |
| 2007-07-26 11:40:00 | AAPL | Stock | 5.2561 | 5.2657 | 5.25 | 5.2536 | 15642144.0 |
| 2007-07-26 11:45:00 | AAPL | Stock | 5.2529 | 5.2554 | 5.2389 | 5.2407 | 15599668.0 |
| 2007-07-26 11:50:00 | AAPL | Stock | 5.2404 | 5.2589 | 5.24 | 5.2589 | 11900476.0 |
| 2007-07-26 11:55:00 | AAPL | Stock | 5.2589 | 5.2732 | 5.2539 | 5.2679 | 20390300.0 |
| 2007-07-26 12:00:00 | AAPL | Stock | 5.2686 | 5.2746 | 5.25 | 5.2607 | 14162176.0 |
| 2007-07-26 12:05:00 | AAPL | Stock | 5.2611 | 5.2629 | 5.2446 | 5.2589 | 15493128.0 |
| 2007-07-26 12:10:00 | AAPL | Stock | 5.2593 | 5.2614 | 5.2464 | 5.25 | 12157152.0 |
| 2007-07-26 12:15:00 | AAPL | Stock | 5.25 | 5.2554 | 5.2429 | 5.2482 | 12698364.0 |
| 2007-07-26 12:20:00 | AAPL | Stock | 5.2486 | 5.2489 | 5.2293 | 5.2332 | 15794296.0 |
| 2007-07-26 12:25:00 | AAPL | Stock | 5.2331 | 5.2489 | 5.2304 | 5.2418 | 11231332.0 |
| 2007-07-26 12:30:00 | AAPL | Stock | 5.2421 | 5.2454 | 5.2346 | 5.2389 | 13078044.0 |
| 2007-07-26 12:35:00 | AAPL | Stock | 5.2386 | 5.2429 | 5.1979 | 5.2143 | 34249180.0 |
| 2007-07-26 12:40:00 | AAPL | Stock | 5.2141 | 5.2179 | 5.1982 | 5.205 | 19814844.0 |
| 2007-07-26 12:45:00 | AAPL | Stock | 5.2054 | 5.21 | 5.1643 | 5.205 | 37305436.0 |
| 2007-07-26 12:50:00 | AAPL | Stock | 5.205 | 5.2246 | 5.1993 | 5.2154 | 16308152.0 |
| 2007-07-26 12:55:00 | AAPL | Stock | 5.2154 | 5.2332 | 5.2143 | 5.2196 | 15777664.0 |
| 2007-07-26 13:00:00 | AAPL | Stock | 5.2218 | 5.225 | 5.2018 | 5.2098 | 11399976.0 |
| 2007-07-26 13:05:00 | AAPL | Stock | 5.21 | 5.2182 | 5.185 | 5.1869 | 17867864.0 |
| 2007-07-26 13:10:00 | AAPL | Stock | 5.1871 | 5.2129 | 5.1786 | 5.2036 | 12999364.0 |
| 2007-07-26 13:15:00 | AAPL | Stock | 5.2036 | 5.2132 | 5.1982 | 5.1993 | 9153648.0 |
| 2007-07-26 13:20:00 | AAPL | Stock | 5.2 | 5.2054 | 5.1821 | 5.1921 | 12504604.0 |
| 2007-07-26 13:25:00 | AAPL | Stock | 5.1918 | 5.1918 | 5.1786 | 5.1886 | 15823304.0 |
| 2007-07-26 13:30:00 | AAPL | Stock | 5.1886 | 5.1982 | 5.1821 | 5.1875 | 9661736.0 |
| 2007-07-26 13:35:00 | AAPL | Stock | 5.1875 | 5.1961 | 5.1699 | 5.1782 | 17006612.0 |
> showing 50 of 315,052 rows — these rows as CSV