PREVIEW / stock_5min / 2021-03-18
file: by_date/stock_5min/2021/2021-03-18.parquet size: 7.9 MB rows: 491,741 symbols: 2,909
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 |
|---|---|---|---|---|---|---|---|
| 2021-03-18 04:00:00 | AAPL | Stock | 123.36 | 124.27 | 123.36 | 123.7 | 11947.0 |
| 2021-03-18 04:05:00 | AAPL | Stock | 123.8 | 124.27 | 123.74 | 123.8 | 2663.0 |
| 2021-03-18 04:10:00 | AAPL | Stock | 123.89 | 123.89 | 123.86 | 123.86 | 1093.0 |
| 2021-03-18 04:15:00 | AAPL | Stock | 123.82 | 124.15 | 123.8 | 124.11 | 2931.0 |
| 2021-03-18 04:20:00 | AAPL | Stock | 124.01 | 124.01 | 123.85 | 123.85 | 200.0 |
| 2021-03-18 04:25:00 | AAPL | Stock | 123.85 | 123.86 | 123.8 | 123.85 | 2314.0 |
| 2021-03-18 04:30:00 | AAPL | Stock | 123.96 | 123.96 | 123.85 | 123.85 | 1483.0 |
| 2021-03-18 04:35:00 | AAPL | Stock | 123.76 | 123.76 | 123.33 | 123.66 | 5455.0 |
| 2021-03-18 04:40:00 | AAPL | Stock | 123.58 | 123.58 | 123.33 | 123.33 | 1172.0 |
| 2021-03-18 04:45:00 | AAPL | Stock | 123.26 | 123.36 | 123.17 | 123.17 | 3736.0 |
| 2021-03-18 04:50:00 | AAPL | Stock | 123.23 | 123.23 | 123.2 | 123.2 | 2813.0 |
| 2021-03-18 04:55:00 | AAPL | Stock | 123.37 | 123.37 | 123.04 | 123.04 | 4968.0 |
| 2021-03-18 05:00:00 | AAPL | Stock | 123.19 | 123.28 | 123.17 | 123.17 | 2943.0 |
| 2021-03-18 05:05:00 | AAPL | Stock | 123.13 | 123.3 | 123.13 | 123.25 | 884.0 |
| 2021-03-18 05:10:00 | AAPL | Stock | 123.13 | 123.4 | 123.02 | 123.35 | 2562.0 |
| 2021-03-18 05:15:00 | AAPL | Stock | 123.39 | 123.51 | 123.39 | 123.41 | 1860.0 |
| 2021-03-18 05:20:00 | AAPL | Stock | 123.46 | 123.5 | 123.46 | 123.49 | 1302.0 |
| 2021-03-18 05:25:00 | AAPL | Stock | 123.45 | 123.45 | 123.3 | 123.35 | 481.0 |
| 2021-03-18 05:35:00 | AAPL | Stock | 123.57 | 123.6 | 123.57 | 123.6 | 1204.0 |
| 2021-03-18 05:40:00 | AAPL | Stock | 123.6 | 123.64 | 123.57 | 123.64 | 4048.0 |
| 2021-03-18 05:45:00 | AAPL | Stock | 123.7 | 123.7 | 123.54 | 123.62 | 800.0 |
| 2021-03-18 05:50:00 | AAPL | Stock | 123.54 | 123.54 | 123.54 | 123.54 | 221.0 |
| 2021-03-18 05:55:00 | AAPL | Stock | 123.62 | 123.62 | 123.13 | 123.42 | 1827.0 |
| 2021-03-18 06:10:00 | AAPL | Stock | 123.6 | 123.61 | 123.6 | 123.61 | 1367.0 |
| 2021-03-18 06:15:00 | AAPL | Stock | 123.57 | 123.57 | 123.57 | 123.57 | 200.0 |
| 2021-03-18 06:20:00 | AAPL | Stock | 123.6 | 123.69 | 123.6 | 123.6 | 1874.0 |
| 2021-03-18 06:25:00 | AAPL | Stock | 123.45 | 123.62 | 123.45 | 123.61 | 1050.0 |
| 2021-03-18 06:30:00 | AAPL | Stock | 123.63 | 123.8 | 123.63 | 123.8 | 2182.0 |
| 2021-03-18 06:35:00 | AAPL | Stock | 123.8 | 123.85 | 123.75 | 123.85 | 2987.0 |
| 2021-03-18 06:40:00 | AAPL | Stock | 123.8 | 123.8 | 123.75 | 123.79 | 354.0 |
| 2021-03-18 06:45:00 | AAPL | Stock | 123.82 | 123.82 | 123.64 | 123.64 | 2486.0 |
| 2021-03-18 06:50:00 | AAPL | Stock | 123.64 | 123.71 | 123.64 | 123.71 | 2530.0 |
| 2021-03-18 06:55:00 | AAPL | Stock | 123.67 | 123.67 | 123.51 | 123.6 | 1331.0 |
| 2021-03-18 07:00:00 | AAPL | Stock | 123.65 | 123.89 | 123.55 | 123.72 | 61876.0 |
| 2021-03-18 07:05:00 | AAPL | Stock | 123.71 | 123.74 | 123.46 | 123.6 | 49391.0 |
| 2021-03-18 07:10:00 | AAPL | Stock | 123.63 | 123.67 | 123.46 | 123.56 | 20396.0 |
| 2021-03-18 07:15:00 | AAPL | Stock | 123.56 | 123.56 | 123.31 | 123.35 | 37073.0 |
| 2021-03-18 07:20:00 | AAPL | Stock | 123.35 | 123.49 | 123.25 | 123.42 | 17009.0 |
| 2021-03-18 07:25:00 | AAPL | Stock | 123.44 | 123.45 | 123.25 | 123.4 | 19325.0 |
| 2021-03-18 07:30:00 | AAPL | Stock | 123.38 | 123.43 | 122.97 | 123.09 | 58864.0 |
| 2021-03-18 07:35:00 | AAPL | Stock | 123.1 | 123.1 | 122.69 | 122.8 | 61641.0 |
| 2021-03-18 07:40:00 | AAPL | Stock | 122.77 | 122.9 | 122.75 | 122.9 | 36133.0 |
| 2021-03-18 07:45:00 | AAPL | Stock | 122.89 | 123.24 | 122.85 | 123.09 | 24310.0 |
| 2021-03-18 07:50:00 | AAPL | Stock | 123.1 | 123.11 | 122.85 | 122.87 | 33055.0 |
| 2021-03-18 07:55:00 | AAPL | Stock | 122.87 | 123.11 | 122.85 | 123.0 | 33277.0 |
| 2021-03-18 08:00:00 | AAPL | Stock | 123.8 | 125.071 | 122.68 | 123.04 | 255580.0 |
| 2021-03-18 08:05:00 | AAPL | Stock | 123.06 | 123.07 | 122.95 | 122.97 | 29608.0 |
| 2021-03-18 08:10:00 | AAPL | Stock | 122.99 | 123.0 | 122.8 | 122.94 | 58485.0 |
| 2021-03-18 08:15:00 | AAPL | Stock | 122.94 | 123.0 | 122.8 | 123.0 | 42612.0 |
| 2021-03-18 08:20:00 | AAPL | Stock | 123.0 | 123.05 | 122.83 | 123.04 | 41613.0 |
> showing 50 of 491,741 rows — these rows as CSV