PREVIEW / stock_30min / 2024-03-19
file: by_date/stock_30min/2024/2024-03-19.parquet size: 2.1 MB rows: 100,075 symbols: 1,072
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-03-19 04:00:00 | AAPL | Stock | 173.9 | 173.96 | 173.32 | 173.73 | 4125.0 |
| 2024-03-19 04:30:00 | AAPL | Stock | 173.84 | 174.38 | 173.81 | 174.1 | 6441.0 |
| 2024-03-19 05:00:00 | AAPL | Stock | 174.15 | 174.15 | 173.74 | 174.08 | 3818.0 |
| 2024-03-19 05:30:00 | AAPL | Stock | 174.19 | 174.2 | 173.86 | 173.86 | 3989.0 |
| 2024-03-19 06:00:00 | AAPL | Stock | 174.04 | 174.09 | 173.96 | 173.96 | 949.0 |
| 2024-03-19 06:30:00 | AAPL | Stock | 174.07 | 174.41 | 173.96 | 174.01 | 8503.0 |
| 2024-03-19 07:00:00 | AAPL | Stock | 174.03 | 174.07 | 173.26 | 173.35 | 19264.0 |
| 2024-03-19 07:30:00 | AAPL | Stock | 173.35 | 173.45 | 173.15 | 173.35 | 10215.0 |
| 2024-03-19 08:00:00 | AAPL | Stock | 173.74 | 174.14 | 173.0593 | 173.0593 | 67874.0 |
| 2024-03-19 08:30:00 | AAPL | Stock | 173.2 | 174.3 | 173.06 | 174.22 | 66951.0 |
| 2024-03-19 09:00:00 | AAPL | Stock | 174.23 | 174.84 | 174.15 | 174.25 | 167937.0 |
| 2024-03-19 09:30:00 | AAPL | Stock | 174.34 | 174.5 | 173.03 | 174.46 | 5517485.0 |
| 2024-03-19 10:00:00 | AAPL | Stock | 174.455 | 175.04 | 174.435 | 174.705 | 3699437.0 |
| 2024-03-19 10:30:00 | AAPL | Stock | 174.7 | 175.37 | 174.56 | 174.88 | 2970886.0 |
| 2024-03-19 11:00:00 | AAPL | Stock | 174.88 | 175.34 | 174.62 | 174.84 | 2041923.0 |
| 2024-03-19 11:30:00 | AAPL | Stock | 174.84 | 175.415 | 174.84 | 175.21 | 1916613.0 |
| 2024-03-19 12:00:00 | AAPL | Stock | 175.215 | 175.396 | 174.88 | 175.31 | 1464576.0 |
| 2024-03-19 12:30:00 | AAPL | Stock | 175.315 | 175.475 | 175.17 | 175.3245 | 1350108.0 |
| 2024-03-19 13:00:00 | AAPL | Stock | 175.3202 | 175.85 | 175.3202 | 175.645 | 1863556.0 |
| 2024-03-19 13:30:00 | AAPL | Stock | 175.65 | 176.12 | 175.64 | 176.115 | 1669675.0 |
| 2024-03-19 14:00:00 | AAPL | Stock | 176.12 | 176.435 | 176.0721 | 176.425 | 2139288.0 |
| 2024-03-19 14:30:00 | AAPL | Stock | 176.43 | 176.605 | 176.1 | 176.2199 | 1996359.0 |
| 2024-03-19 15:00:00 | AAPL | Stock | 176.21 | 176.43 | 176.0 | 176.34 | 1968184.0 |
| 2024-03-19 15:30:00 | AAPL | Stock | 176.335 | 176.54 | 175.79 | 176.08 | 5057900.0 |
| 2024-03-19 16:00:00 | AAPL | Stock | 176.31 | 176.31 | 175.59 | 175.64 | 9431867.0 |
| 2024-03-19 16:30:00 | AAPL | Stock | 175.64 | 176.08 | 175.64 | 175.75 | 97465.0 |
| 2024-03-19 17:00:00 | AAPL | Stock | 175.76 | 175.8 | 175.67 | 175.72 | 12745.0 |
| 2024-03-19 17:30:00 | AAPL | Stock | 175.71 | 176.08 | 175.6501 | 175.72 | 51445.0 |
| 2024-03-19 18:00:00 | AAPL | Stock | 175.72 | 175.87 | 175.71 | 175.87 | 8372.0 |
| 2024-03-19 18:30:00 | AAPL | Stock | 175.81 | 175.84 | 175.6 | 175.6 | 19875.0 |
| 2024-03-19 19:00:00 | AAPL | Stock | 175.78 | 175.78 | 175.4 | 175.5 | 23324.0 |
| 2024-03-19 19:30:00 | AAPL | Stock | 175.55 | 175.65 | 175.5 | 175.65 | 16342.0 |
| 2024-03-19 04:00:00 | MSFT | Stock | 416.59 | 416.89 | 416.28 | 416.71 | 1076.0 |
| 2024-03-19 04:30:00 | MSFT | Stock | 416.88 | 417.54 | 416.8 | 417.54 | 2554.0 |
| 2024-03-19 05:00:00 | MSFT | Stock | 417.49 | 417.58 | 416.58 | 416.86 | 1239.0 |
| 2024-03-19 05:30:00 | MSFT | Stock | 416.69 | 416.69 | 416.44 | 416.45 | 1426.0 |
| 2024-03-19 06:00:00 | MSFT | Stock | 416.35 | 416.59 | 416.35 | 416.59 | 216.0 |
| 2024-03-19 06:30:00 | MSFT | Stock | 416.7 | 417.6 | 416.69 | 416.69 | 2879.0 |
| 2024-03-19 07:00:00 | MSFT | Stock | 416.7 | 416.7 | 415.35 | 415.45 | 9521.0 |
| 2024-03-19 07:30:00 | MSFT | Stock | 415.44 | 415.44 | 415.1 | 415.31 | 4354.0 |
| 2024-03-19 08:00:00 | MSFT | Stock | 416.18 | 416.68 | 414.15 | 414.15 | 18299.0 |
| 2024-03-19 08:30:00 | MSFT | Stock | 414.77 | 415.2 | 414.4017 | 414.7509 | 14146.0 |
| 2024-03-19 09:00:00 | MSFT | Stock | 414.75 | 417.96 | 414.37 | 417.96 | 34221.0 |
| 2024-03-19 09:30:00 | MSFT | Stock | 417.96 | 419.22 | 415.55 | 418.58 | 1457430.0 |
| 2024-03-19 10:00:00 | MSFT | Stock | 418.55 | 419.74 | 418.14 | 418.78 | 833309.0 |
| 2024-03-19 10:30:00 | MSFT | Stock | 418.71 | 420.6399 | 418.6223 | 419.97 | 756738.0 |
| 2024-03-19 11:00:00 | MSFT | Stock | 419.92 | 421.305 | 419.86 | 421.07 | 603485.0 |
| 2024-03-19 11:30:00 | MSFT | Stock | 421.1 | 421.6656 | 420.2847 | 420.925 | 611036.0 |
| 2024-03-19 12:00:00 | MSFT | Stock | 420.9154 | 421.4 | 420.46 | 421.19 | 631312.0 |
| 2024-03-19 12:30:00 | MSFT | Stock | 421.2 | 421.6 | 420.46 | 420.605 | 629183.0 |
> showing 50 of 100,075 rows — these rows as CSV