PREVIEW / stock_5min / 2019-04-16
file: by_date/stock_5min/2019/2019-04-16.parquet size: 5.7 MB rows: 356,081 symbols: 2,624
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-04-16 04:00:00 | AAPL | Stock | 49.8975 | 49.8975 | 49.8475 | 49.8475 | 1212.0 |
| 2019-04-16 04:10:00 | AAPL | Stock | 49.98 | 49.98 | 49.98 | 49.98 | 400.0 |
| 2019-04-16 04:15:00 | AAPL | Stock | 49.995 | 49.9975 | 49.9825 | 49.9825 | 6812.0 |
| 2019-04-16 04:20:00 | AAPL | Stock | 49.9825 | 49.9825 | 49.9425 | 49.9425 | 2592.0 |
| 2019-04-16 04:30:00 | AAPL | Stock | 50.0175 | 50.0175 | 50.0175 | 50.0175 | 400.0 |
| 2019-04-16 05:45:00 | AAPL | Stock | 50.0225 | 50.025 | 50.0225 | 50.025 | 872.0 |
| 2019-04-16 06:10:00 | AAPL | Stock | 49.975 | 49.975 | 49.975 | 49.975 | 2000.0 |
| 2019-04-16 06:25:00 | AAPL | Stock | 49.975 | 49.975 | 49.975 | 49.975 | 1140.0 |
| 2019-04-16 06:45:00 | AAPL | Stock | 49.9675 | 49.9675 | 49.9675 | 49.9675 | 800.0 |
| 2019-04-16 06:50:00 | AAPL | Stock | 49.9675 | 49.9675 | 49.9675 | 49.9675 | 1360.0 |
| 2019-04-16 07:00:00 | AAPL | Stock | 49.9275 | 49.97 | 49.915 | 49.9425 | 10372.0 |
| 2019-04-16 07:05:00 | AAPL | Stock | 49.9425 | 49.95 | 49.935 | 49.95 | 22400.0 |
| 2019-04-16 07:10:00 | AAPL | Stock | 49.95 | 49.955 | 49.95 | 49.955 | 6396.0 |
| 2019-04-16 07:15:00 | AAPL | Stock | 49.95 | 49.95 | 49.9375 | 49.9375 | 2800.0 |
| 2019-04-16 07:25:00 | AAPL | Stock | 49.9375 | 49.9475 | 49.9375 | 49.9475 | 6000.0 |
| 2019-04-16 07:30:00 | AAPL | Stock | 49.94 | 49.94 | 49.94 | 49.94 | 408.0 |
| 2019-04-16 07:35:00 | AAPL | Stock | 49.9475 | 49.96 | 49.9475 | 49.96 | 5600.0 |
| 2019-04-16 07:40:00 | AAPL | Stock | 49.96 | 49.9625 | 49.96 | 49.9625 | 6800.0 |
| 2019-04-16 07:45:00 | AAPL | Stock | 49.98 | 49.9875 | 49.965 | 49.975 | 13436.0 |
| 2019-04-16 07:50:00 | AAPL | Stock | 49.9775 | 49.9875 | 49.9775 | 49.9875 | 8680.0 |
| 2019-04-16 07:55:00 | AAPL | Stock | 49.9875 | 49.9875 | 49.985 | 49.9875 | 10472.0 |
| 2019-04-16 08:00:00 | AAPL | Stock | 49.97 | 49.995 | 49.915 | 49.9925 | 62800.0 |
| 2019-04-16 08:05:00 | AAPL | Stock | 49.9975 | 50.0 | 49.9975 | 50.0 | 34288.0 |
| 2019-04-16 08:10:00 | AAPL | Stock | 50.0 | 50.005 | 49.995 | 49.995 | 38756.0 |
| 2019-04-16 08:15:00 | AAPL | Stock | 49.995 | 50.0 | 49.985 | 49.9975 | 7100.0 |
| 2019-04-16 08:20:00 | AAPL | Stock | 49.995 | 50.0125 | 49.9875 | 49.9875 | 11000.0 |
| 2019-04-16 08:30:00 | AAPL | Stock | 49.9925 | 49.9925 | 49.975 | 49.975 | 2056.0 |
| 2019-04-16 08:35:00 | AAPL | Stock | 49.975 | 49.985 | 49.975 | 49.975 | 4000.0 |
| 2019-04-16 08:40:00 | AAPL | Stock | 49.975 | 49.975 | 49.9625 | 49.9675 | 5800.0 |
| 2019-04-16 08:45:00 | AAPL | Stock | 49.9725 | 49.9725 | 49.9625 | 49.9725 | 15376.0 |
| 2019-04-16 08:50:00 | AAPL | Stock | 49.9625 | 49.9725 | 49.9625 | 49.9725 | 800.0 |
| 2019-04-16 08:55:00 | AAPL | Stock | 49.9725 | 49.99 | 49.9625 | 49.97 | 8164.0 |
| 2019-04-16 09:00:00 | AAPL | Stock | 49.9675 | 49.975 | 49.965 | 49.975 | 10796.0 |
| 2019-04-16 09:05:00 | AAPL | Stock | 49.9875 | 50.01 | 49.985 | 50.0 | 39436.0 |
| 2019-04-16 09:10:00 | AAPL | Stock | 50.0075 | 50.01 | 49.99 | 49.99 | 8716.0 |
| 2019-04-16 09:15:00 | AAPL | Stock | 49.99 | 49.995 | 49.9675 | 49.975 | 7708.0 |
| 2019-04-16 09:20:00 | AAPL | Stock | 49.99 | 49.99 | 49.9625 | 49.965 | 9676.0 |
| 2019-04-16 09:25:00 | AAPL | Stock | 49.965 | 49.965 | 49.785 | 49.85 | 122644.0 |
| 2019-04-16 09:30:00 | AAPL | Stock | 49.865 | 49.8875 | 49.7575 | 49.805 | 3820680.0 |
| 2019-04-16 09:35:00 | AAPL | Stock | 49.805 | 49.8575 | 49.7525 | 49.8475 | 1653040.0 |
| 2019-04-16 09:40:00 | AAPL | Stock | 49.8475 | 49.995 | 49.8275 | 49.9925 | 1875604.0 |
| 2019-04-16 09:45:00 | AAPL | Stock | 49.9875 | 50.0 | 49.8775 | 49.88 | 1137708.0 |
| 2019-04-16 09:50:00 | AAPL | Stock | 49.88 | 49.94 | 49.8675 | 49.939 | 1059960.0 |
| 2019-04-16 09:55:00 | AAPL | Stock | 49.9375 | 49.9725 | 49.9075 | 49.9655 | 763032.0 |
| 2019-04-16 10:00:00 | AAPL | Stock | 49.9675 | 49.99 | 49.95 | 49.971 | 1231668.0 |
| 2019-04-16 10:05:00 | AAPL | Stock | 49.9725 | 49.9812 | 49.9175 | 49.9175 | 805344.0 |
| 2019-04-16 10:10:00 | AAPL | Stock | 49.92 | 50.1688 | 49.91 | 50.1475 | 4211472.0 |
| 2019-04-16 10:15:00 | AAPL | Stock | 50.1425 | 50.19 | 50.105 | 50.1768 | 2282412.0 |
| 2019-04-16 10:20:00 | AAPL | Stock | 50.1758 | 50.275 | 50.1725 | 50.2725 | 2751140.0 |
| 2019-04-16 10:25:00 | AAPL | Stock | 50.275 | 50.3425 | 50.265 | 50.3388 | 2284052.0 |
> showing 50 of 356,081 rows — these rows as CSV