PREVIEW / stock_30min / 2005-01-13
file: by_date/stock_30min/2005/2005-01-13.parquet size: 801 KB rows: 42,887 symbols: 1,906
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-01-13 08:00:00 | AAPL | Stock | 1.3182 | 1.3248 | 1.3036 | 1.3248 | 51204776.0 |
| 2005-01-13 08:30:00 | AAPL | Stock | 1.3239 | 1.3304 | 1.3202 | 1.33 | 73149944.0 |
| 2005-01-13 09:00:00 | AAPL | Stock | 1.33 | 1.332 | 1.3036 | 1.3155 | 71394400.0 |
| 2005-01-13 09:30:00 | AAPL | Stock | 1.3152 | 1.3289 | 1.2879 | 1.2884 | 752830568.0 |
| 2005-01-13 10:00:00 | AAPL | Stock | 1.2886 | 1.2995 | 1.2679 | 1.2932 | 462756616.0 |
| 2005-01-13 10:30:00 | AAPL | Stock | 1.2932 | 1.3127 | 1.2809 | 1.2827 | 243563264.0 |
| 2005-01-13 11:00:00 | AAPL | Stock | 1.2827 | 1.2868 | 1.2727 | 1.273 | 133353192.0 |
| 2005-01-13 11:30:00 | AAPL | Stock | 1.2732 | 1.2825 | 1.2614 | 1.2677 | 224260176.0 |
| 2005-01-13 12:00:00 | AAPL | Stock | 1.2677 | 1.2816 | 1.2657 | 1.277 | 118520864.0 |
| 2005-01-13 12:30:00 | AAPL | Stock | 1.277 | 1.2871 | 1.2764 | 1.2818 | 93087008.0 |
| 2005-01-13 13:00:00 | AAPL | Stock | 1.2816 | 1.2884 | 1.2727 | 1.2738 | 96162808.0 |
| 2005-01-13 13:30:00 | AAPL | Stock | 1.2736 | 1.2782 | 1.27 | 1.2775 | 94727192.0 |
| 2005-01-13 14:00:00 | AAPL | Stock | 1.2776 | 1.2777 | 1.267 | 1.2671 | 88712568.0 |
| 2005-01-13 14:30:00 | AAPL | Stock | 1.2671 | 1.2709 | 1.2629 | 1.265 | 99431864.0 |
| 2005-01-13 15:00:00 | AAPL | Stock | 1.2648 | 1.2732 | 1.253 | 1.2546 | 204297912.0 |
| 2005-01-13 15:30:00 | AAPL | Stock | 1.2546 | 1.2605 | 1.2452 | 1.247 | 331759904.0 |
| 2005-01-13 16:00:00 | AAPL | Stock | 1.247 | 1.248 | 1.2414 | 1.2436 | 11472160.0 |
| 2005-01-13 16:30:00 | AAPL | Stock | 1.2436 | 1.2464 | 1.2411 | 1.2425 | 2644600.0 |
| 2005-01-13 17:00:00 | AAPL | Stock | 1.2434 | 1.2456 | 1.2321 | 1.2384 | 4058824.0 |
| 2005-01-13 17:30:00 | AAPL | Stock | 1.237 | 1.2446 | 1.2359 | 1.2416 | 2173976.0 |
| 2005-01-13 18:00:00 | AAPL | Stock | 1.2416 | 1.2429 | 1.2416 | 1.2427 | 465136.0 |
| 2005-01-13 08:00:00 | MSFT | Stock | 26.8 | 26.8 | 26.73 | 26.74 | 10100.0 |
| 2005-01-13 08:30:00 | MSFT | Stock | 26.73 | 26.76 | 26.68 | 26.73 | 78698.0 |
| 2005-01-13 09:00:00 | MSFT | Stock | 26.72 | 26.75 | 26.68 | 26.71 | 103581.0 |
| 2005-01-13 09:30:00 | MSFT | Stock | 26.69 | 26.72 | 26.65 | 26.68 | 5982459.0 |
| 2005-01-13 10:00:00 | MSFT | Stock | 26.68 | 26.8 | 26.61 | 26.65 | 6713153.0 |
| 2005-01-13 10:30:00 | MSFT | Stock | 26.65 | 26.67 | 26.57 | 26.6 | 5891510.0 |
| 2005-01-13 11:00:00 | MSFT | Stock | 26.6 | 26.64 | 26.58 | 26.6 | 4929819.0 |
| 2005-01-13 11:30:00 | MSFT | Stock | 26.6 | 26.63 | 26.55 | 26.601 | 4744705.0 |
| 2005-01-13 12:00:00 | MSFT | Stock | 26.61 | 26.66 | 26.59 | 26.632 | 3847861.0 |
| 2005-01-13 12:30:00 | MSFT | Stock | 26.63 | 26.66 | 26.61 | 26.61 | 1804388.0 |
| 2005-01-13 13:00:00 | MSFT | Stock | 26.61 | 26.66 | 26.57 | 26.57 | 3396090.0 |
| 2005-01-13 13:30:00 | MSFT | Stock | 26.57 | 26.61 | 26.549 | 26.55 | 5265959.0 |
| 2005-01-13 14:00:00 | MSFT | Stock | 26.55 | 26.569 | 26.5 | 26.55 | 5466103.0 |
| 2005-01-13 14:30:00 | MSFT | Stock | 26.55 | 26.56 | 26.46 | 26.48 | 7495405.0 |
| 2005-01-13 15:00:00 | MSFT | Stock | 26.47 | 26.49 | 26.33 | 26.332 | 10132592.0 |
| 2005-01-13 15:30:00 | MSFT | Stock | 26.33 | 26.34 | 26.16 | 26.27 | 18745640.0 |
| 2005-01-13 16:00:00 | MSFT | Stock | 26.27 | 26.31 | 26.26 | 26.28 | 2669789.0 |
| 2005-01-13 16:30:00 | MSFT | Stock | 26.28 | 26.32 | 26.27 | 26.31 | 230078.0 |
| 2005-01-13 17:00:00 | MSFT | Stock | 26.29 | 26.3 | 26.27 | 26.28 | 72200.0 |
| 2005-01-13 17:30:00 | MSFT | Stock | 26.3 | 26.31 | 26.3 | 26.3 | 11940.0 |
| 2005-01-13 18:00:00 | MSFT | Stock | 26.3 | 26.31 | 26.3 | 26.31 | 1816.0 |
| 2005-01-13 08:00:00 | NVDA | Stock | 0.1762 | 0.1768 | 0.1762 | 0.1768 | 660000.0 |
| 2005-01-13 08:30:00 | NVDA | Stock | 0.1768 | 0.1775 | 0.1768 | 0.1775 | 288000.0 |
| 2005-01-13 09:00:00 | NVDA | Stock | 0.1772 | 0.1775 | 0.1761 | 0.1761 | 3252720.0 |
| 2005-01-13 09:30:00 | NVDA | Stock | 0.1772 | 0.1772 | 0.1733 | 0.1752 | 100134120.0 |
| 2005-01-13 10:00:00 | NVDA | Stock | 0.1751 | 0.1784 | 0.1749 | 0.1781 | 58307040.0 |
| 2005-01-13 10:30:00 | NVDA | Stock | 0.1781 | 0.1792 | 0.1778 | 0.1783 | 68686200.0 |
| 2005-01-13 11:00:00 | NVDA | Stock | 0.1784 | 0.1798 | 0.1784 | 0.1791 | 34553400.0 |
| 2005-01-13 11:30:00 | NVDA | Stock | 0.1792 | 0.1795 | 0.177 | 0.1787 | 71829360.0 |
> showing 50 of 42,887 rows — these rows as CSV