PREVIEW / stock_5min / 2002-08-06
file: by_date/stock_5min/2002/2002-08-06.parquet size: 1.9 MB rows: 127,717 symbols: 1,464
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 |
|---|---|---|---|---|---|---|---|
| 2002-08-06 08:00:00 | AAPL | Stock | 0.2505 | 0.2505 | 0.2505 | 0.2505 | 5600.0 |
| 2002-08-06 08:45:00 | AAPL | Stock | 0.2529 | 0.2529 | 0.2529 | 0.2529 | 95200.0 |
| 2002-08-06 09:00:00 | AAPL | Stock | 0.2529 | 0.2529 | 0.2529 | 0.2529 | 67200.0 |
| 2002-08-06 09:10:00 | AAPL | Stock | 0.253 | 0.253 | 0.253 | 0.253 | 16800.0 |
| 2002-08-06 09:15:00 | AAPL | Stock | 0.253 | 0.2536 | 0.253 | 0.2536 | 33600.0 |
| 2002-08-06 09:20:00 | AAPL | Stock | 0.253 | 0.253 | 0.253 | 0.253 | 56000.0 |
| 2002-08-06 09:25:00 | AAPL | Stock | 0.2538 | 0.2541 | 0.2538 | 0.2538 | 369600.0 |
| 2002-08-06 09:30:00 | AAPL | Stock | 0.2538 | 0.2569 | 0.2536 | 0.2563 | 4876368.0 |
| 2002-08-06 09:35:00 | AAPL | Stock | 0.2555 | 0.2563 | 0.2546 | 0.2554 | 2626400.0 |
| 2002-08-06 09:40:00 | AAPL | Stock | 0.2552 | 0.2554 | 0.2536 | 0.2541 | 3371200.0 |
| 2002-08-06 09:45:00 | AAPL | Stock | 0.2539 | 0.2543 | 0.2536 | 0.2538 | 1851360.0 |
| 2002-08-06 09:50:00 | AAPL | Stock | 0.2539 | 0.2543 | 0.2516 | 0.2518 | 7336000.0 |
| 2002-08-06 09:55:00 | AAPL | Stock | 0.2518 | 0.2525 | 0.2514 | 0.2523 | 3102400.0 |
| 2002-08-06 10:00:00 | AAPL | Stock | 0.2521 | 0.2561 | 0.2521 | 0.2559 | 6575912.0 |
| 2002-08-06 10:05:00 | AAPL | Stock | 0.2559 | 0.2571 | 0.2552 | 0.2563 | 7446488.0 |
| 2002-08-06 10:10:00 | AAPL | Stock | 0.2563 | 0.2573 | 0.2552 | 0.2552 | 6773256.0 |
| 2002-08-06 10:15:00 | AAPL | Stock | 0.2555 | 0.2584 | 0.2555 | 0.258 | 8114680.0 |
| 2002-08-06 10:20:00 | AAPL | Stock | 0.2579 | 0.2584 | 0.2541 | 0.2546 | 7870576.0 |
| 2002-08-06 10:25:00 | AAPL | Stock | 0.2552 | 0.2579 | 0.255 | 0.257 | 6832000.0 |
| 2002-08-06 10:30:00 | AAPL | Stock | 0.2563 | 0.2593 | 0.2563 | 0.2593 | 5231968.0 |
| 2002-08-06 10:35:00 | AAPL | Stock | 0.2593 | 0.2593 | 0.2568 | 0.2571 | 2721600.0 |
| 2002-08-06 10:40:00 | AAPL | Stock | 0.2568 | 0.2571 | 0.2564 | 0.2564 | 2542960.0 |
| 2002-08-06 10:45:00 | AAPL | Stock | 0.2563 | 0.2577 | 0.2563 | 0.2577 | 1288000.0 |
| 2002-08-06 10:50:00 | AAPL | Stock | 0.2575 | 0.2577 | 0.2564 | 0.2565 | 2010400.0 |
| 2002-08-06 10:55:00 | AAPL | Stock | 0.2564 | 0.2579 | 0.2564 | 0.2579 | 3693032.0 |
| 2002-08-06 11:00:00 | AAPL | Stock | 0.2577 | 0.2581 | 0.2571 | 0.2577 | 3662736.0 |
| 2002-08-06 11:05:00 | AAPL | Stock | 0.2579 | 0.2604 | 0.2577 | 0.2598 | 4495568.0 |
| 2002-08-06 11:10:00 | AAPL | Stock | 0.2602 | 0.2609 | 0.2596 | 0.2596 | 2832648.0 |
| 2002-08-06 11:15:00 | AAPL | Stock | 0.2595 | 0.2614 | 0.2593 | 0.2609 | 2399656.0 |
| 2002-08-06 11:20:00 | AAPL | Stock | 0.2609 | 0.262 | 0.2605 | 0.262 | 2613016.0 |
| 2002-08-06 11:25:00 | AAPL | Stock | 0.2621 | 0.2625 | 0.2605 | 0.2605 | 4272912.0 |
| 2002-08-06 11:30:00 | AAPL | Stock | 0.2606 | 0.2609 | 0.2598 | 0.2605 | 1379168.0 |
| 2002-08-06 11:35:00 | AAPL | Stock | 0.2605 | 0.2623 | 0.2604 | 0.2623 | 2251200.0 |
| 2002-08-06 11:40:00 | AAPL | Stock | 0.262 | 0.2621 | 0.2613 | 0.2613 | 2111200.0 |
| 2002-08-06 11:45:00 | AAPL | Stock | 0.2611 | 0.2629 | 0.2609 | 0.2623 | 3447472.0 |
| 2002-08-06 11:50:00 | AAPL | Stock | 0.2625 | 0.2627 | 0.2609 | 0.2618 | 1696800.0 |
| 2002-08-06 11:55:00 | AAPL | Stock | 0.2613 | 0.2618 | 0.2604 | 0.2611 | 940800.0 |
| 2002-08-06 12:00:00 | AAPL | Stock | 0.2609 | 0.2629 | 0.2609 | 0.2621 | 1607200.0 |
| 2002-08-06 12:05:00 | AAPL | Stock | 0.2621 | 0.2625 | 0.2616 | 0.2616 | 408800.0 |
| 2002-08-06 12:10:00 | AAPL | Stock | 0.2616 | 0.2629 | 0.2611 | 0.2616 | 1925112.0 |
| 2002-08-06 12:15:00 | AAPL | Stock | 0.2616 | 0.2629 | 0.2616 | 0.2629 | 845600.0 |
| 2002-08-06 12:20:00 | AAPL | Stock | 0.2629 | 0.2661 | 0.2629 | 0.2661 | 4347952.0 |
| 2002-08-06 12:25:00 | AAPL | Stock | 0.2659 | 0.2661 | 0.2654 | 0.2654 | 1540000.0 |
| 2002-08-06 12:30:00 | AAPL | Stock | 0.2655 | 0.2659 | 0.2654 | 0.2657 | 1111432.0 |
| 2002-08-06 12:35:00 | AAPL | Stock | 0.2657 | 0.2663 | 0.2657 | 0.2663 | 1534400.0 |
| 2002-08-06 12:40:00 | AAPL | Stock | 0.2661 | 0.267 | 0.2659 | 0.267 | 2143512.0 |
| 2002-08-06 12:45:00 | AAPL | Stock | 0.267 | 0.2673 | 0.2668 | 0.2673 | 2413600.0 |
| 2002-08-06 12:50:00 | AAPL | Stock | 0.2673 | 0.2673 | 0.2663 | 0.2663 | 784000.0 |
| 2002-08-06 12:55:00 | AAPL | Stock | 0.2663 | 0.2663 | 0.2646 | 0.2663 | 2424800.0 |
| 2002-08-06 13:00:00 | AAPL | Stock | 0.2659 | 0.2671 | 0.2654 | 0.2663 | 1736000.0 |
> showing 50 of 127,717 rows — these rows as CSV