PREVIEW / stock_30min / 2024-06-04
file: by_date/stock_30min/2024/2024-06-04.parquet size: 2.0 MB rows: 99,004 symbols: 974
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-06-04 04:00:00 | AAPL | Stock | 194.03 | 194.03 | 193.44 | 193.65 | 6990.0 |
| 2024-06-04 04:30:00 | AAPL | Stock | 193.51 | 193.6 | 193.31 | 193.31 | 4708.0 |
| 2024-06-04 05:00:00 | AAPL | Stock | 193.25 | 193.25 | 193.02 | 193.2 | 3602.0 |
| 2024-06-04 05:30:00 | AAPL | Stock | 193.2 | 193.4 | 193.2 | 193.2 | 5966.0 |
| 2024-06-04 06:00:00 | AAPL | Stock | 193.21 | 193.43 | 193.03 | 193.43 | 1874.0 |
| 2024-06-04 06:30:00 | AAPL | Stock | 193.31 | 193.34 | 193.3 | 193.3 | 1025.0 |
| 2024-06-04 07:00:00 | AAPL | Stock | 193.46 | 193.6 | 193.4 | 193.6 | 7214.0 |
| 2024-06-04 07:30:00 | AAPL | Stock | 193.64 | 193.88 | 193.6 | 193.68 | 10274.0 |
| 2024-06-04 08:00:00 | AAPL | Stock | 193.41 | 194.42 | 193.3001 | 193.71 | 49443.0 |
| 2024-06-04 08:30:00 | AAPL | Stock | 193.73 | 194.03 | 193.6659 | 193.88 | 30685.0 |
| 2024-06-04 09:00:00 | AAPL | Stock | 193.99 | 194.87 | 193.8612 | 194.63 | 133796.0 |
| 2024-06-04 09:30:00 | AAPL | Stock | 194.61 | 195.0 | 193.0342 | 193.18 | 5028844.0 |
| 2024-06-04 10:00:00 | AAPL | Stock | 193.18 | 194.08 | 193.08 | 194.03 | 3245911.0 |
| 2024-06-04 10:30:00 | AAPL | Stock | 194.025 | 194.4 | 193.66 | 194.1801 | 2444949.0 |
| 2024-06-04 11:00:00 | AAPL | Stock | 194.19 | 194.28 | 193.855 | 194.05 | 1513045.0 |
| 2024-06-04 11:30:00 | AAPL | Stock | 194.055 | 194.18 | 193.715 | 193.8499 | 1345900.0 |
| 2024-06-04 12:00:00 | AAPL | Stock | 193.845 | 194.49 | 193.845 | 194.47 | 1472383.0 |
| 2024-06-04 12:30:00 | AAPL | Stock | 194.47 | 194.82 | 194.34 | 194.525 | 1340823.0 |
| 2024-06-04 13:00:00 | AAPL | Stock | 194.525 | 194.82 | 194.38 | 194.805 | 1137310.0 |
| 2024-06-04 13:30:00 | AAPL | Stock | 194.81 | 194.86 | 194.41 | 194.57 | 1148615.0 |
| 2024-06-04 14:00:00 | AAPL | Stock | 194.57 | 195.32 | 194.5386 | 195.235 | 2856214.0 |
| 2024-06-04 14:30:00 | AAPL | Stock | 195.23 | 195.32 | 194.64 | 194.67 | 1497751.0 |
| 2024-06-04 15:00:00 | AAPL | Stock | 194.66 | 194.705 | 193.93 | 194.505 | 2618940.0 |
| 2024-06-04 15:30:00 | AAPL | Stock | 194.505 | 194.87 | 194.18 | 194.365 | 3259787.0 |
| 2024-06-04 16:00:00 | AAPL | Stock | 194.35 | 194.4695 | 194.08 | 194.38 | 7355348.0 |
| 2024-06-04 16:30:00 | AAPL | Stock | 194.38 | 194.42 | 194.32 | 194.4 | 1268579.0 |
| 2024-06-04 17:00:00 | AAPL | Stock | 194.4 | 194.42 | 194.26 | 194.3 | 7401.0 |
| 2024-06-04 17:30:00 | AAPL | Stock | 194.3799 | 194.4 | 194.33 | 194.3994 | 132637.0 |
| 2024-06-04 18:00:00 | AAPL | Stock | 194.4 | 194.45 | 194.37 | 194.45 | 8951.0 |
| 2024-06-04 18:30:00 | AAPL | Stock | 194.45 | 194.52 | 194.43 | 194.5 | 4292.0 |
| 2024-06-04 19:00:00 | AAPL | Stock | 194.51 | 194.99 | 194.5 | 194.71 | 7794.0 |
| 2024-06-04 19:30:00 | AAPL | Stock | 194.68 | 194.73 | 194.5 | 194.64 | 9257.0 |
| 2024-06-04 04:00:00 | MSFT | Stock | 413.8 | 413.8 | 412.86 | 412.86 | 5634.0 |
| 2024-06-04 04:30:00 | MSFT | Stock | 412.8 | 412.8 | 412.27 | 412.45 | 1304.0 |
| 2024-06-04 05:00:00 | MSFT | Stock | 412.31 | 412.31 | 412.0 | 412.0 | 400.0 |
| 2024-06-04 06:00:00 | MSFT | Stock | 411.6 | 412.05 | 411.6 | 411.82 | 3752.0 |
| 2024-06-04 06:30:00 | MSFT | Stock | 411.71 | 411.74 | 410.93 | 411.08 | 3199.0 |
| 2024-06-04 07:00:00 | MSFT | Stock | 411.28 | 411.77 | 411.28 | 411.77 | 1498.0 |
| 2024-06-04 07:30:00 | MSFT | Stock | 411.95 | 412.26 | 411.95 | 412.06 | 835.0 |
| 2024-06-04 08:00:00 | MSFT | Stock | 411.31 | 417.77 | 411.18 | 411.97 | 16650.0 |
| 2024-06-04 08:30:00 | MSFT | Stock | 412.0 | 412.69 | 412.0 | 412.5 | 3431.0 |
| 2024-06-04 09:00:00 | MSFT | Stock | 412.59 | 413.25 | 411.9 | 412.15 | 8122.0 |
| 2024-06-04 09:30:00 | MSFT | Stock | 412.18 | 412.53 | 409.675 | 411.39 | 1350807.0 |
| 2024-06-04 10:00:00 | MSFT | Stock | 411.39 | 412.7989 | 410.95 | 412.55 | 856467.0 |
| 2024-06-04 10:30:00 | MSFT | Stock | 412.54 | 413.43 | 412.14 | 412.28 | 391711.0 |
| 2024-06-04 11:00:00 | MSFT | Stock | 412.28 | 413.049 | 411.5 | 412.2099 | 335868.0 |
| 2024-06-04 11:30:00 | MSFT | Stock | 412.12 | 412.485 | 411.6 | 412.16 | 246354.0 |
| 2024-06-04 12:00:00 | MSFT | Stock | 412.2 | 412.5927 | 412.0 | 412.375 | 232101.0 |
| 2024-06-04 12:30:00 | MSFT | Stock | 412.35 | 413.37 | 412.31 | 412.91 | 360608.0 |
| 2024-06-04 13:00:00 | MSFT | Stock | 412.905 | 413.56 | 412.26 | 413.47 | 186525.0 |
> showing 50 of 99,004 rows — these rows as CSV