PREVIEW / stock_5min / 2001-03-01
file: by_date/stock_5min/2001/2001-03-01.parquet size: 1.5 MB rows: 100,816 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-03-01 08:35:00 | AAPL | Stock | 0.3203 | 0.3203 | 0.3203 | 0.3203 | 78400.0 |
| 2001-03-01 08:50:00 | AAPL | Stock | 0.3181 | 0.3192 | 0.3181 | 0.3192 | 100800.0 |
| 2001-03-01 08:55:00 | AAPL | Stock | 0.3181 | 0.3181 | 0.3181 | 0.3181 | 11200.0 |
| 2001-03-01 09:00:00 | AAPL | Stock | 0.3192 | 0.3192 | 0.3192 | 0.3192 | 5600.0 |
| 2001-03-01 09:10:00 | AAPL | Stock | 0.3203 | 0.3203 | 0.3203 | 0.3203 | 67200.0 |
| 2001-03-01 09:15:00 | AAPL | Stock | 0.3203 | 0.3259 | 0.3203 | 0.3214 | 140000.0 |
| 2001-03-01 09:20:00 | AAPL | Stock | 0.3181 | 0.3203 | 0.3181 | 0.3181 | 196000.0 |
| 2001-03-01 09:25:00 | AAPL | Stock | 0.317 | 0.3214 | 0.317 | 0.3181 | 868000.0 |
| 2001-03-01 09:30:00 | AAPL | Stock | 0.3181 | 0.3203 | 0.3147 | 0.3147 | 14593600.0 |
| 2001-03-01 09:35:00 | AAPL | Stock | 0.3158 | 0.3181 | 0.3147 | 0.3181 | 8764000.0 |
| 2001-03-01 09:40:00 | AAPL | Stock | 0.3181 | 0.3192 | 0.317 | 0.3192 | 4984000.0 |
| 2001-03-01 09:45:00 | AAPL | Stock | 0.3181 | 0.3192 | 0.3136 | 0.3136 | 16245600.0 |
| 2001-03-01 09:50:00 | AAPL | Stock | 0.3158 | 0.317 | 0.3125 | 0.3147 | 4317600.0 |
| 2001-03-01 09:55:00 | AAPL | Stock | 0.3147 | 0.3158 | 0.3131 | 0.3147 | 8512000.0 |
| 2001-03-01 10:00:00 | AAPL | Stock | 0.3147 | 0.3181 | 0.3125 | 0.3147 | 4211200.0 |
| 2001-03-01 10:05:00 | AAPL | Stock | 0.3158 | 0.317 | 0.3136 | 0.3158 | 3108000.0 |
| 2001-03-01 10:10:00 | AAPL | Stock | 0.3158 | 0.3225 | 0.3147 | 0.3225 | 5796000.0 |
| 2001-03-01 10:15:00 | AAPL | Stock | 0.3214 | 0.3259 | 0.317 | 0.3237 | 3197600.0 |
| 2001-03-01 10:20:00 | AAPL | Stock | 0.3237 | 0.3259 | 0.3237 | 0.3237 | 2884000.0 |
| 2001-03-01 10:25:00 | AAPL | Stock | 0.3237 | 0.327 | 0.3237 | 0.3248 | 7957600.0 |
| 2001-03-01 10:30:00 | AAPL | Stock | 0.3248 | 0.3259 | 0.3203 | 0.3203 | 5835200.0 |
| 2001-03-01 10:35:00 | AAPL | Stock | 0.3203 | 0.3214 | 0.3203 | 0.3203 | 4043200.0 |
| 2001-03-01 10:40:00 | AAPL | Stock | 0.3214 | 0.3214 | 0.3192 | 0.3203 | 9548000.0 |
| 2001-03-01 10:45:00 | AAPL | Stock | 0.3192 | 0.3203 | 0.3181 | 0.3181 | 3757600.0 |
| 2001-03-01 10:50:00 | AAPL | Stock | 0.3181 | 0.3203 | 0.317 | 0.3192 | 2816800.0 |
| 2001-03-01 10:55:00 | AAPL | Stock | 0.3192 | 0.3192 | 0.317 | 0.317 | 1797600.0 |
| 2001-03-01 11:00:00 | AAPL | Stock | 0.317 | 0.3181 | 0.3158 | 0.3181 | 2340800.0 |
| 2001-03-01 11:05:00 | AAPL | Stock | 0.317 | 0.3192 | 0.317 | 0.3181 | 2066400.0 |
| 2001-03-01 11:10:00 | AAPL | Stock | 0.3192 | 0.3192 | 0.317 | 0.3192 | 2396800.0 |
| 2001-03-01 11:15:00 | AAPL | Stock | 0.3181 | 0.3192 | 0.3181 | 0.3181 | 2234400.0 |
| 2001-03-01 11:20:00 | AAPL | Stock | 0.3181 | 0.3192 | 0.317 | 0.3181 | 834400.0 |
| 2001-03-01 11:25:00 | AAPL | Stock | 0.3192 | 0.3203 | 0.3181 | 0.3203 | 582400.0 |
| 2001-03-01 11:30:00 | AAPL | Stock | 0.3203 | 0.3203 | 0.3181 | 0.3181 | 5684000.0 |
| 2001-03-01 11:35:00 | AAPL | Stock | 0.3192 | 0.3203 | 0.3192 | 0.3192 | 5112800.0 |
| 2001-03-01 11:40:00 | AAPL | Stock | 0.3203 | 0.3203 | 0.3192 | 0.3192 | 1024800.0 |
| 2001-03-01 11:45:00 | AAPL | Stock | 0.3192 | 0.3203 | 0.3192 | 0.3192 | 1506400.0 |
| 2001-03-01 11:50:00 | AAPL | Stock | 0.3192 | 0.3192 | 0.3158 | 0.317 | 1181600.0 |
| 2001-03-01 11:55:00 | AAPL | Stock | 0.317 | 0.3181 | 0.3158 | 0.3181 | 548800.0 |
| 2001-03-01 12:00:00 | AAPL | Stock | 0.317 | 0.3181 | 0.3158 | 0.3158 | 1769600.0 |
| 2001-03-01 12:05:00 | AAPL | Stock | 0.3158 | 0.3158 | 0.3147 | 0.3147 | 3287200.0 |
| 2001-03-01 12:10:00 | AAPL | Stock | 0.3147 | 0.3158 | 0.3136 | 0.3158 | 3046400.0 |
| 2001-03-01 12:15:00 | AAPL | Stock | 0.3158 | 0.317 | 0.3136 | 0.3136 | 728000.0 |
| 2001-03-01 12:20:00 | AAPL | Stock | 0.3136 | 0.3147 | 0.3136 | 0.3147 | 515200.0 |
| 2001-03-01 12:25:00 | AAPL | Stock | 0.3147 | 0.3147 | 0.3136 | 0.3136 | 1069600.0 |
| 2001-03-01 12:30:00 | AAPL | Stock | 0.3136 | 0.3147 | 0.3125 | 0.3147 | 4844000.0 |
| 2001-03-01 12:35:00 | AAPL | Stock | 0.3147 | 0.3158 | 0.3136 | 0.3158 | 1080800.0 |
| 2001-03-01 12:40:00 | AAPL | Stock | 0.3147 | 0.3158 | 0.3125 | 0.3136 | 6199200.0 |
| 2001-03-01 12:45:00 | AAPL | Stock | 0.3125 | 0.3158 | 0.3125 | 0.3147 | 1618400.0 |
| 2001-03-01 12:50:00 | AAPL | Stock | 0.3147 | 0.3158 | 0.3147 | 0.3158 | 1013600.0 |
| 2001-03-01 12:55:00 | AAPL | Stock | 0.3147 | 0.3158 | 0.3147 | 0.3147 | 2648800.0 |
> showing 50 of 100,816 rows — these rows as CSV