PREVIEW / stock_5min / 2003-11-05
file: by_date/stock_5min/2003/2003-11-05.parquet size: 2.2 MB rows: 162,074 symbols: 1,654
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 |
|---|---|---|---|---|---|---|---|
| 2003-11-05 08:00:00 | AAPL | Stock | 0.4091 | 0.4091 | 0.4091 | 0.4091 | 11200.0 |
| 2003-11-05 08:30:00 | AAPL | Stock | 0.4071 | 0.4071 | 0.4071 | 0.4071 | 72800.0 |
| 2003-11-05 08:55:00 | AAPL | Stock | 0.4063 | 0.4063 | 0.4063 | 0.4063 | 22400.0 |
| 2003-11-05 09:00:00 | AAPL | Stock | 0.4089 | 0.4089 | 0.4064 | 0.4064 | 98000.0 |
| 2003-11-05 09:10:00 | AAPL | Stock | 0.4063 | 0.4082 | 0.4063 | 0.4082 | 112000.0 |
| 2003-11-05 09:20:00 | AAPL | Stock | 0.4084 | 0.4084 | 0.4084 | 0.4084 | 16800.0 |
| 2003-11-05 09:25:00 | AAPL | Stock | 0.4084 | 0.4084 | 0.4073 | 0.4073 | 176960.0 |
| 2003-11-05 09:30:00 | AAPL | Stock | 0.4075 | 0.4124 | 0.4068 | 0.4102 | 6325312.0 |
| 2003-11-05 09:35:00 | AAPL | Stock | 0.4102 | 0.4114 | 0.4086 | 0.4098 | 4800656.0 |
| 2003-11-05 09:40:00 | AAPL | Stock | 0.4098 | 0.4107 | 0.4068 | 0.4089 | 4666480.0 |
| 2003-11-05 09:45:00 | AAPL | Stock | 0.4089 | 0.4089 | 0.4076 | 0.408 | 7192864.0 |
| 2003-11-05 09:50:00 | AAPL | Stock | 0.408 | 0.4093 | 0.408 | 0.4089 | 1785672.0 |
| 2003-11-05 09:55:00 | AAPL | Stock | 0.4089 | 0.4104 | 0.408 | 0.4098 | 3827320.0 |
| 2003-11-05 10:00:00 | AAPL | Stock | 0.4098 | 0.4098 | 0.4079 | 0.4084 | 4065992.0 |
| 2003-11-05 10:05:00 | AAPL | Stock | 0.4082 | 0.4091 | 0.4082 | 0.4091 | 744800.0 |
| 2003-11-05 10:10:00 | AAPL | Stock | 0.4091 | 0.4091 | 0.4082 | 0.4082 | 430976.0 |
| 2003-11-05 10:15:00 | AAPL | Stock | 0.4082 | 0.4082 | 0.4074 | 0.4077 | 2023112.0 |
| 2003-11-05 10:20:00 | AAPL | Stock | 0.4077 | 0.408 | 0.4073 | 0.4075 | 1422288.0 |
| 2003-11-05 10:25:00 | AAPL | Stock | 0.4075 | 0.408 | 0.405 | 0.405 | 2343824.0 |
| 2003-11-05 10:30:00 | AAPL | Stock | 0.405 | 0.4063 | 0.403 | 0.4063 | 1966496.0 |
| 2003-11-05 10:35:00 | AAPL | Stock | 0.4061 | 0.4061 | 0.4045 | 0.4048 | 5073264.0 |
| 2003-11-05 10:40:00 | AAPL | Stock | 0.4045 | 0.4054 | 0.4045 | 0.4045 | 1312528.0 |
| 2003-11-05 10:45:00 | AAPL | Stock | 0.4043 | 0.4045 | 0.4013 | 0.4016 | 4607064.0 |
| 2003-11-05 10:50:00 | AAPL | Stock | 0.4018 | 0.4041 | 0.4016 | 0.4034 | 4630192.0 |
| 2003-11-05 10:55:00 | AAPL | Stock | 0.4034 | 0.4052 | 0.4027 | 0.4052 | 2141720.0 |
| 2003-11-05 11:00:00 | AAPL | Stock | 0.4051 | 0.4052 | 0.4039 | 0.4046 | 3854200.0 |
| 2003-11-05 11:05:00 | AAPL | Stock | 0.4048 | 0.4054 | 0.4046 | 0.405 | 1168160.0 |
| 2003-11-05 11:10:00 | AAPL | Stock | 0.4048 | 0.4052 | 0.4048 | 0.4048 | 4442200.0 |
| 2003-11-05 11:15:00 | AAPL | Stock | 0.4052 | 0.4063 | 0.4052 | 0.4052 | 1974672.0 |
| 2003-11-05 11:20:00 | AAPL | Stock | 0.4054 | 0.4059 | 0.4039 | 0.4059 | 9257024.0 |
| 2003-11-05 11:25:00 | AAPL | Stock | 0.4046 | 0.4046 | 0.4039 | 0.4045 | 674968.0 |
| 2003-11-05 11:30:00 | AAPL | Stock | 0.4043 | 0.4059 | 0.4043 | 0.4058 | 969416.0 |
| 2003-11-05 11:35:00 | AAPL | Stock | 0.4059 | 0.4063 | 0.4057 | 0.4063 | 1843520.0 |
| 2003-11-05 11:40:00 | AAPL | Stock | 0.4061 | 0.4066 | 0.4059 | 0.4059 | 1254400.0 |
| 2003-11-05 11:45:00 | AAPL | Stock | 0.4063 | 0.4064 | 0.4061 | 0.4063 | 310912.0 |
| 2003-11-05 11:50:00 | AAPL | Stock | 0.4064 | 0.4064 | 0.4048 | 0.4048 | 19045600.0 |
| 2003-11-05 11:55:00 | AAPL | Stock | 0.4048 | 0.4055 | 0.4048 | 0.4054 | 11860128.0 |
| 2003-11-05 12:00:00 | AAPL | Stock | 0.4054 | 0.4054 | 0.4052 | 0.4052 | 411824.0 |
| 2003-11-05 12:05:00 | AAPL | Stock | 0.4052 | 0.4057 | 0.4048 | 0.4057 | 1524992.0 |
| 2003-11-05 12:10:00 | AAPL | Stock | 0.4057 | 0.4057 | 0.4055 | 0.4055 | 544208.0 |
| 2003-11-05 12:15:00 | AAPL | Stock | 0.4056 | 0.4057 | 0.4052 | 0.4057 | 1657600.0 |
| 2003-11-05 12:20:00 | AAPL | Stock | 0.4057 | 0.4059 | 0.4055 | 0.4059 | 739200.0 |
| 2003-11-05 12:25:00 | AAPL | Stock | 0.4057 | 0.4059 | 0.4057 | 0.4057 | 285600.0 |
| 2003-11-05 12:30:00 | AAPL | Stock | 0.4057 | 0.4071 | 0.4057 | 0.407 | 430080.0 |
| 2003-11-05 12:35:00 | AAPL | Stock | 0.4071 | 0.4071 | 0.407 | 0.4071 | 375200.0 |
| 2003-11-05 12:40:00 | AAPL | Stock | 0.4071 | 0.4071 | 0.407 | 0.4071 | 330400.0 |
| 2003-11-05 12:45:00 | AAPL | Stock | 0.407 | 0.407 | 0.4064 | 0.4064 | 420000.0 |
| 2003-11-05 12:50:00 | AAPL | Stock | 0.4066 | 0.4066 | 0.4063 | 0.4063 | 784560.0 |
| 2003-11-05 12:55:00 | AAPL | Stock | 0.4064 | 0.4071 | 0.4057 | 0.4066 | 6516496.0 |
| 2003-11-05 13:00:00 | AAPL | Stock | 0.4064 | 0.4071 | 0.4064 | 0.4071 | 383824.0 |
> showing 50 of 162,074 rows — these rows as CSV