PREVIEW / stock_5min / 2018-11-27
file: by_date/stock_5min/2018/2018-11-27.parquet size: 5.5 MB rows: 349,683 symbols: 2,737
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 |
|---|---|---|---|---|---|---|---|
| 2018-11-27 04:00:00 | AAPL | Stock | 42.9375 | 42.9975 | 42.9375 | 42.985 | 2596.0 |
| 2018-11-27 04:05:00 | AAPL | Stock | 42.985 | 42.985 | 42.985 | 42.985 | 400.0 |
| 2018-11-27 04:10:00 | AAPL | Stock | 43.07 | 43.105 | 43.07 | 43.105 | 6588.0 |
| 2018-11-27 04:15:00 | AAPL | Stock | 43.0925 | 43.0925 | 43.09 | 43.09 | 1504.0 |
| 2018-11-27 04:20:00 | AAPL | Stock | 43.0975 | 43.1225 | 43.0975 | 43.1225 | 6900.0 |
| 2018-11-27 04:25:00 | AAPL | Stock | 43.1225 | 43.1225 | 43.1125 | 43.1225 | 2800.0 |
| 2018-11-27 04:30:00 | AAPL | Stock | 43.21 | 43.21 | 43.175 | 43.175 | 8328.0 |
| 2018-11-27 04:40:00 | AAPL | Stock | 43.0925 | 43.0925 | 43.075 | 43.075 | 1200.0 |
| 2018-11-27 04:45:00 | AAPL | Stock | 43.0375 | 43.0375 | 43.0375 | 43.0375 | 5600.0 |
| 2018-11-27 04:55:00 | AAPL | Stock | 43.0375 | 43.0375 | 43.0375 | 43.0375 | 600.0 |
| 2018-11-27 05:00:00 | AAPL | Stock | 42.975 | 42.975 | 42.975 | 42.975 | 7336.0 |
| 2018-11-27 05:20:00 | AAPL | Stock | 42.975 | 42.975 | 42.975 | 42.975 | 1732.0 |
| 2018-11-27 05:25:00 | AAPL | Stock | 42.9025 | 42.97 | 42.9025 | 42.97 | 6564.0 |
| 2018-11-27 05:30:00 | AAPL | Stock | 42.97 | 42.97 | 42.925 | 42.925 | 4512.0 |
| 2018-11-27 05:35:00 | AAPL | Stock | 42.9475 | 42.9475 | 42.9475 | 42.9475 | 400.0 |
| 2018-11-27 05:40:00 | AAPL | Stock | 42.9475 | 42.9475 | 42.9475 | 42.9475 | 800.0 |
| 2018-11-27 06:00:00 | AAPL | Stock | 42.9 | 42.9 | 42.875 | 42.875 | 10392.0 |
| 2018-11-27 06:05:00 | AAPL | Stock | 42.875 | 42.9 | 42.875 | 42.9 | 2476.0 |
| 2018-11-27 06:10:00 | AAPL | Stock | 42.9 | 42.9 | 42.875 | 42.875 | 11976.0 |
| 2018-11-27 06:15:00 | AAPL | Stock | 42.9 | 42.9 | 42.875 | 42.875 | 1328.0 |
| 2018-11-27 06:20:00 | AAPL | Stock | 42.875 | 42.875 | 42.85 | 42.85 | 6960.0 |
| 2018-11-27 06:25:00 | AAPL | Stock | 42.875 | 42.875 | 42.875 | 42.875 | 1600.0 |
| 2018-11-27 06:30:00 | AAPL | Stock | 42.9 | 42.92 | 42.8875 | 42.92 | 7992.0 |
| 2018-11-27 06:40:00 | AAPL | Stock | 42.9025 | 42.9025 | 42.8375 | 42.875 | 10156.0 |
| 2018-11-27 06:50:00 | AAPL | Stock | 42.9225 | 42.99 | 42.9 | 42.99 | 4968.0 |
| 2018-11-27 06:55:00 | AAPL | Stock | 43.0 | 43.0 | 43.0 | 43.0 | 3992.0 |
| 2018-11-27 07:00:00 | AAPL | Stock | 42.9575 | 42.9775 | 42.7325 | 42.7725 | 103080.0 |
| 2018-11-27 07:05:00 | AAPL | Stock | 42.7975 | 42.8325 | 42.7725 | 42.8 | 27184.0 |
| 2018-11-27 07:10:00 | AAPL | Stock | 42.8125 | 42.8125 | 42.7775 | 42.8 | 11360.0 |
| 2018-11-27 07:15:00 | AAPL | Stock | 42.8125 | 42.8125 | 42.7 | 42.7225 | 58456.0 |
| 2018-11-27 07:20:00 | AAPL | Stock | 42.7125 | 42.7975 | 42.7025 | 42.7875 | 25352.0 |
| 2018-11-27 07:25:00 | AAPL | Stock | 42.77 | 42.81 | 42.77 | 42.81 | 6316.0 |
| 2018-11-27 07:30:00 | AAPL | Stock | 42.815 | 42.8675 | 42.815 | 42.83 | 27452.0 |
| 2018-11-27 07:35:00 | AAPL | Stock | 42.825 | 42.85 | 42.7875 | 42.8225 | 28028.0 |
| 2018-11-27 07:40:00 | AAPL | Stock | 42.8125 | 42.825 | 42.8075 | 42.825 | 23480.0 |
| 2018-11-27 07:45:00 | AAPL | Stock | 42.825 | 42.8325 | 42.725 | 42.725 | 51580.0 |
| 2018-11-27 07:50:00 | AAPL | Stock | 42.7075 | 42.77 | 42.7075 | 42.7625 | 34480.0 |
| 2018-11-27 07:55:00 | AAPL | Stock | 42.7625 | 42.775 | 42.7525 | 42.775 | 22736.0 |
| 2018-11-27 08:00:00 | AAPL | Stock | 42.7092 | 42.95 | 42.6925 | 42.84 | 284824.0 |
| 2018-11-27 08:05:00 | AAPL | Stock | 42.845 | 42.925 | 42.8125 | 42.8725 | 488304.0 |
| 2018-11-27 08:10:00 | AAPL | Stock | 42.815 | 42.8875 | 42.8 | 42.8125 | 41068.0 |
| 2018-11-27 08:15:00 | AAPL | Stock | 42.8325 | 42.8625 | 42.8325 | 42.8375 | 35400.0 |
| 2018-11-27 08:20:00 | AAPL | Stock | 42.845 | 42.855 | 42.7525 | 42.7775 | 90360.0 |
| 2018-11-27 08:25:00 | AAPL | Stock | 42.785 | 42.85 | 42.745 | 42.845 | 112688.0 |
| 2018-11-27 08:30:00 | AAPL | Stock | 42.835 | 42.97 | 42.775 | 42.9675 | 95004.0 |
| 2018-11-27 08:35:00 | AAPL | Stock | 42.925 | 42.9675 | 42.89 | 42.94 | 38600.0 |
| 2018-11-27 08:40:00 | AAPL | Stock | 42.945 | 43.025 | 42.945 | 43.0 | 211856.0 |
| 2018-11-27 08:45:00 | AAPL | Stock | 43.0 | 43.025 | 42.9525 | 42.98 | 83528.0 |
| 2018-11-27 08:50:00 | AAPL | Stock | 43.0075 | 43.025 | 42.975 | 42.975 | 137528.0 |
| 2018-11-27 08:55:00 | AAPL | Stock | 42.975 | 43.0 | 42.9125 | 42.95 | 110504.0 |
> showing 50 of 349,683 rows — these rows as CSV