PREVIEW / stock_5min / 2000-07-03
file: by_date/stock_5min/2000/2000-07-03.parquet size: 734 KB rows: 51,067 symbols: 1,161
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 |
|---|---|---|---|---|---|---|---|
| 2000-07-03 08:00:00 | AAPL | Stock | 0.9353 | 0.9353 | 0.9353 | 0.9353 | 67200.0 |
| 2000-07-03 08:40:00 | AAPL | Stock | 0.9353 | 0.9353 | 0.9353 | 0.9353 | 11200.0 |
| 2000-07-03 08:50:00 | AAPL | Stock | 0.9353 | 0.9353 | 0.9353 | 0.9353 | 28000.0 |
| 2000-07-03 09:00:00 | AAPL | Stock | 0.9353 | 0.9353 | 0.9353 | 0.9353 | 5600.0 |
| 2000-07-03 09:20:00 | AAPL | Stock | 0.9342 | 0.9342 | 0.9308 | 0.9308 | 168000.0 |
| 2000-07-03 09:25:00 | AAPL | Stock | 0.933 | 0.9342 | 0.9308 | 0.9308 | 627200.0 |
| 2000-07-03 09:30:00 | AAPL | Stock | 0.9308 | 0.9375 | 0.9308 | 0.9375 | 5202400.0 |
| 2000-07-03 09:35:00 | AAPL | Stock | 0.9375 | 0.9431 | 0.9364 | 0.9431 | 2346400.0 |
| 2000-07-03 09:40:00 | AAPL | Stock | 0.9431 | 0.9464 | 0.9408 | 0.9453 | 4138400.0 |
| 2000-07-03 09:45:00 | AAPL | Stock | 0.9453 | 0.9542 | 0.9453 | 0.9531 | 1780800.0 |
| 2000-07-03 09:50:00 | AAPL | Stock | 0.9537 | 0.9565 | 0.9464 | 0.9464 | 2200800.0 |
| 2000-07-03 09:55:00 | AAPL | Stock | 0.9487 | 0.952 | 0.9464 | 0.9509 | 688800.0 |
| 2000-07-03 10:00:00 | AAPL | Stock | 0.952 | 0.9621 | 0.9509 | 0.9615 | 2105600.0 |
| 2000-07-03 10:05:00 | AAPL | Stock | 0.9621 | 0.9643 | 0.9598 | 0.9632 | 1612800.0 |
| 2000-07-03 10:10:00 | AAPL | Stock | 0.9643 | 0.9699 | 0.9621 | 0.9688 | 2256800.0 |
| 2000-07-03 10:15:00 | AAPL | Stock | 0.9688 | 0.9699 | 0.9643 | 0.9643 | 1657600.0 |
| 2000-07-03 10:20:00 | AAPL | Stock | 0.9621 | 0.9632 | 0.9487 | 0.952 | 1064000.0 |
| 2000-07-03 10:25:00 | AAPL | Stock | 0.9531 | 0.9565 | 0.9487 | 0.9565 | 868000.0 |
| 2000-07-03 10:30:00 | AAPL | Stock | 0.9565 | 0.9609 | 0.9554 | 0.9598 | 649600.0 |
| 2000-07-03 10:35:00 | AAPL | Stock | 0.9598 | 0.9632 | 0.9554 | 0.9554 | 599200.0 |
| 2000-07-03 10:40:00 | AAPL | Stock | 0.9587 | 0.9587 | 0.9487 | 0.952 | 1624000.0 |
| 2000-07-03 10:45:00 | AAPL | Stock | 0.952 | 0.9554 | 0.9509 | 0.9554 | 666400.0 |
| 2000-07-03 10:50:00 | AAPL | Stock | 0.9554 | 0.9576 | 0.9531 | 0.9531 | 756000.0 |
| 2000-07-03 10:55:00 | AAPL | Stock | 0.9531 | 0.9587 | 0.9531 | 0.9576 | 621600.0 |
| 2000-07-03 11:00:00 | AAPL | Stock | 0.9576 | 0.9576 | 0.9542 | 0.9542 | 364000.0 |
| 2000-07-03 11:05:00 | AAPL | Stock | 0.9531 | 0.9576 | 0.9531 | 0.9565 | 537600.0 |
| 2000-07-03 11:10:00 | AAPL | Stock | 0.9576 | 0.9576 | 0.9537 | 0.9576 | 806400.0 |
| 2000-07-03 11:15:00 | AAPL | Stock | 0.9576 | 0.9576 | 0.9542 | 0.9576 | 968800.0 |
| 2000-07-03 11:20:00 | AAPL | Stock | 0.9576 | 0.9587 | 0.9531 | 0.9531 | 632800.0 |
| 2000-07-03 11:25:00 | AAPL | Stock | 0.9531 | 0.9598 | 0.952 | 0.9587 | 890400.0 |
| 2000-07-03 11:30:00 | AAPL | Stock | 0.9598 | 0.9643 | 0.9598 | 0.9643 | 1232000.0 |
| 2000-07-03 11:35:00 | AAPL | Stock | 0.9632 | 0.9643 | 0.9565 | 0.9621 | 504000.0 |
| 2000-07-03 11:40:00 | AAPL | Stock | 0.9621 | 0.9621 | 0.9554 | 0.9598 | 700000.0 |
| 2000-07-03 11:45:00 | AAPL | Stock | 0.9565 | 0.9598 | 0.9554 | 0.9565 | 285600.0 |
| 2000-07-03 11:50:00 | AAPL | Stock | 0.9576 | 0.9576 | 0.9542 | 0.9542 | 1192800.0 |
| 2000-07-03 11:55:00 | AAPL | Stock | 0.9542 | 0.9576 | 0.952 | 0.9554 | 1691200.0 |
| 2000-07-03 12:00:00 | AAPL | Stock | 0.9554 | 0.9576 | 0.9554 | 0.9576 | 347200.0 |
| 2000-07-03 12:05:00 | AAPL | Stock | 0.9576 | 0.9576 | 0.9565 | 0.9576 | 520800.0 |
| 2000-07-03 12:10:00 | AAPL | Stock | 0.9565 | 0.9576 | 0.9554 | 0.9576 | 649600.0 |
| 2000-07-03 12:15:00 | AAPL | Stock | 0.9576 | 0.9576 | 0.9531 | 0.9531 | 459200.0 |
| 2000-07-03 12:20:00 | AAPL | Stock | 0.9576 | 0.9632 | 0.9554 | 0.9632 | 1926400.0 |
| 2000-07-03 12:25:00 | AAPL | Stock | 0.9632 | 0.9665 | 0.9609 | 0.9621 | 4222400.0 |
| 2000-07-03 12:30:00 | AAPL | Stock | 0.9654 | 0.9654 | 0.9621 | 0.9643 | 1898400.0 |
| 2000-07-03 12:35:00 | AAPL | Stock | 0.9643 | 0.9665 | 0.9621 | 0.9643 | 1915200.0 |
| 2000-07-03 12:40:00 | AAPL | Stock | 0.9654 | 0.9682 | 0.9643 | 0.9676 | 2968000.0 |
| 2000-07-03 12:45:00 | AAPL | Stock | 0.9665 | 0.9688 | 0.9598 | 0.9609 | 3892000.0 |
| 2000-07-03 12:50:00 | AAPL | Stock | 0.9621 | 0.9621 | 0.9576 | 0.9609 | 1752800.0 |
| 2000-07-03 12:55:00 | AAPL | Stock | 0.9609 | 0.9609 | 0.952 | 0.952 | 4020800.0 |
| 2000-07-03 13:00:00 | AAPL | Stock | 0.952 | 0.9565 | 0.952 | 0.952 | 728000.0 |
| 2000-07-03 08:00:00 | MSFT | Stock | 39.75 | 40.0 | 39.75 | 40.0 | 40600.0 |
> showing 50 of 51,067 rows — these rows as CSV