PREVIEW / stock_5min / 2006-11-24
file: by_date/stock_5min/2006/2006-11-24.parquet size: 1.8 MB rows: 122,978 symbols: 2,368
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 |
|---|---|---|---|---|---|---|---|
| 2006-11-24 05:10:00 | AAPL | Stock | 3.2143 | 3.2143 | 3.2143 | 3.2143 | 8400.0 |
| 2006-11-24 05:25:00 | AAPL | Stock | 3.2143 | 3.2143 | 3.2143 | 3.2143 | 2800.0 |
| 2006-11-24 05:35:00 | AAPL | Stock | 3.2143 | 3.2143 | 3.2143 | 3.2143 | 72800.0 |
| 2006-11-24 06:00:00 | AAPL | Stock | 3.2111 | 3.2111 | 3.2111 | 3.2111 | 2800.0 |
| 2006-11-24 06:05:00 | AAPL | Stock | 3.2111 | 3.2111 | 3.2111 | 3.2111 | 2800.0 |
| 2006-11-24 07:25:00 | AAPL | Stock | 3.2032 | 3.2032 | 3.2032 | 3.2032 | 5600.0 |
| 2006-11-24 07:35:00 | AAPL | Stock | 3.2032 | 3.2032 | 3.2032 | 3.2032 | 8036.0 |
| 2006-11-24 07:45:00 | AAPL | Stock | 3.1993 | 3.1993 | 3.1993 | 3.1993 | 2800.0 |
| 2006-11-24 07:50:00 | AAPL | Stock | 3.1986 | 3.2014 | 3.1964 | 3.1964 | 39200.0 |
| 2006-11-24 07:55:00 | AAPL | Stock | 3.1964 | 3.1964 | 3.1961 | 3.1964 | 31164.0 |
| 2006-11-24 08:00:00 | AAPL | Stock | 3.2 | 3.2179 | 3.1946 | 3.2114 | 1272852.0 |
| 2006-11-24 08:05:00 | AAPL | Stock | 3.2129 | 3.2143 | 3.2093 | 3.2132 | 747124.0 |
| 2006-11-24 08:10:00 | AAPL | Stock | 3.2143 | 3.2154 | 3.2139 | 3.2143 | 355600.0 |
| 2006-11-24 08:15:00 | AAPL | Stock | 3.2136 | 3.2182 | 3.2136 | 3.2161 | 215292.0 |
| 2006-11-24 08:20:00 | AAPL | Stock | 3.2161 | 3.2161 | 3.215 | 3.215 | 22400.0 |
| 2006-11-24 08:25:00 | AAPL | Stock | 3.2132 | 3.2143 | 3.2132 | 3.2136 | 43400.0 |
| 2006-11-24 08:30:00 | AAPL | Stock | 3.2136 | 3.2136 | 3.2118 | 3.2118 | 141708.0 |
| 2006-11-24 08:35:00 | AAPL | Stock | 3.2118 | 3.2143 | 3.2104 | 3.2104 | 214984.0 |
| 2006-11-24 08:40:00 | AAPL | Stock | 3.2104 | 3.2107 | 3.2086 | 3.2093 | 406980.0 |
| 2006-11-24 08:45:00 | AAPL | Stock | 3.2096 | 3.2125 | 3.2096 | 3.2125 | 197036.0 |
| 2006-11-24 08:50:00 | AAPL | Stock | 3.2125 | 3.2161 | 3.2125 | 3.2161 | 89292.0 |
| 2006-11-24 08:55:00 | AAPL | Stock | 3.2168 | 3.2168 | 3.2093 | 3.21 | 359324.0 |
| 2006-11-24 09:00:00 | AAPL | Stock | 3.2114 | 3.2114 | 3.2089 | 3.2089 | 145600.0 |
| 2006-11-24 09:05:00 | AAPL | Stock | 3.21 | 3.2143 | 3.2089 | 3.2139 | 396116.0 |
| 2006-11-24 09:10:00 | AAPL | Stock | 3.2139 | 3.2179 | 3.2139 | 3.2143 | 567280.0 |
| 2006-11-24 09:15:00 | AAPL | Stock | 3.2143 | 3.2143 | 3.2143 | 3.2143 | 26600.0 |
| 2006-11-24 09:20:00 | AAPL | Stock | 3.2139 | 3.2143 | 3.2125 | 3.2125 | 60200.0 |
| 2006-11-24 09:25:00 | AAPL | Stock | 3.2143 | 3.2143 | 3.1968 | 3.1968 | 1693720.0 |
| 2006-11-24 09:30:00 | AAPL | Stock | 3.1975 | 3.2139 | 3.1964 | 3.2082 | 19102944.0 |
| 2006-11-24 09:35:00 | AAPL | Stock | 3.2079 | 3.2257 | 3.2075 | 3.2136 | 10355548.0 |
| 2006-11-24 09:40:00 | AAPL | Stock | 3.2136 | 3.2146 | 3.2107 | 3.2125 | 7045976.0 |
| 2006-11-24 09:45:00 | AAPL | Stock | 3.2121 | 3.2271 | 3.2118 | 3.2239 | 13983060.0 |
| 2006-11-24 09:50:00 | AAPL | Stock | 3.2239 | 3.2382 | 3.2225 | 3.2382 | 19169808.0 |
| 2006-11-24 09:55:00 | AAPL | Stock | 3.2386 | 3.2554 | 3.2375 | 3.2414 | 15396416.0 |
| 2006-11-24 10:00:00 | AAPL | Stock | 3.2407 | 3.2479 | 3.2371 | 3.2479 | 11607316.0 |
| 2006-11-24 10:05:00 | AAPL | Stock | 3.2479 | 3.2496 | 3.2425 | 3.2432 | 7938084.0 |
| 2006-11-24 10:10:00 | AAPL | Stock | 3.2435 | 3.2454 | 3.2357 | 3.2371 | 7094920.0 |
| 2006-11-24 10:15:00 | AAPL | Stock | 3.2368 | 3.2436 | 3.2343 | 3.2436 | 7132664.0 |
| 2006-11-24 10:20:00 | AAPL | Stock | 3.2436 | 3.2568 | 3.2433 | 3.255 | 15198932.0 |
| 2006-11-24 10:25:00 | AAPL | Stock | 3.2553 | 3.2614 | 3.2539 | 3.2557 | 14580636.0 |
| 2006-11-24 10:30:00 | AAPL | Stock | 3.2554 | 3.2586 | 3.2539 | 3.2556 | 7741356.0 |
| 2006-11-24 10:35:00 | AAPL | Stock | 3.2557 | 3.2582 | 3.2532 | 3.2568 | 5159644.0 |
| 2006-11-24 10:40:00 | AAPL | Stock | 3.2568 | 3.2639 | 3.2568 | 3.2618 | 9181760.0 |
| 2006-11-24 10:45:00 | AAPL | Stock | 3.2618 | 3.2639 | 3.2589 | 3.2629 | 7045920.0 |
| 2006-11-24 10:50:00 | AAPL | Stock | 3.2632 | 3.2707 | 3.2629 | 3.265 | 13047804.0 |
| 2006-11-24 10:55:00 | AAPL | Stock | 3.265 | 3.2754 | 3.2639 | 3.2729 | 9202368.0 |
| 2006-11-24 11:00:00 | AAPL | Stock | 3.2729 | 3.2782 | 3.27 | 3.2771 | 9141440.0 |
| 2006-11-24 11:05:00 | AAPL | Stock | 3.2771 | 3.2821 | 3.2768 | 3.2802 | 9035432.0 |
| 2006-11-24 11:10:00 | AAPL | Stock | 3.2804 | 3.2843 | 3.2782 | 3.28 | 10626420.0 |
| 2006-11-24 11:15:00 | AAPL | Stock | 3.2804 | 3.2832 | 3.2771 | 3.2793 | 9968168.0 |
> showing 50 of 122,978 rows — these rows as CSV