PREVIEW / stock_30min / 2005-07-14
file: by_date/stock_30min/2005/2005-07-14.parquet size: 834 KB rows: 45,454 symbols: 2,026
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-14 07:00:00 | AAPL | Stock | 1.425 | 1.4275 | 1.425 | 1.4264 | 114800.0 |
| 2005-07-14 07:30:00 | AAPL | Stock | 1.4254 | 1.4521 | 1.4254 | 1.4446 | 4279044.0 |
| 2005-07-14 08:00:00 | AAPL | Stock | 1.4429 | 1.4464 | 1.4375 | 1.4432 | 35487424.0 |
| 2005-07-14 08:30:00 | AAPL | Stock | 1.4436 | 1.4593 | 1.4429 | 1.4554 | 39015424.0 |
| 2005-07-14 09:00:00 | AAPL | Stock | 1.4554 | 1.4643 | 1.4554 | 1.4564 | 45470236.0 |
| 2005-07-14 09:30:00 | AAPL | Stock | 1.4568 | 1.5004 | 1.4514 | 1.48 | 591885504.0 |
| 2005-07-14 10:00:00 | AAPL | Stock | 1.48 | 1.4875 | 1.4661 | 1.4764 | 264464368.0 |
| 2005-07-14 10:30:00 | AAPL | Stock | 1.4764 | 1.4871 | 1.4721 | 1.4739 | 136669904.0 |
| 2005-07-14 11:00:00 | AAPL | Stock | 1.4739 | 1.4782 | 1.4679 | 1.4754 | 81307660.0 |
| 2005-07-14 11:30:00 | AAPL | Stock | 1.4757 | 1.4829 | 1.4732 | 1.4768 | 120833608.0 |
| 2005-07-14 12:00:00 | AAPL | Stock | 1.4768 | 1.4829 | 1.4739 | 1.4782 | 55229468.0 |
| 2005-07-14 12:30:00 | AAPL | Stock | 1.4779 | 1.4839 | 1.4779 | 1.4807 | 44273516.0 |
| 2005-07-14 13:00:00 | AAPL | Stock | 1.4807 | 1.4857 | 1.4768 | 1.4804 | 74782456.0 |
| 2005-07-14 13:30:00 | AAPL | Stock | 1.48 | 1.4804 | 1.4611 | 1.4689 | 117281108.0 |
| 2005-07-14 14:00:00 | AAPL | Stock | 1.4686 | 1.4707 | 1.4443 | 1.4461 | 136802708.0 |
| 2005-07-14 14:30:00 | AAPL | Stock | 1.4461 | 1.4607 | 1.4368 | 1.4389 | 115607548.0 |
| 2005-07-14 15:00:00 | AAPL | Stock | 1.4386 | 1.4582 | 1.4386 | 1.4571 | 104093696.0 |
| 2005-07-14 15:30:00 | AAPL | Stock | 1.4575 | 1.4589 | 1.4521 | 1.4554 | 109523456.0 |
| 2005-07-14 16:00:00 | AAPL | Stock | 1.4557 | 1.4571 | 1.4521 | 1.4554 | 8338540.0 |
| 2005-07-14 16:30:00 | AAPL | Stock | 1.4554 | 1.4693 | 1.4521 | 1.4521 | 933296.0 |
| 2005-07-14 17:00:00 | AAPL | Stock | 1.4521 | 1.4546 | 1.4518 | 1.4518 | 577024.0 |
| 2005-07-14 17:30:00 | AAPL | Stock | 1.4529 | 1.4529 | 1.4511 | 1.4518 | 219800.0 |
| 2005-07-14 18:00:00 | AAPL | Stock | 1.4518 | 1.4518 | 1.4514 | 1.4518 | 128128.0 |
| 2005-07-14 08:00:00 | MSFT | Stock | 25.75 | 25.75 | 25.68 | 25.74 | 8035.0 |
| 2005-07-14 08:30:00 | MSFT | Stock | 25.74 | 25.8 | 25.74 | 25.8 | 57172.0 |
| 2005-07-14 09:00:00 | MSFT | Stock | 25.8 | 25.83 | 25.78 | 25.8 | 74926.0 |
| 2005-07-14 09:30:00 | MSFT | Stock | 25.79 | 25.9 | 25.79 | 25.84 | 7422439.0 |
| 2005-07-14 10:00:00 | MSFT | Stock | 25.83 | 25.95 | 25.83 | 25.93 | 5948688.0 |
| 2005-07-14 10:30:00 | MSFT | Stock | 25.94 | 25.997 | 25.864 | 25.95 | 5984857.0 |
| 2005-07-14 11:00:00 | MSFT | Stock | 25.95 | 25.97 | 25.889 | 25.91 | 3005243.0 |
| 2005-07-14 11:30:00 | MSFT | Stock | 25.91 | 25.99 | 25.87 | 25.98 | 3636983.0 |
| 2005-07-14 12:00:00 | MSFT | Stock | 25.97 | 26.0 | 25.95 | 25.96 | 4579718.0 |
| 2005-07-14 12:30:00 | MSFT | Stock | 25.96 | 26.0 | 25.95 | 25.97 | 4025927.0 |
| 2005-07-14 13:00:00 | MSFT | Stock | 25.98 | 26.0 | 25.96 | 25.98 | 4328049.0 |
| 2005-07-14 13:30:00 | MSFT | Stock | 25.98 | 26.01 | 25.95 | 25.978 | 6137376.0 |
| 2005-07-14 14:00:00 | MSFT | Stock | 25.98 | 26.0 | 25.94 | 25.95 | 3676729.0 |
| 2005-07-14 14:30:00 | MSFT | Stock | 25.96 | 25.99 | 25.93 | 25.989 | 2894611.0 |
| 2005-07-14 15:00:00 | MSFT | Stock | 25.982 | 26.1 | 25.95 | 25.99 | 6609092.0 |
| 2005-07-14 15:30:00 | MSFT | Stock | 25.99 | 26.011 | 25.93 | 25.98 | 9137618.0 |
| 2005-07-14 16:00:00 | MSFT | Stock | 25.98 | 25.99 | 25.91 | 25.96 | 575025.0 |
| 2005-07-14 16:30:00 | MSFT | Stock | 25.95 | 25.97 | 25.934 | 25.97 | 193872.0 |
| 2005-07-14 17:00:00 | MSFT | Stock | 25.96 | 25.97 | 25.96 | 25.96 | 5800.0 |
| 2005-07-14 17:30:00 | MSFT | Stock | 26.0 | 26.0 | 25.95 | 25.97 | 4200.0 |
| 2005-07-14 18:00:00 | MSFT | Stock | 25.97 | 25.97 | 25.94 | 25.94 | 8900.0 |
| 2005-07-14 08:00:00 | NVDA | Stock | 0.2379 | 0.2384 | 0.2354 | 0.2383 | 360000.0 |
| 2005-07-14 08:30:00 | NVDA | Stock | 0.2383 | 0.2396 | 0.2379 | 0.2395 | 504000.0 |
| 2005-07-14 09:00:00 | NVDA | Stock | 0.2387 | 0.2402 | 0.2383 | 0.2396 | 1539000.0 |
| 2005-07-14 09:30:00 | NVDA | Stock | 0.2395 | 0.2442 | 0.2383 | 0.2385 | 150905400.0 |
| 2005-07-14 10:00:00 | NVDA | Stock | 0.2384 | 0.2393 | 0.2335 | 0.2365 | 204940560.0 |
| 2005-07-14 10:30:00 | NVDA | Stock | 0.2365 | 0.2367 | 0.235 | 0.2366 | 71071320.0 |
> showing 50 of 45,454 rows — these rows as CSV