PREVIEW / stock_30min / 2006-03-10
file: by_date/stock_30min/2006/2006-03-10.parquet size: 873 KB rows: 47,450 symbols: 2,193
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-03-10 05:30:00 | AAPL | Stock | 2.2814 | 2.2814 | 2.2814 | 2.2814 | 2800.0 |
| 2006-03-10 07:30:00 | AAPL | Stock | 2.2714 | 2.2714 | 2.2714 | 2.2714 | 2800.0 |
| 2006-03-10 08:00:00 | AAPL | Stock | 2.2821 | 2.2893 | 2.2721 | 2.2857 | 894348.0 |
| 2006-03-10 08:30:00 | AAPL | Stock | 2.285 | 2.3018 | 2.2821 | 2.2914 | 3545836.0 |
| 2006-03-10 09:00:00 | AAPL | Stock | 2.2925 | 2.2982 | 2.2857 | 2.2875 | 1813924.0 |
| 2006-03-10 09:30:00 | AAPL | Stock | 2.2875 | 2.3007 | 2.2525 | 2.2564 | 156805208.0 |
| 2006-03-10 10:00:00 | AAPL | Stock | 2.2579 | 2.2911 | 2.2332 | 2.2807 | 153466628.0 |
| 2006-03-10 10:30:00 | AAPL | Stock | 2.2807 | 2.3032 | 2.2696 | 2.2961 | 92703100.0 |
| 2006-03-10 11:00:00 | AAPL | Stock | 2.2961 | 2.2979 | 2.2779 | 2.285 | 60023880.0 |
| 2006-03-10 11:30:00 | AAPL | Stock | 2.2843 | 2.2861 | 2.2586 | 2.2621 | 62315400.0 |
| 2006-03-10 12:00:00 | AAPL | Stock | 2.2625 | 2.2679 | 2.25 | 2.2554 | 62775216.0 |
| 2006-03-10 12:30:00 | AAPL | Stock | 2.255 | 2.2754 | 2.255 | 2.2639 | 47639844.0 |
| 2006-03-10 13:00:00 | AAPL | Stock | 2.2636 | 2.2721 | 2.2579 | 2.2629 | 32831932.0 |
| 2006-03-10 13:30:00 | AAPL | Stock | 2.2632 | 2.2704 | 2.2554 | 2.2625 | 39600456.0 |
| 2006-03-10 14:00:00 | AAPL | Stock | 2.2625 | 2.2789 | 2.2607 | 2.2614 | 42001680.0 |
| 2006-03-10 14:30:00 | AAPL | Stock | 2.2614 | 2.2625 | 2.24 | 2.2425 | 85210972.0 |
| 2006-03-10 15:00:00 | AAPL | Stock | 2.2429 | 2.2636 | 2.2304 | 2.2632 | 108433080.0 |
| 2006-03-10 15:30:00 | AAPL | Stock | 2.2632 | 2.27 | 2.2364 | 2.2568 | 82230848.0 |
| 2006-03-10 16:00:00 | AAPL | Stock | 2.2575 | 2.2607 | 2.2564 | 2.2607 | 2788212.0 |
| 2006-03-10 16:30:00 | AAPL | Stock | 2.2596 | 2.2607 | 2.2571 | 2.2575 | 272804.0 |
| 2006-03-10 17:00:00 | AAPL | Stock | 2.2575 | 2.26 | 2.2571 | 2.26 | 182000.0 |
| 2006-03-10 17:30:00 | AAPL | Stock | 2.2571 | 2.2589 | 2.2571 | 2.2571 | 104580.0 |
| 2006-03-10 18:00:00 | AAPL | Stock | 2.2575 | 2.2607 | 2.2571 | 2.2604 | 248108.0 |
| 2006-03-10 06:30:00 | MSFT | Stock | 27.03 | 27.03 | 27.03 | 27.03 | 1000.0 |
| 2006-03-10 07:30:00 | MSFT | Stock | 27.0 | 27.0 | 27.0 | 27.0 | 1000.0 |
| 2006-03-10 08:00:00 | MSFT | Stock | 27.0 | 27.0 | 26.96 | 27.0 | 2150.0 |
| 2006-03-10 08:30:00 | MSFT | Stock | 26.96 | 27.07 | 26.96 | 27.05 | 47822.0 |
| 2006-03-10 09:00:00 | MSFT | Stock | 27.05 | 27.14 | 27.0 | 27.06 | 173527.0 |
| 2006-03-10 09:30:00 | MSFT | Stock | 27.06 | 27.11 | 26.92 | 26.98 | 4325258.0 |
| 2006-03-10 10:00:00 | MSFT | Stock | 26.99 | 27.05 | 26.88 | 27.02 | 3796400.0 |
| 2006-03-10 10:30:00 | MSFT | Stock | 27.02 | 27.11 | 26.96 | 27.09 | 3146029.0 |
| 2006-03-10 11:00:00 | MSFT | Stock | 27.09 | 27.09 | 27.02 | 27.08 | 2302047.0 |
| 2006-03-10 11:30:00 | MSFT | Stock | 27.08 | 27.14 | 27.062 | 27.09 | 1972452.0 |
| 2006-03-10 12:00:00 | MSFT | Stock | 27.09 | 27.2 | 27.08 | 27.11 | 3997420.0 |
| 2006-03-10 12:30:00 | MSFT | Stock | 27.11 | 27.18 | 27.09 | 27.142 | 2034154.0 |
| 2006-03-10 13:00:00 | MSFT | Stock | 27.142 | 27.15 | 27.1 | 27.14 | 946558.0 |
| 2006-03-10 13:30:00 | MSFT | Stock | 27.13 | 27.17 | 27.08 | 27.151 | 2240064.0 |
| 2006-03-10 14:00:00 | MSFT | Stock | 27.15 | 27.22 | 27.15 | 27.181 | 1644339.0 |
| 2006-03-10 14:30:00 | MSFT | Stock | 27.18 | 27.22 | 27.13 | 27.15 | 2909775.0 |
| 2006-03-10 15:00:00 | MSFT | Stock | 27.14 | 27.18 | 27.12 | 27.15 | 2555069.0 |
| 2006-03-10 15:30:00 | MSFT | Stock | 27.15 | 27.21 | 27.12 | 27.15 | 6742118.0 |
| 2006-03-10 16:00:00 | MSFT | Stock | 27.16 | 27.2 | 27.16 | 27.17 | 264221.0 |
| 2006-03-10 16:30:00 | MSFT | Stock | 27.17 | 27.17 | 27.15 | 27.15 | 548.0 |
| 2006-03-10 17:00:00 | MSFT | Stock | 27.16 | 27.16 | 27.16 | 27.16 | 300.0 |
| 2006-03-10 17:30:00 | MSFT | Stock | 27.16 | 27.16 | 27.15 | 27.15 | 2700.0 |
| 2006-03-10 18:00:00 | MSFT | Stock | 27.16 | 27.16 | 27.15 | 27.15 | 11946.0 |
| 2006-03-10 08:30:00 | NVDA | Stock | 0.4032 | 0.4042 | 0.4032 | 0.4042 | 402000.0 |
| 2006-03-10 09:00:00 | NVDA | Stock | 0.4048 | 0.4048 | 0.4012 | 0.4012 | 760440.0 |
| 2006-03-10 09:30:00 | NVDA | Stock | 0.4015 | 0.4027 | 0.3972 | 0.4004 | 52759200.0 |
| 2006-03-10 10:00:00 | NVDA | Stock | 0.4003 | 0.4047 | 0.3991 | 0.4029 | 31042680.0 |
> showing 50 of 47,450 rows — these rows as CSV