PREVIEW / stock_30min / 2010-11-30
file: by_date/stock_30min/2010/2010-11-30.parquet size: 1.4 MB rows: 75,817 symbols: 3,510
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-30 04:00:00 | AAPL | Stock | 11.25 | 11.25 | 11.2336 | 11.2336 | 19600.0 |
| 2010-11-30 04:30:00 | AAPL | Stock | 11.2411 | 11.2411 | 11.2214 | 11.2286 | 47600.0 |
| 2010-11-30 05:00:00 | AAPL | Stock | 11.2296 | 11.2332 | 11.2296 | 11.2332 | 11200.0 |
| 2010-11-30 05:30:00 | AAPL | Stock | 11.2332 | 11.2586 | 11.2332 | 11.2586 | 50400.0 |
| 2010-11-30 06:00:00 | AAPL | Stock | 11.2536 | 11.2536 | 11.2536 | 11.2536 | 2800.0 |
| 2010-11-30 06:30:00 | AAPL | Stock | 11.2857 | 11.2857 | 11.2721 | 11.2725 | 8400.0 |
| 2010-11-30 07:00:00 | AAPL | Stock | 11.2611 | 11.2679 | 11.2536 | 11.2536 | 94360.0 |
| 2010-11-30 07:30:00 | AAPL | Stock | 11.2661 | 11.2721 | 11.2325 | 11.25 | 170660.0 |
| 2010-11-30 08:00:00 | AAPL | Stock | 11.2568 | 11.2679 | 11.2314 | 11.2396 | 1692600.0 |
| 2010-11-30 08:30:00 | AAPL | Stock | 11.2386 | 11.2389 | 11.1971 | 11.215 | 1836352.0 |
| 2010-11-30 09:00:00 | AAPL | Stock | 11.2136 | 11.2268 | 11.2018 | 11.2036 | 1975988.0 |
| 2010-11-30 09:30:00 | AAPL | Stock | 11.2032 | 11.2186 | 11.1268 | 11.1757 | 84455028.0 |
| 2010-11-30 10:00:00 | AAPL | Stock | 11.1757 | 11.2271 | 11.1554 | 11.2111 | 47820976.0 |
| 2010-11-30 10:30:00 | AAPL | Stock | 11.2126 | 11.2143 | 11.1643 | 11.1693 | 28575148.0 |
| 2010-11-30 11:00:00 | AAPL | Stock | 11.1696 | 11.1811 | 11.1429 | 11.1606 | 27729072.0 |
| 2010-11-30 11:30:00 | AAPL | Stock | 11.1579 | 11.1764 | 11.1339 | 11.1525 | 33317396.0 |
| 2010-11-30 12:00:00 | AAPL | Stock | 11.1529 | 11.1625 | 11.1193 | 11.1439 | 26161464.0 |
| 2010-11-30 12:30:00 | AAPL | Stock | 11.1418 | 11.1436 | 11.1082 | 11.1168 | 22415316.0 |
| 2010-11-30 13:00:00 | AAPL | Stock | 11.1189 | 11.1718 | 11.1082 | 11.1511 | 37754808.0 |
| 2010-11-30 13:30:00 | AAPL | Stock | 11.1514 | 11.1607 | 11.1271 | 11.1407 | 16462544.0 |
| 2010-11-30 14:00:00 | AAPL | Stock | 11.1414 | 11.1657 | 11.1096 | 11.1171 | 27189540.0 |
| 2010-11-30 14:30:00 | AAPL | Stock | 11.1179 | 11.1371 | 11.1082 | 11.1307 | 25117512.0 |
| 2010-11-30 15:00:00 | AAPL | Stock | 11.1304 | 11.1589 | 11.1243 | 11.15 | 29088136.0 |
| 2010-11-30 15:30:00 | AAPL | Stock | 11.1507 | 11.1579 | 11.1025 | 11.1125 | 53639432.0 |
| 2010-11-30 16:00:00 | AAPL | Stock | 11.1143 | 11.1596 | 11.0871 | 11.0914 | 27448596.0 |
| 2010-11-30 16:30:00 | AAPL | Stock | 11.0914 | 11.1545 | 11.0893 | 11.0957 | 841596.0 |
| 2010-11-30 17:00:00 | AAPL | Stock | 11.0971 | 11.1203 | 11.0932 | 11.1011 | 902720.0 |
| 2010-11-30 17:30:00 | AAPL | Stock | 11.0982 | 11.1153 | 11.0968 | 11.1153 | 141260.0 |
| 2010-11-30 18:00:00 | AAPL | Stock | 11.0971 | 11.1125 | 11.0968 | 11.0993 | 333928.0 |
| 2010-11-30 18:30:00 | AAPL | Stock | 11.0982 | 11.1054 | 11.0968 | 11.0968 | 304724.0 |
| 2010-11-30 19:00:00 | AAPL | Stock | 11.0968 | 11.0996 | 11.0968 | 11.0996 | 139076.0 |
| 2010-11-30 19:30:00 | AAPL | Stock | 11.0996 | 11.0996 | 11.0929 | 11.0932 | 297696.0 |
| 2010-11-30 05:00:00 | MSFT | Stock | 25.11 | 25.11 | 25.11 | 25.11 | 500.0 |
| 2010-11-30 05:30:00 | MSFT | Stock | 25.14 | 25.22 | 25.14 | 25.22 | 1300.0 |
| 2010-11-30 07:00:00 | MSFT | Stock | 25.39 | 25.39 | 25.14 | 25.14 | 4200.0 |
| 2010-11-30 07:30:00 | MSFT | Stock | 25.22 | 25.22 | 25.2 | 25.21 | 6200.0 |
| 2010-11-30 08:00:00 | MSFT | Stock | 25.2 | 25.26 | 25.2 | 25.24 | 22183.0 |
| 2010-11-30 08:30:00 | MSFT | Stock | 25.23 | 25.23 | 25.16 | 25.17 | 13472.0 |
| 2010-11-30 09:00:00 | MSFT | Stock | 25.18 | 25.24 | 25.06 | 25.06 | 118031.0 |
| 2010-11-30 09:30:00 | MSFT | Stock | 25.06 | 25.34 | 25.0 | 25.33 | 9866629.0 |
| 2010-11-30 10:00:00 | MSFT | Stock | 25.33 | 25.47 | 25.295 | 25.42 | 7827426.0 |
| 2010-11-30 10:30:00 | MSFT | Stock | 25.42 | 25.45 | 25.27 | 25.31 | 4714640.0 |
| 2010-11-30 11:00:00 | MSFT | Stock | 25.3 | 25.34 | 25.25 | 25.265 | 4010221.0 |
| 2010-11-30 11:30:00 | MSFT | Stock | 25.265 | 25.38 | 25.25 | 25.33 | 3747261.0 |
| 2010-11-30 12:00:00 | MSFT | Stock | 25.33 | 25.34 | 25.26 | 25.27 | 3034515.0 |
| 2010-11-30 12:30:00 | MSFT | Stock | 25.27 | 25.35 | 25.26 | 25.334 | 2799226.0 |
| 2010-11-30 13:00:00 | MSFT | Stock | 25.33 | 25.4 | 25.32 | 25.35 | 2922423.0 |
| 2010-11-30 13:30:00 | MSFT | Stock | 25.355 | 25.38 | 25.35 | 25.365 | 2034065.0 |
| 2010-11-30 14:00:00 | MSFT | Stock | 25.362 | 25.39 | 25.31 | 25.338 | 4243234.0 |
| 2010-11-30 14:30:00 | MSFT | Stock | 25.34 | 25.375 | 25.3 | 25.332 | 2940434.0 |
> showing 50 of 75,817 rows — these rows as CSV