PREVIEW / stock_30min / 2024-01-30
file: by_date/stock_30min/2024/2024-01-30.parquet size: 2.0 MB rows: 98,799 symbols: 1,161
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-01-30 04:00:00 | AAPL | Stock | 190.91 | 190.91 | 190.39 | 190.4 | 9534.0 |
| 2024-01-30 04:30:00 | AAPL | Stock | 190.38 | 190.5 | 190.37 | 190.5 | 6963.0 |
| 2024-01-30 05:00:00 | AAPL | Stock | 190.5 | 190.76 | 190.5 | 190.7 | 2197.0 |
| 2024-01-30 05:30:00 | AAPL | Stock | 190.7 | 190.7 | 190.42 | 190.43 | 1749.0 |
| 2024-01-30 06:00:00 | AAPL | Stock | 190.4 | 190.5 | 190.39 | 190.5 | 4784.0 |
| 2024-01-30 06:30:00 | AAPL | Stock | 190.6 | 190.66 | 190.51 | 190.51 | 3507.0 |
| 2024-01-30 07:00:00 | AAPL | Stock | 190.57 | 190.75 | 190.51 | 190.73 | 12720.0 |
| 2024-01-30 07:30:00 | AAPL | Stock | 190.7 | 190.75 | 190.55 | 190.55 | 21728.0 |
| 2024-01-30 08:00:00 | AAPL | Stock | 190.5115 | 191.2 | 190.25 | 190.4702 | 57760.0 |
| 2024-01-30 08:30:00 | AAPL | Stock | 190.61 | 190.75 | 190.43 | 190.55 | 23329.0 |
| 2024-01-30 09:00:00 | AAPL | Stock | 190.55 | 190.96 | 190.35 | 190.94 | 98080.0 |
| 2024-01-30 09:30:00 | AAPL | Stock | 190.95 | 191.8 | 190.68 | 191.11 | 4322730.0 |
| 2024-01-30 10:00:00 | AAPL | Stock | 191.1 | 191.17 | 189.46 | 189.95 | 4367805.0 |
| 2024-01-30 10:30:00 | AAPL | Stock | 189.93 | 190.25 | 188.22 | 188.49 | 5912848.0 |
| 2024-01-30 11:00:00 | AAPL | Stock | 188.4898 | 188.82 | 187.865 | 188.6532 | 4403231.0 |
| 2024-01-30 11:30:00 | AAPL | Stock | 188.655 | 188.94 | 188.57 | 188.7201 | 1963904.0 |
| 2024-01-30 12:00:00 | AAPL | Stock | 188.73 | 188.93 | 188.23 | 188.41 | 2040871.0 |
| 2024-01-30 12:30:00 | AAPL | Stock | 188.4 | 188.49 | 187.87 | 187.8702 | 2055682.0 |
| 2024-01-30 13:00:00 | AAPL | Stock | 187.8713 | 188.57 | 187.68 | 188.564 | 1919156.0 |
| 2024-01-30 13:30:00 | AAPL | Stock | 188.56 | 188.6399 | 187.99 | 188.02 | 1539286.0 |
| 2024-01-30 14:00:00 | AAPL | Stock | 188.02 | 188.0399 | 187.47 | 187.845 | 2342627.0 |
| 2024-01-30 14:30:00 | AAPL | Stock | 187.845 | 188.28 | 187.77 | 188.23 | 1483177.0 |
| 2024-01-30 15:00:00 | AAPL | Stock | 188.225 | 188.27 | 187.845 | 188.07 | 2025144.0 |
| 2024-01-30 15:30:00 | AAPL | Stock | 188.065 | 188.14 | 187.8 | 187.98 | 4222514.0 |
| 2024-01-30 16:00:00 | AAPL | Stock | 188.04 | 188.33 | 187.26 | 187.67 | 5830276.0 |
| 2024-01-30 16:30:00 | AAPL | Stock | 187.71 | 188.34 | 187.6 | 188.26 | 199598.0 |
| 2024-01-30 17:00:00 | AAPL | Stock | 188.33 | 188.39 | 187.82 | 187.83 | 67024.0 |
| 2024-01-30 17:30:00 | AAPL | Stock | 187.83 | 188.09 | 187.4 | 187.5 | 87663.0 |
| 2024-01-30 18:00:00 | AAPL | Stock | 187.5 | 187.8 | 187.27 | 187.41 | 47290.0 |
| 2024-01-30 18:30:00 | AAPL | Stock | 187.42 | 187.88 | 187.42 | 187.85 | 14394.0 |
| 2024-01-30 19:00:00 | AAPL | Stock | 187.88 | 187.88 | 187.55 | 187.62 | 7262.0 |
| 2024-01-30 19:30:00 | AAPL | Stock | 187.7 | 187.7 | 187.25 | 187.3 | 34882.0 |
| 2024-01-30 04:00:00 | MSFT | Stock | 413.97 | 414.04 | 412.31 | 412.45 | 25656.0 |
| 2024-01-30 04:30:00 | MSFT | Stock | 412.69 | 412.9 | 412.51 | 412.69 | 7871.0 |
| 2024-01-30 05:00:00 | MSFT | Stock | 412.68 | 413.31 | 412.37 | 413.07 | 6910.0 |
| 2024-01-30 05:30:00 | MSFT | Stock | 413.01 | 413.38 | 412.59 | 412.59 | 2212.0 |
| 2024-01-30 06:00:00 | MSFT | Stock | 412.6 | 413.31 | 412.4 | 412.66 | 10913.0 |
| 2024-01-30 06:30:00 | MSFT | Stock | 412.88 | 413.0 | 412.57 | 412.58 | 5366.0 |
| 2024-01-30 07:00:00 | MSFT | Stock | 412.87 | 413.45 | 412.35 | 413.1 | 42139.0 |
| 2024-01-30 07:30:00 | MSFT | Stock | 413.0 | 413.2 | 412.6 | 412.75 | 11281.0 |
| 2024-01-30 08:00:00 | MSFT | Stock | 413.36 | 417.16 | 412.0675 | 412.49 | 129007.0 |
| 2024-01-30 08:30:00 | MSFT | Stock | 412.58 | 412.8 | 411.86 | 412.18 | 30760.0 |
| 2024-01-30 09:00:00 | MSFT | Stock | 412.13 | 413.73 | 412.13 | 412.22 | 68877.0 |
| 2024-01-30 09:30:00 | MSFT | Stock | 412.26 | 413.05 | 410.26 | 410.88 | 2750712.0 |
| 2024-01-30 10:00:00 | MSFT | Stock | 410.825 | 410.97 | 409.44 | 410.35 | 1830786.0 |
| 2024-01-30 10:30:00 | MSFT | Stock | 410.33 | 411.04 | 409.01 | 409.495 | 1156389.0 |
| 2024-01-30 11:00:00 | MSFT | Stock | 409.49 | 410.57 | 409.49 | 410.14 | 919405.0 |
| 2024-01-30 11:30:00 | MSFT | Stock | 410.16 | 410.3075 | 409.53 | 409.66 | 693770.0 |
| 2024-01-30 12:00:00 | MSFT | Stock | 409.67 | 409.83 | 407.23 | 407.47 | 1052999.0 |
| 2024-01-30 12:30:00 | MSFT | Stock | 407.47 | 407.59 | 406.4501 | 407.14 | 988017.0 |
> showing 50 of 98,799 rows — these rows as CSV