PREVIEW / stock_5min / 2002-03-19
file: by_date/stock_5min/2002/2002-03-19.parquet size: 1.7 MB rows: 118,472 symbols: 1,395
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-19 08:00:00 | AAPL | Stock | 0.442 | 0.442 | 0.4417 | 0.4417 | 2324000.0 |
| 2002-03-19 09:20:00 | AAPL | Stock | 0.4414 | 0.4414 | 0.4414 | 0.4414 | 67200.0 |
| 2002-03-19 09:25:00 | AAPL | Stock | 0.4411 | 0.4418 | 0.4404 | 0.4411 | 246400.0 |
| 2002-03-19 09:30:00 | AAPL | Stock | 0.4409 | 0.4425 | 0.4402 | 0.4411 | 5756800.0 |
| 2002-03-19 09:35:00 | AAPL | Stock | 0.4409 | 0.4425 | 0.4402 | 0.4409 | 2856000.0 |
| 2002-03-19 09:40:00 | AAPL | Stock | 0.4407 | 0.4418 | 0.4395 | 0.4414 | 1780800.0 |
| 2002-03-19 09:45:00 | AAPL | Stock | 0.4413 | 0.4416 | 0.4402 | 0.4416 | 1601600.0 |
| 2002-03-19 09:50:00 | AAPL | Stock | 0.4411 | 0.4416 | 0.4402 | 0.4416 | 1607200.0 |
| 2002-03-19 09:55:00 | AAPL | Stock | 0.4416 | 0.4418 | 0.4398 | 0.4413 | 1982400.0 |
| 2002-03-19 10:00:00 | AAPL | Stock | 0.4411 | 0.4411 | 0.4398 | 0.4405 | 1075200.0 |
| 2002-03-19 10:05:00 | AAPL | Stock | 0.4405 | 0.4421 | 0.4402 | 0.4404 | 2060800.0 |
| 2002-03-19 10:10:00 | AAPL | Stock | 0.4404 | 0.4405 | 0.4379 | 0.4382 | 3052000.0 |
| 2002-03-19 10:15:00 | AAPL | Stock | 0.4384 | 0.4393 | 0.4368 | 0.4382 | 4642400.0 |
| 2002-03-19 10:20:00 | AAPL | Stock | 0.4382 | 0.4382 | 0.4373 | 0.4375 | 1898400.0 |
| 2002-03-19 10:25:00 | AAPL | Stock | 0.4375 | 0.44 | 0.4375 | 0.4393 | 1321600.0 |
| 2002-03-19 10:30:00 | AAPL | Stock | 0.4389 | 0.4398 | 0.4388 | 0.4388 | 1164800.0 |
| 2002-03-19 10:35:00 | AAPL | Stock | 0.4384 | 0.4389 | 0.4379 | 0.438 | 1080800.0 |
| 2002-03-19 10:40:00 | AAPL | Stock | 0.4382 | 0.4382 | 0.4379 | 0.4382 | 862400.0 |
| 2002-03-19 10:45:00 | AAPL | Stock | 0.438 | 0.4382 | 0.4377 | 0.4382 | 834400.0 |
| 2002-03-19 10:50:00 | AAPL | Stock | 0.438 | 0.4393 | 0.438 | 0.4384 | 1713600.0 |
| 2002-03-19 10:55:00 | AAPL | Stock | 0.4382 | 0.4388 | 0.4377 | 0.4388 | 1489600.0 |
| 2002-03-19 11:00:00 | AAPL | Stock | 0.4389 | 0.44 | 0.4388 | 0.4393 | 2139200.0 |
| 2002-03-19 11:05:00 | AAPL | Stock | 0.4389 | 0.4407 | 0.4389 | 0.44 | 1668800.0 |
| 2002-03-19 11:10:00 | AAPL | Stock | 0.4404 | 0.4404 | 0.4388 | 0.4388 | 980000.0 |
| 2002-03-19 11:15:00 | AAPL | Stock | 0.4391 | 0.4395 | 0.4388 | 0.4395 | 1332800.0 |
| 2002-03-19 11:20:00 | AAPL | Stock | 0.4395 | 0.4398 | 0.4395 | 0.4397 | 280000.0 |
| 2002-03-19 11:25:00 | AAPL | Stock | 0.4398 | 0.4404 | 0.4396 | 0.4404 | 884800.0 |
| 2002-03-19 11:30:00 | AAPL | Stock | 0.44 | 0.4414 | 0.44 | 0.4409 | 1568000.0 |
| 2002-03-19 11:35:00 | AAPL | Stock | 0.4405 | 0.4414 | 0.44 | 0.4407 | 2794400.0 |
| 2002-03-19 11:40:00 | AAPL | Stock | 0.4404 | 0.4418 | 0.4404 | 0.4418 | 1685600.0 |
| 2002-03-19 11:45:00 | AAPL | Stock | 0.4418 | 0.4425 | 0.4413 | 0.4423 | 3124800.0 |
| 2002-03-19 11:50:00 | AAPL | Stock | 0.4423 | 0.4423 | 0.4413 | 0.4416 | 610400.0 |
| 2002-03-19 11:55:00 | AAPL | Stock | 0.4416 | 0.4423 | 0.4414 | 0.442 | 1338400.0 |
| 2002-03-19 12:00:00 | AAPL | Stock | 0.442 | 0.4434 | 0.4416 | 0.4423 | 4334400.0 |
| 2002-03-19 12:05:00 | AAPL | Stock | 0.4425 | 0.443 | 0.4423 | 0.4427 | 957600.0 |
| 2002-03-19 12:10:00 | AAPL | Stock | 0.4423 | 0.4429 | 0.442 | 0.4421 | 2447200.0 |
| 2002-03-19 12:15:00 | AAPL | Stock | 0.4425 | 0.4436 | 0.4425 | 0.4432 | 1472800.0 |
| 2002-03-19 12:20:00 | AAPL | Stock | 0.4432 | 0.4441 | 0.4429 | 0.4432 | 2581600.0 |
| 2002-03-19 12:25:00 | AAPL | Stock | 0.4438 | 0.4441 | 0.443 | 0.4434 | 3606400.0 |
| 2002-03-19 12:30:00 | AAPL | Stock | 0.4434 | 0.4443 | 0.4429 | 0.4436 | 5241600.0 |
| 2002-03-19 12:35:00 | AAPL | Stock | 0.4436 | 0.4439 | 0.4436 | 0.4439 | 526400.0 |
| 2002-03-19 12:40:00 | AAPL | Stock | 0.4438 | 0.4441 | 0.4436 | 0.4436 | 1299200.0 |
| 2002-03-19 12:45:00 | AAPL | Stock | 0.4439 | 0.4441 | 0.4436 | 0.4439 | 644000.0 |
| 2002-03-19 12:50:00 | AAPL | Stock | 0.4439 | 0.4455 | 0.4438 | 0.4445 | 2816800.0 |
| 2002-03-19 12:55:00 | AAPL | Stock | 0.4446 | 0.4457 | 0.4445 | 0.4455 | 5348000.0 |
| 2002-03-19 13:00:00 | AAPL | Stock | 0.4455 | 0.4457 | 0.4448 | 0.4452 | 2363200.0 |
| 2002-03-19 13:05:00 | AAPL | Stock | 0.445 | 0.4464 | 0.4448 | 0.4461 | 2284800.0 |
| 2002-03-19 13:10:00 | AAPL | Stock | 0.4459 | 0.4461 | 0.4455 | 0.4457 | 1041600.0 |
| 2002-03-19 13:15:00 | AAPL | Stock | 0.4457 | 0.4464 | 0.4457 | 0.4464 | 7845600.0 |
| 2002-03-19 13:20:00 | AAPL | Stock | 0.4464 | 0.4468 | 0.4457 | 0.4457 | 6680800.0 |
> showing 50 of 118,472 rows — these rows as CSV