PREVIEW / stock_30min / 2024-08-14
file: by_date/stock_30min/2024/2024-08-14.parquet size: 2.0 MB rows: 97,609 symbols: 852
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-14 04:00:00 | AAPL | Stock | 221.28 | 221.4 | 220.77 | 221.07 | 16419.0 |
| 2024-08-14 04:30:00 | AAPL | Stock | 221.14 | 221.18 | 221.0 | 221.07 | 2879.0 |
| 2024-08-14 05:00:00 | AAPL | Stock | 221.19 | 221.59 | 221.12 | 221.58 | 4911.0 |
| 2024-08-14 05:30:00 | AAPL | Stock | 221.63 | 221.7 | 221.57 | 221.61 | 2526.0 |
| 2024-08-14 06:00:00 | AAPL | Stock | 221.69 | 221.77 | 221.2 | 221.26 | 6010.0 |
| 2024-08-14 06:30:00 | AAPL | Stock | 221.51 | 221.51 | 221.35 | 221.35 | 2244.0 |
| 2024-08-14 07:00:00 | AAPL | Stock | 221.33 | 221.33 | 220.95 | 221.14 | 9214.0 |
| 2024-08-14 07:30:00 | AAPL | Stock | 221.14 | 221.14 | 221.04 | 221.04 | 8032.0 |
| 2024-08-14 08:00:00 | AAPL | Stock | 221.2 | 221.65 | 220.35 | 221.3598 | 45312.0 |
| 2024-08-14 08:30:00 | AAPL | Stock | 221.37 | 221.9996 | 220.32 | 221.41 | 115610.0 |
| 2024-08-14 09:00:00 | AAPL | Stock | 221.35 | 222.0 | 220.17 | 220.42 | 219167.0 |
| 2024-08-14 09:30:00 | AAPL | Stock | 220.42 | 222.02 | 219.7 | 220.95 | 4755099.0 |
| 2024-08-14 10:00:00 | AAPL | Stock | 220.945 | 221.7 | 220.69 | 221.13 | 2044559.0 |
| 2024-08-14 10:30:00 | AAPL | Stock | 221.11 | 221.73 | 220.455 | 221.6901 | 1819613.0 |
| 2024-08-14 11:00:00 | AAPL | Stock | 221.695 | 222.56 | 221.6 | 222.5587 | 1603563.0 |
| 2024-08-14 11:30:00 | AAPL | Stock | 222.55 | 223.03 | 222.39 | 222.9701 | 1333747.0 |
| 2024-08-14 12:00:00 | AAPL | Stock | 222.97 | 222.97 | 221.015 | 221.305 | 1692812.0 |
| 2024-08-14 12:30:00 | AAPL | Stock | 221.32 | 221.35 | 220.38 | 221.04 | 1517040.0 |
| 2024-08-14 13:00:00 | AAPL | Stock | 221.03 | 221.465 | 220.88 | 221.175 | 1082235.0 |
| 2024-08-14 13:30:00 | AAPL | Stock | 221.17 | 221.77 | 221.0904 | 221.27 | 1248130.0 |
| 2024-08-14 14:00:00 | AAPL | Stock | 221.26 | 221.72 | 220.9 | 221.54 | 1275396.0 |
| 2024-08-14 14:30:00 | AAPL | Stock | 221.53 | 221.61 | 221.01 | 221.57 | 1027699.0 |
| 2024-08-14 15:00:00 | AAPL | Stock | 221.58 | 221.58 | 220.81 | 221.16 | 1245462.0 |
| 2024-08-14 15:30:00 | AAPL | Stock | 221.16 | 222.35 | 221.1501 | 221.61 | 3279679.0 |
| 2024-08-14 16:00:00 | AAPL | Stock | 221.59 | 221.96 | 221.49 | 221.6566 | 5223758.0 |
| 2024-08-14 16:30:00 | AAPL | Stock | 221.67 | 221.95 | 221.6 | 221.68 | 25894.0 |
| 2024-08-14 17:00:00 | AAPL | Stock | 221.71 | 221.7396 | 221.59 | 221.66 | 6414.0 |
| 2024-08-14 17:30:00 | AAPL | Stock | 221.5841 | 221.85 | 221.5841 | 221.85 | 2876.0 |
| 2024-08-14 18:00:00 | AAPL | Stock | 221.85 | 221.85 | 221.608 | 221.608 | 6717.0 |
| 2024-08-14 18:30:00 | AAPL | Stock | 221.54 | 221.61 | 221.5005 | 221.6081 | 8149.0 |
| 2024-08-14 19:00:00 | AAPL | Stock | 221.6 | 221.9399 | 221.59 | 221.9399 | 10614.0 |
| 2024-08-14 19:30:00 | AAPL | Stock | 221.85 | 222.1594 | 221.72 | 222.0 | 35517.0 |
| 2024-08-14 04:00:00 | MSFT | Stock | 415.07 | 415.07 | 414.35 | 414.93 | 3959.0 |
| 2024-08-14 04:30:00 | MSFT | Stock | 414.99 | 415.7 | 414.99 | 415.13 | 2020.0 |
| 2024-08-14 05:00:00 | MSFT | Stock | 415.28 | 415.28 | 414.97 | 415.0 | 800.0 |
| 2024-08-14 05:30:00 | MSFT | Stock | 414.84 | 414.84 | 414.79 | 414.79 | 1357.0 |
| 2024-08-14 06:00:00 | MSFT | Stock | 414.72 | 415.0 | 414.72 | 415.0 | 950.0 |
| 2024-08-14 06:30:00 | MSFT | Stock | 415.37 | 415.49 | 415.25 | 415.49 | 516.0 |
| 2024-08-14 07:00:00 | MSFT | Stock | 415.32 | 415.4 | 414.8 | 414.88 | 4379.0 |
| 2024-08-14 07:30:00 | MSFT | Stock | 414.98 | 415.14 | 414.83 | 415.13 | 2167.0 |
| 2024-08-14 08:00:00 | MSFT | Stock | 415.0097 | 415.4918 | 414.31 | 414.96 | 15886.0 |
| 2024-08-14 08:30:00 | MSFT | Stock | 415.19 | 416.3 | 412.41 | 414.51 | 29510.0 |
| 2024-08-14 09:00:00 | MSFT | Stock | 414.6 | 415.48 | 414.1107 | 415.03 | 15899.0 |
| 2024-08-14 09:30:00 | MSFT | Stock | 414.89 | 416.637 | 413.86 | 415.38 | 1338833.0 |
| 2024-08-14 10:00:00 | MSFT | Stock | 415.395 | 415.56 | 413.49 | 414.275 | 411965.0 |
| 2024-08-14 10:30:00 | MSFT | Stock | 414.19 | 414.97 | 412.4456 | 414.865 | 393734.0 |
| 2024-08-14 11:00:00 | MSFT | Stock | 414.915 | 416.2832 | 414.77 | 416.2832 | 380273.0 |
| 2024-08-14 11:30:00 | MSFT | Stock | 416.3 | 417.56 | 416.08 | 417.445 | 449100.0 |
| 2024-08-14 12:00:00 | MSFT | Stock | 417.33 | 417.3699 | 415.2442 | 415.86 | 414871.0 |
| 2024-08-14 12:30:00 | MSFT | Stock | 415.875 | 416.49 | 415.11 | 416.45 | 234212.0 |
> showing 50 of 97,609 rows — these rows as CSV