PREVIEW / stock_5min / 2007-04-18
file: by_date/stock_5min/2007/2007-04-18.parquet size: 3.5 MB rows: 254,943 symbols: 2,579
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-04-18 07:10:00 | AAPL | Stock | 3.2143 | 3.2186 | 3.2018 | 3.2018 | 92400.0 |
| 2007-04-18 07:15:00 | AAPL | Stock | 3.2018 | 3.2018 | 3.2018 | 3.2018 | 100100.0 |
| 2007-04-18 07:20:00 | AAPL | Stock | 3.2036 | 3.2036 | 3.2036 | 3.2036 | 2800.0 |
| 2007-04-18 07:25:00 | AAPL | Stock | 3.2018 | 3.2018 | 3.1971 | 3.1971 | 23100.0 |
| 2007-04-18 07:55:00 | AAPL | Stock | 3.2011 | 3.2018 | 3.2011 | 3.2018 | 21700.0 |
| 2007-04-18 08:00:00 | AAPL | Stock | 3.2018 | 3.21 | 3.2018 | 3.21 | 88536.0 |
| 2007-04-18 08:05:00 | AAPL | Stock | 3.2096 | 3.21 | 3.2071 | 3.2071 | 93688.0 |
| 2007-04-18 08:10:00 | AAPL | Stock | 3.2104 | 3.2168 | 3.2104 | 3.2129 | 92960.0 |
| 2007-04-18 08:15:00 | AAPL | Stock | 3.2139 | 3.2139 | 3.2111 | 3.2139 | 21560.0 |
| 2007-04-18 08:20:00 | AAPL | Stock | 3.2139 | 3.2139 | 3.2107 | 3.2107 | 39200.0 |
| 2007-04-18 08:25:00 | AAPL | Stock | 3.2096 | 3.2096 | 3.2079 | 3.2079 | 56924.0 |
| 2007-04-18 08:30:00 | AAPL | Stock | 3.2079 | 3.2104 | 3.2071 | 3.21 | 113456.0 |
| 2007-04-18 08:35:00 | AAPL | Stock | 3.2096 | 3.2125 | 3.2057 | 3.2107 | 155092.0 |
| 2007-04-18 08:40:00 | AAPL | Stock | 3.2107 | 3.2107 | 3.2089 | 3.2089 | 114800.0 |
| 2007-04-18 08:45:00 | AAPL | Stock | 3.2089 | 3.2089 | 3.2054 | 3.2054 | 119868.0 |
| 2007-04-18 08:50:00 | AAPL | Stock | 3.2064 | 3.2089 | 3.2054 | 3.2054 | 126728.0 |
| 2007-04-18 08:55:00 | AAPL | Stock | 3.205 | 3.2064 | 3.2036 | 3.2064 | 84140.0 |
| 2007-04-18 09:00:00 | AAPL | Stock | 3.2071 | 3.2071 | 3.2071 | 3.2071 | 42000.0 |
| 2007-04-18 09:05:00 | AAPL | Stock | 3.2082 | 3.2082 | 3.2071 | 3.2071 | 70700.0 |
| 2007-04-18 09:10:00 | AAPL | Stock | 3.2064 | 3.2071 | 3.2061 | 3.2064 | 67284.0 |
| 2007-04-18 09:20:00 | AAPL | Stock | 3.2071 | 3.2136 | 3.2071 | 3.2114 | 576968.0 |
| 2007-04-18 09:25:00 | AAPL | Stock | 3.2132 | 3.2196 | 3.2075 | 3.2179 | 1752156.0 |
| 2007-04-18 09:30:00 | AAPL | Stock | 3.22 | 3.22 | 3.2054 | 3.2054 | 18009768.0 |
| 2007-04-18 09:35:00 | AAPL | Stock | 3.2054 | 3.22 | 3.2 | 3.2054 | 11645508.0 |
| 2007-04-18 09:40:00 | AAPL | Stock | 3.2054 | 3.2136 | 3.2054 | 3.2122 | 5237820.0 |
| 2007-04-18 09:45:00 | AAPL | Stock | 3.2121 | 3.2164 | 3.2061 | 3.2089 | 6268136.0 |
| 2007-04-18 09:50:00 | AAPL | Stock | 3.2086 | 3.2193 | 3.2071 | 3.2146 | 7505456.0 |
| 2007-04-18 09:55:00 | AAPL | Stock | 3.2143 | 3.2214 | 3.2136 | 3.2168 | 5845056.0 |
| 2007-04-18 10:00:00 | AAPL | Stock | 3.2168 | 3.2232 | 3.2146 | 3.2221 | 8636320.0 |
| 2007-04-18 10:05:00 | AAPL | Stock | 3.2218 | 3.2229 | 3.2154 | 3.2218 | 8411228.0 |
| 2007-04-18 10:10:00 | AAPL | Stock | 3.2218 | 3.2275 | 3.2182 | 3.2261 | 14403368.0 |
| 2007-04-18 10:15:00 | AAPL | Stock | 3.2261 | 3.2371 | 3.2257 | 3.2329 | 15828540.0 |
| 2007-04-18 10:20:00 | AAPL | Stock | 3.2332 | 3.2396 | 3.2296 | 3.2368 | 15171744.0 |
| 2007-04-18 10:25:00 | AAPL | Stock | 3.2368 | 3.2386 | 3.23 | 3.23 | 7596512.0 |
| 2007-04-18 10:30:00 | AAPL | Stock | 3.2296 | 3.2321 | 3.2264 | 3.2299 | 8687140.0 |
| 2007-04-18 10:35:00 | AAPL | Stock | 3.23 | 3.2325 | 3.2271 | 3.2321 | 6105876.0 |
| 2007-04-18 10:40:00 | AAPL | Stock | 3.2321 | 3.2332 | 3.2286 | 3.2296 | 4407452.0 |
| 2007-04-18 10:45:00 | AAPL | Stock | 3.2296 | 3.2332 | 3.2279 | 3.2314 | 10150672.0 |
| 2007-04-18 10:50:00 | AAPL | Stock | 3.2314 | 3.2346 | 3.2296 | 3.2307 | 5790064.0 |
| 2007-04-18 10:55:00 | AAPL | Stock | 3.2307 | 3.2343 | 3.2296 | 3.2311 | 3202136.0 |
| 2007-04-18 11:00:00 | AAPL | Stock | 3.2314 | 3.2364 | 3.2304 | 3.2354 | 6338108.0 |
| 2007-04-18 11:05:00 | AAPL | Stock | 3.2357 | 3.2446 | 3.2354 | 3.2361 | 10797696.0 |
| 2007-04-18 11:10:00 | AAPL | Stock | 3.2364 | 3.2404 | 3.2357 | 3.2404 | 5895652.0 |
| 2007-04-18 11:15:00 | AAPL | Stock | 3.24 | 3.2425 | 3.2382 | 3.239 | 4051880.0 |
| 2007-04-18 11:20:00 | AAPL | Stock | 3.2393 | 3.24 | 3.2361 | 3.2396 | 3909920.0 |
| 2007-04-18 11:25:00 | AAPL | Stock | 3.2396 | 3.2425 | 3.2382 | 3.2418 | 4295060.0 |
| 2007-04-18 11:30:00 | AAPL | Stock | 3.2418 | 3.2425 | 3.2382 | 3.2393 | 4146492.0 |
| 2007-04-18 11:35:00 | AAPL | Stock | 3.2389 | 3.2432 | 3.235 | 3.2361 | 8410444.0 |
| 2007-04-18 11:40:00 | AAPL | Stock | 3.2357 | 3.2404 | 3.2296 | 3.2321 | 11977196.0 |
| 2007-04-18 11:45:00 | AAPL | Stock | 3.2318 | 3.2357 | 3.2318 | 3.2329 | 5479880.0 |
> showing 50 of 254,943 rows — these rows as CSV