PREVIEW / stock_1min / 2005-09-19
file: by_date/stock_1min/2005/2005-09-19.parquet size: 7.1 MB rows: 582,065 symbols: 1,686
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 |
|---|---|---|---|---|---|---|---|
| 2005-09-19 08:00:00 | AAPL | Stock | 1.8282 | 1.8286 | 1.8282 | 1.8286 | 11200.0 |
| 2005-09-19 08:01:00 | AAPL | Stock | 1.8286 | 1.8286 | 1.8286 | 1.8286 | 28000.0 |
| 2005-09-19 08:03:00 | AAPL | Stock | 1.8232 | 1.8232 | 1.8225 | 1.8225 | 7000.0 |
| 2005-09-19 08:04:00 | AAPL | Stock | 1.8286 | 1.8286 | 1.8286 | 1.8286 | 131600.0 |
| 2005-09-19 08:06:00 | AAPL | Stock | 1.8225 | 1.83 | 1.8225 | 1.83 | 81760.0 |
| 2005-09-19 08:07:00 | AAPL | Stock | 1.8286 | 1.8357 | 1.8286 | 1.8354 | 81200.0 |
| 2005-09-19 08:08:00 | AAPL | Stock | 1.8354 | 1.8354 | 1.8243 | 1.8264 | 108500.0 |
| 2005-09-19 08:09:00 | AAPL | Stock | 1.8321 | 1.8321 | 1.8321 | 1.8321 | 63840.0 |
| 2005-09-19 08:10:00 | AAPL | Stock | 1.8357 | 1.8357 | 1.8357 | 1.8357 | 56000.0 |
| 2005-09-19 08:11:00 | AAPL | Stock | 1.8357 | 1.8357 | 1.8357 | 1.8357 | 56000.0 |
| 2005-09-19 08:12:00 | AAPL | Stock | 1.8357 | 1.8357 | 1.8332 | 1.8332 | 50400.0 |
| 2005-09-19 08:13:00 | AAPL | Stock | 1.8332 | 1.8357 | 1.8332 | 1.8357 | 42000.0 |
| 2005-09-19 08:15:00 | AAPL | Stock | 1.8361 | 1.8361 | 1.8361 | 1.8361 | 8400.0 |
| 2005-09-19 08:17:00 | AAPL | Stock | 1.8361 | 1.8361 | 1.8361 | 1.8361 | 2800.0 |
| 2005-09-19 08:18:00 | AAPL | Stock | 1.8361 | 1.8361 | 1.8361 | 1.8361 | 2800.0 |
| 2005-09-19 08:19:00 | AAPL | Stock | 1.8325 | 1.8325 | 1.8325 | 1.8325 | 14000.0 |
| 2005-09-19 08:20:00 | AAPL | Stock | 1.8325 | 1.8325 | 1.8325 | 1.8325 | 2800.0 |
| 2005-09-19 08:21:00 | AAPL | Stock | 1.8325 | 1.8325 | 1.8325 | 1.8325 | 11200.0 |
| 2005-09-19 08:23:00 | AAPL | Stock | 1.8354 | 1.8354 | 1.8354 | 1.8354 | 2800.0 |
| 2005-09-19 08:25:00 | AAPL | Stock | 1.8325 | 1.8325 | 1.8321 | 1.8321 | 56000.0 |
| 2005-09-19 08:27:00 | AAPL | Stock | 1.8321 | 1.8321 | 1.8321 | 1.8321 | 11200.0 |
| 2005-09-19 08:29:00 | AAPL | Stock | 1.8321 | 1.8321 | 1.8321 | 1.8321 | 2800.0 |
| 2005-09-19 08:30:00 | AAPL | Stock | 1.8321 | 1.8321 | 1.8321 | 1.8321 | 2800.0 |
| 2005-09-19 08:31:00 | AAPL | Stock | 1.8304 | 1.8304 | 1.8304 | 1.8304 | 13972.0 |
| 2005-09-19 08:33:00 | AAPL | Stock | 1.8304 | 1.8304 | 1.8304 | 1.8304 | 26600.0 |
| 2005-09-19 08:36:00 | AAPL | Stock | 1.8304 | 1.8304 | 1.8304 | 1.8304 | 26600.0 |
| 2005-09-19 08:40:00 | AAPL | Stock | 1.8293 | 1.8304 | 1.8293 | 1.8304 | 77000.0 |
| 2005-09-19 08:42:00 | AAPL | Stock | 1.8304 | 1.8304 | 1.8304 | 1.8304 | 4200.0 |
| 2005-09-19 08:48:00 | AAPL | Stock | 1.8293 | 1.8293 | 1.8293 | 1.8293 | 9800.0 |
| 2005-09-19 08:49:00 | AAPL | Stock | 1.8293 | 1.8293 | 1.8293 | 1.8293 | 9800.0 |
| 2005-09-19 08:52:00 | AAPL | Stock | 1.8289 | 1.8289 | 1.8289 | 1.8289 | 14000.0 |
| 2005-09-19 08:55:00 | AAPL | Stock | 1.8293 | 1.8293 | 1.8289 | 1.8293 | 60200.0 |
| 2005-09-19 08:56:00 | AAPL | Stock | 1.8293 | 1.8293 | 1.8293 | 1.8293 | 28000.0 |
| 2005-09-19 08:59:00 | AAPL | Stock | 1.8289 | 1.8289 | 1.8289 | 1.8289 | 5600.0 |
| 2005-09-19 09:00:00 | AAPL | Stock | 1.8289 | 1.8289 | 1.8289 | 1.8289 | 25200.0 |
| 2005-09-19 09:02:00 | AAPL | Stock | 1.8293 | 1.8293 | 1.8293 | 1.8293 | 49000.0 |
| 2005-09-19 09:03:00 | AAPL | Stock | 1.8307 | 1.8307 | 1.8307 | 1.8307 | 2800.0 |
| 2005-09-19 09:07:00 | AAPL | Stock | 1.8293 | 1.8311 | 1.8293 | 1.8311 | 121184.0 |
| 2005-09-19 09:08:00 | AAPL | Stock | 1.8293 | 1.8311 | 1.8293 | 1.8311 | 25200.0 |
| 2005-09-19 09:09:00 | AAPL | Stock | 1.8293 | 1.8311 | 1.8293 | 1.8311 | 30800.0 |
| 2005-09-19 09:10:00 | AAPL | Stock | 1.8311 | 1.8321 | 1.83 | 1.83 | 43400.0 |
| 2005-09-19 09:11:00 | AAPL | Stock | 1.83 | 1.83 | 1.83 | 1.83 | 8400.0 |
| 2005-09-19 09:12:00 | AAPL | Stock | 1.8293 | 1.8293 | 1.8293 | 1.8293 | 26040.0 |
| 2005-09-19 09:14:00 | AAPL | Stock | 1.8293 | 1.8293 | 1.8293 | 1.8293 | 3640.0 |
| 2005-09-19 09:15:00 | AAPL | Stock | 1.8289 | 1.8307 | 1.8289 | 1.8289 | 56000.0 |
| 2005-09-19 09:16:00 | AAPL | Stock | 1.8304 | 1.8304 | 1.8304 | 1.8304 | 11200.0 |
| 2005-09-19 09:17:00 | AAPL | Stock | 1.8304 | 1.8304 | 1.8304 | 1.8304 | 11200.0 |
| 2005-09-19 09:18:00 | AAPL | Stock | 1.8289 | 1.8289 | 1.8289 | 1.8289 | 22400.0 |
| 2005-09-19 09:19:00 | AAPL | Stock | 1.8289 | 1.8289 | 1.8289 | 1.8289 | 11200.0 |
| 2005-09-19 09:20:00 | AAPL | Stock | 1.8304 | 1.8304 | 1.8289 | 1.8289 | 8400.0 |
> showing 50 of 582,065 rows — these rows as CSV