PREVIEW / stock_30min / 2005-10-20
file: by_date/stock_30min/2005/2005-10-20.parquet size: 855 KB rows: 45,499 symbols: 2,091
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-10-20 08:00:00 | AAPL | Stock | 1.9464 | 1.9596 | 1.9464 | 1.9536 | 243880.0 |
| 2005-10-20 08:30:00 | AAPL | Stock | 1.9532 | 1.9557 | 1.9507 | 1.9554 | 763700.0 |
| 2005-10-20 09:00:00 | AAPL | Stock | 1.9557 | 1.9557 | 1.9454 | 1.9454 | 1997884.0 |
| 2005-10-20 09:30:00 | AAPL | Stock | 1.9454 | 1.9986 | 1.9411 | 1.9768 | 240570512.0 |
| 2005-10-20 10:00:00 | AAPL | Stock | 1.9768 | 1.9775 | 1.9496 | 1.9686 | 112902804.0 |
| 2005-10-20 10:30:00 | AAPL | Stock | 1.9686 | 1.9957 | 1.9682 | 1.9889 | 135120860.0 |
| 2005-10-20 11:00:00 | AAPL | Stock | 1.9889 | 1.9911 | 1.9721 | 1.9864 | 68904416.0 |
| 2005-10-20 11:30:00 | AAPL | Stock | 1.9864 | 1.9939 | 1.9839 | 1.9925 | 56046452.0 |
| 2005-10-20 12:00:00 | AAPL | Stock | 1.9925 | 2.0086 | 1.9875 | 2.0071 | 112787668.0 |
| 2005-10-20 12:30:00 | AAPL | Stock | 2.0071 | 2.0136 | 1.9861 | 1.9968 | 80758440.0 |
| 2005-10-20 13:00:00 | AAPL | Stock | 1.9964 | 2.0089 | 1.9943 | 2.0011 | 47346740.0 |
| 2005-10-20 13:30:00 | AAPL | Stock | 2.0011 | 2.0089 | 1.9993 | 2.0068 | 44808008.0 |
| 2005-10-20 14:00:00 | AAPL | Stock | 2.0068 | 2.0179 | 2.0004 | 2.0071 | 100611672.0 |
| 2005-10-20 14:30:00 | AAPL | Stock | 2.0071 | 2.01 | 1.9943 | 1.9998 | 65599324.0 |
| 2005-10-20 15:00:00 | AAPL | Stock | 1.9996 | 2.0082 | 1.9764 | 1.9789 | 120830164.0 |
| 2005-10-20 15:30:00 | AAPL | Stock | 1.9789 | 2.0061 | 1.9789 | 2.0029 | 143278408.0 |
| 2005-10-20 16:00:00 | AAPL | Stock | 2.0054 | 2.0229 | 1.9654 | 2.0143 | 5433260.0 |
| 2005-10-20 16:30:00 | AAPL | Stock | 2.015 | 2.0179 | 2.0111 | 2.0161 | 903700.0 |
| 2005-10-20 17:00:00 | AAPL | Stock | 2.0179 | 2.0204 | 2.0054 | 2.0204 | 2720928.0 |
| 2005-10-20 17:30:00 | AAPL | Stock | 2.0207 | 2.0271 | 2.0207 | 2.025 | 645736.0 |
| 2005-10-20 18:00:00 | AAPL | Stock | 2.025 | 2.0289 | 2.025 | 2.025 | 589960.0 |
| 2005-10-20 08:00:00 | MSFT | Stock | 25.1 | 25.1 | 24.98 | 25.08 | 11190.0 |
| 2005-10-20 08:30:00 | MSFT | Stock | 25.09 | 25.1 | 25.03 | 25.03 | 15900.0 |
| 2005-10-20 09:00:00 | MSFT | Stock | 25.03 | 25.06 | 25.01 | 25.05 | 116043.0 |
| 2005-10-20 09:30:00 | MSFT | Stock | 25.05 | 25.13 | 24.97 | 25.03 | 5097332.0 |
| 2005-10-20 10:00:00 | MSFT | Stock | 25.03 | 25.08 | 24.99 | 25.02 | 3586567.0 |
| 2005-10-20 10:30:00 | MSFT | Stock | 25.01 | 25.09 | 24.93 | 24.95 | 4977725.0 |
| 2005-10-20 11:00:00 | MSFT | Stock | 24.95 | 24.99 | 24.93 | 24.97 | 3316601.0 |
| 2005-10-20 11:30:00 | MSFT | Stock | 24.98 | 25.0 | 24.96 | 24.97 | 3450488.0 |
| 2005-10-20 12:00:00 | MSFT | Stock | 24.96 | 24.99 | 24.92 | 24.968 | 3162108.0 |
| 2005-10-20 12:30:00 | MSFT | Stock | 24.96 | 25.04 | 24.92 | 24.93 | 2748250.0 |
| 2005-10-20 13:00:00 | MSFT | Stock | 24.94 | 24.96 | 24.87 | 24.9 | 3093164.0 |
| 2005-10-20 13:30:00 | MSFT | Stock | 24.9 | 24.94 | 24.88 | 24.91 | 2966209.0 |
| 2005-10-20 14:00:00 | MSFT | Stock | 24.91 | 24.91 | 24.81 | 24.88 | 4270521.0 |
| 2005-10-20 14:30:00 | MSFT | Stock | 24.87 | 24.9 | 24.85 | 24.88 | 2374267.0 |
| 2005-10-20 15:00:00 | MSFT | Stock | 24.88 | 24.91 | 24.74 | 24.8 | 6303899.0 |
| 2005-10-20 15:30:00 | MSFT | Stock | 24.8 | 24.9 | 24.78 | 24.79 | 9046481.0 |
| 2005-10-20 16:00:00 | MSFT | Stock | 24.79 | 24.99 | 24.78 | 24.84 | 302651.0 |
| 2005-10-20 16:30:00 | MSFT | Stock | 24.83 | 24.84 | 24.78 | 24.8 | 190962.0 |
| 2005-10-20 17:00:00 | MSFT | Stock | 24.79 | 25.07 | 24.79 | 24.8 | 863796.0 |
| 2005-10-20 17:30:00 | MSFT | Stock | 24.79 | 24.8 | 24.79 | 24.8 | 5090.0 |
| 2005-10-20 18:00:00 | MSFT | Stock | 24.82 | 24.82 | 24.81 | 24.81 | 15400.0 |
| 2005-10-20 09:00:00 | NVDA | Stock | 0.2632 | 0.2632 | 0.2632 | 0.2632 | 61920.0 |
| 2005-10-20 09:30:00 | NVDA | Stock | 0.2632 | 0.2685 | 0.2621 | 0.2654 | 39870600.0 |
| 2005-10-20 10:00:00 | NVDA | Stock | 0.2652 | 0.2677 | 0.2639 | 0.2669 | 32089680.0 |
| 2005-10-20 10:30:00 | NVDA | Stock | 0.2669 | 0.2687 | 0.2668 | 0.2676 | 34548120.0 |
| 2005-10-20 11:00:00 | NVDA | Stock | 0.2677 | 0.2678 | 0.2662 | 0.2677 | 21261240.0 |
| 2005-10-20 11:30:00 | NVDA | Stock | 0.2677 | 0.2683 | 0.2672 | 0.2681 | 12627480.0 |
| 2005-10-20 12:00:00 | NVDA | Stock | 0.2681 | 0.2687 | 0.2669 | 0.2685 | 19142040.0 |
| 2005-10-20 12:30:00 | NVDA | Stock | 0.2685 | 0.2685 | 0.2676 | 0.2684 | 9276840.0 |
> showing 50 of 45,499 rows — these rows as CSV