PREVIEW / stock_5min / 2002-03-11
file: by_date/stock_5min/2002/2002-03-11.parquet size: 1.7 MB rows: 119,531 symbols: 1,398
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-11 08:00:00 | AAPL | Stock | 0.4406 | 0.4406 | 0.4406 | 0.4406 | 84000.0 |
| 2002-03-11 08:15:00 | AAPL | Stock | 0.44 | 0.44 | 0.44 | 0.44 | 28000.0 |
| 2002-03-11 08:55:00 | AAPL | Stock | 0.4391 | 0.4391 | 0.4391 | 0.4391 | 67200.0 |
| 2002-03-11 09:25:00 | AAPL | Stock | 0.4395 | 0.44 | 0.4395 | 0.44 | 112000.0 |
| 2002-03-11 09:30:00 | AAPL | Stock | 0.4393 | 0.4414 | 0.4323 | 0.4323 | 8108800.0 |
| 2002-03-11 09:35:00 | AAPL | Stock | 0.4325 | 0.4325 | 0.4305 | 0.4308 | 7621600.0 |
| 2002-03-11 09:40:00 | AAPL | Stock | 0.4311 | 0.4325 | 0.4304 | 0.4316 | 4306400.0 |
| 2002-03-11 09:45:00 | AAPL | Stock | 0.4316 | 0.4329 | 0.4313 | 0.4314 | 4390400.0 |
| 2002-03-11 09:50:00 | AAPL | Stock | 0.4313 | 0.4339 | 0.4313 | 0.4329 | 2996000.0 |
| 2002-03-11 09:55:00 | AAPL | Stock | 0.4329 | 0.4332 | 0.4314 | 0.4327 | 2458400.0 |
| 2002-03-11 10:00:00 | AAPL | Stock | 0.433 | 0.4339 | 0.4318 | 0.4318 | 7828800.0 |
| 2002-03-11 10:05:00 | AAPL | Stock | 0.4321 | 0.4364 | 0.432 | 0.4364 | 3908800.0 |
| 2002-03-11 10:10:00 | AAPL | Stock | 0.4364 | 0.4386 | 0.4357 | 0.4384 | 3169600.0 |
| 2002-03-11 10:15:00 | AAPL | Stock | 0.4386 | 0.4396 | 0.4382 | 0.4396 | 4984000.0 |
| 2002-03-11 10:20:00 | AAPL | Stock | 0.4396 | 0.442 | 0.4393 | 0.4404 | 6316800.0 |
| 2002-03-11 10:25:00 | AAPL | Stock | 0.44 | 0.442 | 0.4393 | 0.4393 | 4194400.0 |
| 2002-03-11 10:30:00 | AAPL | Stock | 0.4395 | 0.4402 | 0.4382 | 0.4382 | 1086400.0 |
| 2002-03-11 10:35:00 | AAPL | Stock | 0.4393 | 0.4402 | 0.435 | 0.435 | 2850400.0 |
| 2002-03-11 10:40:00 | AAPL | Stock | 0.4354 | 0.4382 | 0.4341 | 0.4343 | 1792000.0 |
| 2002-03-11 10:45:00 | AAPL | Stock | 0.4345 | 0.437 | 0.4341 | 0.4363 | 952000.0 |
| 2002-03-11 10:50:00 | AAPL | Stock | 0.4364 | 0.4382 | 0.4363 | 0.4373 | 1691200.0 |
| 2002-03-11 10:55:00 | AAPL | Stock | 0.4373 | 0.44 | 0.4373 | 0.44 | 1797600.0 |
| 2002-03-11 11:00:00 | AAPL | Stock | 0.44 | 0.4411 | 0.4393 | 0.4405 | 1708000.0 |
| 2002-03-11 11:05:00 | AAPL | Stock | 0.4405 | 0.4409 | 0.4395 | 0.4396 | 1719200.0 |
| 2002-03-11 11:10:00 | AAPL | Stock | 0.4396 | 0.4398 | 0.4386 | 0.4388 | 1388800.0 |
| 2002-03-11 11:15:00 | AAPL | Stock | 0.4391 | 0.4396 | 0.4364 | 0.437 | 3416000.0 |
| 2002-03-11 11:20:00 | AAPL | Stock | 0.437 | 0.4393 | 0.437 | 0.4384 | 1764000.0 |
| 2002-03-11 11:25:00 | AAPL | Stock | 0.4384 | 0.4386 | 0.437 | 0.4377 | 890400.0 |
| 2002-03-11 11:30:00 | AAPL | Stock | 0.437 | 0.4389 | 0.437 | 0.4389 | 560000.0 |
| 2002-03-11 11:35:00 | AAPL | Stock | 0.4393 | 0.4407 | 0.4393 | 0.4393 | 873600.0 |
| 2002-03-11 11:40:00 | AAPL | Stock | 0.4398 | 0.44 | 0.4386 | 0.4389 | 1260000.0 |
| 2002-03-11 11:45:00 | AAPL | Stock | 0.4386 | 0.439 | 0.4362 | 0.4364 | 1478400.0 |
| 2002-03-11 11:50:00 | AAPL | Stock | 0.4371 | 0.4375 | 0.4366 | 0.4366 | 324800.0 |
| 2002-03-11 11:55:00 | AAPL | Stock | 0.437 | 0.437 | 0.4366 | 0.4366 | 459200.0 |
| 2002-03-11 12:00:00 | AAPL | Stock | 0.4366 | 0.4377 | 0.4366 | 0.4377 | 644000.0 |
| 2002-03-11 12:05:00 | AAPL | Stock | 0.4373 | 0.4391 | 0.4373 | 0.4389 | 812000.0 |
| 2002-03-11 12:10:00 | AAPL | Stock | 0.4393 | 0.4393 | 0.4371 | 0.4373 | 868000.0 |
| 2002-03-11 12:15:00 | AAPL | Stock | 0.4377 | 0.438 | 0.4371 | 0.4379 | 980000.0 |
| 2002-03-11 12:20:00 | AAPL | Stock | 0.4384 | 0.4393 | 0.4382 | 0.4391 | 565600.0 |
| 2002-03-11 12:25:00 | AAPL | Stock | 0.4389 | 0.4393 | 0.4384 | 0.4384 | 1736000.0 |
| 2002-03-11 12:30:00 | AAPL | Stock | 0.438 | 0.4391 | 0.4379 | 0.4386 | 677600.0 |
| 2002-03-11 12:35:00 | AAPL | Stock | 0.4386 | 0.4391 | 0.4382 | 0.4388 | 324800.0 |
| 2002-03-11 12:40:00 | AAPL | Stock | 0.4389 | 0.4418 | 0.4389 | 0.4414 | 1327200.0 |
| 2002-03-11 12:45:00 | AAPL | Stock | 0.4407 | 0.4414 | 0.4402 | 0.4409 | 649600.0 |
| 2002-03-11 12:50:00 | AAPL | Stock | 0.4404 | 0.4411 | 0.4402 | 0.4404 | 481600.0 |
| 2002-03-11 12:55:00 | AAPL | Stock | 0.4404 | 0.4414 | 0.4404 | 0.4405 | 543200.0 |
| 2002-03-11 13:00:00 | AAPL | Stock | 0.4405 | 0.4409 | 0.4404 | 0.4404 | 672000.0 |
| 2002-03-11 13:05:00 | AAPL | Stock | 0.4398 | 0.4398 | 0.4388 | 0.4398 | 733600.0 |
| 2002-03-11 13:10:00 | AAPL | Stock | 0.4398 | 0.4402 | 0.4393 | 0.44 | 588000.0 |
| 2002-03-11 13:15:00 | AAPL | Stock | 0.44 | 0.4407 | 0.4396 | 0.4404 | 224000.0 |
> showing 50 of 119,531 rows — these rows as CSV