PREVIEW / stock_5min / 2000-02-17
file: by_date/stock_5min/2000/2000-02-17.parquet size: 1.2 MB rows: 89,622 symbols: 1,134
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-17 09:30:00 | AAPL | Stock | 1.0285 | 1.0301 | 1.0268 | 1.0285 | 14560000.0 |
| 2000-02-17 09:35:00 | AAPL | Stock | 1.0279 | 1.0313 | 1.0268 | 1.0285 | 8176000.0 |
| 2000-02-17 09:40:00 | AAPL | Stock | 1.0279 | 1.0313 | 1.0268 | 1.0271 | 6764800.0 |
| 2000-02-17 09:45:00 | AAPL | Stock | 1.0268 | 1.0279 | 1.019 | 1.019 | 7459200.0 |
| 2000-02-17 09:50:00 | AAPL | Stock | 1.019 | 1.0201 | 1.0134 | 1.0167 | 5835200.0 |
| 2000-02-17 09:55:00 | AAPL | Stock | 1.0167 | 1.0167 | 1.0156 | 1.0165 | 5140800.0 |
| 2000-02-17 10:00:00 | AAPL | Stock | 1.0165 | 1.0167 | 1.01 | 1.0153 | 6406400.0 |
| 2000-02-17 10:05:00 | AAPL | Stock | 1.0151 | 1.0156 | 1.0134 | 1.0156 | 10550400.0 |
| 2000-02-17 10:10:00 | AAPL | Stock | 1.0156 | 1.0179 | 1.0145 | 1.0167 | 11603200.0 |
| 2000-02-17 10:15:00 | AAPL | Stock | 1.0162 | 1.0179 | 1.0156 | 1.0179 | 5308800.0 |
| 2000-02-17 10:20:00 | AAPL | Stock | 1.0156 | 1.0179 | 1.0151 | 1.0179 | 1657600.0 |
| 2000-02-17 10:25:00 | AAPL | Stock | 1.0179 | 1.0179 | 1.0156 | 1.0167 | 1948800.0 |
| 2000-02-17 10:30:00 | AAPL | Stock | 1.0162 | 1.0179 | 1.0145 | 1.0167 | 2900800.0 |
| 2000-02-17 10:35:00 | AAPL | Stock | 1.0162 | 1.0167 | 1.01 | 1.014 | 2016000.0 |
| 2000-02-17 10:40:00 | AAPL | Stock | 1.0112 | 1.0179 | 1.0112 | 1.0179 | 5264000.0 |
| 2000-02-17 10:45:00 | AAPL | Stock | 1.0156 | 1.0234 | 1.0156 | 1.0234 | 6361600.0 |
| 2000-02-17 10:50:00 | AAPL | Stock | 1.0223 | 1.0234 | 1.019 | 1.0229 | 6081600.0 |
| 2000-02-17 10:55:00 | AAPL | Stock | 1.0223 | 1.0246 | 1.0223 | 1.0229 | 3404800.0 |
| 2000-02-17 11:00:00 | AAPL | Stock | 1.0229 | 1.0246 | 1.0201 | 1.0201 | 2464000.0 |
| 2000-02-17 11:05:00 | AAPL | Stock | 1.0201 | 1.0229 | 1.0201 | 1.0218 | 2329600.0 |
| 2000-02-17 11:10:00 | AAPL | Stock | 1.0218 | 1.0234 | 1.0212 | 1.0229 | 5432000.0 |
| 2000-02-17 11:15:00 | AAPL | Stock | 1.0226 | 1.0234 | 1.0218 | 1.0232 | 1948800.0 |
| 2000-02-17 11:20:00 | AAPL | Stock | 1.0229 | 1.0234 | 1.0218 | 1.0223 | 1612800.0 |
| 2000-02-17 11:25:00 | AAPL | Stock | 1.0223 | 1.0229 | 1.0218 | 1.0218 | 1310400.0 |
| 2000-02-17 11:30:00 | AAPL | Stock | 1.0212 | 1.0234 | 1.0212 | 1.0234 | 7280000.0 |
| 2000-02-17 11:35:00 | AAPL | Stock | 1.0234 | 1.0246 | 1.0229 | 1.0229 | 8444800.0 |
| 2000-02-17 11:40:00 | AAPL | Stock | 1.0234 | 1.0246 | 1.0223 | 1.0229 | 1299200.0 |
| 2000-02-17 11:45:00 | AAPL | Stock | 1.0229 | 1.0229 | 1.0218 | 1.0218 | 2654400.0 |
| 2000-02-17 11:50:00 | AAPL | Stock | 1.0206 | 1.0206 | 1.0179 | 1.0179 | 3001600.0 |
| 2000-02-17 11:55:00 | AAPL | Stock | 1.0179 | 1.019 | 1.0156 | 1.0179 | 2497600.0 |
| 2000-02-17 12:00:00 | AAPL | Stock | 1.0179 | 1.0179 | 1.0162 | 1.0173 | 817600.0 |
| 2000-02-17 12:05:00 | AAPL | Stock | 1.0167 | 1.0223 | 1.0167 | 1.0212 | 5297600.0 |
| 2000-02-17 12:10:00 | AAPL | Stock | 1.0212 | 1.0212 | 1.019 | 1.0206 | 2296000.0 |
| 2000-02-17 12:15:00 | AAPL | Stock | 1.0206 | 1.0223 | 1.0206 | 1.0218 | 1892800.0 |
| 2000-02-17 12:20:00 | AAPL | Stock | 1.0218 | 1.0218 | 1.0212 | 1.0212 | 425600.0 |
| 2000-02-17 12:25:00 | AAPL | Stock | 1.0212 | 1.0223 | 1.0206 | 1.0223 | 1747200.0 |
| 2000-02-17 12:30:00 | AAPL | Stock | 1.0223 | 1.0234 | 1.0206 | 1.0234 | 1321600.0 |
| 2000-02-17 12:35:00 | AAPL | Stock | 1.0218 | 1.0234 | 1.0212 | 1.0212 | 851200.0 |
| 2000-02-17 12:40:00 | AAPL | Stock | 1.0206 | 1.0223 | 1.019 | 1.0212 | 436800.0 |
| 2000-02-17 12:45:00 | AAPL | Stock | 1.0218 | 1.0223 | 1.0195 | 1.0218 | 739200.0 |
| 2000-02-17 12:50:00 | AAPL | Stock | 1.0212 | 1.0218 | 1.0201 | 1.0201 | 425600.0 |
| 2000-02-17 12:55:00 | AAPL | Stock | 1.0212 | 1.0223 | 1.0201 | 1.0223 | 1702400.0 |
| 2000-02-17 13:00:00 | AAPL | Stock | 1.0223 | 1.0234 | 1.0212 | 1.0223 | 2105600.0 |
| 2000-02-17 13:05:00 | AAPL | Stock | 1.022 | 1.0268 | 1.0212 | 1.0212 | 5163200.0 |
| 2000-02-17 13:10:00 | AAPL | Stock | 1.0223 | 1.0234 | 1.0195 | 1.0218 | 1456000.0 |
| 2000-02-17 13:15:00 | AAPL | Stock | 1.0218 | 1.0234 | 1.0212 | 1.0234 | 1489600.0 |
| 2000-02-17 13:20:00 | AAPL | Stock | 1.0234 | 1.0234 | 1.0218 | 1.0234 | 3113600.0 |
| 2000-02-17 13:25:00 | AAPL | Stock | 1.0234 | 1.0246 | 1.0229 | 1.024 | 2486400.0 |
| 2000-02-17 13:30:00 | AAPL | Stock | 1.024 | 1.024 | 1.0223 | 1.0234 | 10628800.0 |
| 2000-02-17 13:35:00 | AAPL | Stock | 1.024 | 1.024 | 1.0234 | 1.0234 | 1276800.0 |
> showing 50 of 89,622 rows — these rows as CSV