PREVIEW / stock_5min / 2012-08-15
file: by_date/stock_5min/2012/2012-08-15.parquet size: 4.5 MB rows: 307,377 symbols: 3,468
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 |
|---|---|---|---|---|---|---|---|
| 2012-08-15 04:05:00 | AAPL | Stock | 22.5357 | 22.5464 | 22.5357 | 22.5464 | 5600.0 |
| 2012-08-15 04:10:00 | AAPL | Stock | 22.5468 | 22.5468 | 22.5396 | 22.5396 | 8400.0 |
| 2012-08-15 04:20:00 | AAPL | Stock | 22.5464 | 22.5464 | 22.5464 | 22.5464 | 2800.0 |
| 2012-08-15 04:25:00 | AAPL | Stock | 22.5464 | 22.5464 | 22.5464 | 22.5464 | 11200.0 |
| 2012-08-15 04:55:00 | AAPL | Stock | 22.5786 | 22.5786 | 22.5786 | 22.5786 | 2800.0 |
| 2012-08-15 05:25:00 | AAPL | Stock | 22.6071 | 22.6071 | 22.6071 | 22.6071 | 2800.0 |
| 2012-08-15 05:40:00 | AAPL | Stock | 22.6071 | 22.6107 | 22.6071 | 22.6107 | 15316.0 |
| 2012-08-15 05:45:00 | AAPL | Stock | 22.6107 | 22.6107 | 22.6107 | 22.6107 | 8400.0 |
| 2012-08-15 05:55:00 | AAPL | Stock | 22.6107 | 22.6107 | 22.5893 | 22.5893 | 16800.0 |
| 2012-08-15 06:05:00 | AAPL | Stock | 22.5786 | 22.5786 | 22.5786 | 22.5786 | 2800.0 |
| 2012-08-15 06:15:00 | AAPL | Stock | 22.5679 | 22.5679 | 22.5679 | 22.5679 | 5600.0 |
| 2012-08-15 06:20:00 | AAPL | Stock | 22.5571 | 22.5571 | 22.5571 | 22.5571 | 2800.0 |
| 2012-08-15 06:25:00 | AAPL | Stock | 22.54 | 22.54 | 22.5393 | 22.5393 | 5600.0 |
| 2012-08-15 06:40:00 | AAPL | Stock | 22.5464 | 22.5464 | 22.5464 | 22.5464 | 4788.0 |
| 2012-08-15 06:45:00 | AAPL | Stock | 22.5714 | 22.5714 | 22.5714 | 22.5714 | 4200.0 |
| 2012-08-15 07:00:00 | AAPL | Stock | 22.5711 | 22.5714 | 22.5711 | 22.5714 | 26600.0 |
| 2012-08-15 07:05:00 | AAPL | Stock | 22.5679 | 22.5679 | 22.5629 | 22.5629 | 5600.0 |
| 2012-08-15 07:10:00 | AAPL | Stock | 22.5625 | 22.5625 | 22.5354 | 22.5354 | 11200.0 |
| 2012-08-15 07:20:00 | AAPL | Stock | 22.5218 | 22.5357 | 22.5196 | 22.5357 | 19600.0 |
| 2012-08-15 07:25:00 | AAPL | Stock | 22.5429 | 22.5429 | 22.5429 | 22.5429 | 2800.0 |
| 2012-08-15 07:30:00 | AAPL | Stock | 22.5493 | 22.5493 | 22.5118 | 22.5118 | 55804.0 |
| 2012-08-15 07:35:00 | AAPL | Stock | 22.5179 | 22.5357 | 22.5071 | 22.5071 | 236488.0 |
| 2012-08-15 07:40:00 | AAPL | Stock | 22.5118 | 22.5118 | 22.5089 | 22.5089 | 5600.0 |
| 2012-08-15 07:45:00 | AAPL | Stock | 22.5179 | 22.5232 | 22.5161 | 22.5232 | 34048.0 |
| 2012-08-15 07:50:00 | AAPL | Stock | 22.5325 | 22.5614 | 22.5325 | 22.5614 | 66388.0 |
| 2012-08-15 07:55:00 | AAPL | Stock | 22.5439 | 22.5439 | 22.5439 | 22.5439 | 5600.0 |
| 2012-08-15 08:00:00 | AAPL | Stock | 22.5475 | 22.5546 | 22.5357 | 22.5429 | 23156.0 |
| 2012-08-15 08:05:00 | AAPL | Stock | 22.5514 | 22.5514 | 22.5454 | 22.5454 | 5600.0 |
| 2012-08-15 08:10:00 | AAPL | Stock | 22.5482 | 22.5775 | 22.5264 | 22.5264 | 154112.0 |
| 2012-08-15 08:15:00 | AAPL | Stock | 22.5836 | 22.6036 | 22.5732 | 22.6 | 184464.0 |
| 2012-08-15 08:20:00 | AAPL | Stock | 22.605 | 22.6229 | 22.5964 | 22.6104 | 104104.0 |
| 2012-08-15 08:25:00 | AAPL | Stock | 22.6089 | 22.6218 | 22.5996 | 22.6014 | 138488.0 |
| 2012-08-15 08:30:00 | AAPL | Stock | 22.6 | 22.6064 | 22.5732 | 22.6064 | 112840.0 |
| 2012-08-15 08:35:00 | AAPL | Stock | 22.6057 | 22.6229 | 22.6 | 22.6107 | 140504.0 |
| 2012-08-15 08:40:00 | AAPL | Stock | 22.6125 | 22.6189 | 22.6036 | 22.6179 | 122276.0 |
| 2012-08-15 08:45:00 | AAPL | Stock | 22.6179 | 22.6207 | 22.6054 | 22.6171 | 271544.0 |
| 2012-08-15 08:50:00 | AAPL | Stock | 22.6171 | 22.6229 | 22.6004 | 22.6004 | 123200.0 |
| 2012-08-15 08:55:00 | AAPL | Stock | 22.6 | 22.6121 | 22.5993 | 22.6068 | 36176.0 |
| 2012-08-15 09:00:00 | AAPL | Stock | 22.6093 | 22.6161 | 22.6071 | 22.6082 | 44800.0 |
| 2012-08-15 09:05:00 | AAPL | Stock | 22.6179 | 22.6179 | 22.6079 | 22.6079 | 63112.0 |
| 2012-08-15 09:10:00 | AAPL | Stock | 22.6064 | 22.6071 | 22.6064 | 22.6071 | 16800.0 |
| 2012-08-15 09:15:00 | AAPL | Stock | 22.6071 | 22.6107 | 22.6 | 22.6 | 89600.0 |
| 2012-08-15 09:20:00 | AAPL | Stock | 22.6071 | 22.6154 | 22.6036 | 22.6154 | 119644.0 |
| 2012-08-15 09:25:00 | AAPL | Stock | 22.6125 | 22.6132 | 22.5475 | 22.56 | 1092728.0 |
| 2012-08-15 09:30:00 | AAPL | Stock | 22.5468 | 22.6429 | 22.545 | 22.5768 | 12435304.0 |
| 2012-08-15 09:35:00 | AAPL | Stock | 22.5791 | 22.5814 | 22.5203 | 22.56 | 9313920.0 |
| 2012-08-15 09:40:00 | AAPL | Stock | 22.5625 | 22.5839 | 22.5357 | 22.5786 | 6832140.0 |
| 2012-08-15 09:45:00 | AAPL | Stock | 22.5786 | 22.6332 | 22.5761 | 22.6147 | 8347500.0 |
| 2012-08-15 09:50:00 | AAPL | Stock | 22.616 | 22.6311 | 22.6043 | 22.6189 | 5308968.0 |
| 2012-08-15 09:55:00 | AAPL | Stock | 22.6221 | 22.6368 | 22.6011 | 22.6068 | 6108424.0 |
> showing 50 of 307,377 rows — these rows as CSV