PREVIEW / stock_30min / 2021-03-04
file: by_date/stock_30min/2021/2021-03-04.parquet size: 2.4 MB rows: 122,970 symbols: 2,873
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-03-04 04:00:00 | AAPL | Stock | 121.77 | 122.25 | 121.03 | 121.31 | 27667.0 |
| 2021-03-04 04:30:00 | AAPL | Stock | 121.31 | 121.65 | 120.93 | 121.5 | 26917.0 |
| 2021-03-04 05:00:00 | AAPL | Stock | 121.45 | 121.57 | 121.0 | 121.05 | 11624.0 |
| 2021-03-04 05:30:00 | AAPL | Stock | 121.18 | 121.49 | 120.8 | 121.1 | 10948.0 |
| 2021-03-04 06:00:00 | AAPL | Stock | 121.1 | 121.2 | 120.7 | 120.9 | 10149.0 |
| 2021-03-04 06:30:00 | AAPL | Stock | 120.9 | 121.73 | 120.82 | 121.68 | 19345.0 |
| 2021-03-04 07:00:00 | AAPL | Stock | 121.66 | 122.08 | 121.0 | 121.85 | 517899.0 |
| 2021-03-04 07:30:00 | AAPL | Stock | 121.85 | 121.97 | 121.55 | 121.82 | 106731.0 |
| 2021-03-04 08:00:00 | AAPL | Stock | 121.42 | 122.365 | 121.01 | 122.13 | 307191.0 |
| 2021-03-04 08:30:00 | AAPL | Stock | 122.15 | 122.49 | 121.9 | 122.13 | 294901.0 |
| 2021-03-04 09:00:00 | AAPL | Stock | 122.11 | 122.38 | 121.72 | 121.72 | 326644.0 |
| 2021-03-04 09:30:00 | AAPL | Stock | 121.73 | 123.6 | 120.59 | 120.945 | 16340783.0 |
| 2021-03-04 10:00:00 | AAPL | Stock | 120.96 | 121.52 | 120.32 | 121.43 | 11450154.0 |
| 2021-03-04 10:30:00 | AAPL | Stock | 121.42 | 123.0 | 121.09 | 122.825 | 10080164.0 |
| 2021-03-04 11:00:00 | AAPL | Stock | 122.82 | 123.28 | 121.97 | 122.19 | 6803616.0 |
| 2021-03-04 11:30:00 | AAPL | Stock | 122.195 | 123.19 | 122.1393 | 122.5433 | 5719115.0 |
| 2021-03-04 12:00:00 | AAPL | Stock | 122.55 | 123.05 | 120.68 | 121.2801 | 9095125.0 |
| 2021-03-04 12:30:00 | AAPL | Stock | 121.27 | 121.476 | 119.76 | 120.39 | 11534991.0 |
| 2021-03-04 13:00:00 | AAPL | Stock | 120.395 | 120.71 | 119.63 | 120.536 | 9965031.0 |
| 2021-03-04 13:30:00 | AAPL | Stock | 120.54 | 120.56 | 118.69 | 118.7507 | 10543367.0 |
| 2021-03-04 14:00:00 | AAPL | Stock | 118.76 | 120.44 | 118.62 | 120.18 | 9786641.0 |
| 2021-03-04 14:30:00 | AAPL | Stock | 120.18 | 120.86 | 119.82 | 120.35 | 8031447.0 |
| 2021-03-04 15:00:00 | AAPL | Stock | 120.31 | 120.51 | 119.51 | 119.947 | 8318936.0 |
| 2021-03-04 15:30:00 | AAPL | Stock | 119.94 | 120.39 | 119.56 | 120.22 | 14916103.0 |
| 2021-03-04 16:00:00 | AAPL | Stock | 120.13 | 120.6643 | 119.9 | 120.25 | 7727058.0 |
| 2021-03-04 16:30:00 | AAPL | Stock | 120.26 | 120.27 | 119.7 | 119.7 | 96228.0 |
| 2021-03-04 17:00:00 | AAPL | Stock | 119.7 | 119.84 | 119.62 | 119.84 | 78101.0 |
| 2021-03-04 17:30:00 | AAPL | Stock | 119.84 | 120.13 | 119.84 | 119.9 | 446904.0 |
| 2021-03-04 18:00:00 | AAPL | Stock | 119.9 | 119.97 | 119.6 | 119.7 | 86081.0 |
| 2021-03-04 18:30:00 | AAPL | Stock | 119.7 | 119.72 | 119.2 | 119.32 | 116229.0 |
| 2021-03-04 19:00:00 | AAPL | Stock | 119.27 | 119.35 | 119.0 | 119.09 | 103152.0 |
| 2021-03-04 19:30:00 | AAPL | Stock | 119.06 | 119.1 | 118.0 | 118.69 | 294369.0 |
| 2021-03-04 04:00:00 | MSFT | Stock | 226.7 | 227.25 | 226.7 | 226.95 | 4014.0 |
| 2021-03-04 04:30:00 | MSFT | Stock | 226.87 | 227.11 | 226.03 | 227.11 | 7092.0 |
| 2021-03-04 05:00:00 | MSFT | Stock | 227.0 | 227.18 | 226.55 | 226.67 | 1755.0 |
| 2021-03-04 05:30:00 | MSFT | Stock | 226.52 | 227.32 | 226.14 | 226.8 | 6741.0 |
| 2021-03-04 06:00:00 | MSFT | Stock | 226.5 | 226.76 | 226.03 | 226.5 | 8923.0 |
| 2021-03-04 06:30:00 | MSFT | Stock | 226.99 | 227.29 | 226.61 | 227.02 | 1709.0 |
| 2021-03-04 07:00:00 | MSFT | Stock | 227.02 | 227.6 | 226.74 | 227.21 | 14203.0 |
| 2021-03-04 07:30:00 | MSFT | Stock | 227.06 | 227.26 | 227.0 | 227.18 | 12002.0 |
| 2021-03-04 08:00:00 | MSFT | Stock | 227.42 | 227.98 | 226.57 | 227.98 | 23207.0 |
| 2021-03-04 08:30:00 | MSFT | Stock | 227.52 | 227.85 | 227.01 | 227.01 | 11550.0 |
| 2021-03-04 09:00:00 | MSFT | Stock | 227.27 | 227.45 | 226.415 | 226.8 | 21814.0 |
| 2021-03-04 09:30:00 | MSFT | Stock | 226.85 | 229.1879 | 226.05 | 226.92 | 3161423.0 |
| 2021-03-04 10:00:00 | MSFT | Stock | 226.86 | 228.03 | 226.05 | 227.755 | 2468473.0 |
| 2021-03-04 10:30:00 | MSFT | Stock | 227.76 | 231.45 | 227.62 | 230.85 | 2319312.0 |
| 2021-03-04 11:00:00 | MSFT | Stock | 230.8558 | 231.74 | 230.05 | 230.49 | 1450494.0 |
| 2021-03-04 11:30:00 | MSFT | Stock | 230.51 | 232.49 | 230.26 | 231.0899 | 1459380.0 |
| 2021-03-04 12:00:00 | MSFT | Stock | 231.14 | 231.64 | 227.96 | 228.525 | 1793980.0 |
| 2021-03-04 12:30:00 | MSFT | Stock | 228.49 | 229.01 | 226.21 | 226.6642 | 1820526.0 |
> showing 50 of 122,970 rows — these rows as CSV