PREVIEW / stock_5min / 2015-04-27
file: by_date/stock_5min/2015/2015-04-27.parquet size: 5.6 MB rows: 369,177 symbols: 3,524
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 |
|---|---|---|---|---|---|---|---|
| 2015-04-27 04:00:00 | AAPL | Stock | 32.745 | 32.745 | 32.7 | 32.725 | 17048.0 |
| 2015-04-27 04:05:00 | AAPL | Stock | 32.7475 | 32.8 | 32.7475 | 32.78 | 15076.0 |
| 2015-04-27 04:10:00 | AAPL | Stock | 32.7975 | 32.7975 | 32.78 | 32.78 | 2456.0 |
| 2015-04-27 04:15:00 | AAPL | Stock | 32.7875 | 32.7875 | 32.7725 | 32.7725 | 3600.0 |
| 2015-04-27 04:20:00 | AAPL | Stock | 32.7725 | 32.775 | 32.755 | 32.755 | 10028.0 |
| 2015-04-27 04:35:00 | AAPL | Stock | 32.765 | 32.765 | 32.765 | 32.765 | 400.0 |
| 2015-04-27 04:45:00 | AAPL | Stock | 32.7525 | 32.7525 | 32.7375 | 32.75 | 16496.0 |
| 2015-04-27 04:50:00 | AAPL | Stock | 32.75 | 32.75 | 32.75 | 32.75 | 2000.0 |
| 2015-04-27 04:55:00 | AAPL | Stock | 32.775 | 32.775 | 32.775 | 32.775 | 22240.0 |
| 2015-04-27 05:00:00 | AAPL | Stock | 32.775 | 32.775 | 32.775 | 32.775 | 10800.0 |
| 2015-04-27 05:05:00 | AAPL | Stock | 32.775 | 32.775 | 32.775 | 32.775 | 4800.0 |
| 2015-04-27 05:10:00 | AAPL | Stock | 32.775 | 32.775 | 32.75 | 32.775 | 4456.0 |
| 2015-04-27 05:15:00 | AAPL | Stock | 32.775 | 32.775 | 32.75 | 32.75 | 11072.0 |
| 2015-04-27 05:20:00 | AAPL | Stock | 32.75 | 32.7525 | 32.75 | 32.75 | 17964.0 |
| 2015-04-27 05:25:00 | AAPL | Stock | 32.75 | 32.75 | 32.7375 | 32.7375 | 2044.0 |
| 2015-04-27 05:30:00 | AAPL | Stock | 32.7375 | 32.75 | 32.735 | 32.75 | 11588.0 |
| 2015-04-27 05:35:00 | AAPL | Stock | 32.75 | 32.75 | 32.75 | 32.75 | 1488.0 |
| 2015-04-27 05:45:00 | AAPL | Stock | 32.76 | 32.765 | 32.7475 | 32.765 | 10400.0 |
| 2015-04-27 05:50:00 | AAPL | Stock | 32.7675 | 32.77 | 32.7475 | 32.77 | 4172.0 |
| 2015-04-27 06:00:00 | AAPL | Stock | 32.775 | 32.775 | 32.75 | 32.7625 | 72644.0 |
| 2015-04-27 06:05:00 | AAPL | Stock | 32.775 | 32.775 | 32.7625 | 32.77 | 44472.0 |
| 2015-04-27 06:10:00 | AAPL | Stock | 32.77 | 32.77 | 32.77 | 32.77 | 1600.0 |
| 2015-04-27 06:15:00 | AAPL | Stock | 32.775 | 32.775 | 32.775 | 32.775 | 4400.0 |
| 2015-04-27 06:20:00 | AAPL | Stock | 32.77 | 32.775 | 32.77 | 32.775 | 43404.0 |
| 2015-04-27 06:25:00 | AAPL | Stock | 32.77 | 32.775 | 32.77 | 32.775 | 15200.0 |
| 2015-04-27 06:30:00 | AAPL | Stock | 32.775 | 32.79 | 32.77 | 32.775 | 8800.0 |
| 2015-04-27 06:35:00 | AAPL | Stock | 32.775 | 32.7775 | 32.75 | 32.75 | 17372.0 |
| 2015-04-27 06:40:00 | AAPL | Stock | 32.77 | 32.77 | 32.77 | 32.77 | 7728.0 |
| 2015-04-27 06:45:00 | AAPL | Stock | 32.77 | 32.795 | 32.77 | 32.795 | 4516.0 |
| 2015-04-27 06:50:00 | AAPL | Stock | 32.795 | 32.795 | 32.7925 | 32.795 | 3940.0 |
| 2015-04-27 06:55:00 | AAPL | Stock | 32.7975 | 32.7975 | 32.795 | 32.795 | 17240.0 |
| 2015-04-27 07:00:00 | AAPL | Stock | 32.795 | 32.8625 | 32.785 | 32.8375 | 122368.0 |
| 2015-04-27 07:05:00 | AAPL | Stock | 32.8325 | 32.8575 | 32.8225 | 32.8225 | 54484.0 |
| 2015-04-27 07:10:00 | AAPL | Stock | 32.815 | 32.8625 | 32.8125 | 32.8625 | 58448.0 |
| 2015-04-27 07:15:00 | AAPL | Stock | 32.87 | 32.8875 | 32.8625 | 32.8775 | 126036.0 |
| 2015-04-27 07:20:00 | AAPL | Stock | 32.8775 | 32.8975 | 32.875 | 32.8875 | 28376.0 |
| 2015-04-27 07:25:00 | AAPL | Stock | 32.8775 | 32.895 | 32.8375 | 32.8475 | 125468.0 |
| 2015-04-27 07:30:00 | AAPL | Stock | 32.845 | 32.8675 | 32.845 | 32.865 | 21896.0 |
| 2015-04-27 07:35:00 | AAPL | Stock | 32.865 | 32.865 | 32.8375 | 32.85 | 43656.0 |
| 2015-04-27 07:40:00 | AAPL | Stock | 32.8625 | 32.895 | 32.8625 | 32.8925 | 33268.0 |
| 2015-04-27 07:45:00 | AAPL | Stock | 32.8925 | 32.8925 | 32.875 | 32.8875 | 37784.0 |
| 2015-04-27 07:50:00 | AAPL | Stock | 32.8775 | 32.93 | 32.8775 | 32.92 | 84464.0 |
| 2015-04-27 07:55:00 | AAPL | Stock | 32.9225 | 32.925 | 32.8875 | 32.9 | 48652.0 |
| 2015-04-27 08:00:00 | AAPL | Stock | 32.8975 | 32.975 | 32.625 | 32.9725 | 717216.0 |
| 2015-04-27 08:05:00 | AAPL | Stock | 32.9725 | 33.02 | 32.9675 | 33.0125 | 363872.0 |
| 2015-04-27 08:10:00 | AAPL | Stock | 33.0125 | 33.0425 | 33.0 | 33.0425 | 223900.0 |
| 2015-04-27 08:15:00 | AAPL | Stock | 33.0425 | 33.12 | 33.0425 | 33.0875 | 624624.0 |
| 2015-04-27 08:20:00 | AAPL | Stock | 33.0875 | 33.0875 | 33.05 | 33.0575 | 321424.0 |
| 2015-04-27 08:25:00 | AAPL | Stock | 33.05 | 33.1125 | 33.05 | 33.1 | 317088.0 |
| 2015-04-27 08:30:00 | AAPL | Stock | 33.09 | 33.1075 | 33.0625 | 33.0875 | 224196.0 |
> showing 50 of 369,177 rows — these rows as CSV