PREVIEW / stock_5min / 2007-04-19
file: by_date/stock_5min/2007/2007-04-19.parquet size: 3.6 MB rows: 258,268 symbols: 2,575
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-19 04:15:00 | AAPL | Stock | 3.2057 | 3.2057 | 3.2057 | 3.2057 | 2800.0 |
| 2007-04-19 06:05:00 | AAPL | Stock | 3.2143 | 3.2143 | 3.2143 | 3.2143 | 2800.0 |
| 2007-04-19 06:10:00 | AAPL | Stock | 3.2075 | 3.2075 | 3.2075 | 3.2075 | 14000.0 |
| 2007-04-19 07:30:00 | AAPL | Stock | 3.2236 | 3.2236 | 3.2236 | 3.2236 | 26628.0 |
| 2007-04-19 08:00:00 | AAPL | Stock | 3.2179 | 3.2193 | 3.2107 | 3.2114 | 159460.0 |
| 2007-04-19 08:05:00 | AAPL | Stock | 3.2146 | 3.2146 | 3.2143 | 3.2143 | 30240.0 |
| 2007-04-19 08:15:00 | AAPL | Stock | 3.2193 | 3.2193 | 3.2118 | 3.2118 | 98980.0 |
| 2007-04-19 08:20:00 | AAPL | Stock | 3.2139 | 3.2189 | 3.2139 | 3.2189 | 42000.0 |
| 2007-04-19 08:25:00 | AAPL | Stock | 3.2189 | 3.2211 | 3.2189 | 3.2211 | 16800.0 |
| 2007-04-19 08:30:00 | AAPL | Stock | 3.2196 | 3.2196 | 3.2143 | 3.2146 | 103908.0 |
| 2007-04-19 08:35:00 | AAPL | Stock | 3.2161 | 3.2161 | 3.2146 | 3.2146 | 13692.0 |
| 2007-04-19 08:40:00 | AAPL | Stock | 3.2161 | 3.2161 | 3.2143 | 3.2143 | 37240.0 |
| 2007-04-19 08:45:00 | AAPL | Stock | 3.2143 | 3.2143 | 3.2143 | 3.2143 | 109200.0 |
| 2007-04-19 08:55:00 | AAPL | Stock | 3.2157 | 3.2157 | 3.215 | 3.215 | 28000.0 |
| 2007-04-19 09:00:00 | AAPL | Stock | 3.215 | 3.215 | 3.2143 | 3.215 | 19600.0 |
| 2007-04-19 09:05:00 | AAPL | Stock | 3.2143 | 3.2161 | 3.2143 | 3.2161 | 186200.0 |
| 2007-04-19 09:10:00 | AAPL | Stock | 3.2154 | 3.2154 | 3.2143 | 3.2146 | 125328.0 |
| 2007-04-19 09:15:00 | AAPL | Stock | 3.2154 | 3.2154 | 3.2154 | 3.2154 | 44800.0 |
| 2007-04-19 09:20:00 | AAPL | Stock | 3.2154 | 3.2243 | 3.2154 | 3.2186 | 259364.0 |
| 2007-04-19 09:25:00 | AAPL | Stock | 3.2168 | 3.2207 | 3.2161 | 3.2207 | 1589672.0 |
| 2007-04-19 09:30:00 | AAPL | Stock | 3.2211 | 3.2214 | 3.2082 | 3.2118 | 14247436.0 |
| 2007-04-19 09:35:00 | AAPL | Stock | 3.2118 | 3.2257 | 3.2104 | 3.2236 | 9933924.0 |
| 2007-04-19 09:40:00 | AAPL | Stock | 3.2236 | 3.24 | 3.2196 | 3.2364 | 16287880.0 |
| 2007-04-19 09:45:00 | AAPL | Stock | 3.2361 | 3.2407 | 3.2265 | 3.2332 | 17536344.0 |
| 2007-04-19 09:50:00 | AAPL | Stock | 3.2343 | 3.2414 | 3.2293 | 3.2389 | 7885472.0 |
| 2007-04-19 09:55:00 | AAPL | Stock | 3.2389 | 3.2525 | 3.2368 | 3.2461 | 16427208.0 |
| 2007-04-19 10:00:00 | AAPL | Stock | 3.2461 | 3.2536 | 3.2404 | 3.2504 | 11496520.0 |
| 2007-04-19 10:05:00 | AAPL | Stock | 3.2504 | 3.2504 | 3.2404 | 3.2418 | 9441544.0 |
| 2007-04-19 10:10:00 | AAPL | Stock | 3.2418 | 3.2482 | 3.2357 | 3.2364 | 10336620.0 |
| 2007-04-19 10:15:00 | AAPL | Stock | 3.2368 | 3.2411 | 3.2321 | 3.2396 | 7980084.0 |
| 2007-04-19 10:20:00 | AAPL | Stock | 3.24 | 3.2457 | 3.2379 | 3.245 | 9169832.0 |
| 2007-04-19 10:25:00 | AAPL | Stock | 3.2454 | 3.2475 | 3.2382 | 3.2396 | 7102956.0 |
| 2007-04-19 10:30:00 | AAPL | Stock | 3.24 | 3.2407 | 3.2357 | 3.2396 | 4358256.0 |
| 2007-04-19 10:35:00 | AAPL | Stock | 3.2396 | 3.2418 | 3.2379 | 3.2382 | 4241384.0 |
| 2007-04-19 10:40:00 | AAPL | Stock | 3.2379 | 3.2386 | 3.2332 | 3.2354 | 4205740.0 |
| 2007-04-19 10:45:00 | AAPL | Stock | 3.2361 | 3.2382 | 3.235 | 3.235 | 3092460.0 |
| 2007-04-19 10:50:00 | AAPL | Stock | 3.235 | 3.2379 | 3.2329 | 3.2361 | 2962680.0 |
| 2007-04-19 10:55:00 | AAPL | Stock | 3.2361 | 3.2407 | 3.235 | 3.2407 | 2779224.0 |
| 2007-04-19 11:00:00 | AAPL | Stock | 3.2411 | 3.2446 | 3.2386 | 3.2407 | 4315528.0 |
| 2007-04-19 11:05:00 | AAPL | Stock | 3.2407 | 3.2432 | 3.2375 | 3.2379 | 3119676.0 |
| 2007-04-19 11:10:00 | AAPL | Stock | 3.2375 | 3.2468 | 3.2371 | 3.2464 | 5117588.0 |
| 2007-04-19 11:15:00 | AAPL | Stock | 3.2468 | 3.2496 | 3.2432 | 3.2464 | 6433868.0 |
| 2007-04-19 11:20:00 | AAPL | Stock | 3.2468 | 3.2482 | 3.2443 | 3.2479 | 4035752.0 |
| 2007-04-19 11:25:00 | AAPL | Stock | 3.2479 | 3.2589 | 3.2475 | 3.2539 | 15874152.0 |
| 2007-04-19 11:30:00 | AAPL | Stock | 3.2539 | 3.2543 | 3.2507 | 3.2518 | 4029312.0 |
| 2007-04-19 11:35:00 | AAPL | Stock | 3.2518 | 3.2529 | 3.2443 | 3.2471 | 5935888.0 |
| 2007-04-19 11:40:00 | AAPL | Stock | 3.2471 | 3.2511 | 3.2457 | 3.2504 | 4734604.0 |
| 2007-04-19 11:45:00 | AAPL | Stock | 3.2507 | 3.2529 | 3.2489 | 3.2504 | 6064660.0 |
| 2007-04-19 11:50:00 | AAPL | Stock | 3.25 | 3.2539 | 3.2475 | 3.2532 | 4855396.0 |
| 2007-04-19 11:55:00 | AAPL | Stock | 3.2529 | 3.2536 | 3.2457 | 3.2475 | 4198348.0 |
> showing 50 of 258,268 rows — these rows as CSV