PREVIEW / stock_5min / 2002-03-20
file: by_date/stock_5min/2002/2002-03-20.parquet size: 1.7 MB rows: 115,772 symbols: 1,407
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-03-20 08:10:00 | AAPL | Stock | 0.4414 | 0.4414 | 0.4414 | 0.4414 | 22400.0 |
| 2002-03-20 08:50:00 | AAPL | Stock | 0.4384 | 0.4384 | 0.4384 | 0.4384 | 16800.0 |
| 2002-03-20 09:10:00 | AAPL | Stock | 0.4393 | 0.4393 | 0.4392 | 0.4392 | 28000.0 |
| 2002-03-20 09:15:00 | AAPL | Stock | 0.44 | 0.44 | 0.44 | 0.44 | 39200.0 |
| 2002-03-20 09:25:00 | AAPL | Stock | 0.44 | 0.44 | 0.44 | 0.44 | 5600.0 |
| 2002-03-20 09:30:00 | AAPL | Stock | 0.4404 | 0.4411 | 0.4375 | 0.4393 | 4944800.0 |
| 2002-03-20 09:35:00 | AAPL | Stock | 0.4393 | 0.4405 | 0.4393 | 0.4396 | 5353600.0 |
| 2002-03-20 09:40:00 | AAPL | Stock | 0.44 | 0.4416 | 0.4391 | 0.4413 | 9794400.0 |
| 2002-03-20 09:45:00 | AAPL | Stock | 0.4418 | 0.4418 | 0.4396 | 0.4396 | 2822400.0 |
| 2002-03-20 09:50:00 | AAPL | Stock | 0.44 | 0.4409 | 0.4396 | 0.4396 | 5045600.0 |
| 2002-03-20 09:55:00 | AAPL | Stock | 0.4396 | 0.4418 | 0.4395 | 0.4395 | 5812800.0 |
| 2002-03-20 10:00:00 | AAPL | Stock | 0.4395 | 0.4409 | 0.4388 | 0.4398 | 3186400.0 |
| 2002-03-20 10:05:00 | AAPL | Stock | 0.4405 | 0.4414 | 0.44 | 0.4409 | 3281600.0 |
| 2002-03-20 10:10:00 | AAPL | Stock | 0.4407 | 0.442 | 0.4402 | 0.4414 | 3113600.0 |
| 2002-03-20 10:15:00 | AAPL | Stock | 0.4411 | 0.4416 | 0.4402 | 0.4413 | 1192800.0 |
| 2002-03-20 10:20:00 | AAPL | Stock | 0.4411 | 0.4414 | 0.4407 | 0.4411 | 856800.0 |
| 2002-03-20 10:25:00 | AAPL | Stock | 0.4411 | 0.442 | 0.4407 | 0.4416 | 2760800.0 |
| 2002-03-20 10:30:00 | AAPL | Stock | 0.442 | 0.4429 | 0.4411 | 0.4429 | 6546400.0 |
| 2002-03-20 10:35:00 | AAPL | Stock | 0.4429 | 0.4429 | 0.4407 | 0.4416 | 1814400.0 |
| 2002-03-20 10:40:00 | AAPL | Stock | 0.442 | 0.443 | 0.4416 | 0.4418 | 4905600.0 |
| 2002-03-20 10:45:00 | AAPL | Stock | 0.4425 | 0.443 | 0.4418 | 0.4425 | 1573600.0 |
| 2002-03-20 10:50:00 | AAPL | Stock | 0.4427 | 0.4431 | 0.4421 | 0.4429 | 1416800.0 |
| 2002-03-20 10:55:00 | AAPL | Stock | 0.4425 | 0.443 | 0.4425 | 0.443 | 1685600.0 |
| 2002-03-20 11:00:00 | AAPL | Stock | 0.443 | 0.4436 | 0.4421 | 0.4421 | 1601600.0 |
| 2002-03-20 11:05:00 | AAPL | Stock | 0.4423 | 0.4429 | 0.4423 | 0.4429 | 901600.0 |
| 2002-03-20 11:10:00 | AAPL | Stock | 0.4429 | 0.4429 | 0.4423 | 0.4425 | 582400.0 |
| 2002-03-20 11:15:00 | AAPL | Stock | 0.4425 | 0.4427 | 0.4416 | 0.4416 | 1097600.0 |
| 2002-03-20 11:20:00 | AAPL | Stock | 0.4423 | 0.4432 | 0.4413 | 0.4423 | 980000.0 |
| 2002-03-20 11:25:00 | AAPL | Stock | 0.4423 | 0.4455 | 0.442 | 0.4452 | 6333600.0 |
| 2002-03-20 11:30:00 | AAPL | Stock | 0.4452 | 0.4455 | 0.4438 | 0.4453 | 3640000.0 |
| 2002-03-20 11:35:00 | AAPL | Stock | 0.4449 | 0.4461 | 0.4448 | 0.4455 | 3516800.0 |
| 2002-03-20 11:40:00 | AAPL | Stock | 0.4455 | 0.4457 | 0.4448 | 0.4455 | 2844800.0 |
| 2002-03-20 11:45:00 | AAPL | Stock | 0.4459 | 0.4463 | 0.4446 | 0.4457 | 3886400.0 |
| 2002-03-20 11:50:00 | AAPL | Stock | 0.4455 | 0.4461 | 0.4455 | 0.4459 | 336000.0 |
| 2002-03-20 11:55:00 | AAPL | Stock | 0.4455 | 0.4459 | 0.445 | 0.4455 | 4160800.0 |
| 2002-03-20 12:00:00 | AAPL | Stock | 0.4454 | 0.4455 | 0.4441 | 0.4454 | 4653600.0 |
| 2002-03-20 12:05:00 | AAPL | Stock | 0.4455 | 0.4457 | 0.445 | 0.4455 | 308000.0 |
| 2002-03-20 12:10:00 | AAPL | Stock | 0.4455 | 0.4461 | 0.4455 | 0.4455 | 616000.0 |
| 2002-03-20 12:15:00 | AAPL | Stock | 0.4459 | 0.4461 | 0.4457 | 0.4459 | 1136800.0 |
| 2002-03-20 12:20:00 | AAPL | Stock | 0.4459 | 0.4463 | 0.4457 | 0.4459 | 3382400.0 |
| 2002-03-20 12:25:00 | AAPL | Stock | 0.4459 | 0.4468 | 0.4455 | 0.4455 | 14341600.0 |
| 2002-03-20 12:30:00 | AAPL | Stock | 0.4461 | 0.4461 | 0.4457 | 0.4461 | 604800.0 |
| 2002-03-20 12:35:00 | AAPL | Stock | 0.4463 | 0.4464 | 0.4461 | 0.4463 | 1747200.0 |
| 2002-03-20 12:40:00 | AAPL | Stock | 0.4464 | 0.4464 | 0.4455 | 0.4455 | 2408000.0 |
| 2002-03-20 12:45:00 | AAPL | Stock | 0.4457 | 0.4464 | 0.4457 | 0.4461 | 705600.0 |
| 2002-03-20 12:50:00 | AAPL | Stock | 0.4461 | 0.4463 | 0.4454 | 0.4455 | 459200.0 |
| 2002-03-20 12:55:00 | AAPL | Stock | 0.4455 | 0.4459 | 0.445 | 0.4452 | 862400.0 |
| 2002-03-20 13:00:00 | AAPL | Stock | 0.4457 | 0.4457 | 0.445 | 0.445 | 442400.0 |
| 2002-03-20 13:05:00 | AAPL | Stock | 0.4448 | 0.4455 | 0.4434 | 0.4434 | 1164800.0 |
| 2002-03-20 13:10:00 | AAPL | Stock | 0.4434 | 0.4436 | 0.4434 | 0.4434 | 179200.0 |
> showing 50 of 115,772 rows — these rows as CSV