PREVIEW / stock_5min / 2009-05-22
file: by_date/stock_5min/2009/2009-05-22.parquet size: 4.4 MB rows: 307,584 symbols: 3,321
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 |
|---|---|---|---|---|---|---|---|
| 2009-05-22 04:15:00 | AAPL | Stock | 4.4496 | 4.4496 | 4.4496 | 4.4496 | 2800.0 |
| 2009-05-22 04:20:00 | AAPL | Stock | 4.4529 | 4.4529 | 4.4529 | 4.4529 | 2800.0 |
| 2009-05-22 06:20:00 | AAPL | Stock | 4.4768 | 4.4768 | 4.4768 | 4.4768 | 2800.0 |
| 2009-05-22 06:30:00 | AAPL | Stock | 4.4821 | 4.4871 | 4.4821 | 4.4871 | 5600.0 |
| 2009-05-22 07:00:00 | AAPL | Stock | 4.4714 | 4.4714 | 4.4714 | 4.4714 | 31164.0 |
| 2009-05-22 07:05:00 | AAPL | Stock | 4.4286 | 4.4732 | 4.4286 | 4.4732 | 8400.0 |
| 2009-05-22 07:20:00 | AAPL | Stock | 4.4464 | 4.4464 | 4.4464 | 4.4464 | 2800.0 |
| 2009-05-22 07:25:00 | AAPL | Stock | 4.4321 | 4.4321 | 4.4321 | 4.4321 | 2800.0 |
| 2009-05-22 07:30:00 | AAPL | Stock | 4.4464 | 4.4464 | 4.4464 | 4.4464 | 11200.0 |
| 2009-05-22 07:35:00 | AAPL | Stock | 4.4536 | 4.4536 | 4.4536 | 4.4536 | 8876.0 |
| 2009-05-22 07:40:00 | AAPL | Stock | 4.4571 | 4.4571 | 4.4571 | 4.4571 | 2800.0 |
| 2009-05-22 08:00:00 | AAPL | Stock | 4.4525 | 4.4525 | 4.4482 | 4.4482 | 38192.0 |
| 2009-05-22 08:05:00 | AAPL | Stock | 4.4482 | 4.4543 | 4.4464 | 4.4464 | 237720.0 |
| 2009-05-22 08:10:00 | AAPL | Stock | 4.45 | 4.45 | 4.45 | 4.45 | 8400.0 |
| 2009-05-22 08:15:00 | AAPL | Stock | 4.45 | 4.45 | 4.4496 | 4.45 | 73500.0 |
| 2009-05-22 08:20:00 | AAPL | Stock | 4.4471 | 4.45 | 4.4464 | 4.45 | 33040.0 |
| 2009-05-22 08:25:00 | AAPL | Stock | 4.4482 | 4.4496 | 4.4464 | 4.4496 | 21700.0 |
| 2009-05-22 08:30:00 | AAPL | Stock | 4.4486 | 4.4486 | 4.4486 | 4.4486 | 2800.0 |
| 2009-05-22 08:35:00 | AAPL | Stock | 4.4486 | 4.45 | 4.4486 | 4.45 | 39312.0 |
| 2009-05-22 08:40:00 | AAPL | Stock | 4.4482 | 4.4482 | 4.4464 | 4.4464 | 11900.0 |
| 2009-05-22 08:45:00 | AAPL | Stock | 4.4496 | 4.4536 | 4.4496 | 4.4504 | 117628.0 |
| 2009-05-22 08:50:00 | AAPL | Stock | 4.4511 | 4.4511 | 4.4511 | 4.4511 | 34440.0 |
| 2009-05-22 08:55:00 | AAPL | Stock | 4.4518 | 4.4536 | 4.4518 | 4.4536 | 13860.0 |
| 2009-05-22 09:00:00 | AAPL | Stock | 4.4539 | 4.4539 | 4.4511 | 4.4511 | 53620.0 |
| 2009-05-22 09:05:00 | AAPL | Stock | 4.4518 | 4.4518 | 4.4518 | 4.4518 | 16800.0 |
| 2009-05-22 09:10:00 | AAPL | Stock | 4.4475 | 4.4482 | 4.4464 | 4.4464 | 118328.0 |
| 2009-05-22 09:15:00 | AAPL | Stock | 4.4464 | 4.4464 | 4.4461 | 4.4461 | 34664.0 |
| 2009-05-22 09:20:00 | AAPL | Stock | 4.4475 | 4.4475 | 4.4443 | 4.4443 | 91728.0 |
| 2009-05-22 09:25:00 | AAPL | Stock | 4.4468 | 4.4468 | 4.4289 | 4.4307 | 97272.0 |
| 2009-05-22 09:30:00 | AAPL | Stock | 4.4311 | 4.4343 | 4.375 | 4.3799 | 13673324.0 |
| 2009-05-22 09:35:00 | AAPL | Stock | 4.3768 | 4.3929 | 4.3611 | 4.3632 | 13177332.0 |
| 2009-05-22 09:40:00 | AAPL | Stock | 4.3632 | 4.3764 | 4.3571 | 4.365 | 11203108.0 |
| 2009-05-22 09:45:00 | AAPL | Stock | 4.365 | 4.3679 | 4.3482 | 4.3664 | 10623424.0 |
| 2009-05-22 09:50:00 | AAPL | Stock | 4.3664 | 4.3814 | 4.3632 | 4.38 | 8349236.0 |
| 2009-05-22 09:55:00 | AAPL | Stock | 4.3796 | 4.3875 | 4.3754 | 4.3846 | 5529356.0 |
| 2009-05-22 10:00:00 | AAPL | Stock | 4.3846 | 4.3846 | 4.3643 | 4.3736 | 5557048.0 |
| 2009-05-22 10:05:00 | AAPL | Stock | 4.3756 | 4.3871 | 4.3682 | 4.3707 | 7082292.0 |
| 2009-05-22 10:10:00 | AAPL | Stock | 4.3707 | 4.3779 | 4.3646 | 4.3718 | 5915476.0 |
| 2009-05-22 10:15:00 | AAPL | Stock | 4.3711 | 4.4036 | 4.3686 | 4.3914 | 9374596.0 |
| 2009-05-22 10:20:00 | AAPL | Stock | 4.3911 | 4.4046 | 4.3846 | 4.3887 | 7851956.0 |
| 2009-05-22 10:25:00 | AAPL | Stock | 4.3886 | 4.4107 | 4.3882 | 4.3993 | 7181020.0 |
| 2009-05-22 10:30:00 | AAPL | Stock | 4.4002 | 4.4025 | 4.3868 | 4.3898 | 3637564.0 |
| 2009-05-22 10:35:00 | AAPL | Stock | 4.3896 | 4.3929 | 4.3825 | 4.3843 | 3330908.0 |
| 2009-05-22 10:40:00 | AAPL | Stock | 4.3854 | 4.4 | 4.38 | 4.3985 | 4367020.0 |
| 2009-05-22 10:45:00 | AAPL | Stock | 4.3979 | 4.4 | 4.3911 | 4.3952 | 2459268.0 |
| 2009-05-22 10:50:00 | AAPL | Stock | 4.3939 | 4.4004 | 4.3929 | 4.395 | 2276428.0 |
| 2009-05-22 10:55:00 | AAPL | Stock | 4.395 | 4.4007 | 4.3939 | 4.3967 | 2471784.0 |
| 2009-05-22 11:00:00 | AAPL | Stock | 4.3968 | 4.4054 | 4.3968 | 4.4016 | 5060888.0 |
| 2009-05-22 11:05:00 | AAPL | Stock | 4.4014 | 4.4071 | 4.4 | 4.405 | 1710884.0 |
| 2009-05-22 11:10:00 | AAPL | Stock | 4.4054 | 4.4118 | 4.4032 | 4.4093 | 2397892.0 |
> showing 50 of 307,584 rows — these rows as CSV