PREVIEW / stock_5min / 2000-02-18
file: by_date/stock_5min/2000/2000-02-18.parquet size: 1.2 MB rows: 89,812 symbols: 1,142
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 |
|---|---|---|---|---|---|---|---|
| 2000-02-18 09:30:00 | AAPL | Stock | 1.0234 | 1.0234 | 1.0201 | 1.0218 | 11435200.0 |
| 2000-02-18 09:35:00 | AAPL | Stock | 1.0218 | 1.0234 | 1.0162 | 1.0162 | 4020800.0 |
| 2000-02-18 09:40:00 | AAPL | Stock | 1.0151 | 1.0223 | 1.0128 | 1.0201 | 3337600.0 |
| 2000-02-18 09:45:00 | AAPL | Stock | 1.0201 | 1.0223 | 1.0167 | 1.0179 | 4480000.0 |
| 2000-02-18 09:50:00 | AAPL | Stock | 1.019 | 1.0198 | 1.0167 | 1.0167 | 1366400.0 |
| 2000-02-18 09:55:00 | AAPL | Stock | 1.0201 | 1.0218 | 1.0162 | 1.0162 | 2856000.0 |
| 2000-02-18 10:00:00 | AAPL | Stock | 1.0173 | 1.0218 | 1.0167 | 1.0179 | 2811200.0 |
| 2000-02-18 10:05:00 | AAPL | Stock | 1.0201 | 1.0201 | 1.0156 | 1.0156 | 4636800.0 |
| 2000-02-18 10:10:00 | AAPL | Stock | 1.0167 | 1.0201 | 1.0145 | 1.0145 | 3528000.0 |
| 2000-02-18 10:15:00 | AAPL | Stock | 1.0173 | 1.0198 | 1.0145 | 1.0145 | 2374400.0 |
| 2000-02-18 10:20:00 | AAPL | Stock | 1.014 | 1.0173 | 1.014 | 1.014 | 2307200.0 |
| 2000-02-18 10:25:00 | AAPL | Stock | 1.0156 | 1.0167 | 1.0112 | 1.014 | 4816000.0 |
| 2000-02-18 10:30:00 | AAPL | Stock | 1.014 | 1.0151 | 1.014 | 1.0145 | 4054400.0 |
| 2000-02-18 10:35:00 | AAPL | Stock | 1.0167 | 1.0201 | 1.0156 | 1.0156 | 5566400.0 |
| 2000-02-18 10:40:00 | AAPL | Stock | 1.0162 | 1.0184 | 1.0145 | 1.0173 | 1993600.0 |
| 2000-02-18 10:45:00 | AAPL | Stock | 1.0179 | 1.0184 | 1.0151 | 1.0179 | 1422400.0 |
| 2000-02-18 10:50:00 | AAPL | Stock | 1.0179 | 1.0201 | 1.0156 | 1.0179 | 1444800.0 |
| 2000-02-18 10:55:00 | AAPL | Stock | 1.0206 | 1.0212 | 1.0179 | 1.0206 | 1411200.0 |
| 2000-02-18 11:00:00 | AAPL | Stock | 1.0206 | 1.0206 | 1.0156 | 1.0156 | 448000.0 |
| 2000-02-18 11:05:00 | AAPL | Stock | 1.0151 | 1.0195 | 1.0145 | 1.0179 | 1803200.0 |
| 2000-02-18 11:10:00 | AAPL | Stock | 1.0195 | 1.0195 | 1.0162 | 1.0167 | 1064000.0 |
| 2000-02-18 11:15:00 | AAPL | Stock | 1.0167 | 1.0195 | 1.0167 | 1.0179 | 481600.0 |
| 2000-02-18 11:20:00 | AAPL | Stock | 1.0179 | 1.0201 | 1.0167 | 1.0201 | 1176000.0 |
| 2000-02-18 11:25:00 | AAPL | Stock | 1.0195 | 1.0218 | 1.0195 | 1.0218 | 4412800.0 |
| 2000-02-18 11:30:00 | AAPL | Stock | 1.0201 | 1.0223 | 1.0195 | 1.0218 | 716800.0 |
| 2000-02-18 11:35:00 | AAPL | Stock | 1.0223 | 1.0223 | 1.0179 | 1.0206 | 1019200.0 |
| 2000-02-18 11:40:00 | AAPL | Stock | 1.0206 | 1.0268 | 1.019 | 1.0268 | 1982400.0 |
| 2000-02-18 11:45:00 | AAPL | Stock | 1.0262 | 1.0279 | 1.022 | 1.0223 | 2408000.0 |
| 2000-02-18 11:50:00 | AAPL | Stock | 1.0229 | 1.0268 | 1.0229 | 1.0262 | 560000.0 |
| 2000-02-18 11:55:00 | AAPL | Stock | 1.0262 | 1.0279 | 1.0246 | 1.0251 | 1344000.0 |
| 2000-02-18 12:00:00 | AAPL | Stock | 1.0268 | 1.0301 | 1.0251 | 1.0301 | 2284800.0 |
| 2000-02-18 12:05:00 | AAPL | Stock | 1.0301 | 1.0301 | 1.0234 | 1.0246 | 2139200.0 |
| 2000-02-18 12:10:00 | AAPL | Stock | 1.0246 | 1.0246 | 1.0234 | 1.024 | 280000.0 |
| 2000-02-18 12:15:00 | AAPL | Stock | 1.024 | 1.0246 | 1.024 | 1.0246 | 828800.0 |
| 2000-02-18 12:20:00 | AAPL | Stock | 1.0246 | 1.0257 | 1.0234 | 1.0234 | 1388800.0 |
| 2000-02-18 12:25:00 | AAPL | Stock | 1.0234 | 1.0246 | 1.0229 | 1.0246 | 2083200.0 |
| 2000-02-18 12:30:00 | AAPL | Stock | 1.0246 | 1.0246 | 1.0206 | 1.022 | 1937600.0 |
| 2000-02-18 12:35:00 | AAPL | Stock | 1.0212 | 1.0212 | 1.019 | 1.019 | 1758400.0 |
| 2000-02-18 12:40:00 | AAPL | Stock | 1.0201 | 1.0201 | 1.0167 | 1.0167 | 4155200.0 |
| 2000-02-18 12:45:00 | AAPL | Stock | 1.0167 | 1.0195 | 1.0167 | 1.0195 | 1859200.0 |
| 2000-02-18 12:50:00 | AAPL | Stock | 1.0201 | 1.0212 | 1.0167 | 1.0212 | 537600.0 |
| 2000-02-18 12:55:00 | AAPL | Stock | 1.0212 | 1.0212 | 1.0179 | 1.0179 | 44800.0 |
| 2000-02-18 13:00:00 | AAPL | Stock | 1.0212 | 1.0212 | 1.0167 | 1.0167 | 1254400.0 |
| 2000-02-18 13:05:00 | AAPL | Stock | 1.0212 | 1.0212 | 1.0167 | 1.0173 | 190400.0 |
| 2000-02-18 13:10:00 | AAPL | Stock | 1.0179 | 1.0179 | 1.0167 | 1.0173 | 1590400.0 |
| 2000-02-18 13:15:00 | AAPL | Stock | 1.0167 | 1.0173 | 1.0134 | 1.0134 | 4737600.0 |
| 2000-02-18 13:20:00 | AAPL | Stock | 1.0134 | 1.0151 | 1.01 | 1.01 | 1691200.0 |
| 2000-02-18 13:25:00 | AAPL | Stock | 1.01 | 1.0112 | 1.0095 | 1.0112 | 1008000.0 |
| 2000-02-18 13:30:00 | AAPL | Stock | 1.0123 | 1.0184 | 1.0112 | 1.0173 | 750400.0 |
| 2000-02-18 13:35:00 | AAPL | Stock | 1.0184 | 1.0184 | 1.0167 | 1.0167 | 448000.0 |
> showing 50 of 89,812 rows — these rows as CSV