PREVIEW / stock_5min / 2007-04-20
file: by_date/stock_5min/2007/2007-04-20.parquet size: 3.6 MB rows: 259,296 symbols: 2,587
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-20 06:55:00 | AAPL | Stock | 3.25 | 3.25 | 3.2414 | 3.2414 | 16800.0 |
| 2007-04-20 07:20:00 | AAPL | Stock | 3.255 | 3.2554 | 3.255 | 3.2554 | 53200.0 |
| 2007-04-20 07:25:00 | AAPL | Stock | 3.2564 | 3.2564 | 3.2564 | 3.2564 | 4200.0 |
| 2007-04-20 07:30:00 | AAPL | Stock | 3.2564 | 3.2564 | 3.2564 | 3.2564 | 2800.0 |
| 2007-04-20 07:45:00 | AAPL | Stock | 3.2536 | 3.2536 | 3.2489 | 3.2536 | 67200.0 |
| 2007-04-20 07:50:00 | AAPL | Stock | 3.2536 | 3.2536 | 3.25 | 3.2518 | 76244.0 |
| 2007-04-20 07:55:00 | AAPL | Stock | 3.2518 | 3.2518 | 3.2518 | 3.2518 | 2800.0 |
| 2007-04-20 08:00:00 | AAPL | Stock | 3.2489 | 3.25 | 3.2436 | 3.2436 | 214312.0 |
| 2007-04-20 08:05:00 | AAPL | Stock | 3.2464 | 3.2471 | 3.2446 | 3.2446 | 66920.0 |
| 2007-04-20 08:10:00 | AAPL | Stock | 3.2432 | 3.2464 | 3.2432 | 3.2461 | 121800.0 |
| 2007-04-20 08:15:00 | AAPL | Stock | 3.2464 | 3.2504 | 3.2464 | 3.2482 | 239372.0 |
| 2007-04-20 08:20:00 | AAPL | Stock | 3.2482 | 3.2504 | 3.2482 | 3.25 | 271684.0 |
| 2007-04-20 08:25:00 | AAPL | Stock | 3.25 | 3.25 | 3.2489 | 3.2496 | 42280.0 |
| 2007-04-20 08:30:00 | AAPL | Stock | 3.2486 | 3.2496 | 3.2482 | 3.2496 | 58800.0 |
| 2007-04-20 08:35:00 | AAPL | Stock | 3.2493 | 3.25 | 3.2489 | 3.2496 | 191800.0 |
| 2007-04-20 08:40:00 | AAPL | Stock | 3.2493 | 3.25 | 3.2482 | 3.25 | 520576.0 |
| 2007-04-20 08:45:00 | AAPL | Stock | 3.2482 | 3.2482 | 3.2468 | 3.2475 | 153160.0 |
| 2007-04-20 08:50:00 | AAPL | Stock | 3.2475 | 3.2479 | 3.2464 | 3.2464 | 37632.0 |
| 2007-04-20 08:55:00 | AAPL | Stock | 3.2475 | 3.2482 | 3.2475 | 3.2475 | 206780.0 |
| 2007-04-20 09:00:00 | AAPL | Stock | 3.2475 | 3.2479 | 3.2464 | 3.2464 | 238868.0 |
| 2007-04-20 09:05:00 | AAPL | Stock | 3.2464 | 3.2464 | 3.2429 | 3.2432 | 194600.0 |
| 2007-04-20 09:10:00 | AAPL | Stock | 3.2461 | 3.2464 | 3.2446 | 3.2446 | 126000.0 |
| 2007-04-20 09:15:00 | AAPL | Stock | 3.245 | 3.2479 | 3.245 | 3.2479 | 134400.0 |
| 2007-04-20 09:20:00 | AAPL | Stock | 3.2479 | 3.2479 | 3.2464 | 3.2471 | 112000.0 |
| 2007-04-20 09:25:00 | AAPL | Stock | 3.2471 | 3.25 | 3.2432 | 3.2457 | 5611032.0 |
| 2007-04-20 09:30:00 | AAPL | Stock | 3.246 | 3.2536 | 3.2382 | 3.2489 | 67784696.0 |
| 2007-04-20 09:35:00 | AAPL | Stock | 3.2489 | 3.2518 | 3.2443 | 3.2461 | 11743284.0 |
| 2007-04-20 09:40:00 | AAPL | Stock | 3.2461 | 3.25 | 3.2407 | 3.2436 | 12227544.0 |
| 2007-04-20 09:45:00 | AAPL | Stock | 3.2436 | 3.2489 | 3.2429 | 3.2482 | 17488604.0 |
| 2007-04-20 09:50:00 | AAPL | Stock | 3.2479 | 3.2482 | 3.2382 | 3.2393 | 10292184.0 |
| 2007-04-20 09:55:00 | AAPL | Stock | 3.2393 | 3.2414 | 3.2354 | 3.24 | 10321500.0 |
| 2007-04-20 10:00:00 | AAPL | Stock | 3.2396 | 3.2421 | 3.2343 | 3.2407 | 10465140.0 |
| 2007-04-20 10:05:00 | AAPL | Stock | 3.2411 | 3.2425 | 3.2368 | 3.2386 | 6792240.0 |
| 2007-04-20 10:10:00 | AAPL | Stock | 3.2389 | 3.2461 | 3.2386 | 3.2457 | 7707868.0 |
| 2007-04-20 10:15:00 | AAPL | Stock | 3.2457 | 3.2461 | 3.2396 | 3.2439 | 5159616.0 |
| 2007-04-20 10:20:00 | AAPL | Stock | 3.2439 | 3.2521 | 3.2429 | 3.2504 | 11086964.0 |
| 2007-04-20 10:25:00 | AAPL | Stock | 3.2504 | 3.2504 | 3.2439 | 3.2464 | 6371036.0 |
| 2007-04-20 10:30:00 | AAPL | Stock | 3.2461 | 3.25 | 3.2446 | 3.2446 | 3986164.0 |
| 2007-04-20 10:35:00 | AAPL | Stock | 3.2446 | 3.2454 | 3.2407 | 3.2436 | 5003040.0 |
| 2007-04-20 10:40:00 | AAPL | Stock | 3.2436 | 3.2443 | 3.2393 | 3.2404 | 5632732.0 |
| 2007-04-20 10:45:00 | AAPL | Stock | 3.2404 | 3.2411 | 3.2375 | 3.2393 | 5159868.0 |
| 2007-04-20 10:50:00 | AAPL | Stock | 3.2393 | 3.2411 | 3.2368 | 3.2382 | 5860988.0 |
| 2007-04-20 10:55:00 | AAPL | Stock | 3.2386 | 3.24 | 3.2368 | 3.2382 | 4045972.0 |
| 2007-04-20 11:00:00 | AAPL | Stock | 3.2382 | 3.24 | 3.2368 | 3.2389 | 3860444.0 |
| 2007-04-20 11:05:00 | AAPL | Stock | 3.2389 | 3.2396 | 3.2379 | 3.2379 | 3196424.0 |
| 2007-04-20 11:10:00 | AAPL | Stock | 3.2379 | 3.2379 | 3.2343 | 3.2354 | 6717760.0 |
| 2007-04-20 11:15:00 | AAPL | Stock | 3.2354 | 3.2386 | 3.235 | 3.2386 | 4871496.0 |
| 2007-04-20 11:20:00 | AAPL | Stock | 3.2386 | 3.24 | 3.2364 | 3.2396 | 4248132.0 |
| 2007-04-20 11:25:00 | AAPL | Stock | 3.2396 | 3.2411 | 3.2389 | 3.2393 | 3017056.0 |
| 2007-04-20 11:30:00 | AAPL | Stock | 3.2393 | 3.2421 | 3.2375 | 3.2421 | 3997028.0 |
> showing 50 of 259,296 rows — these rows as CSV