PREVIEW / stock_1min / 2007-02-02
file: by_date/stock_1min/2007/2007-02-02.parquet size: 9.0 MB rows: 729,842 symbols: 2,032
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-02-02 06:54:00 | AAPL | Stock | 3.0204 | 3.0204 | 3.0204 | 3.0204 | 19600.0 |
| 2007-02-02 06:55:00 | AAPL | Stock | 3.0204 | 3.0204 | 3.0146 | 3.0146 | 36400.0 |
| 2007-02-02 07:15:00 | AAPL | Stock | 3.0257 | 3.0257 | 3.0257 | 3.0257 | 2800.0 |
| 2007-02-02 07:33:00 | AAPL | Stock | 3.0175 | 3.0175 | 3.0175 | 3.0175 | 14000.0 |
| 2007-02-02 07:35:00 | AAPL | Stock | 3.015 | 3.015 | 3.015 | 3.015 | 2800.0 |
| 2007-02-02 07:46:00 | AAPL | Stock | 3.0143 | 3.0143 | 3.0143 | 3.0143 | 2800.0 |
| 2007-02-02 07:50:00 | AAPL | Stock | 3.0143 | 3.015 | 3.0143 | 3.015 | 20720.0 |
| 2007-02-02 07:52:00 | AAPL | Stock | 3.015 | 3.015 | 3.015 | 3.015 | 10136.0 |
| 2007-02-02 08:00:00 | AAPL | Stock | 3.0143 | 3.0179 | 3.0129 | 3.0143 | 137116.0 |
| 2007-02-02 08:01:00 | AAPL | Stock | 3.0125 | 3.0125 | 3.0096 | 3.0096 | 49924.0 |
| 2007-02-02 08:02:00 | AAPL | Stock | 3.01 | 3.01 | 3.0018 | 3.0018 | 226884.0 |
| 2007-02-02 08:03:00 | AAPL | Stock | 3.0018 | 3.0032 | 2.9979 | 3.0 | 118580.0 |
| 2007-02-02 08:04:00 | AAPL | Stock | 3.0 | 3.0 | 2.9964 | 2.9964 | 352800.0 |
| 2007-02-02 08:05:00 | AAPL | Stock | 2.9964 | 3.0 | 2.9929 | 2.9957 | 357476.0 |
| 2007-02-02 08:06:00 | AAPL | Stock | 2.9971 | 2.9982 | 2.9929 | 2.9961 | 224336.0 |
| 2007-02-02 08:07:00 | AAPL | Stock | 2.9932 | 2.9964 | 2.9911 | 2.9964 | 234164.0 |
| 2007-02-02 08:08:00 | AAPL | Stock | 2.9961 | 2.9964 | 2.9911 | 2.9911 | 287840.0 |
| 2007-02-02 08:09:00 | AAPL | Stock | 2.9932 | 2.9964 | 2.9918 | 2.9964 | 95200.0 |
| 2007-02-02 08:10:00 | AAPL | Stock | 2.9964 | 2.9964 | 2.9961 | 2.9964 | 164416.0 |
| 2007-02-02 08:11:00 | AAPL | Stock | 2.9964 | 2.9964 | 2.9964 | 2.9964 | 221760.0 |
| 2007-02-02 08:12:00 | AAPL | Stock | 2.9964 | 2.9964 | 2.9964 | 2.9964 | 78400.0 |
| 2007-02-02 08:13:00 | AAPL | Stock | 2.9996 | 3.0 | 2.9982 | 3.0 | 47600.0 |
| 2007-02-02 08:14:00 | AAPL | Stock | 2.9982 | 3.0 | 2.9982 | 2.9993 | 44800.0 |
| 2007-02-02 08:15:00 | AAPL | Stock | 2.9982 | 2.9982 | 2.9961 | 2.9964 | 91532.0 |
| 2007-02-02 08:16:00 | AAPL | Stock | 2.995 | 2.995 | 2.9946 | 2.995 | 45500.0 |
| 2007-02-02 08:17:00 | AAPL | Stock | 2.9954 | 2.9964 | 2.9929 | 2.9929 | 101080.0 |
| 2007-02-02 08:18:00 | AAPL | Stock | 2.9929 | 2.9946 | 2.9911 | 2.9946 | 315196.0 |
| 2007-02-02 08:19:00 | AAPL | Stock | 2.9929 | 2.9961 | 2.9914 | 2.9961 | 105168.0 |
| 2007-02-02 08:20:00 | AAPL | Stock | 2.9961 | 2.9964 | 2.9946 | 2.9946 | 72100.0 |
| 2007-02-02 08:21:00 | AAPL | Stock | 2.9946 | 2.9964 | 2.9946 | 2.9946 | 100800.0 |
| 2007-02-02 08:22:00 | AAPL | Stock | 2.9946 | 2.9946 | 2.9946 | 2.9946 | 2800.0 |
| 2007-02-02 08:23:00 | AAPL | Stock | 2.9946 | 2.9964 | 2.9946 | 2.9946 | 83300.0 |
| 2007-02-02 08:24:00 | AAPL | Stock | 2.9946 | 2.9946 | 2.9914 | 2.9929 | 100044.0 |
| 2007-02-02 08:25:00 | AAPL | Stock | 2.9946 | 2.9946 | 2.9946 | 2.9946 | 25200.0 |
| 2007-02-02 08:26:00 | AAPL | Stock | 2.9946 | 2.9964 | 2.9946 | 2.9964 | 47600.0 |
| 2007-02-02 08:27:00 | AAPL | Stock | 2.9968 | 2.9968 | 2.9964 | 2.9968 | 64400.0 |
| 2007-02-02 08:28:00 | AAPL | Stock | 2.9968 | 2.9982 | 2.9964 | 2.9968 | 318500.0 |
| 2007-02-02 08:29:00 | AAPL | Stock | 2.9968 | 2.9982 | 2.9968 | 2.9982 | 162820.0 |
| 2007-02-02 08:30:00 | AAPL | Stock | 2.9979 | 3.0 | 2.9979 | 2.9989 | 164080.0 |
| 2007-02-02 08:31:00 | AAPL | Stock | 2.9989 | 3.0054 | 2.9989 | 3.0004 | 450660.0 |
| 2007-02-02 08:32:00 | AAPL | Stock | 3.0043 | 3.0054 | 3.0018 | 3.0032 | 95200.0 |
| 2007-02-02 08:33:00 | AAPL | Stock | 3.0018 | 3.0036 | 3.0018 | 3.0036 | 125440.0 |
| 2007-02-02 08:34:00 | AAPL | Stock | 3.0036 | 3.005 | 3.0018 | 3.0036 | 165452.0 |
| 2007-02-02 08:35:00 | AAPL | Stock | 3.0036 | 3.0068 | 3.0036 | 3.0054 | 184800.0 |
| 2007-02-02 08:36:00 | AAPL | Stock | 3.005 | 3.0064 | 3.0043 | 3.0064 | 137760.0 |
| 2007-02-02 08:37:00 | AAPL | Stock | 3.0054 | 3.0054 | 3.0036 | 3.0036 | 180684.0 |
| 2007-02-02 08:38:00 | AAPL | Stock | 3.0054 | 3.0054 | 3.0036 | 3.0036 | 148960.0 |
| 2007-02-02 08:39:00 | AAPL | Stock | 3.0043 | 3.0054 | 3.0036 | 3.0036 | 61600.0 |
| 2007-02-02 08:40:00 | AAPL | Stock | 3.0036 | 3.0036 | 2.9989 | 3.0018 | 260400.0 |
| 2007-02-02 08:41:00 | AAPL | Stock | 2.9986 | 3.0 | 2.9979 | 2.9982 | 108276.0 |
> showing 50 of 729,842 rows — these rows as CSV