PREVIEW / stock_5min / 2005-02-03
file: by_date/stock_5min/2005/2005-02-03.parquet size: 2.6 MB rows: 192,017 symbols: 1,923
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 |
|---|---|---|---|---|---|---|---|
| 2005-02-03 08:00:00 | AAPL | Stock | 1.4154 | 1.4161 | 1.4107 | 1.4125 | 245952.0 |
| 2005-02-03 08:05:00 | AAPL | Stock | 1.4111 | 1.4125 | 1.4104 | 1.4111 | 225736.0 |
| 2005-02-03 08:20:00 | AAPL | Stock | 1.4111 | 1.4125 | 1.4111 | 1.4125 | 28560.0 |
| 2005-02-03 08:25:00 | AAPL | Stock | 1.4109 | 1.4134 | 1.4109 | 1.4129 | 157864.0 |
| 2005-02-03 08:30:00 | AAPL | Stock | 1.4139 | 1.4143 | 1.4127 | 1.4127 | 39200.0 |
| 2005-02-03 08:35:00 | AAPL | Stock | 1.4125 | 1.4125 | 1.4107 | 1.4125 | 186480.0 |
| 2005-02-03 08:40:00 | AAPL | Stock | 1.4138 | 1.4138 | 1.4109 | 1.4111 | 78400.0 |
| 2005-02-03 08:45:00 | AAPL | Stock | 1.4132 | 1.4132 | 1.4109 | 1.4116 | 115360.0 |
| 2005-02-03 08:50:00 | AAPL | Stock | 1.4116 | 1.4116 | 1.4116 | 1.4116 | 16240.0 |
| 2005-02-03 08:55:00 | AAPL | Stock | 1.4116 | 1.4125 | 1.4116 | 1.4125 | 109760.0 |
| 2005-02-03 09:00:00 | AAPL | Stock | 1.4125 | 1.4125 | 1.4109 | 1.4125 | 84000.0 |
| 2005-02-03 09:05:00 | AAPL | Stock | 1.4116 | 1.4125 | 1.4111 | 1.4111 | 78400.0 |
| 2005-02-03 09:10:00 | AAPL | Stock | 1.4111 | 1.4111 | 1.4111 | 1.4111 | 11200.0 |
| 2005-02-03 09:15:00 | AAPL | Stock | 1.4125 | 1.4125 | 1.4125 | 1.4125 | 33600.0 |
| 2005-02-03 09:20:00 | AAPL | Stock | 1.412 | 1.4121 | 1.4107 | 1.4111 | 166320.0 |
| 2005-02-03 09:25:00 | AAPL | Stock | 1.4121 | 1.4148 | 1.4109 | 1.4148 | 768656.0 |
| 2005-02-03 09:30:00 | AAPL | Stock | 1.4125 | 1.4184 | 1.408 | 1.4107 | 26218304.0 |
| 2005-02-03 09:35:00 | AAPL | Stock | 1.4104 | 1.4134 | 1.4093 | 1.4098 | 21313264.0 |
| 2005-02-03 09:40:00 | AAPL | Stock | 1.41 | 1.4118 | 1.4091 | 1.4107 | 17559136.0 |
| 2005-02-03 09:45:00 | AAPL | Stock | 1.4107 | 1.4116 | 1.405 | 1.4082 | 18815160.0 |
| 2005-02-03 09:50:00 | AAPL | Stock | 1.408 | 1.4109 | 1.4063 | 1.4071 | 17090696.0 |
| 2005-02-03 09:55:00 | AAPL | Stock | 1.4073 | 1.4096 | 1.4043 | 1.4063 | 14495768.0 |
| 2005-02-03 10:00:00 | AAPL | Stock | 1.4059 | 1.4063 | 1.3957 | 1.3977 | 26873896.0 |
| 2005-02-03 10:05:00 | AAPL | Stock | 1.3975 | 1.3988 | 1.3888 | 1.3896 | 41476064.0 |
| 2005-02-03 10:10:00 | AAPL | Stock | 1.3893 | 1.3938 | 1.3886 | 1.3911 | 26249608.0 |
| 2005-02-03 10:15:00 | AAPL | Stock | 1.3913 | 1.3918 | 1.3809 | 1.3857 | 33918584.0 |
| 2005-02-03 10:20:00 | AAPL | Stock | 1.3861 | 1.3877 | 1.3845 | 1.385 | 19164992.0 |
| 2005-02-03 10:25:00 | AAPL | Stock | 1.385 | 1.3907 | 1.3829 | 1.3893 | 21218624.0 |
| 2005-02-03 10:30:00 | AAPL | Stock | 1.3895 | 1.3913 | 1.3884 | 1.3889 | 15115576.0 |
| 2005-02-03 10:35:00 | AAPL | Stock | 1.3893 | 1.3923 | 1.3884 | 1.3916 | 12502392.0 |
| 2005-02-03 10:40:00 | AAPL | Stock | 1.3916 | 1.3996 | 1.3898 | 1.3995 | 24119480.0 |
| 2005-02-03 10:45:00 | AAPL | Stock | 1.3993 | 1.4016 | 1.3963 | 1.3968 | 20233528.0 |
| 2005-02-03 10:50:00 | AAPL | Stock | 1.3968 | 1.3982 | 1.3946 | 1.3966 | 13174672.0 |
| 2005-02-03 10:55:00 | AAPL | Stock | 1.3966 | 1.3973 | 1.3898 | 1.392 | 14220416.0 |
| 2005-02-03 11:00:00 | AAPL | Stock | 1.392 | 1.3935 | 1.3898 | 1.3927 | 7980672.0 |
| 2005-02-03 11:05:00 | AAPL | Stock | 1.393 | 1.3946 | 1.3907 | 1.3943 | 8947176.0 |
| 2005-02-03 11:10:00 | AAPL | Stock | 1.3945 | 1.3946 | 1.3913 | 1.3918 | 7156632.0 |
| 2005-02-03 11:15:00 | AAPL | Stock | 1.3914 | 1.3936 | 1.3905 | 1.3927 | 5361776.0 |
| 2005-02-03 11:20:00 | AAPL | Stock | 1.3925 | 1.3938 | 1.3918 | 1.3929 | 5814088.0 |
| 2005-02-03 11:25:00 | AAPL | Stock | 1.3927 | 1.397 | 1.3927 | 1.3934 | 4077304.0 |
| 2005-02-03 11:30:00 | AAPL | Stock | 1.3932 | 1.3934 | 1.3916 | 1.3921 | 6711376.0 |
| 2005-02-03 11:35:00 | AAPL | Stock | 1.3921 | 1.3929 | 1.3913 | 1.3916 | 8572536.0 |
| 2005-02-03 11:40:00 | AAPL | Stock | 1.3916 | 1.3929 | 1.3902 | 1.3921 | 9749544.0 |
| 2005-02-03 11:45:00 | AAPL | Stock | 1.3921 | 1.3925 | 1.3905 | 1.3912 | 3744888.0 |
| 2005-02-03 11:50:00 | AAPL | Stock | 1.3914 | 1.3918 | 1.3907 | 1.3918 | 2326576.0 |
| 2005-02-03 11:55:00 | AAPL | Stock | 1.3918 | 1.3929 | 1.3911 | 1.392 | 4769912.0 |
| 2005-02-03 12:00:00 | AAPL | Stock | 1.3923 | 1.3929 | 1.3913 | 1.392 | 3716720.0 |
| 2005-02-03 12:05:00 | AAPL | Stock | 1.3918 | 1.392 | 1.3896 | 1.3902 | 5991048.0 |
| 2005-02-03 12:10:00 | AAPL | Stock | 1.3904 | 1.3905 | 1.3886 | 1.3902 | 5594344.0 |
| 2005-02-03 12:15:00 | AAPL | Stock | 1.3903 | 1.3911 | 1.3891 | 1.3907 | 3753568.0 |
> showing 50 of 192,017 rows — these rows as CSV