PREVIEW / stock_30min / 2006-07-11
file: by_date/stock_30min/2006/2006-07-11.parquet size: 913 KB rows: 49,976 symbols: 2,314
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 |
|---|---|---|---|---|---|---|---|
| 2006-07-11 06:30:00 | AAPL | Stock | 1.9643 | 1.9714 | 1.9643 | 1.9714 | 14000.0 |
| 2006-07-11 07:00:00 | AAPL | Stock | 1.9732 | 1.9732 | 1.9643 | 1.9643 | 28000.0 |
| 2006-07-11 07:30:00 | AAPL | Stock | 1.9693 | 1.9718 | 1.9693 | 1.9718 | 22400.0 |
| 2006-07-11 08:00:00 | AAPL | Stock | 1.9643 | 1.975 | 1.9614 | 1.9682 | 1627500.0 |
| 2006-07-11 08:30:00 | AAPL | Stock | 1.9693 | 1.9714 | 1.965 | 1.9707 | 546588.0 |
| 2006-07-11 09:00:00 | AAPL | Stock | 1.9714 | 1.9732 | 1.9671 | 1.9679 | 1076824.0 |
| 2006-07-11 09:30:00 | AAPL | Stock | 1.9682 | 1.9875 | 1.9489 | 1.9757 | 99924580.0 |
| 2006-07-11 10:00:00 | AAPL | Stock | 1.9757 | 1.9775 | 1.9589 | 1.9671 | 77529088.0 |
| 2006-07-11 10:30:00 | AAPL | Stock | 1.9671 | 1.9704 | 1.9543 | 1.9618 | 53090268.0 |
| 2006-07-11 11:00:00 | AAPL | Stock | 1.9614 | 1.9675 | 1.9575 | 1.9611 | 46574360.0 |
| 2006-07-11 11:30:00 | AAPL | Stock | 1.9607 | 1.9707 | 1.96 | 1.9643 | 35838880.0 |
| 2006-07-11 12:00:00 | AAPL | Stock | 1.9643 | 1.9682 | 1.9589 | 1.967 | 34513696.0 |
| 2006-07-11 12:30:00 | AAPL | Stock | 1.9668 | 1.9668 | 1.9546 | 1.9546 | 31651760.0 |
| 2006-07-11 13:00:00 | AAPL | Stock | 1.9547 | 1.9561 | 1.9482 | 1.9496 | 38240300.0 |
| 2006-07-11 13:30:00 | AAPL | Stock | 1.9496 | 1.9782 | 1.9475 | 1.9714 | 57017576.0 |
| 2006-07-11 14:00:00 | AAPL | Stock | 1.9714 | 1.9911 | 1.9693 | 1.9829 | 85625428.0 |
| 2006-07-11 14:30:00 | AAPL | Stock | 1.9818 | 1.9818 | 1.9607 | 1.9643 | 74857860.0 |
| 2006-07-11 15:00:00 | AAPL | Stock | 1.9643 | 1.9946 | 1.9596 | 1.9875 | 88106704.0 |
| 2006-07-11 15:30:00 | AAPL | Stock | 1.9875 | 1.9996 | 1.9829 | 1.9868 | 82087152.0 |
| 2006-07-11 16:00:00 | AAPL | Stock | 1.9857 | 1.9875 | 1.9708 | 1.9804 | 1502452.0 |
| 2006-07-11 16:30:00 | AAPL | Stock | 1.9821 | 1.9839 | 1.9705 | 1.9821 | 534520.0 |
| 2006-07-11 17:00:00 | AAPL | Stock | 1.9821 | 1.9857 | 1.9821 | 1.9839 | 252000.0 |
| 2006-07-11 17:30:00 | AAPL | Stock | 1.9839 | 1.9857 | 1.9839 | 1.9857 | 90160.0 |
| 2006-07-11 18:00:00 | AAPL | Stock | 1.9857 | 1.9868 | 1.9821 | 1.9832 | 218372.0 |
| 2006-07-11 07:00:00 | MSFT | Stock | 23.38 | 23.38 | 23.38 | 23.38 | 1000.0 |
| 2006-07-11 07:30:00 | MSFT | Stock | 23.49 | 23.49 | 23.49 | 23.49 | 100.0 |
| 2006-07-11 08:00:00 | MSFT | Stock | 23.48 | 23.5 | 23.48 | 23.5 | 6200.0 |
| 2006-07-11 08:30:00 | MSFT | Stock | 23.48 | 23.48 | 23.42 | 23.45 | 563700.0 |
| 2006-07-11 09:00:00 | MSFT | Stock | 23.48 | 23.49 | 23.34 | 23.35 | 112769.0 |
| 2006-07-11 09:30:00 | MSFT | Stock | 23.37 | 23.37 | 23.16 | 23.16 | 8743180.0 |
| 2006-07-11 10:00:00 | MSFT | Stock | 23.17 | 23.365 | 23.04 | 23.1 | 8664621.0 |
| 2006-07-11 10:30:00 | MSFT | Stock | 23.1 | 23.14 | 23.05 | 23.12 | 5082474.0 |
| 2006-07-11 11:00:00 | MSFT | Stock | 23.11 | 23.16 | 23.11 | 23.14 | 2744047.0 |
| 2006-07-11 11:30:00 | MSFT | Stock | 23.13 | 23.16 | 23.1 | 23.12 | 2574369.0 |
| 2006-07-11 12:00:00 | MSFT | Stock | 23.123 | 23.35 | 23.09 | 23.11 | 3342770.0 |
| 2006-07-11 12:30:00 | MSFT | Stock | 23.11 | 23.13 | 22.96 | 22.97 | 4612998.0 |
| 2006-07-11 13:00:00 | MSFT | Stock | 22.97 | 22.99 | 22.8 | 22.88 | 6614403.0 |
| 2006-07-11 13:30:00 | MSFT | Stock | 22.89 | 22.96 | 22.74 | 22.94 | 9543765.0 |
| 2006-07-11 14:00:00 | MSFT | Stock | 22.94 | 23.07 | 22.89 | 23.02 | 6376781.0 |
| 2006-07-11 14:30:00 | MSFT | Stock | 23.02 | 23.025 | 22.95 | 23.0 | 4529080.0 |
| 2006-07-11 15:00:00 | MSFT | Stock | 23.01 | 23.15 | 23.0 | 23.13 | 8120160.0 |
| 2006-07-11 15:30:00 | MSFT | Stock | 23.14 | 23.14 | 23.05 | 23.09 | 7564400.0 |
| 2006-07-11 16:00:00 | MSFT | Stock | 23.09 | 23.11 | 22.94 | 23.1 | 332998.0 |
| 2006-07-11 16:30:00 | MSFT | Stock | 23.09 | 23.11 | 23.09 | 23.11 | 5334.0 |
| 2006-07-11 17:00:00 | MSFT | Stock | 23.11 | 23.11 | 23.1 | 23.11 | 2700.0 |
| 2006-07-11 17:30:00 | MSFT | Stock | 23.11 | 23.12 | 23.11 | 23.12 | 2800.0 |
| 2006-07-11 18:00:00 | MSFT | Stock | 23.1 | 23.1 | 23.1 | 23.1 | 329.0 |
| 2006-07-11 08:00:00 | NVDA | Stock | 0.3083 | 0.3083 | 0.3083 | 0.3083 | 22620.0 |
| 2006-07-11 09:00:00 | NVDA | Stock | 0.3078 | 0.3078 | 0.3067 | 0.3067 | 42000.0 |
| 2006-07-11 09:30:00 | NVDA | Stock | 0.3078 | 0.3138 | 0.3033 | 0.31 | 65339940.0 |
> showing 50 of 49,976 rows — these rows as CSV