PREVIEW / stock_1min / 2009-12-02
file: by_date/stock_1min/2009/2009-12-02.parquet size: 12.8 MB rows: 969,939 symbols: 2,778
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 |
|---|---|---|---|---|---|---|---|
| 2009-12-02 04:15:00 | AAPL | Stock | 7.0875 | 7.0875 | 7.0875 | 7.0875 | 2800.0 |
| 2009-12-02 04:36:00 | AAPL | Stock | 7.0732 | 7.0732 | 7.0732 | 7.0732 | 4760.0 |
| 2009-12-02 05:37:00 | AAPL | Stock | 7.0775 | 7.0836 | 7.0775 | 7.0836 | 14784.0 |
| 2009-12-02 05:41:00 | AAPL | Stock | 7.0768 | 7.0768 | 7.0768 | 7.0768 | 2800.0 |
| 2009-12-02 05:48:00 | AAPL | Stock | 7.0746 | 7.0746 | 7.0607 | 7.0714 | 20160.0 |
| 2009-12-02 06:14:00 | AAPL | Stock | 7.0714 | 7.0714 | 7.0714 | 7.0714 | 14000.0 |
| 2009-12-02 06:22:00 | AAPL | Stock | 7.0714 | 7.0714 | 7.0714 | 7.0714 | 8400.0 |
| 2009-12-02 06:31:00 | AAPL | Stock | 7.0804 | 7.0804 | 7.0804 | 7.0804 | 2800.0 |
| 2009-12-02 06:53:00 | AAPL | Stock | 7.0821 | 7.0821 | 7.0821 | 7.0821 | 2800.0 |
| 2009-12-02 06:55:00 | AAPL | Stock | 7.0779 | 7.0779 | 7.0779 | 7.0779 | 2800.0 |
| 2009-12-02 07:32:00 | AAPL | Stock | 7.0857 | 7.0857 | 7.0857 | 7.0857 | 2800.0 |
| 2009-12-02 07:36:00 | AAPL | Stock | 7.0857 | 7.0857 | 7.0857 | 7.0857 | 2800.0 |
| 2009-12-02 07:46:00 | AAPL | Stock | 7.0793 | 7.0793 | 7.0793 | 7.0793 | 2800.0 |
| 2009-12-02 07:49:00 | AAPL | Stock | 7.0793 | 7.0793 | 7.0793 | 7.0793 | 2800.0 |
| 2009-12-02 07:58:00 | AAPL | Stock | 7.0882 | 7.1175 | 7.0882 | 7.0946 | 52640.0 |
| 2009-12-02 08:00:00 | AAPL | Stock | 7.0982 | 7.1018 | 7.0982 | 7.1018 | 39200.0 |
| 2009-12-02 08:01:00 | AAPL | Stock | 7.1011 | 7.1018 | 7.0982 | 7.0982 | 59556.0 |
| 2009-12-02 08:02:00 | AAPL | Stock | 7.0979 | 7.0979 | 7.0954 | 7.0954 | 5600.0 |
| 2009-12-02 08:03:00 | AAPL | Stock | 7.0975 | 7.0982 | 7.0964 | 7.0964 | 56000.0 |
| 2009-12-02 08:04:00 | AAPL | Stock | 7.0982 | 7.0982 | 7.0964 | 7.0964 | 14000.0 |
| 2009-12-02 08:05:00 | AAPL | Stock | 7.0982 | 7.0982 | 7.0964 | 7.0982 | 30800.0 |
| 2009-12-02 08:06:00 | AAPL | Stock | 7.0982 | 7.1018 | 7.0982 | 7.1018 | 17780.0 |
| 2009-12-02 08:07:00 | AAPL | Stock | 7.0986 | 7.0986 | 7.0982 | 7.0982 | 23520.0 |
| 2009-12-02 08:08:00 | AAPL | Stock | 7.1007 | 7.1018 | 7.1007 | 7.1018 | 16912.0 |
| 2009-12-02 08:10:00 | AAPL | Stock | 7.1007 | 7.1054 | 7.1007 | 7.1054 | 58520.0 |
| 2009-12-02 08:11:00 | AAPL | Stock | 7.1054 | 7.1139 | 7.1036 | 7.1107 | 195048.0 |
| 2009-12-02 08:12:00 | AAPL | Stock | 7.1129 | 7.1143 | 7.1111 | 7.1143 | 28000.0 |
| 2009-12-02 08:13:00 | AAPL | Stock | 7.1146 | 7.12 | 7.11 | 7.1179 | 205408.0 |
| 2009-12-02 08:14:00 | AAPL | Stock | 7.1136 | 7.1136 | 7.1125 | 7.1125 | 22400.0 |
| 2009-12-02 08:15:00 | AAPL | Stock | 7.1107 | 7.1114 | 7.1075 | 7.1114 | 72800.0 |
| 2009-12-02 08:16:00 | AAPL | Stock | 7.1107 | 7.1118 | 7.1107 | 7.1118 | 14000.0 |
| 2009-12-02 08:18:00 | AAPL | Stock | 7.1118 | 7.1118 | 7.1089 | 7.1107 | 53200.0 |
| 2009-12-02 08:19:00 | AAPL | Stock | 7.1118 | 7.1118 | 7.1118 | 7.1118 | 63420.0 |
| 2009-12-02 08:20:00 | AAPL | Stock | 7.1118 | 7.1136 | 7.1054 | 7.1068 | 140000.0 |
| 2009-12-02 08:21:00 | AAPL | Stock | 7.1043 | 7.1043 | 7.0996 | 7.1018 | 95480.0 |
| 2009-12-02 08:22:00 | AAPL | Stock | 7.1004 | 7.1021 | 7.0996 | 7.1018 | 53200.0 |
| 2009-12-02 08:23:00 | AAPL | Stock | 7.1036 | 7.1066 | 7.1021 | 7.1064 | 43372.0 |
| 2009-12-02 08:24:00 | AAPL | Stock | 7.1064 | 7.1064 | 7.1064 | 7.1064 | 2800.0 |
| 2009-12-02 08:25:00 | AAPL | Stock | 7.1064 | 7.1064 | 7.1064 | 7.1064 | 2800.0 |
| 2009-12-02 08:26:00 | AAPL | Stock | 7.1064 | 7.1071 | 7.1037 | 7.1071 | 25200.0 |
| 2009-12-02 08:27:00 | AAPL | Stock | 7.1071 | 7.1071 | 7.1061 | 7.1061 | 7840.0 |
| 2009-12-02 08:28:00 | AAPL | Stock | 7.1079 | 7.1086 | 7.1079 | 7.1079 | 14000.0 |
| 2009-12-02 08:29:00 | AAPL | Stock | 7.1071 | 7.1079 | 7.1071 | 7.1071 | 36400.0 |
| 2009-12-02 08:30:00 | AAPL | Stock | 7.1071 | 7.1071 | 7.1036 | 7.1036 | 74200.0 |
| 2009-12-02 08:31:00 | AAPL | Stock | 7.1021 | 7.1025 | 7.0996 | 7.1025 | 47600.0 |
| 2009-12-02 08:32:00 | AAPL | Stock | 7.1018 | 7.105 | 7.1018 | 7.105 | 60816.0 |
| 2009-12-02 08:33:00 | AAPL | Stock | 7.1029 | 7.1029 | 7.1018 | 7.1018 | 15400.0 |
| 2009-12-02 08:34:00 | AAPL | Stock | 7.1043 | 7.105 | 7.0346 | 7.105 | 27272.0 |
| 2009-12-02 08:35:00 | AAPL | Stock | 7.1043 | 7.1057 | 7.1036 | 7.1036 | 55104.0 |
| 2009-12-02 08:36:00 | AAPL | Stock | 7.1018 | 7.1018 | 7.1014 | 7.1014 | 5600.0 |
> showing 50 of 969,939 rows — these rows as CSV