PREVIEW / stock_5min / 2020-08-13
file: by_date/stock_5min/2020/2020-08-13.parquet size: 6.5 MB rows: 406,272 symbols: 2,429
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-08-13 04:00:00 | AAPL | Stock | 113.1225 | 113.1225 | 112.8375 | 112.8375 | 2572.0 |
| 2020-08-13 04:05:00 | AAPL | Stock | 112.825 | 112.825 | 112.825 | 112.825 | 400.0 |
| 2020-08-13 04:10:00 | AAPL | Stock | 112.7875 | 112.7875 | 112.7875 | 112.7875 | 800.0 |
| 2020-08-13 04:15:00 | AAPL | Stock | 112.73 | 112.73 | 112.73 | 112.73 | 992.0 |
| 2020-08-13 04:20:00 | AAPL | Stock | 112.7225 | 112.75 | 112.7125 | 112.7125 | 1600.0 |
| 2020-08-13 04:30:00 | AAPL | Stock | 112.675 | 112.675 | 112.675 | 112.675 | 800.0 |
| 2020-08-13 04:35:00 | AAPL | Stock | 112.765 | 112.765 | 112.765 | 112.765 | 400.0 |
| 2020-08-13 04:40:00 | AAPL | Stock | 112.765 | 112.775 | 112.765 | 112.775 | 1324.0 |
| 2020-08-13 04:45:00 | AAPL | Stock | 112.825 | 112.825 | 112.825 | 112.825 | 400.0 |
| 2020-08-13 04:50:00 | AAPL | Stock | 112.875 | 112.925 | 112.875 | 112.925 | 848.0 |
| 2020-08-13 05:10:00 | AAPL | Stock | 112.9175 | 112.9175 | 112.9175 | 112.9175 | 400.0 |
| 2020-08-13 05:15:00 | AAPL | Stock | 112.875 | 112.875 | 112.875 | 112.875 | 952.0 |
| 2020-08-13 05:20:00 | AAPL | Stock | 112.8725 | 112.875 | 112.8725 | 112.875 | 1520.0 |
| 2020-08-13 05:30:00 | AAPL | Stock | 112.875 | 112.875 | 112.875 | 112.875 | 1976.0 |
| 2020-08-13 05:35:00 | AAPL | Stock | 112.875 | 112.875 | 112.875 | 112.875 | 3200.0 |
| 2020-08-13 06:00:00 | AAPL | Stock | 112.915 | 113.265 | 112.875 | 113.12 | 29408.0 |
| 2020-08-13 06:05:00 | AAPL | Stock | 113.2875 | 113.2875 | 113.1875 | 113.1925 | 12928.0 |
| 2020-08-13 06:10:00 | AAPL | Stock | 113.235 | 113.25 | 113.235 | 113.25 | 2628.0 |
| 2020-08-13 06:15:00 | AAPL | Stock | 113.2925 | 113.6925 | 113.2925 | 113.575 | 14496.0 |
| 2020-08-13 06:20:00 | AAPL | Stock | 113.525 | 113.525 | 113.4575 | 113.47 | 1600.0 |
| 2020-08-13 06:25:00 | AAPL | Stock | 113.5375 | 113.6225 | 113.5375 | 113.6225 | 3604.0 |
| 2020-08-13 06:30:00 | AAPL | Stock | 113.5425 | 113.5425 | 113.5425 | 113.5425 | 2400.0 |
| 2020-08-13 06:35:00 | AAPL | Stock | 113.6025 | 113.6025 | 113.505 | 113.505 | 4800.0 |
| 2020-08-13 06:40:00 | AAPL | Stock | 113.525 | 113.525 | 113.525 | 113.525 | 1596.0 |
| 2020-08-13 06:45:00 | AAPL | Stock | 113.47 | 113.475 | 113.47 | 113.475 | 1600.0 |
| 2020-08-13 06:50:00 | AAPL | Stock | 113.555 | 113.555 | 113.48 | 113.48 | 6800.0 |
| 2020-08-13 06:55:00 | AAPL | Stock | 113.495 | 113.495 | 113.495 | 113.495 | 944.0 |
| 2020-08-13 07:00:00 | AAPL | Stock | 113.505 | 113.635 | 113.2575 | 113.635 | 105964.0 |
| 2020-08-13 07:05:00 | AAPL | Stock | 113.705 | 113.75 | 113.6 | 113.6875 | 100664.0 |
| 2020-08-13 07:10:00 | AAPL | Stock | 113.66 | 113.695 | 113.6175 | 113.6175 | 10524.0 |
| 2020-08-13 07:15:00 | AAPL | Stock | 113.6475 | 113.6625 | 113.6 | 113.6625 | 19864.0 |
| 2020-08-13 07:20:00 | AAPL | Stock | 113.6825 | 113.75 | 113.625 | 113.63 | 72192.0 |
| 2020-08-13 07:25:00 | AAPL | Stock | 113.575 | 113.6275 | 113.5025 | 113.6275 | 24436.0 |
| 2020-08-13 07:30:00 | AAPL | Stock | 113.6375 | 113.6875 | 113.565 | 113.565 | 18276.0 |
| 2020-08-13 07:35:00 | AAPL | Stock | 113.5875 | 113.595 | 113.515 | 113.5225 | 4804.0 |
| 2020-08-13 07:40:00 | AAPL | Stock | 113.5575 | 113.6 | 113.5225 | 113.5225 | 9396.0 |
| 2020-08-13 07:45:00 | AAPL | Stock | 113.515 | 113.515 | 113.425 | 113.45 | 31404.0 |
| 2020-08-13 07:50:00 | AAPL | Stock | 113.475 | 113.4975 | 113.4525 | 113.4975 | 10060.0 |
| 2020-08-13 07:55:00 | AAPL | Stock | 113.5 | 113.7175 | 113.5 | 113.6875 | 28972.0 |
| 2020-08-13 08:00:00 | AAPL | Stock | 113.625 | 113.75 | 113.2575 | 113.6625 | 232284.0 |
| 2020-08-13 08:05:00 | AAPL | Stock | 113.6625 | 113.75 | 113.6625 | 113.7 | 119144.0 |
| 2020-08-13 08:10:00 | AAPL | Stock | 113.7225 | 113.9125 | 113.4875 | 113.8775 | 173048.0 |
| 2020-08-13 08:15:00 | AAPL | Stock | 113.8875 | 113.91 | 113.8375 | 113.85 | 70312.0 |
| 2020-08-13 08:20:00 | AAPL | Stock | 113.87 | 113.875 | 113.625 | 113.8575 | 85312.0 |
| 2020-08-13 08:25:00 | AAPL | Stock | 113.85 | 113.9 | 113.8115 | 113.8115 | 47844.0 |
| 2020-08-13 08:30:00 | AAPL | Stock | 113.8725 | 114.25 | 113.825 | 114.1925 | 225744.0 |
| 2020-08-13 08:35:00 | AAPL | Stock | 114.2025 | 114.2875 | 114.185 | 114.2062 | 230104.0 |
| 2020-08-13 08:40:00 | AAPL | Stock | 114.1925 | 114.2862 | 114.1625 | 114.165 | 122080.0 |
| 2020-08-13 08:45:00 | AAPL | Stock | 114.1875 | 114.31 | 114.0805 | 114.26 | 111864.0 |
| 2020-08-13 08:50:00 | AAPL | Stock | 114.2575 | 114.4825 | 114.2125 | 114.44 | 301444.0 |
> showing 50 of 406,272 rows — these rows as CSV