PREVIEW / stock_30min / 2024-05-01
file: by_date/stock_30min/2024/2024-05-01.parquet size: 2.0 MB rows: 96,453 symbols: 970
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 |
|---|---|---|---|---|---|---|---|
| 2024-05-01 04:00:00 | AAPL | Stock | 170.5 | 170.5 | 169.57 | 169.57 | 9220.0 |
| 2024-05-01 04:30:00 | AAPL | Stock | 169.69 | 169.79 | 169.51 | 169.79 | 3869.0 |
| 2024-05-01 05:00:00 | AAPL | Stock | 169.73 | 169.73 | 169.34 | 169.49 | 6148.0 |
| 2024-05-01 05:30:00 | AAPL | Stock | 169.5 | 169.6 | 169.36 | 169.59 | 877.0 |
| 2024-05-01 06:00:00 | AAPL | Stock | 169.5 | 170.1 | 169.5 | 169.9 | 9077.0 |
| 2024-05-01 06:30:00 | AAPL | Stock | 169.89 | 170.3 | 169.75 | 170.1 | 5665.0 |
| 2024-05-01 07:00:00 | AAPL | Stock | 170.2 | 170.2 | 169.82 | 169.82 | 7166.0 |
| 2024-05-01 07:30:00 | AAPL | Stock | 169.92 | 170.1 | 169.88 | 169.99 | 11463.0 |
| 2024-05-01 08:00:00 | AAPL | Stock | 170.15 | 170.6 | 169.5 | 169.75 | 82503.0 |
| 2024-05-01 08:30:00 | AAPL | Stock | 169.83 | 170.33 | 169.64 | 169.9702 | 110170.0 |
| 2024-05-01 09:00:00 | AAPL | Stock | 169.96 | 170.19 | 169.5809 | 169.78 | 124791.0 |
| 2024-05-01 09:30:00 | AAPL | Stock | 169.58 | 170.6387 | 169.11 | 170.3299 | 3606462.0 |
| 2024-05-01 10:00:00 | AAPL | Stock | 170.32 | 171.07 | 170.17 | 170.815 | 2470320.0 |
| 2024-05-01 10:30:00 | AAPL | Stock | 170.785 | 171.35 | 170.65 | 171.105 | 1678306.0 |
| 2024-05-01 11:00:00 | AAPL | Stock | 171.1 | 171.36 | 170.645 | 171.17 | 1476217.0 |
| 2024-05-01 11:30:00 | AAPL | Stock | 171.17 | 171.6 | 171.1 | 171.52 | 1909248.0 |
| 2024-05-01 12:00:00 | AAPL | Stock | 171.52 | 171.72 | 171.29 | 171.395 | 1438274.0 |
| 2024-05-01 12:30:00 | AAPL | Stock | 171.38 | 171.45 | 171.06 | 171.06 | 1202106.0 |
| 2024-05-01 13:00:00 | AAPL | Stock | 171.055 | 171.21 | 170.755 | 171.12 | 983270.0 |
| 2024-05-01 13:30:00 | AAPL | Stock | 171.125 | 171.249 | 170.61 | 171.23 | 1384288.0 |
| 2024-05-01 14:00:00 | AAPL | Stock | 171.24 | 171.51 | 170.83 | 171.42 | 1675083.0 |
| 2024-05-01 14:30:00 | AAPL | Stock | 171.42 | 172.635 | 170.895 | 172.48 | 3628980.0 |
| 2024-05-01 15:00:00 | AAPL | Stock | 172.49 | 172.705 | 171.98 | 172.39 | 2518970.0 |
| 2024-05-01 15:30:00 | AAPL | Stock | 172.385 | 172.39 | 169.25 | 169.31 | 6901252.0 |
| 2024-05-01 16:00:00 | AAPL | Stock | 169.3 | 170.0 | 169.1 | 169.9 | 7198334.0 |
| 2024-05-01 16:30:00 | AAPL | Stock | 169.93 | 170.34 | 169.3 | 170.06 | 178138.0 |
| 2024-05-01 17:00:00 | AAPL | Stock | 170.03 | 170.27 | 169.3 | 170.23 | 46472.0 |
| 2024-05-01 17:30:00 | AAPL | Stock | 170.29 | 170.39 | 170.0812 | 170.35 | 23672.0 |
| 2024-05-01 18:00:00 | AAPL | Stock | 170.3 | 170.45 | 169.3 | 170.1987 | 36464.0 |
| 2024-05-01 18:30:00 | AAPL | Stock | 170.15 | 170.28 | 170.08 | 170.15 | 16571.0 |
| 2024-05-01 19:00:00 | AAPL | Stock | 170.29 | 170.29 | 170.09 | 170.09 | 15038.0 |
| 2024-05-01 19:30:00 | AAPL | Stock | 170.09 | 170.49 | 170.08 | 170.35 | 24127.0 |
| 2024-05-01 04:00:00 | MSFT | Stock | 391.11 | 391.11 | 390.2 | 390.24 | 730.0 |
| 2024-05-01 04:30:00 | MSFT | Stock | 390.81 | 390.85 | 390.7 | 390.85 | 425.0 |
| 2024-05-01 05:00:00 | MSFT | Stock | 390.88 | 390.88 | 390.0 | 390.7 | 2389.0 |
| 2024-05-01 05:30:00 | MSFT | Stock | 390.59 | 390.71 | 390.3 | 390.35 | 1234.0 |
| 2024-05-01 06:00:00 | MSFT | Stock | 390.2 | 390.73 | 390.0 | 390.73 | 2751.0 |
| 2024-05-01 06:30:00 | MSFT | Stock | 390.15 | 390.84 | 389.57 | 390.84 | 5388.0 |
| 2024-05-01 07:00:00 | MSFT | Stock | 390.9 | 391.23 | 390.6 | 391.1 | 8946.0 |
| 2024-05-01 07:30:00 | MSFT | Stock | 391.15 | 391.25 | 390.39 | 390.4 | 4080.0 |
| 2024-05-01 08:00:00 | MSFT | Stock | 391.0 | 392.2 | 389.33 | 391.0 | 109990.0 |
| 2024-05-01 08:30:00 | MSFT | Stock | 391.41 | 393.0 | 389.33 | 392.62 | 29709.0 |
| 2024-05-01 09:00:00 | MSFT | Stock | 392.42 | 394.35 | 392.0 | 393.44 | 46092.0 |
| 2024-05-01 09:30:00 | MSFT | Stock | 392.61 | 394.31 | 390.31 | 391.9972 | 1851732.0 |
| 2024-05-01 10:00:00 | MSFT | Stock | 392.03 | 393.66 | 391.28 | 393.625 | 684573.0 |
| 2024-05-01 10:30:00 | MSFT | Stock | 393.66 | 395.2435 | 393.38 | 394.675 | 975866.0 |
| 2024-05-01 11:00:00 | MSFT | Stock | 394.61 | 395.626 | 394.19 | 394.6038 | 993957.0 |
| 2024-05-01 11:30:00 | MSFT | Stock | 394.54 | 394.91 | 393.15 | 393.17 | 993914.0 |
| 2024-05-01 12:00:00 | MSFT | Stock | 393.19 | 393.71 | 392.66 | 393.67 | 416662.0 |
| 2024-05-01 12:30:00 | MSFT | Stock | 393.66 | 394.57 | 393.24 | 394.475 | 351601.0 |
> showing 50 of 96,453 rows — these rows as CSV