PREVIEW / stock_5min / 2009-12-29
file: by_date/stock_5min/2009/2009-12-29.parquet size: 4.5 MB rows: 307,463 symbols: 3,467
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-12-29 04:25:00 | AAPL | Stock | 7.5714 | 7.5714 | 7.5714 | 7.5714 | 5600.0 |
| 2009-12-29 05:20:00 | AAPL | Stock | 7.5714 | 7.5714 | 7.5714 | 7.5714 | 2800.0 |
| 2009-12-29 05:45:00 | AAPL | Stock | 7.575 | 7.575 | 7.575 | 7.575 | 2800.0 |
| 2009-12-29 05:55:00 | AAPL | Stock | 7.5714 | 7.5714 | 7.5714 | 7.5714 | 2800.0 |
| 2009-12-29 06:20:00 | AAPL | Stock | 7.5707 | 7.5707 | 7.5707 | 7.5707 | 2800.0 |
| 2009-12-29 07:00:00 | AAPL | Stock | 7.5836 | 7.5836 | 7.5821 | 7.5821 | 16800.0 |
| 2009-12-29 07:15:00 | AAPL | Stock | 7.5814 | 7.5814 | 7.5814 | 7.5814 | 5600.0 |
| 2009-12-29 07:30:00 | AAPL | Stock | 7.5782 | 7.5821 | 7.5782 | 7.5821 | 16940.0 |
| 2009-12-29 07:35:00 | AAPL | Stock | 7.585 | 7.585 | 7.585 | 7.585 | 2800.0 |
| 2009-12-29 07:50:00 | AAPL | Stock | 7.5875 | 7.5993 | 7.5875 | 7.5993 | 16800.0 |
| 2009-12-29 07:55:00 | AAPL | Stock | 7.5982 | 7.5982 | 7.5929 | 7.5929 | 19600.0 |
| 2009-12-29 08:00:00 | AAPL | Stock | 7.5893 | 7.6021 | 7.5893 | 7.5946 | 702576.0 |
| 2009-12-29 08:05:00 | AAPL | Stock | 7.5946 | 7.6018 | 7.5946 | 7.5946 | 276388.0 |
| 2009-12-29 08:10:00 | AAPL | Stock | 7.5946 | 7.6036 | 7.5911 | 7.5982 | 171052.0 |
| 2009-12-29 08:15:00 | AAPL | Stock | 7.5968 | 7.6036 | 7.5911 | 7.595 | 325024.0 |
| 2009-12-29 08:20:00 | AAPL | Stock | 7.6007 | 7.6007 | 7.5929 | 7.5968 | 74900.0 |
| 2009-12-29 08:25:00 | AAPL | Stock | 7.5936 | 7.5946 | 7.5812 | 7.5889 | 415800.0 |
| 2009-12-29 08:30:00 | AAPL | Stock | 7.5857 | 7.5911 | 7.5836 | 7.5889 | 209440.0 |
| 2009-12-29 08:35:00 | AAPL | Stock | 7.5886 | 7.5893 | 7.5804 | 7.5821 | 160804.0 |
| 2009-12-29 08:40:00 | AAPL | Stock | 7.5855 | 7.5889 | 7.5823 | 7.5889 | 82600.0 |
| 2009-12-29 08:45:00 | AAPL | Stock | 7.5879 | 7.5882 | 7.5839 | 7.5839 | 63000.0 |
| 2009-12-29 08:50:00 | AAPL | Stock | 7.5839 | 7.5875 | 7.5839 | 7.5875 | 153720.0 |
| 2009-12-29 08:55:00 | AAPL | Stock | 7.5875 | 7.5875 | 7.5821 | 7.5821 | 201992.0 |
| 2009-12-29 09:00:00 | AAPL | Stock | 7.5814 | 7.5857 | 7.5814 | 7.5839 | 75292.0 |
| 2009-12-29 09:05:00 | AAPL | Stock | 7.5839 | 7.5839 | 7.5786 | 7.5786 | 277788.0 |
| 2009-12-29 09:10:00 | AAPL | Stock | 7.5786 | 7.5857 | 7.5775 | 7.5857 | 169260.0 |
| 2009-12-29 09:15:00 | AAPL | Stock | 7.5857 | 7.5871 | 7.5771 | 7.5786 | 95200.0 |
| 2009-12-29 09:20:00 | AAPL | Stock | 7.5793 | 7.585 | 7.5782 | 7.5839 | 151900.0 |
| 2009-12-29 09:25:00 | AAPL | Stock | 7.5807 | 7.5957 | 7.5789 | 7.5957 | 647276.0 |
| 2009-12-29 09:30:00 | AAPL | Stock | 7.5925 | 7.5971 | 7.5636 | 7.5661 | 18350192.0 |
| 2009-12-29 09:35:00 | AAPL | Stock | 7.5664 | 7.5807 | 7.5575 | 7.5719 | 10232376.0 |
| 2009-12-29 09:40:00 | AAPL | Stock | 7.5718 | 7.5743 | 7.5371 | 7.54 | 20933416.0 |
| 2009-12-29 09:45:00 | AAPL | Stock | 7.5421 | 7.5464 | 7.5357 | 7.5383 | 8478736.0 |
| 2009-12-29 09:50:00 | AAPL | Stock | 7.5383 | 7.5482 | 7.5279 | 7.5432 | 11978456.0 |
| 2009-12-29 09:55:00 | AAPL | Stock | 7.5439 | 7.5532 | 7.5243 | 7.5479 | 10795484.0 |
| 2009-12-29 10:00:00 | AAPL | Stock | 7.5479 | 7.5511 | 7.5218 | 7.5231 | 10107076.0 |
| 2009-12-29 10:05:00 | AAPL | Stock | 7.5232 | 7.5411 | 7.5007 | 7.5134 | 14108948.0 |
| 2009-12-29 10:10:00 | AAPL | Stock | 7.5139 | 7.5175 | 7.5018 | 7.51 | 5476996.0 |
| 2009-12-29 10:15:00 | AAPL | Stock | 7.51 | 7.5168 | 7.5046 | 7.5154 | 4820060.0 |
| 2009-12-29 10:20:00 | AAPL | Stock | 7.5146 | 7.5275 | 7.5143 | 7.5233 | 6268136.0 |
| 2009-12-29 10:25:00 | AAPL | Stock | 7.5236 | 7.5339 | 7.5236 | 7.5307 | 5021352.0 |
| 2009-12-29 10:30:00 | AAPL | Stock | 7.5304 | 7.5479 | 7.5286 | 7.5461 | 6078548.0 |
| 2009-12-29 10:35:00 | AAPL | Stock | 7.5461 | 7.5461 | 7.5336 | 7.5393 | 6565944.0 |
| 2009-12-29 10:40:00 | AAPL | Stock | 7.5389 | 7.5436 | 7.535 | 7.5379 | 4219180.0 |
| 2009-12-29 10:45:00 | AAPL | Stock | 7.5379 | 7.5411 | 7.5289 | 7.5336 | 4150972.0 |
| 2009-12-29 10:50:00 | AAPL | Stock | 7.5336 | 7.5411 | 7.5232 | 7.5254 | 6395844.0 |
| 2009-12-29 10:55:00 | AAPL | Stock | 7.5257 | 7.5321 | 7.5236 | 7.5268 | 3211460.0 |
| 2009-12-29 11:00:00 | AAPL | Stock | 7.5261 | 7.5321 | 7.5179 | 7.5189 | 5147100.0 |
| 2009-12-29 11:05:00 | AAPL | Stock | 7.5193 | 7.5232 | 7.5018 | 7.5054 | 6895980.0 |
| 2009-12-29 11:10:00 | AAPL | Stock | 7.5054 | 7.5059 | 7.4946 | 7.5 | 8842540.0 |
> showing 50 of 307,463 rows — these rows as CSV