PREVIEW / stock_30min / 2006-12-01
file: by_date/stock_30min/2006/2006-12-01.parquet size: 981 KB rows: 52,596 symbols: 2,449
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-12-01 07:30:00 | AAPL | Stock | 3.2821 | 3.2886 | 3.2821 | 3.2886 | 47460.0 |
| 2006-12-01 08:00:00 | AAPL | Stock | 3.2925 | 3.2929 | 3.2821 | 3.2832 | 1373120.0 |
| 2006-12-01 08:30:00 | AAPL | Stock | 3.2829 | 3.2836 | 3.2736 | 3.2789 | 1082648.0 |
| 2006-12-01 09:00:00 | AAPL | Stock | 3.2786 | 3.2818 | 3.2743 | 3.275 | 1349432.0 |
| 2006-12-01 09:30:00 | AAPL | Stock | 3.2786 | 3.2975 | 3.2725 | 3.275 | 82385436.0 |
| 2006-12-01 10:00:00 | AAPL | Stock | 3.2757 | 3.2768 | 3.2525 | 3.2589 | 102698176.0 |
| 2006-12-01 10:30:00 | AAPL | Stock | 3.2586 | 3.2607 | 3.2179 | 3.2468 | 114536604.0 |
| 2006-12-01 11:00:00 | AAPL | Stock | 3.2468 | 3.2571 | 3.2404 | 3.25 | 52060680.0 |
| 2006-12-01 11:30:00 | AAPL | Stock | 3.2502 | 3.2786 | 3.2443 | 3.2754 | 64713152.0 |
| 2006-12-01 12:00:00 | AAPL | Stock | 3.2754 | 3.2796 | 3.2639 | 3.2668 | 46780636.0 |
| 2006-12-01 12:30:00 | AAPL | Stock | 3.2671 | 3.2768 | 3.2571 | 3.2732 | 32509512.0 |
| 2006-12-01 13:00:00 | AAPL | Stock | 3.2735 | 3.275 | 3.255 | 3.2589 | 37440368.0 |
| 2006-12-01 13:30:00 | AAPL | Stock | 3.2586 | 3.2643 | 3.245 | 3.2593 | 39809980.0 |
| 2006-12-01 14:00:00 | AAPL | Stock | 3.2586 | 3.2621 | 3.2479 | 3.255 | 38780476.0 |
| 2006-12-01 14:30:00 | AAPL | Stock | 3.2546 | 3.2823 | 3.2393 | 3.2506 | 59597020.0 |
| 2006-12-01 15:00:00 | AAPL | Stock | 3.2507 | 3.2625 | 3.2468 | 3.2621 | 50405236.0 |
| 2006-12-01 15:30:00 | AAPL | Stock | 3.2621 | 3.2625 | 3.2518 | 3.2604 | 57864576.0 |
| 2006-12-01 16:00:00 | AAPL | Stock | 3.2614 | 3.2646 | 3.2518 | 3.2621 | 1646064.0 |
| 2006-12-01 16:30:00 | AAPL | Stock | 3.2629 | 3.2636 | 3.2589 | 3.2589 | 222628.0 |
| 2006-12-01 17:00:00 | AAPL | Stock | 3.2636 | 3.2636 | 3.2589 | 3.2625 | 129948.0 |
| 2006-12-01 17:30:00 | AAPL | Stock | 3.2625 | 3.2629 | 3.2621 | 3.2629 | 95200.0 |
| 2006-12-01 18:00:00 | AAPL | Stock | 3.2625 | 3.2629 | 3.2621 | 3.2621 | 158480.0 |
| 2006-12-01 18:30:00 | AAPL | Stock | 3.2621 | 3.2625 | 3.2618 | 3.2621 | 105980.0 |
| 2006-12-01 19:00:00 | AAPL | Stock | 3.2625 | 3.2636 | 3.2625 | 3.2636 | 44800.0 |
| 2006-12-01 19:30:00 | AAPL | Stock | 3.2632 | 3.2639 | 3.2611 | 3.2639 | 89012.0 |
| 2006-12-01 06:30:00 | MSFT | Stock | 29.4 | 29.4 | 29.4 | 29.4 | 1283.0 |
| 2006-12-01 07:00:00 | MSFT | Stock | 29.4 | 29.4 | 29.4 | 29.4 | 5000.0 |
| 2006-12-01 08:00:00 | MSFT | Stock | 29.4 | 29.4 | 29.35 | 29.35 | 300.0 |
| 2006-12-01 08:30:00 | MSFT | Stock | 29.35 | 29.36 | 29.33 | 29.33 | 5700.0 |
| 2006-12-01 09:00:00 | MSFT | Stock | 29.32 | 29.33 | 29.19 | 29.23 | 228663.0 |
| 2006-12-01 09:30:00 | MSFT | Stock | 29.21 | 29.3 | 29.12 | 29.18 | 6250760.0 |
| 2006-12-01 10:00:00 | MSFT | Stock | 29.18 | 29.21 | 28.93 | 29.11 | 11393926.0 |
| 2006-12-01 10:30:00 | MSFT | Stock | 29.11 | 29.17 | 28.96 | 29.05 | 6077880.0 |
| 2006-12-01 11:00:00 | MSFT | Stock | 29.04 | 29.12 | 29.03 | 29.07 | 2858459.0 |
| 2006-12-01 11:30:00 | MSFT | Stock | 29.08 | 29.15 | 29.04 | 29.11 | 2892061.0 |
| 2006-12-01 12:00:00 | MSFT | Stock | 29.11 | 29.14 | 29.01 | 29.01 | 3346106.0 |
| 2006-12-01 12:30:00 | MSFT | Stock | 29.013 | 29.03 | 28.94 | 28.989 | 4609285.0 |
| 2006-12-01 13:00:00 | MSFT | Stock | 28.98 | 29.0 | 28.93 | 28.95 | 3364230.0 |
| 2006-12-01 13:30:00 | MSFT | Stock | 28.95 | 29.0 | 28.9 | 28.975 | 4878754.0 |
| 2006-12-01 14:00:00 | MSFT | Stock | 28.97 | 29.0 | 28.9 | 28.96 | 3985493.0 |
| 2006-12-01 14:30:00 | MSFT | Stock | 28.96 | 28.99 | 28.92 | 28.98 | 3843328.0 |
| 2006-12-01 15:00:00 | MSFT | Stock | 28.98 | 29.04 | 28.97 | 28.99 | 5466516.0 |
| 2006-12-01 15:30:00 | MSFT | Stock | 28.98 | 29.11 | 28.97 | 29.11 | 8386129.0 |
| 2006-12-01 16:00:00 | MSFT | Stock | 29.12 | 29.12 | 29.09 | 29.11 | 196219.0 |
| 2006-12-01 16:30:00 | MSFT | Stock | 29.11 | 29.15 | 29.11 | 29.14 | 35600.0 |
| 2006-12-01 17:00:00 | MSFT | Stock | 29.15 | 29.15 | 29.12 | 29.15 | 27234.0 |
| 2006-12-01 17:30:00 | MSFT | Stock | 29.15 | 29.15 | 29.027 | 29.14 | 3183.0 |
| 2006-12-01 18:00:00 | MSFT | Stock | 29.14 | 29.14 | 29.14 | 29.14 | 300.0 |
| 2006-12-01 18:30:00 | MSFT | Stock | 29.14 | 29.14 | 29.14 | 29.14 | 4000.0 |
| 2006-12-01 19:30:00 | MSFT | Stock | 29.15 | 29.15 | 29.15 | 29.15 | 1146.0 |
> showing 50 of 52,596 rows — these rows as CSV