PREVIEW / stock_30min / 2009-10-07
file: by_date/stock_30min/2009/2009-10-07.parquet size: 1.3 MB rows: 70,240 symbols: 3,374
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 |
|---|---|---|---|---|---|---|---|
| 2009-10-07 06:00:00 | AAPL | Stock | 6.8157 | 6.8157 | 6.8154 | 6.8154 | 19600.0 |
| 2009-10-07 06:30:00 | AAPL | Stock | 6.8071 | 6.8107 | 6.7964 | 6.7964 | 40068.0 |
| 2009-10-07 07:00:00 | AAPL | Stock | 6.7979 | 6.7982 | 6.7682 | 6.7682 | 109480.0 |
| 2009-10-07 07:30:00 | AAPL | Stock | 6.7682 | 6.7839 | 6.7679 | 6.7732 | 101640.0 |
| 2009-10-07 08:00:00 | AAPL | Stock | 6.7732 | 6.785 | 6.7614 | 6.78 | 808192.0 |
| 2009-10-07 08:30:00 | AAPL | Stock | 6.7782 | 6.78 | 6.7646 | 6.7646 | 881608.0 |
| 2009-10-07 09:00:00 | AAPL | Stock | 6.765 | 6.78 | 6.7643 | 6.7779 | 665084.0 |
| 2009-10-07 09:30:00 | AAPL | Stock | 6.7743 | 6.8054 | 6.7571 | 6.7789 | 89903380.0 |
| 2009-10-07 10:00:00 | AAPL | Stock | 6.78 | 6.7964 | 6.7643 | 6.7819 | 51219812.0 |
| 2009-10-07 10:30:00 | AAPL | Stock | 6.7821 | 6.7839 | 6.7604 | 6.7804 | 40075532.0 |
| 2009-10-07 11:00:00 | AAPL | Stock | 6.7804 | 6.7971 | 6.7689 | 6.7696 | 31143336.0 |
| 2009-10-07 11:30:00 | AAPL | Stock | 6.77 | 6.7768 | 6.7657 | 6.7675 | 21491204.0 |
| 2009-10-07 12:00:00 | AAPL | Stock | 6.7664 | 6.7811 | 6.7643 | 6.7711 | 19487944.0 |
| 2009-10-07 12:30:00 | AAPL | Stock | 6.7715 | 6.7854 | 6.7679 | 6.7825 | 17687432.0 |
| 2009-10-07 13:00:00 | AAPL | Stock | 6.7821 | 6.7829 | 6.7647 | 6.7718 | 21493192.0 |
| 2009-10-07 13:30:00 | AAPL | Stock | 6.7725 | 6.7768 | 6.7668 | 6.7757 | 20813464.0 |
| 2009-10-07 14:00:00 | AAPL | Stock | 6.7739 | 6.7764 | 6.7511 | 6.7682 | 28422436.0 |
| 2009-10-07 14:30:00 | AAPL | Stock | 6.7679 | 6.7854 | 6.7643 | 6.7814 | 29394708.0 |
| 2009-10-07 15:00:00 | AAPL | Stock | 6.7807 | 6.7907 | 6.7714 | 6.78 | 36086036.0 |
| 2009-10-07 15:30:00 | AAPL | Stock | 6.78 | 6.7954 | 6.7754 | 6.7943 | 44049908.0 |
| 2009-10-07 16:00:00 | AAPL | Stock | 6.7946 | 6.8 | 6.7774 | 6.7982 | 6130544.0 |
| 2009-10-07 16:30:00 | AAPL | Stock | 6.7946 | 6.8018 | 6.7936 | 6.8018 | 404600.0 |
| 2009-10-07 17:00:00 | AAPL | Stock | 6.8032 | 6.8143 | 6.8018 | 6.8143 | 520352.0 |
| 2009-10-07 17:30:00 | AAPL | Stock | 6.8111 | 6.8179 | 6.81 | 6.8143 | 252112.0 |
| 2009-10-07 18:00:00 | AAPL | Stock | 6.8143 | 6.8143 | 6.7929 | 6.8111 | 309540.0 |
| 2009-10-07 18:30:00 | AAPL | Stock | 6.8136 | 6.8143 | 6.8125 | 6.8143 | 22400.0 |
| 2009-10-07 19:00:00 | AAPL | Stock | 6.8143 | 6.8179 | 6.8132 | 6.8179 | 149520.0 |
| 2009-10-07 19:30:00 | AAPL | Stock | 6.8179 | 6.8304 | 6.8179 | 6.8286 | 287952.0 |
| 2009-10-07 06:00:00 | MSFT | Stock | 25.29 | 25.29 | 25.29 | 25.29 | 300.0 |
| 2009-10-07 06:30:00 | MSFT | Stock | 25.25 | 25.25 | 25.25 | 25.25 | 200.0 |
| 2009-10-07 07:30:00 | MSFT | Stock | 25.23 | 25.23 | 25.22 | 25.22 | 400.0 |
| 2009-10-07 08:00:00 | MSFT | Stock | 25.11 | 25.15 | 25.09 | 25.14 | 2000.0 |
| 2009-10-07 08:30:00 | MSFT | Stock | 25.09 | 25.1 | 25.08 | 25.1 | 5782.0 |
| 2009-10-07 09:00:00 | MSFT | Stock | 25.07 | 25.11 | 24.98 | 24.99 | 80698.0 |
| 2009-10-07 09:30:00 | MSFT | Stock | 24.99 | 25.01 | 24.88 | 24.99 | 4727358.0 |
| 2009-10-07 10:00:00 | MSFT | Stock | 25.0 | 25.18 | 24.96 | 25.164 | 2991671.0 |
| 2009-10-07 10:30:00 | MSFT | Stock | 25.16 | 25.17 | 25.04 | 25.11 | 2480471.0 |
| 2009-10-07 11:00:00 | MSFT | Stock | 25.11 | 25.17 | 25.03 | 25.04 | 1851780.0 |
| 2009-10-07 11:30:00 | MSFT | Stock | 25.04 | 25.05 | 24.89 | 24.91 | 2568323.0 |
| 2009-10-07 12:00:00 | MSFT | Stock | 24.89 | 25.05 | 24.89 | 25.049 | 2694125.0 |
| 2009-10-07 12:30:00 | MSFT | Stock | 25.04 | 25.1 | 25.0 | 25.09 | 1363869.0 |
| 2009-10-07 13:00:00 | MSFT | Stock | 25.09 | 25.1 | 25.02 | 25.06 | 995964.0 |
| 2009-10-07 13:30:00 | MSFT | Stock | 25.07 | 25.08 | 25.02 | 25.04 | 1179720.0 |
| 2009-10-07 14:00:00 | MSFT | Stock | 25.04 | 25.05 | 24.94 | 24.96 | 3486098.0 |
| 2009-10-07 14:30:00 | MSFT | Stock | 24.97 | 25.07 | 24.96 | 25.03 | 1704350.0 |
| 2009-10-07 15:00:00 | MSFT | Stock | 25.03 | 25.07 | 24.99 | 25.021 | 1984543.0 |
| 2009-10-07 15:30:00 | MSFT | Stock | 25.02 | 25.11 | 25.02 | 25.1 | 3961489.0 |
| 2009-10-07 16:00:00 | MSFT | Stock | 25.11 | 25.14 | 25.022 | 25.09 | 2902465.0 |
| 2009-10-07 16:30:00 | MSFT | Stock | 25.09 | 25.14 | 25.08 | 25.14 | 2261.0 |
| 2009-10-07 17:00:00 | MSFT | Stock | 25.14 | 25.14 | 25.14 | 25.14 | 500.0 |
> showing 50 of 70,240 rows — these rows as CSV