PREVIEW / stock_5min / 2012-10-23
file: by_date/stock_5min/2012/2012-10-23.parquet size: 4.7 MB rows: 317,667 symbols: 3,482
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-10-23 04:00:00 | AAPL | Stock | 22.5714 | 22.5714 | 22.5714 | 22.5714 | 5600.0 |
| 2012-10-23 04:10:00 | AAPL | Stock | 22.5696 | 22.5696 | 22.5432 | 22.5432 | 11200.0 |
| 2012-10-23 04:15:00 | AAPL | Stock | 22.57 | 22.57 | 22.57 | 22.57 | 2800.0 |
| 2012-10-23 04:20:00 | AAPL | Stock | 22.5679 | 22.5714 | 22.5679 | 22.5714 | 23800.0 |
| 2012-10-23 04:25:00 | AAPL | Stock | 22.5714 | 22.6071 | 22.5711 | 22.6071 | 92092.0 |
| 2012-10-23 04:30:00 | AAPL | Stock | 22.5786 | 22.5786 | 22.5786 | 22.5786 | 2800.0 |
| 2012-10-23 05:00:00 | AAPL | Stock | 22.5607 | 22.5607 | 22.5607 | 22.5607 | 8400.0 |
| 2012-10-23 05:15:00 | AAPL | Stock | 22.5607 | 22.5607 | 22.5607 | 22.5607 | 6580.0 |
| 2012-10-23 05:30:00 | AAPL | Stock | 22.6071 | 22.6071 | 22.6071 | 22.6071 | 24584.0 |
| 2012-10-23 05:40:00 | AAPL | Stock | 22.575 | 22.575 | 22.5679 | 22.5679 | 11200.0 |
| 2012-10-23 06:00:00 | AAPL | Stock | 22.5607 | 22.5786 | 22.5607 | 22.5786 | 11760.0 |
| 2012-10-23 06:10:00 | AAPL | Stock | 22.5571 | 22.5571 | 22.5571 | 22.5571 | 5600.0 |
| 2012-10-23 06:15:00 | AAPL | Stock | 22.5357 | 22.5357 | 22.5357 | 22.5357 | 6160.0 |
| 2012-10-23 06:20:00 | AAPL | Stock | 22.5361 | 22.5361 | 22.5357 | 22.5357 | 16800.0 |
| 2012-10-23 06:25:00 | AAPL | Stock | 22.5182 | 22.5182 | 22.5004 | 22.5004 | 5600.0 |
| 2012-10-23 06:30:00 | AAPL | Stock | 22.5321 | 22.5357 | 22.5321 | 22.5357 | 7504.0 |
| 2012-10-23 06:40:00 | AAPL | Stock | 22.5004 | 22.5004 | 22.5004 | 22.5004 | 2800.0 |
| 2012-10-23 06:55:00 | AAPL | Stock | 22.5036 | 22.5036 | 22.5036 | 22.5036 | 2800.0 |
| 2012-10-23 07:00:00 | AAPL | Stock | 22.5357 | 22.5357 | 22.5143 | 22.5143 | 23100.0 |
| 2012-10-23 07:05:00 | AAPL | Stock | 22.5243 | 22.5357 | 22.5071 | 22.5071 | 43680.0 |
| 2012-10-23 07:10:00 | AAPL | Stock | 22.5 | 22.5536 | 22.5 | 22.5536 | 71148.0 |
| 2012-10-23 07:15:00 | AAPL | Stock | 22.5679 | 22.5679 | 22.5468 | 22.5468 | 63280.0 |
| 2012-10-23 07:20:00 | AAPL | Stock | 22.5446 | 22.5504 | 22.5446 | 22.5504 | 17500.0 |
| 2012-10-23 07:25:00 | AAPL | Stock | 22.5504 | 22.5714 | 22.5504 | 22.5714 | 98532.0 |
| 2012-10-23 07:30:00 | AAPL | Stock | 22.5714 | 22.5714 | 22.5254 | 22.5254 | 249732.0 |
| 2012-10-23 07:35:00 | AAPL | Stock | 22.5386 | 22.5482 | 22.5361 | 22.5468 | 35280.0 |
| 2012-10-23 07:40:00 | AAPL | Stock | 22.5407 | 22.5407 | 22.5182 | 22.5257 | 39200.0 |
| 2012-10-23 07:45:00 | AAPL | Stock | 22.5336 | 22.5336 | 22.5179 | 22.5179 | 39200.0 |
| 2012-10-23 07:50:00 | AAPL | Stock | 22.5075 | 22.5143 | 22.5004 | 22.5143 | 106820.0 |
| 2012-10-23 07:55:00 | AAPL | Stock | 22.5175 | 22.53 | 22.5111 | 22.5296 | 70000.0 |
| 2012-10-23 08:00:00 | AAPL | Stock | 22.5179 | 22.5679 | 22.4746 | 22.5193 | 585788.0 |
| 2012-10-23 08:05:00 | AAPL | Stock | 22.5093 | 22.5139 | 22.45 | 22.4682 | 571732.0 |
| 2012-10-23 08:10:00 | AAPL | Stock | 22.4732 | 22.5004 | 22.4732 | 22.4929 | 154980.0 |
| 2012-10-23 08:15:00 | AAPL | Stock | 22.4964 | 22.5714 | 22.4839 | 22.5221 | 563920.0 |
| 2012-10-23 08:20:00 | AAPL | Stock | 22.5179 | 22.5332 | 22.5143 | 22.5268 | 55832.0 |
| 2012-10-23 08:25:00 | AAPL | Stock | 22.525 | 22.5268 | 22.4946 | 22.5179 | 304556.0 |
| 2012-10-23 08:30:00 | AAPL | Stock | 22.5 | 22.5175 | 22.4868 | 22.5043 | 149212.0 |
| 2012-10-23 08:35:00 | AAPL | Stock | 22.5 | 22.5136 | 22.475 | 22.475 | 257404.0 |
| 2012-10-23 08:40:00 | AAPL | Stock | 22.4829 | 22.4857 | 22.4457 | 22.4579 | 583044.0 |
| 2012-10-23 08:45:00 | AAPL | Stock | 22.4596 | 22.4821 | 22.4464 | 22.475 | 287644.0 |
| 2012-10-23 08:50:00 | AAPL | Stock | 22.4761 | 22.4946 | 22.4746 | 22.4946 | 109620.0 |
| 2012-10-23 08:55:00 | AAPL | Stock | 22.4839 | 22.495 | 22.4764 | 22.4875 | 82516.0 |
| 2012-10-23 09:00:00 | AAPL | Stock | 22.4889 | 22.4964 | 22.4821 | 22.4821 | 96936.0 |
| 2012-10-23 09:05:00 | AAPL | Stock | 22.4889 | 22.4893 | 22.4775 | 22.4893 | 78596.0 |
| 2012-10-23 09:10:00 | AAPL | Stock | 22.4821 | 22.5179 | 22.4796 | 22.5029 | 490364.0 |
| 2012-10-23 09:15:00 | AAPL | Stock | 22.5018 | 22.5154 | 22.5004 | 22.5125 | 156324.0 |
| 2012-10-23 09:20:00 | AAPL | Stock | 22.5089 | 22.5161 | 22.4875 | 22.49 | 167860.0 |
| 2012-10-23 09:25:00 | AAPL | Stock | 22.4946 | 22.5464 | 22.4714 | 22.5368 | 1046024.0 |
| 2012-10-23 09:30:00 | AAPL | Stock | 22.5343 | 22.5489 | 22.3821 | 22.4141 | 21167636.0 |
| 2012-10-23 09:35:00 | AAPL | Stock | 22.4089 | 22.4129 | 22.2686 | 22.285 | 19111848.0 |
> showing 50 of 317,667 rows — these rows as CSV