PREVIEW / stock_30min / 2024-08-23
file: by_date/stock_30min/2024/2024-08-23.parquet size: 2.0 MB rows: 98,024 symbols: 833
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-23 04:00:00 | AAPL | Stock | 225.5 | 225.6 | 225.11 | 225.57 | 5164.0 |
| 2024-08-23 04:30:00 | AAPL | Stock | 225.55 | 225.65 | 225.55 | 225.65 | 649.0 |
| 2024-08-23 05:00:00 | AAPL | Stock | 225.71 | 225.71 | 225.5 | 225.66 | 1995.0 |
| 2024-08-23 05:30:00 | AAPL | Stock | 225.66 | 225.75 | 225.5 | 225.7 | 969.0 |
| 2024-08-23 06:00:00 | AAPL | Stock | 225.65 | 225.72 | 225.65 | 225.69 | 1100.0 |
| 2024-08-23 06:30:00 | AAPL | Stock | 225.57 | 225.96 | 225.57 | 225.96 | 1828.0 |
| 2024-08-23 07:00:00 | AAPL | Stock | 225.87 | 226.08 | 225.83 | 225.97 | 9440.0 |
| 2024-08-23 07:30:00 | AAPL | Stock | 226.0 | 226.14 | 225.95 | 226.14 | 3876.0 |
| 2024-08-23 08:00:00 | AAPL | Stock | 225.99 | 226.35 | 225.05 | 226.16 | 38381.0 |
| 2024-08-23 08:30:00 | AAPL | Stock | 226.1 | 226.38 | 226.0102 | 226.34 | 39622.0 |
| 2024-08-23 09:00:00 | AAPL | Stock | 226.34 | 226.47 | 224.53 | 225.64 | 117282.0 |
| 2024-08-23 09:30:00 | AAPL | Stock | 225.79 | 227.39 | 225.51 | 227.04 | 3274893.0 |
| 2024-08-23 10:00:00 | AAPL | Stock | 227.06 | 228.22 | 226.8 | 227.975 | 3103253.0 |
| 2024-08-23 10:30:00 | AAPL | Stock | 227.99 | 228.11 | 225.51 | 226.2399 | 2514152.0 |
| 2024-08-23 11:00:00 | AAPL | Stock | 226.21 | 226.74 | 225.1901 | 225.95 | 1633775.0 |
| 2024-08-23 11:30:00 | AAPL | Stock | 225.95 | 226.71 | 225.61 | 225.84 | 1019886.0 |
| 2024-08-23 12:00:00 | AAPL | Stock | 225.85 | 225.905 | 224.88 | 225.115 | 1287379.0 |
| 2024-08-23 12:30:00 | AAPL | Stock | 225.11 | 225.47 | 224.33 | 225.3 | 1255634.0 |
| 2024-08-23 13:00:00 | AAPL | Stock | 225.33 | 225.99 | 225.15 | 225.965 | 756331.0 |
| 2024-08-23 13:30:00 | AAPL | Stock | 225.97 | 226.51 | 225.95 | 226.21 | 947501.0 |
| 2024-08-23 14:00:00 | AAPL | Stock | 226.21 | 226.55 | 226.11 | 226.4527 | 823813.0 |
| 2024-08-23 14:30:00 | AAPL | Stock | 226.455 | 226.7 | 226.22 | 226.47 | 716420.0 |
| 2024-08-23 15:00:00 | AAPL | Stock | 226.47 | 227.1 | 226.22 | 227.06 | 1148581.0 |
| 2024-08-23 15:30:00 | AAPL | Stock | 227.065 | 227.1669 | 226.23 | 226.7736 | 2611457.0 |
| 2024-08-23 16:00:00 | AAPL | Stock | 226.76 | 227.09 | 226.76 | 226.96 | 6353745.0 |
| 2024-08-23 16:30:00 | AAPL | Stock | 226.93 | 226.99 | 226.84 | 226.95 | 2853999.0 |
| 2024-08-23 17:00:00 | AAPL | Stock | 226.99 | 226.99 | 226.95 | 226.95 | 5190.0 |
| 2024-08-23 17:30:00 | AAPL | Stock | 226.98 | 226.99 | 226.9 | 226.9783 | 3996.0 |
| 2024-08-23 18:00:00 | AAPL | Stock | 226.98 | 227.0799 | 226.98 | 227.0789 | 5966.0 |
| 2024-08-23 18:30:00 | AAPL | Stock | 227.04 | 227.1 | 227.03 | 227.1 | 5000.0 |
| 2024-08-23 19:00:00 | AAPL | Stock | 227.1292 | 227.17 | 227.1 | 227.11 | 4065.0 |
| 2024-08-23 19:30:00 | AAPL | Stock | 227.11 | 227.1631 | 227.01 | 227.1631 | 10105.0 |
| 2024-08-23 04:00:00 | MSFT | Stock | 418.05 | 418.3 | 417.51 | 418.1 | 1489.0 |
| 2024-08-23 04:30:00 | MSFT | Stock | 418.28 | 418.5 | 418.28 | 418.41 | 1181.0 |
| 2024-08-23 05:00:00 | MSFT | Stock | 418.02 | 418.02 | 417.8 | 418.02 | 890.0 |
| 2024-08-23 05:30:00 | MSFT | Stock | 418.16 | 418.95 | 418.16 | 418.92 | 2240.0 |
| 2024-08-23 06:00:00 | MSFT | Stock | 418.91 | 418.91 | 418.8 | 418.84 | 556.0 |
| 2024-08-23 06:30:00 | MSFT | Stock | 418.82 | 419.06 | 418.81 | 419.06 | 2085.0 |
| 2024-08-23 07:00:00 | MSFT | Stock | 419.0 | 419.0 | 418.4 | 418.5 | 7278.0 |
| 2024-08-23 07:30:00 | MSFT | Stock | 418.61 | 418.75 | 418.5 | 418.59 | 2305.0 |
| 2024-08-23 08:00:00 | MSFT | Stock | 418.42 | 419.0 | 416.588 | 418.5 | 14029.0 |
| 2024-08-23 08:30:00 | MSFT | Stock | 418.5 | 418.55 | 418.25 | 418.5 | 11962.0 |
| 2024-08-23 09:00:00 | MSFT | Stock | 418.54 | 418.86 | 416.6 | 416.9 | 34813.0 |
| 2024-08-23 09:30:00 | MSFT | Stock | 416.98 | 417.91 | 416.28 | 417.24 | 1076253.0 |
| 2024-08-23 10:00:00 | MSFT | Stock | 417.26 | 419.26 | 417.17 | 418.18 | 1012476.0 |
| 2024-08-23 10:30:00 | MSFT | Stock | 418.22 | 418.32 | 412.92 | 414.93 | 976821.0 |
| 2024-08-23 11:00:00 | MSFT | Stock | 414.9 | 416.6 | 413.96 | 415.509 | 533971.0 |
| 2024-08-23 11:30:00 | MSFT | Stock | 415.56 | 416.81 | 414.59 | 414.635 | 367982.0 |
| 2024-08-23 12:00:00 | MSFT | Stock | 414.69 | 414.805 | 412.4 | 412.85 | 485623.0 |
| 2024-08-23 12:30:00 | MSFT | Stock | 412.86 | 414.41 | 412.09 | 413.97 | 367496.0 |
> showing 50 of 98,024 rows — these rows as CSV