PREVIEW / stock_5min / 2016-07-28
file: by_date/stock_5min/2016/2016-07-28.parquet size: 5.3 MB rows: 350,138 symbols: 3,261
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-07-28 04:00:00 | AAPL | Stock | 25.85 | 25.875 | 25.85 | 25.875 | 2320.0 |
| 2016-07-28 04:05:00 | AAPL | Stock | 25.8 | 25.8 | 25.8 | 25.8 | 9200.0 |
| 2016-07-28 04:30:00 | AAPL | Stock | 25.8025 | 25.8025 | 25.8 | 25.8 | 2000.0 |
| 2016-07-28 04:35:00 | AAPL | Stock | 25.8125 | 25.8125 | 25.8125 | 25.8125 | 2744.0 |
| 2016-07-28 04:50:00 | AAPL | Stock | 25.8 | 25.8 | 25.8 | 25.8 | 1028.0 |
| 2016-07-28 04:55:00 | AAPL | Stock | 25.8025 | 25.8025 | 25.8025 | 25.8025 | 1200.0 |
| 2016-07-28 05:00:00 | AAPL | Stock | 25.8075 | 25.8075 | 25.8 | 25.8 | 6200.0 |
| 2016-07-28 05:05:00 | AAPL | Stock | 25.8125 | 25.8125 | 25.8 | 25.8 | 6400.0 |
| 2016-07-28 05:20:00 | AAPL | Stock | 25.7825 | 25.7825 | 25.7825 | 25.7825 | 1560.0 |
| 2016-07-28 05:25:00 | AAPL | Stock | 25.7825 | 25.7825 | 25.7825 | 25.7825 | 400.0 |
| 2016-07-28 05:35:00 | AAPL | Stock | 25.7775 | 25.7775 | 25.7775 | 25.7775 | 1200.0 |
| 2016-07-28 05:45:00 | AAPL | Stock | 25.78 | 25.78 | 25.78 | 25.78 | 644.0 |
| 2016-07-28 05:55:00 | AAPL | Stock | 25.81 | 25.8325 | 25.7825 | 25.7825 | 6064.0 |
| 2016-07-28 06:35:00 | AAPL | Stock | 25.7875 | 25.7875 | 25.7875 | 25.7875 | 1392.0 |
| 2016-07-28 06:40:00 | AAPL | Stock | 25.78 | 25.78 | 25.78 | 25.78 | 2116.0 |
| 2016-07-28 06:45:00 | AAPL | Stock | 25.78 | 25.78 | 25.78 | 25.78 | 1044.0 |
| 2016-07-28 06:50:00 | AAPL | Stock | 25.7825 | 25.7825 | 25.7825 | 25.7825 | 1200.0 |
| 2016-07-28 06:55:00 | AAPL | Stock | 25.7825 | 25.7825 | 25.78 | 25.78 | 4144.0 |
| 2016-07-28 07:00:00 | AAPL | Stock | 25.765 | 25.765 | 25.76 | 25.76 | 8800.0 |
| 2016-07-28 07:05:00 | AAPL | Stock | 25.76 | 25.78 | 25.7375 | 25.7375 | 12600.0 |
| 2016-07-28 07:10:00 | AAPL | Stock | 25.7375 | 25.7675 | 25.735 | 25.735 | 19380.0 |
| 2016-07-28 07:15:00 | AAPL | Stock | 25.7425 | 25.745 | 25.7425 | 25.745 | 4400.0 |
| 2016-07-28 07:20:00 | AAPL | Stock | 25.75 | 25.75 | 25.75 | 25.75 | 1576.0 |
| 2016-07-28 07:25:00 | AAPL | Stock | 25.7475 | 25.7475 | 25.7475 | 25.7475 | 2000.0 |
| 2016-07-28 07:30:00 | AAPL | Stock | 25.745 | 25.785 | 25.745 | 25.785 | 7352.0 |
| 2016-07-28 07:35:00 | AAPL | Stock | 25.785 | 25.785 | 25.775 | 25.775 | 6164.0 |
| 2016-07-28 07:40:00 | AAPL | Stock | 25.755 | 25.755 | 25.74 | 25.74 | 16812.0 |
| 2016-07-28 07:45:00 | AAPL | Stock | 25.75 | 25.75 | 25.7375 | 25.7375 | 13000.0 |
| 2016-07-28 07:50:00 | AAPL | Stock | 25.75 | 25.75 | 25.725 | 25.725 | 14120.0 |
| 2016-07-28 07:55:00 | AAPL | Stock | 25.725 | 25.725 | 25.7025 | 25.7225 | 5244.0 |
| 2016-07-28 08:00:00 | AAPL | Stock | 25.7225 | 25.77 | 25.675 | 25.75 | 94152.0 |
| 2016-07-28 08:05:00 | AAPL | Stock | 25.7625 | 25.77 | 25.7475 | 25.7475 | 45528.0 |
| 2016-07-28 08:10:00 | AAPL | Stock | 25.75 | 25.75 | 25.73 | 25.7375 | 17040.0 |
| 2016-07-28 08:15:00 | AAPL | Stock | 25.74 | 25.74 | 25.7375 | 25.7375 | 10200.0 |
| 2016-07-28 08:20:00 | AAPL | Stock | 25.7375 | 25.7375 | 25.7275 | 25.735 | 7920.0 |
| 2016-07-28 08:25:00 | AAPL | Stock | 25.7275 | 25.7425 | 25.7275 | 25.7425 | 15896.0 |
| 2016-07-28 08:30:00 | AAPL | Stock | 25.7475 | 25.7475 | 25.72 | 25.7275 | 18308.0 |
| 2016-07-28 08:35:00 | AAPL | Stock | 25.73 | 25.7375 | 25.73 | 25.7375 | 33884.0 |
| 2016-07-28 08:40:00 | AAPL | Stock | 25.7375 | 25.75 | 25.7375 | 25.7475 | 12208.0 |
| 2016-07-28 08:45:00 | AAPL | Stock | 25.7475 | 25.75 | 25.7375 | 25.75 | 7160.0 |
| 2016-07-28 08:50:00 | AAPL | Stock | 25.75 | 25.75 | 25.73 | 25.73 | 16460.0 |
| 2016-07-28 08:55:00 | AAPL | Stock | 25.7375 | 25.7425 | 25.7375 | 25.7375 | 16000.0 |
| 2016-07-28 09:00:00 | AAPL | Stock | 25.745 | 25.7575 | 25.7375 | 25.755 | 18000.0 |
| 2016-07-28 09:05:00 | AAPL | Stock | 25.7575 | 25.76 | 25.75 | 25.7525 | 73720.0 |
| 2016-07-28 09:10:00 | AAPL | Stock | 25.755 | 25.775 | 25.755 | 25.765 | 29804.0 |
| 2016-07-28 09:15:00 | AAPL | Stock | 25.7625 | 25.7675 | 25.75 | 25.765 | 19440.0 |
| 2016-07-28 09:20:00 | AAPL | Stock | 25.7675 | 25.775 | 25.7625 | 25.7625 | 18080.0 |
| 2016-07-28 09:25:00 | AAPL | Stock | 25.76 | 25.775 | 25.7125 | 25.7125 | 96284.0 |
| 2016-07-28 09:30:00 | AAPL | Stock | 25.7125 | 25.8675 | 25.705 | 25.8575 | 6448584.0 |
| 2016-07-28 09:35:00 | AAPL | Stock | 25.8575 | 25.86 | 25.7425 | 25.7675 | 3991980.0 |
> showing 50 of 350,138 rows — these rows as CSV