PREVIEW / stock_5min / 2005-01-13
file: by_date/stock_5min/2005/2005-01-13.parquet size: 2.6 MB rows: 188,790 symbols: 1,906
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 |
|---|---|---|---|---|---|---|---|
| 2005-01-13 08:00:00 | AAPL | Stock | 1.3182 | 1.3241 | 1.3036 | 1.3068 | 20779752.0 |
| 2005-01-13 08:05:00 | AAPL | Stock | 1.3071 | 1.3173 | 1.3046 | 1.317 | 6511064.0 |
| 2005-01-13 08:10:00 | AAPL | Stock | 1.3161 | 1.3188 | 1.3125 | 1.3161 | 3709160.0 |
| 2005-01-13 08:15:00 | AAPL | Stock | 1.3161 | 1.317 | 1.3134 | 1.3161 | 3298176.0 |
| 2005-01-13 08:20:00 | AAPL | Stock | 1.3152 | 1.3166 | 1.3125 | 1.3155 | 5158160.0 |
| 2005-01-13 08:25:00 | AAPL | Stock | 1.3164 | 1.3248 | 1.3125 | 1.3248 | 11748464.0 |
| 2005-01-13 08:30:00 | AAPL | Stock | 1.3239 | 1.3295 | 1.3202 | 1.3241 | 12669720.0 |
| 2005-01-13 08:35:00 | AAPL | Stock | 1.3241 | 1.3295 | 1.3216 | 1.3241 | 7461440.0 |
| 2005-01-13 08:40:00 | AAPL | Stock | 1.3241 | 1.3268 | 1.3223 | 1.3254 | 21649264.0 |
| 2005-01-13 08:45:00 | AAPL | Stock | 1.325 | 1.3277 | 1.3241 | 1.3268 | 9971080.0 |
| 2005-01-13 08:50:00 | AAPL | Stock | 1.3268 | 1.3277 | 1.3246 | 1.325 | 10320688.0 |
| 2005-01-13 08:55:00 | AAPL | Stock | 1.3252 | 1.3304 | 1.3245 | 1.33 | 11077752.0 |
| 2005-01-13 09:00:00 | AAPL | Stock | 1.33 | 1.332 | 1.3261 | 1.3289 | 10185616.0 |
| 2005-01-13 09:05:00 | AAPL | Stock | 1.3286 | 1.3289 | 1.3261 | 1.3277 | 3980312.0 |
| 2005-01-13 09:10:00 | AAPL | Stock | 1.3277 | 1.3304 | 1.3266 | 1.3298 | 7201208.0 |
| 2005-01-13 09:15:00 | AAPL | Stock | 1.3298 | 1.3313 | 1.325 | 1.3252 | 10713752.0 |
| 2005-01-13 09:20:00 | AAPL | Stock | 1.3252 | 1.3259 | 1.3179 | 1.3213 | 15220128.0 |
| 2005-01-13 09:25:00 | AAPL | Stock | 1.3213 | 1.3266 | 1.3036 | 1.3155 | 24093384.0 |
| 2005-01-13 09:30:00 | AAPL | Stock | 1.3152 | 1.3289 | 1.2995 | 1.3055 | 212720816.0 |
| 2005-01-13 09:35:00 | AAPL | Stock | 1.3052 | 1.3152 | 1.3027 | 1.3104 | 123504696.0 |
| 2005-01-13 09:40:00 | AAPL | Stock | 1.3098 | 1.3132 | 1.2979 | 1.3027 | 106123360.0 |
| 2005-01-13 09:45:00 | AAPL | Stock | 1.3025 | 1.3041 | 1.2913 | 1.2913 | 101594976.0 |
| 2005-01-13 09:50:00 | AAPL | Stock | 1.2914 | 1.3214 | 1.2911 | 1.2986 | 115085544.0 |
| 2005-01-13 09:55:00 | AAPL | Stock | 1.2984 | 1.2998 | 1.2879 | 1.2884 | 93801176.0 |
| 2005-01-13 10:00:00 | AAPL | Stock | 1.2886 | 1.2964 | 1.28 | 1.2864 | 107040416.0 |
| 2005-01-13 10:05:00 | AAPL | Stock | 1.2864 | 1.2995 | 1.2768 | 1.2802 | 92540728.0 |
| 2005-01-13 10:10:00 | AAPL | Stock | 1.2802 | 1.2891 | 1.2679 | 1.2829 | 91643160.0 |
| 2005-01-13 10:15:00 | AAPL | Stock | 1.2829 | 1.2877 | 1.2796 | 1.2857 | 53206384.0 |
| 2005-01-13 10:20:00 | AAPL | Stock | 1.2859 | 1.2929 | 1.285 | 1.2864 | 67103008.0 |
| 2005-01-13 10:25:00 | AAPL | Stock | 1.2864 | 1.2964 | 1.2858 | 1.2932 | 51222920.0 |
| 2005-01-13 10:30:00 | AAPL | Stock | 1.2932 | 1.3127 | 1.2875 | 1.2929 | 52329928.0 |
| 2005-01-13 10:35:00 | AAPL | Stock | 1.2929 | 1.2955 | 1.2884 | 1.2896 | 51002280.0 |
| 2005-01-13 10:40:00 | AAPL | Stock | 1.2898 | 1.2911 | 1.2857 | 1.2889 | 34257216.0 |
| 2005-01-13 10:45:00 | AAPL | Stock | 1.2889 | 1.2902 | 1.283 | 1.2863 | 42018760.0 |
| 2005-01-13 10:50:00 | AAPL | Stock | 1.2863 | 1.2893 | 1.2813 | 1.2829 | 31047520.0 |
| 2005-01-13 10:55:00 | AAPL | Stock | 1.2829 | 1.2848 | 1.2809 | 1.2827 | 32907560.0 |
| 2005-01-13 11:00:00 | AAPL | Stock | 1.2827 | 1.2868 | 1.2793 | 1.2854 | 31833032.0 |
| 2005-01-13 11:05:00 | AAPL | Stock | 1.2854 | 1.2855 | 1.2821 | 1.2825 | 17799040.0 |
| 2005-01-13 11:10:00 | AAPL | Stock | 1.2825 | 1.2843 | 1.2795 | 1.2816 | 15793176.0 |
| 2005-01-13 11:15:00 | AAPL | Stock | 1.2816 | 1.2836 | 1.2804 | 1.2821 | 16971528.0 |
| 2005-01-13 11:20:00 | AAPL | Stock | 1.2827 | 1.2834 | 1.2795 | 1.2795 | 15765568.0 |
| 2005-01-13 11:25:00 | AAPL | Stock | 1.2795 | 1.2804 | 1.2727 | 1.273 | 35190848.0 |
| 2005-01-13 11:30:00 | AAPL | Stock | 1.2732 | 1.2754 | 1.2704 | 1.2752 | 46160576.0 |
| 2005-01-13 11:35:00 | AAPL | Stock | 1.2752 | 1.2825 | 1.2718 | 1.273 | 20485528.0 |
| 2005-01-13 11:40:00 | AAPL | Stock | 1.2732 | 1.2732 | 1.2652 | 1.2675 | 48307672.0 |
| 2005-01-13 11:45:00 | AAPL | Stock | 1.2673 | 1.2673 | 1.2614 | 1.2643 | 60419016.0 |
| 2005-01-13 11:50:00 | AAPL | Stock | 1.2643 | 1.2705 | 1.2639 | 1.27 | 32657240.0 |
| 2005-01-13 11:55:00 | AAPL | Stock | 1.2702 | 1.2704 | 1.267 | 1.2677 | 16230144.0 |
| 2005-01-13 12:00:00 | AAPL | Stock | 1.2677 | 1.2727 | 1.2657 | 1.2713 | 24551352.0 |
| 2005-01-13 12:05:00 | AAPL | Stock | 1.2714 | 1.275 | 1.2711 | 1.2732 | 17566976.0 |
> showing 50 of 188,790 rows — these rows as CSV