PREVIEW / stock_5min / 2019-03-14
file: by_date/stock_5min/2019/2019-03-14.parquet size: 5.6 MB rows: 357,875 symbols: 2,645
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-14 04:50:00 | AAPL | Stock | 45.7275 | 45.7325 | 45.7275 | 45.7325 | 800.0 |
| 2019-03-14 05:00:00 | AAPL | Stock | 45.725 | 45.725 | 45.725 | 45.725 | 1200.0 |
| 2019-03-14 05:05:00 | AAPL | Stock | 45.695 | 45.695 | 45.695 | 45.695 | 748.0 |
| 2019-03-14 05:10:00 | AAPL | Stock | 45.725 | 45.74 | 45.725 | 45.74 | 5928.0 |
| 2019-03-14 05:15:00 | AAPL | Stock | 45.7375 | 45.8025 | 45.735 | 45.8 | 10568.0 |
| 2019-03-14 05:25:00 | AAPL | Stock | 45.7875 | 45.7875 | 45.7875 | 45.7875 | 1176.0 |
| 2019-03-14 05:40:00 | AAPL | Stock | 45.7525 | 45.755 | 45.7525 | 45.755 | 800.0 |
| 2019-03-14 05:50:00 | AAPL | Stock | 45.7875 | 45.7875 | 45.7875 | 45.7875 | 1600.0 |
| 2019-03-14 05:55:00 | AAPL | Stock | 45.795 | 45.82 | 45.7875 | 45.8 | 5600.0 |
| 2019-03-14 06:00:00 | AAPL | Stock | 45.825 | 45.825 | 45.675 | 45.7025 | 111432.0 |
| 2019-03-14 06:05:00 | AAPL | Stock | 45.725 | 45.725 | 45.65 | 45.685 | 9088.0 |
| 2019-03-14 06:10:00 | AAPL | Stock | 45.67 | 45.67 | 45.67 | 45.67 | 800.0 |
| 2019-03-14 06:20:00 | AAPL | Stock | 45.7 | 45.7 | 45.675 | 45.675 | 10520.0 |
| 2019-03-14 06:25:00 | AAPL | Stock | 45.65 | 45.6525 | 45.6375 | 45.6375 | 4452.0 |
| 2019-03-14 06:30:00 | AAPL | Stock | 45.6725 | 45.7 | 45.6725 | 45.7 | 7672.0 |
| 2019-03-14 06:35:00 | AAPL | Stock | 45.7 | 45.85 | 45.6925 | 45.83 | 49768.0 |
| 2019-03-14 06:40:00 | AAPL | Stock | 45.8625 | 45.865 | 45.83 | 45.865 | 9264.0 |
| 2019-03-14 06:45:00 | AAPL | Stock | 45.805 | 45.85 | 45.805 | 45.85 | 11200.0 |
| 2019-03-14 06:50:00 | AAPL | Stock | 45.8025 | 45.8025 | 45.7575 | 45.7575 | 8324.0 |
| 2019-03-14 06:55:00 | AAPL | Stock | 45.765 | 45.8 | 45.7575 | 45.78 | 21340.0 |
| 2019-03-14 07:00:00 | AAPL | Stock | 45.78 | 45.8175 | 45.7675 | 45.79 | 22148.0 |
| 2019-03-14 07:05:00 | AAPL | Stock | 45.7875 | 45.85 | 45.7875 | 45.8475 | 26804.0 |
| 2019-03-14 07:10:00 | AAPL | Stock | 45.845 | 45.8475 | 45.795 | 45.825 | 21380.0 |
| 2019-03-14 07:15:00 | AAPL | Stock | 45.84 | 45.8475 | 45.8075 | 45.825 | 12476.0 |
| 2019-03-14 07:20:00 | AAPL | Stock | 45.805 | 45.825 | 45.7925 | 45.8 | 27444.0 |
| 2019-03-14 07:25:00 | AAPL | Stock | 45.8 | 45.86 | 45.8 | 45.86 | 30560.0 |
| 2019-03-14 07:30:00 | AAPL | Stock | 45.8475 | 45.8575 | 45.8275 | 45.8325 | 19912.0 |
| 2019-03-14 07:35:00 | AAPL | Stock | 45.83 | 45.89 | 45.83 | 45.89 | 30368.0 |
| 2019-03-14 07:40:00 | AAPL | Stock | 45.8625 | 45.8625 | 45.845 | 45.845 | 8084.0 |
| 2019-03-14 07:45:00 | AAPL | Stock | 45.855 | 45.9375 | 45.855 | 45.92 | 30128.0 |
| 2019-03-14 07:50:00 | AAPL | Stock | 45.8875 | 45.9375 | 45.8875 | 45.9175 | 24800.0 |
| 2019-03-14 07:55:00 | AAPL | Stock | 45.915 | 45.9625 | 45.905 | 45.9375 | 49084.0 |
| 2019-03-14 08:00:00 | AAPL | Stock | 45.8022 | 45.9525 | 45.5425 | 45.925 | 114364.0 |
| 2019-03-14 08:05:00 | AAPL | Stock | 45.9125 | 45.95 | 45.9125 | 45.95 | 48048.0 |
| 2019-03-14 08:10:00 | AAPL | Stock | 45.9475 | 45.9875 | 45.9475 | 45.9675 | 64304.0 |
| 2019-03-14 08:15:00 | AAPL | Stock | 45.97 | 45.97 | 45.875 | 45.875 | 65400.0 |
| 2019-03-14 08:20:00 | AAPL | Stock | 45.8775 | 45.9025 | 45.875 | 45.88 | 28516.0 |
| 2019-03-14 08:25:00 | AAPL | Stock | 45.915 | 45.935 | 45.8875 | 45.93 | 10624.0 |
| 2019-03-14 08:30:00 | AAPL | Stock | 45.9425 | 45.9425 | 45.9125 | 45.9125 | 20068.0 |
| 2019-03-14 08:35:00 | AAPL | Stock | 45.925 | 45.955 | 45.89 | 45.955 | 53800.0 |
| 2019-03-14 08:40:00 | AAPL | Stock | 45.95 | 45.97 | 45.9475 | 45.95 | 7600.0 |
| 2019-03-14 08:45:00 | AAPL | Stock | 45.945 | 45.9875 | 45.9275 | 45.97 | 53128.0 |
| 2019-03-14 08:50:00 | AAPL | Stock | 45.9625 | 46.0 | 45.9625 | 45.9925 | 41524.0 |
| 2019-03-14 08:55:00 | AAPL | Stock | 45.9925 | 46.0 | 45.9525 | 45.975 | 77708.0 |
| 2019-03-14 09:00:00 | AAPL | Stock | 45.9525 | 45.9925 | 45.9525 | 45.9925 | 58852.0 |
| 2019-03-14 09:05:00 | AAPL | Stock | 45.9875 | 46.04 | 45.9725 | 45.9975 | 139692.0 |
| 2019-03-14 09:10:00 | AAPL | Stock | 45.9975 | 46.025 | 45.9775 | 45.9925 | 152272.0 |
| 2019-03-14 09:15:00 | AAPL | Stock | 45.9875 | 46.04 | 45.9775 | 46.025 | 101708.0 |
| 2019-03-14 09:20:00 | AAPL | Stock | 46.025 | 46.045 | 46.015 | 46.035 | 61716.0 |
| 2019-03-14 09:25:00 | AAPL | Stock | 46.0325 | 46.0325 | 45.95 | 45.9825 | 115204.0 |
> showing 50 of 357,875 rows — these rows as CSV