PREVIEW / stock_5min / 2007-04-27
file: by_date/stock_5min/2007/2007-04-27.parquet size: 3.6 MB rows: 258,619 symbols: 2,617
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-04-27 05:10:00 | AAPL | Stock | 3.5221 | 3.5221 | 3.5221 | 3.5221 | 2800.0 |
| 2007-04-27 05:15:00 | AAPL | Stock | 3.5221 | 3.5221 | 3.5221 | 3.5221 | 5600.0 |
| 2007-04-27 05:35:00 | AAPL | Stock | 3.5225 | 3.5225 | 3.5225 | 3.5225 | 2800.0 |
| 2007-04-27 06:30:00 | AAPL | Stock | 3.53 | 3.53 | 3.53 | 3.53 | 5600.0 |
| 2007-04-27 06:35:00 | AAPL | Stock | 3.53 | 3.53 | 3.53 | 3.53 | 5600.0 |
| 2007-04-27 07:00:00 | AAPL | Stock | 3.5304 | 3.5304 | 3.5204 | 3.5204 | 28000.0 |
| 2007-04-27 07:20:00 | AAPL | Stock | 3.5214 | 3.5286 | 3.5214 | 3.5286 | 22400.0 |
| 2007-04-27 07:30:00 | AAPL | Stock | 3.5321 | 3.5321 | 3.5321 | 3.5321 | 8400.0 |
| 2007-04-27 07:35:00 | AAPL | Stock | 3.5232 | 3.5232 | 3.5232 | 3.5232 | 14000.0 |
| 2007-04-27 07:40:00 | AAPL | Stock | 3.5232 | 3.5232 | 3.5182 | 3.5182 | 32200.0 |
| 2007-04-27 07:45:00 | AAPL | Stock | 3.5161 | 3.5179 | 3.5161 | 3.5179 | 15680.0 |
| 2007-04-27 07:50:00 | AAPL | Stock | 3.5179 | 3.5179 | 3.5168 | 3.5168 | 20328.0 |
| 2007-04-27 07:55:00 | AAPL | Stock | 3.5179 | 3.5179 | 3.5164 | 3.5164 | 62804.0 |
| 2007-04-27 08:00:00 | AAPL | Stock | 3.5214 | 3.5214 | 3.5061 | 3.5071 | 452340.0 |
| 2007-04-27 08:05:00 | AAPL | Stock | 3.5071 | 3.5096 | 3.5046 | 3.5046 | 245560.0 |
| 2007-04-27 08:10:00 | AAPL | Stock | 3.5036 | 3.5071 | 3.5 | 3.5071 | 246960.0 |
| 2007-04-27 08:15:00 | AAPL | Stock | 3.5071 | 3.5089 | 3.5046 | 3.5046 | 121940.0 |
| 2007-04-27 08:20:00 | AAPL | Stock | 3.5046 | 3.5071 | 3.5046 | 3.5046 | 281288.0 |
| 2007-04-27 08:25:00 | AAPL | Stock | 3.5071 | 3.5086 | 3.5046 | 3.5071 | 168308.0 |
| 2007-04-27 08:30:00 | AAPL | Stock | 3.5071 | 3.5086 | 3.4911 | 3.4964 | 1749384.0 |
| 2007-04-27 08:35:00 | AAPL | Stock | 3.4982 | 3.4982 | 3.4939 | 3.4939 | 859600.0 |
| 2007-04-27 08:40:00 | AAPL | Stock | 3.4943 | 3.4961 | 3.4929 | 3.4939 | 270228.0 |
| 2007-04-27 08:45:00 | AAPL | Stock | 3.4939 | 3.4961 | 3.4929 | 3.4954 | 1580124.0 |
| 2007-04-27 08:50:00 | AAPL | Stock | 3.4954 | 3.4954 | 3.4936 | 3.495 | 288316.0 |
| 2007-04-27 08:55:00 | AAPL | Stock | 3.495 | 3.4964 | 3.495 | 3.4964 | 305004.0 |
| 2007-04-27 09:00:00 | AAPL | Stock | 3.4957 | 3.5071 | 3.4957 | 3.5054 | 240604.0 |
| 2007-04-27 09:05:00 | AAPL | Stock | 3.5054 | 3.5146 | 3.5036 | 3.5143 | 848456.0 |
| 2007-04-27 09:10:00 | AAPL | Stock | 3.5139 | 3.5168 | 3.5107 | 3.5107 | 480200.0 |
| 2007-04-27 09:15:00 | AAPL | Stock | 3.5107 | 3.5118 | 3.5079 | 3.5118 | 117600.0 |
| 2007-04-27 09:20:00 | AAPL | Stock | 3.5107 | 3.5204 | 3.5089 | 3.5204 | 337176.0 |
| 2007-04-27 09:25:00 | AAPL | Stock | 3.5214 | 3.5214 | 3.5043 | 3.5054 | 630252.0 |
| 2007-04-27 09:30:00 | AAPL | Stock | 3.5064 | 3.5071 | 3.4889 | 3.4954 | 29193080.0 |
| 2007-04-27 09:35:00 | AAPL | Stock | 3.4943 | 3.5089 | 3.4929 | 3.4968 | 22539020.0 |
| 2007-04-27 09:40:00 | AAPL | Stock | 3.4964 | 3.5264 | 3.4946 | 3.5193 | 16181872.0 |
| 2007-04-27 09:45:00 | AAPL | Stock | 3.5196 | 3.5339 | 3.5121 | 3.5225 | 18173596.0 |
| 2007-04-27 09:50:00 | AAPL | Stock | 3.5228 | 3.5236 | 3.5182 | 3.5214 | 7572264.0 |
| 2007-04-27 09:55:00 | AAPL | Stock | 3.5214 | 3.5232 | 3.5082 | 3.5129 | 7480340.0 |
| 2007-04-27 10:00:00 | AAPL | Stock | 3.5129 | 3.5246 | 3.5096 | 3.5232 | 13200880.0 |
| 2007-04-27 10:05:00 | AAPL | Stock | 3.5232 | 3.5464 | 3.5232 | 3.5379 | 29709904.0 |
| 2007-04-27 10:10:00 | AAPL | Stock | 3.5381 | 3.5411 | 3.5329 | 3.5336 | 12099388.0 |
| 2007-04-27 10:15:00 | AAPL | Stock | 3.5339 | 3.5489 | 3.5329 | 3.5386 | 15976912.0 |
| 2007-04-27 10:20:00 | AAPL | Stock | 3.5393 | 3.5446 | 3.5286 | 3.535 | 12264112.0 |
| 2007-04-27 10:25:00 | AAPL | Stock | 3.5346 | 3.5382 | 3.5332 | 3.5361 | 5831084.0 |
| 2007-04-27 10:30:00 | AAPL | Stock | 3.5357 | 3.5379 | 3.5207 | 3.5239 | 12364436.0 |
| 2007-04-27 10:35:00 | AAPL | Stock | 3.5239 | 3.5254 | 3.5182 | 3.5218 | 8849960.0 |
| 2007-04-27 10:40:00 | AAPL | Stock | 3.5218 | 3.5218 | 3.5089 | 3.5111 | 11881324.0 |
| 2007-04-27 10:45:00 | AAPL | Stock | 3.5111 | 3.5139 | 3.5057 | 3.5129 | 8722700.0 |
| 2007-04-27 10:50:00 | AAPL | Stock | 3.5132 | 3.5211 | 3.5129 | 3.5171 | 8516256.0 |
| 2007-04-27 10:55:00 | AAPL | Stock | 3.5171 | 3.5246 | 3.5168 | 3.5243 | 5243224.0 |
| 2007-04-27 11:00:00 | AAPL | Stock | 3.5239 | 3.525 | 3.5179 | 3.5243 | 6467412.0 |
> showing 50 of 258,619 rows — these rows as CSV