PREVIEW / stock_30min / 2021-10-28
file: by_date/stock_30min/2021/2021-10-28.parquet size: 2.3 MB rows: 112,421 symbols: 2,694
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-10-28 04:00:00 | AAPL | Stock | 149.2 | 149.48 | 149.2 | 149.31 | 7089.0 |
| 2021-10-28 04:30:00 | AAPL | Stock | 149.34 | 149.6 | 149.28 | 149.38 | 6647.0 |
| 2021-10-28 05:00:00 | AAPL | Stock | 149.4 | 149.46 | 149.37 | 149.37 | 7938.0 |
| 2021-10-28 05:30:00 | AAPL | Stock | 149.34 | 149.44 | 149.34 | 149.4 | 5295.0 |
| 2021-10-28 06:00:00 | AAPL | Stock | 149.39 | 149.39 | 149.35 | 149.36 | 9463.0 |
| 2021-10-28 06:30:00 | AAPL | Stock | 149.46 | 149.8 | 149.4 | 149.75 | 10531.0 |
| 2021-10-28 07:00:00 | AAPL | Stock | 149.75 | 150.0 | 149.6 | 149.74 | 74091.0 |
| 2021-10-28 07:30:00 | AAPL | Stock | 149.71 | 149.79 | 149.5 | 149.64 | 48452.0 |
| 2021-10-28 08:00:00 | AAPL | Stock | 149.7001 | 149.99 | 148.478 | 149.85 | 332697.0 |
| 2021-10-28 08:30:00 | AAPL | Stock | 149.84 | 149.93 | 149.61 | 149.78 | 293304.0 |
| 2021-10-28 09:00:00 | AAPL | Stock | 149.79 | 149.93 | 148.85 | 149.73 | 276921.0 |
| 2021-10-28 09:30:00 | AAPL | Stock | 149.86 | 152.11 | 149.72 | 152.07 | 14492406.0 |
| 2021-10-28 10:00:00 | AAPL | Stock | 152.06 | 152.51 | 151.7 | 152.445 | 8175593.0 |
| 2021-10-28 10:30:00 | AAPL | Stock | 152.445 | 152.92 | 152.3 | 152.5452 | 6075625.0 |
| 2021-10-28 11:00:00 | AAPL | Stock | 152.55 | 153.125 | 152.32 | 153.095 | 5791173.0 |
| 2021-10-28 11:30:00 | AAPL | Stock | 153.1 | 153.165 | 152.54 | 152.635 | 4538443.0 |
| 2021-10-28 12:00:00 | AAPL | Stock | 152.63 | 152.84 | 152.53 | 152.665 | 4138923.0 |
| 2021-10-28 12:30:00 | AAPL | Stock | 152.665 | 152.73 | 151.97 | 152.2 | 3269449.0 |
| 2021-10-28 13:00:00 | AAPL | Stock | 152.204 | 152.42 | 152.15 | 152.4074 | 2482173.0 |
| 2021-10-28 13:30:00 | AAPL | Stock | 152.405 | 152.7 | 152.37 | 152.4929 | 2791449.0 |
| 2021-10-28 14:00:00 | AAPL | Stock | 152.5 | 152.81 | 152.455 | 152.7842 | 2799397.0 |
| 2021-10-28 14:30:00 | AAPL | Stock | 152.7823 | 152.89 | 152.53 | 152.615 | 3116622.0 |
| 2021-10-28 15:00:00 | AAPL | Stock | 152.615 | 152.615 | 152.2201 | 152.345 | 3623347.0 |
| 2021-10-28 15:30:00 | AAPL | Stock | 152.345 | 152.69 | 152.17 | 152.4766 | 8333097.0 |
| 2021-10-28 16:00:00 | AAPL | Stock | 152.57 | 152.58 | 150.72 | 152.5 | 7843881.0 |
| 2021-10-28 16:30:00 | AAPL | Stock | 152.4 | 152.57 | 144.42 | 146.99 | 5964332.0 |
| 2021-10-28 17:00:00 | AAPL | Stock | 146.91 | 148.89 | 146.48 | 148.43 | 1626993.0 |
| 2021-10-28 17:30:00 | AAPL | Stock | 148.44 | 148.65 | 146.8 | 146.98 | 689820.0 |
| 2021-10-28 18:00:00 | AAPL | Stock | 146.98 | 147.34 | 146.75 | 147.09 | 249141.0 |
| 2021-10-28 18:30:00 | AAPL | Stock | 147.1 | 147.1 | 146.75 | 147.01 | 212670.0 |
| 2021-10-28 19:00:00 | AAPL | Stock | 147.0 | 147.03 | 146.79 | 146.8 | 152033.0 |
| 2021-10-28 19:30:00 | AAPL | Stock | 146.8 | 147.2 | 146.75 | 147.19 | 239809.0 |
| 2021-10-28 04:00:00 | MSFT | Stock | 324.05 | 324.64 | 324.01 | 324.55 | 2384.0 |
| 2021-10-28 04:30:00 | MSFT | Stock | 324.46 | 325.37 | 324.3 | 325.37 | 5482.0 |
| 2021-10-28 05:00:00 | MSFT | Stock | 325.34 | 325.43 | 324.87 | 324.87 | 4593.0 |
| 2021-10-28 05:30:00 | MSFT | Stock | 324.73 | 324.89 | 324.43 | 324.43 | 942.0 |
| 2021-10-28 06:30:00 | MSFT | Stock | 324.3 | 324.3 | 324.04 | 324.3 | 1725.0 |
| 2021-10-28 07:00:00 | MSFT | Stock | 324.43 | 325.38 | 324.3 | 325.21 | 12896.0 |
| 2021-10-28 07:30:00 | MSFT | Stock | 325.02 | 325.7 | 324.3 | 324.5 | 6811.0 |
| 2021-10-28 08:00:00 | MSFT | Stock | 324.9985 | 325.75 | 324.34 | 325.0 | 38406.0 |
| 2021-10-28 08:30:00 | MSFT | Stock | 325.0 | 325.19 | 324.02 | 324.05 | 21602.0 |
| 2021-10-28 09:00:00 | MSFT | Stock | 324.2881 | 325.34 | 323.17 | 324.05 | 43415.0 |
| 2021-10-28 09:30:00 | MSFT | Stock | 324.325 | 324.56 | 321.3601 | 321.84 | 3113563.0 |
| 2021-10-28 10:00:00 | MSFT | Stock | 321.78 | 322.7665 | 321.43 | 321.86 | 1869962.0 |
| 2021-10-28 10:30:00 | MSFT | Stock | 321.89 | 323.19 | 321.81 | 322.48 | 1930730.0 |
| 2021-10-28 11:00:00 | MSFT | Stock | 322.4623 | 324.03 | 322.42 | 323.72 | 1159620.0 |
| 2021-10-28 11:30:00 | MSFT | Stock | 323.73 | 324.38 | 323.57 | 323.79 | 1127836.0 |
| 2021-10-28 12:00:00 | MSFT | Stock | 323.8 | 324.0 | 323.36 | 323.53 | 695967.0 |
| 2021-10-28 12:30:00 | MSFT | Stock | 323.54 | 323.57 | 322.2752 | 322.58 | 858840.0 |
| 2021-10-28 13:00:00 | MSFT | Stock | 322.63 | 323.22 | 322.45 | 323.22 | 624301.0 |
> showing 50 of 112,421 rows — these rows as CSV