PREVIEW / stock_1min / 2007-05-04
file: by_date/stock_1min/2007/2007-05-04.parquet size: 10.4 MB rows: 863,903 symbols: 2,219
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-04 09:30:00 | AAPL | Stock | 3.6 | 3.6061 | 3.5971 | 3.6046 | 5638920.0 |
| 2007-05-04 09:31:00 | AAPL | Stock | 3.6039 | 3.6071 | 3.5982 | 3.6071 | 2754612.0 |
| 2007-05-04 09:32:00 | AAPL | Stock | 3.6025 | 3.6057 | 3.5946 | 3.5954 | 1866424.0 |
| 2007-05-04 09:33:00 | AAPL | Stock | 3.595 | 3.5954 | 3.5893 | 3.5925 | 2579752.0 |
| 2007-05-04 09:34:00 | AAPL | Stock | 3.5932 | 3.5968 | 3.5893 | 3.5918 | 1491812.0 |
| 2007-05-04 09:35:00 | AAPL | Stock | 3.5936 | 3.5982 | 3.5911 | 3.5982 | 1547700.0 |
| 2007-05-04 09:36:00 | AAPL | Stock | 3.5985 | 3.5989 | 3.5957 | 3.5957 | 1070076.0 |
| 2007-05-04 09:37:00 | AAPL | Stock | 3.5961 | 3.5975 | 3.5943 | 3.5975 | 1496684.0 |
| 2007-05-04 09:38:00 | AAPL | Stock | 3.5975 | 3.5982 | 3.5954 | 3.5964 | 2581936.0 |
| 2007-05-04 09:39:00 | AAPL | Stock | 3.5965 | 3.5996 | 3.595 | 3.5996 | 3407180.0 |
| 2007-05-04 09:40:00 | AAPL | Stock | 3.5996 | 3.6064 | 3.5964 | 3.6036 | 3438764.0 |
| 2007-05-04 09:41:00 | AAPL | Stock | 3.6032 | 3.6111 | 3.6014 | 3.6089 | 4061708.0 |
| 2007-05-04 09:42:00 | AAPL | Stock | 3.6086 | 3.6107 | 3.6071 | 3.6086 | 1593480.0 |
| 2007-05-04 09:43:00 | AAPL | Stock | 3.6082 | 3.6082 | 3.6039 | 3.6053 | 2123940.0 |
| 2007-05-04 09:44:00 | AAPL | Stock | 3.6054 | 3.6057 | 3.6011 | 3.6036 | 1213212.0 |
| 2007-05-04 09:45:00 | AAPL | Stock | 3.6036 | 3.6039 | 3.6011 | 3.6025 | 905800.0 |
| 2007-05-04 09:46:00 | AAPL | Stock | 3.6029 | 3.6054 | 3.6025 | 3.6039 | 1107792.0 |
| 2007-05-04 09:47:00 | AAPL | Stock | 3.6036 | 3.6046 | 3.6011 | 3.6021 | 679280.0 |
| 2007-05-04 09:48:00 | AAPL | Stock | 3.6029 | 3.6032 | 3.5989 | 3.6007 | 1128512.0 |
| 2007-05-04 09:49:00 | AAPL | Stock | 3.6007 | 3.6007 | 3.5964 | 3.5986 | 1996624.0 |
| 2007-05-04 09:50:00 | AAPL | Stock | 3.5993 | 3.5996 | 3.5968 | 3.5986 | 1584464.0 |
| 2007-05-04 09:51:00 | AAPL | Stock | 3.5989 | 3.6025 | 3.5972 | 3.6025 | 1363348.0 |
| 2007-05-04 09:52:00 | AAPL | Stock | 3.6021 | 3.6029 | 3.5986 | 3.5986 | 897596.0 |
| 2007-05-04 09:53:00 | AAPL | Stock | 3.5982 | 3.5993 | 3.5964 | 3.5986 | 1537648.0 |
| 2007-05-04 09:54:00 | AAPL | Stock | 3.5979 | 3.5989 | 3.5961 | 3.5989 | 1523368.0 |
| 2007-05-04 09:55:00 | AAPL | Stock | 3.5993 | 3.6021 | 3.5971 | 3.6011 | 850164.0 |
| 2007-05-04 09:56:00 | AAPL | Stock | 3.6004 | 3.6018 | 3.5994 | 3.601 | 567896.0 |
| 2007-05-04 09:57:00 | AAPL | Stock | 3.6007 | 3.6018 | 3.6004 | 3.6018 | 734496.0 |
| 2007-05-04 09:58:00 | AAPL | Stock | 3.6011 | 3.6014 | 3.5975 | 3.5996 | 851872.0 |
| 2007-05-04 09:59:00 | AAPL | Stock | 3.5993 | 3.6 | 3.5979 | 3.5986 | 397768.0 |
| 2007-05-04 10:00:00 | AAPL | Stock | 3.5989 | 3.6011 | 3.5971 | 3.5979 | 1218672.0 |
| 2007-05-04 10:01:00 | AAPL | Stock | 3.5975 | 3.5989 | 3.5961 | 3.5967 | 2004772.0 |
| 2007-05-04 10:02:00 | AAPL | Stock | 3.5964 | 3.5982 | 3.5954 | 3.5968 | 1911420.0 |
| 2007-05-04 10:03:00 | AAPL | Stock | 3.5971 | 3.5986 | 3.5957 | 3.5982 | 1378272.0 |
| 2007-05-04 10:04:00 | AAPL | Stock | 3.5986 | 3.6057 | 3.5986 | 3.6025 | 3366944.0 |
| 2007-05-04 10:05:00 | AAPL | Stock | 3.6025 | 3.6054 | 3.6017 | 3.6043 | 1826916.0 |
| 2007-05-04 10:06:00 | AAPL | Stock | 3.6043 | 3.6046 | 3.6021 | 3.6043 | 693000.0 |
| 2007-05-04 10:07:00 | AAPL | Stock | 3.6039 | 3.6043 | 3.6025 | 3.6029 | 711312.0 |
| 2007-05-04 10:08:00 | AAPL | Stock | 3.6029 | 3.6039 | 3.6025 | 3.6032 | 425572.0 |
| 2007-05-04 10:09:00 | AAPL | Stock | 3.6032 | 3.6039 | 3.6025 | 3.6036 | 561120.0 |
| 2007-05-04 10:10:00 | AAPL | Stock | 3.6032 | 3.6089 | 3.6032 | 3.6079 | 2983876.0 |
| 2007-05-04 10:11:00 | AAPL | Stock | 3.6079 | 3.6079 | 3.6054 | 3.6064 | 1020068.0 |
| 2007-05-04 10:12:00 | AAPL | Stock | 3.6064 | 3.6096 | 3.6061 | 3.6093 | 1810228.0 |
| 2007-05-04 10:13:00 | AAPL | Stock | 3.6093 | 3.6107 | 3.6089 | 3.61 | 1369732.0 |
| 2007-05-04 10:14:00 | AAPL | Stock | 3.61 | 3.6104 | 3.6096 | 3.6104 | 814800.0 |
| 2007-05-04 10:15:00 | AAPL | Stock | 3.6107 | 3.6118 | 3.6096 | 3.6114 | 1982932.0 |
| 2007-05-04 10:16:00 | AAPL | Stock | 3.6111 | 3.6118 | 3.61 | 3.61 | 974456.0 |
| 2007-05-04 10:17:00 | AAPL | Stock | 3.6104 | 3.6104 | 3.6079 | 3.6096 | 987028.0 |
| 2007-05-04 10:18:00 | AAPL | Stock | 3.6096 | 3.6118 | 3.6089 | 3.6117 | 1127112.0 |
| 2007-05-04 10:19:00 | AAPL | Stock | 3.6118 | 3.6161 | 3.6107 | 3.615 | 3938004.0 |
> showing 50 of 863,903 rows — these rows as CSV