PREVIEW / stock_5min / 2007-10-10
file: by_date/stock_5min/2007/2007-10-10.parquet size: 4.1 MB rows: 302,328 symbols: 3,146
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 |
|---|---|---|---|---|---|---|---|
| 2007-10-10 05:05:00 | AAPL | Stock | 5.985 | 5.985 | 5.985 | 5.985 | 14000.0 |
| 2007-10-10 07:05:00 | AAPL | Stock | 5.9946 | 5.9946 | 5.9929 | 5.9929 | 5600.0 |
| 2007-10-10 07:10:00 | AAPL | Stock | 5.9825 | 5.9825 | 5.9825 | 5.9825 | 50400.0 |
| 2007-10-10 07:15:00 | AAPL | Stock | 5.9821 | 5.9821 | 5.9768 | 5.9768 | 16800.0 |
| 2007-10-10 07:20:00 | AAPL | Stock | 5.9771 | 5.9804 | 5.9761 | 5.9804 | 19600.0 |
| 2007-10-10 07:25:00 | AAPL | Stock | 5.9711 | 5.9711 | 5.9679 | 5.9689 | 64400.0 |
| 2007-10-10 07:35:00 | AAPL | Stock | 5.9768 | 5.9768 | 5.9768 | 5.9768 | 2800.0 |
| 2007-10-10 07:55:00 | AAPL | Stock | 5.9818 | 5.9818 | 5.9818 | 5.9818 | 5600.0 |
| 2007-10-10 08:00:00 | AAPL | Stock | 5.9768 | 5.9907 | 5.9696 | 5.9821 | 173796.0 |
| 2007-10-10 08:05:00 | AAPL | Stock | 5.9821 | 5.9946 | 5.9821 | 5.9929 | 387632.0 |
| 2007-10-10 08:10:00 | AAPL | Stock | 5.9929 | 5.9946 | 5.9875 | 5.9889 | 140728.0 |
| 2007-10-10 08:20:00 | AAPL | Stock | 5.9907 | 5.9929 | 5.9854 | 5.9854 | 168000.0 |
| 2007-10-10 08:25:00 | AAPL | Stock | 5.9825 | 5.9846 | 5.9804 | 5.9843 | 95368.0 |
| 2007-10-10 08:30:00 | AAPL | Stock | 5.9846 | 5.99 | 5.9804 | 5.9857 | 180292.0 |
| 2007-10-10 08:35:00 | AAPL | Stock | 5.9854 | 5.9929 | 5.9854 | 5.9929 | 183400.0 |
| 2007-10-10 08:40:00 | AAPL | Stock | 5.9929 | 6.0054 | 5.9911 | 6.0018 | 498960.0 |
| 2007-10-10 08:45:00 | AAPL | Stock | 6.0036 | 6.0104 | 5.9989 | 5.9989 | 705432.0 |
| 2007-10-10 08:50:00 | AAPL | Stock | 6.0036 | 6.0068 | 5.9964 | 6.0004 | 379428.0 |
| 2007-10-10 08:55:00 | AAPL | Stock | 6.0018 | 6.0018 | 5.9964 | 5.9964 | 44800.0 |
| 2007-10-10 09:00:00 | AAPL | Stock | 5.9964 | 5.9982 | 5.9946 | 5.9982 | 81620.0 |
| 2007-10-10 09:05:00 | AAPL | Stock | 5.9982 | 6.0071 | 5.9943 | 5.9979 | 348628.0 |
| 2007-10-10 09:10:00 | AAPL | Stock | 5.995 | 5.9964 | 5.9879 | 5.9907 | 194180.0 |
| 2007-10-10 09:15:00 | AAPL | Stock | 5.9911 | 5.9911 | 5.9857 | 5.9857 | 54320.0 |
| 2007-10-10 09:20:00 | AAPL | Stock | 5.9861 | 5.9954 | 5.9832 | 5.995 | 107380.0 |
| 2007-10-10 09:25:00 | AAPL | Stock | 5.9946 | 5.9957 | 5.9832 | 5.9889 | 346192.0 |
| 2007-10-10 09:30:00 | AAPL | Stock | 5.985 | 5.9957 | 5.9286 | 5.9464 | 31886008.0 |
| 2007-10-10 09:35:00 | AAPL | Stock | 5.9461 | 5.9639 | 5.9289 | 5.9439 | 18924444.0 |
| 2007-10-10 09:40:00 | AAPL | Stock | 5.9443 | 5.9525 | 5.9364 | 5.9457 | 12853680.0 |
| 2007-10-10 09:45:00 | AAPL | Stock | 5.9461 | 5.9568 | 5.9304 | 5.9529 | 13363812.0 |
| 2007-10-10 09:50:00 | AAPL | Stock | 5.9536 | 5.9575 | 5.9314 | 5.94 | 11274900.0 |
| 2007-10-10 09:55:00 | AAPL | Stock | 5.94 | 5.9446 | 5.92 | 5.9343 | 20871396.0 |
| 2007-10-10 10:00:00 | AAPL | Stock | 5.9339 | 5.9429 | 5.9261 | 5.9389 | 12044676.0 |
| 2007-10-10 10:05:00 | AAPL | Stock | 5.9389 | 5.9389 | 5.9143 | 5.9254 | 13093528.0 |
| 2007-10-10 10:10:00 | AAPL | Stock | 5.9261 | 5.9421 | 5.9225 | 5.9354 | 13157956.0 |
| 2007-10-10 10:15:00 | AAPL | Stock | 5.9357 | 5.9486 | 5.9329 | 5.9457 | 9737000.0 |
| 2007-10-10 10:20:00 | AAPL | Stock | 5.9457 | 5.9511 | 5.9382 | 5.9411 | 9758448.0 |
| 2007-10-10 10:25:00 | AAPL | Stock | 5.9409 | 5.9437 | 5.9286 | 5.9354 | 7978908.0 |
| 2007-10-10 10:30:00 | AAPL | Stock | 5.9354 | 5.9436 | 5.9325 | 5.9375 | 9260832.0 |
| 2007-10-10 10:35:00 | AAPL | Stock | 5.9379 | 5.9454 | 5.9343 | 5.9421 | 7624428.0 |
| 2007-10-10 10:40:00 | AAPL | Stock | 5.9414 | 5.9521 | 5.9379 | 5.9421 | 8615852.0 |
| 2007-10-10 10:45:00 | AAPL | Stock | 5.9421 | 5.9471 | 5.9386 | 5.9446 | 7194824.0 |
| 2007-10-10 10:50:00 | AAPL | Stock | 5.9443 | 5.9457 | 5.9396 | 5.9425 | 4580212.0 |
| 2007-10-10 10:55:00 | AAPL | Stock | 5.9429 | 5.9454 | 5.9386 | 5.9425 | 5098520.0 |
| 2007-10-10 11:00:00 | AAPL | Stock | 5.9425 | 5.9589 | 5.94 | 5.9586 | 7565208.0 |
| 2007-10-10 11:05:00 | AAPL | Stock | 5.9586 | 5.9792 | 5.9575 | 5.9679 | 18309536.0 |
| 2007-10-10 11:10:00 | AAPL | Stock | 5.9675 | 5.9711 | 5.9596 | 5.9611 | 10825864.0 |
| 2007-10-10 11:15:00 | AAPL | Stock | 5.9604 | 5.9657 | 5.9579 | 5.96 | 8621144.0 |
| 2007-10-10 11:20:00 | AAPL | Stock | 5.9604 | 5.9629 | 5.9518 | 5.9614 | 10106712.0 |
| 2007-10-10 11:25:00 | AAPL | Stock | 5.9621 | 5.9675 | 5.9546 | 5.9668 | 8228864.0 |
| 2007-10-10 11:30:00 | AAPL | Stock | 5.9671 | 5.9693 | 5.9589 | 5.9668 | 5259268.0 |
> showing 50 of 302,328 rows — these rows as CSV