PREVIEW / stock_5min / 2009-01-28
file: by_date/stock_5min/2009/2009-01-28.parquet size: 4.4 MB rows: 310,513 symbols: 3,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 |
|---|---|---|---|---|---|---|---|
| 2009-01-28 04:15:00 | AAPL | Stock | 3.2661 | 3.2661 | 3.2661 | 3.2661 | 16800.0 |
| 2009-01-28 04:20:00 | AAPL | Stock | 3.2661 | 3.2661 | 3.2661 | 3.2661 | 14000.0 |
| 2009-01-28 04:30:00 | AAPL | Stock | 3.2661 | 3.2661 | 3.2661 | 3.2661 | 5600.0 |
| 2009-01-28 04:35:00 | AAPL | Stock | 3.2661 | 3.2661 | 3.2661 | 3.2661 | 16800.0 |
| 2009-01-28 04:40:00 | AAPL | Stock | 3.2661 | 3.2661 | 3.2661 | 3.2661 | 2800.0 |
| 2009-01-28 06:35:00 | AAPL | Stock | 3.2768 | 3.2768 | 3.2768 | 3.2768 | 84000.0 |
| 2009-01-28 06:50:00 | AAPL | Stock | 3.2893 | 3.2911 | 3.2807 | 3.2807 | 25200.0 |
| 2009-01-28 06:55:00 | AAPL | Stock | 3.2954 | 3.2954 | 3.2954 | 3.2954 | 28000.0 |
| 2009-01-28 07:05:00 | AAPL | Stock | 3.2857 | 3.2857 | 3.2857 | 3.2857 | 30800.0 |
| 2009-01-28 07:10:00 | AAPL | Stock | 3.3 | 3.3 | 3.2961 | 3.2961 | 14000.0 |
| 2009-01-28 07:15:00 | AAPL | Stock | 3.2961 | 3.2961 | 3.2946 | 3.2946 | 137200.0 |
| 2009-01-28 07:20:00 | AAPL | Stock | 3.2925 | 3.2946 | 3.2925 | 3.2946 | 14000.0 |
| 2009-01-28 07:25:00 | AAPL | Stock | 3.2946 | 3.2946 | 3.2946 | 3.2946 | 42000.0 |
| 2009-01-28 07:35:00 | AAPL | Stock | 3.2857 | 3.2857 | 3.2857 | 3.2857 | 14000.0 |
| 2009-01-28 07:40:00 | AAPL | Stock | 3.2821 | 3.2821 | 3.2821 | 3.2821 | 7560.0 |
| 2009-01-28 07:45:00 | AAPL | Stock | 3.2857 | 3.2857 | 3.2857 | 3.2857 | 25200.0 |
| 2009-01-28 07:50:00 | AAPL | Stock | 3.2946 | 3.2946 | 3.2946 | 3.2946 | 5600.0 |
| 2009-01-28 07:55:00 | AAPL | Stock | 3.2861 | 3.3125 | 3.2857 | 3.3121 | 152516.0 |
| 2009-01-28 08:00:00 | AAPL | Stock | 3.3039 | 3.3039 | 3.2857 | 3.3036 | 391804.0 |
| 2009-01-28 08:05:00 | AAPL | Stock | 3.3036 | 3.3139 | 3.3036 | 3.3139 | 633276.0 |
| 2009-01-28 08:10:00 | AAPL | Stock | 3.3125 | 3.3139 | 3.3079 | 3.3079 | 74116.0 |
| 2009-01-28 08:15:00 | AAPL | Stock | 3.3079 | 3.3125 | 3.3071 | 3.3107 | 95256.0 |
| 2009-01-28 08:20:00 | AAPL | Stock | 3.3121 | 3.3125 | 3.3086 | 3.3107 | 99064.0 |
| 2009-01-28 08:25:00 | AAPL | Stock | 3.3114 | 3.3189 | 3.3089 | 3.3189 | 285376.0 |
| 2009-01-28 08:30:00 | AAPL | Stock | 3.3107 | 3.3175 | 3.3089 | 3.3107 | 238504.0 |
| 2009-01-28 08:35:00 | AAPL | Stock | 3.3125 | 3.3179 | 3.3125 | 3.3146 | 245140.0 |
| 2009-01-28 08:40:00 | AAPL | Stock | 3.3146 | 3.3186 | 3.3143 | 3.3143 | 51492.0 |
| 2009-01-28 08:45:00 | AAPL | Stock | 3.3146 | 3.3154 | 3.3071 | 3.3129 | 334180.0 |
| 2009-01-28 08:50:00 | AAPL | Stock | 3.3107 | 3.3107 | 3.3057 | 3.3071 | 259000.0 |
| 2009-01-28 08:55:00 | AAPL | Stock | 3.3071 | 3.3093 | 3.3064 | 3.3064 | 83664.0 |
| 2009-01-28 09:00:00 | AAPL | Stock | 3.3057 | 3.3089 | 3.3057 | 3.3075 | 134736.0 |
| 2009-01-28 09:05:00 | AAPL | Stock | 3.3082 | 3.3089 | 3.3075 | 3.3089 | 61768.0 |
| 2009-01-28 09:10:00 | AAPL | Stock | 3.3089 | 3.3104 | 3.3036 | 3.3036 | 400848.0 |
| 2009-01-28 09:15:00 | AAPL | Stock | 3.3086 | 3.3086 | 3.3 | 3.3 | 523236.0 |
| 2009-01-28 09:20:00 | AAPL | Stock | 3.3 | 3.3 | 3.2975 | 3.2975 | 156800.0 |
| 2009-01-28 09:25:00 | AAPL | Stock | 3.2964 | 3.2975 | 3.2893 | 3.2893 | 326620.0 |
| 2009-01-28 09:30:00 | AAPL | Stock | 3.29 | 3.2925 | 3.2768 | 3.2854 | 14316820.0 |
| 2009-01-28 09:35:00 | AAPL | Stock | 3.285 | 3.3014 | 3.2825 | 3.2871 | 13326012.0 |
| 2009-01-28 09:40:00 | AAPL | Stock | 3.2879 | 3.2924 | 3.2679 | 3.2696 | 15186136.0 |
| 2009-01-28 09:45:00 | AAPL | Stock | 3.2689 | 3.2764 | 3.2679 | 3.2714 | 9681196.0 |
| 2009-01-28 09:50:00 | AAPL | Stock | 3.2711 | 3.2832 | 3.2704 | 3.2725 | 12433568.0 |
| 2009-01-28 09:55:00 | AAPL | Stock | 3.2721 | 3.2836 | 3.2704 | 3.275 | 8757196.0 |
| 2009-01-28 10:00:00 | AAPL | Stock | 3.275 | 3.2904 | 3.2743 | 3.2771 | 11546752.0 |
| 2009-01-28 10:05:00 | AAPL | Stock | 3.2775 | 3.2843 | 3.2696 | 3.2814 | 11647944.0 |
| 2009-01-28 10:10:00 | AAPL | Stock | 3.2818 | 3.2889 | 3.2782 | 3.2854 | 6349924.0 |
| 2009-01-28 10:15:00 | AAPL | Stock | 3.2857 | 3.2875 | 3.2746 | 3.2839 | 7204960.0 |
| 2009-01-28 10:20:00 | AAPL | Stock | 3.2825 | 3.2843 | 3.2679 | 3.2696 | 8541288.0 |
| 2009-01-28 10:25:00 | AAPL | Stock | 3.2693 | 3.2771 | 3.2679 | 3.2771 | 6416284.0 |
| 2009-01-28 10:30:00 | AAPL | Stock | 3.2775 | 3.29 | 3.275 | 3.2836 | 13418664.0 |
| 2009-01-28 10:35:00 | AAPL | Stock | 3.2836 | 3.2929 | 3.2836 | 3.2893 | 12004384.0 |
> showing 50 of 310,513 rows — these rows as CSV