PREVIEW / stock_30min / 2023-12-29
file: by_date/stock_30min/2023/2023-12-29.parquet size: 2.1 MB rows: 102,724 symbols: 1,236
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-12-29 04:00:00 | AAPL | Stock | 193.77 | 193.86 | 193.7 | 193.86 | 2948.0 |
| 2023-12-29 04:30:00 | AAPL | Stock | 193.86 | 193.88 | 193.76 | 193.76 | 2257.0 |
| 2023-12-29 05:00:00 | AAPL | Stock | 193.74 | 193.75 | 193.74 | 193.75 | 500.0 |
| 2023-12-29 05:30:00 | AAPL | Stock | 193.67 | 193.67 | 193.67 | 193.67 | 100.0 |
| 2023-12-29 06:00:00 | AAPL | Stock | 193.75 | 193.75 | 193.67 | 193.75 | 1379.0 |
| 2023-12-29 06:30:00 | AAPL | Stock | 193.75 | 193.75 | 193.75 | 193.75 | 200.0 |
| 2023-12-29 07:00:00 | AAPL | Stock | 193.8 | 193.86 | 193.69 | 193.7 | 6582.0 |
| 2023-12-29 07:30:00 | AAPL | Stock | 193.75 | 193.77 | 193.6 | 193.73 | 8854.0 |
| 2023-12-29 08:00:00 | AAPL | Stock | 193.72 | 193.89 | 193.56 | 193.7 | 41846.0 |
| 2023-12-29 08:30:00 | AAPL | Stock | 193.7596 | 193.95 | 193.65 | 193.93 | 15801.0 |
| 2023-12-29 09:00:00 | AAPL | Stock | 193.93 | 194.0 | 193.58 | 193.87 | 63286.0 |
| 2023-12-29 09:30:00 | AAPL | Stock | 193.88 | 194.4 | 193.4301 | 193.505 | 2531103.0 |
| 2023-12-29 10:00:00 | AAPL | Stock | 193.505 | 193.52 | 193.2203 | 193.51 | 1511743.0 |
| 2023-12-29 10:30:00 | AAPL | Stock | 193.51 | 193.55 | 192.6646 | 192.755 | 1651632.0 |
| 2023-12-29 11:00:00 | AAPL | Stock | 192.76 | 192.8667 | 191.9099 | 191.96 | 1805491.0 |
| 2023-12-29 11:30:00 | AAPL | Stock | 191.965 | 192.45 | 191.89 | 192.3201 | 1566007.0 |
| 2023-12-29 12:00:00 | AAPL | Stock | 192.325 | 192.48 | 191.725 | 191.9 | 1933003.0 |
| 2023-12-29 12:30:00 | AAPL | Stock | 191.905 | 192.06 | 191.78 | 191.955 | 1626671.0 |
| 2023-12-29 13:00:00 | AAPL | Stock | 191.955 | 192.23 | 191.87 | 191.9 | 1457493.0 |
| 2023-12-29 13:30:00 | AAPL | Stock | 191.905 | 192.42 | 191.9 | 192.37 | 1245119.0 |
| 2023-12-29 14:00:00 | AAPL | Stock | 192.375 | 192.45 | 192.09 | 192.12 | 876074.0 |
| 2023-12-29 14:30:00 | AAPL | Stock | 192.115 | 192.54 | 192.11 | 192.47 | 1021004.0 |
| 2023-12-29 15:00:00 | AAPL | Stock | 192.475 | 192.73 | 192.27 | 192.68 | 1730586.0 |
| 2023-12-29 15:30:00 | AAPL | Stock | 192.675 | 193.13 | 192.02 | 192.52 | 6293773.0 |
| 2023-12-29 16:00:00 | AAPL | Stock | 192.54 | 192.955 | 192.38 | 192.4 | 8536919.0 |
| 2023-12-29 16:30:00 | AAPL | Stock | 192.41 | 192.53 | 192.26 | 192.38 | 246844.0 |
| 2023-12-29 17:00:00 | AAPL | Stock | 192.3702 | 192.53 | 192.0 | 192.16 | 81434.0 |
| 2023-12-29 17:30:00 | AAPL | Stock | 192.16 | 192.28 | 192.16 | 192.26 | 9090.0 |
| 2023-12-29 18:00:00 | AAPL | Stock | 192.2599 | 192.2599 | 192.16 | 192.16 | 3216.0 |
| 2023-12-29 18:30:00 | AAPL | Stock | 192.19 | 192.23 | 192.13 | 192.1894 | 9878.0 |
| 2023-12-29 19:00:00 | AAPL | Stock | 192.14 | 192.16 | 192.1 | 192.11 | 3166.0 |
| 2023-12-29 19:30:00 | AAPL | Stock | 192.1 | 192.24 | 192.1 | 192.1501 | 19032.0 |
| 2023-12-29 04:00:00 | MSFT | Stock | 376.01 | 376.03 | 376.01 | 376.03 | 200.0 |
| 2023-12-29 04:30:00 | MSFT | Stock | 376.03 | 376.03 | 375.81 | 375.81 | 855.0 |
| 2023-12-29 05:00:00 | MSFT | Stock | 375.84 | 375.84 | 375.84 | 375.84 | 410.0 |
| 2023-12-29 05:30:00 | MSFT | Stock | 375.96 | 375.96 | 375.96 | 375.96 | 100.0 |
| 2023-12-29 06:00:00 | MSFT | Stock | 376.2 | 376.2 | 376.2 | 376.2 | 768.0 |
| 2023-12-29 06:30:00 | MSFT | Stock | 376.15 | 376.25 | 376.15 | 376.23 | 640.0 |
| 2023-12-29 07:00:00 | MSFT | Stock | 376.03 | 376.04 | 375.48 | 375.8 | 6800.0 |
| 2023-12-29 07:30:00 | MSFT | Stock | 375.73 | 375.75 | 375.5 | 375.51 | 993.0 |
| 2023-12-29 08:00:00 | MSFT | Stock | 375.9 | 376.48 | 375.5 | 375.9352 | 14285.0 |
| 2023-12-29 08:30:00 | MSFT | Stock | 375.88 | 376.0 | 375.77 | 375.88 | 5219.0 |
| 2023-12-29 09:00:00 | MSFT | Stock | 375.92 | 376.03 | 375.7 | 376.03 | 12287.0 |
| 2023-12-29 09:30:00 | MSFT | Stock | 376.0 | 377.16 | 375.66 | 376.805 | 1357206.0 |
| 2023-12-29 10:00:00 | MSFT | Stock | 376.78 | 377.13 | 376.4801 | 377.09 | 628297.0 |
| 2023-12-29 10:30:00 | MSFT | Stock | 377.09 | 377.11 | 375.27 | 375.685 | 785243.0 |
| 2023-12-29 11:00:00 | MSFT | Stock | 375.67 | 375.92 | 373.6 | 373.64 | 764516.0 |
| 2023-12-29 11:30:00 | MSFT | Stock | 373.59 | 374.64 | 373.56 | 374.37 | 426748.0 |
| 2023-12-29 12:00:00 | MSFT | Stock | 374.35 | 374.63 | 373.48 | 373.69 | 407825.0 |
| 2023-12-29 12:30:00 | MSFT | Stock | 373.69 | 374.73 | 373.63 | 374.7 | 417189.0 |
> showing 50 of 102,724 rows — these rows as CSV