PREVIEW / stock_1min / 2007-05-03
file: by_date/stock_1min/2007/2007-05-03.parquet size: 10.5 MB rows: 869,271 symbols: 2,200
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-05-03 09:30:00 | AAPL | Stock | 3.5975 | 3.6018 | 3.5954 | 3.6 | 5645948.0 |
| 2007-05-03 09:31:00 | AAPL | Stock | 3.5982 | 3.6054 | 3.5964 | 3.6036 | 3590188.0 |
| 2007-05-03 09:32:00 | AAPL | Stock | 3.6032 | 3.6075 | 3.5982 | 3.6071 | 6361012.0 |
| 2007-05-03 09:33:00 | AAPL | Stock | 3.6071 | 3.6107 | 3.6068 | 3.6107 | 4914448.0 |
| 2007-05-03 09:34:00 | AAPL | Stock | 3.6107 | 3.6125 | 3.6093 | 3.6107 | 3748136.0 |
| 2007-05-03 09:35:00 | AAPL | Stock | 3.6107 | 3.6114 | 3.6071 | 3.6071 | 3099712.0 |
| 2007-05-03 09:36:00 | AAPL | Stock | 3.6071 | 3.6125 | 3.6071 | 3.6107 | 3065496.0 |
| 2007-05-03 09:37:00 | AAPL | Stock | 3.6111 | 3.6121 | 3.6071 | 3.6071 | 3353476.0 |
| 2007-05-03 09:38:00 | AAPL | Stock | 3.6071 | 3.6079 | 3.6054 | 3.6068 | 2251284.0 |
| 2007-05-03 09:39:00 | AAPL | Stock | 3.6068 | 3.61 | 3.6057 | 3.6089 | 2148496.0 |
| 2007-05-03 09:40:00 | AAPL | Stock | 3.6089 | 3.6125 | 3.6086 | 3.6114 | 2999780.0 |
| 2007-05-03 09:41:00 | AAPL | Stock | 3.6118 | 3.6143 | 3.6114 | 3.6136 | 3267880.0 |
| 2007-05-03 09:42:00 | AAPL | Stock | 3.6132 | 3.6189 | 3.6125 | 3.6175 | 6285944.0 |
| 2007-05-03 09:43:00 | AAPL | Stock | 3.6171 | 3.6179 | 3.615 | 3.6179 | 3658760.0 |
| 2007-05-03 09:44:00 | AAPL | Stock | 3.6175 | 3.6214 | 3.6171 | 3.6179 | 4885972.0 |
| 2007-05-03 09:45:00 | AAPL | Stock | 3.6179 | 3.6207 | 3.6164 | 3.6186 | 4125744.0 |
| 2007-05-03 09:46:00 | AAPL | Stock | 3.6186 | 3.6189 | 3.6132 | 3.6132 | 3394832.0 |
| 2007-05-03 09:47:00 | AAPL | Stock | 3.6129 | 3.6146 | 3.6125 | 3.6139 | 3511620.0 |
| 2007-05-03 09:48:00 | AAPL | Stock | 3.6139 | 3.6143 | 3.6064 | 3.61 | 4199104.0 |
| 2007-05-03 09:49:00 | AAPL | Stock | 3.61 | 3.6121 | 3.6086 | 3.61 | 2432332.0 |
| 2007-05-03 09:50:00 | AAPL | Stock | 3.61 | 3.6122 | 3.6096 | 3.6104 | 1502284.0 |
| 2007-05-03 09:51:00 | AAPL | Stock | 3.6104 | 3.6132 | 3.61 | 3.6118 | 1534932.0 |
| 2007-05-03 09:52:00 | AAPL | Stock | 3.6121 | 3.6132 | 3.6104 | 3.6121 | 1749916.0 |
| 2007-05-03 09:53:00 | AAPL | Stock | 3.6121 | 3.6129 | 3.61 | 3.6125 | 1801184.0 |
| 2007-05-03 09:54:00 | AAPL | Stock | 3.6121 | 3.6125 | 3.6096 | 3.6096 | 990640.0 |
| 2007-05-03 09:55:00 | AAPL | Stock | 3.61 | 3.61 | 3.6032 | 3.6036 | 4099452.0 |
| 2007-05-03 09:56:00 | AAPL | Stock | 3.6046 | 3.6054 | 3.5996 | 3.6032 | 3492104.0 |
| 2007-05-03 09:57:00 | AAPL | Stock | 3.6032 | 3.6046 | 3.6 | 3.6004 | 2142560.0 |
| 2007-05-03 09:58:00 | AAPL | Stock | 3.6 | 3.6036 | 3.5982 | 3.6032 | 2370032.0 |
| 2007-05-03 09:59:00 | AAPL | Stock | 3.6036 | 3.6054 | 3.6021 | 3.6054 | 1968204.0 |
| 2007-05-03 10:00:00 | AAPL | Stock | 3.6057 | 3.6089 | 3.6036 | 3.605 | 3888360.0 |
| 2007-05-03 10:01:00 | AAPL | Stock | 3.6043 | 3.6107 | 3.6021 | 3.6096 | 3945984.0 |
| 2007-05-03 10:02:00 | AAPL | Stock | 3.6096 | 3.6129 | 3.6046 | 3.6086 | 2797704.0 |
| 2007-05-03 10:03:00 | AAPL | Stock | 3.6082 | 3.6104 | 3.6071 | 3.6071 | 2184224.0 |
| 2007-05-03 10:04:00 | AAPL | Stock | 3.6071 | 3.6075 | 3.6017 | 3.6025 | 2432192.0 |
| 2007-05-03 10:05:00 | AAPL | Stock | 3.6029 | 3.6068 | 3.6018 | 3.6046 | 1328208.0 |
| 2007-05-03 10:06:00 | AAPL | Stock | 3.6046 | 3.6068 | 3.604 | 3.6064 | 1114260.0 |
| 2007-05-03 10:07:00 | AAPL | Stock | 3.6068 | 3.6086 | 3.6054 | 3.6075 | 964684.0 |
| 2007-05-03 10:08:00 | AAPL | Stock | 3.6071 | 3.6086 | 3.6057 | 3.6086 | 1120588.0 |
| 2007-05-03 10:09:00 | AAPL | Stock | 3.6086 | 3.6096 | 3.5957 | 3.6089 | 1638700.0 |
| 2007-05-03 10:10:00 | AAPL | Stock | 3.6089 | 3.6096 | 3.6064 | 3.6064 | 1550276.0 |
| 2007-05-03 10:11:00 | AAPL | Stock | 3.6064 | 3.6071 | 3.6039 | 3.6046 | 1235920.0 |
| 2007-05-03 10:12:00 | AAPL | Stock | 3.605 | 3.605 | 3.6014 | 3.6036 | 1645280.0 |
| 2007-05-03 10:13:00 | AAPL | Stock | 3.6032 | 3.6036 | 3.6018 | 3.6032 | 423612.0 |
| 2007-05-03 10:14:00 | AAPL | Stock | 3.6032 | 3.6061 | 3.6029 | 3.6054 | 1496292.0 |
| 2007-05-03 10:15:00 | AAPL | Stock | 3.6046 | 3.6057 | 3.6043 | 3.6043 | 1176644.0 |
| 2007-05-03 10:16:00 | AAPL | Stock | 3.6043 | 3.6111 | 3.6043 | 3.6093 | 1923768.0 |
| 2007-05-03 10:17:00 | AAPL | Stock | 3.6093 | 3.6107 | 3.6086 | 3.6086 | 449120.0 |
| 2007-05-03 10:18:00 | AAPL | Stock | 3.6086 | 3.61 | 3.6079 | 3.6079 | 896028.0 |
| 2007-05-03 10:19:00 | AAPL | Stock | 3.6082 | 3.6104 | 3.6075 | 3.6089 | 578676.0 |
> showing 50 of 869,271 rows — these rows as CSV