PREVIEW / stock_30min / 2010-11-26
file: by_date/stock_30min/2010/2010-11-26.parquet size: 855 KB rows: 41,911 symbols: 3,376
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 |
|---|---|---|---|---|---|---|---|
| 2010-11-26 04:00:00 | AAPL | Stock | 11.2429 | 11.2429 | 11.1543 | 11.1543 | 42000.0 |
| 2010-11-26 04:30:00 | AAPL | Stock | 11.0957 | 11.0957 | 11.0957 | 11.0957 | 2800.0 |
| 2010-11-26 05:00:00 | AAPL | Stock | 11.1071 | 11.1214 | 11.0804 | 11.1161 | 16800.0 |
| 2010-11-26 05:30:00 | AAPL | Stock | 11.0911 | 11.0911 | 11.0911 | 11.0911 | 2800.0 |
| 2010-11-26 06:00:00 | AAPL | Stock | 11.0982 | 11.1161 | 11.0982 | 11.1161 | 11200.0 |
| 2010-11-26 06:30:00 | AAPL | Stock | 11.1061 | 11.1282 | 11.1061 | 11.1282 | 63000.0 |
| 2010-11-26 07:00:00 | AAPL | Stock | 11.1271 | 11.2118 | 11.1271 | 11.1768 | 288400.0 |
| 2010-11-26 07:30:00 | AAPL | Stock | 11.1746 | 11.1946 | 11.1643 | 11.1907 | 159376.0 |
| 2010-11-26 08:00:00 | AAPL | Stock | 11.1879 | 11.205 | 11.1786 | 11.1804 | 1944880.0 |
| 2010-11-26 08:30:00 | AAPL | Stock | 11.1807 | 11.2018 | 11.1793 | 11.2018 | 1943312.0 |
| 2010-11-26 09:00:00 | AAPL | Stock | 11.2018 | 11.23 | 11.1986 | 11.2064 | 1718192.0 |
| 2010-11-26 09:30:00 | AAPL | Stock | 11.2082 | 11.2939 | 11.1764 | 11.2779 | 64153936.0 |
| 2010-11-26 10:00:00 | AAPL | Stock | 11.2768 | 11.3464 | 11.2714 | 11.3292 | 49646100.0 |
| 2010-11-26 10:30:00 | AAPL | Stock | 11.3292 | 11.3389 | 11.2714 | 11.2807 | 33348644.0 |
| 2010-11-26 11:00:00 | AAPL | Stock | 11.28 | 11.3157 | 11.2771 | 11.2957 | 22111320.0 |
| 2010-11-26 11:30:00 | AAPL | Stock | 11.2957 | 11.3 | 11.2771 | 11.2968 | 17100664.0 |
| 2010-11-26 12:00:00 | AAPL | Stock | 11.2961 | 11.3007 | 11.2689 | 11.2873 | 13325620.0 |
| 2010-11-26 12:30:00 | AAPL | Stock | 11.2874 | 11.2946 | 11.2643 | 11.2771 | 24857420.0 |
| 2010-11-26 13:00:00 | AAPL | Stock | 11.2771 | 11.2819 | 11.2382 | 11.2446 | 4101384.0 |
| 2010-11-26 13:30:00 | AAPL | Stock | 11.2443 | 11.2886 | 11.2354 | 11.2389 | 526680.0 |
| 2010-11-26 14:00:00 | AAPL | Stock | 11.2393 | 11.2436 | 11.1899 | 11.2436 | 49728.0 |
| 2010-11-26 14:30:00 | AAPL | Stock | 11.2429 | 11.2436 | 11.2389 | 11.2436 | 73528.0 |
| 2010-11-26 15:00:00 | AAPL | Stock | 11.2418 | 11.2482 | 11.2414 | 11.2457 | 71960.0 |
| 2010-11-26 15:30:00 | AAPL | Stock | 11.2464 | 11.2464 | 11.2379 | 11.2382 | 139748.0 |
| 2010-11-26 16:00:00 | AAPL | Stock | 11.2382 | 11.2425 | 11.2379 | 11.2382 | 86380.0 |
| 2010-11-26 16:30:00 | AAPL | Stock | 11.2421 | 11.2446 | 11.2404 | 11.2411 | 62972.0 |
| 2010-11-26 04:30:00 | MSFT | Stock | 25.15 | 25.15 | 25.15 | 25.15 | 600.0 |
| 2010-11-26 05:30:00 | MSFT | Stock | 25.1 | 25.1 | 24.88 | 24.96 | 4200.0 |
| 2010-11-26 06:00:00 | MSFT | Stock | 24.95 | 24.95 | 24.95 | 24.95 | 100.0 |
| 2010-11-26 06:30:00 | MSFT | Stock | 25.01 | 25.05 | 25.01 | 25.05 | 4000.0 |
| 2010-11-26 07:00:00 | MSFT | Stock | 25.1 | 25.17 | 25.07 | 25.17 | 1700.0 |
| 2010-11-26 07:30:00 | MSFT | Stock | 25.16 | 25.18 | 25.16 | 25.18 | 300.0 |
| 2010-11-26 08:00:00 | MSFT | Stock | 25.22 | 25.3 | 25.18 | 25.18 | 17742.0 |
| 2010-11-26 08:30:00 | MSFT | Stock | 25.2 | 25.23 | 25.2 | 25.2 | 15530.0 |
| 2010-11-26 09:00:00 | MSFT | Stock | 25.2 | 25.23 | 25.08 | 25.22 | 79077.0 |
| 2010-11-26 09:30:00 | MSFT | Stock | 25.21 | 25.27 | 25.17 | 25.23 | 3184229.0 |
| 2010-11-26 10:00:00 | MSFT | Stock | 25.23 | 25.39 | 25.23 | 25.365 | 1916916.0 |
| 2010-11-26 10:30:00 | MSFT | Stock | 25.36 | 25.41 | 25.27 | 25.305 | 2161755.0 |
| 2010-11-26 11:00:00 | MSFT | Stock | 25.31 | 25.34 | 25.24 | 25.27 | 1667896.0 |
| 2010-11-26 11:30:00 | MSFT | Stock | 25.27 | 25.31 | 25.22 | 25.3 | 3046017.0 |
| 2010-11-26 12:00:00 | MSFT | Stock | 25.3 | 25.4 | 25.29 | 25.38 | 2226829.0 |
| 2010-11-26 12:30:00 | MSFT | Stock | 25.38 | 25.4 | 25.34 | 25.35 | 3400723.0 |
| 2010-11-26 13:00:00 | MSFT | Stock | 25.34 | 25.35 | 25.23 | 25.25 | 1391618.0 |
| 2010-11-26 13:30:00 | MSFT | Stock | 25.345 | 25.36 | 25.27 | 25.27 | 94180.0 |
| 2010-11-26 14:30:00 | MSFT | Stock | 25.27 | 25.27 | 25.27 | 25.27 | 1926.0 |
| 2010-11-26 15:00:00 | MSFT | Stock | 25.26 | 25.3 | 25.26 | 25.3 | 399.0 |
| 2010-11-26 15:30:00 | MSFT | Stock | 25.26 | 25.4 | 25.26 | 25.4 | 3450.0 |
| 2010-11-26 16:30:00 | MSFT | Stock | 25.37 | 25.37 | 25.37 | 25.37 | 100.0 |
| 2010-11-26 08:00:00 | NVDA | Stock | 0.3485 | 0.3488 | 0.3485 | 0.3488 | 16000.0 |
| 2010-11-26 09:00:00 | NVDA | Stock | 0.3438 | 0.3455 | 0.3435 | 0.344 | 106160.0 |
> showing 50 of 41,911 rows — these rows as CSV