PREVIEW / stock_1min / 2005-07-14
file: by_date/stock_1min/2005/2005-07-14.parquet size: 7.0 MB rows: 575,676 symbols: 1,661
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-07-14 07:11:00 | AAPL | Stock | 1.425 | 1.425 | 1.425 | 1.425 | 25200.0 |
| 2005-07-14 07:12:00 | AAPL | Stock | 1.4268 | 1.4268 | 1.4268 | 1.4268 | 2800.0 |
| 2005-07-14 07:13:00 | AAPL | Stock | 1.4254 | 1.4254 | 1.4254 | 1.4254 | 5600.0 |
| 2005-07-14 07:21:00 | AAPL | Stock | 1.4268 | 1.4268 | 1.4268 | 1.4268 | 2800.0 |
| 2005-07-14 07:22:00 | AAPL | Stock | 1.4268 | 1.4268 | 1.4268 | 1.4268 | 2800.0 |
| 2005-07-14 07:25:00 | AAPL | Stock | 1.4268 | 1.4268 | 1.4268 | 1.4268 | 2800.0 |
| 2005-07-14 07:26:00 | AAPL | Stock | 1.4275 | 1.4275 | 1.4275 | 1.4275 | 70000.0 |
| 2005-07-14 07:27:00 | AAPL | Stock | 1.4264 | 1.4264 | 1.4264 | 1.4264 | 2800.0 |
| 2005-07-14 07:30:00 | AAPL | Stock | 1.4254 | 1.4264 | 1.4254 | 1.4264 | 78820.0 |
| 2005-07-14 07:31:00 | AAPL | Stock | 1.4264 | 1.4264 | 1.4264 | 1.4264 | 2800.0 |
| 2005-07-14 07:32:00 | AAPL | Stock | 1.4264 | 1.4264 | 1.4264 | 1.4264 | 14000.0 |
| 2005-07-14 07:33:00 | AAPL | Stock | 1.4264 | 1.4275 | 1.4264 | 1.4275 | 252000.0 |
| 2005-07-14 07:34:00 | AAPL | Stock | 1.4286 | 1.4286 | 1.4286 | 1.4286 | 280000.0 |
| 2005-07-14 07:35:00 | AAPL | Stock | 1.4321 | 1.4325 | 1.4321 | 1.4321 | 147000.0 |
| 2005-07-14 07:36:00 | AAPL | Stock | 1.4321 | 1.4321 | 1.4293 | 1.4293 | 154000.0 |
| 2005-07-14 07:37:00 | AAPL | Stock | 1.4293 | 1.4293 | 1.4293 | 1.4293 | 98000.0 |
| 2005-07-14 07:38:00 | AAPL | Stock | 1.4293 | 1.4293 | 1.4286 | 1.4293 | 198800.0 |
| 2005-07-14 07:39:00 | AAPL | Stock | 1.4293 | 1.4293 | 1.4293 | 1.4293 | 70000.0 |
| 2005-07-14 07:40:00 | AAPL | Stock | 1.4286 | 1.4286 | 1.4286 | 1.4286 | 86800.0 |
| 2005-07-14 07:41:00 | AAPL | Stock | 1.4286 | 1.4304 | 1.4286 | 1.4304 | 128800.0 |
| 2005-07-14 07:42:00 | AAPL | Stock | 1.4307 | 1.4307 | 1.4296 | 1.4304 | 61600.0 |
| 2005-07-14 07:43:00 | AAPL | Stock | 1.4307 | 1.4386 | 1.4307 | 1.4386 | 455700.0 |
| 2005-07-14 07:44:00 | AAPL | Stock | 1.4375 | 1.4393 | 1.4354 | 1.4393 | 123200.0 |
| 2005-07-14 07:45:00 | AAPL | Stock | 1.4393 | 1.4521 | 1.4393 | 1.4432 | 226800.0 |
| 2005-07-14 07:46:00 | AAPL | Stock | 1.44 | 1.4446 | 1.44 | 1.4446 | 309400.0 |
| 2005-07-14 07:47:00 | AAPL | Stock | 1.4446 | 1.4464 | 1.4446 | 1.4464 | 322280.0 |
| 2005-07-14 07:48:00 | AAPL | Stock | 1.4457 | 1.4464 | 1.4446 | 1.4446 | 412440.0 |
| 2005-07-14 07:49:00 | AAPL | Stock | 1.4446 | 1.4446 | 1.4429 | 1.4429 | 390880.0 |
| 2005-07-14 07:50:00 | AAPL | Stock | 1.445 | 1.445 | 1.445 | 1.445 | 2800.0 |
| 2005-07-14 07:52:00 | AAPL | Stock | 1.4446 | 1.4446 | 1.4446 | 1.4446 | 11200.0 |
| 2005-07-14 07:53:00 | AAPL | Stock | 1.4446 | 1.445 | 1.4446 | 1.4446 | 157724.0 |
| 2005-07-14 07:55:00 | AAPL | Stock | 1.4446 | 1.4446 | 1.4446 | 1.4446 | 72800.0 |
| 2005-07-14 07:56:00 | AAPL | Stock | 1.4446 | 1.4446 | 1.4446 | 1.4446 | 84000.0 |
| 2005-07-14 07:57:00 | AAPL | Stock | 1.4464 | 1.4464 | 1.4464 | 1.4464 | 67200.0 |
| 2005-07-14 07:58:00 | AAPL | Stock | 1.4464 | 1.4464 | 1.4446 | 1.4446 | 70000.0 |
| 2005-07-14 08:00:00 | AAPL | Stock | 1.4429 | 1.4464 | 1.44 | 1.44 | 725956.0 |
| 2005-07-14 08:01:00 | AAPL | Stock | 1.4421 | 1.4461 | 1.44 | 1.4421 | 10148096.0 |
| 2005-07-14 08:02:00 | AAPL | Stock | 1.4407 | 1.4446 | 1.4393 | 1.4429 | 1874992.0 |
| 2005-07-14 08:03:00 | AAPL | Stock | 1.4439 | 1.445 | 1.4418 | 1.4432 | 716828.0 |
| 2005-07-14 08:04:00 | AAPL | Stock | 1.4429 | 1.4446 | 1.4429 | 1.4432 | 2239860.0 |
| 2005-07-14 08:05:00 | AAPL | Stock | 1.4446 | 1.4446 | 1.4418 | 1.4432 | 404796.0 |
| 2005-07-14 08:06:00 | AAPL | Stock | 1.4432 | 1.4446 | 1.4418 | 1.4429 | 901740.0 |
| 2005-07-14 08:07:00 | AAPL | Stock | 1.4418 | 1.4429 | 1.4375 | 1.4393 | 913052.0 |
| 2005-07-14 08:08:00 | AAPL | Stock | 1.4411 | 1.4425 | 1.4393 | 1.44 | 142800.0 |
| 2005-07-14 08:09:00 | AAPL | Stock | 1.44 | 1.4425 | 1.4393 | 1.4411 | 3237528.0 |
| 2005-07-14 08:10:00 | AAPL | Stock | 1.4425 | 1.4429 | 1.4411 | 1.4429 | 58688.0 |
| 2005-07-14 08:11:00 | AAPL | Stock | 1.4429 | 1.4429 | 1.4411 | 1.4411 | 2188900.0 |
| 2005-07-14 08:12:00 | AAPL | Stock | 1.4411 | 1.4429 | 1.4411 | 1.4429 | 277256.0 |
| 2005-07-14 08:13:00 | AAPL | Stock | 1.4429 | 1.4436 | 1.4411 | 1.4432 | 101780.0 |
| 2005-07-14 08:14:00 | AAPL | Stock | 1.4436 | 1.4439 | 1.4432 | 1.4439 | 75600.0 |
> showing 50 of 575,676 rows — these rows as CSV