PREVIEW / stock_1min / 2020-01-13
file: by_date/stock_1min/2020/2020-01-13.parquet size: 18.5 MB rows: 1,149,582 symbols: 2,088
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 |
|---|---|---|---|---|---|---|---|
| 2020-01-13 04:00:00 | AAPL | Stock | 77.8825 | 77.8825 | 77.8825 | 77.8825 | 460.0 |
| 2020-01-13 04:01:00 | AAPL | Stock | 77.98 | 77.98 | 77.98 | 77.98 | 1180.0 |
| 2020-01-13 04:08:00 | AAPL | Stock | 77.975 | 77.975 | 77.975 | 77.975 | 1880.0 |
| 2020-01-13 04:09:00 | AAPL | Stock | 77.8875 | 77.8875 | 77.8875 | 77.8875 | 2000.0 |
| 2020-01-13 04:15:00 | AAPL | Stock | 77.975 | 77.975 | 77.975 | 77.975 | 400.0 |
| 2020-01-13 04:16:00 | AAPL | Stock | 77.975 | 77.975 | 77.975 | 77.975 | 400.0 |
| 2020-01-13 04:17:00 | AAPL | Stock | 77.925 | 77.95 | 77.9075 | 77.9075 | 3388.0 |
| 2020-01-13 04:18:00 | AAPL | Stock | 77.905 | 77.95 | 77.905 | 77.95 | 1080.0 |
| 2020-01-13 04:19:00 | AAPL | Stock | 77.9375 | 77.9375 | 77.9375 | 77.9375 | 1200.0 |
| 2020-01-13 04:22:00 | AAPL | Stock | 77.9125 | 77.9125 | 77.875 | 77.875 | 7768.0 |
| 2020-01-13 04:23:00 | AAPL | Stock | 77.9375 | 77.9375 | 77.9375 | 77.9375 | 656.0 |
| 2020-01-13 04:29:00 | AAPL | Stock | 77.9375 | 77.9375 | 77.9375 | 77.9375 | 1600.0 |
| 2020-01-13 04:30:00 | AAPL | Stock | 77.9 | 77.9 | 77.9 | 77.9 | 400.0 |
| 2020-01-13 04:36:00 | AAPL | Stock | 77.9475 | 77.95 | 77.9475 | 77.95 | 2124.0 |
| 2020-01-13 04:41:00 | AAPL | Stock | 77.95 | 77.955 | 77.95 | 77.955 | 2000.0 |
| 2020-01-13 04:46:00 | AAPL | Stock | 77.925 | 77.925 | 77.925 | 77.925 | 800.0 |
| 2020-01-13 04:47:00 | AAPL | Stock | 77.9875 | 77.9875 | 77.9875 | 77.9875 | 5196.0 |
| 2020-01-13 04:50:00 | AAPL | Stock | 77.9825 | 77.9825 | 77.9825 | 77.9825 | 1024.0 |
| 2020-01-13 04:55:00 | AAPL | Stock | 77.975 | 77.975 | 77.975 | 77.975 | 400.0 |
| 2020-01-13 04:56:00 | AAPL | Stock | 77.975 | 77.975 | 77.95 | 77.975 | 21000.0 |
| 2020-01-13 05:04:00 | AAPL | Stock | 77.975 | 77.975 | 77.975 | 77.975 | 400.0 |
| 2020-01-13 05:07:00 | AAPL | Stock | 77.975 | 77.975 | 77.975 | 77.975 | 400.0 |
| 2020-01-13 05:13:00 | AAPL | Stock | 77.9525 | 77.9525 | 77.9525 | 77.9525 | 1000.0 |
| 2020-01-13 05:14:00 | AAPL | Stock | 77.9375 | 77.9375 | 77.9375 | 77.9375 | 1604.0 |
| 2020-01-13 05:15:00 | AAPL | Stock | 77.95 | 77.95 | 77.95 | 77.95 | 13600.0 |
| 2020-01-13 05:16:00 | AAPL | Stock | 77.95 | 77.95 | 77.95 | 77.95 | 800.0 |
| 2020-01-13 05:17:00 | AAPL | Stock | 77.9375 | 77.9375 | 77.9375 | 77.9375 | 400.0 |
| 2020-01-13 05:19:00 | AAPL | Stock | 77.925 | 77.925 | 77.9175 | 77.9175 | 1320.0 |
| 2020-01-13 05:31:00 | AAPL | Stock | 77.92 | 77.92 | 77.9125 | 77.9125 | 908.0 |
| 2020-01-13 05:33:00 | AAPL | Stock | 77.9125 | 77.9175 | 77.9125 | 77.9175 | 1200.0 |
| 2020-01-13 05:34:00 | AAPL | Stock | 77.9125 | 77.9125 | 77.9125 | 77.9125 | 800.0 |
| 2020-01-13 05:36:00 | AAPL | Stock | 77.92 | 77.92 | 77.92 | 77.92 | 4880.0 |
| 2020-01-13 05:42:00 | AAPL | Stock | 77.9125 | 77.925 | 77.9125 | 77.925 | 5108.0 |
| 2020-01-13 05:43:00 | AAPL | Stock | 77.925 | 77.925 | 77.925 | 77.925 | 4000.0 |
| 2020-01-13 05:45:00 | AAPL | Stock | 77.925 | 77.925 | 77.925 | 77.925 | 3432.0 |
| 2020-01-13 05:47:00 | AAPL | Stock | 77.97 | 77.9875 | 77.97 | 77.9875 | 6000.0 |
| 2020-01-13 05:48:00 | AAPL | Stock | 77.9875 | 77.9875 | 77.9875 | 77.9875 | 4400.0 |
| 2020-01-13 05:49:00 | AAPL | Stock | 78.0 | 78.0 | 78.0 | 78.0 | 708.0 |
| 2020-01-13 06:02:00 | AAPL | Stock | 77.9875 | 77.9875 | 77.9875 | 77.9875 | 604.0 |
| 2020-01-13 06:06:00 | AAPL | Stock | 77.9875 | 77.9875 | 77.9875 | 77.9875 | 400.0 |
| 2020-01-13 06:08:00 | AAPL | Stock | 77.9975 | 77.9975 | 77.9975 | 77.9975 | 1200.0 |
| 2020-01-13 06:14:00 | AAPL | Stock | 77.9125 | 77.9125 | 77.9125 | 77.9125 | 400.0 |
| 2020-01-13 06:16:00 | AAPL | Stock | 77.915 | 77.915 | 77.915 | 77.915 | 592.0 |
| 2020-01-13 06:17:00 | AAPL | Stock | 77.915 | 77.915 | 77.915 | 77.915 | 400.0 |
| 2020-01-13 06:25:00 | AAPL | Stock | 77.9125 | 77.9125 | 77.9125 | 77.9125 | 5148.0 |
| 2020-01-13 06:29:00 | AAPL | Stock | 77.95 | 77.95 | 77.95 | 77.95 | 4000.0 |
| 2020-01-13 06:33:00 | AAPL | Stock | 77.95 | 77.95 | 77.95 | 77.95 | 19972.0 |
| 2020-01-13 06:35:00 | AAPL | Stock | 77.965 | 78.05 | 77.965 | 78.05 | 12972.0 |
| 2020-01-13 06:36:00 | AAPL | Stock | 78.05 | 78.125 | 78.05 | 78.0975 | 6604.0 |
| 2020-01-13 06:42:00 | AAPL | Stock | 78.0 | 78.0 | 78.0 | 78.0 | 600.0 |
> showing 50 of 1,149,582 rows — these rows as CSV