PREVIEW / stock_5min / 2005-05-16
file: by_date/stock_5min/2005/2005-05-16.parquet size: 2.7 MB rows: 197,760 symbols: 1,996
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 |
|---|---|---|---|---|---|---|---|
| 2005-05-16 08:00:00 | AAPL | Stock | 1.2421 | 1.2446 | 1.2421 | 1.2446 | 105000.0 |
| 2005-05-16 08:05:00 | AAPL | Stock | 1.2446 | 1.2446 | 1.2446 | 1.2446 | 14000.0 |
| 2005-05-16 08:20:00 | AAPL | Stock | 1.2486 | 1.2486 | 1.2446 | 1.2446 | 86800.0 |
| 2005-05-16 08:30:00 | AAPL | Stock | 1.2446 | 1.2464 | 1.2411 | 1.2464 | 427000.0 |
| 2005-05-16 08:35:00 | AAPL | Stock | 1.2429 | 1.2464 | 1.2411 | 1.2411 | 53200.0 |
| 2005-05-16 08:45:00 | AAPL | Stock | 1.2411 | 1.2429 | 1.2411 | 1.2429 | 56000.0 |
| 2005-05-16 08:55:00 | AAPL | Stock | 1.2368 | 1.2407 | 1.2357 | 1.2407 | 168000.0 |
| 2005-05-16 09:05:00 | AAPL | Stock | 1.24 | 1.24 | 1.24 | 1.24 | 26600.0 |
| 2005-05-16 09:15:00 | AAPL | Stock | 1.2368 | 1.2368 | 1.2357 | 1.2357 | 520800.0 |
| 2005-05-16 09:20:00 | AAPL | Stock | 1.2357 | 1.2357 | 1.2357 | 1.2357 | 92400.0 |
| 2005-05-16 09:25:00 | AAPL | Stock | 1.2382 | 1.2393 | 1.2357 | 1.2364 | 165648.0 |
| 2005-05-16 09:30:00 | AAPL | Stock | 1.2343 | 1.2754 | 1.2332 | 1.2379 | 10266424.0 |
| 2005-05-16 09:35:00 | AAPL | Stock | 1.2379 | 1.2529 | 1.2364 | 1.25 | 15163456.0 |
| 2005-05-16 09:40:00 | AAPL | Stock | 1.2507 | 1.2571 | 1.2496 | 1.2568 | 8343104.0 |
| 2005-05-16 09:45:00 | AAPL | Stock | 1.2571 | 1.2625 | 1.2543 | 1.255 | 15548428.0 |
| 2005-05-16 09:50:00 | AAPL | Stock | 1.255 | 1.2571 | 1.2432 | 1.2439 | 14529396.0 |
| 2005-05-16 09:55:00 | AAPL | Stock | 1.2436 | 1.2479 | 1.2414 | 1.2429 | 9875992.0 |
| 2005-05-16 10:00:00 | AAPL | Stock | 1.2432 | 1.2464 | 1.2396 | 1.2464 | 8433656.0 |
| 2005-05-16 10:05:00 | AAPL | Stock | 1.2464 | 1.2493 | 1.2429 | 1.2482 | 6706616.0 |
| 2005-05-16 10:10:00 | AAPL | Stock | 1.2482 | 1.2518 | 1.2443 | 1.25 | 9075388.0 |
| 2005-05-16 10:15:00 | AAPL | Stock | 1.2496 | 1.2554 | 1.2482 | 1.2554 | 9339988.0 |
| 2005-05-16 10:20:00 | AAPL | Stock | 1.2554 | 1.2596 | 1.2525 | 1.2568 | 11960676.0 |
| 2005-05-16 10:25:00 | AAPL | Stock | 1.2568 | 1.2621 | 1.255 | 1.2621 | 8085476.0 |
| 2005-05-16 10:30:00 | AAPL | Stock | 1.2621 | 1.2639 | 1.2564 | 1.2564 | 12551252.0 |
| 2005-05-16 10:35:00 | AAPL | Stock | 1.2564 | 1.265 | 1.2564 | 1.2614 | 8618288.0 |
| 2005-05-16 10:40:00 | AAPL | Stock | 1.2614 | 1.2618 | 1.2575 | 1.2618 | 5575332.0 |
| 2005-05-16 10:45:00 | AAPL | Stock | 1.2614 | 1.2661 | 1.2614 | 1.2632 | 8135988.0 |
| 2005-05-16 10:50:00 | AAPL | Stock | 1.2632 | 1.2639 | 1.26 | 1.2629 | 4618544.0 |
| 2005-05-16 10:55:00 | AAPL | Stock | 1.2629 | 1.2639 | 1.2611 | 1.2632 | 3600520.0 |
| 2005-05-16 11:00:00 | AAPL | Stock | 1.2629 | 1.2639 | 1.2582 | 1.2589 | 6686008.0 |
| 2005-05-16 11:05:00 | AAPL | Stock | 1.2586 | 1.2596 | 1.2564 | 1.2593 | 4278064.0 |
| 2005-05-16 11:10:00 | AAPL | Stock | 1.2593 | 1.2593 | 1.2561 | 1.2571 | 2582328.0 |
| 2005-05-16 11:15:00 | AAPL | Stock | 1.2575 | 1.2611 | 1.2575 | 1.2607 | 3957212.0 |
| 2005-05-16 11:20:00 | AAPL | Stock | 1.2614 | 1.2636 | 1.26 | 1.2636 | 5037956.0 |
| 2005-05-16 11:25:00 | AAPL | Stock | 1.2632 | 1.2636 | 1.2596 | 1.2604 | 2887584.0 |
| 2005-05-16 11:30:00 | AAPL | Stock | 1.26 | 1.2611 | 1.2582 | 1.2593 | 2896656.0 |
| 2005-05-16 11:35:00 | AAPL | Stock | 1.2593 | 1.2625 | 1.2589 | 1.2604 | 2999668.0 |
| 2005-05-16 11:40:00 | AAPL | Stock | 1.2604 | 1.2607 | 1.2586 | 1.2596 | 2153368.0 |
| 2005-05-16 11:45:00 | AAPL | Stock | 1.26 | 1.26 | 1.2564 | 1.2568 | 3608612.0 |
| 2005-05-16 11:50:00 | AAPL | Stock | 1.2568 | 1.2582 | 1.2564 | 1.2579 | 2518684.0 |
| 2005-05-16 11:55:00 | AAPL | Stock | 1.2582 | 1.26 | 1.2571 | 1.2575 | 2524368.0 |
| 2005-05-16 12:00:00 | AAPL | Stock | 1.2575 | 1.2582 | 1.2529 | 1.2539 | 6070708.0 |
| 2005-05-16 12:05:00 | AAPL | Stock | 1.2539 | 1.2561 | 1.2529 | 1.2536 | 3548384.0 |
| 2005-05-16 12:10:00 | AAPL | Stock | 1.2539 | 1.2546 | 1.2514 | 1.2521 | 2582720.0 |
| 2005-05-16 12:15:00 | AAPL | Stock | 1.2521 | 1.2532 | 1.2493 | 1.25 | 4931556.0 |
| 2005-05-16 12:20:00 | AAPL | Stock | 1.2496 | 1.2514 | 1.2496 | 1.25 | 3764460.0 |
| 2005-05-16 12:25:00 | AAPL | Stock | 1.25 | 1.2525 | 1.25 | 1.2514 | 3702132.0 |
| 2005-05-16 12:30:00 | AAPL | Stock | 1.2511 | 1.2514 | 1.2496 | 1.25 | 5262348.0 |
| 2005-05-16 12:35:00 | AAPL | Stock | 1.2504 | 1.2504 | 1.2479 | 1.2493 | 5655496.0 |
| 2005-05-16 12:40:00 | AAPL | Stock | 1.2496 | 1.25 | 1.2489 | 1.2493 | 1712564.0 |
> showing 50 of 197,760 rows — these rows as CSV