PREVIEW / stock_5min / 2005-06-30
file: by_date/stock_5min/2005/2005-06-30.parquet size: 2.7 MB rows: 196,405 symbols: 2,030
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-06-30 08:10:00 | AAPL | Stock | 1.2989 | 1.3025 | 1.2989 | 1.3025 | 37520.0 |
| 2005-06-30 08:15:00 | AAPL | Stock | 1.3057 | 1.3071 | 1.3032 | 1.3068 | 137200.0 |
| 2005-06-30 08:30:00 | AAPL | Stock | 1.3054 | 1.3068 | 1.3054 | 1.3068 | 181636.0 |
| 2005-06-30 08:35:00 | AAPL | Stock | 1.3043 | 1.3071 | 1.3043 | 1.3071 | 61600.0 |
| 2005-06-30 08:40:00 | AAPL | Stock | 1.3086 | 1.3086 | 1.3046 | 1.3071 | 61600.0 |
| 2005-06-30 08:55:00 | AAPL | Stock | 1.3089 | 1.3125 | 1.3089 | 1.3111 | 98000.0 |
| 2005-06-30 09:00:00 | AAPL | Stock | 1.3107 | 1.3111 | 1.3089 | 1.3089 | 43400.0 |
| 2005-06-30 09:10:00 | AAPL | Stock | 1.3075 | 1.3075 | 1.3054 | 1.3054 | 61600.0 |
| 2005-06-30 09:15:00 | AAPL | Stock | 1.3054 | 1.3054 | 1.3054 | 1.3054 | 5600.0 |
| 2005-06-30 09:20:00 | AAPL | Stock | 1.3054 | 1.3054 | 1.3054 | 1.3054 | 5600.0 |
| 2005-06-30 09:25:00 | AAPL | Stock | 1.3054 | 1.3075 | 1.3021 | 1.3071 | 1252300.0 |
| 2005-06-30 09:30:00 | AAPL | Stock | 1.3075 | 1.3136 | 1.3057 | 1.3064 | 17025064.0 |
| 2005-06-30 09:35:00 | AAPL | Stock | 1.3068 | 1.3075 | 1.3039 | 1.3064 | 8311744.0 |
| 2005-06-30 09:40:00 | AAPL | Stock | 1.3064 | 1.3075 | 1.3043 | 1.3057 | 7893984.0 |
| 2005-06-30 09:45:00 | AAPL | Stock | 1.3057 | 1.3071 | 1.3032 | 1.3054 | 5511940.0 |
| 2005-06-30 09:50:00 | AAPL | Stock | 1.305 | 1.3054 | 1.3004 | 1.3004 | 4461632.0 |
| 2005-06-30 09:55:00 | AAPL | Stock | 1.3004 | 1.3032 | 1.2968 | 1.2996 | 6907768.0 |
| 2005-06-30 10:00:00 | AAPL | Stock | 1.2996 | 1.3004 | 1.2971 | 1.2996 | 5519920.0 |
| 2005-06-30 10:05:00 | AAPL | Stock | 1.3 | 1.3 | 1.2982 | 1.2993 | 2925468.0 |
| 2005-06-30 10:10:00 | AAPL | Stock | 1.2993 | 1.2996 | 1.2979 | 1.2993 | 2181928.0 |
| 2005-06-30 10:15:00 | AAPL | Stock | 1.2989 | 1.3 | 1.2986 | 1.2996 | 4947684.0 |
| 2005-06-30 10:20:00 | AAPL | Stock | 1.2993 | 1.2996 | 1.2979 | 1.2982 | 5142928.0 |
| 2005-06-30 10:25:00 | AAPL | Stock | 1.2982 | 1.2989 | 1.2979 | 1.2982 | 2146424.0 |
| 2005-06-30 10:30:00 | AAPL | Stock | 1.2982 | 1.2989 | 1.2979 | 1.2979 | 1903244.0 |
| 2005-06-30 10:35:00 | AAPL | Stock | 1.2986 | 1.2989 | 1.2982 | 1.2986 | 2094008.0 |
| 2005-06-30 10:40:00 | AAPL | Stock | 1.2989 | 1.3054 | 1.2986 | 1.3046 | 8951488.0 |
| 2005-06-30 10:45:00 | AAPL | Stock | 1.3043 | 1.3061 | 1.3021 | 1.305 | 5433484.0 |
| 2005-06-30 10:50:00 | AAPL | Stock | 1.3054 | 1.3054 | 1.3036 | 1.305 | 3787420.0 |
| 2005-06-30 10:55:00 | AAPL | Stock | 1.305 | 1.305 | 1.3014 | 1.3032 | 2987544.0 |
| 2005-06-30 11:00:00 | AAPL | Stock | 1.3032 | 1.3043 | 1.3007 | 1.3032 | 7017388.0 |
| 2005-06-30 11:05:00 | AAPL | Stock | 1.3032 | 1.3061 | 1.3014 | 1.3039 | 3917004.0 |
| 2005-06-30 11:10:00 | AAPL | Stock | 1.3039 | 1.3054 | 1.3029 | 1.3039 | 3790780.0 |
| 2005-06-30 11:15:00 | AAPL | Stock | 1.3039 | 1.3054 | 1.3032 | 1.305 | 2571156.0 |
| 2005-06-30 11:20:00 | AAPL | Stock | 1.305 | 1.305 | 1.3025 | 1.305 | 2985360.0 |
| 2005-06-30 11:25:00 | AAPL | Stock | 1.3054 | 1.3061 | 1.3043 | 1.305 | 2198532.0 |
| 2005-06-30 11:30:00 | AAPL | Stock | 1.305 | 1.3057 | 1.3029 | 1.3032 | 2436196.0 |
| 2005-06-30 11:35:00 | AAPL | Stock | 1.3032 | 1.3057 | 1.3029 | 1.305 | 1579116.0 |
| 2005-06-30 11:40:00 | AAPL | Stock | 1.305 | 1.305 | 1.3029 | 1.3029 | 1299676.0 |
| 2005-06-30 11:45:00 | AAPL | Stock | 1.3029 | 1.3043 | 1.3021 | 1.3025 | 1842540.0 |
| 2005-06-30 11:50:00 | AAPL | Stock | 1.3029 | 1.3036 | 1.3025 | 1.3032 | 1574160.0 |
| 2005-06-30 11:55:00 | AAPL | Stock | 1.3032 | 1.3043 | 1.3029 | 1.3043 | 755216.0 |
| 2005-06-30 12:00:00 | AAPL | Stock | 1.3043 | 1.3043 | 1.3029 | 1.3036 | 1274588.0 |
| 2005-06-30 12:05:00 | AAPL | Stock | 1.3036 | 1.3036 | 1.3032 | 1.3035 | 1549436.0 |
| 2005-06-30 12:10:00 | AAPL | Stock | 1.3036 | 1.3046 | 1.3029 | 1.3043 | 1343832.0 |
| 2005-06-30 12:15:00 | AAPL | Stock | 1.3043 | 1.3064 | 1.3039 | 1.3061 | 2445716.0 |
| 2005-06-30 12:20:00 | AAPL | Stock | 1.3064 | 1.3064 | 1.3039 | 1.3043 | 928620.0 |
| 2005-06-30 12:25:00 | AAPL | Stock | 1.3043 | 1.3054 | 1.3039 | 1.3054 | 972972.0 |
| 2005-06-30 12:30:00 | AAPL | Stock | 1.305 | 1.3071 | 1.305 | 1.3071 | 2267188.0 |
| 2005-06-30 12:35:00 | AAPL | Stock | 1.3071 | 1.3121 | 1.3071 | 1.3112 | 8834308.0 |
| 2005-06-30 12:40:00 | AAPL | Stock | 1.3114 | 1.3118 | 1.3082 | 1.3107 | 3941672.0 |
> showing 50 of 196,405 rows — these rows as CSV