PREVIEW / stock_5min / 2008-08-28
file: by_date/stock_5min/2008/2008-08-28.parquet size: 4.3 MB rows: 308,009 symbols: 3,308
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 |
|---|---|---|---|---|---|---|---|
| 2008-08-28 07:50:00 | AAPL | Stock | 6.2479 | 6.2479 | 6.2479 | 6.2479 | 2800.0 |
| 2008-08-28 08:00:00 | AAPL | Stock | 6.2007 | 6.2264 | 6.2007 | 6.2232 | 33012.0 |
| 2008-08-28 08:05:00 | AAPL | Stock | 6.2254 | 6.2254 | 6.2214 | 6.2243 | 36092.0 |
| 2008-08-28 08:10:00 | AAPL | Stock | 6.2186 | 6.2218 | 6.2186 | 6.2214 | 64400.0 |
| 2008-08-28 08:15:00 | AAPL | Stock | 6.2214 | 6.2214 | 6.2211 | 6.2211 | 6720.0 |
| 2008-08-28 08:25:00 | AAPL | Stock | 6.2243 | 6.2314 | 6.2236 | 6.2261 | 63280.0 |
| 2008-08-28 08:30:00 | AAPL | Stock | 6.23 | 6.2475 | 6.23 | 6.2418 | 441224.0 |
| 2008-08-28 08:35:00 | AAPL | Stock | 6.2418 | 6.2571 | 6.2357 | 6.25 | 571088.0 |
| 2008-08-28 08:40:00 | AAPL | Stock | 6.2518 | 6.2579 | 6.25 | 6.2571 | 245000.0 |
| 2008-08-28 08:45:00 | AAPL | Stock | 6.2571 | 6.2607 | 6.2557 | 6.2571 | 142912.0 |
| 2008-08-28 08:50:00 | AAPL | Stock | 6.2579 | 6.2618 | 6.2554 | 6.2607 | 429072.0 |
| 2008-08-28 08:55:00 | AAPL | Stock | 6.2607 | 6.2639 | 6.2575 | 6.2618 | 446460.0 |
| 2008-08-28 09:00:00 | AAPL | Stock | 6.2618 | 6.2618 | 6.2589 | 6.2614 | 127092.0 |
| 2008-08-28 09:05:00 | AAPL | Stock | 6.26 | 6.2611 | 6.26 | 6.2607 | 44100.0 |
| 2008-08-28 09:10:00 | AAPL | Stock | 6.2593 | 6.2607 | 6.2582 | 6.2589 | 151004.0 |
| 2008-08-28 09:15:00 | AAPL | Stock | 6.2607 | 6.2607 | 6.2575 | 6.2575 | 77280.0 |
| 2008-08-28 09:20:00 | AAPL | Stock | 6.2568 | 6.2579 | 6.2557 | 6.2579 | 50876.0 |
| 2008-08-28 09:25:00 | AAPL | Stock | 6.26 | 6.2607 | 6.2568 | 6.26 | 138320.0 |
| 2008-08-28 09:30:00 | AAPL | Stock | 6.26 | 6.2946 | 6.2554 | 6.2807 | 17945256.0 |
| 2008-08-28 09:35:00 | AAPL | Stock | 6.2804 | 6.285 | 6.2607 | 6.2607 | 12396076.0 |
| 2008-08-28 09:40:00 | AAPL | Stock | 6.2614 | 6.27 | 6.2436 | 6.2518 | 10550680.0 |
| 2008-08-28 09:45:00 | AAPL | Stock | 6.2518 | 6.2618 | 6.2468 | 6.2578 | 7790804.0 |
| 2008-08-28 09:50:00 | AAPL | Stock | 6.2586 | 6.2736 | 6.2539 | 6.2732 | 7294084.0 |
| 2008-08-28 09:55:00 | AAPL | Stock | 6.2729 | 6.2821 | 6.2711 | 6.2746 | 6489812.0 |
| 2008-08-28 10:00:00 | AAPL | Stock | 6.2746 | 6.2857 | 6.27 | 6.2761 | 8706264.0 |
| 2008-08-28 10:05:00 | AAPL | Stock | 6.2776 | 6.2914 | 6.2739 | 6.2814 | 8354920.0 |
| 2008-08-28 10:10:00 | AAPL | Stock | 6.2818 | 6.2871 | 6.2793 | 6.2832 | 4659424.0 |
| 2008-08-28 10:15:00 | AAPL | Stock | 6.2843 | 6.2929 | 6.2818 | 6.285 | 6662460.0 |
| 2008-08-28 10:20:00 | AAPL | Stock | 6.2854 | 6.2893 | 6.2804 | 6.2871 | 3995180.0 |
| 2008-08-28 10:25:00 | AAPL | Stock | 6.2868 | 6.2871 | 6.2804 | 6.2857 | 3164840.0 |
| 2008-08-28 10:30:00 | AAPL | Stock | 6.285 | 6.2871 | 6.2764 | 6.2789 | 3975412.0 |
| 2008-08-28 10:35:00 | AAPL | Stock | 6.2793 | 6.2929 | 6.2793 | 6.2857 | 6458116.0 |
| 2008-08-28 10:40:00 | AAPL | Stock | 6.2857 | 6.2911 | 6.2825 | 6.2911 | 3707928.0 |
| 2008-08-28 10:45:00 | AAPL | Stock | 6.2896 | 6.2911 | 6.2775 | 6.282 | 5231688.0 |
| 2008-08-28 10:50:00 | AAPL | Stock | 6.2821 | 6.2886 | 6.2721 | 6.2864 | 4707024.0 |
| 2008-08-28 10:55:00 | AAPL | Stock | 6.2861 | 6.2893 | 6.2807 | 6.2825 | 2900744.0 |
| 2008-08-28 11:00:00 | AAPL | Stock | 6.2825 | 6.2875 | 6.2786 | 6.2807 | 3263680.0 |
| 2008-08-28 11:05:00 | AAPL | Stock | 6.2801 | 6.2804 | 6.2714 | 6.2725 | 4234636.0 |
| 2008-08-28 11:10:00 | AAPL | Stock | 6.2725 | 6.2764 | 6.2661 | 6.2716 | 4463956.0 |
| 2008-08-28 11:15:00 | AAPL | Stock | 6.2732 | 6.2814 | 6.2717 | 6.2768 | 3366356.0 |
| 2008-08-28 11:20:00 | AAPL | Stock | 6.2779 | 6.2804 | 6.2614 | 6.2654 | 3452624.0 |
| 2008-08-28 11:25:00 | AAPL | Stock | 6.2657 | 6.2746 | 6.265 | 6.2696 | 2135364.0 |
| 2008-08-28 11:30:00 | AAPL | Stock | 6.2696 | 6.2786 | 6.2696 | 6.2745 | 1672020.0 |
| 2008-08-28 11:35:00 | AAPL | Stock | 6.2754 | 6.2779 | 6.2718 | 6.275 | 2071888.0 |
| 2008-08-28 11:40:00 | AAPL | Stock | 6.275 | 6.2761 | 6.2632 | 6.2682 | 3551016.0 |
| 2008-08-28 11:45:00 | AAPL | Stock | 6.2689 | 6.2768 | 6.2625 | 6.2764 | 3806180.0 |
| 2008-08-28 11:50:00 | AAPL | Stock | 6.2757 | 6.2829 | 6.2704 | 6.2818 | 5185796.0 |
| 2008-08-28 11:55:00 | AAPL | Stock | 6.2814 | 6.285 | 6.2721 | 6.2743 | 4190228.0 |
| 2008-08-28 12:00:00 | AAPL | Stock | 6.2732 | 6.2757 | 6.2571 | 6.2629 | 7357784.0 |
| 2008-08-28 12:05:00 | AAPL | Stock | 6.2621 | 6.2621 | 6.2518 | 6.2586 | 4754680.0 |
> showing 50 of 308,009 rows — these rows as CSV