PREVIEW / stock_30min / 2024-07-03
file: by_date/stock_30min/2024/2024-07-03.parquet size: 1.4 MB rows: 62,724 symbols: 861
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-07-03 04:00:00 | AAPL | Stock | 220.0 | 220.0 | 219.66 | 219.84 | 5071.0 |
| 2024-07-03 04:30:00 | AAPL | Stock | 219.76 | 219.85 | 219.53 | 219.7 | 14352.0 |
| 2024-07-03 05:00:00 | AAPL | Stock | 219.62 | 219.7 | 219.51 | 219.56 | 5594.0 |
| 2024-07-03 05:30:00 | AAPL | Stock | 219.56 | 219.75 | 219.49 | 219.71 | 10940.0 |
| 2024-07-03 06:00:00 | AAPL | Stock | 219.71 | 219.75 | 219.55 | 219.75 | 7201.0 |
| 2024-07-03 06:30:00 | AAPL | Stock | 219.8 | 219.8 | 219.53 | 219.6 | 4661.0 |
| 2024-07-03 07:00:00 | AAPL | Stock | 219.64 | 219.7 | 219.5 | 219.55 | 20930.0 |
| 2024-07-03 07:30:00 | AAPL | Stock | 219.5 | 219.5 | 219.21 | 219.45 | 19092.0 |
| 2024-07-03 08:00:00 | AAPL | Stock | 219.635 | 219.89 | 219.21 | 219.52 | 92433.0 |
| 2024-07-03 08:30:00 | AAPL | Stock | 219.59 | 219.88 | 219.55 | 219.61 | 61085.0 |
| 2024-07-03 09:00:00 | AAPL | Stock | 219.6001 | 220.0 | 219.3 | 219.99 | 81533.0 |
| 2024-07-03 09:30:00 | AAPL | Stock | 220.0 | 221.33 | 219.6 | 221.14 | 6940324.0 |
| 2024-07-03 10:00:00 | AAPL | Stock | 221.16 | 221.4 | 219.03 | 219.38 | 4708712.0 |
| 2024-07-03 10:30:00 | AAPL | Stock | 219.3799 | 220.58 | 219.1001 | 220.54 | 2654525.0 |
| 2024-07-03 11:00:00 | AAPL | Stock | 220.55 | 220.74 | 220.02 | 220.115 | 2375161.0 |
| 2024-07-03 11:30:00 | AAPL | Stock | 220.115 | 220.455 | 219.77 | 220.3099 | 1780857.0 |
| 2024-07-03 12:00:00 | AAPL | Stock | 220.32 | 221.31 | 220.32 | 221.3 | 2306704.0 |
| 2024-07-03 12:30:00 | AAPL | Stock | 221.29 | 221.55 | 220.88 | 221.54 | 4606493.0 |
| 2024-07-03 13:00:00 | AAPL | Stock | 221.51 | 221.71 | 221.01 | 221.0999 | 4772408.0 |
| 2024-07-03 13:30:00 | AAPL | Stock | 221.0802 | 221.1 | 220.7108 | 220.8488 | 43166.0 |
| 2024-07-03 14:00:00 | AAPL | Stock | 220.85 | 221.55 | 220.75 | 220.8901 | 31650.0 |
| 2024-07-03 14:30:00 | AAPL | Stock | 220.89 | 221.1 | 220.86 | 221.07 | 11422.0 |
| 2024-07-03 15:00:00 | AAPL | Stock | 221.04 | 221.26 | 220.92 | 220.93 | 15334.0 |
| 2024-07-03 15:30:00 | AAPL | Stock | 220.93 | 221.55 | 220.69 | 221.0 | 24104.0 |
| 2024-07-03 16:00:00 | AAPL | Stock | 220.88 | 220.95 | 220.84 | 220.95 | 3086.0 |
| 2024-07-03 16:30:00 | AAPL | Stock | 220.9495 | 221.08 | 220.9495 | 221.08 | 7382.0 |
| 2024-07-03 04:00:00 | MSFT | Stock | 459.25 | 459.25 | 458.94 | 459.11 | 3702.0 |
| 2024-07-03 04:30:00 | MSFT | Stock | 459.07 | 459.2 | 458.9 | 459.2 | 715.0 |
| 2024-07-03 05:00:00 | MSFT | Stock | 459.28 | 459.36 | 459.28 | 459.35 | 689.0 |
| 2024-07-03 06:00:00 | MSFT | Stock | 459.61 | 459.61 | 459.61 | 459.61 | 103.0 |
| 2024-07-03 07:00:00 | MSFT | Stock | 459.1 | 459.14 | 458.93 | 458.93 | 3378.0 |
| 2024-07-03 07:30:00 | MSFT | Stock | 458.8 | 459.0 | 458.71 | 458.71 | 2383.0 |
| 2024-07-03 08:00:00 | MSFT | Stock | 459.26 | 459.57 | 458.1 | 458.19 | 8682.0 |
| 2024-07-03 08:30:00 | MSFT | Stock | 458.3 | 458.415 | 457.75 | 457.75 | 5636.0 |
| 2024-07-03 09:00:00 | MSFT | Stock | 458.0 | 458.5 | 457.75 | 458.0 | 10160.0 |
| 2024-07-03 09:30:00 | MSFT | Stock | 458.19 | 460.48 | 457.88 | 459.11 | 1199249.0 |
| 2024-07-03 10:00:00 | MSFT | Stock | 459.2 | 459.57 | 458.0 | 458.03 | 613457.0 |
| 2024-07-03 10:30:00 | MSFT | Stock | 458.08 | 459.15 | 458.0 | 458.75 | 381438.0 |
| 2024-07-03 11:00:00 | MSFT | Stock | 458.745 | 460.7799 | 458.51 | 460.175 | 460903.0 |
| 2024-07-03 11:30:00 | MSFT | Stock | 460.175 | 460.22 | 458.71 | 459.32 | 432694.0 |
| 2024-07-03 12:00:00 | MSFT | Stock | 459.31 | 460.39 | 459.18 | 459.555 | 459527.0 |
| 2024-07-03 12:30:00 | MSFT | Stock | 459.55 | 461.02 | 459.1763 | 460.77 | 1272726.0 |
| 2024-07-03 13:00:00 | MSFT | Stock | 460.77 | 460.77 | 460.03 | 460.5 | 2008541.0 |
| 2024-07-03 13:30:00 | MSFT | Stock | 459.6472 | 460.6499 | 459.6472 | 460.0 | 5629.0 |
| 2024-07-03 14:00:00 | MSFT | Stock | 460.1 | 460.2893 | 459.91 | 459.91 | 3243.0 |
| 2024-07-03 14:30:00 | MSFT | Stock | 460.29 | 460.77 | 460.0 | 460.1865 | 124944.0 |
| 2024-07-03 15:00:00 | MSFT | Stock | 460.2 | 460.2 | 460.0035 | 460.0035 | 1437.0 |
| 2024-07-03 15:30:00 | MSFT | Stock | 460.29 | 460.3851 | 460.0 | 460.0 | 1083.0 |
| 2024-07-03 16:00:00 | MSFT | Stock | 460.3 | 460.5 | 460.15 | 460.3 | 932.0 |
| 2024-07-03 16:30:00 | MSFT | Stock | 460.3586 | 460.3586 | 459.8 | 459.8 | 6477.0 |
> showing 50 of 62,724 rows — these rows as CSV