PREVIEW / stock_5min / 2001-01-04
file: by_date/stock_5min/2001/2001-01-04.parquet size: 1.4 MB rows: 104,472 symbols: 1,265
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-01-04 08:00:00 | AAPL | Stock | 0.2857 | 0.2857 | 0.2857 | 0.2857 | 16800.0 |
| 2001-01-04 08:10:00 | AAPL | Stock | 0.2924 | 0.2924 | 0.2924 | 0.2924 | 28000.0 |
| 2001-01-04 08:15:00 | AAPL | Stock | 0.2924 | 0.2924 | 0.2902 | 0.2902 | 308000.0 |
| 2001-01-04 08:20:00 | AAPL | Stock | 0.2913 | 0.2924 | 0.2902 | 0.2902 | 117600.0 |
| 2001-01-04 08:25:00 | AAPL | Stock | 0.2879 | 0.2902 | 0.2879 | 0.2902 | 151200.0 |
| 2001-01-04 08:35:00 | AAPL | Stock | 0.2902 | 0.2902 | 0.2902 | 0.2902 | 39200.0 |
| 2001-01-04 08:45:00 | AAPL | Stock | 0.2913 | 0.2913 | 0.2913 | 0.2913 | 11200.0 |
| 2001-01-04 08:50:00 | AAPL | Stock | 0.2879 | 0.2913 | 0.2879 | 0.2913 | 173600.0 |
| 2001-01-04 08:55:00 | AAPL | Stock | 0.2913 | 0.2913 | 0.2913 | 0.2913 | 274400.0 |
| 2001-01-04 09:00:00 | AAPL | Stock | 0.2913 | 0.2913 | 0.2879 | 0.2902 | 156800.0 |
| 2001-01-04 09:05:00 | AAPL | Stock | 0.2913 | 0.2924 | 0.2902 | 0.2924 | 459200.0 |
| 2001-01-04 09:10:00 | AAPL | Stock | 0.2969 | 0.3013 | 0.2924 | 0.2991 | 1366400.0 |
| 2001-01-04 09:15:00 | AAPL | Stock | 0.2924 | 0.3192 | 0.2924 | 0.3136 | 9357600.0 |
| 2001-01-04 09:20:00 | AAPL | Stock | 0.317 | 0.3181 | 0.3058 | 0.3147 | 3914400.0 |
| 2001-01-04 09:25:00 | AAPL | Stock | 0.3136 | 0.3259 | 0.3125 | 0.3248 | 15400000.0 |
| 2001-01-04 09:30:00 | AAPL | Stock | 0.3237 | 0.3281 | 0.3192 | 0.3259 | 58581600.0 |
| 2001-01-04 09:35:00 | AAPL | Stock | 0.3248 | 0.3304 | 0.3214 | 0.3214 | 46144000.0 |
| 2001-01-04 09:40:00 | AAPL | Stock | 0.3225 | 0.3259 | 0.308 | 0.3125 | 32933600.0 |
| 2001-01-04 09:45:00 | AAPL | Stock | 0.3125 | 0.3125 | 0.3013 | 0.3047 | 17147200.0 |
| 2001-01-04 09:50:00 | AAPL | Stock | 0.3036 | 0.3103 | 0.3002 | 0.308 | 15584800.0 |
| 2001-01-04 09:55:00 | AAPL | Stock | 0.3092 | 0.3125 | 0.3047 | 0.3114 | 18782400.0 |
| 2001-01-04 10:00:00 | AAPL | Stock | 0.3119 | 0.3147 | 0.308 | 0.3092 | 15601600.0 |
| 2001-01-04 10:05:00 | AAPL | Stock | 0.3103 | 0.3103 | 0.3069 | 0.308 | 12040000.0 |
| 2001-01-04 10:10:00 | AAPL | Stock | 0.308 | 0.3103 | 0.3058 | 0.3103 | 7078400.0 |
| 2001-01-04 10:15:00 | AAPL | Stock | 0.3103 | 0.3125 | 0.308 | 0.3092 | 6311200.0 |
| 2001-01-04 10:20:00 | AAPL | Stock | 0.3069 | 0.3103 | 0.3058 | 0.3069 | 9346400.0 |
| 2001-01-04 10:25:00 | AAPL | Stock | 0.3069 | 0.308 | 0.3013 | 0.3047 | 13165600.0 |
| 2001-01-04 10:30:00 | AAPL | Stock | 0.3047 | 0.3047 | 0.3002 | 0.3036 | 13008800.0 |
| 2001-01-04 10:35:00 | AAPL | Stock | 0.3036 | 0.308 | 0.3036 | 0.3047 | 7078400.0 |
| 2001-01-04 10:40:00 | AAPL | Stock | 0.3058 | 0.3069 | 0.3047 | 0.3058 | 7683200.0 |
| 2001-01-04 10:45:00 | AAPL | Stock | 0.3058 | 0.3114 | 0.3047 | 0.3103 | 12258400.0 |
| 2001-01-04 10:50:00 | AAPL | Stock | 0.3092 | 0.3125 | 0.3092 | 0.3092 | 28084000.0 |
| 2001-01-04 10:55:00 | AAPL | Stock | 0.3092 | 0.3114 | 0.3069 | 0.3103 | 10763200.0 |
| 2001-01-04 11:00:00 | AAPL | Stock | 0.3114 | 0.3125 | 0.3092 | 0.3114 | 9010400.0 |
| 2001-01-04 11:05:00 | AAPL | Stock | 0.3125 | 0.3158 | 0.3125 | 0.3125 | 12163200.0 |
| 2001-01-04 11:10:00 | AAPL | Stock | 0.3136 | 0.3147 | 0.3114 | 0.3136 | 5101600.0 |
| 2001-01-04 11:15:00 | AAPL | Stock | 0.3142 | 0.3158 | 0.3136 | 0.3147 | 5370400.0 |
| 2001-01-04 11:20:00 | AAPL | Stock | 0.3147 | 0.3158 | 0.3103 | 0.3114 | 9788800.0 |
| 2001-01-04 11:25:00 | AAPL | Stock | 0.3103 | 0.3125 | 0.3103 | 0.3114 | 4401600.0 |
| 2001-01-04 11:30:00 | AAPL | Stock | 0.3114 | 0.3125 | 0.3103 | 0.3114 | 2749600.0 |
| 2001-01-04 11:35:00 | AAPL | Stock | 0.3114 | 0.3136 | 0.3114 | 0.3114 | 5118400.0 |
| 2001-01-04 11:40:00 | AAPL | Stock | 0.3114 | 0.3125 | 0.3103 | 0.3125 | 4524800.0 |
| 2001-01-04 11:45:00 | AAPL | Stock | 0.3125 | 0.3142 | 0.3114 | 0.3136 | 5555200.0 |
| 2001-01-04 11:50:00 | AAPL | Stock | 0.3136 | 0.3147 | 0.3125 | 0.3147 | 2340800.0 |
| 2001-01-04 11:55:00 | AAPL | Stock | 0.3147 | 0.317 | 0.3136 | 0.3158 | 5157600.0 |
| 2001-01-04 12:00:00 | AAPL | Stock | 0.3158 | 0.317 | 0.3147 | 0.317 | 15702400.0 |
| 2001-01-04 12:05:00 | AAPL | Stock | 0.317 | 0.3175 | 0.3158 | 0.317 | 7896000.0 |
| 2001-01-04 12:10:00 | AAPL | Stock | 0.3181 | 0.3192 | 0.3158 | 0.317 | 7694400.0 |
| 2001-01-04 12:15:00 | AAPL | Stock | 0.3181 | 0.3192 | 0.317 | 0.3181 | 5975200.0 |
| 2001-01-04 12:20:00 | AAPL | Stock | 0.317 | 0.3181 | 0.3158 | 0.3158 | 3477600.0 |
> showing 50 of 104,472 rows — these rows as CSV