PREVIEW / stock_1min / 2005-03-24
file: by_date/stock_1min/2005/2005-03-24.parquet size: 6.4 MB rows: 534,650 symbols: 1,605
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-03-24 08:00:00 | AAPL | Stock | 1.5214 | 1.5214 | 1.5214 | 1.5214 | 2800.0 |
| 2005-03-24 08:01:00 | AAPL | Stock | 1.5286 | 1.5304 | 1.5268 | 1.5286 | 319984.0 |
| 2005-03-24 08:02:00 | AAPL | Stock | 1.5289 | 1.5318 | 1.5289 | 1.5318 | 1240008.0 |
| 2005-03-24 08:03:00 | AAPL | Stock | 1.5336 | 1.5336 | 1.5286 | 1.5336 | 14000.0 |
| 2005-03-24 08:06:00 | AAPL | Stock | 1.5307 | 1.5307 | 1.5296 | 1.5296 | 39200.0 |
| 2005-03-24 08:08:00 | AAPL | Stock | 1.5336 | 1.5339 | 1.5296 | 1.5339 | 71232.0 |
| 2005-03-24 08:09:00 | AAPL | Stock | 1.5339 | 1.5339 | 1.5339 | 1.5339 | 9968.0 |
| 2005-03-24 08:10:00 | AAPL | Stock | 1.5296 | 1.5296 | 1.5296 | 1.5296 | 2800.0 |
| 2005-03-24 08:12:00 | AAPL | Stock | 1.5318 | 1.5318 | 1.5318 | 1.5318 | 2800.0 |
| 2005-03-24 08:13:00 | AAPL | Stock | 1.5318 | 1.5318 | 1.5318 | 1.5318 | 2800.0 |
| 2005-03-24 08:15:00 | AAPL | Stock | 1.5318 | 1.5318 | 1.5296 | 1.5296 | 22400.0 |
| 2005-03-24 08:16:00 | AAPL | Stock | 1.5318 | 1.5318 | 1.5304 | 1.5304 | 5600.0 |
| 2005-03-24 08:17:00 | AAPL | Stock | 1.5304 | 1.5304 | 1.5286 | 1.5286 | 50400.0 |
| 2005-03-24 08:20:00 | AAPL | Stock | 1.5332 | 1.5332 | 1.5332 | 1.5332 | 28000.0 |
| 2005-03-24 08:21:00 | AAPL | Stock | 1.5286 | 1.5286 | 1.5264 | 1.5264 | 15400.0 |
| 2005-03-24 08:29:00 | AAPL | Stock | 1.5282 | 1.5282 | 1.5282 | 1.5282 | 2800.0 |
| 2005-03-24 08:36:00 | AAPL | Stock | 1.525 | 1.525 | 1.525 | 1.525 | 14000.0 |
| 2005-03-24 08:38:00 | AAPL | Stock | 1.525 | 1.525 | 1.525 | 1.525 | 14000.0 |
| 2005-03-24 08:39:00 | AAPL | Stock | 1.525 | 1.525 | 1.525 | 1.525 | 2800.0 |
| 2005-03-24 08:45:00 | AAPL | Stock | 1.5275 | 1.5279 | 1.5275 | 1.5279 | 46844.0 |
| 2005-03-24 08:46:00 | AAPL | Stock | 1.5275 | 1.5275 | 1.5275 | 1.5275 | 2800.0 |
| 2005-03-24 08:48:00 | AAPL | Stock | 1.5282 | 1.5286 | 1.5282 | 1.5286 | 16800.0 |
| 2005-03-24 08:50:00 | AAPL | Stock | 1.5286 | 1.5286 | 1.5286 | 1.5286 | 5600.0 |
| 2005-03-24 08:51:00 | AAPL | Stock | 1.5286 | 1.5286 | 1.5286 | 1.5286 | 16800.0 |
| 2005-03-24 08:53:00 | AAPL | Stock | 1.5286 | 1.5286 | 1.5286 | 1.5286 | 28000.0 |
| 2005-03-24 08:54:00 | AAPL | Stock | 1.5286 | 1.5286 | 1.5282 | 1.5286 | 81200.0 |
| 2005-03-24 08:55:00 | AAPL | Stock | 1.5282 | 1.5282 | 1.5279 | 1.5279 | 22400.0 |
| 2005-03-24 08:57:00 | AAPL | Stock | 1.5268 | 1.5286 | 1.5268 | 1.5286 | 26992.0 |
| 2005-03-24 08:59:00 | AAPL | Stock | 1.5293 | 1.5293 | 1.5293 | 1.5293 | 44800.0 |
| 2005-03-24 09:04:00 | AAPL | Stock | 1.5293 | 1.5293 | 1.5293 | 1.5293 | 117600.0 |
| 2005-03-24 09:06:00 | AAPL | Stock | 1.53 | 1.5321 | 1.53 | 1.5321 | 86800.0 |
| 2005-03-24 09:08:00 | AAPL | Stock | 1.53 | 1.53 | 1.53 | 1.53 | 5964.0 |
| 2005-03-24 09:10:00 | AAPL | Stock | 1.53 | 1.53 | 1.5296 | 1.5296 | 45640.0 |
| 2005-03-24 09:11:00 | AAPL | Stock | 1.53 | 1.53 | 1.5296 | 1.5296 | 34440.0 |
| 2005-03-24 09:12:00 | AAPL | Stock | 1.5304 | 1.5311 | 1.5293 | 1.53 | 66360.0 |
| 2005-03-24 09:13:00 | AAPL | Stock | 1.5304 | 1.5304 | 1.5296 | 1.5296 | 100800.0 |
| 2005-03-24 09:16:00 | AAPL | Stock | 1.53 | 1.5304 | 1.53 | 1.5304 | 5600.0 |
| 2005-03-24 09:17:00 | AAPL | Stock | 1.53 | 1.5304 | 1.53 | 1.53 | 33600.0 |
| 2005-03-24 09:18:00 | AAPL | Stock | 1.5311 | 1.5332 | 1.5311 | 1.5332 | 25200.0 |
| 2005-03-24 09:20:00 | AAPL | Stock | 1.5332 | 1.5332 | 1.5332 | 1.5332 | 81200.0 |
| 2005-03-24 09:21:00 | AAPL | Stock | 1.5336 | 1.5336 | 1.5336 | 1.5336 | 19600.0 |
| 2005-03-24 09:22:00 | AAPL | Stock | 1.5336 | 1.5336 | 1.5336 | 1.5336 | 36400.0 |
| 2005-03-24 09:23:00 | AAPL | Stock | 1.5336 | 1.5336 | 1.5332 | 1.5332 | 16800.0 |
| 2005-03-24 09:24:00 | AAPL | Stock | 1.5336 | 1.5339 | 1.5336 | 1.5339 | 61600.0 |
| 2005-03-24 09:25:00 | AAPL | Stock | 1.5246 | 1.5357 | 1.5246 | 1.535 | 134400.0 |
| 2005-03-24 09:28:00 | AAPL | Stock | 1.535 | 1.5357 | 1.5329 | 1.5329 | 50400.0 |
| 2005-03-24 09:29:00 | AAPL | Stock | 1.5325 | 1.535 | 1.5325 | 1.5336 | 151984.0 |
| 2005-03-24 09:30:00 | AAPL | Stock | 1.5325 | 1.535 | 1.52 | 1.5218 | 6746236.0 |
| 2005-03-24 09:31:00 | AAPL | Stock | 1.5211 | 1.5286 | 1.5193 | 1.5286 | 3591644.0 |
| 2005-03-24 09:32:00 | AAPL | Stock | 1.5279 | 1.5304 | 1.5232 | 1.5293 | 3188500.0 |
> showing 50 of 534,650 rows — these rows as CSV