PREVIEW / stock_5min / 2005-03-30
file: by_date/stock_5min/2005/2005-03-30.parquet size: 2.7 MB rows: 197,005 symbols: 1,961
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 |
|---|---|---|---|---|---|---|---|
| 2005-03-30 08:00:00 | AAPL | Stock | 1.4964 | 1.4993 | 1.4964 | 1.4982 | 225400.0 |
| 2005-03-30 08:05:00 | AAPL | Stock | 1.4982 | 1.4982 | 1.4982 | 1.4982 | 5180.0 |
| 2005-03-30 08:10:00 | AAPL | Stock | 1.4979 | 1.4982 | 1.4979 | 1.4982 | 51800.0 |
| 2005-03-30 08:15:00 | AAPL | Stock | 1.4964 | 1.5 | 1.4964 | 1.5 | 196924.0 |
| 2005-03-30 08:20:00 | AAPL | Stock | 1.5 | 1.5 | 1.4982 | 1.4982 | 94780.0 |
| 2005-03-30 08:25:00 | AAPL | Stock | 1.4982 | 1.4982 | 1.4982 | 1.4982 | 72212.0 |
| 2005-03-30 08:30:00 | AAPL | Stock | 1.4986 | 1.4986 | 1.4986 | 1.4986 | 2800.0 |
| 2005-03-30 08:35:00 | AAPL | Stock | 1.4979 | 1.4979 | 1.4975 | 1.4975 | 111552.0 |
| 2005-03-30 08:40:00 | AAPL | Stock | 1.4982 | 1.4982 | 1.4982 | 1.4982 | 2800.0 |
| 2005-03-30 08:45:00 | AAPL | Stock | 1.4982 | 1.4982 | 1.4982 | 1.4982 | 16800.0 |
| 2005-03-30 08:50:00 | AAPL | Stock | 1.4982 | 1.4982 | 1.4982 | 1.4982 | 2800.0 |
| 2005-03-30 08:55:00 | AAPL | Stock | 1.4986 | 1.4986 | 1.4982 | 1.4982 | 106400.0 |
| 2005-03-30 09:00:00 | AAPL | Stock | 1.4982 | 1.4982 | 1.4982 | 1.4982 | 30800.0 |
| 2005-03-30 09:05:00 | AAPL | Stock | 1.4971 | 1.4971 | 1.4971 | 1.4971 | 18200.0 |
| 2005-03-30 09:10:00 | AAPL | Stock | 1.4982 | 1.4982 | 1.4971 | 1.4971 | 40600.0 |
| 2005-03-30 09:15:00 | AAPL | Stock | 1.4989 | 1.4989 | 1.4975 | 1.4975 | 14000.0 |
| 2005-03-30 09:20:00 | AAPL | Stock | 1.4989 | 1.5 | 1.4979 | 1.4986 | 233352.0 |
| 2005-03-30 09:25:00 | AAPL | Stock | 1.4964 | 1.5061 | 1.4964 | 1.5054 | 822220.0 |
| 2005-03-30 09:30:00 | AAPL | Stock | 1.5025 | 1.5054 | 1.4971 | 1.4993 | 12946024.0 |
| 2005-03-30 09:35:00 | AAPL | Stock | 1.4989 | 1.505 | 1.4986 | 1.5007 | 7058632.0 |
| 2005-03-30 09:40:00 | AAPL | Stock | 1.5007 | 1.5043 | 1.4996 | 1.5004 | 4825800.0 |
| 2005-03-30 09:45:00 | AAPL | Stock | 1.5007 | 1.5011 | 1.4936 | 1.4971 | 8847636.0 |
| 2005-03-30 09:50:00 | AAPL | Stock | 1.4971 | 1.5 | 1.4961 | 1.4964 | 3222016.0 |
| 2005-03-30 09:55:00 | AAPL | Stock | 1.4961 | 1.5 | 1.4961 | 1.4986 | 2924544.0 |
| 2005-03-30 10:00:00 | AAPL | Stock | 1.4987 | 1.5082 | 1.4986 | 1.5079 | 7558768.0 |
| 2005-03-30 10:05:00 | AAPL | Stock | 1.5079 | 1.5125 | 1.5061 | 1.5111 | 11279380.0 |
| 2005-03-30 10:10:00 | AAPL | Stock | 1.5121 | 1.5121 | 1.5057 | 1.5071 | 5945436.0 |
| 2005-03-30 10:15:00 | AAPL | Stock | 1.5071 | 1.5114 | 1.5068 | 1.5104 | 4769772.0 |
| 2005-03-30 10:20:00 | AAPL | Stock | 1.51 | 1.5143 | 1.5089 | 1.5139 | 6849080.0 |
| 2005-03-30 10:25:00 | AAPL | Stock | 1.5136 | 1.5139 | 1.5104 | 1.5132 | 5340692.0 |
| 2005-03-30 10:30:00 | AAPL | Stock | 1.5136 | 1.5186 | 1.5132 | 1.5164 | 10648400.0 |
| 2005-03-30 10:35:00 | AAPL | Stock | 1.5161 | 1.5175 | 1.5132 | 1.5132 | 6061244.0 |
| 2005-03-30 10:40:00 | AAPL | Stock | 1.5136 | 1.5143 | 1.5125 | 1.5129 | 4454996.0 |
| 2005-03-30 10:45:00 | AAPL | Stock | 1.5132 | 1.5193 | 1.5132 | 1.5186 | 8989876.0 |
| 2005-03-30 10:50:00 | AAPL | Stock | 1.5182 | 1.5225 | 1.5182 | 1.5214 | 11033596.0 |
| 2005-03-30 10:55:00 | AAPL | Stock | 1.5211 | 1.5218 | 1.5161 | 1.5182 | 4845988.0 |
| 2005-03-30 11:00:00 | AAPL | Stock | 1.5179 | 1.5196 | 1.5118 | 1.5129 | 7513212.0 |
| 2005-03-30 11:05:00 | AAPL | Stock | 1.5129 | 1.5164 | 1.5129 | 1.5161 | 3447556.0 |
| 2005-03-30 11:10:00 | AAPL | Stock | 1.5168 | 1.5168 | 1.5143 | 1.5154 | 2363928.0 |
| 2005-03-30 11:15:00 | AAPL | Stock | 1.5154 | 1.5193 | 1.5154 | 1.5193 | 3906560.0 |
| 2005-03-30 11:20:00 | AAPL | Stock | 1.5193 | 1.5193 | 1.5175 | 1.5182 | 2859416.0 |
| 2005-03-30 11:25:00 | AAPL | Stock | 1.5179 | 1.5189 | 1.5171 | 1.5175 | 2001636.0 |
| 2005-03-30 11:30:00 | AAPL | Stock | 1.5175 | 1.5179 | 1.5143 | 1.5171 | 3259900.0 |
| 2005-03-30 11:35:00 | AAPL | Stock | 1.5175 | 1.5179 | 1.5154 | 1.5168 | 2118620.0 |
| 2005-03-30 11:40:00 | AAPL | Stock | 1.5168 | 1.5196 | 1.5154 | 1.5196 | 3769612.0 |
| 2005-03-30 11:45:00 | AAPL | Stock | 1.5196 | 1.5218 | 1.5186 | 1.5218 | 6704124.0 |
| 2005-03-30 11:50:00 | AAPL | Stock | 1.5214 | 1.5229 | 1.5204 | 1.5207 | 4563888.0 |
| 2005-03-30 11:55:00 | AAPL | Stock | 1.5207 | 1.5254 | 1.5193 | 1.525 | 6309660.0 |
| 2005-03-30 12:00:00 | AAPL | Stock | 1.525 | 1.5268 | 1.5239 | 1.5264 | 5655188.0 |
| 2005-03-30 12:05:00 | AAPL | Stock | 1.5264 | 1.5279 | 1.5239 | 1.5239 | 4552856.0 |
> showing 50 of 197,005 rows — these rows as CSV