PREVIEW / stock_5min / 2001-01-18
file: by_date/stock_5min/2001/2001-01-18.parquet size: 1.3 MB rows: 103,650 symbols: 1,273
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-18 08:00:00 | AAPL | Stock | 0.3036 | 0.3175 | 0.3036 | 0.3136 | 431200.0 |
| 2001-01-18 08:05:00 | AAPL | Stock | 0.3136 | 0.317 | 0.3136 | 0.3147 | 252000.0 |
| 2001-01-18 08:10:00 | AAPL | Stock | 0.317 | 0.317 | 0.3125 | 0.317 | 179200.0 |
| 2001-01-18 08:15:00 | AAPL | Stock | 0.317 | 0.3192 | 0.3147 | 0.3192 | 1758400.0 |
| 2001-01-18 08:20:00 | AAPL | Stock | 0.3147 | 0.3147 | 0.3136 | 0.3136 | 397600.0 |
| 2001-01-18 08:25:00 | AAPL | Stock | 0.3158 | 0.3158 | 0.3125 | 0.3158 | 448000.0 |
| 2001-01-18 08:30:00 | AAPL | Stock | 0.3158 | 0.3158 | 0.3147 | 0.3158 | 1215200.0 |
| 2001-01-18 08:35:00 | AAPL | Stock | 0.3147 | 0.3147 | 0.3125 | 0.3147 | 1097600.0 |
| 2001-01-18 08:40:00 | AAPL | Stock | 0.3136 | 0.3136 | 0.3136 | 0.3136 | 112000.0 |
| 2001-01-18 08:45:00 | AAPL | Stock | 0.3136 | 0.3147 | 0.3125 | 0.3136 | 772800.0 |
| 2001-01-18 08:50:00 | AAPL | Stock | 0.3136 | 0.3158 | 0.3136 | 0.3158 | 1041600.0 |
| 2001-01-18 08:55:00 | AAPL | Stock | 0.3158 | 0.317 | 0.3158 | 0.3158 | 644000.0 |
| 2001-01-18 09:00:00 | AAPL | Stock | 0.3158 | 0.317 | 0.3158 | 0.317 | 1136800.0 |
| 2001-01-18 09:05:00 | AAPL | Stock | 0.317 | 0.317 | 0.3114 | 0.317 | 1411200.0 |
| 2001-01-18 09:10:00 | AAPL | Stock | 0.317 | 0.3181 | 0.3158 | 0.3158 | 2542400.0 |
| 2001-01-18 09:15:00 | AAPL | Stock | 0.3158 | 0.317 | 0.3158 | 0.3158 | 1685600.0 |
| 2001-01-18 09:20:00 | AAPL | Stock | 0.3092 | 0.317 | 0.3092 | 0.317 | 2917600.0 |
| 2001-01-18 09:25:00 | AAPL | Stock | 0.317 | 0.3181 | 0.3125 | 0.3181 | 6120800.0 |
| 2001-01-18 09:30:00 | AAPL | Stock | 0.3181 | 0.3203 | 0.317 | 0.3181 | 46239200.0 |
| 2001-01-18 09:35:00 | AAPL | Stock | 0.3181 | 0.3192 | 0.3158 | 0.3158 | 43646400.0 |
| 2001-01-18 09:40:00 | AAPL | Stock | 0.3158 | 0.317 | 0.3158 | 0.317 | 12852000.0 |
| 2001-01-18 09:45:00 | AAPL | Stock | 0.3164 | 0.3181 | 0.3147 | 0.317 | 12779200.0 |
| 2001-01-18 09:50:00 | AAPL | Stock | 0.317 | 0.3181 | 0.317 | 0.317 | 16391200.0 |
| 2001-01-18 09:55:00 | AAPL | Stock | 0.3181 | 0.3203 | 0.317 | 0.3192 | 33023200.0 |
| 2001-01-18 10:00:00 | AAPL | Stock | 0.3181 | 0.3203 | 0.3181 | 0.3181 | 21638400.0 |
| 2001-01-18 10:05:00 | AAPL | Stock | 0.3192 | 0.3231 | 0.3181 | 0.3225 | 41557600.0 |
| 2001-01-18 10:10:00 | AAPL | Stock | 0.3214 | 0.3225 | 0.3203 | 0.3214 | 24057600.0 |
| 2001-01-18 10:15:00 | AAPL | Stock | 0.3214 | 0.3225 | 0.3203 | 0.3214 | 22411200.0 |
| 2001-01-18 10:20:00 | AAPL | Stock | 0.3225 | 0.3225 | 0.3203 | 0.3203 | 8786400.0 |
| 2001-01-18 10:25:00 | AAPL | Stock | 0.3203 | 0.3225 | 0.3203 | 0.3225 | 17270400.0 |
| 2001-01-18 10:30:00 | AAPL | Stock | 0.3214 | 0.3225 | 0.3214 | 0.3214 | 13568800.0 |
| 2001-01-18 10:35:00 | AAPL | Stock | 0.322 | 0.3248 | 0.3214 | 0.3237 | 23296000.0 |
| 2001-01-18 10:40:00 | AAPL | Stock | 0.3237 | 0.3259 | 0.3214 | 0.3259 | 25004000.0 |
| 2001-01-18 10:45:00 | AAPL | Stock | 0.3259 | 0.3259 | 0.3225 | 0.3248 | 18709600.0 |
| 2001-01-18 10:50:00 | AAPL | Stock | 0.3248 | 0.3259 | 0.3237 | 0.3248 | 8540000.0 |
| 2001-01-18 10:55:00 | AAPL | Stock | 0.3248 | 0.3259 | 0.3225 | 0.3237 | 11989600.0 |
| 2001-01-18 11:00:00 | AAPL | Stock | 0.3248 | 0.3248 | 0.3214 | 0.3225 | 9699200.0 |
| 2001-01-18 11:05:00 | AAPL | Stock | 0.3237 | 0.3248 | 0.3225 | 0.3248 | 12555200.0 |
| 2001-01-18 11:10:00 | AAPL | Stock | 0.3237 | 0.3248 | 0.3237 | 0.3237 | 23111200.0 |
| 2001-01-18 11:15:00 | AAPL | Stock | 0.3237 | 0.3248 | 0.3214 | 0.3225 | 28571200.0 |
| 2001-01-18 11:20:00 | AAPL | Stock | 0.3225 | 0.3225 | 0.3203 | 0.3209 | 22752800.0 |
| 2001-01-18 11:25:00 | AAPL | Stock | 0.3214 | 0.3214 | 0.3203 | 0.3214 | 5689600.0 |
| 2001-01-18 11:30:00 | AAPL | Stock | 0.3214 | 0.3225 | 0.3203 | 0.3214 | 12706400.0 |
| 2001-01-18 11:35:00 | AAPL | Stock | 0.3225 | 0.3225 | 0.3203 | 0.3214 | 9396800.0 |
| 2001-01-18 11:40:00 | AAPL | Stock | 0.3203 | 0.3214 | 0.3203 | 0.3214 | 5947200.0 |
| 2001-01-18 11:45:00 | AAPL | Stock | 0.3225 | 0.3237 | 0.3214 | 0.3237 | 5656000.0 |
| 2001-01-18 11:50:00 | AAPL | Stock | 0.3237 | 0.3237 | 0.3214 | 0.3225 | 4284000.0 |
| 2001-01-18 11:55:00 | AAPL | Stock | 0.3214 | 0.3225 | 0.3214 | 0.3225 | 3332000.0 |
| 2001-01-18 12:00:00 | AAPL | Stock | 0.3225 | 0.3237 | 0.3214 | 0.3237 | 5062400.0 |
| 2001-01-18 12:05:00 | AAPL | Stock | 0.3237 | 0.3237 | 0.3214 | 0.3214 | 4060000.0 |
> showing 50 of 103,650 rows — these rows as CSV