PREVIEW / stock_1min / 2002-04-09
file: by_date/stock_1min/2002/2002-04-09.parquet size: 3.9 MB rows: 307,553 symbols: 1,154
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 |
|---|---|---|---|---|---|---|---|
| 2002-04-09 08:31:00 | AAPL | Stock | 0.4463 | 0.4463 | 0.4463 | 0.4463 | 5600.0 |
| 2002-04-09 08:40:00 | AAPL | Stock | 0.442 | 0.442 | 0.442 | 0.442 | 28000.0 |
| 2002-04-09 08:46:00 | AAPL | Stock | 0.4407 | 0.4407 | 0.4407 | 0.4407 | 39200.0 |
| 2002-04-09 09:22:00 | AAPL | Stock | 0.4407 | 0.4407 | 0.4407 | 0.4407 | 28000.0 |
| 2002-04-09 09:27:00 | AAPL | Stock | 0.4393 | 0.4393 | 0.4393 | 0.4393 | 112000.0 |
| 2002-04-09 09:28:00 | AAPL | Stock | 0.4391 | 0.4391 | 0.4391 | 0.4391 | 16800.0 |
| 2002-04-09 09:30:00 | AAPL | Stock | 0.4391 | 0.442 | 0.4391 | 0.4418 | 1495200.0 |
| 2002-04-09 09:31:00 | AAPL | Stock | 0.442 | 0.4429 | 0.4418 | 0.442 | 666400.0 |
| 2002-04-09 09:32:00 | AAPL | Stock | 0.4391 | 0.4429 | 0.4391 | 0.4429 | 795200.0 |
| 2002-04-09 09:33:00 | AAPL | Stock | 0.4427 | 0.443 | 0.4409 | 0.4409 | 1366400.0 |
| 2002-04-09 09:34:00 | AAPL | Stock | 0.4427 | 0.4427 | 0.44 | 0.4404 | 369600.0 |
| 2002-04-09 09:35:00 | AAPL | Stock | 0.4411 | 0.442 | 0.4411 | 0.442 | 1556800.0 |
| 2002-04-09 09:36:00 | AAPL | Stock | 0.4416 | 0.4445 | 0.4416 | 0.4445 | 2066400.0 |
| 2002-04-09 09:37:00 | AAPL | Stock | 0.4445 | 0.4445 | 0.4427 | 0.4429 | 1170400.0 |
| 2002-04-09 09:38:00 | AAPL | Stock | 0.4427 | 0.4444 | 0.4427 | 0.4443 | 772800.0 |
| 2002-04-09 09:39:00 | AAPL | Stock | 0.4443 | 0.4454 | 0.4436 | 0.4446 | 2940000.0 |
| 2002-04-09 09:40:00 | AAPL | Stock | 0.4446 | 0.4464 | 0.4438 | 0.4443 | 3186400.0 |
| 2002-04-09 09:41:00 | AAPL | Stock | 0.4443 | 0.4454 | 0.4436 | 0.4439 | 1646400.0 |
| 2002-04-09 09:42:00 | AAPL | Stock | 0.4445 | 0.4446 | 0.4436 | 0.4438 | 509600.0 |
| 2002-04-09 09:43:00 | AAPL | Stock | 0.4436 | 0.4445 | 0.4427 | 0.4427 | 1142400.0 |
| 2002-04-09 09:44:00 | AAPL | Stock | 0.4436 | 0.4438 | 0.4421 | 0.4421 | 1243200.0 |
| 2002-04-09 09:45:00 | AAPL | Stock | 0.442 | 0.442 | 0.4409 | 0.4409 | 1881600.0 |
| 2002-04-09 09:46:00 | AAPL | Stock | 0.4411 | 0.4413 | 0.4407 | 0.4411 | 537600.0 |
| 2002-04-09 09:47:00 | AAPL | Stock | 0.4416 | 0.4436 | 0.4413 | 0.4436 | 520800.0 |
| 2002-04-09 09:48:00 | AAPL | Stock | 0.4436 | 0.4436 | 0.4425 | 0.4425 | 246400.0 |
| 2002-04-09 09:49:00 | AAPL | Stock | 0.442 | 0.4425 | 0.4416 | 0.442 | 744800.0 |
| 2002-04-09 09:50:00 | AAPL | Stock | 0.4416 | 0.4425 | 0.4416 | 0.4425 | 112000.0 |
| 2002-04-09 09:51:00 | AAPL | Stock | 0.4425 | 0.4429 | 0.4423 | 0.4425 | 408800.0 |
| 2002-04-09 09:52:00 | AAPL | Stock | 0.4432 | 0.4436 | 0.4427 | 0.443 | 285600.0 |
| 2002-04-09 09:53:00 | AAPL | Stock | 0.443 | 0.443 | 0.4411 | 0.4411 | 968800.0 |
| 2002-04-09 09:54:00 | AAPL | Stock | 0.4411 | 0.4413 | 0.4409 | 0.4409 | 649600.0 |
| 2002-04-09 09:55:00 | AAPL | Stock | 0.4409 | 0.4416 | 0.4409 | 0.4416 | 89600.0 |
| 2002-04-09 09:56:00 | AAPL | Stock | 0.4411 | 0.4411 | 0.4405 | 0.4407 | 856800.0 |
| 2002-04-09 09:57:00 | AAPL | Stock | 0.4405 | 0.4405 | 0.4389 | 0.4389 | 1209600.0 |
| 2002-04-09 09:58:00 | AAPL | Stock | 0.4398 | 0.4402 | 0.4396 | 0.4398 | 184800.0 |
| 2002-04-09 09:59:00 | AAPL | Stock | 0.4402 | 0.4411 | 0.4402 | 0.4407 | 431200.0 |
| 2002-04-09 10:00:00 | AAPL | Stock | 0.4404 | 0.4405 | 0.4384 | 0.4384 | 728000.0 |
| 2002-04-09 10:01:00 | AAPL | Stock | 0.4384 | 0.4384 | 0.4366 | 0.4375 | 1114400.0 |
| 2002-04-09 10:02:00 | AAPL | Stock | 0.437 | 0.4391 | 0.437 | 0.4391 | 733600.0 |
| 2002-04-09 10:03:00 | AAPL | Stock | 0.4391 | 0.4395 | 0.4389 | 0.4395 | 84000.0 |
| 2002-04-09 10:04:00 | AAPL | Stock | 0.4395 | 0.4396 | 0.4384 | 0.4393 | 347200.0 |
| 2002-04-09 10:05:00 | AAPL | Stock | 0.4393 | 0.4393 | 0.4368 | 0.4368 | 834400.0 |
| 2002-04-09 10:06:00 | AAPL | Stock | 0.4368 | 0.4375 | 0.4361 | 0.4375 | 1036000.0 |
| 2002-04-09 10:07:00 | AAPL | Stock | 0.4375 | 0.4377 | 0.437 | 0.437 | 431200.0 |
| 2002-04-09 10:08:00 | AAPL | Stock | 0.437 | 0.437 | 0.4359 | 0.4364 | 666400.0 |
| 2002-04-09 10:09:00 | AAPL | Stock | 0.4368 | 0.4377 | 0.4366 | 0.4368 | 588000.0 |
| 2002-04-09 10:10:00 | AAPL | Stock | 0.437 | 0.4382 | 0.4366 | 0.4379 | 324800.0 |
| 2002-04-09 10:11:00 | AAPL | Stock | 0.4382 | 0.4388 | 0.4382 | 0.4388 | 509600.0 |
| 2002-04-09 10:12:00 | AAPL | Stock | 0.4386 | 0.4386 | 0.438 | 0.4382 | 95200.0 |
| 2002-04-09 10:13:00 | AAPL | Stock | 0.438 | 0.4382 | 0.4375 | 0.4377 | 156800.0 |
> showing 50 of 307,553 rows — these rows as CSV