PREVIEW / stock_5min / 2009-05-01
file: by_date/stock_5min/2009/2009-05-01.parquet size: 4.5 MB rows: 310,749 symbols: 3,319
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 |
|---|---|---|---|---|---|---|---|
| 2009-05-01 05:55:00 | AAPL | Stock | 4.4964 | 4.4964 | 4.4964 | 4.4964 | 5600.0 |
| 2009-05-01 07:25:00 | AAPL | Stock | 4.5071 | 4.5071 | 4.5071 | 4.5071 | 2800.0 |
| 2009-05-01 08:00:00 | AAPL | Stock | 4.5079 | 4.5157 | 4.5071 | 4.5154 | 39620.0 |
| 2009-05-01 08:05:00 | AAPL | Stock | 4.5071 | 4.5143 | 4.5071 | 4.5143 | 57960.0 |
| 2009-05-01 08:10:00 | AAPL | Stock | 4.5125 | 4.5193 | 4.5125 | 4.5179 | 183960.0 |
| 2009-05-01 08:15:00 | AAPL | Stock | 4.5179 | 4.5193 | 4.5129 | 4.5171 | 244300.0 |
| 2009-05-01 08:20:00 | AAPL | Stock | 4.5157 | 4.5179 | 4.5157 | 4.5179 | 72800.0 |
| 2009-05-01 08:25:00 | AAPL | Stock | 4.5179 | 4.5179 | 4.5179 | 4.5179 | 16800.0 |
| 2009-05-01 08:30:00 | AAPL | Stock | 4.5121 | 4.5121 | 4.5121 | 4.5121 | 2800.0 |
| 2009-05-01 08:35:00 | AAPL | Stock | 4.51 | 4.51 | 4.51 | 4.51 | 2800.0 |
| 2009-05-01 08:40:00 | AAPL | Stock | 4.5089 | 4.5089 | 4.5071 | 4.5071 | 37660.0 |
| 2009-05-01 08:45:00 | AAPL | Stock | 4.5029 | 4.5036 | 4.5 | 4.5 | 75600.0 |
| 2009-05-01 08:50:00 | AAPL | Stock | 4.5007 | 4.5007 | 4.5007 | 4.5007 | 2800.0 |
| 2009-05-01 08:55:00 | AAPL | Stock | 4.5011 | 4.5011 | 4.4961 | 4.4964 | 100184.0 |
| 2009-05-01 09:00:00 | AAPL | Stock | 4.4968 | 4.4975 | 4.4939 | 4.4975 | 101892.0 |
| 2009-05-01 09:05:00 | AAPL | Stock | 4.4982 | 4.4982 | 4.4961 | 4.4979 | 45360.0 |
| 2009-05-01 09:10:00 | AAPL | Stock | 4.4957 | 4.4957 | 4.4921 | 4.4921 | 5600.0 |
| 2009-05-01 09:15:00 | AAPL | Stock | 4.4918 | 4.4918 | 4.4907 | 4.4907 | 16800.0 |
| 2009-05-01 09:20:00 | AAPL | Stock | 4.4957 | 4.4957 | 4.4886 | 4.4896 | 36400.0 |
| 2009-05-01 09:25:00 | AAPL | Stock | 4.4889 | 4.4954 | 4.4889 | 4.4954 | 72744.0 |
| 2009-05-01 09:30:00 | AAPL | Stock | 4.4929 | 4.5157 | 4.4929 | 4.5018 | 7120792.0 |
| 2009-05-01 09:35:00 | AAPL | Stock | 4.5025 | 4.5268 | 4.4971 | 4.5243 | 8377208.0 |
| 2009-05-01 09:40:00 | AAPL | Stock | 4.5243 | 4.5357 | 4.5239 | 4.5307 | 13660080.0 |
| 2009-05-01 09:45:00 | AAPL | Stock | 4.5307 | 4.5311 | 4.5157 | 4.5229 | 10307696.0 |
| 2009-05-01 09:50:00 | AAPL | Stock | 4.5239 | 4.5314 | 4.5179 | 4.5246 | 7460880.0 |
| 2009-05-01 09:55:00 | AAPL | Stock | 4.525 | 4.5311 | 4.5132 | 4.5307 | 8136464.0 |
| 2009-05-01 10:00:00 | AAPL | Stock | 4.5307 | 4.5382 | 4.5179 | 4.5361 | 8850716.0 |
| 2009-05-01 10:05:00 | AAPL | Stock | 4.5361 | 4.5375 | 4.5196 | 4.5196 | 6517700.0 |
| 2009-05-01 10:10:00 | AAPL | Stock | 4.52 | 4.5243 | 4.5143 | 4.5214 | 5604312.0 |
| 2009-05-01 10:15:00 | AAPL | Stock | 4.5214 | 4.5229 | 4.5036 | 4.5061 | 5288416.0 |
| 2009-05-01 10:20:00 | AAPL | Stock | 4.5064 | 4.5114 | 4.5 | 4.5046 | 5347832.0 |
| 2009-05-01 10:25:00 | AAPL | Stock | 4.5043 | 4.5154 | 4.5032 | 4.5075 | 4733988.0 |
| 2009-05-01 10:30:00 | AAPL | Stock | 4.5086 | 4.5093 | 4.5007 | 4.5061 | 2837660.0 |
| 2009-05-01 10:35:00 | AAPL | Stock | 4.5061 | 4.5132 | 4.5057 | 4.507 | 3175452.0 |
| 2009-05-01 10:40:00 | AAPL | Stock | 4.5075 | 4.5075 | 4.4936 | 4.5043 | 4463116.0 |
| 2009-05-01 10:45:00 | AAPL | Stock | 4.5046 | 4.5232 | 4.4996 | 4.5218 | 6431740.0 |
| 2009-05-01 10:50:00 | AAPL | Stock | 4.5225 | 4.5339 | 4.5179 | 4.5289 | 5412988.0 |
| 2009-05-01 10:55:00 | AAPL | Stock | 4.5289 | 4.5293 | 4.5232 | 4.5257 | 2612120.0 |
| 2009-05-01 11:00:00 | AAPL | Stock | 4.525 | 4.5261 | 4.5196 | 4.5207 | 2891812.0 |
| 2009-05-01 11:05:00 | AAPL | Stock | 4.5211 | 4.5336 | 4.5211 | 4.5314 | 4877712.0 |
| 2009-05-01 11:10:00 | AAPL | Stock | 4.5304 | 4.5354 | 4.525 | 4.5336 | 4726708.0 |
| 2009-05-01 11:15:00 | AAPL | Stock | 4.5332 | 4.5429 | 4.5311 | 4.5412 | 6924792.0 |
| 2009-05-01 11:20:00 | AAPL | Stock | 4.5418 | 4.5464 | 4.5382 | 4.5436 | 6032152.0 |
| 2009-05-01 11:25:00 | AAPL | Stock | 4.5436 | 4.5464 | 4.5411 | 4.5444 | 4106368.0 |
| 2009-05-01 11:30:00 | AAPL | Stock | 4.5443 | 4.5507 | 4.5432 | 4.5482 | 3814664.0 |
| 2009-05-01 11:35:00 | AAPL | Stock | 4.5482 | 4.5518 | 4.5429 | 4.5479 | 5067692.0 |
| 2009-05-01 11:40:00 | AAPL | Stock | 4.5482 | 4.5507 | 4.5457 | 4.5468 | 3032260.0 |
| 2009-05-01 11:45:00 | AAPL | Stock | 4.5468 | 4.5471 | 4.5411 | 4.5411 | 3830848.0 |
| 2009-05-01 11:50:00 | AAPL | Stock | 4.5411 | 4.5439 | 4.5311 | 4.5321 | 4403952.0 |
| 2009-05-01 11:55:00 | AAPL | Stock | 4.5321 | 4.5332 | 4.525 | 4.5279 | 3881612.0 |
> showing 50 of 310,749 rows — these rows as CSV