PREVIEW / stock_30min / 2023-08-30
file: by_date/stock_30min/2023/2023-08-30.parquet size: 2.0 MB rows: 97,395 symbols: 1,460
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 |
|---|---|---|---|---|---|---|---|
| 2023-08-30 04:00:00 | AAPL | Stock | 184.3 | 184.53 | 183.14 | 184.09 | 11817.0 |
| 2023-08-30 04:30:00 | AAPL | Stock | 184.02 | 184.09 | 183.96 | 184.06 | 1646.0 |
| 2023-08-30 05:00:00 | AAPL | Stock | 184.06 | 184.1 | 183.55 | 183.64 | 20516.0 |
| 2023-08-30 05:30:00 | AAPL | Stock | 183.71 | 183.71 | 183.53 | 183.6 | 6190.0 |
| 2023-08-30 06:00:00 | AAPL | Stock | 183.63 | 183.84 | 183.63 | 183.84 | 11477.0 |
| 2023-08-30 06:30:00 | AAPL | Stock | 183.85 | 184.06 | 183.82 | 184.01 | 4883.0 |
| 2023-08-30 07:00:00 | AAPL | Stock | 184.01 | 184.16 | 183.86 | 184.11 | 24103.0 |
| 2023-08-30 07:30:00 | AAPL | Stock | 184.08 | 184.32 | 184.04 | 184.21 | 18457.0 |
| 2023-08-30 08:00:00 | AAPL | Stock | 184.07 | 185.17 | 183.85 | 184.7 | 141259.0 |
| 2023-08-30 08:30:00 | AAPL | Stock | 184.66 | 184.9 | 184.41 | 184.66 | 106019.0 |
| 2023-08-30 09:00:00 | AAPL | Stock | 184.66 | 185.0 | 184.38 | 184.8 | 157811.0 |
| 2023-08-30 09:30:00 | AAPL | Stock | 184.81 | 186.43 | 184.74 | 186.37 | 7492259.0 |
| 2023-08-30 10:00:00 | AAPL | Stock | 186.37 | 187.67 | 185.85 | 186.185 | 8652027.0 |
| 2023-08-30 10:30:00 | AAPL | Stock | 186.19 | 186.8 | 186.13 | 186.685 | 3630722.0 |
| 2023-08-30 11:00:00 | AAPL | Stock | 186.6889 | 186.79 | 186.18 | 186.63 | 2174613.0 |
| 2023-08-30 11:30:00 | AAPL | Stock | 186.63 | 187.33 | 186.61 | 187.16 | 2421900.0 |
| 2023-08-30 12:00:00 | AAPL | Stock | 187.15 | 187.49 | 187.01 | 187.43 | 2152026.0 |
| 2023-08-30 12:30:00 | AAPL | Stock | 187.44 | 187.77 | 187.32 | 187.44 | 2616522.0 |
| 2023-08-30 13:00:00 | AAPL | Stock | 187.435 | 187.55 | 187.2 | 187.2901 | 1297635.0 |
| 2023-08-30 13:30:00 | AAPL | Stock | 187.3 | 187.59 | 186.89 | 187.1026 | 1792825.0 |
| 2023-08-30 14:00:00 | AAPL | Stock | 187.11 | 187.28 | 186.65 | 186.85 | 2809213.0 |
| 2023-08-30 14:30:00 | AAPL | Stock | 186.85 | 187.61 | 186.78 | 187.56 | 2265135.0 |
| 2023-08-30 15:00:00 | AAPL | Stock | 187.56 | 187.68 | 187.31 | 187.385 | 1954567.0 |
| 2023-08-30 15:30:00 | AAPL | Stock | 187.39 | 187.79 | 187.32 | 187.67 | 6040889.0 |
| 2023-08-30 16:00:00 | AAPL | Stock | 187.68 | 187.85 | 187.36 | 187.63 | 6843118.0 |
| 2023-08-30 16:30:00 | AAPL | Stock | 187.63 | 187.72 | 187.55 | 187.65 | 106797.0 |
| 2023-08-30 17:00:00 | AAPL | Stock | 187.65 | 187.66 | 187.6 | 187.65 | 12383.0 |
| 2023-08-30 17:30:00 | AAPL | Stock | 187.65 | 187.65 | 187.57 | 187.64 | 17944.0 |
| 2023-08-30 18:00:00 | AAPL | Stock | 187.65 | 187.66 | 187.63 | 187.65 | 7745.0 |
| 2023-08-30 18:30:00 | AAPL | Stock | 187.64 | 187.66 | 187.6095 | 187.66 | 13273.0 |
| 2023-08-30 19:00:00 | AAPL | Stock | 187.66 | 187.66 | 187.6 | 187.62 | 8926.0 |
| 2023-08-30 19:30:00 | AAPL | Stock | 187.64 | 187.66 | 187.61 | 187.66 | 16144.0 |
| 2023-08-30 04:00:00 | MSFT | Stock | 328.75 | 328.75 | 327.6 | 327.6 | 1122.0 |
| 2023-08-30 04:30:00 | MSFT | Stock | 327.5 | 327.5 | 327.29 | 327.29 | 1958.0 |
| 2023-08-30 05:00:00 | MSFT | Stock | 327.17 | 327.3 | 327.17 | 327.3 | 2362.0 |
| 2023-08-30 06:30:00 | MSFT | Stock | 327.68 | 327.91 | 327.68 | 327.91 | 694.0 |
| 2023-08-30 07:00:00 | MSFT | Stock | 327.88 | 328.0 | 327.48 | 328.0 | 2245.0 |
| 2023-08-30 07:30:00 | MSFT | Stock | 327.79 | 327.91 | 327.7 | 327.7 | 1692.0 |
| 2023-08-30 08:00:00 | MSFT | Stock | 328.0 | 329.25 | 327.27 | 328.91 | 15238.0 |
| 2023-08-30 08:30:00 | MSFT | Stock | 328.64 | 329.44 | 328.44 | 328.82 | 5815.0 |
| 2023-08-30 09:00:00 | MSFT | Stock | 328.82 | 329.19 | 328.5 | 328.76 | 20266.0 |
| 2023-08-30 09:30:00 | MSFT | Stock | 328.72 | 329.81 | 327.24 | 329.44 | 1395464.0 |
| 2023-08-30 10:00:00 | MSFT | Stock | 329.46 | 329.76 | 326.445 | 327.22 | 1125315.0 |
| 2023-08-30 10:30:00 | MSFT | Stock | 327.17 | 328.75 | 327.13 | 328.57 | 628434.0 |
| 2023-08-30 11:00:00 | MSFT | Stock | 328.6 | 328.71 | 327.575 | 328.33 | 483936.0 |
| 2023-08-30 11:30:00 | MSFT | Stock | 328.3348 | 328.72 | 327.795 | 328.35 | 391076.0 |
| 2023-08-30 12:00:00 | MSFT | Stock | 328.35 | 328.92 | 328.07 | 328.89 | 383367.0 |
| 2023-08-30 12:30:00 | MSFT | Stock | 328.91 | 329.07 | 328.4 | 328.865 | 414905.0 |
| 2023-08-30 13:00:00 | MSFT | Stock | 328.855 | 328.885 | 328.1 | 328.3 | 396234.0 |
| 2023-08-30 13:30:00 | MSFT | Stock | 328.2986 | 328.85 | 328.0456 | 328.5058 | 314893.0 |
> showing 50 of 97,395 rows — these rows as CSV