PREVIEW / stock_5min / 2006-08-11
file: by_date/stock_5min/2006/2006-08-11.parquet size: 2.9 MB rows: 218,655 symbols: 2,305
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 |
|---|---|---|---|---|---|---|---|
| 2006-08-11 06:55:00 | AAPL | Stock | 2.2839 | 2.2839 | 2.2839 | 2.2839 | 2800.0 |
| 2006-08-11 07:00:00 | AAPL | Stock | 2.2786 | 2.2804 | 2.2786 | 2.2786 | 29680.0 |
| 2006-08-11 07:05:00 | AAPL | Stock | 2.2786 | 2.2786 | 2.2786 | 2.2786 | 16800.0 |
| 2006-08-11 07:25:00 | AAPL | Stock | 2.2786 | 2.2786 | 2.2786 | 2.2786 | 25200.0 |
| 2006-08-11 07:35:00 | AAPL | Stock | 2.2789 | 2.2789 | 2.2789 | 2.2789 | 2800.0 |
| 2006-08-11 07:45:00 | AAPL | Stock | 2.2786 | 2.2821 | 2.2696 | 2.2696 | 151200.0 |
| 2006-08-11 07:50:00 | AAPL | Stock | 2.2786 | 2.2793 | 2.2786 | 2.2793 | 5600.0 |
| 2006-08-11 07:55:00 | AAPL | Stock | 2.2736 | 2.2736 | 2.2736 | 2.2736 | 5600.0 |
| 2006-08-11 08:00:00 | AAPL | Stock | 2.2818 | 2.2821 | 2.2571 | 2.2586 | 750540.0 |
| 2006-08-11 08:05:00 | AAPL | Stock | 2.2543 | 2.2546 | 2.2357 | 2.2393 | 1107960.0 |
| 2006-08-11 08:10:00 | AAPL | Stock | 2.2407 | 2.2454 | 2.2214 | 2.2346 | 1734936.0 |
| 2006-08-11 08:15:00 | AAPL | Stock | 2.2343 | 2.2454 | 2.2343 | 2.2436 | 736232.0 |
| 2006-08-11 08:20:00 | AAPL | Stock | 2.2436 | 2.2568 | 2.2411 | 2.2532 | 1037988.0 |
| 2006-08-11 08:25:00 | AAPL | Stock | 2.2529 | 2.2625 | 2.2511 | 2.26 | 1457820.0 |
| 2006-08-11 08:30:00 | AAPL | Stock | 2.2596 | 2.2611 | 2.2586 | 2.2593 | 1790460.0 |
| 2006-08-11 08:35:00 | AAPL | Stock | 2.2589 | 2.2696 | 2.2571 | 2.2696 | 1618960.0 |
| 2006-08-11 08:40:00 | AAPL | Stock | 2.2679 | 2.2746 | 2.2589 | 2.2714 | 1569400.0 |
| 2006-08-11 08:45:00 | AAPL | Stock | 2.2714 | 2.2775 | 2.2682 | 2.2693 | 1363040.0 |
| 2006-08-11 08:50:00 | AAPL | Stock | 2.2704 | 2.2714 | 2.2693 | 2.2707 | 199220.0 |
| 2006-08-11 08:55:00 | AAPL | Stock | 2.2696 | 2.27 | 2.2679 | 2.2689 | 726908.0 |
| 2006-08-11 09:00:00 | AAPL | Stock | 2.2689 | 2.2689 | 2.2636 | 2.2643 | 588476.0 |
| 2006-08-11 09:05:00 | AAPL | Stock | 2.265 | 2.2657 | 2.2593 | 2.2643 | 302428.0 |
| 2006-08-11 09:10:00 | AAPL | Stock | 2.2621 | 2.2625 | 2.2571 | 2.2579 | 515144.0 |
| 2006-08-11 09:15:00 | AAPL | Stock | 2.2575 | 2.2629 | 2.2575 | 2.2607 | 226240.0 |
| 2006-08-11 09:20:00 | AAPL | Stock | 2.2618 | 2.2629 | 2.2604 | 2.2614 | 280840.0 |
| 2006-08-11 09:25:00 | AAPL | Stock | 2.2614 | 2.2625 | 2.2571 | 2.2586 | 838880.0 |
| 2006-08-11 09:30:00 | AAPL | Stock | 2.2582 | 2.2593 | 2.235 | 2.25 | 45373944.0 |
| 2006-08-11 09:35:00 | AAPL | Stock | 2.25 | 2.255 | 2.2429 | 2.2482 | 29072036.0 |
| 2006-08-11 09:40:00 | AAPL | Stock | 2.2482 | 2.2636 | 2.2446 | 2.2618 | 28272692.0 |
| 2006-08-11 09:45:00 | AAPL | Stock | 2.2621 | 2.2679 | 2.255 | 2.2675 | 33586700.0 |
| 2006-08-11 09:50:00 | AAPL | Stock | 2.2674 | 2.2721 | 2.26 | 2.2621 | 31527076.0 |
| 2006-08-11 09:55:00 | AAPL | Stock | 2.2618 | 2.2711 | 2.2611 | 2.265 | 18109980.0 |
| 2006-08-11 10:00:00 | AAPL | Stock | 2.265 | 2.2686 | 2.2557 | 2.2564 | 14534996.0 |
| 2006-08-11 10:05:00 | AAPL | Stock | 2.2561 | 2.2643 | 2.2507 | 2.2539 | 16893772.0 |
| 2006-08-11 10:10:00 | AAPL | Stock | 2.2539 | 2.2621 | 2.2532 | 2.26 | 18950596.0 |
| 2006-08-11 10:15:00 | AAPL | Stock | 2.26 | 2.2625 | 2.2561 | 2.2618 | 9271416.0 |
| 2006-08-11 10:20:00 | AAPL | Stock | 2.2618 | 2.2796 | 2.2518 | 2.2743 | 21356328.0 |
| 2006-08-11 10:25:00 | AAPL | Stock | 2.2743 | 2.28 | 2.2693 | 2.2764 | 15909712.0 |
| 2006-08-11 10:30:00 | AAPL | Stock | 2.2761 | 2.2786 | 2.2732 | 2.2764 | 10200736.0 |
| 2006-08-11 10:35:00 | AAPL | Stock | 2.2764 | 2.285 | 2.2764 | 2.2814 | 15860600.0 |
| 2006-08-11 10:40:00 | AAPL | Stock | 2.2821 | 2.2836 | 2.2771 | 2.2829 | 8696212.0 |
| 2006-08-11 10:45:00 | AAPL | Stock | 2.2825 | 2.2904 | 2.2807 | 2.2839 | 16078636.0 |
| 2006-08-11 10:50:00 | AAPL | Stock | 2.2839 | 2.2843 | 2.2771 | 2.2771 | 7140336.0 |
| 2006-08-11 10:55:00 | AAPL | Stock | 2.2771 | 2.28 | 2.2746 | 2.2768 | 8260084.0 |
| 2006-08-11 11:00:00 | AAPL | Stock | 2.2764 | 2.2793 | 2.2714 | 2.2768 | 7688464.0 |
| 2006-08-11 11:05:00 | AAPL | Stock | 2.2764 | 2.2811 | 2.275 | 2.2768 | 7206332.0 |
| 2006-08-11 11:10:00 | AAPL | Stock | 2.2757 | 2.285 | 2.2757 | 2.2843 | 5576088.0 |
| 2006-08-11 11:15:00 | AAPL | Stock | 2.2846 | 2.2864 | 2.2818 | 2.2829 | 7314496.0 |
| 2006-08-11 11:20:00 | AAPL | Stock | 2.2829 | 2.2832 | 2.275 | 2.2779 | 8437044.0 |
| 2006-08-11 11:25:00 | AAPL | Stock | 2.2782 | 2.2796 | 2.2743 | 2.2746 | 5280716.0 |
> showing 50 of 218,655 rows — these rows as CSV