PREVIEW / stock_30min / 2024-05-21
file: by_date/stock_30min/2024/2024-05-21.parquet size: 2.0 MB rows: 98,620 symbols: 972
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-21 04:00:00 | AAPL | Stock | 191.18 | 191.18 | 190.79 | 190.85 | 5866.0 |
| 2024-05-21 04:30:00 | AAPL | Stock | 190.81 | 190.84 | 190.81 | 190.81 | 2990.0 |
| 2024-05-21 05:00:00 | AAPL | Stock | 190.8 | 190.8 | 190.75 | 190.75 | 1286.0 |
| 2024-05-21 05:30:00 | AAPL | Stock | 190.74 | 190.77 | 190.74 | 190.77 | 1367.0 |
| 2024-05-21 06:00:00 | AAPL | Stock | 190.8 | 190.96 | 190.8 | 190.95 | 1963.0 |
| 2024-05-21 06:30:00 | AAPL | Stock | 190.95 | 191.33 | 190.95 | 191.22 | 9242.0 |
| 2024-05-21 07:00:00 | AAPL | Stock | 191.21 | 191.6 | 191.2 | 191.58 | 8878.0 |
| 2024-05-21 07:30:00 | AAPL | Stock | 191.55 | 191.67 | 191.52 | 191.52 | 6985.0 |
| 2024-05-21 08:00:00 | AAPL | Stock | 191.29 | 191.66 | 191.05 | 191.31 | 25915.0 |
| 2024-05-21 08:30:00 | AAPL | Stock | 191.29 | 191.39 | 191.04 | 191.39 | 28819.0 |
| 2024-05-21 09:00:00 | AAPL | Stock | 191.33 | 191.65 | 191.0681 | 191.13 | 137718.0 |
| 2024-05-21 09:30:00 | AAPL | Stock | 191.09 | 192.24 | 190.9201 | 192.2 | 4691021.0 |
| 2024-05-21 10:00:00 | AAPL | Stock | 192.2 | 192.6 | 192.07 | 192.21 | 3081423.0 |
| 2024-05-21 10:30:00 | AAPL | Stock | 192.22 | 192.3499 | 191.86 | 192.2899 | 1851686.0 |
| 2024-05-21 11:00:00 | AAPL | Stock | 192.2899 | 192.65 | 192.165 | 192.28 | 1952476.0 |
| 2024-05-21 11:30:00 | AAPL | Stock | 192.29 | 192.423 | 192.02 | 192.105 | 1103173.0 |
| 2024-05-21 12:00:00 | AAPL | Stock | 192.11 | 192.2 | 191.83 | 192.1791 | 1005071.0 |
| 2024-05-21 12:30:00 | AAPL | Stock | 192.175 | 192.2188 | 191.78 | 192.1299 | 947239.0 |
| 2024-05-21 13:00:00 | AAPL | Stock | 192.1271 | 192.385 | 192.0482 | 192.36 | 1575651.0 |
| 2024-05-21 13:30:00 | AAPL | Stock | 192.37 | 192.53 | 192.295 | 192.4988 | 1411752.0 |
| 2024-05-21 14:00:00 | AAPL | Stock | 192.5 | 192.54 | 192.33 | 192.515 | 1316706.0 |
| 2024-05-21 14:30:00 | AAPL | Stock | 192.515 | 192.63 | 192.42 | 192.605 | 1245548.0 |
| 2024-05-21 15:00:00 | AAPL | Stock | 192.6 | 192.68 | 192.395 | 192.53 | 1721013.0 |
| 2024-05-21 15:30:00 | AAPL | Stock | 192.53 | 192.73 | 192.275 | 192.36 | 4524002.0 |
| 2024-05-21 16:00:00 | AAPL | Stock | 192.47 | 192.47 | 192.33 | 192.34 | 6335161.0 |
| 2024-05-21 16:30:00 | AAPL | Stock | 192.35 | 192.44 | 192.35 | 192.35 | 221363.0 |
| 2024-05-21 17:00:00 | AAPL | Stock | 192.36 | 192.4 | 192.34 | 192.39 | 7191.0 |
| 2024-05-21 17:30:00 | AAPL | Stock | 192.37 | 192.44 | 192.37 | 192.4 | 829.0 |
| 2024-05-21 18:00:00 | AAPL | Stock | 192.4 | 192.47 | 192.39 | 192.47 | 3606.0 |
| 2024-05-21 18:30:00 | AAPL | Stock | 192.48 | 192.62 | 192.45 | 192.59 | 5619.0 |
| 2024-05-21 19:00:00 | AAPL | Stock | 192.62 | 192.62 | 192.35 | 192.46 | 6330.0 |
| 2024-05-21 19:30:00 | AAPL | Stock | 192.49 | 192.68 | 192.46 | 192.48 | 15918.0 |
| 2024-05-21 04:00:00 | MSFT | Stock | 425.67 | 425.95 | 425.66 | 425.95 | 1263.0 |
| 2024-05-21 04:30:00 | MSFT | Stock | 426.25 | 426.25 | 426.02 | 426.02 | 345.0 |
| 2024-05-21 05:30:00 | MSFT | Stock | 426.2 | 426.35 | 426.2 | 426.35 | 779.0 |
| 2024-05-21 06:00:00 | MSFT | Stock | 426.77 | 426.96 | 426.77 | 426.96 | 972.0 |
| 2024-05-21 06:30:00 | MSFT | Stock | 427.19 | 427.48 | 427.19 | 427.4 | 1840.0 |
| 2024-05-21 07:00:00 | MSFT | Stock | 427.32 | 427.32 | 426.0 | 426.97 | 11902.0 |
| 2024-05-21 07:30:00 | MSFT | Stock | 426.92 | 427.0 | 426.69 | 426.75 | 2816.0 |
| 2024-05-21 08:00:00 | MSFT | Stock | 426.24 | 427.35 | 424.66 | 426.8008 | 15877.0 |
| 2024-05-21 08:30:00 | MSFT | Stock | 426.8 | 426.84 | 426.4115 | 426.53 | 15975.0 |
| 2024-05-21 09:00:00 | MSFT | Stock | 426.4 | 427.0 | 426.15 | 426.77 | 25373.0 |
| 2024-05-21 09:30:00 | MSFT | Stock | 426.99 | 428.15 | 424.85 | 427.0345 | 1776559.0 |
| 2024-05-21 10:00:00 | MSFT | Stock | 427.005 | 428.82 | 427.005 | 428.77 | 909848.0 |
| 2024-05-21 10:30:00 | MSFT | Stock | 428.79 | 430.5 | 428.61 | 429.015 | 1059691.0 |
| 2024-05-21 11:00:00 | MSFT | Stock | 429.01 | 429.96 | 428.88 | 429.67 | 489625.0 |
| 2024-05-21 11:30:00 | MSFT | Stock | 429.69 | 432.97 | 429.47 | 431.8702 | 1629744.0 |
| 2024-05-21 12:00:00 | MSFT | Stock | 431.8401 | 431.87 | 430.37 | 430.51 | 762633.0 |
| 2024-05-21 12:30:00 | MSFT | Stock | 430.5 | 430.5599 | 429.37 | 429.62 | 505941.0 |
| 2024-05-21 13:00:00 | MSFT | Stock | 429.59 | 430.4575 | 429.3501 | 430.2957 | 547134.0 |
> showing 50 of 98,620 rows — these rows as CSV