PREVIEW / stock_5min / 2021-07-20
file: by_date/stock_5min/2021/2021-07-20.parquet size: 7.5 MB rows: 464,342 symbols: 2,859
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-07-20 04:00:00 | AAPL | Stock | 143.3 | 143.6 | 143.0 | 143.2 | 13095.0 |
| 2021-07-20 04:05:00 | AAPL | Stock | 143.29 | 143.3 | 143.19 | 143.22 | 5773.0 |
| 2021-07-20 04:10:00 | AAPL | Stock | 143.19 | 143.3 | 143.16 | 143.16 | 3138.0 |
| 2021-07-20 04:15:00 | AAPL | Stock | 143.28 | 143.3 | 143.28 | 143.3 | 496.0 |
| 2021-07-20 04:20:00 | AAPL | Stock | 143.19 | 143.19 | 143.19 | 143.19 | 200.0 |
| 2021-07-20 04:25:00 | AAPL | Stock | 143.17 | 143.17 | 142.99 | 143.0 | 19492.0 |
| 2021-07-20 04:30:00 | AAPL | Stock | 143.07 | 143.12 | 143.07 | 143.12 | 1307.0 |
| 2021-07-20 04:35:00 | AAPL | Stock | 143.1 | 143.1 | 143.1 | 143.1 | 221.0 |
| 2021-07-20 04:40:00 | AAPL | Stock | 143.18 | 143.18 | 143.17 | 143.17 | 511.0 |
| 2021-07-20 04:45:00 | AAPL | Stock | 143.15 | 143.15 | 143.15 | 143.15 | 243.0 |
| 2021-07-20 04:50:00 | AAPL | Stock | 143.11 | 143.11 | 143.08 | 143.08 | 639.0 |
| 2021-07-20 04:55:00 | AAPL | Stock | 143.13 | 143.13 | 143.08 | 143.08 | 825.0 |
| 2021-07-20 05:00:00 | AAPL | Stock | 143.1 | 143.16 | 143.1 | 143.16 | 515.0 |
| 2021-07-20 05:05:00 | AAPL | Stock | 143.15 | 143.15 | 143.1 | 143.1 | 229.0 |
| 2021-07-20 05:10:00 | AAPL | Stock | 143.17 | 143.17 | 143.15 | 143.15 | 904.0 |
| 2021-07-20 05:20:00 | AAPL | Stock | 143.13 | 143.13 | 143.13 | 143.13 | 433.0 |
| 2021-07-20 05:25:00 | AAPL | Stock | 143.15 | 143.15 | 143.15 | 143.15 | 127.0 |
| 2021-07-20 05:30:00 | AAPL | Stock | 143.19 | 143.2 | 143.19 | 143.2 | 399.0 |
| 2021-07-20 05:35:00 | AAPL | Stock | 143.23 | 143.29 | 143.22 | 143.22 | 1405.0 |
| 2021-07-20 05:40:00 | AAPL | Stock | 143.2 | 143.2 | 143.1 | 143.1 | 1829.0 |
| 2021-07-20 05:45:00 | AAPL | Stock | 143.09 | 143.09 | 143.0 | 143.0 | 3952.0 |
| 2021-07-20 05:50:00 | AAPL | Stock | 143.0 | 143.0 | 142.75 | 142.81 | 1958.0 |
| 2021-07-20 05:55:00 | AAPL | Stock | 142.87 | 142.92 | 142.87 | 142.92 | 851.0 |
| 2021-07-20 06:05:00 | AAPL | Stock | 142.9 | 142.93 | 142.89 | 142.93 | 998.0 |
| 2021-07-20 06:10:00 | AAPL | Stock | 143.0 | 143.25 | 143.0 | 143.25 | 940.0 |
| 2021-07-20 06:15:00 | AAPL | Stock | 143.17 | 143.3 | 143.15 | 143.23 | 2115.0 |
| 2021-07-20 06:20:00 | AAPL | Stock | 143.25 | 143.27 | 143.2 | 143.2 | 2242.0 |
| 2021-07-20 06:25:00 | AAPL | Stock | 143.2 | 143.25 | 143.2 | 143.25 | 473.0 |
| 2021-07-20 06:30:00 | AAPL | Stock | 143.26 | 143.26 | 143.19 | 143.23 | 1683.0 |
| 2021-07-20 06:35:00 | AAPL | Stock | 143.27 | 143.38 | 143.25 | 143.38 | 3871.0 |
| 2021-07-20 06:40:00 | AAPL | Stock | 143.4 | 143.55 | 143.4 | 143.53 | 4009.0 |
| 2021-07-20 06:45:00 | AAPL | Stock | 143.49 | 143.51 | 143.3 | 143.31 | 1646.0 |
| 2021-07-20 06:50:00 | AAPL | Stock | 143.3 | 143.37 | 143.19 | 143.28 | 3757.0 |
| 2021-07-20 06:55:00 | AAPL | Stock | 143.49 | 143.65 | 143.49 | 143.65 | 3153.0 |
| 2021-07-20 07:00:00 | AAPL | Stock | 143.63 | 143.74 | 143.41 | 143.65 | 36075.0 |
| 2021-07-20 07:05:00 | AAPL | Stock | 143.69 | 143.8 | 143.65 | 143.7 | 21765.0 |
| 2021-07-20 07:10:00 | AAPL | Stock | 143.71 | 143.72 | 143.52 | 143.58 | 17435.0 |
| 2021-07-20 07:15:00 | AAPL | Stock | 143.58 | 143.68 | 143.57 | 143.6 | 14156.0 |
| 2021-07-20 07:20:00 | AAPL | Stock | 143.62 | 143.63 | 143.5 | 143.55 | 17161.0 |
| 2021-07-20 07:25:00 | AAPL | Stock | 143.55 | 143.55 | 143.46 | 143.55 | 6723.0 |
| 2021-07-20 07:30:00 | AAPL | Stock | 143.58 | 143.6 | 143.44 | 143.44 | 9795.0 |
| 2021-07-20 07:35:00 | AAPL | Stock | 143.45 | 143.57 | 143.45 | 143.55 | 6748.0 |
| 2021-07-20 07:40:00 | AAPL | Stock | 143.53 | 143.57 | 143.51 | 143.53 | 10601.0 |
| 2021-07-20 07:45:00 | AAPL | Stock | 143.5 | 143.5 | 143.3 | 143.39 | 9950.0 |
| 2021-07-20 07:50:00 | AAPL | Stock | 143.36 | 143.55 | 143.35 | 143.5 | 7533.0 |
| 2021-07-20 07:55:00 | AAPL | Stock | 143.49 | 143.6 | 143.49 | 143.55 | 8706.0 |
| 2021-07-20 08:00:00 | AAPL | Stock | 143.56 | 143.8 | 143.33 | 143.74 | 233826.0 |
| 2021-07-20 08:05:00 | AAPL | Stock | 143.7 | 143.73 | 143.6 | 143.61 | 44456.0 |
| 2021-07-20 08:10:00 | AAPL | Stock | 143.62 | 143.63 | 143.52 | 143.6 | 50183.0 |
| 2021-07-20 08:15:00 | AAPL | Stock | 143.61 | 143.61 | 143.54 | 143.6 | 20079.0 |
> showing 50 of 464,342 rows — these rows as CSV