PREVIEW / stock_30min / 2006-08-11
file: by_date/stock_30min/2006/2006-08-11.parquet size: 862 KB rows: 47,477 symbols: 2,305
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-08-11 06:30:00 | AAPL | Stock | 2.2839 | 2.2839 | 2.2839 | 2.2839 | 2800.0 |
| 2006-08-11 07:00:00 | AAPL | Stock | 2.2786 | 2.2804 | 2.2786 | 2.2786 | 71680.0 |
| 2006-08-11 07:30:00 | AAPL | Stock | 2.2789 | 2.2821 | 2.2696 | 2.2736 | 165200.0 |
| 2006-08-11 08:00:00 | AAPL | Stock | 2.2818 | 2.2821 | 2.2214 | 2.26 | 6825476.0 |
| 2006-08-11 08:30:00 | AAPL | Stock | 2.2596 | 2.2775 | 2.2571 | 2.2689 | 7267988.0 |
| 2006-08-11 09:00:00 | AAPL | Stock | 2.2689 | 2.2689 | 2.2571 | 2.2586 | 2752008.0 |
| 2006-08-11 09:30:00 | AAPL | Stock | 2.2582 | 2.2721 | 2.235 | 2.265 | 185942428.0 |
| 2006-08-11 10:00:00 | AAPL | Stock | 2.265 | 2.28 | 2.2507 | 2.2764 | 96916820.0 |
| 2006-08-11 10:30:00 | AAPL | Stock | 2.2761 | 2.2904 | 2.2732 | 2.2768 | 66236604.0 |
| 2006-08-11 11:00:00 | AAPL | Stock | 2.2764 | 2.2864 | 2.2714 | 2.2746 | 41503140.0 |
| 2006-08-11 11:30:00 | AAPL | Stock | 2.2743 | 2.2786 | 2.2646 | 2.2682 | 30658012.0 |
| 2006-08-11 12:00:00 | AAPL | Stock | 2.2682 | 2.2732 | 2.255 | 2.2629 | 48907740.0 |
| 2006-08-11 12:30:00 | AAPL | Stock | 2.2629 | 2.2675 | 2.2575 | 2.2629 | 27301008.0 |
| 2006-08-11 13:00:00 | AAPL | Stock | 2.2629 | 2.2671 | 2.2554 | 2.2593 | 27944896.0 |
| 2006-08-11 13:30:00 | AAPL | Stock | 2.2589 | 2.2679 | 2.2571 | 2.2657 | 25006324.0 |
| 2006-08-11 14:00:00 | AAPL | Stock | 2.2654 | 2.2675 | 2.2518 | 2.2529 | 36163400.0 |
| 2006-08-11 14:30:00 | AAPL | Stock | 2.2525 | 2.2646 | 2.2457 | 2.2611 | 64218000.0 |
| 2006-08-11 15:00:00 | AAPL | Stock | 2.2611 | 2.2657 | 2.2561 | 2.265 | 31333932.0 |
| 2006-08-11 15:30:00 | AAPL | Stock | 2.265 | 2.2768 | 2.2639 | 2.2736 | 66308172.0 |
| 2006-08-11 16:00:00 | AAPL | Stock | 2.2736 | 2.275 | 2.2686 | 2.2732 | 4645760.0 |
| 2006-08-11 16:30:00 | AAPL | Stock | 2.2714 | 2.2732 | 2.2661 | 2.2682 | 811944.0 |
| 2006-08-11 17:00:00 | AAPL | Stock | 2.2707 | 2.2711 | 2.2679 | 2.27 | 166040.0 |
| 2006-08-11 17:30:00 | AAPL | Stock | 2.2696 | 2.2725 | 2.2696 | 2.2725 | 133728.0 |
| 2006-08-11 18:00:00 | AAPL | Stock | 2.2696 | 2.2696 | 2.2696 | 2.2696 | 2800.0 |
| 2006-08-11 07:30:00 | MSFT | Stock | 24.37 | 24.38 | 24.37 | 24.37 | 3000.0 |
| 2006-08-11 08:00:00 | MSFT | Stock | 24.4 | 24.4 | 24.37 | 24.37 | 850.0 |
| 2006-08-11 08:30:00 | MSFT | Stock | 24.43 | 24.43 | 24.4 | 24.42 | 1000.0 |
| 2006-08-11 09:00:00 | MSFT | Stock | 24.39 | 24.43 | 24.34 | 24.43 | 69349.0 |
| 2006-08-11 09:30:00 | MSFT | Stock | 24.43 | 24.43 | 24.23 | 24.26 | 3327319.0 |
| 2006-08-11 10:00:00 | MSFT | Stock | 24.26 | 24.31 | 24.2 | 24.29 | 2462891.0 |
| 2006-08-11 10:30:00 | MSFT | Stock | 24.29 | 24.37 | 24.22 | 24.33 | 1967926.0 |
| 2006-08-11 11:00:00 | MSFT | Stock | 24.33 | 24.36 | 24.31 | 24.33 | 1811712.0 |
| 2006-08-11 11:30:00 | MSFT | Stock | 24.33 | 24.34 | 24.25 | 24.27 | 2849023.0 |
| 2006-08-11 12:00:00 | MSFT | Stock | 24.27 | 24.3 | 24.25 | 24.28 | 1478251.0 |
| 2006-08-11 12:30:00 | MSFT | Stock | 24.281 | 24.3 | 24.26 | 24.28 | 1378793.0 |
| 2006-08-11 13:00:00 | MSFT | Stock | 24.28 | 24.29 | 24.25 | 24.26 | 1449239.0 |
| 2006-08-11 13:30:00 | MSFT | Stock | 24.26 | 24.33 | 24.23 | 24.3 | 2142949.0 |
| 2006-08-11 14:00:00 | MSFT | Stock | 24.3 | 24.34 | 24.29 | 24.338 | 1714753.0 |
| 2006-08-11 14:30:00 | MSFT | Stock | 24.33 | 24.35 | 24.3 | 24.34 | 1309850.0 |
| 2006-08-11 15:00:00 | MSFT | Stock | 24.34 | 24.4 | 24.31 | 24.39 | 2645253.0 |
| 2006-08-11 15:30:00 | MSFT | Stock | 24.392 | 24.45 | 24.37 | 24.43 | 3685289.0 |
| 2006-08-11 16:00:00 | MSFT | Stock | 24.42 | 24.5 | 24.35 | 24.37 | 571711.0 |
| 2006-08-11 16:30:00 | MSFT | Stock | 24.4 | 24.42 | 24.38 | 24.38 | 3100.0 |
| 2006-08-11 17:30:00 | MSFT | Stock | 24.43 | 24.43 | 24.43 | 24.43 | 450.0 |
| 2006-08-11 07:30:00 | NVDA | Stock | 0.3672 | 0.3672 | 0.3625 | 0.3637 | 1188000.0 |
| 2006-08-11 08:00:00 | NVDA | Stock | 0.365 | 0.3732 | 0.3617 | 0.3707 | 23929440.0 |
| 2006-08-11 08:30:00 | NVDA | Stock | 0.3703 | 0.3772 | 0.3692 | 0.3725 | 30163860.0 |
| 2006-08-11 09:00:00 | NVDA | Stock | 0.374 | 0.375 | 0.3713 | 0.3733 | 29682660.0 |
| 2006-08-11 09:30:00 | NVDA | Stock | 0.3733 | 0.3957 | 0.372 | 0.3898 | 449137260.0 |
| 2006-08-11 10:00:00 | NVDA | Stock | 0.39 | 0.4 | 0.388 | 0.398 | 199836660.0 |
> showing 50 of 47,477 rows — these rows as CSV