PREVIEW / stock_1min / 2006-02-07
file: by_date/stock_1min/2006/2006-02-07.parquet size: 8.3 MB rows: 671,103 symbols: 1,791
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 |
|---|---|---|---|---|---|---|---|
| 2006-02-07 04:40:00 | AAPL | Stock | 2.3975 | 2.3975 | 2.3975 | 2.3975 | 2800.0 |
| 2006-02-07 04:42:00 | AAPL | Stock | 2.3971 | 2.3971 | 2.3971 | 2.3971 | 8400.0 |
| 2006-02-07 05:07:00 | AAPL | Stock | 2.3821 | 2.3821 | 2.3821 | 2.3821 | 11200.0 |
| 2006-02-07 05:18:00 | AAPL | Stock | 2.3714 | 2.3714 | 2.3714 | 2.3714 | 16800.0 |
| 2006-02-07 05:23:00 | AAPL | Stock | 2.3714 | 2.3714 | 2.3714 | 2.3714 | 14000.0 |
| 2006-02-07 05:26:00 | AAPL | Stock | 2.3732 | 2.3732 | 2.3732 | 2.3732 | 11200.0 |
| 2006-02-07 05:30:00 | AAPL | Stock | 2.3732 | 2.3732 | 2.3732 | 2.3732 | 2800.0 |
| 2006-02-07 05:33:00 | AAPL | Stock | 2.3732 | 2.3732 | 2.3679 | 2.3679 | 22400.0 |
| 2006-02-07 05:52:00 | AAPL | Stock | 2.3714 | 2.3714 | 2.3714 | 2.3714 | 61600.0 |
| 2006-02-07 05:53:00 | AAPL | Stock | 2.3714 | 2.3714 | 2.3714 | 2.3714 | 8400.0 |
| 2006-02-07 05:56:00 | AAPL | Stock | 2.3679 | 2.3679 | 2.3679 | 2.3679 | 11200.0 |
| 2006-02-07 06:03:00 | AAPL | Stock | 2.3714 | 2.3714 | 2.3714 | 2.3714 | 28000.0 |
| 2006-02-07 06:06:00 | AAPL | Stock | 2.3786 | 2.3786 | 2.3786 | 2.3786 | 2800.0 |
| 2006-02-07 06:22:00 | AAPL | Stock | 2.3732 | 2.3732 | 2.3732 | 2.3732 | 14000.0 |
| 2006-02-07 06:23:00 | AAPL | Stock | 2.3732 | 2.3732 | 2.3732 | 2.3732 | 14000.0 |
| 2006-02-07 06:24:00 | AAPL | Stock | 2.3714 | 2.3714 | 2.3714 | 2.3714 | 28000.0 |
| 2006-02-07 06:37:00 | AAPL | Stock | 2.3714 | 2.3714 | 2.3714 | 2.3714 | 28000.0 |
| 2006-02-07 06:45:00 | AAPL | Stock | 2.375 | 2.375 | 2.375 | 2.375 | 2800.0 |
| 2006-02-07 06:46:00 | AAPL | Stock | 2.3839 | 2.3839 | 2.3839 | 2.3839 | 25200.0 |
| 2006-02-07 06:56:00 | AAPL | Stock | 2.3821 | 2.3821 | 2.3821 | 2.3821 | 2800.0 |
| 2006-02-07 06:57:00 | AAPL | Stock | 2.375 | 2.375 | 2.375 | 2.375 | 5600.0 |
| 2006-02-07 07:00:00 | AAPL | Stock | 2.3843 | 2.3929 | 2.3839 | 2.3839 | 54600.0 |
| 2006-02-07 07:03:00 | AAPL | Stock | 2.3893 | 2.3893 | 2.3875 | 2.3875 | 11200.0 |
| 2006-02-07 07:05:00 | AAPL | Stock | 2.3875 | 2.3875 | 2.3875 | 2.3875 | 2800.0 |
| 2006-02-07 07:06:00 | AAPL | Stock | 2.3879 | 2.3911 | 2.3879 | 2.3911 | 19600.0 |
| 2006-02-07 07:07:00 | AAPL | Stock | 2.3929 | 2.3929 | 2.3929 | 2.3929 | 28000.0 |
| 2006-02-07 07:12:00 | AAPL | Stock | 2.3929 | 2.3929 | 2.3929 | 2.3929 | 2800.0 |
| 2006-02-07 07:14:00 | AAPL | Stock | 2.3929 | 2.3929 | 2.3929 | 2.3929 | 50400.0 |
| 2006-02-07 07:16:00 | AAPL | Stock | 2.3911 | 2.3911 | 2.3911 | 2.3911 | 14000.0 |
| 2006-02-07 07:17:00 | AAPL | Stock | 2.3886 | 2.3886 | 2.3886 | 2.3886 | 6608.0 |
| 2006-02-07 07:20:00 | AAPL | Stock | 2.3879 | 2.3879 | 2.3879 | 2.3879 | 22400.0 |
| 2006-02-07 07:21:00 | AAPL | Stock | 2.3821 | 2.3821 | 2.3821 | 2.3821 | 86800.0 |
| 2006-02-07 07:22:00 | AAPL | Stock | 2.3821 | 2.3929 | 2.3821 | 2.3929 | 47600.0 |
| 2006-02-07 07:24:00 | AAPL | Stock | 2.3929 | 2.3929 | 2.3929 | 2.3929 | 44800.0 |
| 2006-02-07 07:26:00 | AAPL | Stock | 2.3929 | 2.3929 | 2.3929 | 2.3929 | 22400.0 |
| 2006-02-07 07:29:00 | AAPL | Stock | 2.3929 | 2.3929 | 2.3929 | 2.3929 | 22400.0 |
| 2006-02-07 07:30:00 | AAPL | Stock | 2.3929 | 2.3929 | 2.3929 | 2.3929 | 50400.0 |
| 2006-02-07 07:31:00 | AAPL | Stock | 2.3964 | 2.3964 | 2.3964 | 2.3964 | 14000.0 |
| 2006-02-07 07:32:00 | AAPL | Stock | 2.3964 | 2.3964 | 2.3964 | 2.3964 | 5600.0 |
| 2006-02-07 07:34:00 | AAPL | Stock | 2.3925 | 2.3925 | 2.3925 | 2.3925 | 19600.0 |
| 2006-02-07 07:36:00 | AAPL | Stock | 2.3893 | 2.3893 | 2.3893 | 2.3893 | 2800.0 |
| 2006-02-07 07:38:00 | AAPL | Stock | 2.3929 | 2.3964 | 2.3929 | 2.3964 | 16800.0 |
| 2006-02-07 07:39:00 | AAPL | Stock | 2.3964 | 2.3964 | 2.3964 | 2.3964 | 2800.0 |
| 2006-02-07 07:43:00 | AAPL | Stock | 2.3964 | 2.3964 | 2.3964 | 2.3964 | 27720.0 |
| 2006-02-07 07:53:00 | AAPL | Stock | 2.3982 | 2.3982 | 2.3982 | 2.3982 | 11200.0 |
| 2006-02-07 07:54:00 | AAPL | Stock | 2.3961 | 2.3961 | 2.3961 | 2.3961 | 8036.0 |
| 2006-02-07 07:57:00 | AAPL | Stock | 2.4011 | 2.4018 | 2.4011 | 2.4018 | 33600.0 |
| 2006-02-07 07:58:00 | AAPL | Stock | 2.4018 | 2.4018 | 2.3964 | 2.3964 | 8400.0 |
| 2006-02-07 08:00:00 | AAPL | Stock | 2.3954 | 2.4071 | 2.3893 | 2.4071 | 533148.0 |
| 2006-02-07 08:01:00 | AAPL | Stock | 2.4039 | 2.4071 | 2.3986 | 2.4036 | 930636.0 |
> showing 50 of 671,103 rows — these rows as CSV