PREVIEW / stock_5min / 2001-09-18
file: by_date/stock_5min/2001/2001-09-18.parquet size: 1.6 MB rows: 111,775 symbols: 1,339
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-09-18 08:20:00 | AAPL | Stock | 0.3053 | 0.3571 | 0.3032 | 0.3034 | 207200.0 |
| 2001-09-18 08:40:00 | AAPL | Stock | 0.3034 | 0.3034 | 0.3034 | 0.3034 | 1125600.0 |
| 2001-09-18 08:50:00 | AAPL | Stock | 0.3018 | 0.3018 | 0.3018 | 0.3018 | 5600.0 |
| 2001-09-18 08:55:00 | AAPL | Stock | 0.303 | 0.303 | 0.303 | 0.303 | 56000.0 |
| 2001-09-18 09:10:00 | AAPL | Stock | 0.3034 | 0.3034 | 0.3034 | 0.3034 | 78400.0 |
| 2001-09-18 09:15:00 | AAPL | Stock | 0.3034 | 0.3034 | 0.3034 | 0.3034 | 1321600.0 |
| 2001-09-18 09:25:00 | AAPL | Stock | 0.3032 | 0.3032 | 0.3018 | 0.3018 | 145600.0 |
| 2001-09-18 09:30:00 | AAPL | Stock | 0.3018 | 0.3039 | 0.2986 | 0.2986 | 4866400.0 |
| 2001-09-18 09:35:00 | AAPL | Stock | 0.2986 | 0.3005 | 0.2968 | 0.2998 | 4698400.0 |
| 2001-09-18 09:40:00 | AAPL | Stock | 0.2998 | 0.2998 | 0.2982 | 0.2988 | 5012000.0 |
| 2001-09-18 09:45:00 | AAPL | Stock | 0.2988 | 0.3027 | 0.2988 | 0.3018 | 5364800.0 |
| 2001-09-18 09:50:00 | AAPL | Stock | 0.3011 | 0.3036 | 0.3007 | 0.3036 | 3662400.0 |
| 2001-09-18 09:55:00 | AAPL | Stock | 0.3034 | 0.3054 | 0.3016 | 0.3038 | 2553600.0 |
| 2001-09-18 10:00:00 | AAPL | Stock | 0.3038 | 0.3045 | 0.3021 | 0.303 | 2010400.0 |
| 2001-09-18 10:05:00 | AAPL | Stock | 0.3034 | 0.3052 | 0.303 | 0.305 | 1836800.0 |
| 2001-09-18 10:10:00 | AAPL | Stock | 0.305 | 0.3089 | 0.305 | 0.3086 | 5896800.0 |
| 2001-09-18 10:15:00 | AAPL | Stock | 0.3079 | 0.3139 | 0.3079 | 0.3125 | 7414400.0 |
| 2001-09-18 10:20:00 | AAPL | Stock | 0.3116 | 0.3143 | 0.3116 | 0.3132 | 6977600.0 |
| 2001-09-18 10:25:00 | AAPL | Stock | 0.3132 | 0.3139 | 0.3127 | 0.3134 | 3438400.0 |
| 2001-09-18 10:30:00 | AAPL | Stock | 0.3134 | 0.3139 | 0.3107 | 0.312 | 4984000.0 |
| 2001-09-18 10:35:00 | AAPL | Stock | 0.3113 | 0.3138 | 0.3113 | 0.3127 | 1349600.0 |
| 2001-09-18 10:40:00 | AAPL | Stock | 0.3127 | 0.3161 | 0.3118 | 0.3161 | 4172000.0 |
| 2001-09-18 10:45:00 | AAPL | Stock | 0.3161 | 0.3164 | 0.3113 | 0.3113 | 3505600.0 |
| 2001-09-18 10:50:00 | AAPL | Stock | 0.3114 | 0.312 | 0.3084 | 0.3088 | 2027200.0 |
| 2001-09-18 10:55:00 | AAPL | Stock | 0.3089 | 0.312 | 0.308 | 0.3109 | 2615200.0 |
| 2001-09-18 11:00:00 | AAPL | Stock | 0.31 | 0.3114 | 0.3029 | 0.3029 | 4177600.0 |
| 2001-09-18 11:05:00 | AAPL | Stock | 0.3029 | 0.3041 | 0.3027 | 0.3036 | 2016000.0 |
| 2001-09-18 11:10:00 | AAPL | Stock | 0.3038 | 0.3038 | 0.2988 | 0.2988 | 3264800.0 |
| 2001-09-18 11:15:00 | AAPL | Stock | 0.2988 | 0.3018 | 0.2964 | 0.3013 | 4205600.0 |
| 2001-09-18 11:20:00 | AAPL | Stock | 0.3018 | 0.3023 | 0.3005 | 0.3005 | 1500800.0 |
| 2001-09-18 11:25:00 | AAPL | Stock | 0.3004 | 0.3004 | 0.2982 | 0.2986 | 2184000.0 |
| 2001-09-18 11:30:00 | AAPL | Stock | 0.2989 | 0.2991 | 0.2966 | 0.2973 | 1853600.0 |
| 2001-09-18 11:35:00 | AAPL | Stock | 0.2975 | 0.2982 | 0.2968 | 0.2977 | 3494400.0 |
| 2001-09-18 11:40:00 | AAPL | Stock | 0.2977 | 0.3004 | 0.2977 | 0.2995 | 3992800.0 |
| 2001-09-18 11:45:00 | AAPL | Stock | 0.2993 | 0.3021 | 0.2991 | 0.3016 | 940800.0 |
| 2001-09-18 11:50:00 | AAPL | Stock | 0.3016 | 0.3025 | 0.3004 | 0.3014 | 2402400.0 |
| 2001-09-18 11:55:00 | AAPL | Stock | 0.3018 | 0.3021 | 0.3007 | 0.3009 | 576800.0 |
| 2001-09-18 12:00:00 | AAPL | Stock | 0.3009 | 0.302 | 0.3005 | 0.3013 | 476000.0 |
| 2001-09-18 12:05:00 | AAPL | Stock | 0.3011 | 0.3023 | 0.3009 | 0.3021 | 14632800.0 |
| 2001-09-18 12:10:00 | AAPL | Stock | 0.3023 | 0.3027 | 0.3 | 0.3005 | 4004000.0 |
| 2001-09-18 12:15:00 | AAPL | Stock | 0.3013 | 0.3014 | 0.3003 | 0.3009 | 985600.0 |
| 2001-09-18 12:20:00 | AAPL | Stock | 0.3009 | 0.3014 | 0.3005 | 0.3005 | 980000.0 |
| 2001-09-18 12:25:00 | AAPL | Stock | 0.3009 | 0.3012 | 0.2995 | 0.2995 | 1741600.0 |
| 2001-09-18 12:30:00 | AAPL | Stock | 0.2995 | 0.3 | 0.2986 | 0.3 | 2906400.0 |
| 2001-09-18 12:35:00 | AAPL | Stock | 0.2998 | 0.3 | 0.2993 | 0.2993 | 2032800.0 |
| 2001-09-18 12:40:00 | AAPL | Stock | 0.2996 | 0.3 | 0.2995 | 0.2996 | 1265600.0 |
| 2001-09-18 12:45:00 | AAPL | Stock | 0.2995 | 0.3009 | 0.2995 | 0.3007 | 6742400.0 |
| 2001-09-18 12:50:00 | AAPL | Stock | 0.3007 | 0.3009 | 0.3 | 0.3007 | 1092000.0 |
| 2001-09-18 12:55:00 | AAPL | Stock | 0.3002 | 0.3009 | 0.3 | 0.3007 | 341600.0 |
| 2001-09-18 13:00:00 | AAPL | Stock | 0.3004 | 0.3004 | 0.2986 | 0.2986 | 1058400.0 |
> showing 50 of 111,775 rows — these rows as CSV