PREVIEW / stock_5min / 2021-02-23
file: by_date/stock_5min/2021/2021-02-23.parquet size: 8.8 MB rows: 551,802 symbols: 2,839
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-02-23 04:00:00 | AAPL | Stock | 126.0 | 126.0 | 125.37 | 125.37 | 6764.0 |
| 2021-02-23 04:05:00 | AAPL | Stock | 125.37 | 125.44 | 125.27 | 125.43 | 4550.0 |
| 2021-02-23 04:10:00 | AAPL | Stock | 125.36 | 125.36 | 125.07 | 125.15 | 18117.0 |
| 2021-02-23 04:15:00 | AAPL | Stock | 125.15 | 125.15 | 125.04 | 125.1 | 11462.0 |
| 2021-02-23 04:20:00 | AAPL | Stock | 125.18 | 125.19 | 125.1 | 125.15 | 1874.0 |
| 2021-02-23 04:25:00 | AAPL | Stock | 125.06 | 125.06 | 124.52 | 124.58 | 24157.0 |
| 2021-02-23 04:30:00 | AAPL | Stock | 124.51 | 124.66 | 124.09 | 124.13 | 31348.0 |
| 2021-02-23 04:35:00 | AAPL | Stock | 124.27 | 124.69 | 124.13 | 124.4 | 16086.0 |
| 2021-02-23 04:40:00 | AAPL | Stock | 124.42 | 124.45 | 124.0 | 124.44 | 22866.0 |
| 2021-02-23 04:45:00 | AAPL | Stock | 124.3 | 124.33 | 123.99 | 124.04 | 5648.0 |
| 2021-02-23 04:50:00 | AAPL | Stock | 124.14 | 124.2 | 124.0 | 124.18 | 8658.0 |
| 2021-02-23 04:55:00 | AAPL | Stock | 124.19 | 124.72 | 124.05 | 124.2 | 7847.0 |
| 2021-02-23 05:00:00 | AAPL | Stock | 124.2 | 124.39 | 124.0 | 124.0 | 10564.0 |
| 2021-02-23 05:05:00 | AAPL | Stock | 123.93 | 123.96 | 123.52 | 123.52 | 25812.0 |
| 2021-02-23 05:10:00 | AAPL | Stock | 123.52 | 123.52 | 123.03 | 123.31 | 88573.0 |
| 2021-02-23 05:15:00 | AAPL | Stock | 123.31 | 123.45 | 122.96 | 122.96 | 11987.0 |
| 2021-02-23 05:20:00 | AAPL | Stock | 122.92 | 123.19 | 122.4 | 122.4 | 21143.0 |
| 2021-02-23 05:25:00 | AAPL | Stock | 122.63 | 122.64 | 121.77 | 122.45 | 54479.0 |
| 2021-02-23 05:30:00 | AAPL | Stock | 122.29 | 122.5 | 122.13 | 122.24 | 23083.0 |
| 2021-02-23 05:35:00 | AAPL | Stock | 122.18 | 122.33 | 121.58 | 122.04 | 50417.0 |
| 2021-02-23 05:40:00 | AAPL | Stock | 122.25 | 122.3 | 121.81 | 122.28 | 27967.0 |
| 2021-02-23 05:45:00 | AAPL | Stock | 122.29 | 123.0 | 122.27 | 122.87 | 27577.0 |
| 2021-02-23 05:50:00 | AAPL | Stock | 122.75 | 122.93 | 122.75 | 122.93 | 8007.0 |
| 2021-02-23 05:55:00 | AAPL | Stock | 122.85 | 122.99 | 122.25 | 122.42 | 15271.0 |
| 2021-02-23 06:00:00 | AAPL | Stock | 122.45 | 122.5 | 122.04 | 122.4 | 8823.0 |
| 2021-02-23 06:05:00 | AAPL | Stock | 122.47 | 122.85 | 122.41 | 122.85 | 1346.0 |
| 2021-02-23 06:10:00 | AAPL | Stock | 122.76 | 123.27 | 122.72 | 123.15 | 6262.0 |
| 2021-02-23 06:15:00 | AAPL | Stock | 123.15 | 123.29 | 122.8 | 122.8 | 5608.0 |
| 2021-02-23 06:20:00 | AAPL | Stock | 122.8 | 123.0 | 122.78 | 123.0 | 3188.0 |
| 2021-02-23 06:25:00 | AAPL | Stock | 122.99 | 123.13 | 122.95 | 123.08 | 4563.0 |
| 2021-02-23 06:30:00 | AAPL | Stock | 123.01 | 123.13 | 123.0 | 123.1 | 23810.0 |
| 2021-02-23 06:35:00 | AAPL | Stock | 123.34 | 123.42 | 123.1 | 123.15 | 8548.0 |
| 2021-02-23 06:40:00 | AAPL | Stock | 123.15 | 123.3 | 123.13 | 123.26 | 8728.0 |
| 2021-02-23 06:45:00 | AAPL | Stock | 123.23 | 123.5 | 123.12 | 123.18 | 5298.0 |
| 2021-02-23 06:50:00 | AAPL | Stock | 123.24 | 123.24 | 122.62 | 122.75 | 10634.0 |
| 2021-02-23 06:55:00 | AAPL | Stock | 122.9 | 123.49 | 122.79 | 123.36 | 5032.0 |
| 2021-02-23 07:00:00 | AAPL | Stock | 123.33 | 123.9 | 123.21 | 123.55 | 142071.0 |
| 2021-02-23 07:05:00 | AAPL | Stock | 123.55 | 123.69 | 123.5 | 123.68 | 37876.0 |
| 2021-02-23 07:10:00 | AAPL | Stock | 123.66 | 123.76 | 123.31 | 123.41 | 73315.0 |
| 2021-02-23 07:15:00 | AAPL | Stock | 123.42 | 123.81 | 123.4 | 123.61 | 33513.0 |
| 2021-02-23 07:20:00 | AAPL | Stock | 123.61 | 123.76 | 123.4 | 123.44 | 33643.0 |
| 2021-02-23 07:25:00 | AAPL | Stock | 123.43 | 123.79 | 123.42 | 123.79 | 23561.0 |
| 2021-02-23 07:30:00 | AAPL | Stock | 123.75 | 123.78 | 123.5 | 123.52 | 38943.0 |
| 2021-02-23 07:35:00 | AAPL | Stock | 123.53 | 123.54 | 123.23 | 123.39 | 52840.0 |
| 2021-02-23 07:40:00 | AAPL | Stock | 123.39 | 123.5 | 123.31 | 123.39 | 32678.0 |
| 2021-02-23 07:45:00 | AAPL | Stock | 123.37 | 123.4 | 123.3 | 123.3 | 17015.0 |
| 2021-02-23 07:50:00 | AAPL | Stock | 123.34 | 123.78 | 123.32 | 123.72 | 53081.0 |
| 2021-02-23 07:55:00 | AAPL | Stock | 123.74 | 123.74 | 123.58 | 123.62 | 21748.0 |
| 2021-02-23 08:00:00 | AAPL | Stock | 123.62 | 123.85 | 123.2 | 123.2 | 282593.0 |
| 2021-02-23 08:05:00 | AAPL | Stock | 123.23 | 123.48 | 123.08 | 123.18 | 69666.0 |
> showing 50 of 551,802 rows — these rows as CSV