PREVIEW / stock_5min / 2006-07-12
file: by_date/stock_5min/2006/2006-07-12.parquet size: 3.1 MB rows: 224,243 symbols: 2,314
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 |
|---|---|---|---|---|---|---|---|
| 2006-07-12 07:20:00 | AAPL | Stock | 1.985 | 1.985 | 1.985 | 1.985 | 28000.0 |
| 2006-07-12 08:00:00 | AAPL | Stock | 1.9786 | 1.9786 | 1.9786 | 1.9786 | 5600.0 |
| 2006-07-12 08:05:00 | AAPL | Stock | 1.9779 | 1.9786 | 1.975 | 1.9786 | 166600.0 |
| 2006-07-12 08:10:00 | AAPL | Stock | 1.9786 | 1.9786 | 1.9768 | 1.9771 | 114800.0 |
| 2006-07-12 08:15:00 | AAPL | Stock | 1.9771 | 1.9771 | 1.9768 | 1.9768 | 96600.0 |
| 2006-07-12 08:20:00 | AAPL | Stock | 1.9768 | 1.9768 | 1.9714 | 1.9714 | 176400.0 |
| 2006-07-12 08:25:00 | AAPL | Stock | 1.9714 | 1.9721 | 1.9686 | 1.9686 | 108584.0 |
| 2006-07-12 08:30:00 | AAPL | Stock | 1.9729 | 1.9732 | 1.9714 | 1.9714 | 261912.0 |
| 2006-07-12 08:35:00 | AAPL | Stock | 1.9714 | 1.9714 | 1.9661 | 1.9714 | 149772.0 |
| 2006-07-12 08:40:00 | AAPL | Stock | 1.9714 | 1.9714 | 1.9704 | 1.9704 | 170800.0 |
| 2006-07-12 08:45:00 | AAPL | Stock | 1.9714 | 1.9729 | 1.9714 | 1.9729 | 123200.0 |
| 2006-07-12 08:50:00 | AAPL | Stock | 1.9729 | 1.9746 | 1.9729 | 1.9729 | 116536.0 |
| 2006-07-12 08:55:00 | AAPL | Stock | 1.9743 | 1.9746 | 1.9732 | 1.9732 | 22400.0 |
| 2006-07-12 09:00:00 | AAPL | Stock | 1.9732 | 1.9732 | 1.9696 | 1.9704 | 94724.0 |
| 2006-07-12 09:05:00 | AAPL | Stock | 1.9714 | 1.9732 | 1.9696 | 1.9696 | 136920.0 |
| 2006-07-12 09:10:00 | AAPL | Stock | 1.97 | 1.97 | 1.97 | 1.97 | 14000.0 |
| 2006-07-12 09:15:00 | AAPL | Stock | 1.9714 | 1.9714 | 1.9714 | 1.9714 | 7000.0 |
| 2006-07-12 09:20:00 | AAPL | Stock | 1.97 | 1.9729 | 1.97 | 1.97 | 50400.0 |
| 2006-07-12 09:25:00 | AAPL | Stock | 1.9732 | 1.9732 | 1.9696 | 1.9704 | 543732.0 |
| 2006-07-12 09:30:00 | AAPL | Stock | 1.9704 | 1.9729 | 1.9607 | 1.9661 | 18850608.0 |
| 2006-07-12 09:35:00 | AAPL | Stock | 1.9661 | 1.9714 | 1.9604 | 1.9625 | 11895184.0 |
| 2006-07-12 09:40:00 | AAPL | Stock | 1.9625 | 1.9646 | 1.9571 | 1.9621 | 16000628.0 |
| 2006-07-12 09:45:00 | AAPL | Stock | 1.9614 | 1.97 | 1.9614 | 1.9693 | 15980944.0 |
| 2006-07-12 09:50:00 | AAPL | Stock | 1.9693 | 1.9693 | 1.9589 | 1.9614 | 15169784.0 |
| 2006-07-12 09:55:00 | AAPL | Stock | 1.9611 | 1.9614 | 1.9543 | 1.9564 | 14960092.0 |
| 2006-07-12 10:00:00 | AAPL | Stock | 1.9564 | 1.96 | 1.9529 | 1.9582 | 13629112.0 |
| 2006-07-12 10:05:00 | AAPL | Stock | 1.9582 | 1.9596 | 1.9546 | 1.9568 | 8132964.0 |
| 2006-07-12 10:10:00 | AAPL | Stock | 1.9571 | 1.9575 | 1.9464 | 1.9471 | 19289760.0 |
| 2006-07-12 10:15:00 | AAPL | Stock | 1.9468 | 1.9543 | 1.9464 | 1.9536 | 14321244.0 |
| 2006-07-12 10:20:00 | AAPL | Stock | 1.9536 | 1.9536 | 1.9432 | 1.9496 | 18498032.0 |
| 2006-07-12 10:25:00 | AAPL | Stock | 1.9496 | 1.95 | 1.9457 | 1.9489 | 8131200.0 |
| 2006-07-12 10:30:00 | AAPL | Stock | 1.9489 | 1.9525 | 1.9411 | 1.9411 | 17393236.0 |
| 2006-07-12 10:35:00 | AAPL | Stock | 1.9414 | 1.9425 | 1.9368 | 1.9375 | 19916148.0 |
| 2006-07-12 10:40:00 | AAPL | Stock | 1.9379 | 1.945 | 1.9379 | 1.9446 | 11778396.0 |
| 2006-07-12 10:45:00 | AAPL | Stock | 1.9443 | 1.9482 | 1.9396 | 1.94 | 13215076.0 |
| 2006-07-12 10:50:00 | AAPL | Stock | 1.9404 | 1.9407 | 1.9354 | 1.9379 | 14469644.0 |
| 2006-07-12 10:55:00 | AAPL | Stock | 1.9382 | 1.9421 | 1.9375 | 1.9414 | 7576156.0 |
| 2006-07-12 11:00:00 | AAPL | Stock | 1.9411 | 1.9414 | 1.9361 | 1.9407 | 6071716.0 |
| 2006-07-12 11:05:00 | AAPL | Stock | 1.9407 | 1.9414 | 1.9361 | 1.9368 | 7074648.0 |
| 2006-07-12 11:10:00 | AAPL | Stock | 1.9361 | 1.9382 | 1.9336 | 1.9368 | 13408500.0 |
| 2006-07-12 11:15:00 | AAPL | Stock | 1.9364 | 1.9407 | 1.9361 | 1.9404 | 6349308.0 |
| 2006-07-12 11:20:00 | AAPL | Stock | 1.9407 | 1.9411 | 1.9339 | 1.9346 | 5430040.0 |
| 2006-07-12 11:25:00 | AAPL | Stock | 1.9343 | 1.9432 | 1.9332 | 1.9425 | 14351876.0 |
| 2006-07-12 11:30:00 | AAPL | Stock | 1.9425 | 1.9471 | 1.9414 | 1.945 | 9444624.0 |
| 2006-07-12 11:35:00 | AAPL | Stock | 1.9454 | 1.9493 | 1.9421 | 1.9425 | 12789812.0 |
| 2006-07-12 11:40:00 | AAPL | Stock | 1.9432 | 1.9454 | 1.9418 | 1.9436 | 9646084.0 |
| 2006-07-12 11:45:00 | AAPL | Stock | 1.9432 | 1.9454 | 1.9425 | 1.9432 | 3511452.0 |
| 2006-07-12 11:50:00 | AAPL | Stock | 1.9429 | 1.9475 | 1.9421 | 1.9463 | 5629624.0 |
| 2006-07-12 11:55:00 | AAPL | Stock | 1.9464 | 1.9464 | 1.9418 | 1.9439 | 5473832.0 |
| 2006-07-12 12:00:00 | AAPL | Stock | 1.9441 | 1.9446 | 1.94 | 1.9422 | 13169156.0 |
> showing 50 of 224,243 rows — these rows as CSV