PREVIEW / stock_5min / 2008-11-10
file: by_date/stock_5min/2008/2008-11-10.parquet size: 4.3 MB rows: 308,719 symbols: 3,308
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-11-10 07:00:00 | AAPL | Stock | 3.5839 | 3.5839 | 3.5839 | 3.5839 | 3920.0 |
| 2008-11-10 07:15:00 | AAPL | Stock | 3.5882 | 3.6429 | 3.5882 | 3.6161 | 78008.0 |
| 2008-11-10 07:20:00 | AAPL | Stock | 3.6161 | 3.6161 | 3.6161 | 3.6161 | 22400.0 |
| 2008-11-10 07:25:00 | AAPL | Stock | 3.6157 | 3.6161 | 3.6068 | 3.6071 | 25200.0 |
| 2008-11-10 07:35:00 | AAPL | Stock | 3.6036 | 3.6036 | 3.6036 | 3.6036 | 10892.0 |
| 2008-11-10 07:45:00 | AAPL | Stock | 3.6 | 3.6 | 3.6 | 3.6 | 14000.0 |
| 2008-11-10 07:50:00 | AAPL | Stock | 3.6018 | 3.6018 | 3.6018 | 3.6018 | 29400.0 |
| 2008-11-10 07:55:00 | AAPL | Stock | 3.6 | 3.6014 | 3.6 | 3.6014 | 65604.0 |
| 2008-11-10 08:00:00 | AAPL | Stock | 3.6014 | 3.6214 | 3.5929 | 3.6143 | 743512.0 |
| 2008-11-10 08:05:00 | AAPL | Stock | 3.6143 | 3.6143 | 3.6039 | 3.6039 | 119112.0 |
| 2008-11-10 08:10:00 | AAPL | Stock | 3.6068 | 3.6071 | 3.5911 | 3.6007 | 173208.0 |
| 2008-11-10 08:15:00 | AAPL | Stock | 3.6007 | 3.6071 | 3.5857 | 3.5911 | 321496.0 |
| 2008-11-10 08:20:00 | AAPL | Stock | 3.5889 | 3.5929 | 3.5857 | 3.5893 | 226772.0 |
| 2008-11-10 08:25:00 | AAPL | Stock | 3.5893 | 3.5896 | 3.5857 | 3.5893 | 115640.0 |
| 2008-11-10 08:30:00 | AAPL | Stock | 3.5889 | 3.5893 | 3.5864 | 3.5875 | 27860.0 |
| 2008-11-10 08:35:00 | AAPL | Stock | 3.5875 | 3.5889 | 3.5846 | 3.585 | 138040.0 |
| 2008-11-10 08:40:00 | AAPL | Stock | 3.5854 | 3.5857 | 3.585 | 3.5857 | 237468.0 |
| 2008-11-10 08:45:00 | AAPL | Stock | 3.5875 | 3.5975 | 3.5875 | 3.5896 | 274596.0 |
| 2008-11-10 08:50:00 | AAPL | Stock | 3.5929 | 3.5957 | 3.5889 | 3.5889 | 208180.0 |
| 2008-11-10 08:55:00 | AAPL | Stock | 3.5889 | 3.5889 | 3.5857 | 3.5871 | 163632.0 |
| 2008-11-10 09:00:00 | AAPL | Stock | 3.5875 | 3.5875 | 3.5757 | 3.5818 | 317996.0 |
| 2008-11-10 09:05:00 | AAPL | Stock | 3.5821 | 3.5825 | 3.5714 | 3.5725 | 257936.0 |
| 2008-11-10 09:10:00 | AAPL | Stock | 3.5729 | 3.5757 | 3.5675 | 3.575 | 277508.0 |
| 2008-11-10 09:15:00 | AAPL | Stock | 3.575 | 3.5811 | 3.575 | 3.5786 | 91980.0 |
| 2008-11-10 09:20:00 | AAPL | Stock | 3.5754 | 3.5757 | 3.5679 | 3.5696 | 210280.0 |
| 2008-11-10 09:25:00 | AAPL | Stock | 3.5689 | 3.5889 | 3.5679 | 3.5814 | 1726340.0 |
| 2008-11-10 09:30:00 | AAPL | Stock | 3.5814 | 3.5821 | 3.5489 | 3.5664 | 22361192.0 |
| 2008-11-10 09:35:00 | AAPL | Stock | 3.5661 | 3.5857 | 3.5339 | 3.5343 | 31006808.0 |
| 2008-11-10 09:40:00 | AAPL | Stock | 3.5339 | 3.5475 | 3.5179 | 3.5179 | 23657788.0 |
| 2008-11-10 09:45:00 | AAPL | Stock | 3.5179 | 3.5243 | 3.5043 | 3.5057 | 23183664.0 |
| 2008-11-10 09:50:00 | AAPL | Stock | 3.5054 | 3.5186 | 3.495 | 3.5111 | 21141260.0 |
| 2008-11-10 09:55:00 | AAPL | Stock | 3.5118 | 3.5332 | 3.5004 | 3.5311 | 15366848.0 |
| 2008-11-10 10:00:00 | AAPL | Stock | 3.5325 | 3.5429 | 3.5196 | 3.5329 | 14466844.0 |
| 2008-11-10 10:05:00 | AAPL | Stock | 3.5318 | 3.5511 | 3.5186 | 3.5461 | 13537664.0 |
| 2008-11-10 10:10:00 | AAPL | Stock | 3.5461 | 3.5714 | 3.5439 | 3.5679 | 14425516.0 |
| 2008-11-10 10:15:00 | AAPL | Stock | 3.5675 | 3.5707 | 3.5461 | 3.55 | 14495600.0 |
| 2008-11-10 10:20:00 | AAPL | Stock | 3.5504 | 3.5518 | 3.5329 | 3.5397 | 16381288.0 |
| 2008-11-10 10:25:00 | AAPL | Stock | 3.5418 | 3.565 | 3.5332 | 3.5375 | 12084772.0 |
| 2008-11-10 10:30:00 | AAPL | Stock | 3.5379 | 3.5482 | 3.5318 | 3.5429 | 11809896.0 |
| 2008-11-10 10:35:00 | AAPL | Stock | 3.5425 | 3.5525 | 3.5371 | 3.5493 | 10574732.0 |
| 2008-11-10 10:40:00 | AAPL | Stock | 3.5489 | 3.5611 | 3.5439 | 3.555 | 11553052.0 |
| 2008-11-10 10:45:00 | AAPL | Stock | 3.555 | 3.5589 | 3.5225 | 3.5229 | 12661404.0 |
| 2008-11-10 10:50:00 | AAPL | Stock | 3.5229 | 3.5321 | 3.5171 | 3.52 | 9602012.0 |
| 2008-11-10 10:55:00 | AAPL | Stock | 3.52 | 3.5271 | 3.5125 | 3.5236 | 9054416.0 |
| 2008-11-10 11:00:00 | AAPL | Stock | 3.5239 | 3.5243 | 3.5018 | 3.5082 | 12242664.0 |
| 2008-11-10 11:05:00 | AAPL | Stock | 3.5075 | 3.5121 | 3.4946 | 3.5111 | 15574132.0 |
| 2008-11-10 11:10:00 | AAPL | Stock | 3.5104 | 3.5114 | 3.47 | 3.4779 | 21673428.0 |
| 2008-11-10 11:15:00 | AAPL | Stock | 3.4786 | 3.4786 | 3.45 | 3.4514 | 18295004.0 |
| 2008-11-10 11:20:00 | AAPL | Stock | 3.4504 | 3.4739 | 3.4432 | 3.4739 | 17116064.0 |
| 2008-11-10 11:25:00 | AAPL | Stock | 3.4735 | 3.48 | 3.4704 | 3.4732 | 12275760.0 |
> showing 50 of 308,719 rows — these rows as CSV