PREVIEW / stock_5min / 2008-02-15
file: by_date/stock_5min/2008/2008-02-15.parquet size: 4.3 MB rows: 316,665 symbols: 3,254
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 |
|---|---|---|---|---|---|---|---|
| 2008-02-15 07:05:00 | AAPL | Stock | 4.5386 | 4.5386 | 4.5386 | 4.5386 | 28000.0 |
| 2008-02-15 07:15:00 | AAPL | Stock | 4.5482 | 4.5482 | 4.5357 | 4.5357 | 70000.0 |
| 2008-02-15 07:35:00 | AAPL | Stock | 4.5429 | 4.5429 | 4.5375 | 4.5375 | 16800.0 |
| 2008-02-15 07:40:00 | AAPL | Stock | 4.5375 | 4.5375 | 4.5375 | 4.5375 | 5600.0 |
| 2008-02-15 07:50:00 | AAPL | Stock | 4.5375 | 4.5375 | 4.5375 | 4.5375 | 2800.0 |
| 2008-02-15 07:55:00 | AAPL | Stock | 4.5375 | 4.5375 | 4.52 | 4.52 | 45080.0 |
| 2008-02-15 08:00:00 | AAPL | Stock | 4.5336 | 4.5336 | 4.5089 | 4.5089 | 404796.0 |
| 2008-02-15 08:05:00 | AAPL | Stock | 4.5089 | 4.5179 | 4.5 | 4.5064 | 292292.0 |
| 2008-02-15 08:10:00 | AAPL | Stock | 4.5071 | 4.5107 | 4.5071 | 4.5107 | 73500.0 |
| 2008-02-15 08:15:00 | AAPL | Stock | 4.5107 | 4.5179 | 4.5107 | 4.5157 | 83720.0 |
| 2008-02-15 08:20:00 | AAPL | Stock | 4.5171 | 4.5179 | 4.5146 | 4.5146 | 100800.0 |
| 2008-02-15 08:25:00 | AAPL | Stock | 4.5161 | 4.5179 | 4.5146 | 4.5146 | 140728.0 |
| 2008-02-15 08:30:00 | AAPL | Stock | 4.5146 | 4.5146 | 4.4907 | 4.5 | 928088.0 |
| 2008-02-15 08:35:00 | AAPL | Stock | 4.5007 | 4.505 | 4.5 | 4.505 | 439404.0 |
| 2008-02-15 08:40:00 | AAPL | Stock | 4.5004 | 4.5107 | 4.5 | 4.5107 | 134036.0 |
| 2008-02-15 08:45:00 | AAPL | Stock | 4.5107 | 4.5107 | 4.4979 | 4.5 | 182616.0 |
| 2008-02-15 08:50:00 | AAPL | Stock | 4.5 | 4.5 | 4.495 | 4.4982 | 197400.0 |
| 2008-02-15 08:55:00 | AAPL | Stock | 4.4982 | 4.4989 | 4.4964 | 4.4971 | 211820.0 |
| 2008-02-15 09:00:00 | AAPL | Stock | 4.4964 | 4.5036 | 4.4957 | 4.5 | 382480.0 |
| 2008-02-15 09:05:00 | AAPL | Stock | 4.4989 | 4.5043 | 4.4975 | 4.5004 | 429016.0 |
| 2008-02-15 09:10:00 | AAPL | Stock | 4.5018 | 4.5089 | 4.5018 | 4.5064 | 52892.0 |
| 2008-02-15 09:15:00 | AAPL | Stock | 4.505 | 4.5107 | 4.505 | 4.5093 | 96068.0 |
| 2008-02-15 09:20:00 | AAPL | Stock | 4.5093 | 4.5107 | 4.5064 | 4.5107 | 187964.0 |
| 2008-02-15 09:25:00 | AAPL | Stock | 4.5096 | 4.5154 | 4.5054 | 4.5104 | 2371656.0 |
| 2008-02-15 09:30:00 | AAPL | Stock | 4.5107 | 4.5154 | 4.4929 | 4.5075 | 60748464.0 |
| 2008-02-15 09:35:00 | AAPL | Stock | 4.5082 | 4.5179 | 4.5018 | 4.5132 | 20489952.0 |
| 2008-02-15 09:40:00 | AAPL | Stock | 4.5129 | 4.5268 | 4.5117 | 4.5232 | 16827972.0 |
| 2008-02-15 09:45:00 | AAPL | Stock | 4.5232 | 4.5339 | 4.5179 | 4.5271 | 17263428.0 |
| 2008-02-15 09:50:00 | AAPL | Stock | 4.5246 | 4.5386 | 4.5186 | 4.5289 | 20552924.0 |
| 2008-02-15 09:55:00 | AAPL | Stock | 4.5286 | 4.5311 | 4.5036 | 4.5168 | 20450024.0 |
| 2008-02-15 10:00:00 | AAPL | Stock | 4.5164 | 4.5261 | 4.5125 | 4.5179 | 12833380.0 |
| 2008-02-15 10:05:00 | AAPL | Stock | 4.5186 | 4.5186 | 4.4964 | 4.5025 | 12618928.0 |
| 2008-02-15 10:10:00 | AAPL | Stock | 4.5025 | 4.5086 | 4.4857 | 4.4982 | 20102012.0 |
| 2008-02-15 10:15:00 | AAPL | Stock | 4.4979 | 4.5029 | 4.4821 | 4.5029 | 13152580.0 |
| 2008-02-15 10:20:00 | AAPL | Stock | 4.5029 | 4.5061 | 4.4879 | 4.4922 | 8371832.0 |
| 2008-02-15 10:25:00 | AAPL | Stock | 4.4929 | 4.5143 | 4.4929 | 4.5104 | 13016080.0 |
| 2008-02-15 10:30:00 | AAPL | Stock | 4.5097 | 4.5325 | 4.5064 | 4.525 | 16884420.0 |
| 2008-02-15 10:35:00 | AAPL | Stock | 4.525 | 4.5314 | 4.515 | 4.5164 | 10552696.0 |
| 2008-02-15 10:40:00 | AAPL | Stock | 4.5164 | 4.5204 | 4.5089 | 4.515 | 8825460.0 |
| 2008-02-15 10:45:00 | AAPL | Stock | 4.5146 | 4.5157 | 4.5004 | 4.5018 | 8314964.0 |
| 2008-02-15 10:50:00 | AAPL | Stock | 4.5018 | 4.5089 | 4.4911 | 4.4964 | 8563940.0 |
| 2008-02-15 10:55:00 | AAPL | Stock | 4.4957 | 4.4996 | 4.4875 | 4.4918 | 8841728.0 |
| 2008-02-15 11:00:00 | AAPL | Stock | 4.4895 | 4.4943 | 4.4857 | 4.4858 | 7121968.0 |
| 2008-02-15 11:05:00 | AAPL | Stock | 4.4857 | 4.4871 | 4.4732 | 4.4779 | 13282276.0 |
| 2008-02-15 11:10:00 | AAPL | Stock | 4.4775 | 4.4889 | 4.475 | 4.4825 | 9295076.0 |
| 2008-02-15 11:15:00 | AAPL | Stock | 4.4829 | 4.4854 | 4.4732 | 4.4764 | 6500508.0 |
| 2008-02-15 11:20:00 | AAPL | Stock | 4.4761 | 4.4786 | 4.4696 | 4.4736 | 9301684.0 |
| 2008-02-15 11:25:00 | AAPL | Stock | 4.4736 | 4.4756 | 4.4661 | 4.4689 | 9245768.0 |
| 2008-02-15 11:30:00 | AAPL | Stock | 4.4694 | 4.4718 | 4.4671 | 4.4682 | 8173844.0 |
| 2008-02-15 11:35:00 | AAPL | Stock | 4.4689 | 4.4689 | 4.4468 | 4.4511 | 18250680.0 |
> showing 50 of 316,665 rows — these rows as CSV