PREVIEW / stock_1min / 2006-07-19
file: by_date/stock_1min/2006/2006-07-19.parquet size: 8.7 MB rows: 711,561 symbols: 1,896
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-07-19 08:00:00 | AAPL | Stock | 1.8979 | 1.9 | 1.8929 | 1.8996 | 124544.0 |
| 2006-07-19 08:01:00 | AAPL | Stock | 1.8932 | 1.8932 | 1.8929 | 1.8929 | 47376.0 |
| 2006-07-19 08:02:00 | AAPL | Stock | 1.8982 | 1.8982 | 1.8982 | 1.8982 | 14000.0 |
| 2006-07-19 08:03:00 | AAPL | Stock | 1.8982 | 1.8982 | 1.8964 | 1.8964 | 11200.0 |
| 2006-07-19 08:04:00 | AAPL | Stock | 1.8982 | 1.8982 | 1.8964 | 1.8964 | 56000.0 |
| 2006-07-19 08:05:00 | AAPL | Stock | 1.8982 | 1.8982 | 1.8982 | 1.8982 | 204400.0 |
| 2006-07-19 08:07:00 | AAPL | Stock | 1.8989 | 1.8989 | 1.8982 | 1.8982 | 8540.0 |
| 2006-07-19 08:08:00 | AAPL | Stock | 1.8982 | 1.8982 | 1.8968 | 1.8982 | 38920.0 |
| 2006-07-19 08:10:00 | AAPL | Stock | 1.8979 | 1.8979 | 1.8968 | 1.8979 | 159600.0 |
| 2006-07-19 08:11:00 | AAPL | Stock | 1.8982 | 1.8982 | 1.8982 | 1.8982 | 3080.0 |
| 2006-07-19 08:12:00 | AAPL | Stock | 1.8989 | 1.8989 | 1.8989 | 1.8989 | 28364.0 |
| 2006-07-19 08:13:00 | AAPL | Stock | 1.8989 | 1.8989 | 1.8989 | 1.8989 | 11200.0 |
| 2006-07-19 08:15:00 | AAPL | Stock | 1.8989 | 1.8989 | 1.8989 | 1.8989 | 9100.0 |
| 2006-07-19 08:16:00 | AAPL | Stock | 1.8989 | 1.8989 | 1.8968 | 1.8982 | 70364.0 |
| 2006-07-19 08:17:00 | AAPL | Stock | 1.8982 | 1.9 | 1.8982 | 1.9 | 74760.0 |
| 2006-07-19 08:18:00 | AAPL | Stock | 1.9007 | 1.9018 | 1.9007 | 1.9018 | 691600.0 |
| 2006-07-19 08:19:00 | AAPL | Stock | 1.9018 | 1.9064 | 1.9018 | 1.9064 | 36400.0 |
| 2006-07-19 08:20:00 | AAPL | Stock | 1.9075 | 1.9089 | 1.9057 | 1.9089 | 81200.0 |
| 2006-07-19 08:21:00 | AAPL | Stock | 1.9089 | 1.9107 | 1.9082 | 1.9107 | 50400.0 |
| 2006-07-19 08:22:00 | AAPL | Stock | 1.9093 | 1.9093 | 1.9071 | 1.9086 | 92036.0 |
| 2006-07-19 08:23:00 | AAPL | Stock | 1.9071 | 1.9089 | 1.9054 | 1.9054 | 77000.0 |
| 2006-07-19 08:24:00 | AAPL | Stock | 1.9054 | 1.9089 | 1.9054 | 1.9071 | 22400.0 |
| 2006-07-19 08:25:00 | AAPL | Stock | 1.9071 | 1.9104 | 1.9054 | 1.9054 | 44800.0 |
| 2006-07-19 08:26:00 | AAPL | Stock | 1.9054 | 1.9054 | 1.9054 | 1.9054 | 64400.0 |
| 2006-07-19 08:27:00 | AAPL | Stock | 1.9054 | 1.9064 | 1.9054 | 1.9064 | 84000.0 |
| 2006-07-19 08:28:00 | AAPL | Stock | 1.9096 | 1.91 | 1.9096 | 1.91 | 8036.0 |
| 2006-07-19 08:29:00 | AAPL | Stock | 1.9089 | 1.91 | 1.9089 | 1.91 | 19600.0 |
| 2006-07-19 08:30:00 | AAPL | Stock | 1.9075 | 1.9089 | 1.9036 | 1.9089 | 42000.0 |
| 2006-07-19 08:31:00 | AAPL | Stock | 1.9071 | 1.9071 | 1.9036 | 1.9036 | 22400.0 |
| 2006-07-19 08:32:00 | AAPL | Stock | 1.9036 | 1.9036 | 1.9018 | 1.9018 | 92848.0 |
| 2006-07-19 08:33:00 | AAPL | Stock | 1.9018 | 1.9032 | 1.9 | 1.9004 | 67200.0 |
| 2006-07-19 08:34:00 | AAPL | Stock | 1.9 | 1.9 | 1.8968 | 1.8968 | 102200.0 |
| 2006-07-19 08:35:00 | AAPL | Stock | 1.8975 | 1.9 | 1.8968 | 1.8968 | 28392.0 |
| 2006-07-19 08:36:00 | AAPL | Stock | 1.8993 | 1.9018 | 1.8989 | 1.8989 | 42924.0 |
| 2006-07-19 08:37:00 | AAPL | Stock | 1.8989 | 1.8989 | 1.8989 | 1.8989 | 40068.0 |
| 2006-07-19 08:38:00 | AAPL | Stock | 1.8982 | 1.8982 | 1.8964 | 1.8964 | 50008.0 |
| 2006-07-19 08:39:00 | AAPL | Stock | 1.8989 | 1.8989 | 1.8968 | 1.8968 | 5600.0 |
| 2006-07-19 08:40:00 | AAPL | Stock | 1.8968 | 1.8968 | 1.8964 | 1.8964 | 51352.0 |
| 2006-07-19 08:41:00 | AAPL | Stock | 1.8964 | 1.9 | 1.8964 | 1.9 | 707728.0 |
| 2006-07-19 08:43:00 | AAPL | Stock | 1.9018 | 1.9018 | 1.9018 | 1.9018 | 56000.0 |
| 2006-07-19 08:45:00 | AAPL | Stock | 1.8982 | 1.9 | 1.8982 | 1.9 | 30800.0 |
| 2006-07-19 08:46:00 | AAPL | Stock | 1.9 | 1.9036 | 1.9 | 1.9 | 61628.0 |
| 2006-07-19 08:48:00 | AAPL | Stock | 1.9 | 1.9 | 1.9 | 1.9 | 28000.0 |
| 2006-07-19 08:50:00 | AAPL | Stock | 1.9018 | 1.9018 | 1.8996 | 1.9018 | 33600.0 |
| 2006-07-19 08:51:00 | AAPL | Stock | 1.9018 | 1.9018 | 1.9018 | 1.9018 | 81200.0 |
| 2006-07-19 08:52:00 | AAPL | Stock | 1.9018 | 1.9036 | 1.9018 | 1.9018 | 319900.0 |
| 2006-07-19 08:53:00 | AAPL | Stock | 1.9018 | 1.9018 | 1.8996 | 1.9 | 70000.0 |
| 2006-07-19 08:55:00 | AAPL | Stock | 1.9 | 1.9 | 1.9 | 1.9 | 67200.0 |
| 2006-07-19 08:56:00 | AAPL | Stock | 1.9 | 1.9 | 1.8982 | 1.8982 | 33600.0 |
| 2006-07-19 08:57:00 | AAPL | Stock | 1.8971 | 1.9 | 1.8971 | 1.9 | 282128.0 |
> showing 50 of 711,561 rows — these rows as CSV