PREVIEW / stock_30min / 2023-10-12
file: by_date/stock_30min/2023/2023-10-12.parquet size: 2.0 MB rows: 97,323 symbols: 1,380
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-10-12 04:00:00 | AAPL | Stock | 180.24 | 180.47 | 180.2 | 180.41 | 9261.0 |
| 2023-10-12 04:30:00 | AAPL | Stock | 180.41 | 180.5 | 180.41 | 180.46 | 4387.0 |
| 2023-10-12 05:00:00 | AAPL | Stock | 180.53 | 180.61 | 180.51 | 180.6 | 2621.0 |
| 2023-10-12 05:30:00 | AAPL | Stock | 180.59 | 180.64 | 180.46 | 180.46 | 12700.0 |
| 2023-10-12 06:00:00 | AAPL | Stock | 180.48 | 180.58 | 180.45 | 180.58 | 15343.0 |
| 2023-10-12 06:30:00 | AAPL | Stock | 180.51 | 180.54 | 180.43 | 180.49 | 2116.0 |
| 2023-10-12 07:00:00 | AAPL | Stock | 180.45 | 180.5 | 180.22 | 180.22 | 14095.0 |
| 2023-10-12 07:30:00 | AAPL | Stock | 180.25 | 180.47 | 180.25 | 180.47 | 18885.0 |
| 2023-10-12 08:00:00 | AAPL | Stock | 180.27 | 180.5595 | 180.01 | 180.4399 | 62480.0 |
| 2023-10-12 08:30:00 | AAPL | Stock | 180.35 | 180.44 | 179.49 | 179.94 | 203908.0 |
| 2023-10-12 09:00:00 | AAPL | Stock | 179.82 | 180.1 | 179.71 | 180.1 | 102337.0 |
| 2023-10-12 09:30:00 | AAPL | Stock | 180.07 | 180.99 | 179.84 | 180.93 | 4905085.0 |
| 2023-10-12 10:00:00 | AAPL | Stock | 180.93 | 182.1499 | 180.81 | 181.72 | 5947372.0 |
| 2023-10-12 10:30:00 | AAPL | Stock | 181.73 | 182.1078 | 181.46 | 182.06 | 3622803.0 |
| 2023-10-12 11:00:00 | AAPL | Stock | 182.065 | 182.34 | 181.64 | 181.77 | 3310685.0 |
| 2023-10-12 11:30:00 | AAPL | Stock | 181.765 | 181.962 | 181.51 | 181.94 | 2556650.0 |
| 2023-10-12 12:00:00 | AAPL | Stock | 181.94 | 182.29 | 181.7907 | 182.27 | 2250551.0 |
| 2023-10-12 12:30:00 | AAPL | Stock | 182.28 | 182.28 | 181.87 | 181.955 | 1860740.0 |
| 2023-10-12 13:00:00 | AAPL | Stock | 181.955 | 182.06 | 180.33 | 180.3549 | 3068352.0 |
| 2023-10-12 13:30:00 | AAPL | Stock | 180.34 | 180.63 | 179.96 | 179.985 | 2234735.0 |
| 2023-10-12 14:00:00 | AAPL | Stock | 179.99 | 180.13 | 179.04 | 179.64 | 3561458.0 |
| 2023-10-12 14:30:00 | AAPL | Stock | 179.635 | 180.02 | 179.49 | 179.8099 | 1672146.0 |
| 2023-10-12 15:00:00 | AAPL | Stock | 179.82 | 180.48 | 179.73 | 180.4 | 2421824.0 |
| 2023-10-12 15:30:00 | AAPL | Stock | 180.4 | 180.815 | 180.39 | 180.73 | 5016193.0 |
| 2023-10-12 16:00:00 | AAPL | Stock | 180.7201 | 181.11 | 180.69 | 181.1 | 4159882.0 |
| 2023-10-12 16:30:00 | AAPL | Stock | 181.1 | 181.2 | 180.71 | 181.1 | 53444.0 |
| 2023-10-12 17:00:00 | AAPL | Stock | 181.09 | 181.21 | 181.09 | 181.19 | 15328.0 |
| 2023-10-12 17:30:00 | AAPL | Stock | 181.19 | 181.23 | 181.1 | 181.19 | 17966.0 |
| 2023-10-12 18:00:00 | AAPL | Stock | 181.2 | 181.2 | 180.71 | 181.13 | 25118.0 |
| 2023-10-12 18:30:00 | AAPL | Stock | 181.08 | 181.18 | 181.04 | 181.15 | 7206.0 |
| 2023-10-12 19:00:00 | AAPL | Stock | 181.1399 | 181.49 | 181.1 | 181.49 | 9236.0 |
| 2023-10-12 19:30:00 | AAPL | Stock | 181.4 | 181.4988 | 181.3 | 181.45 | 24417.0 |
| 2023-10-12 04:00:00 | MSFT | Stock | 330.56 | 331.05 | 330.56 | 331.05 | 695.0 |
| 2023-10-12 04:30:00 | MSFT | Stock | 331.0 | 331.0 | 331.0 | 331.0 | 100.0 |
| 2023-10-12 05:00:00 | MSFT | Stock | 331.5 | 331.59 | 331.44 | 331.59 | 600.0 |
| 2023-10-12 05:30:00 | MSFT | Stock | 331.58 | 331.75 | 331.58 | 331.75 | 599.0 |
| 2023-10-12 06:00:00 | MSFT | Stock | 331.6 | 331.65 | 331.42 | 331.42 | 614.0 |
| 2023-10-12 06:30:00 | MSFT | Stock | 331.25 | 331.25 | 331.2 | 331.2 | 829.0 |
| 2023-10-12 07:00:00 | MSFT | Stock | 331.08 | 331.27 | 330.6 | 330.6 | 14418.0 |
| 2023-10-12 07:30:00 | MSFT | Stock | 330.6 | 330.75 | 330.35 | 330.36 | 8817.0 |
| 2023-10-12 08:00:00 | MSFT | Stock | 330.93 | 331.74 | 330.14 | 330.73 | 33826.0 |
| 2023-10-12 08:30:00 | MSFT | Stock | 330.3 | 330.9 | 329.1313 | 330.05 | 69011.0 |
| 2023-10-12 09:00:00 | MSFT | Stock | 330.0 | 330.65 | 329.55 | 330.65 | 29842.0 |
| 2023-10-12 09:30:00 | MSFT | Stock | 330.65 | 332.16 | 329.59 | 331.86 | 1877675.0 |
| 2023-10-12 10:00:00 | MSFT | Stock | 331.865 | 333.485 | 331.2 | 332.68 | 1287687.0 |
| 2023-10-12 10:30:00 | MSFT | Stock | 332.68 | 332.96 | 331.795 | 332.73 | 864389.0 |
| 2023-10-12 11:00:00 | MSFT | Stock | 332.74 | 333.6299 | 332.17 | 332.2145 | 956377.0 |
| 2023-10-12 11:30:00 | MSFT | Stock | 332.26 | 332.7 | 331.71 | 332.225 | 559783.0 |
| 2023-10-12 12:00:00 | MSFT | Stock | 332.275 | 332.83 | 331.87 | 332.57 | 649780.0 |
| 2023-10-12 12:30:00 | MSFT | Stock | 332.59 | 332.96 | 332.23 | 332.4593 | 606032.0 |
> showing 50 of 97,323 rows — these rows as CSV