PREVIEW / stock_5min / 2009-02-18
file: by_date/stock_5min/2009/2009-02-18.parquet size: 4.4 MB rows: 307,774 symbols: 3,323
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-02-18 06:55:00 | AAPL | Stock | 3.3918 | 3.3918 | 3.3918 | 3.3918 | 2800.0 |
| 2009-02-18 07:40:00 | AAPL | Stock | 3.3893 | 3.3893 | 3.3893 | 3.3893 | 56000.0 |
| 2009-02-18 08:00:00 | AAPL | Stock | 3.3839 | 3.3839 | 3.3829 | 3.3829 | 19040.0 |
| 2009-02-18 08:05:00 | AAPL | Stock | 3.3829 | 3.3829 | 3.375 | 3.375 | 84000.0 |
| 2009-02-18 08:10:00 | AAPL | Stock | 3.3875 | 3.3875 | 3.3875 | 3.3875 | 5600.0 |
| 2009-02-18 08:30:00 | AAPL | Stock | 3.3875 | 3.3893 | 3.3818 | 3.3818 | 37800.0 |
| 2009-02-18 08:35:00 | AAPL | Stock | 3.3871 | 3.3871 | 3.3871 | 3.3871 | 8400.0 |
| 2009-02-18 08:40:00 | AAPL | Stock | 3.3871 | 3.3982 | 3.3871 | 3.3964 | 184436.0 |
| 2009-02-18 08:45:00 | AAPL | Stock | 3.3964 | 3.3982 | 3.3929 | 3.3982 | 79100.0 |
| 2009-02-18 08:50:00 | AAPL | Stock | 3.4029 | 3.4046 | 3.4029 | 3.4029 | 77000.0 |
| 2009-02-18 08:55:00 | AAPL | Stock | 3.3982 | 3.3982 | 3.3982 | 3.3982 | 54880.0 |
| 2009-02-18 09:00:00 | AAPL | Stock | 3.4029 | 3.4061 | 3.4029 | 3.4061 | 49700.0 |
| 2009-02-18 09:05:00 | AAPL | Stock | 3.4061 | 3.4079 | 3.4054 | 3.4079 | 132608.0 |
| 2009-02-18 09:10:00 | AAPL | Stock | 3.4093 | 3.4114 | 3.4021 | 3.4021 | 441588.0 |
| 2009-02-18 09:15:00 | AAPL | Stock | 3.4061 | 3.4061 | 3.4036 | 3.4036 | 35000.0 |
| 2009-02-18 09:20:00 | AAPL | Stock | 3.3968 | 3.3982 | 3.3925 | 3.3929 | 291816.0 |
| 2009-02-18 09:25:00 | AAPL | Stock | 3.3929 | 3.4011 | 3.3929 | 3.4011 | 15400.0 |
| 2009-02-18 09:30:00 | AAPL | Stock | 3.3946 | 3.4107 | 3.3786 | 3.4082 | 12845084.0 |
| 2009-02-18 09:35:00 | AAPL | Stock | 3.4086 | 3.4107 | 3.3929 | 3.3982 | 14422044.0 |
| 2009-02-18 09:40:00 | AAPL | Stock | 3.3979 | 3.4111 | 3.3964 | 3.4107 | 11803512.0 |
| 2009-02-18 09:45:00 | AAPL | Stock | 3.4107 | 3.4154 | 3.3989 | 3.4029 | 10360364.0 |
| 2009-02-18 09:50:00 | AAPL | Stock | 3.4032 | 3.4071 | 3.3964 | 3.4 | 9904384.0 |
| 2009-02-18 09:55:00 | AAPL | Stock | 3.4002 | 3.405 | 3.3893 | 3.3954 | 11672360.0 |
| 2009-02-18 10:00:00 | AAPL | Stock | 3.3954 | 3.3989 | 3.3757 | 3.3807 | 13671420.0 |
| 2009-02-18 10:05:00 | AAPL | Stock | 3.3807 | 3.3832 | 3.3468 | 3.3468 | 21839048.0 |
| 2009-02-18 10:10:00 | AAPL | Stock | 3.3468 | 3.365 | 3.3114 | 3.3421 | 34140736.0 |
| 2009-02-18 10:15:00 | AAPL | Stock | 3.3404 | 3.3564 | 3.3364 | 3.35 | 12499872.0 |
| 2009-02-18 10:20:00 | AAPL | Stock | 3.3508 | 3.3739 | 3.35 | 3.3704 | 12401620.0 |
| 2009-02-18 10:25:00 | AAPL | Stock | 3.3707 | 3.3804 | 3.3686 | 3.3754 | 11406332.0 |
| 2009-02-18 10:30:00 | AAPL | Stock | 3.3754 | 3.3921 | 3.375 | 3.3921 | 12567688.0 |
| 2009-02-18 10:35:00 | AAPL | Stock | 3.3921 | 3.3929 | 3.3814 | 3.3814 | 8089984.0 |
| 2009-02-18 10:40:00 | AAPL | Stock | 3.3814 | 3.3946 | 3.3796 | 3.3829 | 8992592.0 |
| 2009-02-18 10:45:00 | AAPL | Stock | 3.3835 | 3.3929 | 3.3729 | 3.38 | 9954924.0 |
| 2009-02-18 10:50:00 | AAPL | Stock | 3.3796 | 3.385 | 3.3721 | 3.3804 | 5731852.0 |
| 2009-02-18 10:55:00 | AAPL | Stock | 3.3804 | 3.3857 | 3.3739 | 3.3804 | 7982744.0 |
| 2009-02-18 11:00:00 | AAPL | Stock | 3.3804 | 3.3832 | 3.3739 | 3.3789 | 6359276.0 |
| 2009-02-18 11:05:00 | AAPL | Stock | 3.3789 | 3.3886 | 3.3764 | 3.3854 | 6354796.0 |
| 2009-02-18 11:10:00 | AAPL | Stock | 3.385 | 3.3946 | 3.3832 | 3.3904 | 7178248.0 |
| 2009-02-18 11:15:00 | AAPL | Stock | 3.3907 | 3.405 | 3.3907 | 3.4018 | 9175432.0 |
| 2009-02-18 11:20:00 | AAPL | Stock | 3.4004 | 3.4136 | 3.3996 | 3.4121 | 11786068.0 |
| 2009-02-18 11:25:00 | AAPL | Stock | 3.4121 | 3.4143 | 3.4057 | 3.4061 | 6930448.0 |
| 2009-02-18 11:30:00 | AAPL | Stock | 3.4057 | 3.4086 | 3.3982 | 3.4071 | 6722632.0 |
| 2009-02-18 11:35:00 | AAPL | Stock | 3.4075 | 3.4089 | 3.4025 | 3.4086 | 4649848.0 |
| 2009-02-18 11:40:00 | AAPL | Stock | 3.4079 | 3.4139 | 3.4011 | 3.4118 | 7492380.0 |
| 2009-02-18 11:45:00 | AAPL | Stock | 3.4116 | 3.4132 | 3.4032 | 3.4037 | 4805892.0 |
| 2009-02-18 11:50:00 | AAPL | Stock | 3.4039 | 3.4081 | 3.3993 | 3.4046 | 4114236.0 |
| 2009-02-18 11:55:00 | AAPL | Stock | 3.4043 | 3.4111 | 3.4029 | 3.4057 | 4167072.0 |
| 2009-02-18 12:00:00 | AAPL | Stock | 3.4054 | 3.4139 | 3.4025 | 3.4114 | 7337204.0 |
| 2009-02-18 12:05:00 | AAPL | Stock | 3.4114 | 3.4232 | 3.4089 | 3.42 | 7352940.0 |
| 2009-02-18 12:10:00 | AAPL | Stock | 3.4207 | 3.4221 | 3.4129 | 3.4136 | 6235824.0 |
> showing 50 of 307,774 rows — these rows as CSV