PREVIEW / stock_30min / 2024-02-13
file: by_date/stock_30min/2024/2024-02-13.parquet size: 2.1 MB rows: 101,700 symbols: 1,149
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-02-13 04:00:00 | AAPL | Stock | 186.52 | 186.61 | 186.0 | 186.42 | 10732.0 |
| 2024-02-13 04:30:00 | AAPL | Stock | 186.32 | 186.32 | 186.11 | 186.11 | 3216.0 |
| 2024-02-13 05:00:00 | AAPL | Stock | 186.0 | 186.01 | 185.8 | 185.84 | 4342.0 |
| 2024-02-13 05:30:00 | AAPL | Stock | 185.84 | 185.93 | 185.79 | 185.8 | 2356.0 |
| 2024-02-13 06:00:00 | AAPL | Stock | 185.8 | 185.99 | 185.8 | 185.99 | 6289.0 |
| 2024-02-13 06:30:00 | AAPL | Stock | 186.01 | 186.06 | 185.73 | 185.82 | 4415.0 |
| 2024-02-13 07:00:00 | AAPL | Stock | 185.91 | 186.09 | 185.87 | 186.04 | 10747.0 |
| 2024-02-13 07:30:00 | AAPL | Stock | 186.04 | 186.16 | 185.94 | 186.14 | 9437.0 |
| 2024-02-13 08:00:00 | AAPL | Stock | 185.97 | 187.03 | 185.92 | 186.45 | 49696.0 |
| 2024-02-13 08:30:00 | AAPL | Stock | 186.49 | 186.5 | 185.05 | 185.25 | 251887.0 |
| 2024-02-13 09:00:00 | AAPL | Stock | 185.25 | 186.0 | 185.18 | 185.8 | 141571.0 |
| 2024-02-13 09:30:00 | AAPL | Stock | 185.77 | 186.21 | 184.18 | 185.16 | 6056177.0 |
| 2024-02-13 10:00:00 | AAPL | Stock | 185.15 | 185.48 | 184.76 | 185.4708 | 2778882.0 |
| 2024-02-13 10:30:00 | AAPL | Stock | 185.4799 | 186.19 | 185.36 | 185.85 | 2945557.0 |
| 2024-02-13 11:00:00 | AAPL | Stock | 185.85 | 186.025 | 185.48 | 185.61 | 1723970.0 |
| 2024-02-13 11:30:00 | AAPL | Stock | 185.595 | 185.7394 | 185.2701 | 185.41 | 1541298.0 |
| 2024-02-13 12:00:00 | AAPL | Stock | 185.41 | 185.676 | 185.2516 | 185.475 | 1372480.0 |
| 2024-02-13 12:30:00 | AAPL | Stock | 185.48 | 185.77 | 185.11 | 185.16 | 1254659.0 |
| 2024-02-13 13:00:00 | AAPL | Stock | 185.15 | 185.44 | 185.132 | 185.295 | 1241917.0 |
| 2024-02-13 13:30:00 | AAPL | Stock | 185.29 | 185.38 | 184.96 | 185.0 | 1611208.0 |
| 2024-02-13 14:00:00 | AAPL | Stock | 184.99 | 184.995 | 184.19 | 184.285 | 2153827.0 |
| 2024-02-13 14:30:00 | AAPL | Stock | 184.28 | 184.595 | 183.7925 | 183.8597 | 2171977.0 |
| 2024-02-13 15:00:00 | AAPL | Stock | 183.855 | 183.91 | 183.5128 | 183.7299 | 2348142.0 |
| 2024-02-13 15:30:00 | AAPL | Stock | 183.725 | 185.2 | 183.69 | 185.03 | 6069173.0 |
| 2024-02-13 16:00:00 | AAPL | Stock | 185.04 | 185.2492 | 184.96 | 185.1501 | 6991688.0 |
| 2024-02-13 16:30:00 | AAPL | Stock | 185.1539 | 185.41 | 185.04 | 185.3197 | 73501.0 |
| 2024-02-13 17:00:00 | AAPL | Stock | 185.31 | 185.31 | 185.21 | 185.21 | 12181.0 |
| 2024-02-13 17:30:00 | AAPL | Stock | 185.25 | 185.34 | 185.11 | 185.34 | 18564.0 |
| 2024-02-13 18:00:00 | AAPL | Stock | 185.34 | 185.34 | 185.0 | 185.21 | 27755.0 |
| 2024-02-13 18:30:00 | AAPL | Stock | 185.23 | 185.23 | 185.14 | 185.15 | 5933.0 |
| 2024-02-13 19:00:00 | AAPL | Stock | 185.17 | 185.2 | 185.11 | 185.11 | 2826.0 |
| 2024-02-13 19:30:00 | AAPL | Stock | 185.14 | 185.35 | 185.14 | 185.3 | 7314.0 |
| 2024-02-13 04:00:00 | MSFT | Stock | 414.35 | 414.35 | 413.78 | 413.89 | 1532.0 |
| 2024-02-13 04:30:00 | MSFT | Stock | 413.28 | 413.28 | 412.12 | 412.3 | 4331.0 |
| 2024-02-13 05:00:00 | MSFT | Stock | 412.33 | 412.33 | 411.92 | 411.92 | 3151.0 |
| 2024-02-13 05:30:00 | MSFT | Stock | 411.96 | 412.25 | 411.96 | 412.1 | 1912.0 |
| 2024-02-13 06:00:00 | MSFT | Stock | 412.03 | 412.06 | 411.51 | 411.51 | 7970.0 |
| 2024-02-13 06:30:00 | MSFT | Stock | 411.35 | 411.35 | 409.85 | 410.77 | 11780.0 |
| 2024-02-13 07:00:00 | MSFT | Stock | 410.63 | 411.47 | 408.84 | 410.08 | 38303.0 |
| 2024-02-13 07:30:00 | MSFT | Stock | 410.25 | 410.6 | 409.64 | 410.1 | 13099.0 |
| 2024-02-13 08:00:00 | MSFT | Stock | 416.1 | 416.1 | 408.85 | 411.0999 | 51631.0 |
| 2024-02-13 08:30:00 | MSFT | Stock | 411.1 | 411.1 | 406.24 | 406.75 | 159325.0 |
| 2024-02-13 09:00:00 | MSFT | Stock | 406.7 | 406.7 | 404.25 | 404.77 | 129355.0 |
| 2024-02-13 09:30:00 | MSFT | Stock | 404.85 | 407.7 | 403.39 | 407.57 | 3402981.0 |
| 2024-02-13 10:00:00 | MSFT | Stock | 407.51 | 408.93 | 406.06 | 408.91 | 1446094.0 |
| 2024-02-13 10:30:00 | MSFT | Stock | 408.9 | 410.071 | 408.18 | 408.26 | 1244419.0 |
| 2024-02-13 11:00:00 | MSFT | Stock | 408.3 | 409.78 | 408.25 | 408.9 | 776581.0 |
| 2024-02-13 11:30:00 | MSFT | Stock | 408.88 | 409.17 | 407.8 | 407.89 | 655769.0 |
| 2024-02-13 12:00:00 | MSFT | Stock | 407.88 | 408.0 | 406.87 | 407.24 | 815388.0 |
| 2024-02-13 12:30:00 | MSFT | Stock | 407.245 | 408.32 | 406.89 | 406.89 | 614974.0 |
> showing 50 of 101,700 rows — these rows as CSV