PREVIEW / stock_5min / 2005-08-19
file: by_date/stock_5min/2005/2005-08-19.parquet size: 2.6 MB rows: 191,362 symbols: 2,064
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-08-19 08:10:00 | AAPL | Stock | 1.6646 | 1.6646 | 1.6646 | 1.6646 | 2800.0 |
| 2005-08-19 08:15:00 | AAPL | Stock | 1.6643 | 1.665 | 1.6643 | 1.665 | 81200.0 |
| 2005-08-19 08:20:00 | AAPL | Stock | 1.665 | 1.665 | 1.665 | 1.665 | 19600.0 |
| 2005-08-19 08:25:00 | AAPL | Stock | 1.665 | 1.665 | 1.665 | 1.665 | 5600.0 |
| 2005-08-19 08:30:00 | AAPL | Stock | 1.6639 | 1.6639 | 1.6639 | 1.6639 | 11200.0 |
| 2005-08-19 08:35:00 | AAPL | Stock | 1.6607 | 1.6636 | 1.6607 | 1.6636 | 15400.0 |
| 2005-08-19 08:45:00 | AAPL | Stock | 1.6636 | 1.6636 | 1.6614 | 1.6614 | 106400.0 |
| 2005-08-19 08:50:00 | AAPL | Stock | 1.6625 | 1.6625 | 1.6625 | 1.6625 | 33600.0 |
| 2005-08-19 08:55:00 | AAPL | Stock | 1.6625 | 1.6625 | 1.6607 | 1.6607 | 51800.0 |
| 2005-08-19 09:00:00 | AAPL | Stock | 1.6621 | 1.6621 | 1.6593 | 1.6621 | 145600.0 |
| 2005-08-19 09:05:00 | AAPL | Stock | 1.6621 | 1.6621 | 1.6607 | 1.6607 | 30800.0 |
| 2005-08-19 09:10:00 | AAPL | Stock | 1.6607 | 1.6621 | 1.6607 | 1.6621 | 168000.0 |
| 2005-08-19 09:15:00 | AAPL | Stock | 1.6607 | 1.6639 | 1.6607 | 1.6607 | 214200.0 |
| 2005-08-19 09:20:00 | AAPL | Stock | 1.6593 | 1.6607 | 1.6582 | 1.6607 | 25200.0 |
| 2005-08-19 09:25:00 | AAPL | Stock | 1.6607 | 1.6607 | 1.6511 | 1.6543 | 2400300.0 |
| 2005-08-19 09:30:00 | AAPL | Stock | 1.6529 | 1.66 | 1.65 | 1.6589 | 27005636.0 |
| 2005-08-19 09:35:00 | AAPL | Stock | 1.6589 | 1.6593 | 1.6539 | 1.655 | 7656320.0 |
| 2005-08-19 09:40:00 | AAPL | Stock | 1.6557 | 1.6607 | 1.6546 | 1.6593 | 9015188.0 |
| 2005-08-19 09:45:00 | AAPL | Stock | 1.6593 | 1.6607 | 1.6575 | 1.6596 | 8030708.0 |
| 2005-08-19 09:50:00 | AAPL | Stock | 1.66 | 1.6607 | 1.6579 | 1.6604 | 7002380.0 |
| 2005-08-19 09:55:00 | AAPL | Stock | 1.6607 | 1.6671 | 1.6579 | 1.665 | 19632648.0 |
| 2005-08-19 10:00:00 | AAPL | Stock | 1.6654 | 1.6679 | 1.6589 | 1.66 | 14521220.0 |
| 2005-08-19 10:05:00 | AAPL | Stock | 1.66 | 1.6607 | 1.6468 | 1.6525 | 24646692.0 |
| 2005-08-19 10:10:00 | AAPL | Stock | 1.6521 | 1.6546 | 1.6436 | 1.6486 | 16746184.0 |
| 2005-08-19 10:15:00 | AAPL | Stock | 1.6486 | 1.6504 | 1.6375 | 1.6379 | 11979072.0 |
| 2005-08-19 10:20:00 | AAPL | Stock | 1.6375 | 1.6461 | 1.6361 | 1.6446 | 14078148.0 |
| 2005-08-19 10:25:00 | AAPL | Stock | 1.6443 | 1.6471 | 1.6414 | 1.6471 | 6181392.0 |
| 2005-08-19 10:30:00 | AAPL | Stock | 1.6461 | 1.6486 | 1.645 | 1.6454 | 4775484.0 |
| 2005-08-19 10:35:00 | AAPL | Stock | 1.6454 | 1.6454 | 1.64 | 1.6404 | 7374332.0 |
| 2005-08-19 10:40:00 | AAPL | Stock | 1.6404 | 1.6457 | 1.6379 | 1.6453 | 9950696.0 |
| 2005-08-19 10:45:00 | AAPL | Stock | 1.6454 | 1.6464 | 1.6436 | 1.6464 | 2447256.0 |
| 2005-08-19 10:50:00 | AAPL | Stock | 1.6461 | 1.6479 | 1.6446 | 1.645 | 3459652.0 |
| 2005-08-19 10:55:00 | AAPL | Stock | 1.6457 | 1.6464 | 1.6429 | 1.6439 | 2317336.0 |
| 2005-08-19 11:00:00 | AAPL | Stock | 1.6439 | 1.6454 | 1.6389 | 1.64 | 7778960.0 |
| 2005-08-19 11:05:00 | AAPL | Stock | 1.6396 | 1.6432 | 1.6379 | 1.6396 | 4226516.0 |
| 2005-08-19 11:10:00 | AAPL | Stock | 1.6396 | 1.6411 | 1.6361 | 1.6364 | 4889304.0 |
| 2005-08-19 11:15:00 | AAPL | Stock | 1.6361 | 1.6382 | 1.635 | 1.6375 | 6212500.0 |
| 2005-08-19 11:20:00 | AAPL | Stock | 1.6375 | 1.6421 | 1.6364 | 1.6389 | 6052620.0 |
| 2005-08-19 11:25:00 | AAPL | Stock | 1.6389 | 1.6407 | 1.6364 | 1.6382 | 3429244.0 |
| 2005-08-19 11:30:00 | AAPL | Stock | 1.6386 | 1.6411 | 1.6386 | 1.6407 | 2083508.0 |
| 2005-08-19 11:35:00 | AAPL | Stock | 1.6407 | 1.6454 | 1.6404 | 1.6436 | 4568004.0 |
| 2005-08-19 11:40:00 | AAPL | Stock | 1.6439 | 1.6457 | 1.6421 | 1.6446 | 4553920.0 |
| 2005-08-19 11:45:00 | AAPL | Stock | 1.6446 | 1.645 | 1.6411 | 1.6414 | 2100364.0 |
| 2005-08-19 11:50:00 | AAPL | Stock | 1.6411 | 1.6421 | 1.6382 | 1.6382 | 3184160.0 |
| 2005-08-19 11:55:00 | AAPL | Stock | 1.6382 | 1.6404 | 1.6379 | 1.6379 | 2286984.0 |
| 2005-08-19 12:00:00 | AAPL | Stock | 1.6379 | 1.6436 | 1.6371 | 1.6389 | 2789780.0 |
| 2005-08-19 12:05:00 | AAPL | Stock | 1.6389 | 1.64 | 1.6379 | 1.6382 | 1940288.0 |
| 2005-08-19 12:10:00 | AAPL | Stock | 1.6382 | 1.6389 | 1.6371 | 1.6382 | 1146544.0 |
| 2005-08-19 12:15:00 | AAPL | Stock | 1.6386 | 1.6386 | 1.6368 | 1.6379 | 1953784.0 |
| 2005-08-19 12:20:00 | AAPL | Stock | 1.6379 | 1.6393 | 1.6375 | 1.6386 | 1720600.0 |
> showing 50 of 191,362 rows — these rows as CSV