PREVIEW / stock_5min / 2016-03-11
file: by_date/stock_5min/2016/2016-03-11.parquet size: 5.4 MB rows: 357,614 symbols: 3,342
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 |
|---|---|---|---|---|---|---|---|
| 2016-03-11 04:00:00 | AAPL | Stock | 25.5075 | 25.5075 | 25.5075 | 25.5075 | 400.0 |
| 2016-03-11 04:10:00 | AAPL | Stock | 25.5625 | 25.5625 | 25.5625 | 25.5625 | 1980.0 |
| 2016-03-11 04:45:00 | AAPL | Stock | 25.5 | 25.5 | 25.5 | 25.5 | 400.0 |
| 2016-03-11 05:05:00 | AAPL | Stock | 25.505 | 25.5375 | 25.505 | 25.5375 | 6844.0 |
| 2016-03-11 05:10:00 | AAPL | Stock | 25.5875 | 25.59 | 25.5875 | 25.59 | 3680.0 |
| 2016-03-11 05:20:00 | AAPL | Stock | 25.5875 | 25.59 | 25.5875 | 25.59 | 4000.0 |
| 2016-03-11 05:30:00 | AAPL | Stock | 25.53 | 25.53 | 25.53 | 25.53 | 504.0 |
| 2016-03-11 05:35:00 | AAPL | Stock | 25.55 | 25.55 | 25.55 | 25.55 | 11456.0 |
| 2016-03-11 05:40:00 | AAPL | Stock | 25.55 | 25.55 | 25.55 | 25.55 | 4544.0 |
| 2016-03-11 06:00:00 | AAPL | Stock | 25.55 | 25.55 | 25.53 | 25.53 | 1400.0 |
| 2016-03-11 06:05:00 | AAPL | Stock | 25.55 | 25.555 | 25.55 | 25.555 | 4220.0 |
| 2016-03-11 06:10:00 | AAPL | Stock | 25.5625 | 25.5625 | 25.5625 | 25.5625 | 1200.0 |
| 2016-03-11 06:15:00 | AAPL | Stock | 25.5625 | 25.5625 | 25.5475 | 25.5475 | 2000.0 |
| 2016-03-11 06:20:00 | AAPL | Stock | 25.555 | 25.5625 | 25.555 | 25.5625 | 10000.0 |
| 2016-03-11 06:30:00 | AAPL | Stock | 25.55 | 25.5725 | 25.55 | 25.5625 | 5044.0 |
| 2016-03-11 06:35:00 | AAPL | Stock | 25.56 | 25.5625 | 25.53 | 25.53 | 2812.0 |
| 2016-03-11 06:40:00 | AAPL | Stock | 25.525 | 25.525 | 25.525 | 25.525 | 400.0 |
| 2016-03-11 06:45:00 | AAPL | Stock | 25.525 | 25.525 | 25.5 | 25.5 | 2528.0 |
| 2016-03-11 07:00:00 | AAPL | Stock | 25.4975 | 25.5 | 25.4975 | 25.4975 | 7376.0 |
| 2016-03-11 07:05:00 | AAPL | Stock | 25.4975 | 25.5 | 25.475 | 25.485 | 43328.0 |
| 2016-03-11 07:10:00 | AAPL | Stock | 25.48 | 25.4875 | 25.48 | 25.4875 | 800.0 |
| 2016-03-11 07:15:00 | AAPL | Stock | 25.49 | 25.49 | 25.4675 | 25.49 | 3396.0 |
| 2016-03-11 07:20:00 | AAPL | Stock | 25.4875 | 25.5 | 25.4875 | 25.5 | 25664.0 |
| 2016-03-11 07:25:00 | AAPL | Stock | 25.5 | 25.5 | 25.5 | 25.5 | 2400.0 |
| 2016-03-11 07:30:00 | AAPL | Stock | 25.5125 | 25.5175 | 25.5125 | 25.515 | 14464.0 |
| 2016-03-11 07:35:00 | AAPL | Stock | 25.5025 | 25.5025 | 25.5 | 25.5 | 28016.0 |
| 2016-03-11 07:40:00 | AAPL | Stock | 25.4825 | 25.4825 | 25.475 | 25.475 | 2800.0 |
| 2016-03-11 07:45:00 | AAPL | Stock | 25.5 | 25.5 | 25.5 | 25.5 | 872.0 |
| 2016-03-11 07:50:00 | AAPL | Stock | 25.4875 | 25.4875 | 25.4875 | 25.4875 | 1600.0 |
| 2016-03-11 07:55:00 | AAPL | Stock | 25.48 | 25.48 | 25.48 | 25.48 | 400.0 |
| 2016-03-11 08:00:00 | AAPL | Stock | 25.4975 | 25.5625 | 25.46 | 25.4875 | 80568.0 |
| 2016-03-11 08:05:00 | AAPL | Stock | 25.4825 | 25.4925 | 25.4825 | 25.4925 | 13296.0 |
| 2016-03-11 08:10:00 | AAPL | Stock | 25.495 | 25.5 | 25.475 | 25.475 | 40424.0 |
| 2016-03-11 08:15:00 | AAPL | Stock | 25.475 | 25.4975 | 25.475 | 25.4925 | 20064.0 |
| 2016-03-11 08:20:00 | AAPL | Stock | 25.48 | 25.4825 | 25.48 | 25.48 | 11400.0 |
| 2016-03-11 08:25:00 | AAPL | Stock | 25.48 | 25.4875 | 25.475 | 25.475 | 10992.0 |
| 2016-03-11 08:30:00 | AAPL | Stock | 25.475 | 25.475 | 25.465 | 25.475 | 7572.0 |
| 2016-03-11 08:35:00 | AAPL | Stock | 25.4825 | 25.4825 | 25.47 | 25.4725 | 11200.0 |
| 2016-03-11 08:40:00 | AAPL | Stock | 25.4575 | 25.46 | 25.445 | 25.45 | 13000.0 |
| 2016-03-11 08:45:00 | AAPL | Stock | 25.45 | 25.4625 | 25.445 | 25.45 | 46440.0 |
| 2016-03-11 08:50:00 | AAPL | Stock | 25.45 | 25.4625 | 25.45 | 25.45 | 7720.0 |
| 2016-03-11 08:55:00 | AAPL | Stock | 25.445 | 25.4525 | 25.44 | 25.4525 | 9200.0 |
| 2016-03-11 09:00:00 | AAPL | Stock | 25.4475 | 25.465 | 25.4475 | 25.4625 | 7644.0 |
| 2016-03-11 09:05:00 | AAPL | Stock | 25.4625 | 25.4725 | 25.455 | 25.4725 | 7924.0 |
| 2016-03-11 09:10:00 | AAPL | Stock | 25.4625 | 25.48 | 25.4625 | 25.48 | 49724.0 |
| 2016-03-11 09:15:00 | AAPL | Stock | 25.2925 | 25.485 | 25.2925 | 25.485 | 5960.0 |
| 2016-03-11 09:20:00 | AAPL | Stock | 25.4775 | 25.4825 | 25.4775 | 25.4825 | 14800.0 |
| 2016-03-11 09:25:00 | AAPL | Stock | 25.475 | 25.56 | 25.475 | 25.5575 | 279812.0 |
| 2016-03-11 09:30:00 | AAPL | Stock | 25.5575 | 25.5625 | 25.44 | 25.4425 | 4001396.0 |
| 2016-03-11 09:35:00 | AAPL | Stock | 25.44 | 25.515 | 25.3888 | 25.4825 | 2974496.0 |
> showing 50 of 357,614 rows — these rows as CSV