PREVIEW / stock_5min / 2009-01-07
file: by_date/stock_5min/2009/2009-01-07.parquet size: 4.5 MB rows: 313,607 symbols: 3,325
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 |
|---|---|---|---|---|---|---|---|
| 2009-01-07 07:55:00 | AAPL | Stock | 3.2875 | 3.2875 | 3.2875 | 3.2875 | 23800.0 |
| 2009-01-07 08:00:00 | AAPL | Stock | 3.3 | 3.3007 | 3.2821 | 3.2857 | 208040.0 |
| 2009-01-07 08:05:00 | AAPL | Stock | 3.2854 | 3.2861 | 3.2821 | 3.2821 | 100044.0 |
| 2009-01-07 08:10:00 | AAPL | Stock | 3.2825 | 3.2825 | 3.2704 | 3.2804 | 106932.0 |
| 2009-01-07 08:15:00 | AAPL | Stock | 3.2786 | 3.2821 | 3.2714 | 3.2736 | 461076.0 |
| 2009-01-07 08:20:00 | AAPL | Stock | 3.2718 | 3.2768 | 3.2714 | 3.2736 | 54908.0 |
| 2009-01-07 08:25:00 | AAPL | Stock | 3.2736 | 3.2821 | 3.2736 | 3.2786 | 51100.0 |
| 2009-01-07 08:30:00 | AAPL | Stock | 3.2789 | 3.2821 | 3.2779 | 3.2814 | 163240.0 |
| 2009-01-07 08:35:00 | AAPL | Stock | 3.2814 | 3.2843 | 3.2793 | 3.2793 | 100464.0 |
| 2009-01-07 08:40:00 | AAPL | Stock | 3.28 | 3.2843 | 3.2786 | 3.2821 | 307748.0 |
| 2009-01-07 08:45:00 | AAPL | Stock | 3.2804 | 3.2936 | 3.28 | 3.2936 | 233100.0 |
| 2009-01-07 08:50:00 | AAPL | Stock | 3.2932 | 3.3036 | 3.2911 | 3.2939 | 252420.0 |
| 2009-01-07 08:55:00 | AAPL | Stock | 3.2946 | 3.2975 | 3.2857 | 3.2904 | 203000.0 |
| 2009-01-07 09:00:00 | AAPL | Stock | 3.2879 | 3.2879 | 3.2714 | 3.2836 | 991508.0 |
| 2009-01-07 09:05:00 | AAPL | Stock | 3.2793 | 3.2793 | 3.2757 | 3.2782 | 336616.0 |
| 2009-01-07 09:10:00 | AAPL | Stock | 3.2768 | 3.2782 | 3.2714 | 3.2714 | 336672.0 |
| 2009-01-07 09:15:00 | AAPL | Stock | 3.2754 | 3.2804 | 3.2714 | 3.275 | 211176.0 |
| 2009-01-07 09:20:00 | AAPL | Stock | 3.2768 | 3.2768 | 3.2714 | 3.2732 | 258468.0 |
| 2009-01-07 09:25:00 | AAPL | Stock | 3.2736 | 3.2786 | 3.2714 | 3.2786 | 215600.0 |
| 2009-01-07 09:30:00 | AAPL | Stock | 3.2786 | 3.2789 | 3.25 | 3.2636 | 23447872.0 |
| 2009-01-07 09:35:00 | AAPL | Stock | 3.2643 | 3.2711 | 3.2393 | 3.2471 | 25887064.0 |
| 2009-01-07 09:40:00 | AAPL | Stock | 3.2482 | 3.2564 | 3.2386 | 3.2504 | 19128872.0 |
| 2009-01-07 09:45:00 | AAPL | Stock | 3.2504 | 3.2779 | 3.2489 | 3.2768 | 15967336.0 |
| 2009-01-07 09:50:00 | AAPL | Stock | 3.2764 | 3.2857 | 3.2721 | 3.2804 | 21760732.0 |
| 2009-01-07 09:55:00 | AAPL | Stock | 3.2804 | 3.295 | 3.2757 | 3.29 | 14053900.0 |
| 2009-01-07 10:00:00 | AAPL | Stock | 3.2904 | 3.2979 | 3.2732 | 3.2793 | 15769404.0 |
| 2009-01-07 10:05:00 | AAPL | Stock | 3.2791 | 3.2793 | 3.2592 | 3.2668 | 12952072.0 |
| 2009-01-07 10:10:00 | AAPL | Stock | 3.2671 | 3.2704 | 3.2418 | 3.2468 | 14463232.0 |
| 2009-01-07 10:15:00 | AAPL | Stock | 3.2468 | 3.2521 | 3.2389 | 3.2468 | 12698392.0 |
| 2009-01-07 10:20:00 | AAPL | Stock | 3.2464 | 3.25 | 3.2396 | 3.2432 | 9677976.0 |
| 2009-01-07 10:25:00 | AAPL | Stock | 3.2436 | 3.2482 | 3.2329 | 3.2464 | 11486776.0 |
| 2009-01-07 10:30:00 | AAPL | Stock | 3.2457 | 3.2557 | 3.2321 | 3.2543 | 12632032.0 |
| 2009-01-07 10:35:00 | AAPL | Stock | 3.2536 | 3.2693 | 3.2489 | 3.2621 | 11901652.0 |
| 2009-01-07 10:40:00 | AAPL | Stock | 3.262 | 3.2668 | 3.2582 | 3.2636 | 6823096.0 |
| 2009-01-07 10:45:00 | AAPL | Stock | 3.2632 | 3.2729 | 3.2571 | 3.2668 | 7854056.0 |
| 2009-01-07 10:50:00 | AAPL | Stock | 3.2664 | 3.2721 | 3.2579 | 3.2686 | 7437556.0 |
| 2009-01-07 10:55:00 | AAPL | Stock | 3.2686 | 3.2761 | 3.2636 | 3.2721 | 7038024.0 |
| 2009-01-07 11:00:00 | AAPL | Stock | 3.2721 | 3.2843 | 3.2679 | 3.2789 | 9549848.0 |
| 2009-01-07 11:05:00 | AAPL | Stock | 3.2789 | 3.285 | 3.2764 | 3.2779 | 7144368.0 |
| 2009-01-07 11:10:00 | AAPL | Stock | 3.2775 | 3.2779 | 3.2707 | 3.2757 | 7249620.0 |
| 2009-01-07 11:15:00 | AAPL | Stock | 3.2764 | 3.2846 | 3.2707 | 3.2718 | 7082824.0 |
| 2009-01-07 11:20:00 | AAPL | Stock | 3.2718 | 3.2732 | 3.2661 | 3.2714 | 6608616.0 |
| 2009-01-07 11:25:00 | AAPL | Stock | 3.2718 | 3.2764 | 3.2664 | 3.2707 | 5212088.0 |
| 2009-01-07 11:30:00 | AAPL | Stock | 3.2704 | 3.2732 | 3.2632 | 3.2679 | 6148660.0 |
| 2009-01-07 11:35:00 | AAPL | Stock | 3.2675 | 3.2692 | 3.2596 | 3.2636 | 5059992.0 |
| 2009-01-07 11:40:00 | AAPL | Stock | 3.2636 | 3.2818 | 3.2625 | 3.2786 | 6487292.0 |
| 2009-01-07 11:45:00 | AAPL | Stock | 3.2789 | 3.2864 | 3.2778 | 3.2857 | 6868876.0 |
| 2009-01-07 11:50:00 | AAPL | Stock | 3.2857 | 3.2911 | 3.2786 | 3.2832 | 8102416.0 |
| 2009-01-07 11:55:00 | AAPL | Stock | 3.2829 | 3.2836 | 3.2707 | 3.2739 | 5254564.0 |
| 2009-01-07 12:00:00 | AAPL | Stock | 3.2743 | 3.2754 | 3.2661 | 3.2693 | 5337164.0 |
> showing 50 of 313,607 rows — these rows as CSV