PREVIEW / stock_1min / 2005-06-23
file: by_date/stock_1min/2005/2005-06-23.parquet size: 6.9 MB rows: 570,908 symbols: 1,630
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:27:00 | AAPL | Stock | 1.3857 | 1.3857 | 1.3857 | 1.3857 | 28000.0 |
| 2005-06-23 07:46:00 | AAPL | Stock | 1.3857 | 1.3857 | 1.3857 | 1.3857 | 11200.0 |
| 2005-06-23 08:01:00 | AAPL | Stock | 1.3839 | 1.3839 | 1.3839 | 1.3839 | 116760.0 |
| 2005-06-23 08:02:00 | AAPL | Stock | 1.3839 | 1.3839 | 1.3839 | 1.3839 | 37576.0 |
| 2005-06-23 08:03:00 | AAPL | Stock | 1.3839 | 1.3839 | 1.3839 | 1.3839 | 17780.0 |
| 2005-06-23 08:07:00 | AAPL | Stock | 1.3821 | 1.3821 | 1.3821 | 1.3821 | 11200.0 |
| 2005-06-23 08:08:00 | AAPL | Stock | 1.3843 | 1.3843 | 1.3843 | 1.3843 | 8400.0 |
| 2005-06-23 08:10:00 | AAPL | Stock | 1.3843 | 1.3854 | 1.3843 | 1.3854 | 314244.0 |
| 2005-06-23 08:11:00 | AAPL | Stock | 1.3854 | 1.3868 | 1.3854 | 1.3868 | 46956.0 |
| 2005-06-23 08:12:00 | AAPL | Stock | 1.3875 | 1.3875 | 1.3875 | 1.3875 | 9856.0 |
| 2005-06-23 08:15:00 | AAPL | Stock | 1.3879 | 1.3893 | 1.3879 | 1.3893 | 69300.0 |
| 2005-06-23 08:16:00 | AAPL | Stock | 1.3907 | 1.3911 | 1.3907 | 1.3907 | 40600.0 |
| 2005-06-23 08:17:00 | AAPL | Stock | 1.3921 | 1.3921 | 1.3918 | 1.3918 | 78400.0 |
| 2005-06-23 08:19:00 | AAPL | Stock | 1.3911 | 1.3911 | 1.3911 | 1.3911 | 30800.0 |
| 2005-06-23 08:22:00 | AAPL | Stock | 1.3875 | 1.3875 | 1.3875 | 1.3875 | 28000.0 |
| 2005-06-23 08:24:00 | AAPL | Stock | 1.3875 | 1.3875 | 1.3875 | 1.3875 | 67200.0 |
| 2005-06-23 08:25:00 | AAPL | Stock | 1.3875 | 1.3911 | 1.3871 | 1.3911 | 129080.0 |
| 2005-06-23 08:27:00 | AAPL | Stock | 1.3911 | 1.3911 | 1.3911 | 1.3911 | 28000.0 |
| 2005-06-23 08:28:00 | AAPL | Stock | 1.3911 | 1.3911 | 1.3911 | 1.3911 | 14000.0 |
| 2005-06-23 08:29:00 | AAPL | Stock | 1.3875 | 1.3875 | 1.3871 | 1.3871 | 14000.0 |
| 2005-06-23 08:30:00 | AAPL | Stock | 1.3896 | 1.39 | 1.3896 | 1.39 | 8400.0 |
| 2005-06-23 08:31:00 | AAPL | Stock | 1.3907 | 1.3907 | 1.3907 | 1.3907 | 2800.0 |
| 2005-06-23 08:32:00 | AAPL | Stock | 1.3914 | 1.3946 | 1.3914 | 1.3946 | 105000.0 |
| 2005-06-23 08:33:00 | AAPL | Stock | 1.3932 | 1.3946 | 1.3932 | 1.3946 | 61600.0 |
| 2005-06-23 08:34:00 | AAPL | Stock | 1.3939 | 1.3939 | 1.3932 | 1.3932 | 50400.0 |
| 2005-06-23 08:35:00 | AAPL | Stock | 1.3929 | 1.3929 | 1.3929 | 1.3929 | 58800.0 |
| 2005-06-23 08:36:00 | AAPL | Stock | 1.3896 | 1.3896 | 1.3896 | 1.3896 | 28000.0 |
| 2005-06-23 08:40:00 | AAPL | Stock | 1.3918 | 1.3932 | 1.3918 | 1.3925 | 93660.0 |
| 2005-06-23 08:41:00 | AAPL | Stock | 1.3929 | 1.3929 | 1.3925 | 1.3925 | 14000.0 |
| 2005-06-23 08:42:00 | AAPL | Stock | 1.3925 | 1.3925 | 1.3925 | 1.3925 | 8400.0 |
| 2005-06-23 08:43:00 | AAPL | Stock | 1.3925 | 1.3925 | 1.3925 | 1.3925 | 5600.0 |
| 2005-06-23 08:44:00 | AAPL | Stock | 1.3925 | 1.3929 | 1.3925 | 1.3929 | 14000.0 |
| 2005-06-23 08:45:00 | AAPL | Stock | 1.3929 | 1.3929 | 1.3925 | 1.3929 | 63000.0 |
| 2005-06-23 08:46:00 | AAPL | Stock | 1.3929 | 1.3929 | 1.3921 | 1.3921 | 64400.0 |
| 2005-06-23 08:47:00 | AAPL | Stock | 1.3921 | 1.3925 | 1.3911 | 1.3911 | 33600.0 |
| 2005-06-23 08:48:00 | AAPL | Stock | 1.3911 | 1.3911 | 1.3911 | 1.3911 | 11200.0 |
| 2005-06-23 08:50:00 | AAPL | Stock | 1.3896 | 1.3896 | 1.3893 | 1.3893 | 28000.0 |
| 2005-06-23 08:51:00 | AAPL | Stock | 1.3893 | 1.3893 | 1.3893 | 1.3893 | 11200.0 |
| 2005-06-23 08:53:00 | AAPL | Stock | 1.3893 | 1.3893 | 1.3893 | 1.3893 | 19600.0 |
| 2005-06-23 08:55:00 | AAPL | Stock | 1.3889 | 1.3889 | 1.3889 | 1.3889 | 2800.0 |
| 2005-06-23 08:57:00 | AAPL | Stock | 1.3893 | 1.3893 | 1.3893 | 1.3893 | 2800.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.3893 | 1.3893 | 1.3893 | 5600.0 |
| 2005-06-23 09:07:00 | AAPL | Stock | 1.3896 | 1.3896 | 1.3889 | 1.3889 | 30800.0 |
| 2005-06-23 09:09:00 | AAPL | Stock | 1.3879 | 1.3879 | 1.3879 | 1.3879 | 28000.0 |
| 2005-06-23 09:10:00 | AAPL | Stock | 1.3889 | 1.3893 | 1.3879 | 1.3879 | 75460.0 |
| 2005-06-23 09:12:00 | AAPL | Stock | 1.3882 | 1.3882 | 1.3882 | 1.3882 | 5600.0 |
| 2005-06-23 09:13:00 | AAPL | Stock | 1.3889 | 1.3889 | 1.3889 | 1.3889 | 5600.0 |
| 2005-06-23 09:14:00 | AAPL | Stock | 1.3882 | 1.3911 | 1.3879 | 1.3911 | 36400.0 |
> showing 50 of 570,908 rows — these rows as CSV