PREVIEW / stock_30min / 2006-11-09
file: by_date/stock_30min/2006/2006-11-09.parquet size: 956 KB rows: 51,659 symbols: 2,425
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-11-09 07:00:00 | AAPL | Stock | 2.9607 | 2.9621 | 2.9607 | 2.9614 | 64400.0 |
| 2006-11-09 07:30:00 | AAPL | Stock | 2.9643 | 2.9704 | 2.9571 | 2.9607 | 416808.0 |
| 2006-11-09 08:00:00 | AAPL | Stock | 2.9625 | 2.9679 | 2.9589 | 2.9589 | 1936732.0 |
| 2006-11-09 08:30:00 | AAPL | Stock | 2.9607 | 2.9643 | 2.9571 | 2.9625 | 1105160.0 |
| 2006-11-09 09:00:00 | AAPL | Stock | 2.9639 | 2.9689 | 2.9536 | 2.9625 | 2840656.0 |
| 2006-11-09 09:30:00 | AAPL | Stock | 2.9607 | 2.9707 | 2.9464 | 2.9521 | 117849816.0 |
| 2006-11-09 10:00:00 | AAPL | Stock | 2.9525 | 2.9743 | 2.9329 | 2.9707 | 94108168.0 |
| 2006-11-09 10:30:00 | AAPL | Stock | 2.9707 | 2.9989 | 2.9671 | 2.9939 | 107443588.0 |
| 2006-11-09 11:00:00 | AAPL | Stock | 2.9943 | 3.0011 | 2.985 | 2.9911 | 63819224.0 |
| 2006-11-09 11:30:00 | AAPL | Stock | 2.9911 | 2.9996 | 2.9839 | 2.9968 | 46573380.0 |
| 2006-11-09 12:00:00 | AAPL | Stock | 2.9971 | 3.01 | 2.9932 | 3.0082 | 59057040.0 |
| 2006-11-09 12:30:00 | AAPL | Stock | 3.0082 | 3.0246 | 3.0061 | 3.0239 | 62560988.0 |
| 2006-11-09 13:00:00 | AAPL | Stock | 3.0239 | 3.0239 | 2.9896 | 2.9911 | 60735976.0 |
| 2006-11-09 13:30:00 | AAPL | Stock | 2.9911 | 2.9982 | 2.9821 | 2.995 | 67149796.0 |
| 2006-11-09 14:00:00 | AAPL | Stock | 2.9954 | 3.0029 | 2.9843 | 2.9904 | 43480612.0 |
| 2006-11-09 14:30:00 | AAPL | Stock | 2.9896 | 2.9904 | 2.9664 | 2.9796 | 59621128.0 |
| 2006-11-09 15:00:00 | AAPL | Stock | 2.9796 | 2.98 | 2.9582 | 2.9704 | 55281100.0 |
| 2006-11-09 15:30:00 | AAPL | Stock | 2.9704 | 2.9775 | 2.9675 | 2.9754 | 67744208.0 |
| 2006-11-09 16:00:00 | AAPL | Stock | 2.9771 | 2.9818 | 2.9757 | 2.9764 | 1498028.0 |
| 2006-11-09 16:30:00 | AAPL | Stock | 2.9754 | 2.9786 | 2.975 | 2.9782 | 266560.0 |
| 2006-11-09 17:00:00 | AAPL | Stock | 2.9782 | 2.9782 | 2.9754 | 2.9761 | 205100.0 |
| 2006-11-09 17:30:00 | AAPL | Stock | 2.9754 | 2.9754 | 2.9711 | 2.975 | 164248.0 |
| 2006-11-09 18:00:00 | AAPL | Stock | 2.975 | 2.9754 | 2.9714 | 2.9714 | 132720.0 |
| 2006-11-09 18:30:00 | AAPL | Stock | 2.9704 | 2.9704 | 2.9664 | 2.9664 | 23800.0 |
| 2006-11-09 19:00:00 | AAPL | Stock | 2.9704 | 2.9704 | 2.97 | 2.97 | 11200.0 |
| 2006-11-09 19:30:00 | AAPL | Stock | 2.9682 | 2.9714 | 2.9682 | 2.9714 | 25060.0 |
| 2006-11-09 07:30:00 | MSFT | Stock | 29.1 | 29.1 | 29.05 | 29.05 | 2100.0 |
| 2006-11-09 08:00:00 | MSFT | Stock | 29.16 | 29.18 | 29.15 | 29.15 | 6500.0 |
| 2006-11-09 08:30:00 | MSFT | Stock | 29.13 | 29.18 | 29.08 | 29.17 | 17916.0 |
| 2006-11-09 09:00:00 | MSFT | Stock | 29.14 | 29.17 | 29.03 | 29.07 | 185540.0 |
| 2006-11-09 09:30:00 | MSFT | Stock | 29.11 | 29.29 | 29.0 | 29.23 | 10067519.0 |
| 2006-11-09 10:00:00 | MSFT | Stock | 29.23 | 29.26 | 29.1 | 29.23 | 7746003.0 |
| 2006-11-09 10:30:00 | MSFT | Stock | 29.23 | 29.25 | 29.16 | 29.25 | 5921209.0 |
| 2006-11-09 11:00:00 | MSFT | Stock | 29.25 | 29.28 | 29.17 | 29.21 | 4736895.0 |
| 2006-11-09 11:30:00 | MSFT | Stock | 29.21 | 29.26 | 29.19 | 29.24 | 4597165.0 |
| 2006-11-09 12:00:00 | MSFT | Stock | 29.24 | 29.29 | 29.2 | 29.28 | 3047847.0 |
| 2006-11-09 12:30:00 | MSFT | Stock | 29.28 | 29.38 | 29.27 | 29.38 | 8179384.0 |
| 2006-11-09 13:00:00 | MSFT | Stock | 29.38 | 29.4 | 29.22 | 29.23 | 6766823.0 |
| 2006-11-09 13:30:00 | MSFT | Stock | 29.23 | 29.35 | 29.22 | 29.25 | 4061732.0 |
| 2006-11-09 14:00:00 | MSFT | Stock | 29.251 | 29.29 | 29.21 | 29.23 | 3598085.0 |
| 2006-11-09 14:30:00 | MSFT | Stock | 29.232 | 29.25 | 29.15 | 29.18 | 5756816.0 |
| 2006-11-09 15:00:00 | MSFT | Stock | 29.17 | 29.24 | 29.15 | 29.23 | 7067732.0 |
| 2006-11-09 15:30:00 | MSFT | Stock | 29.23 | 29.29 | 29.17 | 29.26 | 9211813.0 |
| 2006-11-09 16:00:00 | MSFT | Stock | 29.26 | 29.3 | 29.24 | 29.24 | 198713.0 |
| 2006-11-09 16:30:00 | MSFT | Stock | 29.27 | 29.3 | 29.24 | 29.29 | 7200.0 |
| 2006-11-09 17:00:00 | MSFT | Stock | 29.29 | 29.29 | 29.25 | 29.25 | 4865.0 |
| 2006-11-09 17:30:00 | MSFT | Stock | 29.25 | 29.29 | 29.25 | 29.29 | 5100.0 |
| 2006-11-09 18:00:00 | MSFT | Stock | 29.26 | 29.26 | 29.26 | 29.26 | 100.0 |
| 2006-11-09 18:30:00 | MSFT | Stock | 29.26 | 29.26 | 29.26 | 29.26 | 1100.0 |
| 2006-11-09 19:00:00 | MSFT | Stock | 29.26 | 29.26 | 29.26 | 29.26 | 100.0 |
> showing 50 of 51,659 rows — these rows as CSV