PREVIEW / stock_5min / 2005-04-13
file: by_date/stock_5min/2005/2005-04-13.parquet size: 2.6 MB rows: 189,881 symbols: 1,959
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-04-13 07:10:00 | AAPL | Stock | 1.5357 | 1.5357 | 1.5357 | 1.5357 | 14000.0 |
| 2005-04-13 07:15:00 | AAPL | Stock | 1.5357 | 1.5357 | 1.5357 | 1.5357 | 42000.0 |
| 2005-04-13 07:35:00 | AAPL | Stock | 1.5357 | 1.5357 | 1.5357 | 1.5357 | 2800.0 |
| 2005-04-13 07:40:00 | AAPL | Stock | 1.5357 | 1.5357 | 1.5357 | 1.5357 | 84000.0 |
| 2005-04-13 07:45:00 | AAPL | Stock | 1.5357 | 1.5393 | 1.5357 | 1.5393 | 61600.0 |
| 2005-04-13 08:00:00 | AAPL | Stock | 1.5357 | 1.5389 | 1.5321 | 1.5357 | 381640.0 |
| 2005-04-13 08:05:00 | AAPL | Stock | 1.5325 | 1.5325 | 1.5304 | 1.5314 | 280504.0 |
| 2005-04-13 08:10:00 | AAPL | Stock | 1.5318 | 1.5357 | 1.5286 | 1.5332 | 746116.0 |
| 2005-04-13 08:15:00 | AAPL | Stock | 1.5343 | 1.5343 | 1.5296 | 1.5304 | 571312.0 |
| 2005-04-13 08:20:00 | AAPL | Stock | 1.5304 | 1.5314 | 1.5293 | 1.5314 | 140000.0 |
| 2005-04-13 08:25:00 | AAPL | Stock | 1.5314 | 1.5321 | 1.5314 | 1.5318 | 47600.0 |
| 2005-04-13 08:30:00 | AAPL | Stock | 1.5314 | 1.5325 | 1.5304 | 1.5307 | 246400.0 |
| 2005-04-13 08:35:00 | AAPL | Stock | 1.5321 | 1.5346 | 1.5307 | 1.5346 | 239848.0 |
| 2005-04-13 08:40:00 | AAPL | Stock | 1.5307 | 1.5307 | 1.5304 | 1.5304 | 68432.0 |
| 2005-04-13 08:45:00 | AAPL | Stock | 1.5307 | 1.5307 | 1.5289 | 1.5296 | 89600.0 |
| 2005-04-13 08:50:00 | AAPL | Stock | 1.5296 | 1.53 | 1.5293 | 1.5296 | 100660.0 |
| 2005-04-13 08:55:00 | AAPL | Stock | 1.5293 | 1.53 | 1.5271 | 1.5293 | 136780.0 |
| 2005-04-13 09:00:00 | AAPL | Stock | 1.5289 | 1.5289 | 1.5271 | 1.5286 | 212240.0 |
| 2005-04-13 09:05:00 | AAPL | Stock | 1.5282 | 1.5282 | 1.525 | 1.5275 | 49616.0 |
| 2005-04-13 09:10:00 | AAPL | Stock | 1.5275 | 1.5286 | 1.5271 | 1.5286 | 253764.0 |
| 2005-04-13 09:15:00 | AAPL | Stock | 1.5282 | 1.5321 | 1.5282 | 1.53 | 423836.0 |
| 2005-04-13 09:20:00 | AAPL | Stock | 1.5318 | 1.5318 | 1.5279 | 1.5296 | 81340.0 |
| 2005-04-13 09:25:00 | AAPL | Stock | 1.5304 | 1.5354 | 1.5304 | 1.5346 | 3874416.0 |
| 2005-04-13 09:30:00 | AAPL | Stock | 1.5339 | 1.5354 | 1.5079 | 1.5089 | 38866436.0 |
| 2005-04-13 09:35:00 | AAPL | Stock | 1.5093 | 1.5145 | 1.505 | 1.51 | 29754704.0 |
| 2005-04-13 09:40:00 | AAPL | Stock | 1.5107 | 1.5132 | 1.505 | 1.5064 | 17028872.0 |
| 2005-04-13 09:45:00 | AAPL | Stock | 1.5068 | 1.5168 | 1.5039 | 1.5136 | 20750828.0 |
| 2005-04-13 09:50:00 | AAPL | Stock | 1.5136 | 1.5143 | 1.5029 | 1.5061 | 19864152.0 |
| 2005-04-13 09:55:00 | AAPL | Stock | 1.5057 | 1.5116 | 1.5029 | 1.5075 | 15963528.0 |
| 2005-04-13 10:00:00 | AAPL | Stock | 1.5071 | 1.5082 | 1.5043 | 1.5046 | 14845852.0 |
| 2005-04-13 10:05:00 | AAPL | Stock | 1.5043 | 1.5046 | 1.4989 | 1.4996 | 19585440.0 |
| 2005-04-13 10:10:00 | AAPL | Stock | 1.5 | 1.5107 | 1.4964 | 1.5018 | 23050664.0 |
| 2005-04-13 10:15:00 | AAPL | Stock | 1.5018 | 1.5046 | 1.4996 | 1.5011 | 18217024.0 |
| 2005-04-13 10:20:00 | AAPL | Stock | 1.5011 | 1.5057 | 1.5007 | 1.5036 | 14414652.0 |
| 2005-04-13 10:25:00 | AAPL | Stock | 1.5032 | 1.5039 | 1.4979 | 1.4979 | 12857208.0 |
| 2005-04-13 10:30:00 | AAPL | Stock | 1.4979 | 1.5068 | 1.4971 | 1.5025 | 13647116.0 |
| 2005-04-13 10:35:00 | AAPL | Stock | 1.5025 | 1.5043 | 1.4982 | 1.5011 | 10652432.0 |
| 2005-04-13 10:40:00 | AAPL | Stock | 1.5011 | 1.5054 | 1.4946 | 1.4946 | 14300804.0 |
| 2005-04-13 10:45:00 | AAPL | Stock | 1.4946 | 1.5 | 1.4939 | 1.4971 | 11966444.0 |
| 2005-04-13 10:50:00 | AAPL | Stock | 1.4971 | 1.5025 | 1.4971 | 1.4989 | 10597300.0 |
| 2005-04-13 10:55:00 | AAPL | Stock | 1.4993 | 1.4996 | 1.4968 | 1.4979 | 7860440.0 |
| 2005-04-13 11:00:00 | AAPL | Stock | 1.4982 | 1.5025 | 1.495 | 1.495 | 5898816.0 |
| 2005-04-13 11:05:00 | AAPL | Stock | 1.4946 | 1.5007 | 1.4896 | 1.492 | 15860320.0 |
| 2005-04-13 11:10:00 | AAPL | Stock | 1.4921 | 1.4921 | 1.4832 | 1.485 | 20345220.0 |
| 2005-04-13 11:15:00 | AAPL | Stock | 1.485 | 1.4857 | 1.4779 | 1.4846 | 20452684.0 |
| 2005-04-13 11:20:00 | AAPL | Stock | 1.4846 | 1.4857 | 1.4693 | 1.4696 | 22881936.0 |
| 2005-04-13 11:25:00 | AAPL | Stock | 1.4696 | 1.4839 | 1.4686 | 1.4768 | 22345344.0 |
| 2005-04-13 11:30:00 | AAPL | Stock | 1.4764 | 1.4854 | 1.4739 | 1.4846 | 26724684.0 |
| 2005-04-13 11:35:00 | AAPL | Stock | 1.485 | 1.49 | 1.4832 | 1.4889 | 19465208.0 |
| 2005-04-13 11:40:00 | AAPL | Stock | 1.4886 | 1.4907 | 1.4821 | 1.4825 | 15197980.0 |
> showing 50 of 189,881 rows — these rows as CSV