PREVIEW / stock_30min / 2005-07-15
file: by_date/stock_30min/2005/2005-07-15.parquet size: 819 KB rows: 44,639 symbols: 2,018
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 |
|---|---|---|---|---|---|---|---|
| 2005-07-15 04:30:00 | AAPL | Stock | 1.4607 | 1.4607 | 1.4607 | 1.4607 | 22400.0 |
| 2005-07-15 08:00:00 | AAPL | Stock | 1.45 | 1.4514 | 1.4446 | 1.4464 | 792848.0 |
| 2005-07-15 08:30:00 | AAPL | Stock | 1.4482 | 1.4489 | 1.445 | 1.4461 | 372400.0 |
| 2005-07-15 09:00:00 | AAPL | Stock | 1.4461 | 1.4639 | 1.445 | 1.4639 | 4773132.0 |
| 2005-07-15 09:30:00 | AAPL | Stock | 1.4632 | 1.4643 | 1.445 | 1.45 | 123878328.0 |
| 2005-07-15 10:00:00 | AAPL | Stock | 1.45 | 1.4582 | 1.4461 | 1.4521 | 53421592.0 |
| 2005-07-15 10:30:00 | AAPL | Stock | 1.4525 | 1.4643 | 1.4507 | 1.4611 | 49938364.0 |
| 2005-07-15 11:00:00 | AAPL | Stock | 1.4611 | 1.4786 | 1.4607 | 1.4775 | 93664760.0 |
| 2005-07-15 11:30:00 | AAPL | Stock | 1.4771 | 1.4836 | 1.4739 | 1.4814 | 63738332.0 |
| 2005-07-15 12:00:00 | AAPL | Stock | 1.4814 | 1.4829 | 1.475 | 1.4811 | 49078876.0 |
| 2005-07-15 12:30:00 | AAPL | Stock | 1.4814 | 1.4821 | 1.4775 | 1.4782 | 22537592.0 |
| 2005-07-15 13:00:00 | AAPL | Stock | 1.4786 | 1.4814 | 1.4775 | 1.4775 | 17265472.0 |
| 2005-07-15 13:30:00 | AAPL | Stock | 1.4775 | 1.4796 | 1.4761 | 1.4789 | 17639916.0 |
| 2005-07-15 14:00:00 | AAPL | Stock | 1.4793 | 1.4793 | 1.4746 | 1.4764 | 26937764.0 |
| 2005-07-15 14:30:00 | AAPL | Stock | 1.4764 | 1.4825 | 1.4754 | 1.4814 | 39374524.0 |
| 2005-07-15 15:00:00 | AAPL | Stock | 1.4818 | 1.4821 | 1.4768 | 1.4807 | 35136612.0 |
| 2005-07-15 15:30:00 | AAPL | Stock | 1.4807 | 1.4846 | 1.4738 | 1.4843 | 75895988.0 |
| 2005-07-15 16:00:00 | AAPL | Stock | 1.4846 | 1.4886 | 1.4807 | 1.4857 | 4326084.0 |
| 2005-07-15 16:30:00 | AAPL | Stock | 1.4861 | 1.4911 | 1.4857 | 1.49 | 467040.0 |
| 2005-07-15 17:00:00 | AAPL | Stock | 1.4893 | 1.49 | 1.4857 | 1.4857 | 118160.0 |
| 2005-07-15 17:30:00 | AAPL | Stock | 1.4875 | 1.4893 | 1.4857 | 1.4857 | 133000.0 |
| 2005-07-15 18:00:00 | AAPL | Stock | 1.4857 | 1.4911 | 1.485 | 1.4857 | 182756.0 |
| 2005-07-15 08:00:00 | MSFT | Stock | 25.94 | 25.95 | 25.88 | 25.93 | 29982.0 |
| 2005-07-15 08:30:00 | MSFT | Stock | 25.92 | 25.93 | 25.9 | 25.92 | 59754.0 |
| 2005-07-15 09:00:00 | MSFT | Stock | 25.93 | 26.07 | 25.92 | 26.04 | 431629.0 |
| 2005-07-15 09:30:00 | MSFT | Stock | 26.04 | 26.1 | 25.95 | 26.03 | 11322951.0 |
| 2005-07-15 10:00:00 | MSFT | Stock | 26.03 | 26.05 | 25.9 | 25.92 | 4798160.0 |
| 2005-07-15 10:30:00 | MSFT | Stock | 25.922 | 25.95 | 25.77 | 25.82 | 6013721.0 |
| 2005-07-15 11:00:00 | MSFT | Stock | 25.83 | 25.89 | 25.8 | 25.87 | 3960124.0 |
| 2005-07-15 11:30:00 | MSFT | Stock | 25.87 | 25.89 | 25.84 | 25.852 | 2388864.0 |
| 2005-07-15 12:00:00 | MSFT | Stock | 25.852 | 25.86 | 25.8 | 25.82 | 2598413.0 |
| 2005-07-15 12:30:00 | MSFT | Stock | 25.82 | 25.83 | 25.75 | 25.77 | 2298044.0 |
| 2005-07-15 13:00:00 | MSFT | Stock | 25.77 | 25.85 | 25.77 | 25.828 | 2110099.0 |
| 2005-07-15 13:30:00 | MSFT | Stock | 25.82 | 26.022 | 25.75 | 25.8 | 2344137.0 |
| 2005-07-15 14:00:00 | MSFT | Stock | 25.8 | 25.85 | 25.78 | 25.82 | 2045257.0 |
| 2005-07-15 14:30:00 | MSFT | Stock | 25.82 | 25.93 | 25.8 | 25.91 | 4574298.0 |
| 2005-07-15 15:00:00 | MSFT | Stock | 25.918 | 25.92 | 25.82 | 25.82 | 2653386.0 |
| 2005-07-15 15:30:00 | MSFT | Stock | 25.82 | 25.885 | 25.76 | 25.77 | 6468855.0 |
| 2005-07-15 16:00:00 | MSFT | Stock | 25.76 | 25.79 | 25.74 | 25.78 | 692828.0 |
| 2005-07-15 16:30:00 | MSFT | Stock | 25.77 | 25.79 | 25.75 | 25.78 | 1900.0 |
| 2005-07-15 17:00:00 | MSFT | Stock | 25.75 | 25.75 | 25.75 | 25.75 | 5800.0 |
| 2005-07-15 17:30:00 | MSFT | Stock | 25.76 | 25.78 | 25.75 | 25.76 | 2460.0 |
| 2005-07-15 18:00:00 | MSFT | Stock | 25.76 | 25.77 | 25.75 | 25.77 | 2760.0 |
| 2005-07-15 08:30:00 | NVDA | Stock | 0.2262 | 0.2267 | 0.2262 | 0.2267 | 144000.0 |
| 2005-07-15 09:00:00 | NVDA | Stock | 0.2267 | 0.2271 | 0.2256 | 0.2258 | 7622640.0 |
| 2005-07-15 09:30:00 | NVDA | Stock | 0.2258 | 0.2265 | 0.2222 | 0.2242 | 268603440.0 |
| 2005-07-15 10:00:00 | NVDA | Stock | 0.2242 | 0.2247 | 0.2213 | 0.2233 | 168316320.0 |
| 2005-07-15 10:30:00 | NVDA | Stock | 0.2233 | 0.2234 | 0.2215 | 0.2222 | 50200200.0 |
| 2005-07-15 11:00:00 | NVDA | Stock | 0.2222 | 0.223 | 0.2217 | 0.2222 | 66355560.0 |
| 2005-07-15 11:30:00 | NVDA | Stock | 0.2222 | 0.2222 | 0.2202 | 0.2219 | 63814560.0 |
> showing 50 of 44,639 rows — these rows as CSV