PREVIEW / stock_30min / 2022-08-31
file: by_date/stock_30min/2022/2022-08-31.parquet size: 2.1 MB rows: 104,539 symbols: 2,206
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 |
|---|---|---|---|---|---|---|---|
| 2022-08-31 04:00:00 | AAPL | Stock | 159.91 | 159.91 | 159.3 | 159.3 | 8261.0 |
| 2022-08-31 04:30:00 | AAPL | Stock | 159.6 | 160.0 | 159.4 | 159.72 | 23027.0 |
| 2022-08-31 05:00:00 | AAPL | Stock | 159.65 | 159.66 | 159.4 | 159.4 | 36645.0 |
| 2022-08-31 05:30:00 | AAPL | Stock | 159.37 | 159.59 | 159.3 | 159.59 | 2214.0 |
| 2022-08-31 06:00:00 | AAPL | Stock | 159.45 | 159.97 | 159.45 | 159.95 | 8734.0 |
| 2022-08-31 06:30:00 | AAPL | Stock | 159.82 | 160.35 | 159.61 | 160.11 | 21249.0 |
| 2022-08-31 07:00:00 | AAPL | Stock | 159.99 | 160.1 | 159.51 | 159.72 | 65194.0 |
| 2022-08-31 07:30:00 | AAPL | Stock | 159.68 | 159.72 | 159.43 | 159.72 | 19024.0 |
| 2022-08-31 08:00:00 | AAPL | Stock | 159.7 | 160.76 | 158.513 | 159.9 | 204683.0 |
| 2022-08-31 08:30:00 | AAPL | Stock | 159.89 | 160.24 | 159.52 | 160.02 | 130561.0 |
| 2022-08-31 09:00:00 | AAPL | Stock | 160.02 | 160.48 | 159.96 | 160.29 | 171451.0 |
| 2022-08-31 09:30:00 | AAPL | Stock | 160.305 | 160.58 | 158.8799 | 160.13 | 8457126.0 |
| 2022-08-31 10:00:00 | AAPL | Stock | 160.13 | 160.22 | 158.98 | 159.17 | 5266243.0 |
| 2022-08-31 10:30:00 | AAPL | Stock | 159.17 | 159.77 | 158.87 | 159.06 | 3780983.0 |
| 2022-08-31 11:00:00 | AAPL | Stock | 159.045 | 159.18 | 158.405 | 158.99 | 3371049.0 |
| 2022-08-31 11:30:00 | AAPL | Stock | 158.98 | 159.77 | 158.72 | 159.6001 | 2611600.0 |
| 2022-08-31 12:00:00 | AAPL | Stock | 159.605 | 159.705 | 158.95 | 159.106 | 2269869.0 |
| 2022-08-31 12:30:00 | AAPL | Stock | 159.11 | 159.23 | 158.72 | 159.041 | 2064952.0 |
| 2022-08-31 13:00:00 | AAPL | Stock | 159.045 | 159.3499 | 158.62 | 158.815 | 1910981.0 |
| 2022-08-31 13:30:00 | AAPL | Stock | 158.815 | 158.88 | 158.25 | 158.49 | 2138074.0 |
| 2022-08-31 14:00:00 | AAPL | Stock | 158.4904 | 158.74 | 158.24 | 158.3 | 2495364.0 |
| 2022-08-31 14:30:00 | AAPL | Stock | 158.2801 | 158.3451 | 157.6927 | 157.925 | 2991923.0 |
| 2022-08-31 15:00:00 | AAPL | Stock | 157.93 | 158.98 | 157.75 | 158.55 | 3717974.0 |
| 2022-08-31 15:30:00 | AAPL | Stock | 158.56 | 159.22 | 157.14 | 157.17 | 10717108.0 |
| 2022-08-31 16:00:00 | AAPL | Stock | 157.17 | 157.61 | 157.17 | 157.51 | 21820895.0 |
| 2022-08-31 16:30:00 | AAPL | Stock | 157.52 | 157.7 | 157.22 | 157.7 | 73770.0 |
| 2022-08-31 17:00:00 | AAPL | Stock | 157.62 | 157.69 | 157.37 | 157.43 | 67947.0 |
| 2022-08-31 17:30:00 | AAPL | Stock | 157.5 | 157.5 | 157.29 | 157.35 | 48500.0 |
| 2022-08-31 18:00:00 | AAPL | Stock | 157.35 | 157.77 | 156.7 | 156.99 | 50137.0 |
| 2022-08-31 18:30:00 | AAPL | Stock | 156.97 | 156.97 | 156.52 | 156.61 | 35336.0 |
| 2022-08-31 19:00:00 | AAPL | Stock | 156.61 | 156.66 | 155.87 | 155.9 | 62674.0 |
| 2022-08-31 19:30:00 | AAPL | Stock | 155.95 | 156.15 | 155.77 | 156.0 | 73294.0 |
| 2022-08-31 04:00:00 | MSFT | Stock | 264.0 | 264.3 | 264.0 | 264.11 | 1304.0 |
| 2022-08-31 04:30:00 | MSFT | Stock | 263.79 | 263.98 | 263.79 | 263.98 | 323.0 |
| 2022-08-31 05:00:00 | MSFT | Stock | 263.4 | 263.4 | 263.3 | 263.3 | 200.0 |
| 2022-08-31 05:30:00 | MSFT | Stock | 263.48 | 263.48 | 263.25 | 263.25 | 1227.0 |
| 2022-08-31 06:00:00 | MSFT | Stock | 263.25 | 264.7 | 263.25 | 264.7 | 2981.0 |
| 2022-08-31 06:30:00 | MSFT | Stock | 264.47 | 265.58 | 264.47 | 265.49 | 3202.0 |
| 2022-08-31 07:00:00 | MSFT | Stock | 264.8 | 265.0 | 264.58 | 264.62 | 5583.0 |
| 2022-08-31 07:30:00 | MSFT | Stock | 264.72 | 264.72 | 264.1 | 264.1 | 995.0 |
| 2022-08-31 08:00:00 | MSFT | Stock | 264.75 | 265.25 | 262.313 | 264.8917 | 8367.0 |
| 2022-08-31 08:30:00 | MSFT | Stock | 264.51 | 266.22 | 264.5 | 265.66 | 14703.0 |
| 2022-08-31 09:00:00 | MSFT | Stock | 265.5 | 266.44 | 265.03 | 265.11 | 45333.0 |
| 2022-08-31 09:30:00 | MSFT | Stock | 265.39 | 267.11 | 263.92 | 265.78 | 1963548.0 |
| 2022-08-31 10:00:00 | MSFT | Stock | 265.81 | 265.86 | 263.59 | 263.86 | 942130.0 |
| 2022-08-31 10:30:00 | MSFT | Stock | 263.83 | 264.82 | 263.25 | 263.88 | 735889.0 |
| 2022-08-31 11:00:00 | MSFT | Stock | 263.9 | 263.94 | 262.1761 | 263.02 | 785556.0 |
| 2022-08-31 11:30:00 | MSFT | Stock | 262.98 | 264.9 | 262.6 | 264.59 | 645412.0 |
| 2022-08-31 12:00:00 | MSFT | Stock | 264.62 | 264.91 | 263.96 | 264.14 | 478997.0 |
| 2022-08-31 12:30:00 | MSFT | Stock | 264.2 | 264.465 | 263.42 | 263.67 | 370129.0 |
> showing 50 of 104,539 rows — these rows as CSV