PREVIEW / stock_30min / 2024-08-09
file: by_date/stock_30min/2024/2024-08-09.parquet size: 2.0 MB rows: 95,612 symbols: 824
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-08-09 04:00:00 | AAPL | Stock | 213.41 | 214.04 | 213.26 | 214.04 | 18413.0 |
| 2024-08-09 04:30:00 | AAPL | Stock | 214.06 | 214.25 | 213.98 | 214.1 | 12559.0 |
| 2024-08-09 05:00:00 | AAPL | Stock | 214.14 | 214.14 | 213.54 | 213.54 | 5564.0 |
| 2024-08-09 05:30:00 | AAPL | Stock | 213.61 | 213.66 | 212.44 | 212.44 | 34868.0 |
| 2024-08-09 06:00:00 | AAPL | Stock | 212.4 | 212.4 | 211.57 | 212.16 | 26640.0 |
| 2024-08-09 06:30:00 | AAPL | Stock | 212.36 | 212.49 | 211.9 | 212.3 | 7186.0 |
| 2024-08-09 07:00:00 | AAPL | Stock | 212.46 | 212.7 | 211.5 | 211.99 | 62134.0 |
| 2024-08-09 07:30:00 | AAPL | Stock | 212.01 | 212.01 | 211.0 | 211.62 | 57532.0 |
| 2024-08-09 08:00:00 | AAPL | Stock | 212.7 | 213.8178 | 211.09 | 211.5 | 53948.0 |
| 2024-08-09 08:30:00 | AAPL | Stock | 211.37 | 211.38 | 210.64 | 211.18 | 33215.0 |
| 2024-08-09 09:00:00 | AAPL | Stock | 211.2 | 212.32 | 210.7 | 212.25 | 70810.0 |
| 2024-08-09 09:30:00 | AAPL | Stock | 212.1 | 213.48 | 211.97 | 212.56 | 3168943.0 |
| 2024-08-09 10:00:00 | AAPL | Stock | 212.58 | 214.7895 | 212.34 | 214.7 | 2349994.0 |
| 2024-08-09 10:30:00 | AAPL | Stock | 214.71 | 215.18 | 213.67 | 214.82 | 2031188.0 |
| 2024-08-09 11:00:00 | AAPL | Stock | 214.82 | 215.735 | 214.805 | 215.11 | 1730243.0 |
| 2024-08-09 11:30:00 | AAPL | Stock | 215.12 | 215.71 | 214.54 | 214.7 | 1515993.0 |
| 2024-08-09 12:00:00 | AAPL | Stock | 214.7 | 214.92 | 214.41 | 214.53 | 1225328.0 |
| 2024-08-09 12:30:00 | AAPL | Stock | 214.53 | 215.45 | 214.51 | 215.435 | 1417116.0 |
| 2024-08-09 13:00:00 | AAPL | Stock | 215.4382 | 216.54 | 215.25 | 216.535 | 1631008.0 |
| 2024-08-09 13:30:00 | AAPL | Stock | 216.54 | 216.78 | 215.64 | 215.9164 | 1445408.0 |
| 2024-08-09 14:00:00 | AAPL | Stock | 215.93 | 216.0915 | 214.92 | 215.28 | 1365942.0 |
| 2024-08-09 14:30:00 | AAPL | Stock | 215.275 | 215.68 | 214.9 | 215.61 | 1682145.0 |
| 2024-08-09 15:00:00 | AAPL | Stock | 215.605 | 216.38 | 215.21 | 216.28 | 1653419.0 |
| 2024-08-09 15:30:00 | AAPL | Stock | 216.27 | 216.615 | 215.34 | 216.3 | 4180717.0 |
| 2024-08-09 16:00:00 | AAPL | Stock | 216.24 | 216.4298 | 215.96 | 216.22 | 5904488.0 |
| 2024-08-09 16:30:00 | AAPL | Stock | 216.21 | 216.24 | 216.0998 | 216.12 | 61906.0 |
| 2024-08-09 17:00:00 | AAPL | Stock | 216.09 | 216.2999 | 216.09 | 216.2 | 10338.0 |
| 2024-08-09 17:30:00 | AAPL | Stock | 216.16 | 216.24 | 216.16 | 216.1703 | 3810.0 |
| 2024-08-09 18:00:00 | AAPL | Stock | 216.17 | 216.2 | 216.11 | 216.2 | 4665.0 |
| 2024-08-09 18:30:00 | AAPL | Stock | 216.15 | 216.25 | 216.15 | 216.25 | 3004.0 |
| 2024-08-09 19:00:00 | AAPL | Stock | 216.31 | 216.3763 | 216.28 | 216.32 | 3531.0 |
| 2024-08-09 19:30:00 | AAPL | Stock | 216.32 | 216.468 | 216.31 | 216.468 | 13400.0 |
| 2024-08-09 04:00:00 | MSFT | Stock | 404.75 | 404.88 | 403.92 | 404.88 | 4038.0 |
| 2024-08-09 04:30:00 | MSFT | Stock | 404.86 | 406.82 | 404.86 | 406.25 | 5002.0 |
| 2024-08-09 05:00:00 | MSFT | Stock | 406.32 | 407.3 | 406.2 | 406.93 | 5139.0 |
| 2024-08-09 05:30:00 | MSFT | Stock | 406.61 | 407.0 | 406.2 | 407.0 | 3309.0 |
| 2024-08-09 06:00:00 | MSFT | Stock | 407.0 | 407.0 | 406.1 | 406.69 | 2994.0 |
| 2024-08-09 06:30:00 | MSFT | Stock | 406.67 | 406.85 | 406.5 | 406.5 | 2500.0 |
| 2024-08-09 07:00:00 | MSFT | Stock | 406.6 | 406.64 | 404.73 | 404.75 | 13298.0 |
| 2024-08-09 07:30:00 | MSFT | Stock | 405.3 | 405.3 | 404.27 | 404.81 | 6598.0 |
| 2024-08-09 08:00:00 | MSFT | Stock | 405.4 | 406.3 | 403.0 | 403.19 | 21111.0 |
| 2024-08-09 08:30:00 | MSFT | Stock | 403.1 | 403.49 | 401.6 | 403.29 | 23122.0 |
| 2024-08-09 09:00:00 | MSFT | Stock | 403.0 | 404.21 | 402.67 | 404.0 | 17246.0 |
| 2024-08-09 09:30:00 | MSFT | Stock | 404.03 | 406.0 | 403.12 | 403.48 | 1064404.0 |
| 2024-08-09 10:00:00 | MSFT | Stock | 403.49 | 405.95 | 403.19 | 403.91 | 661568.0 |
| 2024-08-09 10:30:00 | MSFT | Stock | 403.87 | 405.55 | 402.2624 | 405.075 | 592664.0 |
| 2024-08-09 11:00:00 | MSFT | Stock | 405.22 | 406.16 | 404.03 | 404.165 | 426651.0 |
| 2024-08-09 11:30:00 | MSFT | Stock | 404.3 | 405.57 | 403.85 | 404.1399 | 291183.0 |
| 2024-08-09 12:00:00 | MSFT | Stock | 404.21 | 404.49 | 403.41 | 403.68 | 281760.0 |
| 2024-08-09 12:30:00 | MSFT | Stock | 403.65 | 405.17 | 403.65 | 404.98 | 354797.0 |
> showing 50 of 95,612 rows — these rows as CSV