PREVIEW / stock_5min / 2020-08-18
file: by_date/stock_5min/2020/2020-08-18.parquet size: 6.5 MB rows: 411,182 symbols: 2,444
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-18 04:00:00 | AAPL | Stock | 114.6825 | 114.75 | 114.595 | 114.75 | 4424.0 |
| 2020-08-18 04:05:00 | AAPL | Stock | 114.75 | 114.75 | 114.75 | 114.75 | 400.0 |
| 2020-08-18 04:10:00 | AAPL | Stock | 114.95 | 114.95 | 114.95 | 114.95 | 2320.0 |
| 2020-08-18 04:15:00 | AAPL | Stock | 114.9925 | 114.9975 | 114.9925 | 114.9975 | 9044.0 |
| 2020-08-18 04:20:00 | AAPL | Stock | 114.9625 | 114.9625 | 114.86 | 114.86 | 4700.0 |
| 2020-08-18 04:30:00 | AAPL | Stock | 114.925 | 114.9975 | 114.9 | 114.9975 | 1224.0 |
| 2020-08-18 04:40:00 | AAPL | Stock | 114.9 | 114.925 | 114.9 | 114.925 | 1004.0 |
| 2020-08-18 04:55:00 | AAPL | Stock | 114.95 | 114.95 | 114.95 | 114.95 | 2932.0 |
| 2020-08-18 05:00:00 | AAPL | Stock | 114.9975 | 115.0 | 114.9975 | 115.0 | 2708.0 |
| 2020-08-18 05:05:00 | AAPL | Stock | 115.0 | 115.0 | 115.0 | 115.0 | 1200.0 |
| 2020-08-18 05:10:00 | AAPL | Stock | 115.1 | 115.1 | 114.95 | 114.95 | 800.0 |
| 2020-08-18 05:15:00 | AAPL | Stock | 115.1 | 115.1 | 115.1 | 115.1 | 400.0 |
| 2020-08-18 05:25:00 | AAPL | Stock | 115.115 | 115.115 | 115.1125 | 115.1125 | 800.0 |
| 2020-08-18 05:30:00 | AAPL | Stock | 115.17 | 115.17 | 115.17 | 115.17 | 404.0 |
| 2020-08-18 05:35:00 | AAPL | Stock | 115.1375 | 115.1375 | 115.1375 | 115.1375 | 1968.0 |
| 2020-08-18 05:45:00 | AAPL | Stock | 115.125 | 115.125 | 115.12 | 115.12 | 2128.0 |
| 2020-08-18 05:50:00 | AAPL | Stock | 115.1375 | 115.1375 | 115.1375 | 115.1375 | 1600.0 |
| 2020-08-18 06:00:00 | AAPL | Stock | 115.1125 | 115.1125 | 115.1125 | 115.1125 | 400.0 |
| 2020-08-18 06:05:00 | AAPL | Stock | 115.125 | 115.1825 | 115.0575 | 115.0575 | 5880.0 |
| 2020-08-18 06:10:00 | AAPL | Stock | 115.0625 | 115.0625 | 115.0625 | 115.0625 | 800.0 |
| 2020-08-18 06:15:00 | AAPL | Stock | 115.025 | 115.0275 | 115.0125 | 115.0125 | 2400.0 |
| 2020-08-18 06:20:00 | AAPL | Stock | 115.0 | 115.0 | 115.0 | 115.0 | 400.0 |
| 2020-08-18 06:25:00 | AAPL | Stock | 115.0 | 115.0 | 115.0 | 115.0 | 1880.0 |
| 2020-08-18 06:30:00 | AAPL | Stock | 115.0475 | 115.05 | 115.0475 | 115.05 | 2164.0 |
| 2020-08-18 06:35:00 | AAPL | Stock | 115.025 | 115.025 | 115.025 | 115.025 | 400.0 |
| 2020-08-18 06:40:00 | AAPL | Stock | 115.0275 | 115.0275 | 114.995 | 115.0 | 4244.0 |
| 2020-08-18 06:45:00 | AAPL | Stock | 115.0 | 115.0 | 115.0 | 115.0 | 840.0 |
| 2020-08-18 06:55:00 | AAPL | Stock | 115.04 | 115.045 | 115.025 | 115.025 | 2480.0 |
| 2020-08-18 07:00:00 | AAPL | Stock | 115.1 | 115.1 | 114.95 | 114.95 | 43020.0 |
| 2020-08-18 07:05:00 | AAPL | Stock | 114.9825 | 114.9825 | 114.6125 | 114.625 | 90760.0 |
| 2020-08-18 07:10:00 | AAPL | Stock | 114.6325 | 114.645 | 114.5425 | 114.5425 | 23012.0 |
| 2020-08-18 07:15:00 | AAPL | Stock | 114.5425 | 114.5475 | 114.285 | 114.29 | 63368.0 |
| 2020-08-18 07:20:00 | AAPL | Stock | 114.2925 | 114.4 | 114.2125 | 114.375 | 47076.0 |
| 2020-08-18 07:25:00 | AAPL | Stock | 114.3475 | 114.3975 | 114.1875 | 114.1875 | 43716.0 |
| 2020-08-18 07:30:00 | AAPL | Stock | 114.2125 | 114.24 | 114.175 | 114.195 | 25788.0 |
| 2020-08-18 07:35:00 | AAPL | Stock | 114.2125 | 114.375 | 114.2125 | 114.375 | 27156.0 |
| 2020-08-18 07:40:00 | AAPL | Stock | 114.3875 | 114.47 | 114.3475 | 114.3475 | 14304.0 |
| 2020-08-18 07:45:00 | AAPL | Stock | 114.3475 | 114.3725 | 114.325 | 114.325 | 11628.0 |
| 2020-08-18 07:50:00 | AAPL | Stock | 114.3 | 114.3 | 114.2475 | 114.26 | 14336.0 |
| 2020-08-18 07:55:00 | AAPL | Stock | 114.2475 | 114.325 | 114.2475 | 114.325 | 19320.0 |
| 2020-08-18 08:00:00 | AAPL | Stock | 114.65 | 115.17 | 114.1575 | 114.2052 | 164952.0 |
| 2020-08-18 08:05:00 | AAPL | Stock | 114.205 | 114.3125 | 114.125 | 114.3125 | 36528.0 |
| 2020-08-18 08:10:00 | AAPL | Stock | 114.32 | 114.4625 | 114.32 | 114.435 | 51296.0 |
| 2020-08-18 08:15:00 | AAPL | Stock | 114.435 | 114.4625 | 114.3825 | 114.4375 | 24708.0 |
| 2020-08-18 08:20:00 | AAPL | Stock | 114.4375 | 114.457 | 114.3825 | 114.3875 | 26452.0 |
| 2020-08-18 08:25:00 | AAPL | Stock | 114.4075 | 114.4475 | 114.4 | 114.42 | 19036.0 |
| 2020-08-18 08:30:00 | AAPL | Stock | 114.39 | 114.48 | 114.3525 | 114.395 | 51152.0 |
| 2020-08-18 08:35:00 | AAPL | Stock | 114.3892 | 114.8125 | 114.3892 | 114.7538 | 76888.0 |
| 2020-08-18 08:40:00 | AAPL | Stock | 114.7875 | 114.875 | 114.675 | 114.75 | 86344.0 |
| 2020-08-18 08:45:00 | AAPL | Stock | 114.75 | 114.75 | 114.54 | 114.6625 | 55784.0 |
> showing 50 of 411,182 rows — these rows as CSV