PREVIEW / stock_5min / 2021-09-20
file: by_date/stock_5min/2021/2021-09-20.parquet size: 7.9 MB rows: 485,473 symbols: 2,708
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-09-20 04:00:00 | AAPL | Stock | 144.96 | 144.96 | 144.28 | 144.35 | 13790.0 |
| 2021-09-20 04:05:00 | AAPL | Stock | 144.35 | 144.49 | 144.29 | 144.41 | 12656.0 |
| 2021-09-20 04:10:00 | AAPL | Stock | 144.42 | 144.46 | 144.29 | 144.34 | 11456.0 |
| 2021-09-20 04:15:00 | AAPL | Stock | 144.35 | 144.49 | 144.26 | 144.3 | 7739.0 |
| 2021-09-20 04:20:00 | AAPL | Stock | 144.3 | 144.34 | 144.2 | 144.25 | 7840.0 |
| 2021-09-20 04:25:00 | AAPL | Stock | 144.25 | 144.35 | 144.2 | 144.35 | 9408.0 |
| 2021-09-20 04:30:00 | AAPL | Stock | 144.35 | 144.38 | 144.28 | 144.37 | 8499.0 |
| 2021-09-20 04:35:00 | AAPL | Stock | 144.4 | 144.58 | 144.4 | 144.55 | 5403.0 |
| 2021-09-20 04:40:00 | AAPL | Stock | 144.51 | 144.51 | 144.2 | 144.35 | 6021.0 |
| 2021-09-20 04:45:00 | AAPL | Stock | 144.31 | 144.5 | 144.31 | 144.46 | 3676.0 |
| 2021-09-20 04:50:00 | AAPL | Stock | 144.44 | 144.59 | 144.44 | 144.48 | 3724.0 |
| 2021-09-20 04:55:00 | AAPL | Stock | 144.45 | 144.46 | 144.24 | 144.24 | 3511.0 |
| 2021-09-20 05:00:00 | AAPL | Stock | 144.23 | 144.28 | 144.23 | 144.25 | 10444.0 |
| 2021-09-20 05:05:00 | AAPL | Stock | 144.16 | 144.31 | 144.1 | 144.18 | 8523.0 |
| 2021-09-20 05:10:00 | AAPL | Stock | 144.32 | 144.32 | 144.2 | 144.2 | 2108.0 |
| 2021-09-20 05:15:00 | AAPL | Stock | 144.23 | 144.26 | 144.15 | 144.2 | 1548.0 |
| 2021-09-20 05:20:00 | AAPL | Stock | 144.1 | 144.14 | 144.0 | 144.01 | 4996.0 |
| 2021-09-20 05:25:00 | AAPL | Stock | 144.01 | 144.18 | 144.01 | 144.18 | 2673.0 |
| 2021-09-20 05:30:00 | AAPL | Stock | 144.15 | 144.18 | 144.15 | 144.15 | 1396.0 |
| 2021-09-20 05:35:00 | AAPL | Stock | 144.15 | 144.15 | 144.03 | 144.09 | 4986.0 |
| 2021-09-20 05:40:00 | AAPL | Stock | 144.02 | 144.1 | 144.0 | 144.01 | 2701.0 |
| 2021-09-20 05:45:00 | AAPL | Stock | 144.01 | 144.09 | 144.01 | 144.09 | 8954.0 |
| 2021-09-20 05:50:00 | AAPL | Stock | 144.03 | 144.06 | 143.89 | 144.04 | 22094.0 |
| 2021-09-20 05:55:00 | AAPL | Stock | 144.01 | 144.2 | 144.0 | 144.08 | 12905.0 |
| 2021-09-20 06:00:00 | AAPL | Stock | 144.1 | 144.28 | 144.09 | 144.28 | 2117.0 |
| 2021-09-20 06:05:00 | AAPL | Stock | 144.25 | 144.3 | 144.22 | 144.3 | 3467.0 |
| 2021-09-20 06:10:00 | AAPL | Stock | 144.2 | 144.25 | 144.11 | 144.2 | 5472.0 |
| 2021-09-20 06:15:00 | AAPL | Stock | 144.22 | 144.38 | 144.22 | 144.25 | 5262.0 |
| 2021-09-20 06:20:00 | AAPL | Stock | 144.29 | 144.4 | 144.29 | 144.29 | 1129.0 |
| 2021-09-20 06:25:00 | AAPL | Stock | 144.3 | 144.39 | 144.3 | 144.36 | 2679.0 |
| 2021-09-20 06:30:00 | AAPL | Stock | 144.31 | 144.35 | 144.3 | 144.35 | 3579.0 |
| 2021-09-20 06:35:00 | AAPL | Stock | 144.32 | 144.4 | 144.29 | 144.29 | 10822.0 |
| 2021-09-20 06:40:00 | AAPL | Stock | 144.29 | 144.38 | 144.27 | 144.27 | 3470.0 |
| 2021-09-20 06:45:00 | AAPL | Stock | 144.27 | 144.4 | 144.27 | 144.36 | 3330.0 |
| 2021-09-20 06:50:00 | AAPL | Stock | 144.35 | 144.38 | 144.34 | 144.36 | 3790.0 |
| 2021-09-20 06:55:00 | AAPL | Stock | 144.21 | 144.23 | 144.15 | 144.23 | 5479.0 |
| 2021-09-20 07:00:00 | AAPL | Stock | 144.23 | 144.37 | 144.0 | 144.2 | 247715.0 |
| 2021-09-20 07:05:00 | AAPL | Stock | 144.25 | 144.25 | 143.92 | 144.01 | 79395.0 |
| 2021-09-20 07:10:00 | AAPL | Stock | 144.04 | 144.16 | 144.0 | 144.12 | 79343.0 |
| 2021-09-20 07:15:00 | AAPL | Stock | 144.12 | 144.17 | 144.07 | 144.11 | 20891.0 |
| 2021-09-20 07:20:00 | AAPL | Stock | 144.11 | 144.16 | 144.0 | 144.0 | 135888.0 |
| 2021-09-20 07:25:00 | AAPL | Stock | 144.0 | 144.07 | 143.83 | 143.9 | 85821.0 |
| 2021-09-20 07:30:00 | AAPL | Stock | 143.86 | 143.86 | 143.55 | 143.65 | 48049.0 |
| 2021-09-20 07:35:00 | AAPL | Stock | 143.68 | 143.77 | 143.56 | 143.71 | 73192.0 |
| 2021-09-20 07:40:00 | AAPL | Stock | 143.71 | 143.76 | 143.65 | 143.69 | 31197.0 |
| 2021-09-20 07:45:00 | AAPL | Stock | 143.69 | 143.81 | 143.62 | 143.71 | 22190.0 |
| 2021-09-20 07:50:00 | AAPL | Stock | 143.73 | 143.85 | 143.59 | 143.59 | 66785.0 |
| 2021-09-20 07:55:00 | AAPL | Stock | 143.58 | 143.75 | 143.55 | 143.73 | 33875.0 |
| 2021-09-20 08:00:00 | AAPL | Stock | 143.73 | 144.38 | 143.6 | 143.72 | 279066.0 |
| 2021-09-20 08:05:00 | AAPL | Stock | 143.74 | 143.84 | 143.63 | 143.65 | 46212.0 |
> showing 50 of 485,473 rows — these rows as CSV