PREVIEW / stock_1min / 2008-05-22
file: by_date/stock_1min/2008/2008-05-22.parquet size: 12.3 MB rows: 999,165 symbols: 2,687
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 |
|---|---|---|---|---|---|---|---|
| 2008-05-22 04:30:00 | AAPL | Stock | 6.3571 | 6.3571 | 6.3571 | 6.3571 | 2800.0 |
| 2008-05-22 04:37:00 | AAPL | Stock | 6.3564 | 6.3564 | 6.3564 | 6.3564 | 2800.0 |
| 2008-05-22 04:53:00 | AAPL | Stock | 6.3586 | 6.3586 | 6.3586 | 6.3586 | 5600.0 |
| 2008-05-22 06:56:00 | AAPL | Stock | 6.3668 | 6.3668 | 6.3668 | 6.3668 | 5600.0 |
| 2008-05-22 06:58:00 | AAPL | Stock | 6.3675 | 6.3675 | 6.3675 | 6.3675 | 41300.0 |
| 2008-05-22 06:59:00 | AAPL | Stock | 6.37 | 6.37 | 6.37 | 6.37 | 8400.0 |
| 2008-05-22 07:00:00 | AAPL | Stock | 6.3768 | 6.3768 | 6.3768 | 6.3768 | 16240.0 |
| 2008-05-22 07:01:00 | AAPL | Stock | 6.3889 | 6.3893 | 6.3889 | 6.3893 | 28000.0 |
| 2008-05-22 07:04:00 | AAPL | Stock | 6.3757 | 6.3757 | 6.3757 | 6.3757 | 8400.0 |
| 2008-05-22 07:07:00 | AAPL | Stock | 6.3929 | 6.3929 | 6.3929 | 6.3929 | 8400.0 |
| 2008-05-22 07:14:00 | AAPL | Stock | 6.3836 | 6.3836 | 6.3836 | 6.3836 | 2800.0 |
| 2008-05-22 07:15:00 | AAPL | Stock | 6.3857 | 6.3857 | 6.3857 | 6.3857 | 4480.0 |
| 2008-05-22 07:17:00 | AAPL | Stock | 6.3857 | 6.3857 | 6.3857 | 6.3857 | 14000.0 |
| 2008-05-22 07:18:00 | AAPL | Stock | 6.3857 | 6.3857 | 6.3857 | 6.3857 | 13664.0 |
| 2008-05-22 07:23:00 | AAPL | Stock | 6.3818 | 6.3818 | 6.3818 | 6.3818 | 2800.0 |
| 2008-05-22 07:25:00 | AAPL | Stock | 6.3707 | 6.3707 | 6.3707 | 6.3707 | 2800.0 |
| 2008-05-22 07:26:00 | AAPL | Stock | 6.3786 | 6.3786 | 6.3786 | 6.3786 | 5600.0 |
| 2008-05-22 07:29:00 | AAPL | Stock | 6.3854 | 6.3875 | 6.3854 | 6.3875 | 17080.0 |
| 2008-05-22 07:30:00 | AAPL | Stock | 6.3911 | 6.3996 | 6.3911 | 6.3996 | 93800.0 |
| 2008-05-22 07:31:00 | AAPL | Stock | 6.4089 | 6.4125 | 6.4089 | 6.4107 | 25200.0 |
| 2008-05-22 07:32:00 | AAPL | Stock | 6.4107 | 6.4107 | 6.3982 | 6.3982 | 36120.0 |
| 2008-05-22 07:33:00 | AAPL | Stock | 6.4018 | 6.4018 | 6.4018 | 6.4018 | 28000.0 |
| 2008-05-22 07:34:00 | AAPL | Stock | 6.3982 | 6.3982 | 6.3982 | 6.3982 | 4480.0 |
| 2008-05-22 07:35:00 | AAPL | Stock | 6.3982 | 6.3982 | 6.3982 | 6.3982 | 14000.0 |
| 2008-05-22 07:36:00 | AAPL | Stock | 6.4 | 6.4 | 6.4 | 6.4 | 18480.0 |
| 2008-05-22 07:37:00 | AAPL | Stock | 6.4018 | 6.4018 | 6.4018 | 6.4018 | 25200.0 |
| 2008-05-22 07:38:00 | AAPL | Stock | 6.3989 | 6.3989 | 6.3982 | 6.3982 | 15400.0 |
| 2008-05-22 07:39:00 | AAPL | Stock | 6.3946 | 6.3982 | 6.3943 | 6.3982 | 33040.0 |
| 2008-05-22 07:40:00 | AAPL | Stock | 6.3982 | 6.3982 | 6.3982 | 6.3982 | 3500.0 |
| 2008-05-22 07:41:00 | AAPL | Stock | 6.3996 | 6.3996 | 6.3996 | 6.3996 | 36176.0 |
| 2008-05-22 07:42:00 | AAPL | Stock | 6.4014 | 6.4014 | 6.3982 | 6.3982 | 29260.0 |
| 2008-05-22 07:43:00 | AAPL | Stock | 6.3982 | 6.3982 | 6.3982 | 6.3982 | 14000.0 |
| 2008-05-22 07:47:00 | AAPL | Stock | 6.3964 | 6.3964 | 6.3718 | 6.3854 | 63868.0 |
| 2008-05-22 07:48:00 | AAPL | Stock | 6.3893 | 6.3893 | 6.3893 | 6.3893 | 5600.0 |
| 2008-05-22 07:49:00 | AAPL | Stock | 6.3896 | 6.3896 | 6.3896 | 6.3896 | 2800.0 |
| 2008-05-22 07:50:00 | AAPL | Stock | 6.3893 | 6.3893 | 6.3832 | 6.3836 | 61600.0 |
| 2008-05-22 07:51:00 | AAPL | Stock | 6.3821 | 6.3839 | 6.3821 | 6.3839 | 14000.0 |
| 2008-05-22 07:52:00 | AAPL | Stock | 6.3854 | 6.3854 | 6.3854 | 6.3854 | 2800.0 |
| 2008-05-22 07:53:00 | AAPL | Stock | 6.3843 | 6.3843 | 6.3843 | 6.3843 | 5600.0 |
| 2008-05-22 07:54:00 | AAPL | Stock | 6.3875 | 6.3879 | 6.3843 | 6.3879 | 22400.0 |
| 2008-05-22 07:55:00 | AAPL | Stock | 6.3893 | 6.3893 | 6.3893 | 6.3893 | 14000.0 |
| 2008-05-22 07:58:00 | AAPL | Stock | 6.3896 | 6.3896 | 6.3875 | 6.3875 | 47600.0 |
| 2008-05-22 07:59:00 | AAPL | Stock | 6.3843 | 6.3843 | 6.3843 | 6.3843 | 2800.0 |
| 2008-05-22 08:00:00 | AAPL | Stock | 6.3886 | 6.4014 | 6.3871 | 6.395 | 317688.0 |
| 2008-05-22 08:01:00 | AAPL | Stock | 6.3979 | 6.405 | 6.3975 | 6.405 | 148400.0 |
| 2008-05-22 08:02:00 | AAPL | Stock | 6.405 | 6.4061 | 6.4036 | 6.4054 | 116200.0 |
| 2008-05-22 08:03:00 | AAPL | Stock | 6.4036 | 6.4036 | 6.4018 | 6.4036 | 196000.0 |
| 2008-05-22 08:04:00 | AAPL | Stock | 6.4018 | 6.4018 | 6.3993 | 6.4018 | 219380.0 |
| 2008-05-22 08:05:00 | AAPL | Stock | 6.4046 | 6.405 | 6.4018 | 6.405 | 92400.0 |
| 2008-05-22 08:06:00 | AAPL | Stock | 6.4046 | 6.4089 | 6.4039 | 6.4071 | 135100.0 |
> showing 50 of 999,165 rows — these rows as CSV