PREVIEW / stock_5min / 2005-06-23
file: by_date/stock_5min/2005/2005-06-23.parquet size: 2.7 MB rows: 197,986 symbols: 1,988
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-06-23 07:10:00 | AAPL | Stock | 1.3786 | 1.3786 | 1.3786 | 1.3786 | 28000.0 |
| 2005-06-23 07:25:00 | AAPL | Stock | 1.3857 | 1.3857 | 1.3857 | 1.3857 | 28000.0 |
| 2005-06-23 07:45:00 | AAPL | Stock | 1.3857 | 1.3857 | 1.3857 | 1.3857 | 11200.0 |
| 2005-06-23 08:00:00 | AAPL | Stock | 1.3839 | 1.3839 | 1.3839 | 1.3839 | 172116.0 |
| 2005-06-23 08:05:00 | AAPL | Stock | 1.3821 | 1.3843 | 1.3821 | 1.3843 | 19600.0 |
| 2005-06-23 08:10:00 | AAPL | Stock | 1.3843 | 1.3875 | 1.3843 | 1.3875 | 371056.0 |
| 2005-06-23 08:15:00 | AAPL | Stock | 1.3879 | 1.3921 | 1.3879 | 1.3911 | 219100.0 |
| 2005-06-23 08:20:00 | AAPL | Stock | 1.3875 | 1.3875 | 1.3875 | 1.3875 | 95200.0 |
| 2005-06-23 08:25:00 | AAPL | Stock | 1.3875 | 1.3911 | 1.3871 | 1.3871 | 185080.0 |
| 2005-06-23 08:30:00 | AAPL | Stock | 1.3896 | 1.3946 | 1.3896 | 1.3932 | 228200.0 |
| 2005-06-23 08:35:00 | AAPL | Stock | 1.3929 | 1.3929 | 1.3896 | 1.3896 | 86800.0 |
| 2005-06-23 08:40:00 | AAPL | Stock | 1.3918 | 1.3932 | 1.3918 | 1.3929 | 135660.0 |
| 2005-06-23 08:45:00 | AAPL | Stock | 1.3929 | 1.3929 | 1.3911 | 1.3911 | 172200.0 |
| 2005-06-23 08:50:00 | AAPL | Stock | 1.3896 | 1.3896 | 1.3893 | 1.3893 | 58800.0 |
| 2005-06-23 08:55:00 | AAPL | Stock | 1.3889 | 1.3893 | 1.3889 | 1.3893 | 5600.0 |
| 2005-06-23 09:00:00 | AAPL | Stock | 1.3893 | 1.3893 | 1.3893 | 1.3893 | 5600.0 |
| 2005-06-23 09:05:00 | AAPL | Stock | 1.3893 | 1.3896 | 1.3879 | 1.3879 | 64400.0 |
| 2005-06-23 09:10:00 | AAPL | Stock | 1.3889 | 1.3911 | 1.3879 | 1.3911 | 123060.0 |
| 2005-06-23 09:15:00 | AAPL | Stock | 1.3896 | 1.3896 | 1.3896 | 1.3896 | 5600.0 |
| 2005-06-23 09:25:00 | AAPL | Stock | 1.3857 | 1.3907 | 1.3829 | 1.3882 | 638176.0 |
| 2005-06-23 09:30:00 | AAPL | Stock | 1.3868 | 1.3943 | 1.385 | 1.3925 | 19020960.0 |
| 2005-06-23 09:35:00 | AAPL | Stock | 1.3925 | 1.3929 | 1.3879 | 1.3929 | 12656028.0 |
| 2005-06-23 09:40:00 | AAPL | Stock | 1.3929 | 1.3993 | 1.3921 | 1.3936 | 21426412.0 |
| 2005-06-23 09:45:00 | AAPL | Stock | 1.3936 | 1.4025 | 1.3929 | 1.4007 | 20263404.0 |
| 2005-06-23 09:50:00 | AAPL | Stock | 1.4014 | 1.4025 | 1.3961 | 1.4004 | 12165440.0 |
| 2005-06-23 09:55:00 | AAPL | Stock | 1.4004 | 1.4018 | 1.3982 | 1.3996 | 9820384.0 |
| 2005-06-23 10:00:00 | AAPL | Stock | 1.3993 | 1.4011 | 1.3921 | 1.3929 | 14093184.0 |
| 2005-06-23 10:05:00 | AAPL | Stock | 1.3925 | 1.3968 | 1.3907 | 1.3911 | 10330880.0 |
| 2005-06-23 10:10:00 | AAPL | Stock | 1.3911 | 1.3929 | 1.3871 | 1.3882 | 10922044.0 |
| 2005-06-23 10:15:00 | AAPL | Stock | 1.3882 | 1.3925 | 1.3879 | 1.3896 | 8080632.0 |
| 2005-06-23 10:20:00 | AAPL | Stock | 1.3896 | 1.3918 | 1.3875 | 1.3904 | 6265280.0 |
| 2005-06-23 10:25:00 | AAPL | Stock | 1.3904 | 1.3918 | 1.3875 | 1.3879 | 5805576.0 |
| 2005-06-23 10:30:00 | AAPL | Stock | 1.3875 | 1.3914 | 1.3871 | 1.3904 | 6479900.0 |
| 2005-06-23 10:35:00 | AAPL | Stock | 1.3907 | 1.3936 | 1.3879 | 1.3932 | 5923708.0 |
| 2005-06-23 10:40:00 | AAPL | Stock | 1.3932 | 1.3946 | 1.3911 | 1.3929 | 5048288.0 |
| 2005-06-23 10:45:00 | AAPL | Stock | 1.3932 | 1.395 | 1.3911 | 1.3914 | 3960096.0 |
| 2005-06-23 10:50:00 | AAPL | Stock | 1.3914 | 1.3925 | 1.3893 | 1.3925 | 2561692.0 |
| 2005-06-23 10:55:00 | AAPL | Stock | 1.3929 | 1.395 | 1.3921 | 1.3939 | 5935524.0 |
| 2005-06-23 11:00:00 | AAPL | Stock | 1.3936 | 1.3968 | 1.3929 | 1.3943 | 3939964.0 |
| 2005-06-23 11:05:00 | AAPL | Stock | 1.3943 | 1.3968 | 1.3933 | 1.3968 | 4223352.0 |
| 2005-06-23 11:10:00 | AAPL | Stock | 1.3964 | 1.3968 | 1.3936 | 1.3961 | 6449660.0 |
| 2005-06-23 11:15:00 | AAPL | Stock | 1.3961 | 1.4 | 1.3946 | 1.3979 | 10917928.0 |
| 2005-06-23 11:20:00 | AAPL | Stock | 1.3979 | 1.4057 | 1.3975 | 1.4046 | 11259668.0 |
| 2005-06-23 11:25:00 | AAPL | Stock | 1.4046 | 1.4061 | 1.4025 | 1.405 | 10675588.0 |
| 2005-06-23 11:30:00 | AAPL | Stock | 1.4043 | 1.4086 | 1.4039 | 1.4064 | 8331764.0 |
| 2005-06-23 11:35:00 | AAPL | Stock | 1.4064 | 1.4114 | 1.405 | 1.4111 | 10322144.0 |
| 2005-06-23 11:40:00 | AAPL | Stock | 1.4111 | 1.4114 | 1.4082 | 1.4089 | 6921964.0 |
| 2005-06-23 11:45:00 | AAPL | Stock | 1.4089 | 1.4161 | 1.4086 | 1.4154 | 9661904.0 |
| 2005-06-23 11:50:00 | AAPL | Stock | 1.4157 | 1.4207 | 1.4146 | 1.415 | 15130976.0 |
| 2005-06-23 11:55:00 | AAPL | Stock | 1.4146 | 1.4161 | 1.4129 | 1.4132 | 8906268.0 |
> showing 50 of 197,986 rows — these rows as CSV