PREVIEW / stock_5min / 2008-04-14
file: by_date/stock_5min/2008/2008-04-14.parquet size: 4.2 MB rows: 309,729 symbols: 3,308
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-04-14 06:15:00 | AAPL | Stock | 5.2418 | 5.2418 | 5.2418 | 5.2418 | 18900.0 |
| 2008-04-14 06:25:00 | AAPL | Stock | 5.2536 | 5.2721 | 5.2536 | 5.2721 | 16800.0 |
| 2008-04-14 06:50:00 | AAPL | Stock | 5.2386 | 5.2386 | 5.2386 | 5.2386 | 2800.0 |
| 2008-04-14 07:00:00 | AAPL | Stock | 5.23 | 5.23 | 5.23 | 5.23 | 11900.0 |
| 2008-04-14 07:20:00 | AAPL | Stock | 5.2475 | 5.2475 | 5.2321 | 5.2321 | 44800.0 |
| 2008-04-14 07:25:00 | AAPL | Stock | 5.2329 | 5.2464 | 5.2329 | 5.2464 | 11200.0 |
| 2008-04-14 07:30:00 | AAPL | Stock | 5.2464 | 5.2464 | 5.2329 | 5.2329 | 5600.0 |
| 2008-04-14 07:45:00 | AAPL | Stock | 5.2332 | 5.2336 | 5.2271 | 5.2271 | 34300.0 |
| 2008-04-14 07:50:00 | AAPL | Stock | 5.2275 | 5.2275 | 5.2271 | 5.2271 | 16800.0 |
| 2008-04-14 07:55:00 | AAPL | Stock | 5.2236 | 5.2321 | 5.2236 | 5.2321 | 50400.0 |
| 2008-04-14 08:00:00 | AAPL | Stock | 5.2289 | 5.2314 | 5.2143 | 5.2204 | 312816.0 |
| 2008-04-14 08:05:00 | AAPL | Stock | 5.2204 | 5.2214 | 5.2075 | 5.2089 | 334292.0 |
| 2008-04-14 08:10:00 | AAPL | Stock | 5.2089 | 5.2129 | 5.2054 | 5.2071 | 358148.0 |
| 2008-04-14 08:15:00 | AAPL | Stock | 5.21 | 5.2114 | 5.2093 | 5.2107 | 37296.0 |
| 2008-04-14 08:20:00 | AAPL | Stock | 5.2107 | 5.2107 | 5.2071 | 5.2104 | 119336.0 |
| 2008-04-14 08:25:00 | AAPL | Stock | 5.2079 | 5.2089 | 5.1989 | 5.2071 | 238532.0 |
| 2008-04-14 08:30:00 | AAPL | Stock | 5.2068 | 5.2286 | 5.2054 | 5.2193 | 703080.0 |
| 2008-04-14 08:35:00 | AAPL | Stock | 5.2143 | 5.2143 | 5.2071 | 5.2111 | 228956.0 |
| 2008-04-14 08:40:00 | AAPL | Stock | 5.2136 | 5.2268 | 5.2107 | 5.2214 | 453292.0 |
| 2008-04-14 08:45:00 | AAPL | Stock | 5.2214 | 5.2429 | 5.2214 | 5.2429 | 695576.0 |
| 2008-04-14 08:50:00 | AAPL | Stock | 5.2386 | 5.2432 | 5.2357 | 5.2425 | 436968.0 |
| 2008-04-14 08:55:00 | AAPL | Stock | 5.2379 | 5.2393 | 5.2321 | 5.2357 | 99400.0 |
| 2008-04-14 09:00:00 | AAPL | Stock | 5.2361 | 5.2411 | 5.2329 | 5.2411 | 117460.0 |
| 2008-04-14 09:05:00 | AAPL | Stock | 5.2407 | 5.2429 | 5.2407 | 5.2411 | 358176.0 |
| 2008-04-14 09:10:00 | AAPL | Stock | 5.2411 | 5.2411 | 5.2214 | 5.2307 | 343504.0 |
| 2008-04-14 09:15:00 | AAPL | Stock | 5.2293 | 5.25 | 5.2275 | 5.25 | 363720.0 |
| 2008-04-14 09:20:00 | AAPL | Stock | 5.25 | 5.2568 | 5.2429 | 5.2429 | 393400.0 |
| 2008-04-14 09:25:00 | AAPL | Stock | 5.2464 | 5.25 | 5.2346 | 5.2429 | 878500.0 |
| 2008-04-14 09:30:00 | AAPL | Stock | 5.2414 | 5.2736 | 5.2214 | 5.23 | 33077716.0 |
| 2008-04-14 09:35:00 | AAPL | Stock | 5.2296 | 5.2296 | 5.1779 | 5.1871 | 36462776.0 |
| 2008-04-14 09:40:00 | AAPL | Stock | 5.1875 | 5.1939 | 5.1686 | 5.1904 | 27354992.0 |
| 2008-04-14 09:45:00 | AAPL | Stock | 5.1904 | 5.1993 | 5.1621 | 5.1907 | 21734048.0 |
| 2008-04-14 09:50:00 | AAPL | Stock | 5.1907 | 5.1971 | 5.1671 | 5.1871 | 19304740.0 |
| 2008-04-14 09:55:00 | AAPL | Stock | 5.1871 | 5.2018 | 5.1643 | 5.1979 | 20854988.0 |
| 2008-04-14 10:00:00 | AAPL | Stock | 5.1989 | 5.2221 | 5.1893 | 5.2218 | 24523912.0 |
| 2008-04-14 10:05:00 | AAPL | Stock | 5.2221 | 5.23 | 5.2107 | 5.2171 | 19170424.0 |
| 2008-04-14 10:10:00 | AAPL | Stock | 5.2168 | 5.2193 | 5.2004 | 5.2125 | 13209308.0 |
| 2008-04-14 10:15:00 | AAPL | Stock | 5.2125 | 5.2246 | 5.2021 | 5.2225 | 12159756.0 |
| 2008-04-14 10:20:00 | AAPL | Stock | 5.2232 | 5.245 | 5.2214 | 5.2325 | 18195744.0 |
| 2008-04-14 10:25:00 | AAPL | Stock | 5.2324 | 5.2707 | 5.2304 | 5.2593 | 20606544.0 |
| 2008-04-14 10:30:00 | AAPL | Stock | 5.2604 | 5.2875 | 5.2557 | 5.2832 | 20144124.0 |
| 2008-04-14 10:35:00 | AAPL | Stock | 5.2829 | 5.2846 | 5.2654 | 5.2768 | 12574016.0 |
| 2008-04-14 10:40:00 | AAPL | Stock | 5.2764 | 5.3029 | 5.2757 | 5.2896 | 17158904.0 |
| 2008-04-14 10:45:00 | AAPL | Stock | 5.2896 | 5.3 | 5.2789 | 5.2836 | 11625124.0 |
| 2008-04-14 10:50:00 | AAPL | Stock | 5.2836 | 5.295 | 5.2761 | 5.2768 | 7775320.0 |
| 2008-04-14 10:55:00 | AAPL | Stock | 5.2771 | 5.2957 | 5.2721 | 5.2946 | 9720816.0 |
| 2008-04-14 11:00:00 | AAPL | Stock | 5.2954 | 5.3071 | 5.2939 | 5.3021 | 13947668.0 |
| 2008-04-14 11:05:00 | AAPL | Stock | 5.3029 | 5.3136 | 5.2986 | 5.3036 | 9627128.0 |
| 2008-04-14 11:10:00 | AAPL | Stock | 5.3039 | 5.3039 | 5.2879 | 5.2893 | 8751260.0 |
| 2008-04-14 11:15:00 | AAPL | Stock | 5.2886 | 5.2986 | 5.2857 | 5.2875 | 7242088.0 |
> showing 50 of 309,729 rows — these rows as CSV