PREVIEW / stock_30min / 2008-04-15
file: by_date/stock_30min/2008/2008-04-15.parquet size: 1.2 MB rows: 68,151 symbols: 3,292
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 |
|---|---|---|---|---|---|---|---|
| 2008-04-15 05:00:00 | AAPL | Stock | 5.2675 | 5.2675 | 5.2661 | 5.2661 | 10948.0 |
| 2008-04-15 06:00:00 | AAPL | Stock | 5.2693 | 5.2714 | 5.2693 | 5.2714 | 5600.0 |
| 2008-04-15 06:30:00 | AAPL | Stock | 5.2575 | 5.2575 | 5.2546 | 5.2546 | 47600.0 |
| 2008-04-15 07:00:00 | AAPL | Stock | 5.2671 | 5.2679 | 5.2607 | 5.2614 | 33236.0 |
| 2008-04-15 07:30:00 | AAPL | Stock | 5.2675 | 5.2771 | 5.2671 | 5.2771 | 148120.0 |
| 2008-04-15 08:00:00 | AAPL | Stock | 5.2771 | 5.2946 | 5.2771 | 5.2925 | 901516.0 |
| 2008-04-15 08:30:00 | AAPL | Stock | 5.2929 | 5.3482 | 5.2757 | 5.3357 | 3313688.0 |
| 2008-04-15 09:00:00 | AAPL | Stock | 5.3343 | 5.3518 | 5.3304 | 5.3357 | 2475928.0 |
| 2008-04-15 09:30:00 | AAPL | Stock | 5.3357 | 5.3471 | 5.2918 | 5.2929 | 93308068.0 |
| 2008-04-15 10:00:00 | AAPL | Stock | 5.2932 | 5.3168 | 5.2741 | 5.2775 | 62036464.0 |
| 2008-04-15 10:30:00 | AAPL | Stock | 5.2771 | 5.2843 | 5.2304 | 5.25 | 68307512.0 |
| 2008-04-15 11:00:00 | AAPL | Stock | 5.2496 | 5.265 | 5.2043 | 5.2139 | 59113068.0 |
| 2008-04-15 11:30:00 | AAPL | Stock | 5.2125 | 5.2321 | 5.2054 | 5.2218 | 41697432.0 |
| 2008-04-15 12:00:00 | AAPL | Stock | 5.2229 | 5.2454 | 5.2107 | 5.2446 | 28153496.0 |
| 2008-04-15 12:30:00 | AAPL | Stock | 5.2446 | 5.255 | 5.2329 | 5.2475 | 28061908.0 |
| 2008-04-15 13:00:00 | AAPL | Stock | 5.2475 | 5.2704 | 5.2404 | 5.2596 | 32763472.0 |
| 2008-04-15 13:30:00 | AAPL | Stock | 5.2604 | 5.28 | 5.2471 | 5.2668 | 35029344.0 |
| 2008-04-15 14:00:00 | AAPL | Stock | 5.2668 | 5.2936 | 5.2579 | 5.285 | 41677244.0 |
| 2008-04-15 14:30:00 | AAPL | Stock | 5.2854 | 5.3196 | 5.2643 | 5.275 | 70693560.0 |
| 2008-04-15 15:00:00 | AAPL | Stock | 5.2743 | 5.3054 | 5.2707 | 5.3018 | 42265636.0 |
| 2008-04-15 15:30:00 | AAPL | Stock | 5.3021 | 5.3125 | 5.28 | 5.2993 | 55419756.0 |
| 2008-04-15 16:00:00 | AAPL | Stock | 5.2993 | 5.3961 | 5.2617 | 5.3779 | 14222068.0 |
| 2008-04-15 16:30:00 | AAPL | Stock | 5.385 | 5.3996 | 5.2976 | 5.3893 | 5182016.0 |
| 2008-04-15 17:00:00 | AAPL | Stock | 5.3911 | 5.3982 | 5.3821 | 5.3839 | 1310176.0 |
| 2008-04-15 17:30:00 | AAPL | Stock | 5.3857 | 5.3982 | 5.3821 | 5.3982 | 755216.0 |
| 2008-04-15 18:00:00 | AAPL | Stock | 5.3982 | 5.3982 | 5.3893 | 5.3982 | 1269828.0 |
| 2008-04-15 18:30:00 | AAPL | Stock | 5.3982 | 5.4 | 5.3936 | 5.4 | 225148.0 |
| 2008-04-15 19:00:00 | AAPL | Stock | 5.4 | 5.4018 | 5.3964 | 5.3964 | 125636.0 |
| 2008-04-15 19:30:00 | AAPL | Stock | 5.3964 | 5.4046 | 5.3964 | 5.4036 | 227108.0 |
| 2008-04-15 20:00:00 | AAPL | Stock | 5.2779 | 5.2779 | 5.2779 | 5.2779 | 423024.0 |
| 2008-04-15 08:00:00 | MSFT | Stock | 28.15 | 28.16 | 28.12 | 28.12 | 4900.0 |
| 2008-04-15 08:30:00 | MSFT | Stock | 28.1 | 28.29 | 28.1 | 28.2 | 12198.0 |
| 2008-04-15 09:00:00 | MSFT | Stock | 28.16 | 28.2 | 28.12 | 28.12 | 10400.0 |
| 2008-04-15 09:30:00 | MSFT | Stock | 28.12 | 28.41 | 28.1 | 28.4 | 3508766.0 |
| 2008-04-15 10:00:00 | MSFT | Stock | 28.4 | 28.48 | 28.23 | 28.25 | 3042938.0 |
| 2008-04-15 10:30:00 | MSFT | Stock | 28.24 | 28.26 | 28.18 | 28.26 | 2505624.0 |
| 2008-04-15 11:00:00 | MSFT | Stock | 28.25 | 28.27 | 28.03 | 28.085 | 2768425.0 |
| 2008-04-15 11:30:00 | MSFT | Stock | 28.08 | 28.16 | 28.06 | 28.119 | 1786780.0 |
| 2008-04-15 12:00:00 | MSFT | Stock | 28.12 | 28.15 | 28.05 | 28.15 | 1362460.0 |
| 2008-04-15 12:30:00 | MSFT | Stock | 28.15 | 28.16 | 28.08 | 28.09 | 1556038.0 |
| 2008-04-15 13:00:00 | MSFT | Stock | 28.09 | 28.12 | 28.04 | 28.09 | 2316343.0 |
| 2008-04-15 13:30:00 | MSFT | Stock | 28.09 | 28.15 | 28.06 | 28.15 | 1547699.0 |
| 2008-04-15 14:00:00 | MSFT | Stock | 28.15 | 28.22 | 28.1 | 28.2 | 2125960.0 |
| 2008-04-15 14:30:00 | MSFT | Stock | 28.2 | 28.25 | 28.12 | 28.14 | 1739714.0 |
| 2008-04-15 15:00:00 | MSFT | Stock | 28.15 | 28.3 | 28.13 | 28.3 | 2422949.0 |
| 2008-04-15 15:30:00 | MSFT | Stock | 28.3 | 28.35 | 28.19 | 28.27 | 3549392.0 |
| 2008-04-15 16:00:00 | MSFT | Stock | 28.27 | 28.6 | 28.146 | 28.59 | 3140079.0 |
| 2008-04-15 16:30:00 | MSFT | Stock | 28.55 | 28.65 | 28.25 | 28.6 | 119719.0 |
| 2008-04-15 17:00:00 | MSFT | Stock | 28.6 | 28.6 | 28.5 | 28.54 | 19730.0 |
| 2008-04-15 17:30:00 | MSFT | Stock | 28.55 | 28.6 | 28.51 | 28.51 | 11150.0 |
> showing 50 of 68,151 rows — these rows as CSV