PREVIEW / stock_5min / 2007-03-19
file: by_date/stock_5min/2007/2007-03-19.parquet size: 3.5 MB rows: 254,377 symbols: 2,565
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-03-19 04:35:00 | AAPL | Stock | 3.2125 | 3.2125 | 3.2125 | 3.2125 | 2800.0 |
| 2007-03-19 07:00:00 | AAPL | Stock | 3.2175 | 3.2175 | 3.2171 | 3.2171 | 16800.0 |
| 2007-03-19 07:05:00 | AAPL | Stock | 3.2143 | 3.2143 | 3.2143 | 3.2143 | 56000.0 |
| 2007-03-19 07:10:00 | AAPL | Stock | 3.2207 | 3.2207 | 3.2207 | 3.2207 | 2800.0 |
| 2007-03-19 07:20:00 | AAPL | Stock | 3.2293 | 3.2293 | 3.2293 | 3.2293 | 11200.0 |
| 2007-03-19 07:30:00 | AAPL | Stock | 3.2296 | 3.2296 | 3.2296 | 3.2296 | 50400.0 |
| 2007-03-19 07:40:00 | AAPL | Stock | 3.2296 | 3.2464 | 3.2293 | 3.2464 | 406000.0 |
| 2007-03-19 07:45:00 | AAPL | Stock | 3.2482 | 3.2493 | 3.2461 | 3.2464 | 75600.0 |
| 2007-03-19 07:50:00 | AAPL | Stock | 3.2482 | 3.2482 | 3.2443 | 3.2464 | 140000.0 |
| 2007-03-19 07:55:00 | AAPL | Stock | 3.2464 | 3.2468 | 3.2454 | 3.2454 | 520800.0 |
| 2007-03-19 08:00:00 | AAPL | Stock | 3.2464 | 3.25 | 3.2375 | 3.2393 | 1572256.0 |
| 2007-03-19 08:05:00 | AAPL | Stock | 3.2357 | 3.2389 | 3.2318 | 3.2325 | 260484.0 |
| 2007-03-19 08:10:00 | AAPL | Stock | 3.2357 | 3.2357 | 3.2321 | 3.2321 | 81228.0 |
| 2007-03-19 08:15:00 | AAPL | Stock | 3.2339 | 3.2375 | 3.2339 | 3.2375 | 70476.0 |
| 2007-03-19 08:20:00 | AAPL | Stock | 3.2346 | 3.2357 | 3.2339 | 3.2357 | 168560.0 |
| 2007-03-19 08:25:00 | AAPL | Stock | 3.2357 | 3.2357 | 3.2321 | 3.2321 | 48692.0 |
| 2007-03-19 08:30:00 | AAPL | Stock | 3.2318 | 3.2318 | 3.2307 | 3.2307 | 68096.0 |
| 2007-03-19 08:35:00 | AAPL | Stock | 3.2304 | 3.2304 | 3.2268 | 3.2286 | 116200.0 |
| 2007-03-19 08:40:00 | AAPL | Stock | 3.2268 | 3.2304 | 3.2261 | 3.2304 | 208600.0 |
| 2007-03-19 08:45:00 | AAPL | Stock | 3.2286 | 3.23 | 3.2286 | 3.2293 | 169036.0 |
| 2007-03-19 08:50:00 | AAPL | Stock | 3.2286 | 3.2286 | 3.2286 | 3.2286 | 66500.0 |
| 2007-03-19 08:55:00 | AAPL | Stock | 3.2296 | 3.23 | 3.2286 | 3.2286 | 115500.0 |
| 2007-03-19 09:00:00 | AAPL | Stock | 3.2286 | 3.2304 | 3.2257 | 3.2261 | 478268.0 |
| 2007-03-19 09:05:00 | AAPL | Stock | 3.2261 | 3.2261 | 3.2232 | 3.2232 | 519400.0 |
| 2007-03-19 09:10:00 | AAPL | Stock | 3.2232 | 3.2236 | 3.2196 | 3.2207 | 2215920.0 |
| 2007-03-19 09:15:00 | AAPL | Stock | 3.2207 | 3.2214 | 3.2196 | 3.2214 | 320040.0 |
| 2007-03-19 09:20:00 | AAPL | Stock | 3.2214 | 3.2214 | 3.2214 | 3.2214 | 134120.0 |
| 2007-03-19 09:25:00 | AAPL | Stock | 3.2204 | 3.2232 | 3.2189 | 3.2218 | 228060.0 |
| 2007-03-19 09:30:00 | AAPL | Stock | 3.2229 | 3.2257 | 3.2032 | 3.205 | 26038656.0 |
| 2007-03-19 09:35:00 | AAPL | Stock | 3.2057 | 3.2125 | 3.1996 | 3.205 | 18331656.0 |
| 2007-03-19 09:40:00 | AAPL | Stock | 3.2046 | 3.2104 | 3.2 | 3.2075 | 11684372.0 |
| 2007-03-19 09:45:00 | AAPL | Stock | 3.2079 | 3.2143 | 3.2064 | 3.2143 | 10575824.0 |
| 2007-03-19 09:50:00 | AAPL | Stock | 3.2143 | 3.2186 | 3.2125 | 3.2175 | 14371980.0 |
| 2007-03-19 09:55:00 | AAPL | Stock | 3.2171 | 3.2221 | 3.2143 | 3.2211 | 11642988.0 |
| 2007-03-19 10:00:00 | AAPL | Stock | 3.2207 | 3.2218 | 3.2146 | 3.2157 | 8949052.0 |
| 2007-03-19 10:05:00 | AAPL | Stock | 3.2154 | 3.2204 | 3.2143 | 3.2161 | 7999012.0 |
| 2007-03-19 10:10:00 | AAPL | Stock | 3.2164 | 3.2182 | 3.2104 | 3.2136 | 7850612.0 |
| 2007-03-19 10:15:00 | AAPL | Stock | 3.2136 | 3.2171 | 3.2129 | 3.2157 | 6400156.0 |
| 2007-03-19 10:20:00 | AAPL | Stock | 3.2157 | 3.2196 | 3.2146 | 3.2189 | 6247472.0 |
| 2007-03-19 10:25:00 | AAPL | Stock | 3.2189 | 3.2207 | 3.2171 | 3.2193 | 4608100.0 |
| 2007-03-19 10:30:00 | AAPL | Stock | 3.2193 | 3.2196 | 3.2111 | 3.2143 | 7654192.0 |
| 2007-03-19 10:35:00 | AAPL | Stock | 3.2143 | 3.2161 | 3.2139 | 3.2161 | 6581568.0 |
| 2007-03-19 10:40:00 | AAPL | Stock | 3.2161 | 3.2193 | 3.2157 | 3.2171 | 6346928.0 |
| 2007-03-19 10:45:00 | AAPL | Stock | 3.2171 | 3.2179 | 3.2157 | 3.2179 | 3750600.0 |
| 2007-03-19 10:50:00 | AAPL | Stock | 3.2179 | 3.2229 | 3.2143 | 3.2225 | 14070476.0 |
| 2007-03-19 10:55:00 | AAPL | Stock | 3.2225 | 3.2371 | 3.22 | 3.2339 | 26506900.0 |
| 2007-03-19 11:00:00 | AAPL | Stock | 3.2339 | 3.2529 | 3.2329 | 3.2486 | 35386680.0 |
| 2007-03-19 11:05:00 | AAPL | Stock | 3.2489 | 3.2589 | 3.2461 | 3.2575 | 19894420.0 |
| 2007-03-19 11:10:00 | AAPL | Stock | 3.2579 | 3.2589 | 3.2518 | 3.2536 | 15007216.0 |
| 2007-03-19 11:15:00 | AAPL | Stock | 3.2536 | 3.2582 | 3.2529 | 3.2539 | 6664056.0 |
> showing 50 of 254,377 rows — these rows as CSV