PREVIEW / stock_30min / 2021-11-19
file: by_date/stock_30min/2021/2021-11-19.parquet size: 2.3 MB rows: 113,932 symbols: 2,701
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-11-19 04:00:00 | AAPL | Stock | 158.5 | 158.62 | 158.22 | 158.32 | 45382.0 |
| 2021-11-19 04:30:00 | AAPL | Stock | 158.32 | 158.32 | 158.02 | 158.1 | 17490.0 |
| 2021-11-19 05:00:00 | AAPL | Stock | 158.03 | 158.03 | 157.5 | 157.9 | 30428.0 |
| 2021-11-19 05:30:00 | AAPL | Stock | 157.87 | 158.01 | 157.58 | 157.87 | 23096.0 |
| 2021-11-19 06:00:00 | AAPL | Stock | 157.91 | 157.91 | 157.57 | 157.79 | 27155.0 |
| 2021-11-19 06:30:00 | AAPL | Stock | 157.79 | 157.79 | 157.38 | 157.48 | 23574.0 |
| 2021-11-19 07:00:00 | AAPL | Stock | 157.58 | 157.7 | 157.27 | 157.43 | 183691.0 |
| 2021-11-19 07:30:00 | AAPL | Stock | 157.43 | 157.7 | 157.34 | 157.43 | 148164.0 |
| 2021-11-19 08:00:00 | AAPL | Stock | 157.4 | 157.7 | 156.804 | 157.06 | 499329.0 |
| 2021-11-19 08:30:00 | AAPL | Stock | 157.07 | 157.26 | 157.01 | 157.13 | 225704.0 |
| 2021-11-19 09:00:00 | AAPL | Stock | 157.15 | 158.11 | 156.6 | 157.68 | 1167400.0 |
| 2021-11-19 09:30:00 | AAPL | Stock | 157.64 | 159.02 | 156.5328 | 158.945 | 17397451.0 |
| 2021-11-19 10:00:00 | AAPL | Stock | 158.945 | 159.0 | 158.07 | 158.16 | 7781709.0 |
| 2021-11-19 10:30:00 | AAPL | Stock | 158.155 | 159.19 | 158.15 | 158.985 | 5717894.0 |
| 2021-11-19 11:00:00 | AAPL | Stock | 158.99 | 159.955 | 158.86 | 159.8498 | 7890954.0 |
| 2021-11-19 11:30:00 | AAPL | Stock | 159.85 | 160.17 | 159.5401 | 159.87 | 7666006.0 |
| 2021-11-19 12:00:00 | AAPL | Stock | 159.86 | 160.15 | 159.69 | 159.925 | 4352055.0 |
| 2021-11-19 12:30:00 | AAPL | Stock | 159.9268 | 160.35 | 159.7 | 160.2866 | 5005734.0 |
| 2021-11-19 13:00:00 | AAPL | Stock | 160.285 | 160.55 | 159.93 | 159.955 | 5676857.0 |
| 2021-11-19 13:30:00 | AAPL | Stock | 159.955 | 160.72 | 159.77 | 160.69 | 5044958.0 |
| 2021-11-19 14:00:00 | AAPL | Stock | 160.7 | 160.84 | 160.34 | 160.7149 | 5002697.0 |
| 2021-11-19 14:30:00 | AAPL | Stock | 160.715 | 160.77 | 160.3 | 160.515 | 4045101.0 |
| 2021-11-19 15:00:00 | AAPL | Stock | 160.515 | 160.62 | 160.1 | 160.49 | 4530297.0 |
| 2021-11-19 15:30:00 | AAPL | Stock | 160.48 | 161.02 | 160.24 | 160.56 | 11604846.0 |
| 2021-11-19 16:00:00 | AAPL | Stock | 160.57 | 160.86 | 160.52 | 160.82 | 7179031.0 |
| 2021-11-19 16:30:00 | AAPL | Stock | 160.78 | 160.85 | 160.55 | 160.75 | 93868.0 |
| 2021-11-19 17:00:00 | AAPL | Stock | 160.72 | 160.93 | 160.55 | 160.8 | 172284.0 |
| 2021-11-19 17:30:00 | AAPL | Stock | 160.8 | 161.0 | 160.8 | 160.92 | 57000.0 |
| 2021-11-19 18:00:00 | AAPL | Stock | 160.9201 | 160.99 | 160.85 | 160.89 | 19902.0 |
| 2021-11-19 18:30:00 | AAPL | Stock | 160.89 | 160.9 | 160.72 | 160.84 | 24649.0 |
| 2021-11-19 19:00:00 | AAPL | Stock | 160.8 | 160.82 | 160.71 | 160.79 | 19912.0 |
| 2021-11-19 19:30:00 | AAPL | Stock | 160.76 | 161.0 | 160.76 | 160.99 | 44231.0 |
| 2021-11-19 04:00:00 | MSFT | Stock | 342.59 | 343.05 | 342.53 | 343.05 | 3239.0 |
| 2021-11-19 04:30:00 | MSFT | Stock | 342.78 | 342.99 | 342.55 | 342.82 | 2958.0 |
| 2021-11-19 05:00:00 | MSFT | Stock | 342.71 | 343.05 | 341.98 | 343.05 | 3247.0 |
| 2021-11-19 05:30:00 | MSFT | Stock | 343.18 | 343.49 | 343.18 | 343.48 | 1623.0 |
| 2021-11-19 06:00:00 | MSFT | Stock | 343.24 | 343.24 | 342.9 | 343.0 | 6035.0 |
| 2021-11-19 06:30:00 | MSFT | Stock | 343.09 | 343.14 | 342.8 | 343.14 | 2493.0 |
| 2021-11-19 07:00:00 | MSFT | Stock | 343.24 | 343.91 | 343.21 | 343.5 | 12643.0 |
| 2021-11-19 07:30:00 | MSFT | Stock | 343.76 | 344.0 | 343.44 | 344.0 | 7751.0 |
| 2021-11-19 08:00:00 | MSFT | Stock | 342.999 | 344.2093 | 341.27 | 343.25 | 200385.0 |
| 2021-11-19 08:30:00 | MSFT | Stock | 343.2499 | 343.5 | 342.12 | 342.12 | 82092.0 |
| 2021-11-19 09:00:00 | MSFT | Stock | 342.13 | 344.36 | 341.52 | 342.71 | 169563.0 |
| 2021-11-19 09:30:00 | MSFT | Stock | 342.71 | 344.4026 | 342.2 | 344.31 | 3274575.0 |
| 2021-11-19 10:00:00 | MSFT | Stock | 344.35 | 345.1 | 342.68 | 342.7001 | 1707362.0 |
| 2021-11-19 10:30:00 | MSFT | Stock | 342.69 | 343.5927 | 342.635 | 342.77 | 730415.0 |
| 2021-11-19 11:00:00 | MSFT | Stock | 342.73 | 344.03 | 342.68 | 343.74 | 645380.0 |
| 2021-11-19 11:30:00 | MSFT | Stock | 343.75 | 343.98 | 343.275 | 343.43 | 671859.0 |
| 2021-11-19 12:00:00 | MSFT | Stock | 343.44 | 344.2399 | 343.375 | 343.49 | 494171.0 |
| 2021-11-19 12:30:00 | MSFT | Stock | 343.49 | 343.87 | 343.2 | 343.45 | 519233.0 |
> showing 50 of 113,932 rows — these rows as CSV