PREVIEW / stock_5min / 2001-10-09
file: by_date/stock_5min/2001/2001-10-09.parquet size: 1.5 MB rows: 103,335 symbols: 1,341
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 |
|---|---|---|---|---|---|---|---|
| 2001-10-09 08:00:00 | AAPL | Stock | 0.2892 | 0.2892 | 0.2892 | 0.2892 | 162400.0 |
| 2001-10-09 08:35:00 | AAPL | Stock | 0.2893 | 0.2893 | 0.2893 | 0.2893 | 11200.0 |
| 2001-10-09 09:20:00 | AAPL | Stock | 0.2909 | 0.2909 | 0.2902 | 0.2902 | 11200.0 |
| 2001-10-09 09:25:00 | AAPL | Stock | 0.2886 | 0.2886 | 0.2866 | 0.2866 | 151200.0 |
| 2001-10-09 09:30:00 | AAPL | Stock | 0.2866 | 0.2891 | 0.2845 | 0.2889 | 4166400.0 |
| 2001-10-09 09:35:00 | AAPL | Stock | 0.2889 | 0.2893 | 0.2841 | 0.2846 | 4104800.0 |
| 2001-10-09 09:40:00 | AAPL | Stock | 0.2843 | 0.2861 | 0.2839 | 0.285 | 2576000.0 |
| 2001-10-09 09:45:00 | AAPL | Stock | 0.285 | 0.285 | 0.2839 | 0.2845 | 2492000.0 |
| 2001-10-09 09:50:00 | AAPL | Stock | 0.2848 | 0.285 | 0.2841 | 0.2843 | 2402400.0 |
| 2001-10-09 09:55:00 | AAPL | Stock | 0.2841 | 0.2852 | 0.2832 | 0.2846 | 2447200.0 |
| 2001-10-09 10:00:00 | AAPL | Stock | 0.2846 | 0.2852 | 0.2821 | 0.2852 | 3360000.0 |
| 2001-10-09 10:05:00 | AAPL | Stock | 0.2854 | 0.2857 | 0.2831 | 0.285 | 1444800.0 |
| 2001-10-09 10:10:00 | AAPL | Stock | 0.2854 | 0.2859 | 0.2834 | 0.2845 | 1579200.0 |
| 2001-10-09 10:15:00 | AAPL | Stock | 0.284 | 0.2857 | 0.2838 | 0.2854 | 2206400.0 |
| 2001-10-09 10:20:00 | AAPL | Stock | 0.2857 | 0.2866 | 0.2843 | 0.2846 | 2256800.0 |
| 2001-10-09 10:25:00 | AAPL | Stock | 0.2848 | 0.2866 | 0.2841 | 0.2854 | 845600.0 |
| 2001-10-09 10:30:00 | AAPL | Stock | 0.285 | 0.2859 | 0.2848 | 0.2852 | 509600.0 |
| 2001-10-09 10:35:00 | AAPL | Stock | 0.2852 | 0.2871 | 0.285 | 0.2864 | 1388800.0 |
| 2001-10-09 10:40:00 | AAPL | Stock | 0.287 | 0.2873 | 0.2857 | 0.2873 | 1965600.0 |
| 2001-10-09 10:45:00 | AAPL | Stock | 0.2866 | 0.2868 | 0.2859 | 0.2861 | 565600.0 |
| 2001-10-09 10:50:00 | AAPL | Stock | 0.2864 | 0.2889 | 0.2863 | 0.2889 | 1248800.0 |
| 2001-10-09 10:55:00 | AAPL | Stock | 0.2884 | 0.2891 | 0.2877 | 0.2879 | 627200.0 |
| 2001-10-09 11:00:00 | AAPL | Stock | 0.2879 | 0.2879 | 0.2864 | 0.2864 | 1360800.0 |
| 2001-10-09 11:05:00 | AAPL | Stock | 0.2864 | 0.2866 | 0.2854 | 0.2854 | 1008000.0 |
| 2001-10-09 11:10:00 | AAPL | Stock | 0.2854 | 0.2863 | 0.2853 | 0.2863 | 403200.0 |
| 2001-10-09 11:15:00 | AAPL | Stock | 0.2863 | 0.2863 | 0.2854 | 0.2854 | 924000.0 |
| 2001-10-09 11:20:00 | AAPL | Stock | 0.2852 | 0.2852 | 0.2839 | 0.2843 | 739200.0 |
| 2001-10-09 11:25:00 | AAPL | Stock | 0.2843 | 0.2852 | 0.283 | 0.283 | 1467200.0 |
| 2001-10-09 11:30:00 | AAPL | Stock | 0.283 | 0.2839 | 0.2814 | 0.2839 | 3264800.0 |
| 2001-10-09 11:35:00 | AAPL | Stock | 0.2836 | 0.2845 | 0.2823 | 0.2845 | 1915200.0 |
| 2001-10-09 11:40:00 | AAPL | Stock | 0.2839 | 0.2843 | 0.2821 | 0.2829 | 1148000.0 |
| 2001-10-09 11:45:00 | AAPL | Stock | 0.2823 | 0.2823 | 0.2816 | 0.282 | 2682400.0 |
| 2001-10-09 11:50:00 | AAPL | Stock | 0.282 | 0.2827 | 0.2816 | 0.2827 | 974400.0 |
| 2001-10-09 11:55:00 | AAPL | Stock | 0.2823 | 0.2827 | 0.2818 | 0.2825 | 728000.0 |
| 2001-10-09 12:00:00 | AAPL | Stock | 0.2825 | 0.2829 | 0.2813 | 0.2814 | 705600.0 |
| 2001-10-09 12:05:00 | AAPL | Stock | 0.2813 | 0.2825 | 0.2813 | 0.2825 | 408800.0 |
| 2001-10-09 12:10:00 | AAPL | Stock | 0.2829 | 0.2839 | 0.2829 | 0.283 | 1131200.0 |
| 2001-10-09 12:15:00 | AAPL | Stock | 0.2827 | 0.283 | 0.2825 | 0.2825 | 728000.0 |
| 2001-10-09 12:20:00 | AAPL | Stock | 0.2827 | 0.2838 | 0.2827 | 0.2832 | 851200.0 |
| 2001-10-09 12:25:00 | AAPL | Stock | 0.283 | 0.2838 | 0.2827 | 0.283 | 515200.0 |
| 2001-10-09 12:30:00 | AAPL | Stock | 0.2827 | 0.2827 | 0.2814 | 0.2814 | 694400.0 |
| 2001-10-09 12:35:00 | AAPL | Stock | 0.2814 | 0.2821 | 0.2804 | 0.2804 | 2598400.0 |
| 2001-10-09 12:40:00 | AAPL | Stock | 0.2804 | 0.2818 | 0.2804 | 0.2807 | 1629600.0 |
| 2001-10-09 12:45:00 | AAPL | Stock | 0.2809 | 0.2811 | 0.2798 | 0.2798 | 907200.0 |
| 2001-10-09 12:50:00 | AAPL | Stock | 0.2798 | 0.2804 | 0.2791 | 0.2802 | 716800.0 |
| 2001-10-09 12:55:00 | AAPL | Stock | 0.2805 | 0.2805 | 0.2796 | 0.2798 | 397600.0 |
| 2001-10-09 13:00:00 | AAPL | Stock | 0.2798 | 0.2802 | 0.2798 | 0.28 | 341600.0 |
| 2001-10-09 13:05:00 | AAPL | Stock | 0.2801 | 0.2827 | 0.2801 | 0.2827 | 1400000.0 |
| 2001-10-09 13:10:00 | AAPL | Stock | 0.2825 | 0.2834 | 0.2823 | 0.2832 | 1797600.0 |
| 2001-10-09 13:15:00 | AAPL | Stock | 0.2834 | 0.2839 | 0.2813 | 0.2816 | 1590400.0 |
> showing 50 of 103,335 rows — these rows as CSV