PREVIEW / stock_30min / 2008-11-25
file: by_date/stock_30min/2008/2008-11-25.parquet size: 1.2 MB rows: 70,074 symbols: 3,337
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-11-25 07:00:00 | AAPL | Stock | 3.3214 | 3.3232 | 3.3214 | 3.3214 | 42000.0 |
| 2008-11-25 07:30:00 | AAPL | Stock | 3.3036 | 3.3318 | 3.3036 | 3.3318 | 29400.0 |
| 2008-11-25 08:00:00 | AAPL | Stock | 3.3214 | 3.3357 | 3.2729 | 3.3214 | 1576484.0 |
| 2008-11-25 08:30:00 | AAPL | Stock | 3.3154 | 3.3893 | 3.3082 | 3.3821 | 3017084.0 |
| 2008-11-25 09:00:00 | AAPL | Stock | 3.3843 | 3.4129 | 3.3793 | 3.3804 | 4742612.0 |
| 2008-11-25 09:30:00 | AAPL | Stock | 3.3807 | 3.3829 | 3.2411 | 3.2543 | 158515336.0 |
| 2008-11-25 10:00:00 | AAPL | Stock | 3.2586 | 3.2679 | 3.1964 | 3.2211 | 136024308.0 |
| 2008-11-25 10:30:00 | AAPL | Stock | 3.2211 | 3.2225 | 3.1486 | 3.1818 | 122072244.0 |
| 2008-11-25 11:00:00 | AAPL | Stock | 3.1814 | 3.2443 | 3.1643 | 3.2386 | 87568964.0 |
| 2008-11-25 11:30:00 | AAPL | Stock | 3.2386 | 3.2818 | 3.225 | 3.2657 | 78207612.0 |
| 2008-11-25 12:00:00 | AAPL | Stock | 3.2657 | 3.2746 | 3.1989 | 3.2118 | 65243528.0 |
| 2008-11-25 12:30:00 | AAPL | Stock | 3.2118 | 3.2468 | 3.1779 | 3.1857 | 62274604.0 |
| 2008-11-25 13:00:00 | AAPL | Stock | 3.185 | 3.2161 | 3.1736 | 3.2107 | 56408100.0 |
| 2008-11-25 13:30:00 | AAPL | Stock | 3.2111 | 3.2382 | 3.1964 | 3.1975 | 48872992.0 |
| 2008-11-25 14:00:00 | AAPL | Stock | 3.1986 | 3.21 | 3.1764 | 3.1932 | 55852580.0 |
| 2008-11-25 14:30:00 | AAPL | Stock | 3.1943 | 3.2582 | 3.1893 | 3.245 | 66026520.0 |
| 2008-11-25 15:00:00 | AAPL | Stock | 3.2446 | 3.3082 | 3.2404 | 3.256 | 122587668.0 |
| 2008-11-25 15:30:00 | AAPL | Stock | 3.2568 | 3.3018 | 3.2393 | 3.2432 | 122115532.0 |
| 2008-11-25 16:00:00 | AAPL | Stock | 3.2432 | 3.2705 | 3.2284 | 3.2425 | 34658400.0 |
| 2008-11-25 16:30:00 | AAPL | Stock | 3.25 | 3.25 | 3.2321 | 3.2321 | 951804.0 |
| 2008-11-25 17:00:00 | AAPL | Stock | 3.2471 | 3.2514 | 3.2375 | 3.25 | 613620.0 |
| 2008-11-25 17:30:00 | AAPL | Stock | 3.25 | 3.2514 | 3.2446 | 3.2511 | 136080.0 |
| 2008-11-25 18:00:00 | AAPL | Stock | 3.2464 | 3.2511 | 3.2393 | 3.2393 | 93940.0 |
| 2008-11-25 18:30:00 | AAPL | Stock | 3.2386 | 3.2411 | 3.2386 | 3.2411 | 75600.0 |
| 2008-11-25 19:00:00 | AAPL | Stock | 3.2429 | 3.2496 | 3.2429 | 3.2436 | 65240.0 |
| 2008-11-25 19:30:00 | AAPL | Stock | 3.2496 | 3.2571 | 3.2432 | 3.2571 | 66080.0 |
| 2008-11-25 05:30:00 | MSFT | Stock | 20.2 | 20.2 | 20.2 | 20.2 | 150.0 |
| 2008-11-25 08:00:00 | MSFT | Stock | 20.5 | 20.75 | 20.45 | 20.69 | 7692.0 |
| 2008-11-25 08:30:00 | MSFT | Stock | 20.78 | 20.98 | 20.78 | 20.86 | 81764.0 |
| 2008-11-25 09:00:00 | MSFT | Stock | 20.85 | 20.9 | 20.75 | 20.85 | 45827.0 |
| 2008-11-25 09:30:00 | MSFT | Stock | 20.86 | 20.93 | 20.21 | 20.36 | 9529199.0 |
| 2008-11-25 10:00:00 | MSFT | Stock | 20.36 | 20.52 | 20.23 | 20.37 | 6579853.0 |
| 2008-11-25 10:30:00 | MSFT | Stock | 20.36 | 20.44 | 19.94 | 19.97 | 5741712.0 |
| 2008-11-25 11:00:00 | MSFT | Stock | 19.97 | 20.02 | 19.78 | 20.0 | 4643132.0 |
| 2008-11-25 11:30:00 | MSFT | Stock | 20.0 | 20.22 | 19.98 | 20.11 | 4260071.0 |
| 2008-11-25 12:00:00 | MSFT | Stock | 20.12 | 20.15 | 19.85 | 19.9 | 4388650.0 |
| 2008-11-25 12:30:00 | MSFT | Stock | 19.89 | 19.93 | 19.7 | 19.748 | 4199394.0 |
| 2008-11-25 13:00:00 | MSFT | Stock | 19.76 | 19.99 | 19.73 | 19.91 | 3550548.0 |
| 2008-11-25 13:30:00 | MSFT | Stock | 19.9 | 20.0 | 19.84 | 19.85 | 3201123.0 |
| 2008-11-25 14:00:00 | MSFT | Stock | 19.841 | 19.91 | 19.55 | 19.65 | 4946702.0 |
| 2008-11-25 14:30:00 | MSFT | Stock | 19.66 | 20.02 | 19.61 | 19.99 | 4620911.0 |
| 2008-11-25 15:00:00 | MSFT | Stock | 19.99 | 20.24 | 19.99 | 20.11 | 7398547.0 |
| 2008-11-25 15:30:00 | MSFT | Stock | 20.12 | 20.4 | 20.0 | 20.0 | 14494087.0 |
| 2008-11-25 16:00:00 | MSFT | Stock | 20.0 | 20.263 | 19.935 | 20.263 | 11899550.0 |
| 2008-11-25 16:30:00 | MSFT | Stock | 19.992 | 20.122 | 19.85 | 20.088 | 411411.0 |
| 2008-11-25 17:00:00 | MSFT | Stock | 19.97 | 20.11 | 19.94 | 19.94 | 79470.0 |
| 2008-11-25 17:30:00 | MSFT | Stock | 19.97 | 19.97 | 19.97 | 19.97 | 3601.0 |
| 2008-11-25 18:00:00 | MSFT | Stock | 19.94 | 20.0 | 19.94 | 20.0 | 9907.0 |
| 2008-11-25 18:30:00 | MSFT | Stock | 19.99 | 20.0 | 19.97 | 19.99 | 5650.0 |
| 2008-11-25 19:00:00 | MSFT | Stock | 19.99 | 20.05 | 19.99 | 20.05 | 5350.0 |
> showing 50 of 70,074 rows — these rows as CSV