PREVIEW / stock_1min / 2007-03-02
file: by_date/stock_1min/2007/2007-03-02.parquet size: 9.5 MB rows: 769,805 symbols: 2,031
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 |
|---|---|---|---|---|---|---|---|
| 2007-03-02 07:15:00 | AAPL | Stock | 3.0757 | 3.0954 | 3.0757 | 3.0954 | 11200.0 |
| 2007-03-02 07:16:00 | AAPL | Stock | 3.1089 | 3.1089 | 3.1089 | 3.1089 | 53200.0 |
| 2007-03-02 07:18:00 | AAPL | Stock | 3.1089 | 3.1089 | 3.1089 | 3.1089 | 112000.0 |
| 2007-03-02 07:19:00 | AAPL | Stock | 3.1089 | 3.1089 | 3.1089 | 3.1089 | 28000.0 |
| 2007-03-02 07:30:00 | AAPL | Stock | 3.1061 | 3.1061 | 3.1061 | 3.1061 | 11200.0 |
| 2007-03-02 07:31:00 | AAPL | Stock | 3.1061 | 3.1061 | 3.1 | 3.1 | 19600.0 |
| 2007-03-02 07:33:00 | AAPL | Stock | 3.095 | 3.095 | 3.0896 | 3.0943 | 109200.0 |
| 2007-03-02 07:36:00 | AAPL | Stock | 3.095 | 3.095 | 3.0946 | 3.0946 | 19600.0 |
| 2007-03-02 07:37:00 | AAPL | Stock | 3.0982 | 3.0982 | 3.0982 | 3.0982 | 4200.0 |
| 2007-03-02 07:38:00 | AAPL | Stock | 3.1032 | 3.1032 | 3.1032 | 3.1032 | 2800.0 |
| 2007-03-02 07:39:00 | AAPL | Stock | 3.1032 | 3.1032 | 3.1032 | 3.1032 | 11200.0 |
| 2007-03-02 07:41:00 | AAPL | Stock | 3.1061 | 3.1061 | 3.1061 | 3.1061 | 25200.0 |
| 2007-03-02 07:42:00 | AAPL | Stock | 3.1061 | 3.1061 | 3.1061 | 3.1061 | 2800.0 |
| 2007-03-02 07:43:00 | AAPL | Stock | 3.0996 | 3.0996 | 3.0996 | 3.0996 | 3640.0 |
| 2007-03-02 07:48:00 | AAPL | Stock | 3.0996 | 3.0996 | 3.0996 | 3.0996 | 8400.0 |
| 2007-03-02 07:50:00 | AAPL | Stock | 3.0982 | 3.0982 | 3.0982 | 3.0982 | 9240.0 |
| 2007-03-02 08:00:00 | AAPL | Stock | 3.0982 | 3.1036 | 3.0961 | 3.1 | 120400.0 |
| 2007-03-02 08:01:00 | AAPL | Stock | 3.1 | 3.1 | 3.1 | 3.1 | 28000.0 |
| 2007-03-02 08:02:00 | AAPL | Stock | 3.0996 | 3.0996 | 3.0964 | 3.0964 | 16800.0 |
| 2007-03-02 08:03:00 | AAPL | Stock | 3.0964 | 3.0964 | 3.0946 | 3.0964 | 62160.0 |
| 2007-03-02 08:04:00 | AAPL | Stock | 3.0957 | 3.0961 | 3.0911 | 3.0946 | 165200.0 |
| 2007-03-02 08:05:00 | AAPL | Stock | 3.0936 | 3.0936 | 3.0911 | 3.0918 | 64400.0 |
| 2007-03-02 08:06:00 | AAPL | Stock | 3.0946 | 3.0946 | 3.0946 | 3.0946 | 42000.0 |
| 2007-03-02 08:07:00 | AAPL | Stock | 3.0946 | 3.0946 | 3.0921 | 3.0921 | 25200.0 |
| 2007-03-02 08:08:00 | AAPL | Stock | 3.0932 | 3.0932 | 3.0904 | 3.0904 | 57596.0 |
| 2007-03-02 08:09:00 | AAPL | Stock | 3.0911 | 3.0946 | 3.0904 | 3.0904 | 30800.0 |
| 2007-03-02 08:10:00 | AAPL | Stock | 3.0896 | 3.0918 | 3.0896 | 3.0918 | 24500.0 |
| 2007-03-02 08:11:00 | AAPL | Stock | 3.0893 | 3.0907 | 3.0857 | 3.0907 | 168980.0 |
| 2007-03-02 08:12:00 | AAPL | Stock | 3.0893 | 3.0893 | 3.0868 | 3.0893 | 23800.0 |
| 2007-03-02 08:13:00 | AAPL | Stock | 3.0893 | 3.0893 | 3.0861 | 3.0861 | 57400.0 |
| 2007-03-02 08:14:00 | AAPL | Stock | 3.0857 | 3.0871 | 3.0857 | 3.0871 | 15400.0 |
| 2007-03-02 08:15:00 | AAPL | Stock | 3.0875 | 3.0875 | 3.0857 | 3.0857 | 33600.0 |
| 2007-03-02 08:16:00 | AAPL | Stock | 3.0893 | 3.0893 | 3.0861 | 3.0861 | 58800.0 |
| 2007-03-02 08:17:00 | AAPL | Stock | 3.0864 | 3.0864 | 3.0857 | 3.0857 | 84000.0 |
| 2007-03-02 08:18:00 | AAPL | Stock | 3.0889 | 3.0889 | 3.0857 | 3.0857 | 64400.0 |
| 2007-03-02 08:19:00 | AAPL | Stock | 3.0857 | 3.0857 | 3.0857 | 3.0857 | 80220.0 |
| 2007-03-02 08:20:00 | AAPL | Stock | 3.0839 | 3.0875 | 3.0839 | 3.0875 | 139860.0 |
| 2007-03-02 08:21:00 | AAPL | Stock | 3.0875 | 3.0893 | 3.0875 | 3.0875 | 250600.0 |
| 2007-03-02 08:22:00 | AAPL | Stock | 3.0875 | 3.0893 | 3.0875 | 3.0889 | 74200.0 |
| 2007-03-02 08:23:00 | AAPL | Stock | 3.0907 | 3.0946 | 3.0907 | 3.0946 | 213472.0 |
| 2007-03-02 08:24:00 | AAPL | Stock | 3.0907 | 3.0932 | 3.0893 | 3.0893 | 83580.0 |
| 2007-03-02 08:25:00 | AAPL | Stock | 3.0932 | 3.0946 | 3.0911 | 3.0939 | 21840.0 |
| 2007-03-02 08:26:00 | AAPL | Stock | 3.0943 | 3.0943 | 3.0929 | 3.0929 | 47600.0 |
| 2007-03-02 08:27:00 | AAPL | Stock | 3.0939 | 3.0961 | 3.0939 | 3.0961 | 221200.0 |
| 2007-03-02 08:28:00 | AAPL | Stock | 3.0946 | 3.0979 | 3.0946 | 3.0961 | 53200.0 |
| 2007-03-02 08:29:00 | AAPL | Stock | 3.0957 | 3.0982 | 3.0946 | 3.0946 | 258440.0 |
| 2007-03-02 08:30:00 | AAPL | Stock | 3.0946 | 3.0946 | 3.0946 | 3.0946 | 5600.0 |
| 2007-03-02 08:31:00 | AAPL | Stock | 3.0932 | 3.0946 | 3.0932 | 3.0946 | 75600.0 |
| 2007-03-02 08:32:00 | AAPL | Stock | 3.0954 | 3.0957 | 3.0954 | 3.0957 | 50400.0 |
| 2007-03-02 08:33:00 | AAPL | Stock | 3.0954 | 3.0964 | 3.0954 | 3.0964 | 33600.0 |
> showing 50 of 769,805 rows — these rows as CSV