PREVIEW / stock_1min / 2007-08-31
file: by_date/stock_1min/2007/2007-08-31.parquet size: 10.7 MB rows: 874,141 symbols: 2,551
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-08-31 09:30:00 | AAPL | Stock | 4.9821 | 4.985 | 4.9711 | 4.9761 | 17370584.0 |
| 2007-08-31 09:31:00 | AAPL | Stock | 4.9764 | 4.9764 | 4.9611 | 4.9661 | 6490540.0 |
| 2007-08-31 09:32:00 | AAPL | Stock | 4.965 | 4.9875 | 4.9641 | 4.9814 | 7245588.0 |
| 2007-08-31 09:33:00 | AAPL | Stock | 4.9789 | 4.9854 | 4.9714 | 4.9714 | 5307064.0 |
| 2007-08-31 09:34:00 | AAPL | Stock | 4.9711 | 4.975 | 4.9518 | 4.9518 | 8856596.0 |
| 2007-08-31 09:35:00 | AAPL | Stock | 4.9523 | 4.9754 | 4.9464 | 4.9668 | 8794128.0 |
| 2007-08-31 09:36:00 | AAPL | Stock | 4.9654 | 4.9732 | 4.9443 | 4.9457 | 8263192.0 |
| 2007-08-31 09:37:00 | AAPL | Stock | 4.9454 | 4.9621 | 4.9446 | 4.9607 | 6388088.0 |
| 2007-08-31 09:38:00 | AAPL | Stock | 4.9604 | 4.9643 | 4.9525 | 4.9557 | 3617264.0 |
| 2007-08-31 09:39:00 | AAPL | Stock | 4.9557 | 4.9711 | 4.9521 | 4.9671 | 5814144.0 |
| 2007-08-31 09:40:00 | AAPL | Stock | 4.9661 | 4.9661 | 4.955 | 4.96 | 4766160.0 |
| 2007-08-31 09:41:00 | AAPL | Stock | 4.96 | 4.9643 | 4.9539 | 4.9632 | 5244456.0 |
| 2007-08-31 09:42:00 | AAPL | Stock | 4.9618 | 4.9643 | 4.9571 | 4.9621 | 3714312.0 |
| 2007-08-31 09:43:00 | AAPL | Stock | 4.9621 | 4.9686 | 4.9557 | 4.9625 | 5973156.0 |
| 2007-08-31 09:44:00 | AAPL | Stock | 4.9639 | 4.9729 | 4.9611 | 4.9676 | 4122944.0 |
| 2007-08-31 09:45:00 | AAPL | Stock | 4.9679 | 4.9689 | 4.9614 | 4.9632 | 2575188.0 |
| 2007-08-31 09:46:00 | AAPL | Stock | 4.9629 | 4.9668 | 4.9579 | 4.9589 | 4672528.0 |
| 2007-08-31 09:47:00 | AAPL | Stock | 4.9579 | 4.9646 | 4.955 | 4.9571 | 5720624.0 |
| 2007-08-31 09:48:00 | AAPL | Stock | 4.9565 | 4.9579 | 4.9482 | 4.95 | 4529308.0 |
| 2007-08-31 09:49:00 | AAPL | Stock | 4.9496 | 4.9604 | 4.9496 | 4.9579 | 2987656.0 |
| 2007-08-31 09:50:00 | AAPL | Stock | 4.9575 | 4.9607 | 4.9554 | 4.9582 | 2477888.0 |
| 2007-08-31 09:51:00 | AAPL | Stock | 4.9586 | 4.9629 | 4.9582 | 4.9625 | 3226496.0 |
| 2007-08-31 09:52:00 | AAPL | Stock | 4.9621 | 4.9636 | 4.9543 | 4.9543 | 3530436.0 |
| 2007-08-31 09:53:00 | AAPL | Stock | 4.9539 | 4.9589 | 4.9539 | 4.9575 | 2310336.0 |
| 2007-08-31 09:54:00 | AAPL | Stock | 4.9557 | 4.9586 | 4.9511 | 4.9521 | 4436208.0 |
| 2007-08-31 09:55:00 | AAPL | Stock | 4.9518 | 4.9539 | 4.9432 | 4.9446 | 5285784.0 |
| 2007-08-31 09:56:00 | AAPL | Stock | 4.9446 | 4.9518 | 4.9436 | 4.9493 | 4154276.0 |
| 2007-08-31 09:57:00 | AAPL | Stock | 4.9486 | 4.9582 | 4.9482 | 4.9582 | 2845724.0 |
| 2007-08-31 09:58:00 | AAPL | Stock | 4.9582 | 4.9625 | 4.9579 | 4.9611 | 3390296.0 |
| 2007-08-31 09:59:00 | AAPL | Stock | 4.9614 | 4.9625 | 4.9571 | 4.9579 | 2916312.0 |
| 2007-08-31 10:00:00 | AAPL | Stock | 4.9582 | 4.9696 | 4.9561 | 4.9582 | 8244768.0 |
| 2007-08-31 10:01:00 | AAPL | Stock | 4.9575 | 4.9575 | 4.9429 | 4.9479 | 5380312.0 |
| 2007-08-31 10:02:00 | AAPL | Stock | 4.9486 | 4.96 | 4.9432 | 4.9439 | 5144440.0 |
| 2007-08-31 10:03:00 | AAPL | Stock | 4.9439 | 4.9521 | 4.9364 | 4.9436 | 6626256.0 |
| 2007-08-31 10:04:00 | AAPL | Stock | 4.9439 | 4.9486 | 4.9271 | 4.9275 | 9887164.0 |
| 2007-08-31 10:05:00 | AAPL | Stock | 4.9282 | 4.9439 | 4.9236 | 4.9432 | 9652412.0 |
| 2007-08-31 10:06:00 | AAPL | Stock | 4.9429 | 4.9493 | 4.9364 | 4.9429 | 5641216.0 |
| 2007-08-31 10:07:00 | AAPL | Stock | 4.9429 | 4.9496 | 4.9411 | 4.945 | 5646172.0 |
| 2007-08-31 10:08:00 | AAPL | Stock | 4.9457 | 4.9496 | 4.9375 | 4.9393 | 3817632.0 |
| 2007-08-31 10:09:00 | AAPL | Stock | 4.9396 | 4.9446 | 4.9361 | 4.9382 | 3512460.0 |
| 2007-08-31 10:10:00 | AAPL | Stock | 4.9379 | 4.9432 | 4.9364 | 4.9364 | 3183376.0 |
| 2007-08-31 10:11:00 | AAPL | Stock | 4.9364 | 4.9386 | 4.9304 | 4.9304 | 3370080.0 |
| 2007-08-31 10:12:00 | AAPL | Stock | 4.9293 | 4.9307 | 4.9179 | 4.9189 | 6840456.0 |
| 2007-08-31 10:13:00 | AAPL | Stock | 4.9186 | 4.9268 | 4.9179 | 4.9257 | 4787916.0 |
| 2007-08-31 10:14:00 | AAPL | Stock | 4.9264 | 4.9268 | 4.9186 | 4.9193 | 5392212.0 |
| 2007-08-31 10:15:00 | AAPL | Stock | 4.9186 | 4.9343 | 4.9161 | 4.9325 | 5619964.0 |
| 2007-08-31 10:16:00 | AAPL | Stock | 4.9332 | 4.9357 | 4.9229 | 4.9293 | 4382224.0 |
| 2007-08-31 10:17:00 | AAPL | Stock | 4.9289 | 4.9375 | 4.9254 | 4.9368 | 3201660.0 |
| 2007-08-31 10:18:00 | AAPL | Stock | 4.9371 | 4.9396 | 4.9286 | 4.9286 | 2315180.0 |
| 2007-08-31 10:19:00 | AAPL | Stock | 4.9286 | 4.9368 | 4.9286 | 4.9354 | 2352672.0 |
> showing 50 of 874,141 rows — these rows as CSV