PREVIEW / stock_30min / 2024-08-12
file: by_date/stock_30min/2024/2024-08-12.parquet size: 2.0 MB rows: 97,153 symbols: 854
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-12 04:00:00 | AAPL | Stock | 216.77 | 217.01 | 216.3 | 216.77 | 7107.0 |
| 2024-08-12 04:30:00 | AAPL | Stock | 216.75 | 216.75 | 216.62 | 216.7 | 8463.0 |
| 2024-08-12 05:00:00 | AAPL | Stock | 216.79 | 216.85 | 216.75 | 216.76 | 1919.0 |
| 2024-08-12 05:30:00 | AAPL | Stock | 216.83 | 216.94 | 216.8 | 216.92 | 2609.0 |
| 2024-08-12 06:00:00 | AAPL | Stock | 216.9 | 216.9 | 216.66 | 216.66 | 8591.0 |
| 2024-08-12 06:30:00 | AAPL | Stock | 216.79 | 216.93 | 216.79 | 216.85 | 3170.0 |
| 2024-08-12 07:00:00 | AAPL | Stock | 216.8 | 216.99 | 216.42 | 216.99 | 14028.0 |
| 2024-08-12 07:30:00 | AAPL | Stock | 216.8 | 216.9 | 216.55 | 216.8 | 8731.0 |
| 2024-08-12 08:00:00 | AAPL | Stock | 216.7 | 217.09 | 216.42 | 217.08 | 40832.0 |
| 2024-08-12 08:30:00 | AAPL | Stock | 217.09 | 217.26 | 216.52 | 216.68 | 42364.0 |
| 2024-08-12 09:00:00 | AAPL | Stock | 216.72 | 216.93 | 216.01 | 216.04 | 80119.0 |
| 2024-08-12 09:30:00 | AAPL | Stock | 216.14 | 217.65 | 215.6 | 216.9924 | 3839429.0 |
| 2024-08-12 10:00:00 | AAPL | Stock | 217.0 | 218.715 | 216.88 | 218.45 | 2786162.0 |
| 2024-08-12 10:30:00 | AAPL | Stock | 218.44 | 219.09 | 218.15 | 218.63 | 2115456.0 |
| 2024-08-12 11:00:00 | AAPL | Stock | 218.64 | 219.5099 | 217.15 | 217.7948 | 2363247.0 |
| 2024-08-12 11:30:00 | AAPL | Stock | 217.805 | 218.75 | 217.35 | 218.7301 | 1577933.0 |
| 2024-08-12 12:00:00 | AAPL | Stock | 218.73 | 218.7574 | 217.8 | 217.98 | 1149693.0 |
| 2024-08-12 12:30:00 | AAPL | Stock | 217.97 | 218.34 | 217.18 | 217.19 | 1068116.0 |
| 2024-08-12 13:00:00 | AAPL | Stock | 217.19 | 217.7 | 217.03 | 217.25 | 1517393.0 |
| 2024-08-12 13:30:00 | AAPL | Stock | 217.25 | 217.455 | 216.47 | 216.845 | 1357267.0 |
| 2024-08-12 14:00:00 | AAPL | Stock | 216.85 | 217.0485 | 216.53 | 216.745 | 962685.0 |
| 2024-08-12 14:30:00 | AAPL | Stock | 216.73 | 217.42 | 216.595 | 217.3852 | 856214.0 |
| 2024-08-12 15:00:00 | AAPL | Stock | 217.4 | 217.44 | 216.96 | 217.03 | 1116468.0 |
| 2024-08-12 15:30:00 | AAPL | Stock | 217.04 | 217.67 | 216.59 | 217.55 | 2527985.0 |
| 2024-08-12 16:00:00 | AAPL | Stock | 217.53 | 217.79 | 217.45 | 217.58 | 5881708.0 |
| 2024-08-12 16:30:00 | AAPL | Stock | 217.5799 | 217.68 | 217.53 | 217.6182 | 52744.0 |
| 2024-08-12 17:00:00 | AAPL | Stock | 217.6 | 217.68 | 217.52 | 217.52 | 22665.0 |
| 2024-08-12 17:30:00 | AAPL | Stock | 217.5744 | 217.63 | 217.51 | 217.53 | 8961.0 |
| 2024-08-12 18:00:00 | AAPL | Stock | 217.55 | 217.67 | 217.55 | 217.61 | 5339.0 |
| 2024-08-12 18:30:00 | AAPL | Stock | 217.61 | 217.65 | 217.59 | 217.65 | 976.0 |
| 2024-08-12 19:00:00 | AAPL | Stock | 217.6 | 217.6592 | 217.54 | 217.62 | 9196.0 |
| 2024-08-12 19:30:00 | AAPL | Stock | 217.65 | 217.77 | 217.53 | 217.59 | 13421.0 |
| 2024-08-12 04:00:00 | MSFT | Stock | 407.9 | 408.11 | 406.73 | 407.38 | 6342.0 |
| 2024-08-12 04:30:00 | MSFT | Stock | 407.28 | 407.28 | 406.89 | 406.89 | 1648.0 |
| 2024-08-12 05:00:00 | MSFT | Stock | 407.07 | 407.34 | 407.07 | 407.34 | 200.0 |
| 2024-08-12 05:30:00 | MSFT | Stock | 407.54 | 407.93 | 407.35 | 407.85 | 3189.0 |
| 2024-08-12 06:00:00 | MSFT | Stock | 407.78 | 407.88 | 407.55 | 407.88 | 740.0 |
| 2024-08-12 06:30:00 | MSFT | Stock | 408.34 | 409.0 | 408.31 | 408.77 | 2809.0 |
| 2024-08-12 07:00:00 | MSFT | Stock | 408.38 | 408.89 | 408.2 | 408.89 | 3695.0 |
| 2024-08-12 07:30:00 | MSFT | Stock | 408.75 | 408.88 | 408.0 | 408.5 | 4630.0 |
| 2024-08-12 08:00:00 | MSFT | Stock | 408.2601 | 409.0 | 408.0 | 408.99 | 15319.0 |
| 2024-08-12 08:30:00 | MSFT | Stock | 408.89 | 408.99 | 408.0582 | 408.0582 | 4531.0 |
| 2024-08-12 09:00:00 | MSFT | Stock | 408.38 | 408.7468 | 407.07 | 407.07 | 13147.0 |
| 2024-08-12 09:30:00 | MSFT | Stock | 407.01 | 408.33 | 404.44 | 404.725 | 1195558.0 |
| 2024-08-12 10:00:00 | MSFT | Stock | 404.72 | 406.54 | 404.2434 | 405.8 | 643919.0 |
| 2024-08-12 10:30:00 | MSFT | Stock | 405.76 | 407.1 | 405.5975 | 407.1 | 476141.0 |
| 2024-08-12 11:00:00 | MSFT | Stock | 407.1 | 408.135 | 404.35 | 405.3915 | 611074.0 |
| 2024-08-12 11:30:00 | MSFT | Stock | 405.37 | 408.34 | 405.18 | 408.32 | 551954.0 |
| 2024-08-12 12:00:00 | MSFT | Stock | 408.32 | 408.76 | 407.41 | 407.8417 | 392626.0 |
| 2024-08-12 12:30:00 | MSFT | Stock | 407.83 | 408.2 | 405.85 | 405.86 | 320856.0 |
> showing 50 of 97,153 rows — these rows as CSV