PREVIEW / stock_5min / 2019-03-05
file: by_date/stock_5min/2019/2019-03-05.parquet size: 5.6 MB rows: 357,148 symbols: 2,638
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 |
|---|---|---|---|---|---|---|---|
| 2019-03-05 04:20:00 | AAPL | Stock | 44.04 | 44.04 | 44.04 | 44.04 | 1600.0 |
| 2019-03-05 04:25:00 | AAPL | Stock | 44.075 | 44.075 | 44.045 | 44.045 | 816.0 |
| 2019-03-05 05:20:00 | AAPL | Stock | 44.025 | 44.025 | 44.025 | 44.025 | 688.0 |
| 2019-03-05 05:40:00 | AAPL | Stock | 43.965 | 43.965 | 43.965 | 43.965 | 400.0 |
| 2019-03-05 05:45:00 | AAPL | Stock | 44.0 | 44.025 | 44.0 | 44.0125 | 2532.0 |
| 2019-03-05 05:50:00 | AAPL | Stock | 43.9375 | 43.9375 | 43.9375 | 43.9375 | 400.0 |
| 2019-03-05 06:20:00 | AAPL | Stock | 43.95 | 43.95 | 43.95 | 43.95 | 1696.0 |
| 2019-03-05 06:25:00 | AAPL | Stock | 43.95 | 43.95 | 43.95 | 43.95 | 7464.0 |
| 2019-03-05 06:35:00 | AAPL | Stock | 43.95 | 43.95 | 43.95 | 43.95 | 424.0 |
| 2019-03-05 07:00:00 | AAPL | Stock | 43.95 | 43.95 | 43.9475 | 43.95 | 4296.0 |
| 2019-03-05 07:05:00 | AAPL | Stock | 43.9425 | 43.9425 | 43.9375 | 43.9375 | 1444.0 |
| 2019-03-05 07:10:00 | AAPL | Stock | 43.8875 | 43.8875 | 43.88 | 43.88 | 1316.0 |
| 2019-03-05 07:15:00 | AAPL | Stock | 43.8775 | 43.9175 | 43.875 | 43.9175 | 7600.0 |
| 2019-03-05 07:20:00 | AAPL | Stock | 43.9075 | 43.94 | 43.8875 | 43.8875 | 6572.0 |
| 2019-03-05 07:25:00 | AAPL | Stock | 43.9125 | 43.9125 | 43.9125 | 43.9125 | 800.0 |
| 2019-03-05 07:40:00 | AAPL | Stock | 43.91 | 43.9375 | 43.875 | 43.8775 | 15816.0 |
| 2019-03-05 07:45:00 | AAPL | Stock | 43.8625 | 43.8975 | 43.85 | 43.8975 | 7600.0 |
| 2019-03-05 07:50:00 | AAPL | Stock | 43.875 | 43.875 | 43.875 | 43.875 | 1600.0 |
| 2019-03-05 08:00:00 | AAPL | Stock | 43.9375 | 43.9425 | 43.825 | 43.8875 | 28196.0 |
| 2019-03-05 08:05:00 | AAPL | Stock | 43.8875 | 43.9025 | 43.8875 | 43.9025 | 8532.0 |
| 2019-03-05 08:10:00 | AAPL | Stock | 43.9025 | 43.945 | 43.9025 | 43.945 | 2400.0 |
| 2019-03-05 08:15:00 | AAPL | Stock | 43.935 | 43.9425 | 43.935 | 43.9425 | 2400.0 |
| 2019-03-05 08:20:00 | AAPL | Stock | 43.9275 | 43.9625 | 43.925 | 43.95 | 4000.0 |
| 2019-03-05 08:30:00 | AAPL | Stock | 43.9625 | 43.9625 | 43.9625 | 43.9625 | 2212.0 |
| 2019-03-05 08:35:00 | AAPL | Stock | 43.9625 | 43.975 | 43.9625 | 43.975 | 11732.0 |
| 2019-03-05 08:40:00 | AAPL | Stock | 43.9998 | 44.0318 | 43.9998 | 44.0318 | 2660.0 |
| 2019-03-05 08:45:00 | AAPL | Stock | 44.0325 | 44.0325 | 43.9975 | 44.0 | 11596.0 |
| 2019-03-05 08:50:00 | AAPL | Stock | 44.0025 | 44.0125 | 43.9875 | 43.9875 | 16332.0 |
| 2019-03-05 08:55:00 | AAPL | Stock | 43.9875 | 43.9875 | 43.88 | 43.935 | 37360.0 |
| 2019-03-05 09:00:00 | AAPL | Stock | 43.935 | 43.9625 | 43.93 | 43.9625 | 5600.0 |
| 2019-03-05 09:05:00 | AAPL | Stock | 43.9575 | 43.9625 | 43.925 | 43.9375 | 3972.0 |
| 2019-03-05 09:10:00 | AAPL | Stock | 43.94 | 43.9425 | 43.94 | 43.94 | 2000.0 |
| 2019-03-05 09:15:00 | AAPL | Stock | 43.94 | 43.965 | 43.94 | 43.965 | 5188.0 |
| 2019-03-05 09:20:00 | AAPL | Stock | 43.97 | 43.97 | 43.93 | 43.9625 | 6336.0 |
| 2019-03-05 09:25:00 | AAPL | Stock | 43.97 | 43.9775 | 43.9575 | 43.9625 | 10932.0 |
| 2019-03-05 09:30:00 | AAPL | Stock | 43.98 | 44.0 | 43.774 | 43.825 | 2841428.0 |
| 2019-03-05 09:35:00 | AAPL | Stock | 43.825 | 43.965 | 43.7975 | 43.855 | 1595572.0 |
| 2019-03-05 09:40:00 | AAPL | Stock | 43.85 | 43.8875 | 43.8275 | 43.8375 | 1120160.0 |
| 2019-03-05 09:45:00 | AAPL | Stock | 43.8375 | 43.8525 | 43.745 | 43.76 | 1726512.0 |
| 2019-03-05 09:50:00 | AAPL | Stock | 43.7625 | 43.825 | 43.73 | 43.755 | 1461288.0 |
| 2019-03-05 09:55:00 | AAPL | Stock | 43.76 | 43.7975 | 43.6915 | 43.72 | 1325088.0 |
| 2019-03-05 10:00:00 | AAPL | Stock | 43.72 | 43.8475 | 43.72 | 43.8075 | 1479180.0 |
| 2019-03-05 10:05:00 | AAPL | Stock | 43.81 | 43.885 | 43.77 | 43.7775 | 1066672.0 |
| 2019-03-05 10:10:00 | AAPL | Stock | 43.775 | 43.775 | 43.7188 | 43.72 | 1094712.0 |
| 2019-03-05 10:15:00 | AAPL | Stock | 43.7225 | 43.7475 | 43.6375 | 43.67 | 1629832.0 |
| 2019-03-05 10:20:00 | AAPL | Stock | 43.6675 | 43.7825 | 43.645 | 43.7725 | 1253328.0 |
| 2019-03-05 10:25:00 | AAPL | Stock | 43.7725 | 43.7725 | 43.635 | 43.6775 | 1082676.0 |
| 2019-03-05 10:30:00 | AAPL | Stock | 43.675 | 43.8025 | 43.675 | 43.7712 | 1161648.0 |
| 2019-03-05 10:35:00 | AAPL | Stock | 43.77 | 43.7835 | 43.71 | 43.73 | 888224.0 |
| 2019-03-05 10:40:00 | AAPL | Stock | 43.7325 | 43.7725 | 43.7312 | 43.75 | 875292.0 |
> showing 50 of 357,148 rows — these rows as CSV